jsk_fellows (view)

12 rows where fellowship = "jsk-fellows2013" and verified = 0

View and edit SQL

Suggested facets: description, location, created_at (date)

fellowship

  • jsk-fellows2013 · 12
id name description location url fellowship followers_count created_at verified screen_name
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
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
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
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
20951229 Mary Aviles But first, the facts. Bay Area   jsk-fellows2013 982 2009-02-16T00:45:08+00:00 0 Avilesm
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
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
284593852 William McNulty   Santa Cruz CA   jsk-fellows2013 469 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 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
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

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