jsk_fellows (view)

14 rows where fellowship = "jsk-fellows-2018"

View and edit SQL

Suggested facets: location, verified, created_at (date)

fellowship

  • jsk-fellows-2018 · 14
id name description location url fellowship followers_count created_at verified screen_name
3219 Phillip Smith My passion is helping: 💰 1. Newsrooms make more money 📈 2. News startups grow their audience 🔥 3. Journalists succeed as entrepreneurs Let's talk 📩 California https://journalismentrepreneurship.com jsk-fellows-2018 4940 2006-07-27T02:33:10+00:00 0 phillipadsmith
6827702 André Natta Now: @ResolvePhilly/@BrokeinPhilly. Urban conversationalist. Bronx native. 2018 @JSKStanford Fellow. Past: @lenfestlab @bhamterminal @Poynter #wjchat. Love ⚾. Philadelphia, PA https://acnatta.substack.com/ jsk-fellows-2018 4208 2007-06-15T06:50:32+00:00 1 acnatta
14104554 Tim Regan-Porter ❤️ justice, mercy, community, building products & brands, design thinking, coding, mindfulness. Prev: @jskstanford, @mercerccj, @PasteMagazine, @IBM, @McClatchy     jsk-fellows-2018 16623 2008-03-08T23:59:14+00:00 0 timreganporter
16700673 Rock’em Sock’em Rosie @WPR, @JSKstanford ‘18, public radio fanatic, often on eight wheels. she/her Madison, WI   jsk-fellows-2018 424 2008-10-11T21:50:07+00:00 0 jenniferdargan
18454770 🔅Don Day http://BoiseDev.com publisher covering development, growth & business. @JSKstanford Fellow. Spent 18 years in traditional media, now reinventing local news. Boise, ID http://linkedin.com/in/donday jsk-fellows-2018 6589 2008-12-29T17:56:56+00:00 1 DonLDay
19138916 Zeba Khan Librarian's daughter | Caregiver (again) | Race, religion, identity politics | Fellow @JSKstanford | former @theopedproject | she/her Palo Alto, CA   jsk-fellows-2018 4146 2009-01-18T07:16:21+00:00 0 zebakhan
24661811 Michael Grant Teaching Fellow @Google News Lab. Founder of Get Current Studio. Priors: UX @Reveal, @JSKstanford Fellow '18, @sfbusinesstimes, @StarTribune and @SFChronicle Menlo Park, CA https://mikegrant.me jsk-fellows-2018 2238 2009-03-16T07:02:19+00:00 0 mikegrantme
25029808 Guilherme Amado Jornalista. Colunista na @RevistaEpoca e na @cbnoficial. @ICIJorg member. @Abraji VP. @JSKStanford fellow. http://Instagram.com/guilhermeamado Brazil https://epoca.globo.com/guilherme-amado/ jsk-fellows-2018 38575 2009-03-18T04:47:23+00:00 1 guilherme_amado
47898401 Titus Plattner Innovation projects & investigative reporter @Tamedia l @JSKstanford 18' l @ICIJorg Network Committee l Board of Swiss FOIA Lausanne, Suisse https://keybase.io/titus jsk-fellows-2018 2073 2009-06-17T08:26:57+00:00 0 titusplattner
86776199 JulieAnn McKellogg Making texts fetch @joinsubtext | Builder and storyteller @JSKstanford @pactio_us @mcclatchy @washingtonpost @voanews @UNCHussman San Francisco, CA http://joinsubtext.com jsk-fellows-2018 1554 2009-11-01T18:44:39+00:00 0 jmckellogg
97459086 mago torres journalist, researcher • @JSKstanford fellow 2017-2018 • happily sharing a Pulitzer with 370+ journalists #PanamaPapers • amable damisela.   http://www.magotorres.net/ jsk-fellows-2018 3030 2009-12-17T14:59:49+00:00 0 magiccia
184814522 Lisa Rossi Co-founder: Bonfire Strategy. Delivering powerful experiences to spur creative ideas that resonate. Passionate about: Building stronger teams and communities. Des Moines, IA   jsk-fellows-2018 2065 2010-08-30T15:09:19+00:00 1 LisaARossi
213689248 Dr. Seema Yasmin MD + Epidemiologist | Fmr Epidemic Intelligence Service Officer | Science Journalist @WIRED | Director, Stanford Health Comm Initiative | Prof, Stanford Med Hackney girl in California https://linktr.ee/SeemaYasmin jsk-fellows-2018 55409 2010-11-09T15:06:40+00:00 1 DoctorYasmin
2571132636 Barbara Maseda Founder @Invntario, @TEDfellow 2020 Before: @JSKStanford class '18, @BCUMedia #ddj #textdata #opendata #transparency PGP http://bit.ly/2YnCT8Q Cuba https://proyectoinventario.org jsk-fellows-2018 1564 2014-06-16T15:33:22+00:00 0 barbaramaseda

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