jsk_fellows (view)

13 rows where fellowship = "jsk-fellows2014" 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
1246761	Cindy Royal	Professor at TX State, teaching Web design, coding & digital product concepts. ‘13-‘14 JSK Fellow at Stanford. Live in Austin, loved live music, when we had it.	Austin, TX	http://www.cindyroyal.com	https://twitter.com/CindyRoyal	jsk-fellows2014	6563	2007-03-15T20:58:07+00:00	0	CindyRoyal
13371202	john temple	Chairman and Co-founder, Amuse Labs	San Francisco, CA	https://amuselabs.com/	https://twitter.com/jtemplejrnalist	jsk-fellows2014	3168	2008-02-12T01:13:01+00:00	0	jtemplejrnalist
14130084	Shazna Nessa	Global Head of Visuals @WSJ + President, @ONA Board of Directors / Former Director, Journalism @knightfdn + @AP @CondeNast	New York, NY		https://twitter.com/shazna	jsk-fellows2014	4991	2008-03-12T04:35:38+00:00	0	shazna
14715942	Umbreen Bhatti	Director of @barnard_athena || Fmr Director of @KQED's innovation lab, @JSKStanford fellow, and lawyer. Tweets 100% mine.	NYC	https://www.linkedin.com/in/umbreenbhatti	https://twitter.com/ub14	jsk-fellows2014	1993	2008-05-09T17:44:15+00:00	0	ub14
14947379	Tran Ha	Easy problems are no fun // On a break from Twitter // Find me on IG // Frmr: @stanforddschool @jskstanford @redeyechicago	Chicago		https://twitter.com/tranosaurus	jsk-fellows2014	2472	2008-05-29T19:50:13+00:00	0	tranosaurus
17511846	carlosmartinezserna	Program Director @pressfreedom Journalism & human rights	New York, NY		https://twitter.com/cmdelaserna	jsk-fellows2014	2014	2008-11-20T14:23:06+00:00	0	cmdelaserna
27921386	alexa schirtzinger	product marketing @box | former @google @salesforce @JSKStanford @columbiajourn | usual disclaimers	San Francisco		https://twitter.com/aschirtz	jsk-fellows2014	2427	2009-03-31T17:46:59+00:00	0	aschirtz
33155287	Keli “Wears a Fashionable Mask” Dailey	teach @MillsCollege + @stmarysca, creator of #SurvivingSanFrancisco + @newshangover, alum @jskstanford + @ucbsoj, doing comedy + news	Texas-bred/San Francisco-based	http://www.kelidailey.com	https://twitter.com/kelidailey	jsk-fellows2014	4041	2009-04-19T07:19:02+00:00	0	kelidailey
75377550	Ana María Carrano	Journalist | Knight Fellow '14 at Stanford University. Founder of http://archivodevoces.com Formerly with @IAM_Vzla @IAMonuments	Miami, FL	https://www.linkedin.com/in/ana-maria-carrano/	https://twitter.com/AnaMariaCarrano	jsk-fellows2014	1797	2009-09-18T20:30:12+00:00	0	AnaMariaCarrano
104733894	Eric Ortiz	Editor @stadiumtalkcom @Granite_Media. Also @Lawatmargins Former @ESPN @NESN @JSKStanford @Truthdig. Founder @evrybit. #news #sports #journalism #storytelling	Minneapolis, MN	http://lawatthemargins.com/category/community-based-news-room-cbnr/	https://twitter.com/erictortiz	jsk-fellows2014	1055	2010-01-14T06:32:00+00:00	0	erictortiz
168580629	Tayyeb Afridi	Journalist| Radio & Online | Media Development | @JSKStanford |ICFJ 11 | RT≠Endorsement.	Peshawar, Pakistan	https://www.tnn.com.pk	https://twitter.com/tayyebafridi	jsk-fellows2014	877	2010-07-20T08:13:42+00:00	0	tayyebafridi
259414535	Camille Seaman	Polar Photographer. Storm Chaser, Explorer, mother, citizen of planet Earth	Somewhere on Planet Earth	http://www.camilleseaman.com	https://twitter.com/CamilleSeaman	jsk-fellows2014	2094	2011-03-01T21:37:18+00:00	0	CamilleSeaman
321603395	Kennedy Jawoko	I am a dad, writer, college professor, social entrep and media dev. expert, not always in that order.	Toronto, Ontario	https://www.linkedin.com/profile/preview?vpa=pub&locale=en_US	https://twitter.com/KJawoko	jsk-fellows2014	486	2011-06-21T20:54:39+00:00	0	KJawoko

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;