jsk_fellows (view)

18 rows where fellowship = "jsk-fellows-2020" sorted by twitter

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
1171581110 Motunrayo Alaka Intentional|Media+Leadership+Development| ED/CEO @WSoyinkaCentre| UNAD | UNILAG | Fellow @StanfordCDDRL and @JSKstanford| Nehemiah 4:6   http://wscij.org jsk-fellows-2020 2109 2013-02-12T10:38:05+00:00 0 D_Encourager
106475977 Krista Almanzan Senior Journalism Fellow @JSKStanford experimenting with audio in local news Palo Alto, CA   jsk-fellows-2020 323 2010-01-19T17:48:49+00:00 0 KristaAlmanzan
16212914 Natalia Mazotte Journalist & consultant working w/ data, tech, media & innovation. @jskstanford ‘20. @Abraji Director. @okfnbr ex-CEO. @escoladedados & @generonumero co-founder   https://medium.com/@NataliaMazotte jsk-fellows-2020 6143 2008-09-09T23:02:25+00:00 1 NataliaMazotte
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 14961 2012-08-23T19:30:23+00:00 0 NatashaZouves
19257632 Scarin’ 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 6808 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 7288 2009-05-21T19:10:06+00:00 0 agielewska
47854857 Alastair Leithead Portugal-based journalist using BBC foreign correspondent skills to live off the grid, experiment with new ways of storytelling and work agains the infodemic Odemira, SW Portugal http://alastairleithead.com jsk-fellows-2020 14982 2009-06-17T04:26:19+00:00 1 aleithead
516794788 Bryan Pollard associate director, @najournalists; former JSK Fellow, @jskstanford; former exec editor, @CherokeePhoenix; founder @streetroots, board member, @highcountrynews Fayetteville, AR   jsk-fellows-2020 973 2012-03-06T19:10:04+00:00 0 cherokee_editor
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 5807 2011-02-01T01:16:48+00:00 1 garanceburke
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 7902 2008-04-04T20:04:23+00:00 1 jczamora
6199412 Jim Colgan Radio/media/tech. Stanford JSK fellow. Previously Audible, WNYC, SoundCloud. California via New York via Dublin. San Francisco   jsk-fellows-2020 2045 2007-05-21T13:35:41+00:00 0 jim_colgan
4250629253 Joseph Poliszuk Periodista | Coeditor-Fundador de @ArmandoInfo | @JSKstanford Fellow   http://www.armando.info jsk-fellows-2020 28424 2015-11-22T15:54:57+00:00 0 jopoliszuk
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 4776 2011-01-19T20:43:47+00:00 0 marcellehopkins
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 1587 2008-10-27T15:51:18+00:00 0 matt_kiefer
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 922 2011-11-26T09:12:00+00:00 0 michaeljrain
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 13155 2007-03-26T02:40:05+00:00 0 pc
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 21461 2006-11-15T13:18:50+00:00 1 simonw
520989810 Divine Dube Local news #innovation geek. @JSKstanford Alum California, USA https://medium.com/@divine_dube jsk-fellows-2020 1591 2012-03-11T04:04:01+00:00 0 village_scribe

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