jsk_fellows (view)

12 rows where fellowship = "jsk-fellows2008" sorted by location

View and edit SQL

Suggested facets: location, verified, created_at (date)

fellowship

  • jsk-fellows2008 · 12
id name description location ▼ url fellowship followers_count created_at verified screen_name
14615604 Denis RB lealdade, humildade e procedimento   https://epoca.globo.com/denis-r-burgierman/ jsk-fellows2008 2940 2008-05-01T15:46:23+00:00 0 denisrb
39592148 steven dudley Co-director of InSight Crime, longtime crime & public security reporter; author of MS-13: The Making of America's Most Notorious Gang (HarperCollins, 2020).   http://www.stevendudley.com jsk-fellows2008 5347 2009-05-12T20:48:53+00:00 0 stevensdudley
41007644 Matthew B. Stannard       jsk-fellows2008 16 2009-05-19T00:11:54+00:00 0 MBStannard
144661304 Janine Perrett Proud journo for 40 years. Now more than ever. Australia   jsk-fellows2008 9554 2010-05-16T23:58:51+00:00 0 PerrettReport
8119452 💀 damned sinker 💀 I did http://impeachment.fyi. Co-host of @sayswhopodcast, formerly @opennews, author of @MayorEmanuel, founder of Punk Planet (RIP), #1 Candle King of Kickstarter Chicago, IL http://dansinker.com jsk-fellows2008 28430 2007-08-11T05:51:44+00:00 0 dansinker
555484188 Elizabeth Dalziel photographer specializing in everything London http://www.elizabethdalziel.com jsk-fellows2008 435 2012-04-16T20:30:47+00:00 0 edalziel
17667060 Eric Pape Writer, editor, immersive storyteller. Ex-correspondent: @Newsweek, @Spin, @CivilBeat. Ex-contributor: @LATimes, @ForeignPolicy, @DailyBeast. Bylines: @NYT... Los Angeles, CA https://ericpape.journoportfolio.com/ jsk-fellows2008 1433 2008-11-27T02:30:32+00:00 1 ericpape
21538116 Helen Ubiñas Columnist. Welcome to my newsletter. Fact: There aren’t enough journalists of color in your local newsroom. Fact: No one is voiceless. Fact: This mic is mine. Philadelphia, PA http://www.philly.com/philly/columnists/helen_ubinas jsk-fellows2008 12072 2009-02-22T02:29:10+00:00 1 NotesFromHeL
9443532 Rick Attig Dad, Writer and Journalist Portland, Oregon   jsk-fellows2008 181 2007-10-14T21:35:46+00:00 0 Rickattig
9486682 Ezequiel Abiú López Personal tweets by Ezequiel Abiú López. Executive Producer at Noticias SIN @SIN24Horas http://www.noticiassin.com and Foreign correspondent in the Dominican Republic. Santo Domingo   jsk-fellows2008 895 2007-10-16T21:38:33+00:00 0 Ezequiel_Abiu
59112161 Violet Gonda Journalist/Hot Seat interviews/ 1stTV/Moderator of Debates/ Zim/ UK/ President: International Association of Women in Radio and TV - IAWRT/ Serena 💕 Nadal UK/Zimbabwe http://www.violetgonda.com jsk-fellows2008 59714 2009-07-22T12:29:44+00:00 0 violetgonda
423511427 John Daley Multi-media journalist, covering health news for Colorado Public Radio, aka CPRNews A link or retweet does not = endorsement. USA http://cpr.org jsk-fellows2008 2351 2011-11-28T16:05:17+00:00 1 CODaleyNews

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