This data as json, CSV (advanced)
Suggested facets: name, location, verified, created_at (date)
fellowship
id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
---|---|---|---|---|---|---|---|---|---|---|
14080017 | Gabriel Sama | Managing Editor @CNET_Es // Past @JSKStanford @ColumbiaJourn @WSJ | San Francisco, California | http://www.cnet.com/es | https://twitter.com/gabosama | jsk-fellows2010 | 9571 | 2008-03-04T21:17:53+00:00 | 1 | gabosama |
15967248 | Justin Arenstein | Investigative journalist & #CivicTech strategist. Manages pan-African innovation fund + tech labs. Founder at @Code4Africa + @afriLEAKS +@AfricanCIR + @HHAfrica | Africa + Caucasus | http://linkedin.com/in/justinarenstein | https://twitter.com/justinarenstein | jsk-fellows2010 | 7603 | 2008-08-24T07:42:34+00:00 | 0 | justinarenstein |
17677665 | Geoff McGhee | Data vis & multimedia journalism, variously @TheWaterDesk @WestCenter. Former @jskstanford, @lemondefr, @nytimes, @NatGeo My opinions only. | Seattle | http://www.geoffmcghee.com | https://twitter.com/mcgeoff | jsk-fellows2010 | 3119 | 2008-11-27T13:26:22+00:00 | 0 | mcgeoff |
18231471 | Andrew Finlayson | EVP Digital/Social Strategy @SmithGeiger Helping storytellers on screens with research on 📺 OTT, video, SEO, website, mobile Author "Questions That Work" 👇 | 818-874-2000 | http://questionswork.com | https://twitter.com/questionswork | jsk-fellows2010 | 1891 | 2008-12-19T01:49:46+00:00 | 0 | questionswork |
18862139 | maureenfan | Researching a family memoir about my grandfather's legacy and a long-lost aunt. Former Knight Fellow, ex-WashPost Beijing correspondent. RT ≠ endorsement. | San Francisco Bay Area | http://www.maureenfan.com | https://twitter.com/maureenfan | jsk-fellows2010 | 1455 | 2009-01-11T09:26:43+00:00 | 0 | maureenfan |
19041319 | Peter H. Lewis | Reporter, Asheville Watchdog http://avlwatchdog.org. Noble Prize-nominated writer, Enemy of the People, ex NYT. | Asheville, NC | http://www.peterlewis.com | https://twitter.com/peterhlewis | jsk-fellows2010 | 1933 | 2009-01-15T22:01:05+00:00 | 0 | peterhlewis |
19587103 | Andrew Purvis | Journalist and bureau chief, formerly w/ @TIME in Africa, eastern Europe, Turkey, Balkans, Germany. Consultant w/ UN Refugee Agency. Missing...Beirut. | San Francisco | http://about.me/andrewcpurvis | https://twitter.com/ANDREWCPURVIS | jsk-fellows2010 | 1115 | 2009-01-27T11:19:44+00:00 | 0 | ANDREWCPURVIS |
21120375 | John Duncan | Head of development at Mad Mobile in Tampa. Doing big interesting things that aren't easy and which require a bunch of smart people to enjoy working together | Tampa | http://www.madmobile.com | https://twitter.com/inksniffer | jsk-fellows2010 | 60 | 2009-02-17T19:27:19+00:00 | 0 | inksniffer |
24808107 | teru kuwayama | Seeker. Ex-IG/FB, JSK Fellow at Stanford, Ochberg Fellow at Dart Center for Journalism and Trauma, Senior TED Fellow, Hoover Institution media fellow. | NYC | http://www.about.me/terukuwayama | https://twitter.com/terukuwayama | jsk-fellows2010 | 2423 | 2009-03-17T00:48:13+00:00 | 0 | terukuwayama |
34687443 | krissy clark | Host/co-creator: The Uncertain Hour podcast @Marketplace Stories: @reveal @99piorg @PopUpMag @slate Past @JSKstanford fellow 🌖ing at http://storieseverywherere.org | los angeles | https://itunes.apple.com/us/podcast/the-uncertain-hour/id1091031079?mt=2 | https://twitter.com/kristianiaclark | jsk-fellows2010 | 3758 | 2009-04-23T18:28:03+00:00 | 1 | kristianiaclark |
38621496 | Nadia Trinidad | Head of ABS CBN News Channel, Knight Fellow, foodie, living each day as it comes. Views expressed are my own, not ABS-CBN's. | http://anc.abs-cbnnews.com | https://twitter.com/nadiatrinidad | jsk-fellows2010 | 17738 | 2009-05-08T06:36:42+00:00 | 0 | nadiatrinidad | |
47600390 | Marcus Herbert | Once I did TV. Now I do digital. It will happen to us all. Editor in Chief at http://Moneysavingexpert.com, but these views are my own. Or my children's. | Glasgow | https://twitter.com/marcusherbert | jsk-fellows2010 | 400 | 2009-06-16T11:19:44+00:00 | 0 | marcusherbert | |
71545361 | Paul Radu | https://twitter.com/sforaru | jsk-fellows2010 | 69 | 2009-09-04T14:18:36+00:00 | 0 | sforaru | |||
85507898 | Christine Larson | Exuberantly curious. Assistant Professor of Journalism at University of Colorado, Boulder. Mother of (twin teenage) Dragons. | Boulder, CO | http://www.christinelarson.com | https://twitter.com/LarsonWrites | jsk-fellows2010 | 766 | 2009-10-27T05:52:33+00:00 | 0 | LarsonWrites |
86129676 | Alfonso Cuéllar Araújo | Politólogo | Periodista | Diplomático | Columnista de Semana | Bogotá, D.C., Colombia | https://twitter.com/ACuellarAraujo | jsk-fellows2010 | 2356 | 2009-10-29T18:23:11+00:00 | 0 | ACuellarAraujo | |
105381785 | Susanne Rust | Investigative Reporter @latimes | California, USA | http://www.latimes.com/la-bio-susanne-rust-staff.html | https://twitter.com/susrust | jsk-fellows2010 | 2012 | 2010-01-16T05:17:40+00:00 | 1 | susrust |
214740111 | Martin Pallares | Periodista. Co fundador de http://4Pelagatos.com John S. Knight Fellow at Stanford. Mis retuits quieren decir miren esto quizá les interesa. No es apoyo. | Quito, Ecuador | http://4pelagatos.com | https://twitter.com/Martinminguchi | jsk-fellows2010 | 102855 | 2010-11-12T03:18:13+00:00 | 0 | Martinminguchi |
317226860 | John Duncan | Browse for news, share everything you find, make yourself useful | http://hearsay.it | https://twitter.com/HearsayNews | jsk-fellows2010 | 74 | 2011-06-14T16:33:21+00:00 | 0 | HearsayNews |
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;