This data as json, CSV (advanced)
fellowship
| id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 331451880 | Karl Vick | Editor at Large with TIME magazine in NYC, after 4 years in Jerusalem bureau, and 16 at the Washington Post in Rockville, Nairobi, Istanbul, Baghdad and LA. | http://time.com | https://twitter.com/karl_vick | jsk-fellows2007 | 4737 | 2011-07-08T05:52:41+00:00 | 1 | karl_vick | |
| 399433780 | Najia Ashar | Broadcast Journalist-Entrepreneur-Founder @MBaithak - @Gnmionline - Knight Fellow @JSKStanford - Fellow @EastWestCenter - RTs are not endorsements | Karachi, Pakistan | http://www.gnmionline.org | https://twitter.com/najiaashar | jsk-fellows2015 | 226285 | 2011-10-27T13:58:52+00:00 | 1 | najiaashar |
| 423511427 | John Daley | Multi-media journalist, covering health news for Colorado Public Radio, aka CPRNews A link or retweet does not = endorsement. | USA | http://cpr.org | https://twitter.com/CODaleyNews | jsk-fellows2008 | 2351 | 2011-11-28T16:05:17+00:00 | 1 | CODaleyNews |
| 437729436 | Susan Ferriss | Reporter, immigration editor @publicintegrity The Fight in the Fields co-author, former Mexico-based news correspondent. Welcome tips. | Washington, D.C. | http://www.publicintegrity.org/ | https://twitter.com/susanferriss | jsk-fellows2005 | 2121 | 2011-12-15T19:24:06+00:00 | 1 | susanferriss |
| 749768262 | Akoto Ofori-Atta | managing editor @teamtrace. @jskstanford 2014-2015/for life. BK/NJ/Ghana. | Brooklyn, NY | https://twitter.com/KO_616 | jsk-fellows2015 | 3289 | 2012-08-10T17:50:25+00:00 | 1 | KO_616 | |
| 1370570863 | Sacha Pfeiffer | @NPR reporter. Former reporter for @BostonGlobe & @GlobeSpotlight. Former @WBUR host & reporter. @JSKStanford fellow. @SpotlightMovie fan. spfeiffer@npr.org | Boston, MA | https://www.npr.org/people/676406186/sacha-pfeiffer | https://twitter.com/SachaPfeiffer | jsk-fellows2005 | 18502 | 2013-04-21T20:54:15+00:00 | 1 | SachaPfeiffer |
| 1548898596 | Eric Westervelt | @NPR journalist. Recovering foreign correspondent. Occasional host. Musician by moonlight http://SecureDrop.npr.org/ http://SeeDisclaimer.com | San Francisco, CA | https://www.npr.org/people/2101350/eric-westervelt | https://twitter.com/Ericnpr | jsk-fellows2013 | 4897 | 2013-06-26T19:27:15+00:00 | 1 | Ericnpr |
| 2373280040 | 堀江広美 | Bloomberg News東京支局記者・編集者/JBN Finance&Credit TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解 | https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie | https://twitter.com/HiromiSHorie | jsk-fellows1996 | 1602 | 2014-03-05T06:33:39+00:00 | 1 | HiromiSHorie |
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;