This data as json, CSV (advanced)
Suggested facets: location, verified, created_at (date)
fellowship
| id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
|---|---|---|---|---|---|---|---|---|---|---|
| 10794392 | Kathleen McCoy | Good old dog Clare passed in May, 2014. Puppy arrived in August. Her name is Kiska. | Anchorage | https://twitter.com/kjmccoy | jsk-fellows2007 | 314 | 2007-12-02T21:45:12+00:00 | 0 | kjmccoy | |
| 18197783 | Leslie Casimir | Freelance journalist | San Francisco | https://twitter.com/lcasimir | jsk-fellows2007 | 48 | 2008-12-17T19:54:56+00:00 | 0 | lcasimir | |
| 20253808 | Andrea Bernstein | Co-host Trump, Inc. podcast from @WNYC & @ProPublica; NYT best-selling author: AMERICAN OLIGARCHS: The Kushners, The Trumps, and the Marriage of Money and Power | New York, NY | http://AndreaBernsteinBook.com | https://twitter.com/AndreaWNYC | jsk-fellows2007 | 28333 | 2009-02-06T17:29:43+00:00 | 1 | AndreaWNYC |
| 20932059 | Imtiaz Ali | Peshawar -- Washington D.C | https://twitter.com/imtiaz999 | jsk-fellows2007 | 681 | 2009-02-15T19:51:32+00:00 | 0 | imtiaz999 | ||
| 34827824 | Justine Gubar | Docs, News, Investigations. Author of Fanaticus. National Academy of Television Arts & Sciences. Wes grad. Former Knight Fellow. Back in NYC. | New York, NY | http://www.Fanaticusthebook.com | https://twitter.com/justinegub | jsk-fellows2007 | 1224 | 2009-04-24T03:08:16+00:00 | 1 | justinegub |
| 48140747 | Patricia Mercado S. | Mujer, madre, periodista. En la búsqueda constante... Iniciando proyectos y caminos propios. Directora de @Conectmigrante | Al lado de Carlos Miguel | http://www.conexionmigrante.com | https://twitter.com/Patmercado | jsk-fellows2007 | 4606 | 2009-06-17T22:21:43+00:00 | 0 | Patmercado |
| 55273455 | Christianne Gonzalez | Online media consultant | Silicon Valley | http://www.brasilnewscom.com | https://twitter.com/brasilnewscom | jsk-fellows2007 | 66 | 2009-07-09T15:52:45+00:00 | 0 | brasilnewscom |
| 96941094 | Andrew M. Mwenda | The Old Man of the Clan against common nonsense | Kampala, Uganda | http://independent.co.ug/andrewmwenda | https://twitter.com/AndrewMwenda | jsk-fellows2007 | 358504 | 2009-12-15T08:24:17+00:00 | 1 | AndrewMwenda |
| 139161166 | Kevin Fagan | Reporter at the San Francisco Chronicle. Specialties: Human interest, poverty & homelessness, breaking news, The American West. | San Francisco Chronicle | http://sfgate.com | https://twitter.com/KevinChron | jsk-fellows2007 | 7436 | 2010-05-01T18:54:53+00:00 | 1 | KevinChron |
| 197544399 | Pete McBride | Photographer, Writer, Filmmaker. Advocate of Wild Places. Lover of mountains, glassy waves, and spicy living. | Colorado - or road | http://www.petemcbride.com | https://twitter.com/photogpedro | jsk-fellows2007 | 2706 | 2010-10-01T19:53:37+00:00 | 0 | photogpedro |
| 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 | |
| 341118458 | Eric Schmitt | Senior writer, The New York Times (http://nyti.ms/1awYH4E) covering terrorism and national security issues. Co-author, Counterstrike | Washington, D.C. | http://www.counterstrikethebook.com | https://twitter.com/EricSchmittNYT | jsk-fellows2007 | 44038 | 2011-07-23T20:53:07+00:00 | 0 | EricSchmittNYT |
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;