jsk_fellows (view)

108 rows where verified = 1 sorted by twitter

Search:

descending

id	name	description	location	url	twitter ▼	fellowship	followers_count	created_at	verified	screen_name
105381785	Susanne Rust	Investigative Reporter @latimes	California, USA	http://www.latimes.com/la-bio-susanne-rust-staff.html	https://twitter.com/susrust	jsk-fellows2010	2012	2010-01-16T05:17:40+00:00	1	susrust
17684905	John Boudreau	Vietnam bureau chief, Bloomberg News; formerly @mercnews Retweet ≠ endorsement.	Hanoi, Vietnam	http://www.bloomberg.com	https://twitter.com/svwriter	jsk-fellows1998	1776	2008-11-27T18:31:36+00:00	1	svwriter
6423572	Tom Van de Weghe	#AI strategist @VRT & #deepfakes expert \| Research Fellow @Stanford \| Investigative journalist \| former Correspondent & Bureau Chief 🇺🇸&🇨🇳 \| Author+Speaker	Stanford, CA	https://www.linkedin.com/in/tomvandeweghe	https://twitter.com/tomvandeweghe	jsk-fellows-2019	26058	2007-05-29T20:01:06+00:00	1	tomvandeweghe
264340567	T. Christian Miller	Senior investigative reporter @Propublica. Co-author of http://afalsereport.com. Into journalism that counts. And bacon. Pulitzer winner.	Berkeley, CA	http://www.propublica.org	https://twitter.com/txtianmiller	jsk-fellows2012	8847	2011-03-11T19:00:34+00:00	1	txtianmiller
275541233	Veronica Chambers	Editor, Narrative Projects @nytimes, author, Shirley Chisholm Is a Verb, 32 Yolks w/ @ericripert, @JSKStanford alum. I'm not a player but I create a lot.	New York	http://veronicachambers.com	https://twitter.com/vvchambers	jsk-fellows2017	7840	2011-04-01T13:51:48+00:00	1	vvchambers
16672162	Veronica Flores-Paniagua	External Affairs Advisor @Chevron, ex-journo, #energy & #education policy junkie; @UHouston-ex; #runner; 2000 @JSKStanford fellow. RT ≠ endorsement	iPhone: 29.463654,-98.473572	http://www.chevron.com	https://twitter.com/vxflores	jsk-fellows2000	3951	2008-10-09T19:37:34+00:00	1	vxflores
63027773	Wilson Lievano	Senior Digital Editor @GroundTruth. News animator. Knight Fellow. Explaining the world one keyframe at a time.	Boston, MA	http://www.animatedpress.com	https://twitter.com/wlievano	jsk-fellows2013	514	2009-08-05T04:08:38+00:00	1	wlievano
14699813	Zena Barakat	Design director @ideo	San Francisco, CA		https://twitter.com/zena_b	jsk-fellows2015	2996	2008-05-08T12:55:09+00:00	1	zena_b

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;