jsk_fellows (view)

18 rows where fellowship = "jsk-fellows2010"

View and edit SQL

Suggested facets: name, location, verified, created_at (date)

fellowship

  • jsk-fellows2010 · 18
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 jsk-fellows2010 9515 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 jsk-fellows2010 7593 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 jsk-fellows2010 3100 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 jsk-fellows2010 1893 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 jsk-fellows2010 1455 2009-01-11T09:26:43+00:00 0 maureenfan
19041319 Peter H. Lewis Noble Prize-nominated writer, Enemy of the People, ex NYT Asheville, NC http://www.peterlewis.com jsk-fellows2010 1936 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 jsk-fellows2010 1112 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 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 jsk-fellows2010 2427 2009-03-17T00:48:13+00:00 0 terukuwayama
34687443 krissy clark Journalist. Make & Host The Uncertain Hour podcast for @Marketplace exploring things we fight a lot about but know just a little about. ❤️ maps los angeles https://itunes.apple.com/us/podcast/the-uncertain-hour/id1091031079?mt=2 jsk-fellows2010 3749 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 jsk-fellows2010 17751 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   jsk-fellows2010 397 2009-06-16T11:19:44+00:00 0 marcusherbert
71545361 Paul Radu       jsk-fellows2010 68 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 jsk-fellows2010 762 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   jsk-fellows2010 2323 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 jsk-fellows2010 1987 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 jsk-fellows2010 103013 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 jsk-fellows2010 74 2011-06-14T16:33:21+00:00 0 HearsayNews

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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;
Powered by Datasette · Query took 86.162ms · About: simonw/jsk-fellows-on-twitter