jsk_fellows (view)

12 rows where fellowship = "jsk-fellows2008"

Search:

- remove filter - id name description location url twitter fellowship followers_count created_at verified screen_name

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - id name description location url twitter fellowship followers_count created_at verified screen_name

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by id Sort by name Sort by description Sort by location Sort by url Sort by twitter Sort by fellowship Sort by followers_count Sort by created_at Sort by verified Sort by screen_name

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, verified, created_at (date)

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
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	https://twitter.com/dansinker	jsk-fellows2008	28430	2007-08-11T05:51:44+00:00	0	dansinker
9443532	Rick Attig	Dad, Writer and Journalist	Portland, Oregon		https://twitter.com/Rickattig	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		https://twitter.com/Ezequiel_Abiu	jsk-fellows2008	895	2007-10-16T21:38:33+00:00	0	Ezequiel_Abiu
14615604	Denis RB	lealdade, humildade e procedimento		https://epoca.globo.com/denis-r-burgierman/	https://twitter.com/denisrb	jsk-fellows2008	2940	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/	https://twitter.com/ericpape	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	https://twitter.com/NotesFromHeL	jsk-fellows2008	12072	2009-02-22T02:29:10+00:00	1	NotesFromHeL
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	https://twitter.com/stevensdudley	jsk-fellows2008	5347	2009-05-12T20:48:53+00:00	0	stevensdudley
41007644	Matthew B. Stannard				https://twitter.com/MBStannard	jsk-fellows2008	16	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	https://twitter.com/violetgonda	jsk-fellows2008	59714	2009-07-22T12:29:44+00:00	0	violetgonda
144661304	Janine Perrett	Proud journo for 40 years. Now more than ever.	Australia		https://twitter.com/PerrettReport	jsk-fellows2008	9554	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	https://twitter.com/CODaleyNews	jsk-fellows2008	2351	2011-11-28T16:05:17+00:00	1	CODaleyNews
555484188	Elizabeth Dalziel	photographer specializing in everything	London	http://www.elizabethdalziel.com	https://twitter.com/edalziel	jsk-fellows2008	435	2012-04-16T20:30:47+00:00	0	edalziel

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;