jsk_fellows (view)

12 rows where fellowship = "jsk-fellows2008"

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
8119452 💀 damned sinker 💀 I do 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 27199 2007-08-11T05:51:44+00:00 0 dansinker
9443532 Rick Attig Dad, Writer and Journalist Portland, Oregon   jsk-fellows2008 182 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 878 2007-10-16T21:38:33+00:00 0 Ezequiel_Abiu
14615604 denis russo lealdade, humildade e procedimento   http://veja.abril.com.br/blog/denis-russo/ jsk-fellows2008 2819 2008-05-01T15:46:23+00:00 0 denisrb
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 1373 2008-11-27T02:30:32+00:00 1 ericpape
21538116 Helen Ubiñas No one is voiceless. I choose to amplify the voices people in power and position choose to ignore. Philadelphia, PA http://www.philly.com/philly/columnists/helen_ubinas jsk-fellows2008 11351 2009-02-22T02:29:10+00:00 1 NotesFromHeL
39592148 steven dudley Is the co-director of InSight Crime and a longtime crime and public security reporter. Re-tweets not necessarily an endorsement.   http://www.stevendudley.com jsk-fellows2008 4754 2009-05-12T20:48:53+00:00 0 stevensdudley
41007644 Matthew B. Stannard       jsk-fellows2008 15 2009-05-19T00:11:54+00:00 0 MBStannard
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 52586 2009-07-22T12:29:44+00:00 0 violetgonda
144661304 Janine Perrett Proud journo for 40 years. Now more than ever. Australia   jsk-fellows2008 9174 2010-05-16T23:58:51+00:00 0 PerrettReport
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 2299 2011-11-28T16:05:17+00:00 1 CODaleyNews
555484188 Elizabeth Dalziel photographer specializing in everything London http://www.elizabethdalziel.com jsk-fellows2008 419 2012-04-16T20:30:47+00:00 0 edalziel

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