jsk_fellows (view)

18 rows where fellowship = "jsk-fellows-2020"

View and edit SQL

Suggested facets: location, verified, created_at (date)

fellowship

  • jsk-fellows-2020 · 18
id name description location url fellowship followers_count created_at verified screen_name
12497 Simon Willison Creator of @datasetteproj, co-creator Django. Fellow at @JSKstanford. Collector of @nichemuseums. Usually hanging out with @natbat and @cleopaws. He/Him San Francisco, CA https://simonwillison.net/ jsk-fellows-2020 21211 2006-11-15T13:18:50+00:00 1 simonw
2241921 Pamela Chen πŸ™‹πŸ»β€β™€οΈπŸ€¦πŸ»β€β™€οΈ Camera & Photos @apple, curious at heart. 2020 @JSKStanford-@StanfordHAI Fellow, board @magnumfnd, alumna @instagram @natgeo @opensociety ☁️ Stanford, CA https://stanford.io/2O6sojp jsk-fellows-2020 13174 2007-03-26T02:40:05+00:00 0 pc
6199412 Jim Colgan Stanford JSK fellow. Previously Audible, WNYC, SoundCloud. Bay Area via New York via Dublin. San Francisco   jsk-fellows-2020 2049 2007-05-21T13:35:41+00:00 0 jim_colgan
14305753 π™Ÿπ™€π™¨π™š 𝙯𝙖𝙒𝙀𝙧𝙖 β€’ Comms. @UniNoticias. // @JSKstanford Fellow. Prof. @univmiami. Former @knightfdn @el_Periodico @UFMedu Law @UniofOxford MediaLaw @UTAustin MPA. OAS Scholar. Miami, FL http://www.linkedin.com/in/josecarloszamora jsk-fellows-2020 7774 2008-04-04T20:04:23+00:00 1 jczamora
16212914 Natalia Mazotte Social entrepreneur working with data, tech, media & innovation. @jskstanford β€˜20. @Abraji Director. @okfnbr ex-CEO. @escoladedados & @generonumero co-founder.   https://medium.com/@NataliaMazotte jsk-fellows-2020 6051 2008-09-09T23:02:25+00:00 1 NataliaMazotte
17000789 Matt Kiefer R&D for #FOIA + investigations @washingtonpost #jsk20 fellow FOIAmail creator @chicagoreporter alum @NEIU grad @headlineclub @IRE_NICAR #bikechi til I die Chicago http://github.com/mattkiefer jsk-fellows-2020 1558 2008-10-27T15:51:18+00:00 0 matt_kiefer
19257632 Aaron Foley Black Media Initiative director @CCMNewmarkJ | priors @jskstanford '20, @cityofdetroit storyteller | βœŠπŸ½πŸ³οΈβ€πŸŒˆ | books @belt_publishing | email πŸ‘πŸ½, DMs πŸ‘ŽπŸ½ NY borough/Detroit thorough http://www.aaronkfoley.com jsk-fellows-2020 6739 2009-01-20T21:10:41+00:00 0 aaronkfoley
41653397 Anna Gielewska @JSKstanford Fellow20 | Vice-chairman @FReporterow |@vsquare_project | Political and investigative journalist, focused on countering disinformation. Warsaw, Poland   jsk-fellows-2020 7279 2009-05-21T19:10:06+00:00 0 agielewska
47854857 Alastair Leithead BBC Africa Correspondent, checked out of California, great to be back on the continent. Ex-Asia, ex-Kabul. Tweeting and reporting across sub-Saharan Africa. Nairobi, Kenya   jsk-fellows-2020 14982 2009-06-17T04:26:19+00:00 1 aleithead
106475977 Krista Almanzan Senior Journalism Fellow @JSKStanford experimenting with audio in local news Palo Alto, CA   jsk-fellows-2020 302 2010-01-19T17:48:49+00:00 0 KristaAlmanzan
240393453 Marcelle Hopkins Executive producer of VR/AR and deputy editor of video at The New York Times. Formerly Al Jazeera. New York, NY http://nytimes.com jsk-fellows-2020 4786 2011-01-19T20:43:47+00:00 0 marcellehopkins
245587242 Garance Burke Global investigative journalist @AP. 2020 @JSKStanford-@StanfordHAI Fellow. Pulitzer finalist. Your ideas welcomeβ€”DM for Signal. garanceburke@protonmail.com San Francisco http://www.ap.org jsk-fellows-2020 5635 2011-02-01T01:16:48+00:00 1 garanceburke
421725730 Michael Rain Digital Storyteller & Speaker // Founder @ENODI_ // @TEDtalks Speaker & Resident // Fellow @JSKstanford @TowKnightCenter // @Columbia alum πŸ‡ΊπŸ‡ΈπŸ‡¬πŸ‡­ Palo Alto, CA http://www.michaelra.in jsk-fellows-2020 918 2011-11-26T09:12:00+00:00 0 michaeljrain
516794788 Bryan Pollard associate director, @najournalists; former JSK Fellow, @jskstanford; former exec editor, @CherokeePhoenix; founder @streetroots, board member, @highcountrynews Fayetteville, AR   jsk-fellows-2020 825 2012-03-06T19:10:04+00:00 0 cherokee_editor
520989810 Divine Dube Local news #innovation geek exploring local journalism experiments @JSKstanford California, USA https://medium.com/@divine_dube jsk-fellows-2020 1506 2012-03-11T04:04:01+00:00 0 village_scribe
776601864 Natasha Zouves Personal account of ABC7 anchor, journalist and proud Bay Area native! Serious about french fries and USC Trojans ✌ On Instagram @natashazouves   http://www.facebook.com/NatashaZouves jsk-fellows-2020 15003 2012-08-23T19:30:23+00:00 0 NatashaZouves
1171581110 Motunrayo Alaka Intentional|Media+Leadership+Development| ED/CEO @WSoyinkaCentre| Fellow @StanfordCDDRL and @JSKstanford| Neh 4:6   http://wscij.org jsk-fellows-2020 1999 2013-02-12T10:38:05+00:00 0 D_Encourager
4250629253 Joseph Poliszuk Periodista | Coeditor-Fundador de @ArmandoInfo | @JSKstanford Fellow   http://www.armando.info jsk-fellows-2020 28270 2015-11-22T15:54:57+00:00 0 jopoliszuk

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