This data as json, CSV (advanced)
Suggested facets: verified
fellowship
| id | name | description | location | url | fellowship | followers_count | created_at | verified ▼ | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 17677665 | Geoff McGhee | Data vis & multimedia journalism, variously @TheWaterDesk @WestCenter. Former @jskstanford, @lemondefr, @nytimes, @NatGeo My opinions only. | Seattle | http://www.geoffmcghee.com | https://twitter.com/mcgeoff | jsk-fellows2010 | 3119 | 2008-11-27T13:26:22+00:00 | 0 | mcgeoff |
| 17667060 | Eric Pape | Writer, editor, immersive storyteller. Ex-correspondent: @Newsweek, @Spin, @CivilBeat. Ex-contributor: @LATimes, @ForeignPolicy, @DailyBeast. Bylines: @NYT... | Los Angeles, CA | https://ericpape.journoportfolio.com/ | https://twitter.com/ericpape | jsk-fellows2008 | 1433 | 2008-11-27T02:30:32+00:00 | 1 | ericpape |
| 17684905 | John Boudreau | Vietnam bureau chief, Bloomberg News; formerly @mercnews Retweet ≠ endorsement. | Hanoi, Vietnam | http://www.bloomberg.com | https://twitter.com/svwriter | jsk-fellows1998 | 1776 | 2008-11-27T18:31:36+00:00 | 1 | svwriter |
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;