This data as json, CSV (advanced)
Suggested facets: created_at (date)
| id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 22252782 | Julie M. McCarthy | National Public Radio Southeast Asia Correspondent. Currently Manila Bureau Chief. Any opinion expressed here is my own, and re-tweets are not endorsements. | Southeast Asia | http://www.npr.org | https://twitter.com/JulieMcCarthyJM | jsk-fellows2003 | 4856 | 2009-02-28T13:03:53+00:00 | 1 | JulieMcCarthyJM |
| 26334203 | Andrew Maykuth | Philadelphia Inquirer business reporter. I cover energy and gambling. Go figure. | Philadelphia, Pa. | http://www.philly.com | https://twitter.com/Maykuth | jsk-fellows2003 | 2641 | 2009-03-24T21:52:53+00:00 | 1 | Maykuth |
| 60664050 | Hannah Bloch | @NPR lead international digital editor. Former WSJ Work in Progress columnist; TIME Pakistan & Afghanistan correspondent; National Geographic writer. Xenophile. | Washington, DC | https://twitter.com/HannahBloch | jsk-fellows2003 | 4034 | 2009-07-27T18:02:27+00:00 | 1 | HannahBloch |
JSON shape: default, array, newline-delimited
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;