jsk_fellows (view)

13 rows where location = "New York, NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: verified, created_at (date)

location ✖

  • New York, NY · 13 ✖
id name description location url fellowship followers_count created_at verified screen_name
8441632 Burt Herman Entrepreneurial journalist finding meaning in the noise. Now: Product @CondeNast. Always: @HacksHackers. Previous: @LenfestInst, Co-founder @Storify, @AP New York, NY http://burtherman.com jsk-fellows2009 9235 2007-08-26T14:23:45+00:00 1 burtherman
14130084 Shazna Nessa Global Head of Visuals @WSJ + President, @ONA Board of Directors / Former Director, Journalism @knightfdn + @AP @CondeNast New York, NY   jsk-fellows2014 4991 2008-03-12T04:35:38+00:00 0 shazna
15315979 Carolina Guerrero CEO of @NPR's @RadioAmbulante + @elhilopodcast. Breaking the language barrier with @LupaApp. @JSKStanford Fellow. Personal Assistant to León & Eliseo. New York, NY http://radioambulante.org jsk-fellows2015 15419 2008-07-04T07:42:02+00:00 0 nuncaduermo
16248718 LisaHsia EVP Digital media at @bravotv @oxygen @universalkids New York, NY http://www.bravotv.com jsk-fellows1993 1374 2008-09-11T22:17:50+00:00 0 LisaHsia
16911536 Amy Virshup Travel editor of @nytimes. @nytimestravel I've traded Metro for the world. Follow me! New York, NY https://www.nytimes.com/section/travel jsk-fellows1995 9207 2008-10-22T19:41:36+00:00 1 amyvirshup
17511846 carlosmartinezserna Program Director @pressfreedom Journalism & human rights New York, NY   jsk-fellows2014 2014 2008-11-20T14:23:06+00:00 0 cmdelaserna
20253808 Andrea Bernstein Co-host Trump, Inc. podcast from @WNYC & @ProPublica; NYT best-selling author: AMERICAN OLIGARCHS: The Kushners, The Trumps, and the Marriage of Money and Power New York, NY http://AndreaBernsteinBook.com jsk-fellows2007 28333 2009-02-06T17:29:43+00:00 1 AndreaWNYC
28113052 Beth Fouhy Senior editor, politics, NBC News and MSNBC New York, NY http://www.msnbc.com jsk-fellows2002 14638 2009-04-01T14:15:21+00:00 1 bfouhy
34827824 Justine Gubar Docs, News, Investigations. Author of Fanaticus. National Academy of Television Arts & Sciences. Wes grad. Former Knight Fellow. Back in NYC. New York, NY http://www.Fanaticusthebook.com jsk-fellows2007 1224 2009-04-24T03:08:16+00:00 1 justinegub
36063042 Di Pinheiro Journalist, 2011 Fellow @JSKStanford. Former Editor @WSJAmericas and @WSJPortugues; goes from flower girl to street fighter, batman style, whenever required. New York, NY http://wsj.com/brazil jsk-fellows2011 486 2009-04-28T13:24:41+00:00 0 dipinheiro
55300229 Ronny Rojas Tico. Investigative reporter. @TelemundoNews @newmarkjschool @JSKstanford '19. Before @Uninoticias; @OCCRP; @nacion ronny.rojas@journalism.cuny.edu New York, NY   jsk-fellows-2019 1752 2009-07-09T17:28:26+00:00 0 ronnyrojas
115359136 Andrew Losowsky   New York, NY   jsk-fellows2014 8023 2010-02-18T12:03:16+00:00 1 losowsky
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

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