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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1246761 | Cindy Royal | Professor at TX State, teaching Web design, coding & digital product concepts. ‘13-‘14 JSK Fellow at Stanford. Live in Austin, loved live music, when we had it. | Austin, TX | http://www.cindyroyal.com | https://twitter.com/CindyRoyal | jsk-fellows2014 | 6563 | 2007-03-15T20:58:07+00:00 | 0 | CindyRoyal |
| 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 |
| 14130084 | Shazna Nessa | Global Head of Visuals @WSJ + President, @ONA Board of Directors / Former Director, Journalism @knightfdn + @AP @CondeNast | New York, NY | https://twitter.com/shazna | jsk-fellows2014 | 4991 | 2008-03-12T04:35:38+00:00 | 0 | shazna | |
| 14715942 | Umbreen Bhatti | Director of @barnard_athena || Fmr Director of @KQED's innovation lab, @JSKStanford fellow, and lawyer. Tweets 100% mine. | NYC | https://www.linkedin.com/in/umbreenbhatti | https://twitter.com/ub14 | jsk-fellows2014 | 1993 | 2008-05-09T17:44:15+00:00 | 0 | ub14 |
| 14947379 | Tran Ha | Easy problems are no fun // On a break from Twitter // Find me on IG // Frmr: @stanforddschool @jskstanford @redeyechicago | Chicago | https://twitter.com/tranosaurus | jsk-fellows2014 | 2472 | 2008-05-29T19:50:13+00:00 | 0 | tranosaurus | |
| 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 |
| 17511846 | carlosmartinezserna | Program Director @pressfreedom Journalism & human rights | New York, NY | https://twitter.com/cmdelaserna | jsk-fellows2014 | 2014 | 2008-11-20T14:23:06+00:00 | 0 | cmdelaserna | |
| 24334685 | Aela Callan | Ella with an A. Co-founder of @setyourhead an immersive learning ecosystem to keep journalists safe with a strong mindset. @JSKStanford alum | Beirut, Lebanon | http://www.headset.studio | https://twitter.com/aelacallan | jsk-fellows2014 | 4918 | 2009-03-14T05:21:02+00:00 | 1 | aelacallan |
| 27921386 | alexa schirtzinger | product marketing @box | former @google @salesforce @JSKStanford @columbiajourn | usual disclaimers | San Francisco | https://twitter.com/aschirtz | jsk-fellows2014 | 2427 | 2009-03-31T17:46:59+00:00 | 0 | aschirtz | |
| 33155287 | Keli “Wears a Fashionable Mask” Dailey | teach @MillsCollege + @stmarysca, creator of #SurvivingSanFrancisco + @newshangover, alum @jskstanford + @ucbsoj, doing comedy + news | Texas-bred/San Francisco-based | http://www.kelidailey.com | https://twitter.com/kelidailey | jsk-fellows2014 | 4041 | 2009-04-19T07:19:02+00:00 | 0 | kelidailey |
| 75377550 | Ana María Carrano | Journalist | Knight Fellow '14 at Stanford University. Founder of http://archivodevoces.com Formerly with @IAM_Vzla @IAMonuments | Miami, FL | https://www.linkedin.com/in/ana-maria-carrano/ | https://twitter.com/AnaMariaCarrano | jsk-fellows2014 | 1797 | 2009-09-18T20:30:12+00:00 | 0 | AnaMariaCarrano |
| 104733894 | Eric Ortiz | Editor @stadiumtalkcom @Granite_Media. Also @Lawatmargins Former @ESPN @NESN @JSKStanford @Truthdig. Founder @evrybit. #news #sports #journalism #storytelling | Minneapolis, MN | http://lawatthemargins.com/category/community-based-news-room-cbnr/ | https://twitter.com/erictortiz | jsk-fellows2014 | 1055 | 2010-01-14T06:32:00+00:00 | 0 | erictortiz |
| 115359136 | Andrew Losowsky | New York, NY | https://twitter.com/losowsky | jsk-fellows2014 | 8023 | 2010-02-18T12:03:16+00:00 | 1 | losowsky | ||
| 168580629 | Tayyeb Afridi | Journalist| Radio & Online | Media Development | @JSKStanford |ICFJ 11 | RT≠Endorsement. | Peshawar, Pakistan | https://www.tnn.com.pk | https://twitter.com/tayyebafridi | jsk-fellows2014 | 877 | 2010-07-20T08:13:42+00:00 | 0 | tayyebafridi |
| 259414535 | Camille Seaman | Polar Photographer. Storm Chaser, Explorer, mother, citizen of planet Earth | Somewhere on Planet Earth | http://www.camilleseaman.com | https://twitter.com/CamilleSeaman | jsk-fellows2014 | 2094 | 2011-03-01T21:37:18+00:00 | 0 | CamilleSeaman |
| 306428731 | Martin Kotynek | editor-in-chief / Chefredakteur @ DER STANDARD in Vienna // past: deputy editor-in-chief @ ZEIT ONLINE in Berlin // Knight Fellow '14 @ Stanford University | Wien, Österreich | http://linkedin.com/in/mkotynek | https://twitter.com/martin_k | jsk-fellows2014 | 8564 | 2011-05-27T21:30:08+00:00 | 1 | martin_k |
| 321603395 | Kennedy Jawoko | I am a dad, writer, college professor, social entrep and media dev. expert, not always in that order. | Toronto, Ontario | https://www.linkedin.com/profile/preview?vpa=pub&locale=en_US | https://twitter.com/KJawoko | jsk-fellows2014 | 486 | 2011-06-21T20:54:39+00:00 | 0 | KJawoko |
| 329353102 | Amie Ferris-Rotman | Interim Global Editor @FullerProject. Formerly @washingtonpost Moscow Correspondent. Stints with FP, WSJ and Reuters in Kabul. Proud founder of @Sahar_Speaks | London, UK | https://www.amieferrisrotman.com | https://twitter.com/Amie_FR | jsk-fellows2014 | 19217 | 2011-07-04T23:03:23+00:00 | 1 | Amie_FR |
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;