jsk_fellows (view)

7 rows where fellowship = "jsk-fellows-2019" and verified = 1

View and edit SQL

Suggested facets: created_at (date)

fellowship

  • jsk-fellows-2019 · 7
id name description location url fellowship followers_count created_at verified screen_name
6423572 Tom Van de Weghe #AI strategist @VRT & #deepfakes expert | Research Fellow @Stanford | Investigative journalist | former Correspondent & Bureau Chief 🇺🇸&🇨🇳 | Author+Speaker Stanford, CA https://www.linkedin.com/in/tomvandeweghe jsk-fellows-2019 26058 2007-05-29T20:01:06+00:00 1 tomvandeweghe
11688592 Mandy Jenkins GM for @CompassLocal, @McClatchy. Publisher @MahoningMatters & @LongmontLeader. @JSKStanford '19, Midwesterner, Cat Lady & @ONA board member. She/Her BK/OH/CO http://mandyjenkins.com jsk-fellows-2019 11493 2007-12-31T14:09:33+00:00 1 mjenkins
14636665 Flor Coelho La del #emojidelmate 🧉 (& Co.) / Proud @JSKStanford @LNdata & @LNnaturaleza. @ONA #HHBA #neverstoplearning Buenos Aires, Argentina   jsk-fellows-2019 11793 2008-05-03T10:16:42+00:00 1 fcoel
14716014 Laura Hertzfeld Storyteller, LA ambassador, midnight baker. Lost to Jeopardy James. Now #XR @thisisryot @yahoonews Then @Journalism_360 @EW @PBS Always @jskstanford #binders Los Angeles, CA http://www.newsvagabond.com/ jsk-fellows-2019 3387 2008-05-09T17:50:31+00:00 1 laurahertzfeld
16141134 hrv Journalist with @boomlive_in | Focusing on a 'vaccine' against 'fake news', half-truths, propaganda, lies via media literacy #MediaBuddhi | @jskstanford alum Stanford, Delhi, NYC, Oxford http://mediabuddhi.substack.com/ jsk-fellows-2019 3938 2008-09-05T06:14:38+00:00 1 hrvenkatesh
16390952 Akilah Johnson Now: @propublica DC. Then: @JSKstanford @BostonGlobe @SunSentinel. Always: Telling untold stories. Retweets not endorsements. she/her 💙🐩💛 Washington, DC https://www.propublica.org/people/akilah-johnson jsk-fellows-2019 7696 2008-09-21T14:10:09+00:00 1 akjohnson1922
293673969 Cécile Prieur Directrice adjointe de la rédaction @lemondefr / Deputy Editor / Proud @JSKStanford Journalism Fellow 2019 and @ICIJorg member Paris, France http://www.lemonde.fr jsk-fellows-2019 14291 2011-05-05T19:29:32+00:00 1 cecileprieur

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