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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 7809252 | wendy norris | Asst Prof @NazarethCollege exploring socially intelligent computing in humanitarian crisis response | @JSKStanford + @cuinfoscience alum | @PeaceCorps Vanuatu | Rochester, NY | http://wendynorris.com | https://twitter.com/WendyNorris | jsk-fellows2011 | 3121 | 2007-07-30T03:13:25+00:00 | 0 | WendyNorris |
| 14590178 | Michael V. Marcotte | Rethinking news, entrepreneurship and Flintstone houses. UNM Professor of Practice. Started @NMNewsPort and @NVMediaAlliance. MVM Consulting for #pubmedia. | Albuquerque, NM | http://mikemarcotte.com | https://twitter.com/michvinmar | jsk-fellows2011 | 1176 | 2008-04-29T20:21:00+00:00 | 0 | michvinmar |
| 14985683 | Jigar Mehta | Deputy Managing Director of @dohadebates. A new project to inspire solutions to global challenges through civil discourse and debate. | New York, USA | http://dohadebates.com | https://twitter.com/jigarmehta | jsk-fellows2011 | 3619 | 2008-06-02T21:53:47+00:00 | 1 | jigarmehta |
| 17033026 | Gabriela Mafort | Branded Content and Video Branding Consultant. | Rio de Janeiro, Brazil | http://about.me/gmafort | https://twitter.com/gmafort | jsk-fellows2011 | 453 | 2008-10-29T01:22:33+00:00 | 0 | gmafort |
| 17701416 | Beth Duff-Brown | Stanford staff writer; views here my own. Past: AP foreign correspondent, @JSKStanford fellow, Peace Corps. Writing book about one remarkable village in Congo. | Stanford, CA | http://www.bethduffbrown.com | https://twitter.com/bethduffbrown | jsk-fellows2011 | 1441 | 2008-11-28T06:35:16+00:00 | 0 | bethduffbrown |
| 18139193 | Adriano Farano | I've built a company, a pizza oven and a family. Not necessarily in that order. Now Pane Vivo. Ex @Plex @Watchup @StartX @jskstanford @cafebabel_eng | Paris, France | http://adrianofarano.com | https://twitter.com/farano | jsk-fellows2011 | 3115 | 2008-12-15T16:07:32+00:00 | 0 | farano |
| 20392133 | Dan Archer | Graphic Journalist and live sketcher http://Instagram.com/archcomix Portfolio: http://www.archcomix.com | London/New York | http://www.patreon.com/archcomix | https://twitter.com/archcomix | jsk-fellows2011 | 3234 | 2009-02-08T20:57:36+00:00 | 0 | archcomix |
| 21901213 | Paddy Hirsch | ...... | ..... | http://www.paddyhirsch.com | https://twitter.com/paddyhirsch | jsk-fellows2011 | 7337 | 2009-02-25T18:49:06+00:00 | 1 | paddyhirsch |
| 23757441 | Hugo Rupert | stanford U | https://twitter.com/hugorupert | jsk-fellows2011 | 90 | 2009-03-11T12:50:26+00:00 | 0 | hugorupert | ||
| 36063042 | Di Pinheiro | Journalist, 2011 Fellow @JSKStanford. Former Editor @WSJAmericas and @WSJPortugues; goes from flower girl to street fighter, batman style, whenever required. | New York, NY | http://wsj.com/brazil | https://twitter.com/dipinheiro | jsk-fellows2011 | 486 | 2009-04-28T13:24:41+00:00 | 0 | dipinheiro |
| 123692265 | Sahar Habib Ghazi | Journalist. Trainer. Consultant. Experimenting with fiction and comedy. Mother to 8 year-old koala. @globalvoices @JSKstanford @umich @dawn_news alum | Karachi, Pakistan | https://m.youtube.com/watch?index=220&list=PLMd3iH-TpRVdVhyEwDNT_uf_8Rnpqfadm&v=05ZwgjQjnI0 | https://twitter.com/SaharHGhazi | jsk-fellows2011 | 26408 | 2010-03-16T23:09:38+00:00 | 1 | SaharHGhazi |
| 138732826 | Karelia Vázquez | Periodista. Former Knight fellow Stanford University. Autora del blog Antigurú (El País). Mis tuits son míos. | Madrid, Spain | http://blogs.elpais.com/antiguru/ | https://twitter.com/Kareliavt | jsk-fellows2011 | 2332 | 2010-04-30T12:27:05+00:00 | 0 | Kareliavt |
| 165426547 | Jeremy Adam Smith | I edit @greatergoodsc & write for @SFPublicPress @sciam & more. Former @JSKstanford. Contact: jeremysmith (at) http://berkeley.edu | San Francisco Bay Area | https://twitter.com/jeremyadamsmith | jsk-fellows2011 | 4530 | 2010-07-11T14:48:53+00:00 | 0 | jeremyadamsmith | |
| 190430338 | Evelyn Larrubia | I lead investigations and newsrooms. Now @themarkup. Past: Exec Editor @marketplace; Managing Editor News & Investigations @KPCC; @JSKstanford; @LATimes. Cubana | Los Angeles, CA | http://themarkup.org | https://twitter.com/elarrubia | jsk-fellows2011 | 2139 | 2010-09-13T22:59:47+00:00 | 0 | elarrubia |
| 197220475 | Madhu Acharya | CEO @sharecastNP; @JSKstanford Fellow (2010-11). | madhu@sharecast.org.np | http://www.sharecast.org.np | https://twitter.com/Madhu2067 | jsk-fellows2011 | 5262 | 2010-09-30T23:12:28+00:00 | 0 | Madhu2067 |
| 214990371 | Duncan McCue | Nd’Anishinaabe. Southam Fellow @MasseyCollege @UofT. Journalist-in-residence @RSJnow. Host @CheckupCBC (on leave). Fan of frybread. Creator http://riic.ca | Toronto, Ontario | http://www.cbc.ca/mediacentre/bio/duncan-mccue | https://twitter.com/duncanmccue | jsk-fellows2011 | 16308 | 2010-11-12T18:46:52+00:00 | 1 | duncanmccue |
| 254189881 | Angelo Izama | Ugandan Writer. Analyst at VRS|Blogger|Current Affairs|Calisthenics|Film is the Future Language. Kampala. Palo Alto. Abu Dhabi | Kampala, Uganda | http://angeloizama.com | https://twitter.com/Opiaiya | jsk-fellows2011 | 53936 | 2011-02-18T20:01:24+00:00 | 0 | Opiaiya |
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;