jsk_fellows (view)

54 rows where location = ""

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: verified, created_at (date)

location ✖

id name description location url fellowship followers_count created_at verified screen_name
13690462 Bonnie D. Ford http://ESPN.com storyteller. Proud Oberlin alum. Omnivorous reader, traveler, viewer & listener.     jsk-fellows2001 14857 2008-02-19T21:20:30+00:00 1 Bonnie_D_Ford
14104554 Tim Regan-Porter "Make awesome stuff & be kind while doing it." CEO, Colorado Press Association. Prev: @jskstanford, @mercerccj, @PasteMagazine, @IBM, @McClatchy     jsk-fellows-2018 16335 2008-03-08T23:59:14+00:00 0 timreganporter
14173930 stacy-marie ishmael Trinidadian-at-large. Header by Alex Smailes; headshot by Kevin Abosch. She/her/they/them. My superpower is I read to the end.     jsk-fellows2017 40331 2008-03-19T01:40:02+00:00 1 s_m_i
14615604 Denis RB lealdade, humildade e procedimento   https://epoca.globo.com/denis-r-burgierman/ jsk-fellows2008 2940 2008-05-01T15:46:23+00:00 0 denisrb
16212914 Natalia Mazotte Journalist & consultant working w/ data, tech, media & innovation. @jskstanford ‘20. @Abraji Director. @okfnbr ex-CEO. @escoladedados & @generonumero co-founder   https://medium.com/@NataliaMazotte jsk-fellows-2020 6143 2008-09-09T23:02:25+00:00 1 NataliaMazotte
16288136 Melissa Chan reporter, writer | sometimes @dwnews | latest on VICE News Tonight, Foreign Policy, @GlobalRepCentre. Formerly London, China/Asia, Doha, California, more 🌎.   http://www.melissachan.com jsk-fellows2013 75679 2008-09-14T22:25:38+00:00 1 melissakchan
17455049 George Haj President, @hajmediainc, a strategic communications firm. Recovering journalist. Former @miamiherald, @jskstanford, @ALMMedia, @houstonchron   http://hajmedia.com jsk-fellows2000 3070 2008-11-18T00:57:30+00:00 1 georgehaj
17787248 Richard Gonzales NPR       jsk-fellows1995 228 2008-12-01T19:55:08+00:00 0 RichardGonzalesNPR
18257896 Ryan Nakashima Product manager, digital subscriptions, Bay Area News Group. Dad. Former @AP. @JSKstanford fellow ‘16-17. rnakashima@bayareanewsgroup.com   https://medium.com/@rnakashi jsk-fellows2017 2068 2008-12-20T01:19:04+00:00 0 rnakashi
19528008 sergey kuznetsov       jsk-fellows2002 787 2009-01-26T10:35:31+00:00 0 skuzn
20188770 \ Tweets are my own     jsk-fellows1997 454 2009-02-05T21:11:25+00:00 0 gannonbill
20632365 barbara roessner       jsk-fellows2004 20 2009-02-11T21:54:11+00:00 0 broessner
20846696 Tomasz Deptula       jsk-fellows2005 15 2009-02-14T13:27:41+00:00 0 tomekdep
21678279 Agaricus Random and untidy. For Personal Science/Quantified Self, follow @quantifiedself. Some archived journalism here: http://antephase.com/archives     jsk-fellows2006 4019 2009-02-23T18:39:32+00:00 0 agaricus
22746299 Arieh O'Sullivan I am a correspondent and anchor at Israel Public Radio English news in Israel, registered Tour Guide, whiskey brewer and storyteller from Elah Valley     jsk-fellows2003 151 2009-03-04T07:34:23+00:00 0 ariehos
26006398 Jenée Editor. Writer. Subtweeter. Now: @NYTOpinion staff editor, @TheOpedProject mentor + sensitivity reader for hire. Then: @Voxdotcom @TheRoot @Harvard Law @HowardU   https://www.linkedin.com/in/jeneed/ jsk-fellows2016 29294 2009-03-23T14:08:25+00:00 1 jdesmondharris
30117765 Marcelo Rubens Paiva     http://blog.estadao.com.br/blog/marcelorubenspaiva/ jsk-fellows1995 829946 2009-04-10T01:14:01+00:00 1 marcelorubens
31150056 izabela moi journalist. jornalista. journaliste. periodista. giornalista.     jsk-fellows2015 312 2009-04-14T15:43:48+00:00 0 izamoi
32138947 Kevin McKenna Deputy Business Editor, The New York Times. I teach editing at Baruch College, too.     jsk-fellows1998 2241 2009-04-16T20:24:34+00:00 0 kemcke
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 17738 2009-05-08T06:36:42+00:00 0 nadiatrinidad
39592148 steven dudley Co-director of InSight Crime, longtime crime & public security reporter; author of MS-13: The Making of America's Most Notorious Gang (HarperCollins, 2020).   http://www.stevendudley.com jsk-fellows2008 5347 2009-05-12T20:48:53+00:00 0 stevensdudley
41007644 Matthew B. Stannard       jsk-fellows2008 16 2009-05-19T00:11:54+00:00 0 MBStannard
56355598 Colleen Barry Reporting on Italy for the Associated Press. You name it.     jsk-fellows2005 553 2009-07-13T12:08:38+00:00 0 CollBarry
66732477 Bonnie Jo Mount       jsk-fellows2003 118 2009-08-18T16:58:07+00:00 0 bonjomo
69205157 Carlos F Chamorro Journalist/Periodista en Nicaragua. Director de Esta Semana y http://www.confidencial.com.ni     jsk-fellows1998 200958 2009-08-27T04:53:44+00:00 1 cefeche
71545361 Paul Radu       jsk-fellows2010 69 2009-09-04T14:18:36+00:00 0 sforaru
83623934 Jody Berger I care about health--yours, mine, the planet's. #writer, #author   http://www.jody-berger.com jsk-fellows2005 442 2009-10-19T15:30:18+00:00 0 jodyberger
86097492 jo-ann armao       jsk-fellows2006 178 2009-10-29T15:52:11+00:00 0 armaoj
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 3081 2009-12-17T14:59:49+00:00 0 magiccia
107116415 Claudia Kalb Independent journalist writing for @NatGeoMag + @NatGeoBooks. Ex- Newsweek. Book: Andy Warhol was a Hoarder: Inside the Minds of History's Great Personalities   http://amzn.to/1jGIb6R jsk-fellows2002 643 2010-01-21T16:05:37+00:00 0 ClaudiaKalb
117450730 Geraldine Moriba Journalist. Filmmaker. Writer. Stanford AI Researcher. Equity Consultant. @JSKstanford. Platform Agnostic. Evolving Human.   https://soundslikehate.org/ jsk-fellows-2019 2178 2010-02-25T16:12:54+00:00 0 GeraldineMoriba
144361718 Mainul Khan       jsk-fellows2003 98 2010-05-16T02:44:34+00:00 0 mainulislamkhan
157531033 watson ,meng       jsk-fellows2009 38 2010-06-20T03:08:34+00:00 0 watsonmeng
164206121 Akaki Gogichaishvili       jsk-fellows2005 174 2010-07-08T08:49:13+00:00 0 BizCourier
168183999 Peter DiCampo Photographer. Cofounder @everydayafrica @evdayprojects. Co-author @photo_rights. 2019 @JSKstanford Fellow. Bad guitarist. Wannabe comic book writer.   https://www.everydayprojects.org/ jsk-fellows-2019 4238 2010-07-18T16:49:04+00:00 0 peterdicampo
174492304 Daniel Coronell Periodista.     jsk-fellows2006 1443731 2010-08-04T01:56:08+00:00 1 DCoronell
180871553 Michael Rezendes Global investigations @AP. Formerly @GlobeSpotlight.   http://ap.org jsk-fellows2009 14387 2010-08-20T18:17:18+00:00 1 MikeRezendes
246041730 Serif Turgut Peace at Home, Peace in the World-Atatürk     jsk-fellows2002 23936 2011-02-02T00:36:54+00:00 0 Ljiljantr
263734042 Dustin Bleizeffer Freelance journalist, John S. Knight Journalism fellow-2017, former @WyoFile, @CSTribune, always #Wyoming #WestNext #ruralwest #climate #energy   http://dustinbleizeffer.com jsk-fellows2017 2004 2011-03-10T16:50:22+00:00 0 DBleizeffer
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
331451880 Karl Vick Editor at Large with TIME magazine in NYC, after 4 years in Jerusalem bureau, and 16 at the Washington Post in Rockville, Nairobi, Istanbul, Baghdad and LA.   http://time.com jsk-fellows2007 4737 2011-07-08T05:52:41+00:00 1 karl_vick
386183180 Girma T Fantaye       jsk-fellows2012 1229 2011-10-06T20:15:31+00:00 0 Girmatf
588357987 mariam semaan #Knight #Fellow 2012/13 #Stanford #University #DesignThinking#Media expert #Designer of #Experiences #vintage clothes and accessories #collector     jsk-fellows2013 207 2012-05-23T13:11:28+00:00 0 semaanmariam
776601864 Natasha Zouves Personal account of ABC7 anchor, journalist and proud Bay Area native! Serious about french fries and USC Trojans ✌ On Instagram @natashazouves   http://www.facebook.com/NatashaZouves jsk-fellows-2020 14961 2012-08-23T19:30:23+00:00 0 NatashaZouves
798978222 Alvin Bessent newsday editorial writer and columnist     jsk-fellows1998 14 2012-09-02T20:23:24+00:00 0 alvin_bessent
1003951466 Slawomir Zagorski       jsk-fellows1997 32 2012-12-11T12:35:36+00:00 0 SlawomirZagorsk
1171581110 Motunrayo Alaka Intentional|Media+Leadership+Development| ED/CEO @WSoyinkaCentre| UNAD | UNILAG | Fellow @StanfordCDDRL and @JSKstanford| Nehemiah 4:6   http://wscij.org jsk-fellows-2020 2109 2013-02-12T10:38:05+00:00 0 D_Encourager
1236306422 María Lilly Delgado Periodista.-Journalist. Stanford Knight Fellow 2013. Periodista-Freelance TV News Reporter and Producer @ Nicaragua. Tweets are on my own.   https://www.univision.com/temas/nicaragua jsk-fellows2013 11163 2013-03-02T20:33:19+00:00 0 MLillyDelgado
1522716182 Sarah T. Williams       jsk-fellows2000 32 2013-06-16T17:16:34+00:00 0 sarahtwilliams1
1892710843 Rita Neubauer       jsk-fellows2000 24 2013-09-22T06:12:57+00:00 0 ritaneubauer
2149361988 Sara Catania Now: Solutions Journalism Network + USC Annenberg • Always: JSK Stanford 🍝 Catania rhymes with lasagna Headshot by Richa Syal   http://www.saracatania.com jsk-fellows2004 1859 2013-10-22T16:47:07+00:00 0 Catanify
2373280040 堀江広美 Bloomberg News東京支局記者・編集者/JBN Finance&Credit TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解   https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie jsk-fellows1996 1602 2014-03-05T06:33:39+00:00 1 HiromiSHorie
2802357499 Heather Dewar       jsk-fellows1993 20 2014-09-10T19:29:28+00:00 0 heatherjodewar
4250629253 Joseph Poliszuk Periodista | Coeditor-Fundador de @ArmandoInfo | @JSKstanford Fellow   http://www.armando.info jsk-fellows-2020 28424 2015-11-22T15:54:57+00:00 0 jopoliszuk

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