This data as json, CSV (advanced)
Suggested facets: description, location, verified, created_at (date)
fellowship
| id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 14849874 | Matt Crenson | Opinions are my own. Facts belong to no one. | Washington, DC | https://twitter.com/mmcrenson | jsk-fellows2004 | 189 | 2008-05-20T23:21:58+00:00 | 0 | mmcrenson | |
| 16480721 | Lynne Varner | College isn't about preparing for a job, it's about preparing for a fully realized life. Associate Vice Chancellor, Washington State University Everett. | Seattle | https://twitter.com/lkvarner | jsk-fellows2004 | 1468 | 2008-09-27T02:34:03+00:00 | 0 | lkvarner | |
| 20632365 | barbara roessner | https://twitter.com/broessner | jsk-fellows2004 | 20 | 2009-02-11T21:54:11+00:00 | 0 | broessner | |||
| 21022307 | Barbara Brotman | Writer, hiker, former Chicago Tribune columnist, current freelancer. I love swimming, hug trees and wish Chicago had mountains. | Chicago, Ill. | http://archives.chicagotribune.com/writers/barbara-brotman | https://twitter.com/BarbaraBrotman | jsk-fellows2004 | 999 | 2009-02-16T20:19:59+00:00 | 0 | BarbaraBrotman |
| 21404432 | Eric Weiner | NYT bestselling author. Wanderer. @NPR alum. My new book, THE SOCRATES EXPRESS, is out now! | Washington, DC | http://www.ericweinerbooks.com | https://twitter.com/Eric_Weiner | jsk-fellows2004 | 6707 | 2009-02-20T15:21:40+00:00 | 1 | Eric_Weiner |
| 49554368 | Kay Johnson | Reuters bureau chief for Thailand, Cambodia and Laos. RT = not endorsements, sometimes bookmarks. | Asia | https://twitter.com/kayatrtrz | jsk-fellows2004 | 2483 | 2009-06-22T06:13:15+00:00 | 1 | kayatrtrz | |
| 51893064 | Pablo González | Journalist. Former Bloomberg, Debtwire, 3 Puntos, Perfil, Pagina/12, Jornal do Brasil. Stanford Knight Fellow. UNC. Cordoba, Buenos Aires, Palo Alto, Sao Paulo. | South America | https://twitter.com/Pablo_Rosendo | jsk-fellows2004 | 2681 | 2009-06-29T00:16:32+00:00 | 1 | Pablo_Rosendo | |
| 133891833 | Mika Mäkeläinen | Foreign news journalist at Finland's @yleuutiset. Ex-China & USA. @JSKstanford 2004. RT/like=FYI. Author of Kimlandia. http://facebook.com/Mikareport | Finland | http://yle.fi/uutiset/ | https://twitter.com/Mikareport | jsk-fellows2004 | 5536 | 2010-04-16T22:49:20+00:00 | 1 | Mikareport |
| 197940788 | Kelly Scott | Writer, editor, political obsessive, arts & culture enthusiast and @Dodgers fan. Proud mom of @DevinMitchell, @sc_mitchell. | Chicago, IL | https://twitter.com/kscottAtLarge | jsk-fellows2004 | 1407 | 2010-10-02T22:13:14+00:00 | 0 | kscottAtLarge | |
| 253711352 | Torsten Kjellstrand | Torsten is a staff photographer at The Oregonian, where he makes photographs and videos. He likes snow more than rain. | Portland, Oregon, USA | http://oregonlive.com | https://twitter.com/otorsten | jsk-fellows2004 | 104 | 2011-02-17T20:26:16+00:00 | 0 | otorsten |
| 365973699 | Azmat Abbas | Islamabad | https://twitter.com/Azmat_Abbas | jsk-fellows2004 | 73 | 2011-09-01T10:34:49+00:00 | 0 | Azmat_Abbas | ||
| 2149361988 | Sara Catania | Now: Solutions Journalism Network + USC Annenberg • Always: JSK Stanford 🍝 Catania rhymes with lasagna Headshot by Richa Syal | http://www.saracatania.com | https://twitter.com/Catanify | jsk-fellows2004 | 1859 | 2013-10-22T16:47:07+00:00 | 0 | Catanify |
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;