jsk_fellows (view)

15 rows where fellowship = "jsk-fellows2002"

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

- 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, verified, created_at (date)

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
1545741	Elizabeth Osder	Media, Entertainment and Tech Executive... maker of real news...	iPhone: 40.739487,-74.002266	http://www.osdergroup.com	https://twitter.com/osder	jsk-fellows2002	1127	2007-03-19T19:43:35+00:00	0	osder
14908497	luzmariahelguero	Periodista, poeta, activista y deportista de remo. Fiel creyente en la democracia y la responsabilidad ciudadana.	Peru		https://twitter.com/luzmaria	jsk-fellows2002	851	2008-05-26T12:33:00+00:00	0	luzmaria
19152977	Farai Chideya	Creator/Host "Our Body Politic," about power and Black women/all women of color	NYC and Globally	http://farai.com/our-body-politic	https://twitter.com/farai	jsk-fellows2002	44762	2009-01-18T18:36:51+00:00	1	farai
19528008	sergey kuznetsov				https://twitter.com/skuzn	jsk-fellows2002	787	2009-01-26T10:35:31+00:00	0	skuzn
21165536	james t. areddy	jta	formerly Shanghai	http://www.suburbaphobia.com	https://twitter.com/jamestareddy	jsk-fellows2002	2840	2009-02-18T03:38:23+00:00	1	jamestareddy
21783956	gary marx	Chicago Tribune investigative reporter.	Chicago	http://trib.in/2aLM20k	https://twitter.com/garyjmarx	jsk-fellows2002	2139	2009-02-24T19:09:20+00:00	0	garyjmarx
28113052	Beth Fouhy	Senior editor, politics, NBC News and MSNBC	New York, NY	http://www.msnbc.com	https://twitter.com/bfouhy	jsk-fellows2002	14638	2009-04-01T14:15:21+00:00	1	bfouhy
31303305	agnes cusack	Journalist	Melbourne	http://www.newaustraliamedia.org	https://twitter.com/agnescusack	jsk-fellows2002	108	2009-04-15T01:57:51+00:00	0	agnescusack
50379519	Sonni Efron	President & COO, National Press Foundation. Journalism, foreign policy, democracy, human rights, technology, free expression, opinions my own, RTs not.	Washington DC	http://www.nationalpress.org	https://twitter.com/sonniefron	jsk-fellows2002	410	2009-06-24T17:55:58+00:00	0	sonniefron
56245064	Stephen Magagnini	independent journalist covering ethnic affairs, race relations, immigration, tribal affairs, faith issues and human rights	California, USA	http://sacbee.com	https://twitter.com/SteveMagagnini	jsk-fellows2002	1124	2009-07-13T01:12:53+00:00	0	SteveMagagnini
80089310	Andrew Lam	#Lecturer, #journalist & #Author of Perfume Dreams: Reflections on the #Vietnamese Diaspora, East Eats West: Writing in Two Hemisphere, & Birds of Paradise Lost	San Francisco	http://www.huffingtonpost.com/andrew-lam/	https://twitter.com/andrewqlam	jsk-fellows2002	1429	2009-10-05T18:19:44+00:00	1	andrewqlam
107116415	Claudia Kalb	Independent journalist writing for @NatGeoMag + @NatGeoBooks. Ex- Newsweek. Book: Andy Warhol was a Hoarder: Inside the Minds of History's Great Personalities		http://amzn.to/1jGIb6R	https://twitter.com/ClaudiaKalb	jsk-fellows2002	643	2010-01-21T16:05:37+00:00	0	ClaudiaKalb
224059040	Sheila Kaplan	Prohibited disclosure NY student contact info/DOB/birthplace/+ w/w out consent via CPO & regs. Now alarmed by @privacyforum directory info findings; work ahead	Brooklyn NY	https://www.worldprivacyforum.org/2020/04/without-consent/	https://twitter.com/SheilaLKaplan	jsk-fellows2002	1855	2010-12-08T01:43:54+00:00	0	SheilaLKaplan
246041730	Serif Turgut	Peace at Home, Peace in the World-Atatürk			https://twitter.com/Ljiljantr	jsk-fellows2002	23936	2011-02-02T00:36:54+00:00	0	Ljiljantr
1370927040	Alfredo Molano B	🕊🇨🇴 Comisionado de la Verdad 💚 Sociólogo UN, periodista y cronista 🕯 [1944 - 2019] Cuenta en Homenaje al Maestro.	Colombia Rural		https://twitter.com/AlfredoMolanoB	jsk-fellows2002	30206	2013-04-22T01:10:33+00:00	0	AlfredoMolanoB

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;