jsk_fellows (view)

19 rows where fellowship = "jsk-fellows2013" sorted by location

View and edit SQL

Suggested facets: description, location, verified, created_at (date)

fellowship

  • jsk-fellows2013 · 19
id name description location ▼ url fellowship followers_count created_at verified screen_name
16288136 Melissa Chan reporter, writer | sometimes @dwnews | latest on VICE News Tonight, Foreign Policy, @GlobalRepCentre. Formerly London, China/Asia, Doha, California, more 🌎.   http://www.melissachan.com jsk-fellows2013 75679 2008-09-14T22:25:38+00:00 1 melissakchan
588357987 mariam semaan #Knight #Fellow 2012/13 #Stanford #University #DesignThinking#Media expert #Designer of #Experiences #vintage clothes and accessories #collector     jsk-fellows2013 207 2012-05-23T13:11:28+00:00 0 semaanmariam
1236306422 María Lilly Delgado Periodista.-Journalist. Stanford Knight Fellow 2013. Periodista-Freelance TV News Reporter and Producer @ Nicaragua. Tweets are on my own.   https://www.univision.com/temas/nicaragua jsk-fellows2013 11163 2013-03-02T20:33:19+00:00 0 MLillyDelgado
67942338 Musikilu Mojeed Editor-in-Chief/Chief Operating Officer -- @premiumtimesng; Co-Founder -- @ptcij; founder - @TheImoleProject; founder, @naijapolizwatch; member, @ICIJorg Abuja http://www.premiumtimesng.com jsk-fellows2013 2375 2009-08-22T17:53:27+00:00 0 Musikilu
20951229 Mary Aviles But first, the facts. Bay Area   jsk-fellows2013 982 2009-02-16T00:45:08+00:00 0 Avilesm
18912392 Attila Mong journalist//consultant @DW_Akademie // Europe correspondent for @pressfreedom // board member @Atlatszo // @JSKStanford Fellow//Stronger& lighter after #cancer. Berlin   jsk-fellows2013 9395 2009-01-12T19:45:35+00:00 1 attilamong
63027773 Wilson Lievano Senior Digital Editor @GroundTruth. News animator. Knight Fellow. Explaining the world one keyframe at a time. Boston, MA http://www.animatedpress.com jsk-fellows2013 514 2009-08-05T04:08:38+00:00 1 wlievano
22869559 Andy DonoBOO! 👻 managing editor @reveal CALIFORNIA https://www.revealnews.org/author/andrew-d-donohue jsk-fellows2013 7988 2009-03-05T02:55:54+00:00 1 add
19727405 Michael Lindenberger Deputy Opinion Editor at Houston Chronicle | Ex: DC correspondent & edit board @dallasnews | ‘13 @jskstanford | @LouisvilleLaw grad | @Time @TNR Dallas, TX http://about.me/lindenberger jsk-fellows2013 2410 2009-01-29T19:11:06+00:00 1 Lindenberger
16613227 nunovargas Media, Product, Digital Strategy, Design Thinking & Tech. Ever in love with futebol, food and my family. Knight Fellow @Stanford'13 & invented @getdatastory Latin America + Porto,Portugal http://www.linkedin.com/in/vargasnuno/ jsk-fellows2013 2277 2008-10-06T12:54:28+00:00 0 nunovargas
12956682 David Sarno Founder of Lighthaus (@lighthausinc): Virtual reality science education. Stanford Knight Fellow '13. @latimes tech & business writer 2006-2013 Long Beach, CA http://lighthaus.us jsk-fellows2013 7208 2008-02-01T19:54:32+00:00 0 dsarno
7068802 Marie C Beuth deputy editor-in-chief @lopinion_fr • founding editor @businessinsider France • founder @getnod • 2013 fellow @jskstanford • floor rebel Paris, Ile-de-France https://tinyurl.com/FeedbacklOpinion jsk-fellows2013 8697 2007-06-25T13:36:18+00:00 0 M_C_B
29006114 Latoya Peterson Cyborg // Goddess // Storyteller //Technologist. Cofounder/CXO ✨@GlowUpGames✨Making: @InsecureGame Always: @Racialicious. @Techstars '20. Chillin on Clubhouse Quarantined http://glowup.games/ jsk-fellows2013 15237 2009-04-05T15:45:34+00:00 1 LatoyaPeterson
1604288388 Samaruddin Stewart Countering Disinformation @StateDept | Priors: @Journalism_360 & @ONA, Media + Tech @spj_tweets with @GoogleNewsInit, @knightfdn Grantee, @JSKStanford Fellow.. SF Bay Area http://www.linkedin.com/in/samaruddin/ jsk-fellows2013 1222 2013-07-18T20:50:38+00:00 0 samsends
1548898596 Eric Westervelt @NPR journalist. Recovering foreign correspondent. Occasional host. Musician by moonlight http://SecureDrop.npr.org/ http://SeeDisclaimer.com San Francisco, CA https://www.npr.org/people/2101350/eric-westervelt jsk-fellows2013 4897 2013-06-26T19:27:15+00:00 1 Ericnpr
284593852 William McNulty   Santa Cruz CA   jsk-fellows2013 469 2011-04-19T15:40:58+00:00 0 wemcn
29932001 Barbara E. Allen   Stanford!   jsk-fellows2013 269 2009-04-09T05:47:18+00:00 0 BA1245
48193439 drigarcia Journalism, Creativity, Innovation. Teaching Fellow at Google News Initiative. Co-founder of Orbital Midia. @jskstanford 12'/13' São Paulo, Brasil http://about.me/adrianagarciamartinez jsk-fellows2013 511 2009-06-18T01:20:51+00:00 0 drigarcia
8956962 Kirk Caraway Co-founder Megafone/NowAds, 2012-13 John S. Knight Fellow at Stanford University, online news entrepreneur http://GetMegafone.biz http://NowAds.biz jsk-fellows2013 270 2007-09-18T18:11:50+00:00 0 kirkcaraway

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW jsk_fellows AS 
    select
        users.id,
        users.name,
        users.description,
        users.location,
        users.url,
        'https://twitter.com/' || users.screen_name as twitter,
        group_concat(lists.slug) as fellowship,
        users.followers_count,
        users.created_at,
        users.verified,
        users.screen_name
    from users
        join list_members
            on list_members.user = users.id
        join lists
            on list_members.list = lists.id
    where
        lists.slug like 'jsk-fellows%'
        and lists.slug not like '%projects'
    group by users.id;
Powered by Datasette · Query took 79.894ms · About: simonw/jsk-fellows-on-twitter