This data as json, CSV (advanced)
Suggested facets: created_at (date)
fellowship
| id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 47600390 | Marcus Herbert | Once I did TV. Now I do digital. It will happen to us all. Editor in Chief at http://Moneysavingexpert.com, but these views are my own. Or my children's. | Glasgow | https://twitter.com/marcusherbert | jsk-fellows2010 | 400 | 2009-06-16T11:19:44+00:00 | 0 | marcusherbert | |
| 49565987 | Dionne Bunsha | Journalist-author from India, works on human rights, environment, social justice. Loves the sea and sun. Always asking why? | Vancouver, Canada | http://www.dionnebunsha.com | https://twitter.com/dionnebunsha | jsk-fellows2009 | 400 | 2009-06-22T07:29:17+00:00 | 0 | dionnebunsha |
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;