jsk_fellows (view)

257 rows where verified = 0 sorted by location

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

verified ✖

id name description location ▼ url fellowship followers_count created_at verified screen_name
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
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
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
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
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
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
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
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
18231471 Andrew Finlayson EVP Digital/Social Strategy @SmithGeiger Helping storytellers on screens with research on 📺 OTT, video, SEO, website, mobile Author "Questions That Work" 👇 818-874-2000 http://questionswork.com jsk-fellows2010 1891 2008-12-19T01:49:46+00:00 0 questionswork
67942338 Musikilu Mojeed Editor-in-Chief/Chief Operating Officer -- @premiumtimesng; Co-Founder -- @ptcij; founder - @TheImoleProject; founder, @naijapolizwatch; member, @ICIJorg Abuja http://www.premiumtimesng.com jsk-fellows2013 2375 2009-08-22T17:53:27+00:00 0 Musikilu
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 jsk-fellows2010 7603 2008-08-24T07:42:34+00:00 0 justinarenstein
225293034 Damien is The Antichris Horne Publisher of The Devil Strip | JSK Fellow @ Stanford, 2019 | NAS CCF, 2018 | Makronite 💯 | Gave up Lent for bacon. | Retweets will not be televised Akron, Ohio http://TheDevilStrip.com/co-op jsk-fellows-2019 2753 2010-12-11T06:33:19+00:00 0 thischrishorne
48140747 Patricia Mercado S. Mujer, madre, periodista. En la búsqueda constante... Iniciando proyectos y caminos propios. Directora de @Conectmigrante Al lado de Carlos Miguel http://www.conexionmigrante.com jsk-fellows2007 4606 2009-06-17T22:21:43+00:00 0 Patmercado
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 jsk-fellows2011 1176 2008-04-29T20:21:00+00:00 0 michvinmar
10794392 Kathleen McCoy Good old dog Clare passed in May, 2014. Puppy arrived in August. Her name is Kiska. Anchorage   jsk-fellows2007 314 2007-12-02T21:45:12+00:00 0 kjmccoy
19041319 Peter H. Lewis Reporter, Asheville Watchdog http://avlwatchdog.org. Noble Prize-nominated writer, Enemy of the People, ex NYT. Asheville, NC http://www.peterlewis.com jsk-fellows2010 1933 2009-01-15T22:01:05+00:00 0 peterhlewis
243693135 Armando Rivarola Periodista, jefe de redacción adjunto del diario ABC Color de Paraguay. Asunción, Paraguay   jsk-fellows2003 1082 2011-01-27T16:19:17+00:00 0 arivarola
1246761 Cindy Royal Professor at TX State, teaching Web design, coding & digital product concepts. ‘13-‘14 JSK Fellow at Stanford. Live in Austin, loved live music, when we had it. Austin, TX http://www.cindyroyal.com jsk-fellows2014 6563 2007-03-15T20:58:07+00:00 0 CindyRoyal
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
17027157 Juan Castillo Editorial Page Editor at the Austin American-Statesman. Austin, TX, USA   jsk-fellows2003 1101 2008-10-28T19:42:55+00:00 0 JuanCastilloAAS
144661304 Janine Perrett Proud journo for 40 years. Now more than ever. Australia   jsk-fellows2008 9554 2010-05-16T23:58:51+00:00 0 PerrettReport
101610491 Joan Úbeda Factual TV and documentary producer Barcelona http://blogerocasional.blogspot.com.es jsk-fellows1999 1486 2010-01-04T00:22:02+00:00 0 joanubeda
20951229 Mary Aviles But first, the facts. Bay Area   jsk-fellows2013 982 2009-02-16T00:45:08+00:00 0 Avilesm
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
28292957 HuShuli | 胡舒立 《财经》杂志主编 Editor,Caijing Beijing http://www.caijing.com.cn jsk-fellows1995 18545 2009-04-02T06:11:41+00:00 0 HuShuli
19086179 Babak Dehghanpisheh Senior correspondent at Thomson Reuters. Opinions are my own. Beirut   jsk-fellows2009 5592 2009-01-16T21:21:08+00:00 0 BabakDehghan
16018986 Brian EdwardsTiekert Co-Host, UpFront 7-9am @kpfa | Environment, Politics, Housing, Police, CA & SFBay | @CWAUnion | Fmr @JSKStanford | he/him Berkeley, CA http://www.kpfa.org jsk-fellows2017 3423 2008-08-27T22:55:11+00:00 0 bedwardstiek
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
86129676 Alfonso Cuéllar Araújo Politólogo | Periodista | Diplomático | Columnista de Semana Bogotá, D.C., Colombia   jsk-fellows2010 2356 2009-10-29T18:23:11+00:00 0 ACuellarAraujo
82422512 AlexBeam Early Twitter non-adopter, journalist, author and so on Boston   jsk-fellows1997 1650 2009-10-14T18:22:51+00:00 0 imalexbeamyrnot
234387786 Maria Speck ❤️ Whole ancient grains 🌾 Winner Julia Child + M.F.K Fisher cookbook awards 🎉 for 📚: SIMPLY ANCIENT GRAINS and 🌻ANCIENT GRAINS FOR MODERN MEALS Boston http://www.MariaSpeck.com jsk-fellows1994 3857 2011-01-05T14:52:25+00:00 0 MariaSpeck
48068105 Beth Daley Editor and General Manager @ConversationUS. Proud alum of @InsideClimate, @NECIRBU, @BostonGlobe, @JSKStanford. Boston, MA https://theconversation.com/us jsk-fellows2012 3327 2009-06-17T18:49:40+00:00 0 BethBDaley
63125158 Alex Beam This is a Twitter bot. The real Alex Beam, distinguished Boston Globe writer and squash enthusiast, is found at @ImAlexBeamYrNot Boston, MA http://bostonglobe.com/staff/beam jsk-fellows1997 518 2009-08-05T13:02:51+00:00 0 GlobeAlexBeam
230879206 Sean P. Murphy Reporter @Boston Globe, Suffolk University journalism professor, regular on the Red Line Boston, MA http://bostonglobe.com jsk-fellows2000 1407 2010-12-27T00:02:17+00:00 0 spmurphyboston
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
85507898 Christine Larson Exuberantly curious. Assistant Professor of Journalism at University of Colorado, Boulder. Mother of (twin teenage) Dragons. Boulder, CO http://www.christinelarson.com jsk-fellows2010 766 2009-10-27T05:52:33+00:00 0 LarsonWrites
224059040 Sheila Kaplan Prohibited disclosure NY student contact info/DOB/birthplace/+ w/w out consent via CPO & regs. Now alarmed by @privacyforum directory info findings; work ahead Brooklyn NY https://www.worldprivacyforum.org/2020/04/without-consent/ jsk-fellows2002 1855 2010-12-08T01:43:54+00:00 0 SheilaLKaplan
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 jsk-fellows2012 793 2010-10-08T14:02:56+00:00 0 katywnewton
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
111183422 Heather Bryant The future of journalism is collaborative. Partnerships not parachutes. Journalism For & With. Read Curiously. @ProjectFacet @newscatalyst @wellreadio she/her CA | AK http://www.hbcompass.io/ jsk-fellows2017 5788 2010-02-04T02:08:38+00:00 0 HBCompass
3219 Phillip Smith My passion is helping: 💰 1. Newsrooms make more money; 📈 2. News startups grow their audience; 🔥 3. Journalists succeed as entrepreneurs. Let's talk 📩 California https://journalismentrepreneurship.com jsk-fellows-2018 5156 2006-07-27T02:33:10+00:00 0 phillipadsmith
54331654 Anh Hoà TRUONG Innovation Project Leader, VR Journalist, Science Writer, 2015 JSK Fellow at Stanford. Based in Cali. Born in France. Good food / good company lover. California http://vr-journalism.tumblr.com/ jsk-fellows2015 335 2009-07-06T21:01:51+00:00 0 AnhhoaTruong
14370540 jeremyhay Journalist, entrepreneur, JSK Stanford fellow '15 California, USA http://www.jeremyhay.com jsk-fellows2015 897 2008-04-12T19:21:05+00:00 0 jeremyhay
24346858 J. Mariani-Belding Writer. Communicator. Marketer. Lover of good wine and cheese. Living my best life, with gratitude. California, USA   jsk-fellows2003 30 2009-03-14T08:10:36+00:00 0 jmbelding
56245064 Stephen Magagnini independent journalist covering ethnic affairs, race relations, immigration, tribal affairs, faith issues and human rights California, USA http://sacbee.com jsk-fellows2002 1124 2009-07-13T01:12:53+00:00 0 SteveMagagnini
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
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
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
14947379 Tran Ha Easy problems are no fun // On a break from Twitter // Find me on IG // Frmr: @stanforddschool @jskstanford @redeyechicago Chicago   jsk-fellows2014 2472 2008-05-29T19:50:13+00:00 0 tranosaurus
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 jsk-fellows-2020 1587 2008-10-27T15:51:18+00:00 0 matt_kiefer
21783956 gary marx Chicago Tribune investigative reporter. Chicago http://trib.in/2aLM20k jsk-fellows2002 2139 2009-02-24T19:09:20+00:00 0 garyjmarx
8119452 💀 damned sinker 💀 I did http://impeachment.fyi. Co-host of @sayswhopodcast, formerly @opennews, author of @MayorEmanuel, founder of Punk Planet (RIP), #1 Candle King of Kickstarter Chicago, IL http://dansinker.com jsk-fellows2008 28430 2007-08-11T05:51:44+00:00 0 dansinker
197940788 Kelly Scott Writer, editor, political obsessive, arts & culture enthusiast and @Dodgers fan. Proud mom of @DevinMitchell, @sc_mitchell. Chicago, IL   jsk-fellows2004 1407 2010-10-02T22:13:14+00:00 0 kscottAtLarge
21022307 Barbara Brotman Writer, hiker, former Chicago Tribune columnist, current freelancer. I love swimming, hug trees and wish Chicago had mountains. Chicago, Ill. http://archives.chicagotribune.com/writers/barbara-brotman jsk-fellows2004 999 2009-02-16T20:19:59+00:00 0 BarbaraBrotman
108360053 Judith Torrea Independent reporter & blogger covering drug trafficking, femicides and immigration issues in my lovely Juaritos. Author of Juárez en la sombra (Aguilar) Ciudad Juárez http://juarezenlasombra.blogspot.com/ jsk-fellows2012 7134 2010-01-25T18:04:19+00:00 0 Judithtorrea
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
197544399 Pete McBride Photographer, Writer, Filmmaker. Advocate of Wild Places. Lover of mountains, glassy waves, and spicy living. Colorado - or road http://www.petemcbride.com jsk-fellows2007 2706 2010-10-01T19:53:37+00:00 0 photogpedro
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
240349448 Sarah Alvarez Journalist and founder/editor of Outlier Media. Profile photo by MacArthur Genius/Chicana extraordinaire Maria Varela, more:http://bit.ly/2RqcqAs Detroit, MI http://outliermedia.org jsk-fellows2016 2658 2011-01-19T18:33:03+00:00 0 sarahalvarezMI
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
14766481 RODRIGOCARPIO   Fort Lauderdale, FL, USA http://www.zajorynproductions.com jsk-fellows1997 60 2008-05-13T23:45:17+00:00 0 zajoryn
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   jsk-fellows2010 400 2009-06-16T11:19:44+00:00 0 marcusherbert
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
234926815 Stephen Proctor Managing Editor, Houston Chronicle, golfer, golf historian Houston, TX http://chron.com jsk-fellows1999 590 2011-01-06T22:44:27+00:00 0 stephenrproctor
365973699 Azmat Abbas   Islamabad   jsk-fellows2004 73 2011-09-01T10:34:49+00:00 0 Azmat_Abbas
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

Next page

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