jsk_fellows (view)

14 rows where fellowship = "jsk-fellows2003"

View and edit SQL

Suggested facets: description, location, verified, created_at (date)

fellowship

  • jsk-fellows2003 · 14
id name description location url fellowship followers_count created_at verified screen_name
17027157 Juan Castillo Editorial Page Editor at the Austin American-Statesman. Austin, TX, USA   jsk-fellows2003 1099 2008-10-28T19:42:55+00:00 0 JuanCastilloAAS
22252782 Julie M. McCarthy National Public Radio Southeast Asia Correspondent. Currently Manila Bureau Chief. Any opinion expressed here is my own, and re-tweets are not endorsements. Southeast Asia http://www.npr.org jsk-fellows2003 4848 2009-02-28T13:03:53+00:00 1 JulieMcCarthyJM
22746299 Arieh O'Sullivan I am a correspondent and anchor at Israel Public Radio English news in Israel, registered Tour Guide, whiskey brewer and storyteller from Elah Valley     jsk-fellows2003 150 2009-03-04T07:34:23+00:00 0 ariehos
23795899 Jim Walsh Mr. Brightside Minneapolis, MN   jsk-fellows2003 3095 2009-03-11T17:33:08+00:00 0 saintfabio
24346858 J. Mariani-Belding Writer. Communicator. Marketer. Lover of good wine and cheese. Living my best life, with gratitude. California, USA   jsk-fellows2003 30 2009-03-14T08:10:36+00:00 0 jmbelding
26334203 Andrew Maykuth Philadelphia Inquirer business reporter. I cover energy and gambling. Go figure. Philadelphia, Pa. http://www.philly.com jsk-fellows2003 2634 2009-03-24T21:52:53+00:00 1 Maykuth
33870340 Jodi Upton Data journalist. Avid counter of all things. Constantly curious. Fan of dogs, gardens and cake. Syracuse, N.Y. https://newhouse.syr.edu/faculty-staff/jodi-upton jsk-fellows2003 1208 2009-04-21T10:48:03+00:00 0 jodiupton
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 4012 2009-07-27T18:02:27+00:00 1 HannahBloch
66732477 Bonnie Jo Mount       jsk-fellows2003 115 2009-08-18T16:58:07+00:00 0 bonjomo
82976044 Jon Christensen Wrangling this and that @UCLAIoES, @LENSatUCLA, @LuskinCenter, @UCLA_DH, @Stamen, @LibertyHill, @KCET 'Earth Focus,' @LARiverParks, and beyond. UCLA http://christensenlab.net jsk-fellows2003 6211 2009-10-16T21:19:49+00:00 0 the_wrangler
144361718 Mainul Khan       jsk-fellows2003 99 2010-05-16T02:44:34+00:00 0 mainulislamkhan
243693135 Armando Rivarola Periodista, jefe de redacción adjunto del diario ABC Color de Paraguay. Asunción, Paraguay   jsk-fellows2003 1083 2011-01-27T16:19:17+00:00 0 arivarola
315834402 Wanja Njuguna Mother, writer, editor, journalism/communication lecturer, human rights defende. Loves reading voraciously, mentoring, birding, environment, fun. I hate liers! The World http://wanjasnotebook.blogspot.com jsk-fellows2003 123 2011-06-12T14:35:11+00:00 0 wanjasnotebook
406632310 Alan Zarembo Editor @latimes of foreign and national stories. Former correspondent in Africa and Latin America. Los Angeles http://www.latimes.com jsk-fellows2003 1234 2011-11-06T23:59:02+00:00 0 AlanZarembo

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