jsk_fellows (view)

13 rows where fellowship = "jsk-fellows-2020" 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
2241921	Pamela Chen 🙋🏻‍♀️🤦🏻‍♀️	Camera & Photos @apple, curious at heart. 2020 @JSKStanford-@StanfordHAI Fellow, board @magnumfnd, alumna @instagram @natgeo @opensociety ☁️	Stanford, CA	https://stanford.io/2O6sojp	https://twitter.com/pc	jsk-fellows-2020	13155	2007-03-26T02:40:05+00:00	0	pc
6199412	Jim Colgan	Radio/media/tech. Stanford JSK fellow. Previously Audible, WNYC, SoundCloud. California via New York via Dublin.	San Francisco		https://twitter.com/jim_colgan	jsk-fellows-2020	2045	2007-05-21T13:35:41+00:00	0	jim_colgan
17000789	Matt Kiefer	R&D for #FOIA + investigations @washingtonpost #jsk20 fellow FOIAmail creator @chicagoreporter alum @NEIU grad @headlineclub @IRE_NICAR #bikechi til I die	Chicago	http://github.com/mattkiefer	https://twitter.com/matt_kiefer	jsk-fellows-2020	1587	2008-10-27T15:51:18+00:00	0	matt_kiefer
19257632	Scarin’ Foley 🎃	Black Media Initiative director @CCMNewmarkJ | priors @jskstanford '20, @cityofdetroit storyteller | ✊🏽🏳️‍🌈 | books @belt_publishing | email 👍🏽, DMs 👎🏽	NY borough/Detroit thorough	http://www.aaronkfoley.com	https://twitter.com/aaronkfoley	jsk-fellows-2020	6808	2009-01-20T21:10:41+00:00	0	aaronkfoley
41653397	Anna Gielewska	@JSKstanford Fellow20 | Vice-chairman @FReporterow |@vsquare_project | Political and investigative journalist, focused on countering disinformation.	Warsaw, Poland		https://twitter.com/agielewska	jsk-fellows-2020	7288	2009-05-21T19:10:06+00:00	0	agielewska
106475977	Krista Almanzan	Senior Journalism Fellow @JSKStanford experimenting with audio in local news	Palo Alto, CA		https://twitter.com/KristaAlmanzan	jsk-fellows-2020	323	2010-01-19T17:48:49+00:00	0	KristaAlmanzan
240393453	Marcelle Hopkins	Executive producer of VR/AR and deputy editor of video at The New York Times. Formerly Al Jazeera.	New York, NY	http://nytimes.com	https://twitter.com/marcellehopkins	jsk-fellows-2020	4776	2011-01-19T20:43:47+00:00	0	marcellehopkins
421725730	Michael Rain	Digital Storyteller & Speaker // Founder @ENODI_ // @TEDtalks Speaker & Resident // Fellow @JSKstanford @TowKnightCenter // @Columbia alum 🇺🇸🇬🇭	Palo Alto, CA	http://www.michaelra.in	https://twitter.com/michaeljrain	jsk-fellows-2020	922	2011-11-26T09:12:00+00:00	0	michaeljrain
516794788	Bryan Pollard	associate director, @najournalists; former JSK Fellow, @jskstanford; former exec editor, @CherokeePhoenix; founder @streetroots, board member, @highcountrynews	Fayetteville, AR		https://twitter.com/cherokee_editor	jsk-fellows-2020	973	2012-03-06T19:10:04+00:00	0	cherokee_editor
520989810	Divine Dube	Local news #innovation geek. @JSKstanford Alum	California, USA	https://medium.com/@divine_dube	https://twitter.com/village_scribe	jsk-fellows-2020	1591	2012-03-11T04:04:01+00:00	0	village_scribe
776601864	Natasha Zouves	Personal account of ABC7 anchor, journalist and proud Bay Area native! Serious about french fries and USC Trojans ✌ On Instagram @natashazouves		http://www.facebook.com/NatashaZouves	https://twitter.com/NatashaZouves	jsk-fellows-2020	14961	2012-08-23T19:30:23+00:00	0	NatashaZouves
1171581110	Motunrayo Alaka	Intentional|Media+Leadership+Development| ED/CEO @WSoyinkaCentre| UNAD | UNILAG | Fellow @StanfordCDDRL and @JSKstanford| Nehemiah 4:6		http://wscij.org	https://twitter.com/D_Encourager	jsk-fellows-2020	2109	2013-02-12T10:38:05+00:00	0	D_Encourager
4250629253	Joseph Poliszuk	Periodista | Coeditor-Fundador de @ArmandoInfo | @JSKstanford Fellow		http://www.armando.info	https://twitter.com/jopoliszuk	jsk-fellows-2020	28424	2015-11-22T15:54:57+00:00	0	jopoliszuk

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;