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 19652 2006-11-15T13:18:50+00:00 1 simonw
2241921 Pamela Chen πŸ™‹πŸ»β€β™€οΈπŸ€¦πŸ»β€β™€οΈ Fellow @stanfordHAI-@jskStanford studying the art & technology of content curation. By way of @instagram @natgeo @opensociety. Curious at heart. Stanford, CA https://www.gofundme.com/f/ppe-for-black-freelance-photographers-2020 jsk-fellows-2020 13185 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 2056 2007-05-21T13:35:41+00:00 0 jim_colgan
14305753 π™Ÿπ™€π™¨π™š 𝙯𝙖𝙒𝙀𝙧𝙖 β€’ @JSKstanford Fellow. // Comms. @UniNoticias. 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 7643 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 5653 2008-09-09T23:02:25+00:00 1 NataliaMazotte
17000789 Matt Kiefer #jsk20 fellow prototyping tools to monitor civil/human rights @JSKStanford. formerly @chicagoreporter, @headlineclub board. @NEIU alum. #bikechi til I die Chicago http://github.com/mattkiefer jsk-fellows-2020 1492 2008-10-27T15:51:18+00:00 0 matt_kiefer
19257632 Aaron Foley Dir. Black Media Initiative @newmarkjschool | @jskstanford β€˜20 | @belt_publishing author | βœŠπŸ½πŸ³οΈβ€πŸŒˆ| OG @cityofdetroit storyteller | little bylines everywhere Zoom http://www.aaronkfoley.com jsk-fellows-2020 6478 2009-01-20T21:10:41+00:00 0 aaronkfoley
41653397 Anna Gielewska @JSKstanford Fellow20 | Vice-pres. @FReporterow |@vsquare_project | Political and investigative journalist, now focused mainly on countering disinformation. Warsaw, Poland   jsk-fellows-2020 7282 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 14958 2009-06-17T04:26:19+00:00 1 aleithead
106475977 Krista Almanzan 2020 Fellow @JSKStanford, former News Director @903KAZU Public Radio Palo Alto, CA   jsk-fellows-2020 246 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 4815 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 me to chat via Signal. San Francisco http://www.ap.org jsk-fellows-2020 5541 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 John S. Knight Fellow, @jskstanford; former president, @najournalists; former executive editor, @CherokeePhoenix; board member, @highcountrynews Fayetteville, AR   jsk-fellows-2020 611 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 1432 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 15154 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 1888 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 27634 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 87.386ms · About: simonw/jsk-fellows-on-twitter