This data as json, CSV (advanced)
fellowship
| id | name ▼ | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 163422349 | inday espina varona | journalist. gadabout. scarred cat. I stand by my tweets. | Philippines | http://indayvarona.wordpress.com/ | https://twitter.com/indayevarona | jsk-fellows2006 | 31343 | 2010-07-06T11:18:02+00:00 | 1 | indayevarona |
| 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 |
| 18149456 | jerrylarge | Seattle Times columnist. jlarge@seattletimes.com, Column interests: education, inequality, science and technology and interesting people. | Seattle, WA | https://twitter.com/jerrylarge | jsk-fellows2001 | 1349 | 2008-12-15T23:00:06+00:00 | 1 | jerrylarge | |
| 34687443 | krissy clark | Host/co-creator: The Uncertain Hour podcast @Marketplace Stories: @reveal @99piorg @PopUpMag @slate Past @JSKstanford fellow 🌖ing at http://storieseverywherere.org | los angeles | https://itunes.apple.com/us/podcast/the-uncertain-hour/id1091031079?mt=2 | https://twitter.com/kristianiaclark | jsk-fellows2010 | 3758 | 2009-04-23T18:28:03+00:00 | 1 | kristianiaclark |
| 14173930 | stacy-marie ishmael | Trinidadian-at-large. Header by Alex Smailes; headshot by Kevin Abosch. She/her/they/them. My superpower is I read to the end. | https://twitter.com/s_m_i | jsk-fellows2017 | 40331 | 2008-03-19T01:40:02+00:00 | 1 | s_m_i | ||
| 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 | |
| 14305753 | 𝙟𝙤𝙨𝙚 𝙯𝙖𝙢𝙤𝙧𝙖 | • Comms. @UniNoticias. // @JSKstanford Fellow. Prof. @univmiami. Former @knightfdn @el_Periodico @UFMedu Law @UniofOxford MediaLaw @UTAustin MPA. OAS Scholar. | Miami, FL | http://www.linkedin.com/in/josecarloszamora | https://twitter.com/jczamora | jsk-fellows-2020 | 7902 | 2008-04-04T20:04:23+00:00 | 1 | jczamora |
| 18454770 | 🔅Don Day | http://BoiseDev.com publisher covering the story of Idaho’s future. @JSKstanford Fellow. Spent 18 years in traditional media, now reinventing local news. | Boise, ID | http://linkedin.com/in/donday | https://twitter.com/DonLDay | jsk-fellows-2018 | 7036 | 2008-12-29T17:56:56+00:00 | 1 | DonLDay |
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;