This data as json, CSV (advanced)
Suggested facets: verified, created_at (date)
fellowship
| id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 17714681 | Frederic Filloux | Entrepreneur (http://Deepnews.ai), editor of http://mondaynote.com, associate journalism professor at Sciences Po J-school in Paris. | Paris, France | https://mondaynote.com | https://twitter.com/filloux | jsk-fellows2017 | 9008 | 2008-11-28T18:03:11+00:00 | 0 | filloux |
| 18139193 | Adriano Farano | I've built a company, a pizza oven and a family. Not necessarily in that order. Now Pane Vivo. Ex @Plex @Watchup @StartX @jskstanford @cafebabel_eng | Paris, France | http://adrianofarano.com | https://twitter.com/farano | jsk-fellows2011 | 3115 | 2008-12-15T16:07:32+00:00 | 0 | farano |
| 293673969 | Cécile Prieur | Directrice adjointe de la rédaction @lemondefr / Deputy Editor / Proud @JSKStanford Journalism Fellow 2019 and @ICIJorg member | Paris, France | http://www.lemonde.fr | https://twitter.com/cecileprieur | jsk-fellows-2019 | 14291 | 2011-05-05T19:29:32+00:00 | 1 | cecileprieur |
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;