jsk_fellows (view)

257 rows where verified = 0

✎ View and edit SQL

This data as json, CSV (advanced)

verified ✖

id name description location url fellowship followers_count created_at verified screen_name
254189881 Angelo Izama Ugandan Writer. Analyst at VRS|Blogger|Current Affairs|Calisthenics|Film is the Future Language. Kampala. Palo Alto. Abu Dhabi Kampala, Uganda http://angeloizama.com jsk-fellows2011 53936 2011-02-18T20:01:24+00:00 0 Opiaiya
254874238 Jorge R. Imbaquingo Periodista. Knight Fellow, Stanford University 2012. Editor de Política de @ElComerciocom. Mediaciones interactivas. Quito-Ecuador http://goo.gl/OBmUo1 jsk-fellows2012 3088 2011-02-20T05:28:42+00:00 0 jimbaquingo
259414535 Camille Seaman Polar Photographer. Storm Chaser, Explorer, mother, citizen of planet Earth Somewhere on Planet Earth http://www.camilleseaman.com jsk-fellows2014 2094 2011-03-01T21:37:18+00:00 0 CamilleSeaman
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
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
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
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
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
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
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
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
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
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 14.755ms · About: simonw/jsk-fellows-on-twitter