jsk_fellows (view)

18 rows where fellowship = "jsk-fellows2014"

View and edit SQL

Suggested facets: location, verified, created_at (date)

fellowship

  • jsk-fellows2014 · 18
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 jsk-fellows2014 6526 2007-03-15T20:58:07+00:00 0 CindyRoyal
13371202 john temple Chairman and Co-founder, Amuse Labs San Francisco, CA https://amuselabs.com/ jsk-fellows2014 3164 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   jsk-fellows2014 4961 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 jsk-fellows2014 1976 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   jsk-fellows2014 2475 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/ jsk-fellows2014 37543 2008-08-19T17:42:24+00:00 1 danamo
17511846 carlosmartinezserna Program Director @pressfreedom New York, NY   jsk-fellows2014 2000 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 jsk-fellows2014 4920 2009-03-14T05:21:02+00:00 1 aelacallan
27921386 alexa schirtzinger product marketing @google | former @salesforce @JSKStanford @columbiajourn | usual disclaimers San Francisco http://medium.com/@aschirtz jsk-fellows2014 2428 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 jsk-fellows2014 4037 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/ jsk-fellows2014 1793 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/ jsk-fellows2014 1059 2010-01-14T06:32:00+00:00 0 erictortiz
115359136 Andrew Losowsky   New York, NY   jsk-fellows2014 7998 2010-02-18T12:03:16+00:00 1 losowsky
168580629 Tayyeb Afridi Journalist| Radio & Online | Media Developement | @JSKStanford |ICFJ 11 | RT≠Endorsement. Peshawar, Pakistan https://www.tnn.com.pk jsk-fellows2014 816 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 jsk-fellows2014 2084 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 jsk-fellows2014 8464 2011-05-27T21:30:08+00:00 1 martin_k
321603395 Kennedy Jawoko I am a dad, writer, journalist, 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 jsk-fellows2014 480 2011-06-21T20:54:39+00:00 0 KJawoko
329353102 Amie Ferris-Rotman Contributing Editor @FullerProject. Formerly @washingtonpost Moscow Correspondent. Ex-Foreign Policy, WSJ and Reuters in Kabul. Proud founder of @Sahar_Speaks London, UK https://www.amieferrisrotman.com jsk-fellows2014 19178 2011-07-04T23:03:23+00:00 1 Amie_FR

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 82.897ms · About: simonw/jsk-fellows-on-twitter