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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
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;