jsk_fellows (view)

9 rows where fellowship = "jsk-fellows-2019" 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
55300229	Ronny Rojas	Tico. Investigative reporter. @TelemundoNews @newmarkjschool @JSKstanford '19. Before @Uninoticias; @OCCRP; @nacion ronny.rojas@journalism.cuny.edu	New York, NY		https://twitter.com/ronnyrojas	jsk-fellows-2019	1752	2009-07-09T17:28:26+00:00	0	ronnyrojas
78114269	Marina Walker	Executive editor @Pulitzercenter. Mother of 2, builder of teams & @JSKStanford 2019 fellow. Always, @ICIJorg	Washington, DC	http://www.pulitzercenter.org	https://twitter.com/MarinaWalkerG	jsk-fellows-2019	9876	2009-09-28T20:31:14+00:00	0	MarinaWalkerG
117450730	Geraldine Moriba	Journalist. Filmmaker. Writer. Stanford AI Researcher. Equity Consultant. @JSKstanford. Platform Agnostic. Evolving Human.		https://soundslikehate.org/	https://twitter.com/GeraldineMoriba	jsk-fellows-2019	2178	2010-02-25T16:12:54+00:00	0	GeraldineMoriba
168183999	Peter DiCampo	Photographer. Cofounder @everydayafrica @evdayprojects. Co-author @photo_rights. 2019 @JSKstanford Fellow. Bad guitarist. Wannabe comic book writer.		https://www.everydayprojects.org/	https://twitter.com/peterdicampo	jsk-fellows-2019	4238	2010-07-18T16:49:04+00:00	0	peterdicampo
187718921	Katie Palmer	Science and health editor @qz | formerly @JSKStanford @WIRED | she/her | wannabe post-minimal cellist | kpalmer at qz dot com	Northampton, MA	http://katiempalmer.com	https://twitter.com/KatieMPalmer	jsk-fellows-2019	2979	2010-09-07T00:01:21+00:00	0	KatieMPalmer
195493353	Benjamin Petit	Photojournalist, @Dysturbofficial co-director, @JSKStanford 2019 Journalism Fellow, Fulbright Scholar. IG: bendophoto	New York City, USA	http://www.benjaminpetit.com	https://twitter.com/bendophoto	jsk-fellows-2019	621	2010-09-26T21:12:06+00:00	0	bendophoto
225293034	Damien is The Antichris Horne	Publisher of The Devil Strip | JSK Fellow @ Stanford, 2019 | NAS CCF, 2018 | Makronite 💯 | Gave up Lent for bacon. | Retweets will not be televised	Akron, Ohio	http://TheDevilStrip.com/co-op	https://twitter.com/thischrishorne	jsk-fellows-2019	2753	2010-12-11T06:33:19+00:00	0	thischrishorne
316717535	Sarah Shourd	Trauma-informed journalist. Advocate for alternatives to incarceration and restorative justice. Playwright and Director. Lover of popcorn and redwood trees.	Oakland, CA	https://pulitzercenter.org/event/box-virtual-performances	https://twitter.com/SShourd	jsk-fellows-2019	3275	2011-06-13T21:27:49+00:00	0	SShourd
4083799919	Joel Konopo	| Innovator | Investigative journalist @ink_cij 🇧🇼 | Father of three | @jskstanford Fellow 19 |	Botswana	http://www.inkjournalism.org	https://twitter.com/JKonopo	jsk-fellows-2019	2351	2015-10-31T16:47:56+00:00	0	JKonopo

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;