jsk_fellows (view)

9 rows where fellowship = "jsk-fellows1996"

View and edit SQL

Suggested facets: verified, created_at (date)

fellowship

  • jsk-fellows1996 · 9
id name description location url fellowship followers_count created_at verified screen_name
15587316 JocelynNoveckAP Associated Press national culture and feature writer NYC   jsk-fellows1996 834 2008-07-24T19:25:41+00:00 0 JocelynNoveckAP
17270262 Tom Hamburger Reporter for The Washington Post covering the intersection of money and politics. tom.hamburger@washpost.com Washington, D.C. http://www.washingtonpost.com/tom-hamburger/2012/03/05/gIQABXKfTS_page.html jsk-fellows1996 31228 2008-11-09T16:20:46+00:00 0 thamburger
18734088 Marcia Stepanek Journalist, author, speaker, Columbia faculty, focused on how digital voices/crowds interact with traditional power http://about.me/marciastepanek New York City http://marciastepanek.com jsk-fellows1996 5249 2009-01-07T19:28:12+00:00 0 CauseGlobal
27981533 Elaine Ray Journalist, writer, family historian, Stanford, CA http://www.ebenezerray.com jsk-fellows1996 138 2009-03-31T22:31:19+00:00 0 theparagrapher
55363786 Jerry Capeci Expert on the American Mafia and organized crime. Award-winning journalist. Gang Land News columnist. Contact Jerry at column02@ganglandnews.com New York http://ganglandnews.com jsk-fellows1996 1564 2009-07-09T21:11:39+00:00 0 ganglandnews
347983499 Cheryl Devall Independent wordslinger, editor, story consultant. Veteran of @Reveal, @The_Daily_World, @KPCC, @Marketplace and @NPR (based in Chicago & Miami). She/her/y’all Oakland-adjacent, CA http://cheryldevall.com jsk-fellows1996 832 2011-08-03T17:50:27+00:00 0 0212crd
463481376 Sally Lehrman Award-winning science journalist and educator who specializes in identity, race relations and gender. Markkula Center for Applied Ethics Senior Fellow. SF Bay Area http://www.bestwrit.com jsk-fellows1996 570 2012-01-14T04:37:35+00:00 0 bestwrit
1169981785 Mike Stanton UConn journalism professor. Boston Globe Spotlight Fellow. Bestselling author, The Prince of Providence & Unbeaten. Pulitzer. @NewhouseSU & @MedillSchool alum. Rhode Island & Connecticut   jsk-fellows1996 4052 2013-02-11T20:38:09+00:00 0 projomike
2373280040 堀江広美 米通信社Bloomberg News東京支局記者・編集者/企業・金融チームDeputy TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解   https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie jsk-fellows1996 1609 2014-03-05T06:33:39+00:00 1 HiromiSHorie

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