jsk_fellows (view)

7 rows where location = "Los Angeles, CA"

Search:

descending

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
14716014	Laura Hertzfeld	Storyteller, LA ambassador, midnight baker. Lost to Jeopardy James. Now #XR @thisisryot @yahoonews Then @Journalism_360 @EW @PBS Always @jskstanford #binders	Los Angeles, CA	http://www.newsvagabond.com/	https://twitter.com/laurahertzfeld	jsk-fellows-2019	3387	2008-05-09T17:50:31+00:00	1	laurahertzfeld
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
19339650	Gini Sikes	Standup Comic, Filmmaker, Journalist. Writer/Producer Equal Means Equal; Author 8Ball Chicks: A Year in the Violent World of Girl Gangs	Los Angeles, CA		https://twitter.com/8ballchicks	jsk-fellows2001	214	2009-01-22T14:18:01+00:00	0	8ballchicks
22455550	T O N Y A	Host of @NPR’s @Hereandnow & @TruthBeToldKQED @JSKStanford fellow @mizzou mafia. Made in Detroit. she/her. #deartbt	Los Angeles, CA		https://twitter.com/TonyaMosley	jsk-fellows2016	9402	2009-03-02T05:31:47+00:00	1	TonyaMosley
72928579	Ivan Penn	Ivan Penn is a Los Angeles-based energy correspondent for @nytimes, 2006 @JSKstanford fellow and 2014 @LoebAwards winner.	Los Angeles, CA	https://www.nytco.com/ivan-penn-joins-business-day/	https://twitter.com/ivanlpenn	jsk-fellows2006	4483	2009-09-09T19:26:27+00:00	0	ivanlpenn
190430338	Evelyn Larrubia	I lead investigations and newsrooms. Now @themarkup. Past: Exec Editor @marketplace; Managing Editor News & Investigations @KPCC; @JSKstanford; @LATimes. Cubana	Los Angeles, CA	http://themarkup.org	https://twitter.com/elarrubia	jsk-fellows2011	2139	2010-09-13T22:59:47+00:00	0	elarrubia
236583412	Gary Polakovic	Environmental pro for 30 yrs @ Coalition for Clean Air, L.A. Times, http://SEJ.org, Calif State Parks Fdtn., & Make Over Earth, Inc., consulting.	Los Angeles, CA	http://MakeOverEarth.com	https://twitter.com/MakeOverEarth	jsk-fellows1998	169	2011-01-10T22:50:16+00:00	0	MakeOverEarth

Advanced export

JSON shape: default, array, newline-delimited

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;