jsk_fellows (view)

18 rows where fellowship = "jsk-fellows2014" sorted by location

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 6563 2007-03-15T20:58:07+00:00 0 CindyRoyal
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 4918 2009-03-14T05:21:02+00:00 1 aelacallan
14947379 Tran Ha Easy problems are no fun // On a break from Twitter // Find me on IG // Frmr: @stanforddschool @jskstanford @redeyechicago Chicago   jsk-fellows2014 2472 2008-05-29T19:50:13+00:00 0 tranosaurus
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 jsk-fellows2014 19217 2011-07-04T23:03:23+00:00 1 Amie_FR
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 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/ jsk-fellows2014 1055 2010-01-14T06:32:00+00:00 0 erictortiz
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 1993 2008-05-09T17:44:15+00:00 0 ub14
14130084 Shazna Nessa Global Head of Visuals @WSJ + President, @ONA Board of Directors / Former Director, Journalism @knightfdn + @AP @CondeNast New York, NY   jsk-fellows2014 4991 2008-03-12T04:35:38+00:00 0 shazna
17511846 carlosmartinezserna Program Director @pressfreedom Journalism & human rights New York, NY   jsk-fellows2014 2014 2008-11-20T14:23:06+00:00 0 cmdelaserna
115359136 Andrew Losowsky   New York, NY   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 jsk-fellows2014 877 2010-07-20T08:13:42+00:00 0 tayyebafridi
27921386 alexa schirtzinger product marketing @box | former @google @salesforce @JSKStanford @columbiajourn | usual disclaimers San Francisco   jsk-fellows2014 2427 2009-03-31T17:46:59+00:00 0 aschirtz
13371202 john temple Chairman and Co-founder, Amuse Labs San Francisco, CA https://amuselabs.com/ jsk-fellows2014 3168 2008-02-12T01:13:01+00:00 0 jtemplejrnalist
259414535 Camille Seaman Polar Photographer. Storm Chaser, Explorer, mother, citizen of planet Earth Somewhere on Planet Earth http://www.camilleseaman.com jsk-fellows2014 2094 2011-03-01T21:37:18+00:00 0 CamilleSeaman
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 4041 2009-04-19T07:19:02+00:00 0 kelidailey
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 jsk-fellows2014 486 2011-06-21T20:54:39+00:00 0 KJawoko
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 8564 2011-05-27T21:30:08+00:00 1 martin_k
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 37569 2008-08-19T17:42:24+00:00 1 danamo

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