This data as json, CSV (advanced)
fellowship
| id | name | description ▼ | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 22869559 | Andy DonoBOO! 👻 | managing editor @reveal | CALIFORNIA | https://www.revealnews.org/author/andrew-d-donohue | https://twitter.com/add | jsk-fellows2013 | 7988 | 2009-03-05T02:55:54+00:00 | 1 | add |
| 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 | |
| 16288136 | Melissa Chan | reporter, writer | sometimes @dwnews | latest on VICE News Tonight, Foreign Policy, @GlobalRepCentre. Formerly London, China/Asia, Doha, California, more 🌎. | http://www.melissachan.com | https://twitter.com/melissakchan | jsk-fellows2013 | 75679 | 2008-09-14T22:25:38+00:00 | 1 | melissakchan | |
| 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 |
| 16259364 | Michelle Holmes | 📍 Free human, looking for adventure | Indiana, USA | https://www.linkedin.com/in/michelle-holmes-924b2b11/ | https://twitter.com/mlh_holmes | jsk-fellows2012 | 4655 | 2008-09-12T17:26:14+00:00 | 1 | mlh_holmes |
| 15906933 | Danyel Smith | 📚SHINE BRIGHT: A Personal History of Black Women in Pop | @oneworldlit @randomhouse | alum: @espn @billboard @vibe | @xhrdcvrx #hrdlist #themotto | mostly CA | https://danyelsmith.carrd.co/ | https://twitter.com/danamo | jsk-fellows2014 | 37569 | 2008-08-19T17:42:24+00:00 | 1 | danamo |
| 14145296 | Susie Cagle | 🔍👀💻✍️🎨 / climate, crisis, labor, business, technology, California +++ / susie.cagle@gmail / DMs always open | Oakland, CA | http://susiecagle.com | https://twitter.com/susie_c | jsk-fellows2016 | 23441 | 2008-03-14T06:12:34+00:00 | 1 | susie_c |
| 14124402 | Pedro Doria 🇧🇷😷 | 🗞 @canalmeio. 📚 Escrevo livros de história. 🎙 Falo sobre política. ⚽️ @flamengo 🏈 @stanford 📞 http://bit.ly/2HpPzVx RTs não indicam concordância | Rio de Janeiro | http://www.pedrodoria.com.br/ | https://twitter.com/pedrodoria | jsk-fellows2009 | 115197 | 2008-03-11T15:22:17+00:00 | 1 | pedrodoria |
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;