jsk_fellows (view)

365 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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 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   jsk-fellows2006 3401 2011-04-12T15:17:07+00:00 0 MaryPols
284593852 William McNulty   Santa Cruz CA   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 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 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 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 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 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 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 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 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 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/ 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 jsk-fellows1996 918 2011-08-03T17:50:27+00:00 0 0212crd
365973699 Azmat Abbas   Islamabad   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 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/ 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 jsk-fellows2016 3111 2011-09-29T14:36:21+00:00 0 MaierAstrid
386183180 Girma T Fantaye       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 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 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 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 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 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/ 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 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 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   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 jsk-fellows-2020 1591 2012-03-11T04:04:01+00:00 0 village_scribe
531407250 Andrew Zajac Legal reporter for Bloomberg News Washington DC   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 jsk-fellows1999 167 2012-03-26T09:40:10+00:00 0 lindagradstein
555484188 Elizabeth Dalziel photographer specializing in everything London http://www.elizabethdalziel.com jsk-fellows2008 435 2012-04-16T20:30:47+00:00 0 edalziel
556757858 Arif Elsaui journalist -media consultant-freelancer -kenya \Nairobi Kenya-Nairobi   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 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     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 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   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 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   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 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
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/ 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/ jsk-fellows2012 3062 2012-10-27T16:58:11+00:00 0 deepafern
1003951466 Slawomir Zagorski       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   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 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
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 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 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   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   jsk-fellows1998 274 2013-04-25T12:47:22+00:00 0 PietroBahemuka
1522716182 Sarah T. Williams       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 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/ jsk-fellows2013 1222 2013-07-18T20:50:38+00:00 0 samsends
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
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/ 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 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   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 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 jsk-fellows-2018 1587 2014-06-16T15:33:22+00:00 0 barbaramaseda
2802357499 Heather Dewar       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 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 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 jsk-fellows2017 72 2016-07-07T05:10:17+00:00 0 YooHeeHong0916

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