jsk_fellows (view)

12 rows where location = "Washington, DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: verified, created_at (date)

location ✖

  • Washington, DC · 12 ✖
id name description location url fellowship followers_count created_at verified screen_name
5202671 Martyn Williams North Korea-focused journalist/researcher @NorthKoreaTech @38NorthNK. Non-resident fellow @stimsoncenter. Author @committeeHRNK. Also KJ6SDF. Washington, DC http://www.northkoreatech.org jsk-fellows2012 24339 2007-04-19T08:11:12+00:00 1 martyn_williams
14282158 Chris Allbritton Former journalist with @Time, @Reuters, and others. Knight '09, writer/editor. Washington, DC http://www.christopherallbritton.com jsk-fellows2009 2842 2008-04-02T10:54:43+00:00 0 chrisallbritton
14381600 Tracie Powell Connector. Change maker. Founder. Passionate about all things digital & media. Program Officer, Borealis Philanthropy & 2016 JSK Fellow. RT ≠ endorsement Washington, DC http://www.alldigitocracy.org jsk-fellows2016 3059 2008-04-14T05:29:35+00:00 0 TMPowell
14769899 TimJohnson Former cybersecurity reporter at @McClatchyDC, frmr correspondent in Mexico, China. Part of 2017 Pulitzer Prize-winning team on Panama Papers Washington, DC http://www.mcclatchydc.com jsk-fellows2001 5240 2008-05-14T06:13:22+00:00 1 TimJohnson4
14849874 Matt Crenson Opinions are my own. Facts belong to no one. Washington, DC   jsk-fellows2004 189 2008-05-20T23:21:58+00:00 0 mmcrenson
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
21404432 Eric Weiner NYT bestselling author. Wanderer. @NPR alum. My new book, THE SOCRATES EXPRESS, is out now! Washington, DC http://www.ericweinerbooks.com jsk-fellows2004 6707 2009-02-20T15:21:40+00:00 1 Eric_Weiner
22167981 Craig Timberg Longtime WashPost reporter, editor and author now covering technology Washington, DC https://www.washingtonpost.com/people/craig-timberg/?utm_term=.62c2bd0c02da jsk-fellows2016 4923 2009-02-27T18:02:48+00:00 0 craigtimberg
36388506 Bob Drogin Washington Deputy Bureau Chief for Los Angeles Times / author of Curveball Washington, DC   jsk-fellows1998 663 2009-04-29T15:43:56+00:00 0 BobDrogin
60664050 Hannah Bloch @NPR lead international digital editor. Former WSJ Work in Progress columnist; TIME Pakistan & Afghanistan correspondent; National Geographic writer. Xenophile. Washington, DC   jsk-fellows2003 4034 2009-07-27T18:02:27+00:00 1 HannahBloch
78114269 Marina Walker Executive editor @Pulitzercenter. Mother of 2, builder of teams & @JSKStanford 2019 fellow. Always, @ICIJorg Washington, DC http://www.pulitzercenter.org jsk-fellows-2019 9876 2009-09-28T20:31:14+00:00 0 MarinaWalkerG
96366316 Shannon Brownlee SVP Lown Institute, author of Overtreated, member of @RightCareNow, advocate for radically transforming our unjust, wasteful healthcare system, and potter. Washington, DC http://www.lowninstitute.org jsk-fellows1993 5393 2009-12-12T15:55:30+00:00 0 ShannonBrownlee

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