This data as json, CSV (advanced)
Suggested facets: created_at (date)
| id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 16556482 | Emily Harris | Journalist with Reveal, from The Center for Investigative Reporting | United States | https://twitter.com/emilygharris | jsk-fellows2006 | 1751 | 2008-10-02T07:07:28+00:00 | 1 | emilygharris | |
| 46241234 | Mike Swift | Journalist at global crossroad of tech & law, focused on privacy, security. Chief Digital Risk Correspondent for @MLexclusive. Frmr @JSKStanford: swift@mlex.com | Half Moon Bay, CA | http://mlexmarketinsight.com/mike-swift/ | https://twitter.com/Swiftstories | jsk-fellows2006 | 6048 | 2009-06-10T22:14:58+00:00 | 1 | Swiftstories |
| 163422349 | inday espina varona | journalist. gadabout. scarred cat. I stand by my tweets. | Philippines | http://indayvarona.wordpress.com/ | https://twitter.com/indayevarona | jsk-fellows2006 | 31343 | 2010-07-06T11:18:02+00:00 | 1 | indayevarona |
| 174492304 | Daniel Coronell | Periodista. | https://twitter.com/DCoronell | jsk-fellows2006 | 1443731 | 2010-08-04T01:56:08+00:00 | 1 | DCoronell |
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;