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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 12497 | Simon Willison | Creator of @datasetteproj, co-creator Django. Fellow at @JSKstanford. Collector of @nichemuseums. Usually hanging out with @natbat and @cleopaws. He/Him | San Francisco, CA | https://simonwillison.net/ | https://twitter.com/simonw | jsk-fellows-2020 | 21461 | 2006-11-15T13:18:50+00:00 | 1 | simonw |
| 13371202 | john temple | Chairman and Co-founder, Amuse Labs | San Francisco, CA | https://amuselabs.com/ | https://twitter.com/jtemplejrnalist | jsk-fellows2014 | 3168 | 2008-02-12T01:13:01+00:00 | 0 | jtemplejrnalist |
| 14478614 | Jeff Elder | Cybersecurity reporter for Business Insider. DMs open for news tips, or email jelder@businessinsider dot com. Signal 4157999085 | San Francisco, CA | https://www.businessinsider.com/author/jeff-elder | https://twitter.com/JeffElder | jsk-fellows2009 | 87727 | 2008-04-22T18:54:22+00:00 | 1 | JeffElder |
| 14699813 | Zena Barakat | Design director @ideo | San Francisco, CA | https://twitter.com/zena_b | jsk-fellows2015 | 2996 | 2008-05-08T12:55:09+00:00 | 1 | zena_b | |
| 17526481 | Yvonne Leow | building @bewildercamp ⛺we're currently looking for beta campers! let us plan your next camping trip. | San Francisco, CA | http://www.yvonneleow.com | https://twitter.com/YvonneLeow | jsk-fellows2015 | 3655 | 2008-11-21T00:08:02+00:00 | 0 | YvonneLeow |
| 46518958 | Chloe Veltman | Arts & Culture Reporter at @KQED | San Francisco, CA | http://www.chloeveltman.com | https://twitter.com/chloeveltman | jsk-fellows2012 | 2187 | 2009-06-11T23:14:41+00:00 | 0 | chloeveltman |
| 86776199 | JulieAnn McKellogg | Making texts fetch @joinsubtext | Builder and storyteller @JSKstanford @pactio_us @mcclatchy @washingtonpost @voanews @UNCHussman | San Francisco, CA | http://joinsubtext.com | https://twitter.com/jmckellogg | jsk-fellows-2018 | 1576 | 2009-11-01T18:44:39+00:00 | 0 | jmckellogg |
| 106430958 | Aaron Glantz | Senior Reporter @Reveal, Pulitzer Finalist, Author, HOMEWRECKERS from HarperCollins, Peabody & duPont Award-winning journalist, 2016 JSK Fellow at Stanford | San Francisco, CA | http://www.aglantz.com/ | https://twitter.com/Aaron_Glantz | jsk-fellows2016 | 7366 | 2010-01-19T14:53:25+00:00 | 1 | Aaron_Glantz |
| 577618330 | Karen de Sa | an investigative reporter for the San Francisco Chronicle | San Francisco, CA | http://www.sfchronicle.com | https://twitter.com/KarendeSa1 | jsk-fellows2006 | 592 | 2012-05-12T01:22:24+00:00 | 0 | KarendeSa1 |
| 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 |
| 750919846330793984 | YooHee Hong | San Francisco, CA | http://ww.linkedin.com/in/yoohee-hong-6136b856 | https://twitter.com/YooHeeHong0916 | jsk-fellows2017 | 72 | 2016-07-07T05:10:17+00:00 | 0 | YooHeeHong0916 |
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;