jsk_fellows (view)

13 rows where fellowship = "jsk-fellows2012" 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: created_at (date)

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
16350120	Claudia Nunez	Editor at @latimesespanol and @hrw_espanol Founder of @Migrahack immigration stories with data+tech. Love maps and lose sleep. Knight fellow ’12 @JSKstanford	Los Angeles,CA		https://twitter.com/nunezcla	jsk-fellows2012	1428	2008-09-18T17:55:37+00:00	0	nunezcla
17272464	aaronhuey	Aaron Huey is a National Geographic photographer, a Stanford http://d.School Global Ambassador, and the father of Hawkeye and Juno.	Seattle	http://www.aaronhuey.com	https://twitter.com/aaronhuey	jsk-fellows2012	3683	2008-11-09T19:11:32+00:00	0	aaronhuey
46518958	Chloe Veltman	Arts & Culture Reporter at @KQED	San Francisco, CA	http://www.chloeveltman.com	https://twitter.com/chloeveltman	jsk-fellows2012	2187	2009-06-11T23:14:41+00:00	0	chloeveltman
48068105	Beth Daley	Editor and General Manager @ConversationUS. Proud alum of @InsideClimate, @NECIRBU, @BostonGlobe, @JSKStanford.	Boston, MA	https://theconversation.com/us	https://twitter.com/BethBDaley	jsk-fellows2012	3327	2009-06-17T18:49:40+00:00	0	BethBDaley
86152476	Masood Farivar	I cover the Justice Department and the FBI for Voice of America. @capitals and @dcunited fan.	Washington, D.C.	http://www.voanews.com/	https://twitter.com/masoodfarivar	jsk-fellows2012	6809	2009-10-29T20:18:15+00:00	0	masoodfarivar
108360053	Judith Torrea	Independent reporter & blogger covering drug trafficking, femicides and immigration issues in my lovely Juaritos. Author of Juárez en la sombra (Aguilar)	Ciudad Juárez	http://juarezenlasombra.blogspot.com/	https://twitter.com/Judithtorrea	jsk-fellows2012	7134	2010-01-25T18:04:19+00:00	0	Judithtorrea
141222005	Teresa Bouza	Innovation, Media, Tech || Knight Fellow '12 @Stanford || Columbia J-School '04 || 2012 IWMF grantee || Co-author of "A Sense of Something Greater" (Sept. 2018)	Silicon Valley	http://goo.gl/UCfsJc	https://twitter.com/TereBouza	jsk-fellows2012	1026	2010-05-07T13:49:50+00:00	0	TereBouza
148420961	Justin Ferrell	Organization design, self-efficacy & human-centered strategy. Work @stanforddschool Board @amplifierart Prev: design director @washingtonpost Alum @medillschool	Stanford, CA	http://linkedin.com/in/juferrell	https://twitter.com/Jferrell03	jsk-fellows2012	3882	2010-05-26T17:10:46+00:00	0	Jferrell03
186997686	DjurdjaPadejski	Communications at @StanfordPACS/@DigCivSoc, ex @StanfordCDDRL. Bilingual tweets, my own, not my org’s.	Palo Alto, CA		https://twitter.com/DjurdjaPadejski	jsk-fellows2012	1331	2010-09-05T00:14:13+00:00	0	DjurdjaPadejski
200120015	Katy Newton	UX Researcher + Developer, Emergent Media, Stanford http://d.school Media Experiments Resident, IDEONY, @JSKStanford Fellow @latimes	Brooklyn, San Francisco	http://katynewton.com	https://twitter.com/katywnewton	jsk-fellows2012	793	2010-10-08T14:02:56+00:00	0	katywnewton
254874238	Jorge R. Imbaquingo	Periodista. Knight Fellow, Stanford University 2012. Editor de Política de @ElComerciocom. Mediaciones interactivas.	Quito-Ecuador	http://goo.gl/OBmUo1	https://twitter.com/jimbaquingo	jsk-fellows2012	3088	2011-02-20T05:28:42+00:00	0	jimbaquingo
386183180	Girma T Fantaye				https://twitter.com/Girmatf	jsk-fellows2012	1229	2011-10-06T20:15:31+00:00	0	Girmatf
908496738	Deepa Fernandes	Journalist, global & local, @kcrw @TheWorld. Fellow at Pacific Oaks College. I report about women, kids, migrants, the environment. Alum @jskstanford @IWMF.	California, USA	http://deepafernandes.com/	https://twitter.com/deepafern	jsk-fellows2012	3062	2012-10-27T16:58:11+00:00	0	deepafern

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;