This data as json, CSV (advanced)
fellowship
id | name | description | location | url | twitter ▼ | fellowship | followers_count | created_at | verified | screen_name |
---|---|---|---|---|---|---|---|---|---|---|
17714681 | Frederic Filloux | Entrepreneur (http://Deepnews.ai), editor of http://mondaynote.com, associate journalism professor at Sciences Po J-school in Paris. | Paris, France | https://mondaynote.com | https://twitter.com/filloux | jsk-fellows2017 | 9008 | 2008-11-28T18:03:11+00:00 | 0 | filloux |
14080017 | Gabriel Sama | Managing Editor @CNET_Es // Past @JSKStanford @ColumbiaJourn @WSJ | San Francisco, California | http://www.cnet.com/es | https://twitter.com/gabosama | jsk-fellows2010 | 9571 | 2008-03-04T21:17:53+00:00 | 1 | gabosama |
67227724 | Gabriel Spitzer | Communications Specialist @KCPubHealth, Science writer. Fmr @KNKXfm @JSKstanford @WBEZ. | Seattle, WA | http://www.transmissionpodcast.org | https://twitter.com/gabrielspitzer | jsk-fellows2017 | 1999 | 2009-08-20T04:28:57+00:00 | 1 | gabrielspitzer |
55363786 | Jerry Capeci | Expert on the American Mafia and organized crime. Award-winning journalist. Gang Land News columnist. Contact Jerry at column02@ganglandnews.com | New York | http://ganglandnews.com | https://twitter.com/ganglandnews | jsk-fellows1996 | 1559 | 2009-07-09T21:11:39+00:00 | 0 | ganglandnews |
20188770 | \ | Tweets are my own | https://twitter.com/gannonbill | jsk-fellows1997 | 454 | 2009-02-05T21:11:25+00:00 | 0 | gannonbill | ||
245587242 | Garance Burke | Global investigative journalist @AP. 2020 @JSKStanford-@StanfordHAI Fellow. Pulitzer finalist. Your ideas welcome—DM for Signal. garanceburke@protonmail.com | San Francisco | http://www.ap.org | https://twitter.com/garanceburke | jsk-fellows-2020 | 5807 | 2011-02-01T01:16:48+00:00 | 1 | garanceburke |
21783956 | gary marx | Chicago Tribune investigative reporter. | Chicago | http://trib.in/2aLM20k | https://twitter.com/garyjmarx | jsk-fellows2002 | 2139 | 2009-02-24T19:09:20+00:00 | 0 | garyjmarx |
17455049 | George Haj | President, @hajmediainc, a strategic communications firm. Recovering journalist. Former @miamiherald, @jskstanford, @ALMMedia, @houstonchron | http://hajmedia.com | https://twitter.com/georgehaj | jsk-fellows2000 | 3070 | 2008-11-18T00:57:30+00:00 | 1 | georgehaj | |
17033026 | Gabriela Mafort | Branded Content and Video Branding Consultant. | Rio de Janeiro, Brazil | http://about.me/gmafort | https://twitter.com/gmafort | jsk-fellows2011 | 453 | 2008-10-29T01:22:33+00:00 | 0 | gmafort |
44067999 | Geri Migielicz | Lorry I Lokey Professional of Journalism Practice Stanford University Graduate Program in Journalism | Santa Cruz, Ca, USA | http://story4.org | https://twitter.com/gmigielicz | jsk-fellows2005 | 319 | 2009-06-02T05:41:47+00:00 | 0 | gmigielicz |
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/ | https://twitter.com/guilherme_amado | jsk-fellows-2018 | 41787 | 2009-03-18T04:47:23+00:00 | 1 | guilherme_amado |
15900236 | Harriet A.Washington | New York City, Las Vegas, NV | https://twitter.com/haw95 | jsk-fellows1998 | 5650 | 2008-08-19T03:44:42+00:00 | 0 | haw95 | ||
2802357499 | Heather Dewar | https://twitter.com/heatherjodewar | jsk-fellows1993 | 20 | 2014-09-10T19:29:28+00:00 | 0 | heatherjodewar | |||
1356019962 | Lope Gutierrez-Ruiz | @JSKstanford and @TEDFellow. Co-Founder of Gopher Magazine & In-House International. Exploring the future of our cities, open data, design, cultural management. | Austin, TX | http://weareinhouse.com | https://twitter.com/hello_lope | jsk-fellows2015 | 540 | 2013-04-16T04:34:00+00:00 | 0 | hello_lope |
16141134 | hrv | Journalist with @boomlive_in | Focusing on a 'vaccine' against 'fake news', half-truths, propaganda, lies via media literacy #MediaBuddhi | @jskstanford alum | Stanford, Delhi, NYC, Oxford | http://mediabuddhi.substack.com/ | https://twitter.com/hrvenkatesh | jsk-fellows-2019 | 3938 | 2008-09-05T06:14:38+00:00 | 1 | hrvenkatesh |
23757441 | Hugo Rupert | stanford U | https://twitter.com/hugorupert | jsk-fellows2011 | 90 | 2009-03-11T12:50:26+00:00 | 0 | hugorupert | ||
180388029 | agg | @spaceship_media problem solver. journalist. designer. lover of high x-heights. favorite color: CMYK. JSK ‘17 | Space | https://twitter.com/iamlaggr | jsk-fellows2017 | 334 | 2010-08-19T14:25:49+00:00 | 0 | iamlaggr | |
82422512 | AlexBeam | Early Twitter non-adopter, journalist, author and so on | Boston | https://twitter.com/imalexbeamyrnot | jsk-fellows1997 | 1650 | 2009-10-14T18:22:51+00:00 | 0 | imalexbeamyrnot | |
20932059 | Imtiaz Ali | Peshawar -- Washington D.C | https://twitter.com/imtiaz999 | jsk-fellows2007 | 681 | 2009-02-15T19:51:32+00:00 | 0 | imtiaz999 | ||
163422349 | inday espina varona | journalist. gadabout. scarred cat. I stand by my tweets. | Philippines | http://indayvarona.wordpress.com/ | https://twitter.com/indayevarona | jsk-fellows2006 | 31343 | 2010-07-06T11:18:02+00:00 | 1 | indayevarona |
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 | https://twitter.com/inksniffer | jsk-fellows2010 | 60 | 2009-02-17T19:27:19+00:00 | 0 | inksniffer |
72928579 | Ivan Penn | Ivan Penn is a Los Angeles-based energy correspondent for @nytimes, 2006 @JSKstanford fellow and 2014 @LoebAwards winner. | Los Angeles, CA | https://www.nytco.com/ivan-penn-joins-business-day/ | https://twitter.com/ivanlpenn | jsk-fellows2006 | 4483 | 2009-09-09T19:26:27+00:00 | 0 | ivanlpenn |
31150056 | izabela moi | journalist. jornalista. journaliste. periodista. giornalista. | https://twitter.com/izamoi | jsk-fellows2015 | 312 | 2009-04-14T15:43:48+00:00 | 0 | izamoi | ||
25603541 | Jacqueline Park | Journalist/Editor, social entrepreneur. Publishes The Story APAC; Alum: #SpliceBeta @walkleys @JSK Stanford @IFJ @IFEX +Founding ed Walkley Mag | Sydney, Eora Nation | https://twitter.com/jacquipark | jsk-fellows2016 | 1256 | 2009-03-20T23:58:42+00:00 | 0 | jacquipark | |
21165536 | james t. areddy | jta | formerly Shanghai | http://www.suburbaphobia.com | https://twitter.com/jamestareddy | jsk-fellows2002 | 2840 | 2009-02-18T03:38:23+00:00 | 1 | jamestareddy |
230336117 | jane gross | Recovering New York Times journalist. Founder New Old Age blog. Author of A Bittersweet Season (Knopf/Vintage) Lecturer. | new york city | https://twitter.com/janegross | https://twitter.com/janegross | jsk-fellows1995 | 581 | 2010-12-25T03:04:16+00:00 | 0 | janegross |
19086064 | janinezacharia | Ex-WashPost Jerusalem/Mideast correspondent. Now teaching journalism at Stanford, writing on tech/national security, international affairs, media. | Stanford | http://janinezacharia.net | https://twitter.com/janinezacharia | jsk-fellows2009 | 4087 | 2009-01-16T21:18:26+00:00 | 0 | janinezacharia |
68204242 | Jagadish Pokhrel | Hubby, dad, son, brother. Chief Editor of The Rising Nepal until 16/08/2020. Interest in how digits are churning #NEWS and turning it into #KNOWLEDGE. | Kasthamandap | https://www.vizify.com/jagadish-pokhrel/twitter-video | https://twitter.com/japokh | jsk-fellows1998 | 714 | 2009-08-23T18:31:54+00:00 | 0 | japokh |
14305753 | 𝙟𝙤𝙨𝙚 𝙯𝙖𝙢𝙤𝙧𝙖 | • Comms. @UniNoticias. // @JSKstanford Fellow. Prof. @univmiami. Former @knightfdn @el_Periodico @UFMedu Law @UniofOxford MediaLaw @UTAustin MPA. OAS Scholar. | Miami, FL | http://www.linkedin.com/in/josecarloszamora | https://twitter.com/jczamora | jsk-fellows-2020 | 7902 | 2008-04-04T20:04:23+00:00 | 1 | jczamora |
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/ | https://twitter.com/jdesmondharris | jsk-fellows2016 | 29294 | 2009-03-23T14:08:25+00:00 | 1 | jdesmondharris | |
16700673 | Rock’em Sock’em Rosie | @WPR, @JSKstanford ‘18, public radio fanatic, often on eight wheels. | Madison, WI | https://twitter.com/jenniferdargan | jsk-fellows-2018 | 434 | 2008-10-11T21:50:07+00:00 | 0 | jenniferdargan | |
165426547 | Jeremy Adam Smith | I edit @greatergoodsc & write for @SFPublicPress @sciam & more. Former @JSKstanford. Contact: jeremysmith (at) http://berkeley.edu | San Francisco Bay Area | https://twitter.com/jeremyadamsmith | jsk-fellows2011 | 4530 | 2010-07-11T14:48:53+00:00 | 0 | jeremyadamsmith | |
14370540 | jeremyhay | Journalist, entrepreneur, JSK Stanford fellow '15 | California, USA | http://www.jeremyhay.com | https://twitter.com/jeremyhay | jsk-fellows2015 | 897 | 2008-04-12T19:21:05+00:00 | 0 | jeremyhay |
18149456 | jerrylarge | Seattle Times columnist. jlarge@seattletimes.com, Column interests: education, inequality, science and technology and interesting people. | Seattle, WA | https://twitter.com/jerrylarge | jsk-fellows2001 | 1349 | 2008-12-15T23:00:06+00:00 | 1 | jerrylarge | |
18482570 | John Fensterwald | Reporter, @EdSource, great site on California early ed, K-12, higher ed news/policies, committed to equity, #CAStudentsMatter; #GoWarriors | San Jose, California | http://www.edsource.org/today | https://twitter.com/jfenster | jsk-fellows1997 | 7841 | 2008-12-30T17:35:09+00:00 | 1 | jfenster |
14985683 | Jigar Mehta | Deputy Managing Director of @dohadebates. A new project to inspire solutions to global challenges through civil discourse and debate. | New York, USA | http://dohadebates.com | https://twitter.com/jigarmehta | jsk-fellows2011 | 3619 | 2008-06-02T21:53:47+00:00 | 1 | jigarmehta |
6199412 | Jim Colgan | Radio/media/tech. Stanford JSK fellow. Previously Audible, WNYC, SoundCloud. California via New York via Dublin. | San Francisco | https://twitter.com/jim_colgan | jsk-fellows-2020 | 2045 | 2007-05-21T13:35:41+00:00 | 0 | jim_colgan | |
254874238 | Jorge R. Imbaquingo | Periodista. Knight Fellow, Stanford University 2012. Editor de Política de @ElComerciocom. Mediaciones interactivas. | Quito-Ecuador | http://goo.gl/OBmUo1 | https://twitter.com/jimbaquingo | jsk-fellows2012 | 3088 | 2011-02-20T05:28:42+00:00 | 0 | jimbaquingo |
24346858 | J. Mariani-Belding | Writer. Communicator. Marketer. Lover of good wine and cheese. Living my best life, with gratitude. | California, USA | https://twitter.com/jmbelding | jsk-fellows2003 | 30 | 2009-03-14T08:10:36+00:00 | 0 | jmbelding | |
86776199 | JulieAnn McKellogg | Making texts fetch @joinsubtext | Builder and storyteller @JSKstanford @pactio_us @mcclatchy @washingtonpost @voanews @UNCHussman | San Francisco, CA | http://joinsubtext.com | https://twitter.com/jmckellogg | jsk-fellows-2018 | 1576 | 2009-11-01T18:44:39+00:00 | 0 | jmckellogg |
101610491 | Joan Úbeda | Factual TV and documentary producer | Barcelona | http://blogerocasional.blogspot.com.es | https://twitter.com/joanubeda | jsk-fellows1999 | 1486 | 2010-01-04T00:22:02+00:00 | 0 | joanubeda |
33870340 | Jodi Upton | Data journalist. Avid counter of all things. Constantly curious. Fan of dogs, gardens and cake. | Syracuse, N.Y. | https://newhouse.syr.edu/faculty-staff/jodi-upton | https://twitter.com/jodiupton | jsk-fellows2003 | 1208 | 2009-04-21T10:48:03+00:00 | 0 | jodiupton |
83623934 | Jody Berger | I care about health--yours, mine, the planet's. #writer, #author | http://www.jody-berger.com | https://twitter.com/jodyberger | jsk-fellows2005 | 442 | 2009-10-19T15:30:18+00:00 | 0 | jodyberger | |
4250629253 | Joseph Poliszuk | Periodista | Coeditor-Fundador de @ArmandoInfo | @JSKstanford Fellow | http://www.armando.info | https://twitter.com/jopoliszuk | jsk-fellows-2020 | 28424 | 2015-11-22T15:54:57+00:00 | 0 | jopoliszuk | |
262793826 | Joseph Neff | Investigative reporter at The Marshall Project | Durham, NC | http://themarshallproject.org | https://twitter.com/josephcneff | jsk-fellows1999 | 2247 | 2011-03-08T19:38:26+00:00 | 1 | josephcneff |
18433533 | Janet Rae-Dupree | Freelance Unboxed Media writer covering innovation, emerging tech, science and more #Binders | Silicon Valley | http://www.linkedin.com/in/jraedupree | https://twitter.com/jraedupree | jsk-fellows2006 | 2473 | 2008-12-28T20:25:40+00:00 | 0 | jraedupree |
22929310 | Jason Seiken | Digital since before digital was a thing. Washington Post, PBS, Daily Telegraph, etc.. Non-digital father and husband. | London | http://www.qcatalyst.com | https://twitter.com/jseiken | jsk-fellows1994 | 2684 | 2009-03-05T15:10:52+00:00 | 1 | jseiken |
13371202 | john temple | Chairman and Co-founder, Amuse Labs | San Francisco, CA | https://amuselabs.com/ | https://twitter.com/jtemplejrnalist | jsk-fellows2014 | 3168 | 2008-02-12T01:13:01+00:00 | 0 | jtemplejrnalist |
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 | https://twitter.com/justinarenstein | jsk-fellows2010 | 7603 | 2008-08-24T07:42:34+00:00 | 0 | justinarenstein |
34827824 | Justine Gubar | Docs, News, Investigations. Author of Fanaticus. National Academy of Television Arts & Sciences. Wes grad. Former Knight Fellow. Back in NYC. | New York, NY | http://www.Fanaticusthebook.com | https://twitter.com/justinegub | jsk-fellows2007 | 1224 | 2009-04-24T03:08:16+00:00 | 1 | justinegub |
453900651 | Newton Kanhema | Journo | Father | Serving Humanity @UNICNAIROBI | Views are mine | With low handicap🏌🏾 | RTs not Endorsements | Nairobi, Kenya | http://www.unicnairobi.org | https://twitter.com/kanhema | jsk-fellows1999 | 1430 | 2012-01-03T12:04:25+00:00 | 0 | kanhema |
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 | https://twitter.com/karl_vick | jsk-fellows2007 | 4737 | 2011-07-08T05:52:41+00:00 | 1 | karl_vick | |
77842540 | Katherine Ellison | #Author of #Mothers & #Murderers The #MommyBrain: How #Motherhood Makes You Smarter, #Pulitzer prize winning #journalist #editor + #publicspeaker | San Francisco Bay Area | http://www.katherineellison.com | https://twitter.com/kathellison | jsk-fellows2000 | 1142 | 2009-09-27T21:48:12+00:00 | 0 | kathellison |
200120015 | Katy Newton | UX Researcher + Developer, Emergent Media, Stanford http://d.school Media Experiments Resident, IDEONY, @JSKStanford Fellow @latimes | Brooklyn, San Francisco | http://katynewton.com | https://twitter.com/katywnewton | jsk-fellows2012 | 793 | 2010-10-08T14:02:56+00:00 | 0 | katywnewton |
49554368 | Kay Johnson | Reuters bureau chief for Thailand, Cambodia and Laos. RT = not endorsements, sometimes bookmarks. | Asia | https://twitter.com/kayatrtrz | jsk-fellows2004 | 2483 | 2009-06-22T06:13:15+00:00 | 1 | kayatrtrz | |
19169884 | Karen Breslau | Relapsing journalist, p/t strategist, and f/t citizen | Oakland, CA | https://twitter.com/kbreslau | jsk-fellows1999 | 247 | 2009-01-19T03:29:33+00:00 | 0 | kbreslau | |
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 | https://twitter.com/kelidailey | jsk-fellows2014 | 4041 | 2009-04-19T07:19:02+00:00 | 0 | kelidailey |
32138947 | Kevin McKenna | Deputy Business Editor, The New York Times. I teach editing at Baruch College, too. | https://twitter.com/kemcke | jsk-fellows1998 | 2241 | 2009-04-16T20:24:34+00:00 | 0 | kemcke | ||
40381878 | Kim Komenich | Mill Valley, CA | http://kimkom.com | https://twitter.com/kimkom | jsk-fellows1994 | 107 | 2009-05-16T01:35:04+00:00 | 0 | kimkom | |
8956962 | Kirk Caraway | Co-founder Megafone/NowAds, 2012-13 John S. Knight Fellow at Stanford University, online news entrepreneur | http://GetMegafone.biz | http://NowAds.biz | https://twitter.com/kirkcaraway | jsk-fellows2013 | 270 | 2007-09-18T18:11:50+00:00 | 0 | kirkcaraway |
10794392 | Kathleen McCoy | Good old dog Clare passed in May, 2014. Puppy arrived in August. Her name is Kiska. | Anchorage | https://twitter.com/kjmccoy | jsk-fellows2007 | 314 | 2007-12-02T21:45:12+00:00 | 0 | kjmccoy | |
34687443 | krissy clark | Host/co-creator: The Uncertain Hour podcast @Marketplace Stories: @reveal @99piorg @PopUpMag @slate Past @JSKstanford fellow 🌖ing at http://storieseverywherere.org | los angeles | https://itunes.apple.com/us/podcast/the-uncertain-hour/id1091031079?mt=2 | https://twitter.com/kristianiaclark | jsk-fellows2010 | 3758 | 2009-04-23T18:28:03+00:00 | 1 | kristianiaclark |
197940788 | Kelly Scott | Writer, editor, political obsessive, arts & culture enthusiast and @Dodgers fan. Proud mom of @DevinMitchell, @sc_mitchell. | Chicago, IL | https://twitter.com/kscottAtLarge | jsk-fellows2004 | 1407 | 2010-10-02T22:13:14+00:00 | 0 | kscottAtLarge | |
14716014 | Laura Hertzfeld | Storyteller, LA ambassador, midnight baker. Lost to Jeopardy James. Now #XR @thisisryot @yahoonews Then @Journalism_360 @EW @PBS Always @jskstanford #binders | Los Angeles, CA | http://www.newsvagabond.com/ | https://twitter.com/laurahertzfeld | jsk-fellows-2019 | 3387 | 2008-05-09T17:50:31+00:00 | 1 | laurahertzfeld |
18197783 | Leslie Casimir | Freelance journalist | San Francisco | https://twitter.com/lcasimir | jsk-fellows2007 | 48 | 2008-12-17T19:54:56+00:00 | 0 | lcasimir | |
537162951 | Linda Gradstein | Bureau Chief, The Media Line News Agency | Jerusalem | http://www.lindagradstein.com | https://twitter.com/lindagradstein | jsk-fellows1999 | 167 | 2012-03-26T09:40:10+00:00 | 0 | lindagradstein |
770729 | Liz Gannes | My last name rhymes with braaains. | San Francisco | http://60db.co | https://twitter.com/lizgannes | jsk-fellows2016 | 68124 | 2007-02-13T23:05:04+00:00 | 1 | lizgannes |
16480721 | Lynne Varner | College isn't about preparing for a job, it's about preparing for a fully realized life. Associate Vice Chancellor, Washington State University Everett. | Seattle | https://twitter.com/lkvarner | jsk-fellows2004 | 1468 | 2008-09-27T02:34:03+00:00 | 0 | lkvarner | |
115359136 | Andrew Losowsky | New York, NY | https://twitter.com/losowsky | jsk-fellows2014 | 8023 | 2010-02-18T12:03:16+00:00 | 1 | losowsky | ||
14908497 | luzmariahelguero | Periodista, poeta, activista y deportista de remo. Fiel creyente en la democracia y la responsabilidad ciudadana. | Peru | https://twitter.com/luzmaria | jsk-fellows2002 | 851 | 2008-05-26T12:33:00+00:00 | 0 | luzmaria | |
97459086 | mago torres | journalist, researcher • @JSKstanford fellow 2017-2018 • happily sharing a Pulitzer with 370+ journalists #PanamaPapers • amable damisela. | http://www.magotorres.net/ | https://twitter.com/magiccia | jsk-fellows-2018 | 3081 | 2009-12-17T14:59:49+00:00 | 0 | magiccia | |
144361718 | Mainul Khan | https://twitter.com/mainulislamkhan | jsk-fellows2003 | 98 | 2010-05-16T02:44:34+00:00 | 0 | mainulislamkhan | |||
240393453 | Marcelle Hopkins | Executive producer of VR/AR and deputy editor of video at The New York Times. Formerly Al Jazeera. | New York, NY | http://nytimes.com | https://twitter.com/marcellehopkins | jsk-fellows-2020 | 4776 | 2011-01-19T20:43:47+00:00 | 0 | marcellehopkins |
30117765 | Marcelo Rubens Paiva | http://blog.estadao.com.br/blog/marcelorubenspaiva/ | https://twitter.com/marcelorubens | jsk-fellows1995 | 829946 | 2009-04-10T01:14:01+00:00 | 1 | marcelorubens | ||
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 | https://twitter.com/marcusherbert | jsk-fellows2010 | 400 | 2009-06-16T11:19:44+00:00 | 0 | marcusherbert | |
15607854 | MarshaMcFadden | ÜT: 21.339917,-157.925875 | https://twitter.com/marshamcfadden | jsk-fellows1995 | 228 | 2008-07-26T04:50:00+00:00 | 0 | marshamcfadden | ||
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 | https://twitter.com/martin_k | jsk-fellows2014 | 8564 | 2011-05-27T21:30:08+00:00 | 1 | martin_k |
5202671 | Martyn Williams | North Korea-focused journalist/researcher @NorthKoreaTech @38NorthNK. Non-resident fellow @stimsoncenter. Author @committeeHRNK. Also KJ6SDF. | Washington, DC | http://www.northkoreatech.org | https://twitter.com/martyn_williams | jsk-fellows2012 | 24339 | 2007-04-19T08:11:12+00:00 | 1 | martyn_williams |
44911552 | Mariana Santos | CEO @poderosaschicas Stanford @JSK Fellow @KnightFoundation Innovation Chair @FIU @ICFJKnight @guardian swim & surf | Rio de Janeiro, Brazil | https://about.me/mariana.santos | https://twitter.com/marysaints | jsk-fellows2015 | 7628 | 2009-06-05T15:07:34+00:00 | 0 | marysaints |
86152476 | Masood Farivar | I cover the Justice Department and the FBI for Voice of America. @capitals and @dcunited fan. | Washington, D.C. | http://www.voanews.com/ | https://twitter.com/masoodfarivar | jsk-fellows2012 | 6809 | 2009-10-29T20:18:15+00:00 | 0 | masoodfarivar |
241747214 | matilde suescun | Woman - Latina - Sin pelos en la lengua - Bloguera - Spanglish - JSK Knight Fellow @Stanford | Miami, FL | http://mujerconojosabiertos.com/ | https://twitter.com/matisu19 | jsk-fellows2016 | 341 | 2011-01-23T01:47:54+00:00 | 0 | matisu19 |
17000789 | Matt Kiefer | R&D for #FOIA + investigations @washingtonpost #jsk20 fellow FOIAmail creator @chicagoreporter alum @NEIU grad @headlineclub @IRE_NICAR #bikechi til I die | Chicago | http://github.com/mattkiefer | https://twitter.com/matt_kiefer | jsk-fellows-2020 | 1587 | 2008-10-27T15:51:18+00:00 | 0 | matt_kiefer |
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 | https://twitter.com/maureenfan | jsk-fellows2010 | 1455 | 2009-01-11T09:26:43+00:00 | 0 | maureenfan |
17677665 | Geoff McGhee | Data vis & multimedia journalism, variously @TheWaterDesk @WestCenter. Former @jskstanford, @lemondefr, @nytimes, @NatGeo My opinions only. | Seattle | http://www.geoffmcghee.com | https://twitter.com/mcgeoff | jsk-fellows2010 | 3119 | 2008-11-27T13:26:22+00:00 | 0 | mcgeoff |
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 | https://twitter.com/melissakchan | jsk-fellows2013 | 75679 | 2008-09-14T22:25:38+00:00 | 1 | melissakchan | |
70269979 | Martha Mendoza | I'm a Pulitzer prize-winning Associated Press National Writer writing breaking news, enterprise and investigative reporting from Silicon Valley. | NorCal | http://www.ap.org | https://twitter.com/mendozamartha | jsk-fellows2001 | 6465 | 2009-08-31T01:27:28+00:00 | 1 | mendozamartha |
34060703 | Juan Pablo Meneses | Director en @UniPortatil /Profesor en @Uchile y @UABBarcelona /Antes @Stanford, @NYUniversity, @Usach /Escritor de no ficción / Seguidor de la religión portátil | Santiago, Chile | http://uportatil.org | https://twitter.com/menesesportatil | jsk-fellows2017 | 9830 | 2009-04-21T22:03:56+00:00 | 0 | menesesportatil |
421725730 | Michael Rain | Digital Storyteller & Speaker // Founder @ENODI_ // @TEDtalks Speaker & Resident // Fellow @JSKstanford @TowKnightCenter // @Columbia alum 🇺🇸🇬🇭 | Palo Alto, CA | http://www.michaelra.in | https://twitter.com/michaeljrain | jsk-fellows-2020 | 922 | 2011-11-26T09:12:00+00:00 | 0 | michaeljrain |
14590178 | Michael V. Marcotte | Rethinking news, entrepreneurship and Flintstone houses. UNM Professor of Practice. Started @NMNewsPort and @NVMediaAlliance. MVM Consulting for #pubmedia. | Albuquerque, NM | http://mikemarcotte.com | https://twitter.com/michvinmar | jsk-fellows2011 | 1176 | 2008-04-29T20:21:00+00:00 | 0 | michvinmar |
24661811 | Michael Grant | Teaching Fellow @Google News Lab. Founder @GetCurrentNow. Priors: UX @Reveal, @JSKstanford Fellow '18, @StarTribune + @SFChronicle. Views are my own. | Menlo Park, CA | https://mikegrant.me | https://twitter.com/mikegrantme | jsk-fellows-2018 | 2461 | 2009-03-16T07:02:19+00:00 | 0 | mikegrantme |
11688592 | Mandy Jenkins | GM for @CompassLocal, @McClatchy. Publisher @MahoningMatters & @LongmontLeader. @JSKStanford '19, Midwesterner, Cat Lady & @ONA board member. She/Her | BK/OH/CO | http://mandyjenkins.com | https://twitter.com/mjenkins | jsk-fellows-2019 | 11493 | 2007-12-31T14:09:33+00:00 | 1 | mjenkins |
16259364 | Michelle Holmes | 📍 Free human, looking for adventure | Indiana, USA | https://www.linkedin.com/in/michelle-holmes-924b2b11/ | https://twitter.com/mlh_holmes | jsk-fellows2012 | 4655 | 2008-09-12T17:26:14+00:00 | 1 | mlh_holmes |
14849874 | Matt Crenson | Opinions are my own. Facts belong to no one. | Washington, DC | https://twitter.com/mmcrenson | jsk-fellows2004 | 189 | 2008-05-20T23:21:58+00:00 | 0 | mmcrenson | |
6181532 | Michael Morisy | Founder and chief executive @MuckRock, helping run @FOIAMachine @DocumentCloud QuackBot @oTranscribe. Board @NFOIC @asapACCESSPRO @CornellSun. He/him. | Undisclosed Bunker, Cambridge | https://www.muckrock.com | https://twitter.com/morisy | jsk-fellows2015 | 9862 | 2007-05-20T16:43:11+00:00 | 1 | morisy |
32995666 | Maria Ronderos | periodista colombiana | London, England | https://twitter.com/mtronderos | jsk-fellows1997 | 22416 | 2009-04-18T20:08:57+00:00 | 0 | mtronderos | |
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 | https://twitter.com/nadiatrinidad | jsk-fellows2010 | 17738 | 2009-05-08T06:36:42+00:00 | 0 | nadiatrinidad | |
399433780 | Najia Ashar | Broadcast Journalist-Entrepreneur-Founder @MBaithak - @Gnmionline - Knight Fellow @JSKStanford - Fellow @EastWestCenter - RTs are not endorsements | Karachi, Pakistan | http://www.gnmionline.org | https://twitter.com/najiaashar | jsk-fellows2015 | 226285 | 2011-10-27T13:58:52+00:00 | 1 | najiaashar |
15315979 | Carolina Guerrero | CEO of @NPR's @RadioAmbulante + @elhilopodcast. Breaking the language barrier with @LupaApp. @JSKStanford Fellow. Personal Assistant to León & Eliseo. | New York, NY | http://radioambulante.org | https://twitter.com/nuncaduermo | jsk-fellows2015 | 15419 | 2008-07-04T07:42:02+00:00 | 0 | nuncaduermo |
16350120 | Claudia Nunez | Editor at @latimesespanol and @hrw_espanol Founder of @Migrahack immigration stories with data+tech. Love maps and lose sleep. Knight fellow ’12 @JSKstanford | Los Angeles,CA | https://twitter.com/nunezcla | jsk-fellows2012 | 1428 | 2008-09-18T17:55:37+00:00 | 0 | nunezcla | |
16613227 | nunovargas | Media, Product, Digital Strategy, Design Thinking & Tech. Ever in love with futebol, food and my family. Knight Fellow @Stanford'13 & invented @getdatastory | Latin America + Porto,Portugal | http://www.linkedin.com/in/vargasnuno/ | https://twitter.com/nunovargas | jsk-fellows2013 | 2277 | 2008-10-06T12:54:28+00:00 | 0 | nunovargas |
JSON shape: default, array, newline-delimited
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;