jsk_fellows (view)

9 rows where fellowship = "jsk-fellows1996"

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

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
15587316	JocelynNoveckAP	Associated Press national culture and feature writer	NYC		https://twitter.com/JocelynNoveckAP	jsk-fellows1996	867	2008-07-24T19:25:41+00:00	0	JocelynNoveckAP
17270262	Tom Hamburger	Reporter for The Washington Post covering the intersection of money and politics. tom.hamburger@washpost.com	Washington, D.C.	http://www.washingtonpost.com/tom-hamburger/2012/03/05/gIQABXKfTS_page.html	https://twitter.com/thamburger	jsk-fellows1996	31856	2008-11-09T16:20:46+00:00	0	thamburger
18734088	Marcia Stepanek	Journalist, author, speaker, Columbia faculty, focused on how digital voices/crowds interact with traditional power http://about.me/marciastepanek	New York City	http://marciastepanek.com	https://twitter.com/CauseGlobal	jsk-fellows1996	5219	2009-01-07T19:28:12+00:00	0	CauseGlobal
27981533	Elaine Ray	Journalist, writer, family historian,	Stanford, CA	http://www.ebenezerray.com	https://twitter.com/theparagrapher	jsk-fellows1996	138	2009-03-31T22:31:19+00:00	0	theparagrapher
55363786	Jerry Capeci	Expert on the American Mafia and organized crime. Award-winning journalist. Gang Land News columnist. Contact Jerry at column02@ganglandnews.com	New York	http://ganglandnews.com	https://twitter.com/ganglandnews	jsk-fellows1996	1559	2009-07-09T21:11:39+00:00	0	ganglandnews
347983499	Cheryl Devall	Independent wordslinger, editor, story consultant. Veteran of @Reveal, @The_Daily_World, @KPCC, @Marketplace and @NPR (based in Chicago & Miami). She/her/y’all	Oakland-adjacent, CA	http://cheryldevall.com	https://twitter.com/0212crd	jsk-fellows1996	918	2011-08-03T17:50:27+00:00	0	0212crd
463481376	Sally Lehrman	Award-winning science journalist and educator who specializes in identity, race relations and gender. Markkula Center for Applied Ethics Senior Fellow.	SF Bay Area	http://www.bestwrit.com	https://twitter.com/bestwrit	jsk-fellows1996	577	2012-01-14T04:37:35+00:00	0	bestwrit
1169981785	Mike Stanton	UConn journalism professor. Boston Globe Spotlight Fellow. Bestselling author, The Prince of Providence & Unbeaten. Pulitzer. @NewhouseSU & @MedillSchool alum.	Rhode Island & Connecticut		https://twitter.com/projomike	jsk-fellows1996	4220	2013-02-11T20:38:09+00:00	0	projomike
2373280040	堀江広美	Bloomberg News東京支局記者・編集者/JBN Finance&Credit TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解		https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie	https://twitter.com/HiromiSHorie	jsk-fellows1996	1602	2014-03-05T06:33:39+00:00	1	HiromiSHorie

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;