jsk_fellows (view)

13 rows where fellowship = "jsk-fellows2011" 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
7809252	wendy norris	Asst Prof @NazarethCollege exploring socially intelligent computing in humanitarian crisis response | @JSKStanford + @cuinfoscience alum | @PeaceCorps Vanuatu	Rochester, NY	http://wendynorris.com	https://twitter.com/WendyNorris	jsk-fellows2011	3121	2007-07-30T03:13:25+00:00	0	WendyNorris
14590178	Michael V. Marcotte	Rethinking news, entrepreneurship and Flintstone houses. UNM Professor of Practice. Started @NMNewsPort and @NVMediaAlliance. MVM Consulting for #pubmedia.	Albuquerque, NM	http://mikemarcotte.com	https://twitter.com/michvinmar	jsk-fellows2011	1176	2008-04-29T20:21:00+00:00	0	michvinmar
17033026	Gabriela Mafort	Branded Content and Video Branding Consultant.	Rio de Janeiro, Brazil	http://about.me/gmafort	https://twitter.com/gmafort	jsk-fellows2011	453	2008-10-29T01:22:33+00:00	0	gmafort
17701416	Beth Duff-Brown	Stanford staff writer; views here my own. Past: AP foreign correspondent, @JSKStanford fellow, Peace Corps. Writing book about one remarkable village in Congo.	Stanford, CA	http://www.bethduffbrown.com	https://twitter.com/bethduffbrown	jsk-fellows2011	1441	2008-11-28T06:35:16+00:00	0	bethduffbrown
18139193	Adriano Farano	I've built a company, a pizza oven and a family. Not necessarily in that order. Now Pane Vivo. Ex @Plex @Watchup @StartX @jskstanford @cafebabel_eng	Paris, France	http://adrianofarano.com	https://twitter.com/farano	jsk-fellows2011	3115	2008-12-15T16:07:32+00:00	0	farano
20392133	Dan Archer	Graphic Journalist and live sketcher http://Instagram.com/archcomix Portfolio: http://www.archcomix.com	London/New York	http://www.patreon.com/archcomix	https://twitter.com/archcomix	jsk-fellows2011	3234	2009-02-08T20:57:36+00:00	0	archcomix
23757441	Hugo Rupert		stanford U		https://twitter.com/hugorupert	jsk-fellows2011	90	2009-03-11T12:50:26+00:00	0	hugorupert
36063042	Di Pinheiro	Journalist, 2011 Fellow @JSKStanford. Former Editor @WSJAmericas and @WSJPortugues; goes from flower girl to street fighter, batman style, whenever required.	New York, NY	http://wsj.com/brazil	https://twitter.com/dipinheiro	jsk-fellows2011	486	2009-04-28T13:24:41+00:00	0	dipinheiro
138732826	Karelia Vázquez	Periodista. Former Knight fellow Stanford University. Autora del blog Antigurú (El País). Mis tuits son míos.	Madrid, Spain	http://blogs.elpais.com/antiguru/	https://twitter.com/Kareliavt	jsk-fellows2011	2332	2010-04-30T12:27:05+00:00	0	Kareliavt
165426547	Jeremy Adam Smith	I edit @greatergoodsc & write for @SFPublicPress @sciam & more. Former @JSKstanford. Contact: jeremysmith (at) http://berkeley.edu	San Francisco Bay Area		https://twitter.com/jeremyadamsmith	jsk-fellows2011	4530	2010-07-11T14:48:53+00:00	0	jeremyadamsmith
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
197220475	Madhu Acharya	CEO @sharecastNP; @JSKstanford Fellow (2010-11).	madhu@sharecast.org.np	http://www.sharecast.org.np	https://twitter.com/Madhu2067	jsk-fellows2011	5262	2010-09-30T23:12:28+00:00	0	Madhu2067
254189881	Angelo Izama	Ugandan Writer. Analyst at VRS|Blogger|Current Affairs|Calisthenics|Film is the Future Language. Kampala. Palo Alto. Abu Dhabi	Kampala, Uganda	http://angeloizama.com	https://twitter.com/Opiaiya	jsk-fellows2011	53936	2011-02-18T20:01:24+00:00	0	Opiaiya

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;