jsk_fellows (view)

20 rows where fellowship = "jsk-fellows2013"

View and edit SQL

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

fellowship

  • jsk-fellows2013 · 20
id name description location url fellowship followers_count created_at verified screen_name
7068802 Marie C Beuth deputy eic @lopinion_fr all things digital • founding editor @BIFrance • founder @getnod • 2013 fellow @jskstanford • floor rebel @ everywhere Paris, Ile-de-France https://tinyurl.com/FeedbacklOpinion jsk-fellows2013 8699 2007-06-25T13:36:18+00:00 0 M_C_B
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 272 2007-09-18T18:11:50+00:00 0 kirkcaraway
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 7219 2008-02-01T19:54:32+00:00 0 dsarno
16288136 Melissa Chan reporter, writer | sometimes @dwnews | latest in El País, SCMP, Foreign Policy. Formerly London, China/Asia, Doha, California, and more 🌎.   http://www.melissachan.com jsk-fellows2013 75536 2008-09-14T22:25:38+00:00 1 melissakchan
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 2283 2008-10-06T12:54:28+00:00 0 nunovargas
18912392 Attila Mong journalist//consultant @DW_Akademie // Europe correspondent for @pressfreedom // board member @Atlatszo // @JSKStanford Fellow//Stronger& lighter after #cancer. Berlin   jsk-fellows2013 9393 2009-01-12T19:45:35+00:00 1 attilamong
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 2409 2009-01-29T19:11:06+00:00 1 Lindenberger
20580890 xiaoming John S. Knight Fellow at Stanford. Living in Palo Alto, CA. 30.235821,120.435787   jsk-fellows2013 273 2009-02-11T09:39:39+00:00 0 lixiaoming
20951229 Mary Aviles But first, the facts. Bay Area   jsk-fellows2013 986 2009-02-16T00:45:08+00:00 0 Avilesm
22869559 Andy Donohue managing editor @reveal CALIFORNIA https://www.revealnews.org/author/andrew-d-donohue jsk-fellows2013 7520 2009-03-05T02:55:54+00:00 1 add
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 15185 2009-04-05T15:45:34+00:00 1 LatoyaPeterson
29932001 Barbara E. Allen   Stanford!   jsk-fellows2013 268 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 512 2009-06-18T01:20:51+00:00 0 drigarcia
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
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 2369 2009-08-22T17:53:27+00:00 0 Musikilu
284593852 William McNulty   Santa Cruz CA   jsk-fellows2013 468 2011-04-19T15:40:58+00:00 0 wemcn
588357987 mariam semaan #Knight #Fellow 2012/13 #Stanford #University #DesignThinking#Media expert #Designer of #Experiences #vintage clothes and accessories #collector     jsk-fellows2013 208 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 11108 2013-03-02T20:33:19+00:00 0 MLillyDelgado
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 4870 2013-06-26T19:27:15+00:00 1 Ericnpr
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 1208 2013-07-18T20:50:38+00:00 0 samsends

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 77.083ms · About: simonw/jsk-fellows-on-twitter