jsk_fellows (view)

5 rows where fellowship = "jsk-fellows-2020" and verified = 1

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: created_at (date)

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
12497	Simon Willison	Creator of @datasetteproj, co-creator Django. Fellow at @JSKstanford. Collector of @nichemuseums. Usually hanging out with @natbat and @cleopaws. He/Him	San Francisco, CA	https://simonwillison.net/	https://twitter.com/simonw	jsk-fellows-2020	21461	2006-11-15T13:18:50+00:00	1	simonw
14305753	𝙟𝙤𝙨𝙚 𝙯𝙖𝙢𝙤𝙧𝙖	• Comms. @UniNoticias. // @JSKstanford Fellow. Prof. @univmiami. Former @knightfdn @el_Periodico @UFMedu Law @UniofOxford MediaLaw @UTAustin MPA. OAS Scholar.	Miami, FL	http://www.linkedin.com/in/josecarloszamora	https://twitter.com/jczamora	jsk-fellows-2020	7902	2008-04-04T20:04:23+00:00	1	jczamora
16212914	Natalia Mazotte	Journalist & consultant working w/ data, tech, media & innovation. @jskstanford ‘20. @Abraji Director. @okfnbr ex-CEO. @escoladedados & @generonumero co-founder		https://medium.com/@NataliaMazotte	https://twitter.com/NataliaMazotte	jsk-fellows-2020	6143	2008-09-09T23:02:25+00:00	1	NataliaMazotte
47854857	Alastair Leithead	Portugal-based journalist using BBC foreign correspondent skills to live off the grid, experiment with new ways of storytelling and work agains the infodemic	Odemira, SW Portugal	http://alastairleithead.com	https://twitter.com/aleithead	jsk-fellows-2020	14982	2009-06-17T04:26:19+00:00	1	aleithead
245587242	Garance Burke	Global investigative journalist @AP. 2020 @JSKStanford-@StanfordHAI Fellow. Pulitzer finalist. Your ideas welcome—DM for Signal. garanceburke@protonmail.com	San Francisco	http://www.ap.org	https://twitter.com/garanceburke	jsk-fellows-2020	5807	2011-02-01T01:16:48+00:00	1	garanceburke

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;