jsk_fellows (view)

9 rows where fellowship = "jsk-fellows2008" and verified = 0

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

- 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, 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
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
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;