This data as json, CSV (advanced)
fellowship
id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
---|---|---|---|---|---|---|---|---|---|---|
275541233 | Veronica Chambers | Editor, Narrative Projects @nytimes, author, Shirley Chisholm Is a Verb, 32 Yolks w/ @ericripert, @JSKStanford alum. I'm not a player but I create a lot. | New York | http://veronicachambers.com | https://twitter.com/vvchambers | jsk-fellows2017 | 7840 | 2011-04-01T13:51:48+00:00 | 1 | vvchambers |
281065346 | Mary Pols | Media relations @BatesCollege, formerly editor @MaineWomenMag, writer @PressHerald, movie critic @TIME, @JSKStanford. Plus: the blur of the 90s and @ucbsoj | Maine | https://twitter.com/MaryPols | jsk-fellows2006 | 3401 | 2011-04-12T15:17:07+00:00 | 0 | MaryPols | |
284593852 | William McNulty | Santa Cruz CA | https://twitter.com/wemcn | jsk-fellows2013 | 469 | 2011-04-19T15:40:58+00:00 | 0 | wemcn | ||
293673969 | Cécile Prieur | Directrice adjointe de la rédaction @lemondefr / Deputy Editor / Proud @JSKStanford Journalism Fellow 2019 and @ICIJorg member | Paris, France | http://www.lemonde.fr | https://twitter.com/cecileprieur | jsk-fellows-2019 | 14291 | 2011-05-05T19:29:32+00:00 | 1 | cecileprieur |
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 |
315834402 | Wanja Njuguna | Mother, writer, editor, journalism/communication lecturer, human rights defende. Loves reading voraciously, mentoring, birding, environment, fun. I hate liers! | The World | http://wanjasnotebook.blogspot.com | https://twitter.com/wanjasnotebook | jsk-fellows2003 | 123 | 2011-06-12T14:35:11+00:00 | 0 | wanjasnotebook |
316717535 | Sarah Shourd | Trauma-informed journalist. Advocate for alternatives to incarceration and restorative justice. Playwright and Director. Lover of popcorn and redwood trees. | Oakland, CA | https://pulitzercenter.org/event/box-virtual-performances | https://twitter.com/SShourd | jsk-fellows-2019 | 3275 | 2011-06-13T21:27:49+00:00 | 0 | SShourd |
317226860 | John Duncan | Browse for news, share everything you find, make yourself useful | http://hearsay.it | https://twitter.com/HearsayNews | jsk-fellows2010 | 74 | 2011-06-14T16:33:21+00:00 | 0 | HearsayNews | |
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 | https://twitter.com/KJawoko | jsk-fellows2014 | 486 | 2011-06-21T20:54:39+00:00 | 0 | KJawoko |
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 | https://twitter.com/Amie_FR | jsk-fellows2014 | 19217 | 2011-07-04T23:03:23+00:00 | 1 | Amie_FR |
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 | |
341118458 | Eric Schmitt | Senior writer, The New York Times (http://nyti.ms/1awYH4E) covering terrorism and national security issues. Co-author, Counterstrike | Washington, D.C. | http://www.counterstrikethebook.com | https://twitter.com/EricSchmittNYT | jsk-fellows2007 | 44038 | 2011-07-23T20:53:07+00:00 | 0 | EricSchmittNYT |
342455823 | Louis Hansen | Enterprise and housing reporter, Mercury News. I have lots of questions. @JSKstanford fellow, 2015 lhansen@ http://bayareanewsgroup.com | Palo Alto, CA | https://www.mercurynews.com/ | https://twitter.com/HansenLouis | jsk-fellows2015 | 1607 | 2011-07-26T01:36:26+00:00 | 0 | HansenLouis |
347983499 | Cheryl Devall | Independent wordslinger, editor, story consultant. Veteran of @Reveal, @The_Daily_World, @KPCC, @Marketplace and @NPR (based in Chicago & Miami). She/her/y’all | Oakland-adjacent, CA | http://cheryldevall.com | https://twitter.com/0212crd | jsk-fellows1996 | 918 | 2011-08-03T17:50:27+00:00 | 0 | 0212crd |
365973699 | Azmat Abbas | Islamabad | https://twitter.com/Azmat_Abbas | jsk-fellows2004 | 73 | 2011-09-01T10:34:49+00:00 | 0 | Azmat_Abbas | ||
370797042 | Gerald Carbone | Published books on Nathanael Greene and George Washington; former Knight Fellow @ Stanford; master's degree in Public Humanities, Brown | Brown University | http://gedcarbone.com | https://twitter.com/GedCarbone | jsk-fellows1999 | 104 | 2011-09-09T17:02:51+00:00 | 0 | GedCarbone |
376400826 | Bob Shaw | @pioneerpress uber-suburb reporter, Woodbury, Cottage Grove, St. Paul. Father of two perfect children, kayaker, X-C skier, creator of bad art and smelly salads | St. Paul, MN | http://www.twincities.com/ | https://twitter.com/BShawPP | jsk-fellows1995 | 1074 | 2011-09-19T20:34:01+00:00 | 0 | BShawPP |
382121824 | Astrid Maier | Homeoffice Editor in Chief @XINGNews inspiring people to lead the work life they want / ex @join_ada / tech & companies editor @wiwo / @JSKstanford Fellow '16 | Hamburg, Deutschland | http://dverse.media | https://twitter.com/MaierAstrid | jsk-fellows2016 | 3111 | 2011-09-29T14:36:21+00:00 | 0 | MaierAstrid |
386183180 | Girma T Fantaye | https://twitter.com/Girmatf | jsk-fellows2012 | 1229 | 2011-10-06T20:15:31+00:00 | 0 | Girmatf | |||
388030023 | Katherine A Rowlands | I run http://BayCityNews.com + http://BayCityNews.org + http://LocalNewsMatters.org. Past Life: @JSKstanford @DiabloMagazine @mercnews @EastBayTimes @SLOTribune | Bay Area, California | http://www.baycitynews.org | https://twitter.com/News_Kat | jsk-fellows2017 | 2285 | 2011-10-10T02:15:17+00:00 | 0 | News_Kat |
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 |
406632310 | Alan Zarembo | Editor @latimes of foreign and national stories. Former correspondent in Africa and Latin America. | Los Angeles | http://www.latimes.com | https://twitter.com/AlanZarembo | jsk-fellows2003 | 1236 | 2011-11-06T23:59:02+00:00 | 0 | AlanZarembo |
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 |
423511427 | John Daley | Multi-media journalist, covering health news for Colorado Public Radio, aka CPRNews A link or retweet does not = endorsement. | USA | http://cpr.org | https://twitter.com/CODaleyNews | jsk-fellows2008 | 2351 | 2011-11-28T16:05:17+00:00 | 1 | CODaleyNews |
437729436 | Susan Ferriss | Reporter, immigration editor @publicintegrity The Fight in the Fields co-author, former Mexico-based news correspondent. Welcome tips. | Washington, D.C. | http://www.publicintegrity.org/ | https://twitter.com/susanferriss | jsk-fellows2005 | 2121 | 2011-12-15T19:24:06+00:00 | 1 | susanferriss |
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 |
463481376 | Sally Lehrman | Award-winning science journalist and educator who specializes in identity, race relations and gender. Markkula Center for Applied Ethics Senior Fellow. | SF Bay Area | http://www.bestwrit.com | https://twitter.com/bestwrit | jsk-fellows1996 | 577 | 2012-01-14T04:37:35+00:00 | 0 | bestwrit |
516794788 | Bryan Pollard | associate director, @najournalists; former JSK Fellow, @jskstanford; former exec editor, @CherokeePhoenix; founder @streetroots, board member, @highcountrynews | Fayetteville, AR | https://twitter.com/cherokee_editor | jsk-fellows-2020 | 973 | 2012-03-06T19:10:04+00:00 | 0 | cherokee_editor | |
520989810 | Divine Dube | Local news #innovation geek. @JSKstanford Alum | California, USA | https://medium.com/@divine_dube | https://twitter.com/village_scribe | jsk-fellows-2020 | 1591 | 2012-03-11T04:04:01+00:00 | 0 | village_scribe |
531407250 | Andrew Zajac | Legal reporter for Bloomberg News | Washington DC | https://twitter.com/andrewzajac1 | jsk-fellows1997 | 151 | 2012-03-20T14:55:56+00:00 | 0 | andrewzajac1 | |
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 |
555484188 | Elizabeth Dalziel | photographer specializing in everything | London | http://www.elizabethdalziel.com | https://twitter.com/edalziel | jsk-fellows2008 | 435 | 2012-04-16T20:30:47+00:00 | 0 | edalziel |
556757858 | Arif Elsaui | journalist -media consultant-freelancer -kenya \Nairobi | Kenya-Nairobi | https://twitter.com/ArifElsau | jsk-fellows2017 | 922 | 2012-04-18T10:42:05+00:00 | 0 | ArifElsau | |
577618330 | Karen de Sa | an investigative reporter for the San Francisco Chronicle | San Francisco, CA | http://www.sfchronicle.com | https://twitter.com/KarendeSa1 | jsk-fellows2006 | 592 | 2012-05-12T01:22:24+00:00 | 0 | KarendeSa1 |
588357987 | mariam semaan | #Knight #Fellow 2012/13 #Stanford #University #DesignThinking#Media expert #Designer of #Experiences #vintage clothes and accessories #collector | https://twitter.com/semaanmariam | jsk-fellows2013 | 207 | 2012-05-23T13:11:28+00:00 | 0 | semaanmariam | ||
593247967 | Bob Minzesheimer | Book reviewer & reporter; former library board president, Nat. Book Critics Circle executive board, second baseman. Email: bookbobminz@yahoo.com | Cheever Country, N.Y. | http://muckrack.com/bookbobminz | https://twitter.com/bookbobminz | jsk-fellows1994 | 1390 | 2012-05-29T01:45:10+00:00 | 0 | bookbobminz |
619420043 | Joel Gutierrez | Periodista nicaragüense, Knight Fellow de la Universidad de Stanford | Nicaragua | https://twitter.com/JoelGutierrezG | jsk-fellows2009 | 52 | 2012-06-26T21:03:38+00:00 | 0 | JoelGutierrezG | |
627476459 | Alina Fichter | Head of Digital Format Development at @DeutscheWelle, Advisory Board @Newsguardrating. 👉🏼User Centric Formats, Digital Transformation, Fighting Disinformation | Berlin, Deutschland | http://www.dw.com | https://twitter.com/fichtalina | jsk-fellows2017 | 3286 | 2012-07-05T15:30:06+00:00 | 0 | fichtalina |
749768262 | Akoto Ofori-Atta | managing editor @teamtrace. @jskstanford 2014-2015/for life. BK/NJ/Ghana. | Brooklyn, NY | https://twitter.com/KO_616 | jsk-fellows2015 | 3289 | 2012-08-10T17:50:25+00:00 | 1 | KO_616 | |
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 | https://twitter.com/NatashaZouves | jsk-fellows-2020 | 14961 | 2012-08-23T19:30:23+00:00 | 0 | NatashaZouves | |
798978222 | Alvin Bessent | newsday editorial writer and columnist | https://twitter.com/alvin_bessent | jsk-fellows1998 | 14 | 2012-09-02T20:23:24+00:00 | 0 | alvin_bessent | ||
860166914 | Tandemvines Media | Denise Clifton develops stories & writes for organizations like @projectfeast & @alaskaair. Always exploring stories behind food. (Book: Tables From The Rubble) | Seattle | https://www.tandemvines.com/ | https://twitter.com/Tandemvines | jsk-fellows2005 | 230 | 2012-10-03T18:46:41+00:00 | 0 | Tandemvines |
908496738 | Deepa Fernandes | Journalist, global & local, @kcrw @TheWorld. Fellow at Pacific Oaks College. I report about women, kids, migrants, the environment. Alum @jskstanford @IWMF. | California, USA | http://deepafernandes.com/ | https://twitter.com/deepafern | jsk-fellows2012 | 3062 | 2012-10-27T16:58:11+00:00 | 0 | deepafern |
1003951466 | Slawomir Zagorski | https://twitter.com/SlawomirZagorsk | jsk-fellows1997 | 32 | 2012-12-11T12:35:36+00:00 | 0 | SlawomirZagorsk | |||
1169981785 | Mike Stanton | UConn journalism professor. Boston Globe Spotlight Fellow. Bestselling author, The Prince of Providence & Unbeaten. Pulitzer. @NewhouseSU & @MedillSchool alum. | Rhode Island & Connecticut | https://twitter.com/projomike | jsk-fellows1996 | 4220 | 2013-02-11T20:38:09+00:00 | 0 | projomike | |
1171581110 | Motunrayo Alaka | Intentional|Media+Leadership+Development| ED/CEO @WSoyinkaCentre| UNAD | UNILAG | Fellow @StanfordCDDRL and @JSKstanford| Nehemiah 4:6 | http://wscij.org | https://twitter.com/D_Encourager | 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 | https://twitter.com/MLillyDelgado | jsk-fellows2013 | 11163 | 2013-03-02T20:33:19+00:00 | 0 | MLillyDelgado | |
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 |
1370570863 | Sacha Pfeiffer | @NPR reporter. Former reporter for @BostonGlobe & @GlobeSpotlight. Former @WBUR host & reporter. @JSKStanford fellow. @SpotlightMovie fan. spfeiffer@npr.org | Boston, MA | https://www.npr.org/people/676406186/sacha-pfeiffer | https://twitter.com/SachaPfeiffer | jsk-fellows2005 | 18502 | 2013-04-21T20:54:15+00:00 | 1 | SachaPfeiffer |
1370927040 | Alfredo Molano B | 🕊🇨🇴 Comisionado de la Verdad 💚 Sociólogo UN, periodista y cronista 🕯 [1944 - 2019] Cuenta en Homenaje al Maestro. | Colombia Rural | https://twitter.com/AlfredoMolanoB | jsk-fellows2002 | 30206 | 2013-04-22T01:10:33+00:00 | 0 | AlfredoMolanoB | |
1379368854 | Peter Bahemuka | Keenly interested in media, communications, human rights, politics, business, international affairs, literature, film, music, sports, nature, history and travel | Kampala, Uganda | https://twitter.com/PietroBahemuka | jsk-fellows1998 | 274 | 2013-04-25T12:47:22+00:00 | 0 | PietroBahemuka | |
1522716182 | Sarah T. Williams | https://twitter.com/sarahtwilliams1 | jsk-fellows2000 | 32 | 2013-06-16T17:16:34+00:00 | 0 | sarahtwilliams1 | |||
1548898596 | Eric Westervelt | @NPR journalist. Recovering foreign correspondent. Occasional host. Musician by moonlight http://SecureDrop.npr.org/ http://SeeDisclaimer.com | San Francisco, CA | https://www.npr.org/people/2101350/eric-westervelt | https://twitter.com/Ericnpr | jsk-fellows2013 | 4897 | 2013-06-26T19:27:15+00:00 | 1 | Ericnpr |
1604288388 | Samaruddin Stewart | Countering Disinformation @StateDept | Priors: @Journalism_360 & @ONA, Media + Tech @spj_tweets with @GoogleNewsInit, @knightfdn Grantee, @JSKStanford Fellow.. | SF Bay Area | http://www.linkedin.com/in/samaruddin/ | https://twitter.com/samsends | jsk-fellows2013 | 1222 | 2013-07-18T20:50:38+00:00 | 0 | samsends |
1892710843 | Rita Neubauer | https://twitter.com/ritaneubauer | 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 | https://twitter.com/Catanify | jsk-fellows2004 | 1859 | 2013-10-22T16:47:07+00:00 | 0 | Catanify | |
2199658388 | Oleksandr Akymenko | Entrepreneur, design-thinking consultant, @Stanford @JSKstanford Fellow 2015/16. Publisher at @Platfor_ma. Ex-head of investigative department at Forbes Ukraine | Kyiv, Ukraine | http://platfor.ma/ | https://twitter.com/akymenko_o | jsk-fellows2016 | 804 | 2013-11-17T14:58:16+00:00 | 0 | akymenko_o |
2281026164 | Clara G Sueyro | Currently http://alpha.ca.gov. Formerly founder Jobs to be Researched LLC, 2017 Fellow @JSKstanford 2014 Fellow @codeforamerica | Sacramento, CA | http://claraslist.com | https://twitter.com/claragsueyro | jsk-fellows2017 | 502 | 2014-01-07T18:53:13+00:00 | 0 | claragsueyro |
2317636063 | liza osetinskaya | Russian journalist, editor, media manager. interested in Russian politics, digital media, perfect journalism. Stanford Jsk knight fellow 2017 | Palo Alto, CA | https://twitter.com/osetinskayaliza | jsk-fellows2017 | 3368 | 2014-01-29T18:50:40+00:00 | 0 | osetinskayaliza | |
2373280040 | 堀江広美 | Bloomberg News東京支局記者・編集者/JBN Finance&Credit TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解 | https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie | https://twitter.com/HiromiSHorie | jsk-fellows1996 | 1602 | 2014-03-05T06:33:39+00:00 | 1 | HiromiSHorie | |
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 | https://twitter.com/barbaramaseda | jsk-fellows-2018 | 1587 | 2014-06-16T15:33:22+00:00 | 0 | barbaramaseda |
2802357499 | Heather Dewar | https://twitter.com/heatherjodewar | jsk-fellows1993 | 20 | 2014-09-10T19:29:28+00:00 | 0 | heatherjodewar | |||
4083799919 | Joel Konopo | | Innovator | Investigative journalist @ink_cij 🇧🇼 | Father of three | @jskstanford Fellow 19 | | Botswana | http://www.inkjournalism.org | https://twitter.com/JKonopo | jsk-fellows-2019 | 2351 | 2015-10-31T16:47:56+00:00 | 0 | JKonopo |
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 | |
750919846330793984 | YooHee Hong | San Francisco, CA | http://ww.linkedin.com/in/yoohee-hong-6136b856 | https://twitter.com/YooHeeHong0916 | jsk-fellows2017 | 72 | 2016-07-07T05:10:17+00:00 | 0 | YooHeeHong0916 |
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;