jsk_fellows (view)

365 rows sorted by fellowship

✎ View and edit SQL

This data as json, CSV (advanced)

verified ✖

  • 0 257
  • 1 108
id name description location url fellowship ▼ followers_count created_at verified screen_name
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
16672162 Veronica Flores-Paniagua External Affairs Advisor @Chevron, ex-journo, #energy & #education policy junkie; @UHouston-ex; #runner; 2000 @JSKStanford fellow. RT ≠ endorsement iPhone: 29.463654,-98.473572 http://www.chevron.com jsk-fellows2000 3951 2008-10-09T19:37:34+00:00 1 vxflores
17018840 Kevin Sullivan Washington Post Senior Correspondent. Author, with Mary Jordan, of 'Trump on Trial.' Out 8/25/2020. Pre-orders now! Washington DC http://washingtonpost.com jsk-fellows2000 4364 2008-10-28T10:42:23+00:00 1 sullivank
17455049 George Haj President, @hajmediainc, a strategic communications firm. Recovering journalist. Former @miamiherald, @jskstanford, @ALMMedia, @houstonchron   http://hajmedia.com jsk-fellows2000 3070 2008-11-18T00:57:30+00:00 1 georgehaj
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 jsk-fellows2000 1142 2009-09-27T21:48:12+00:00 0 kathellison
101255581 Theo Stein Cranky Yankee besotted by the West. Lafayette, Colo.   jsk-fellows2000 116 2010-01-02T16:13:01+00:00 0 theoestein
118957609 Kim Norgaard CNN Johannesburg Bureau Johannesburg, South Africa http://www.cnn.com jsk-fellows2000 3971 2010-03-02T06:37:09+00:00 0 KimNorgaardCNN
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
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
13690462 Bonnie D. Ford http://ESPN.com storyteller. Proud Oberlin alum. Omnivorous reader, traveler, viewer & listener.     jsk-fellows2001 14857 2008-02-19T21:20:30+00:00 1 Bonnie_D_Ford
14769899 TimJohnson Former cybersecurity reporter at @McClatchyDC, frmr correspondent in Mexico, China. Part of 2017 Pulitzer Prize-winning team on Panama Papers Washington, DC http://www.mcclatchydc.com jsk-fellows2001 5240 2008-05-14T06:13:22+00:00 1 TimJohnson4
18149456 jerrylarge Seattle Times columnist. jlarge@seattletimes.com, Column interests: education, inequality, science and technology and interesting people. Seattle, WA   jsk-fellows2001 1349 2008-12-15T23:00:06+00:00 1 jerrylarge
19339650 Gini Sikes Standup Comic, Filmmaker, Journalist. Writer/Producer Equal Means Equal; Author 8Ball Chicks: A Year in the Violent World of Girl Gangs Los Angeles, CA   jsk-fellows2001 214 2009-01-22T14:18:01+00:00 0 8ballchicks
46514922 Jane Armstrong Digital producer, CBC Former Globe and Mail correspondent, Serena Williams fan Vancouver, B.C.   jsk-fellows2001 1083 2009-06-11T22:54:28+00:00 1 EJaneArmstrong
46676538 David Stabler Writer and teacher. Pianist. Cyclist. davidstabler1@gmail.com Portland, Oregon http://davidstabler.net jsk-fellows2001 1371 2009-06-12T15:36:05+00:00 0 davidstabler
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 jsk-fellows2001 6465 2009-08-31T01:27:28+00:00 1 mendozamartha
86112487 New American Nomads See what happens when two crazy “kids” quit their jobs, sell their house, dump their possessions and hit the road to see America in a fancy camper van. Scottsdale, Arizona http://www.newamericannomads.com jsk-fellows2001 49 2009-10-29T17:01:15+00:00 0 JudithNichols
1545741 Elizabeth Osder Media, Entertainment and Tech Executive... maker of real news... iPhone: 40.739487,-74.002266 http://www.osdergroup.com jsk-fellows2002 1127 2007-03-19T19:43:35+00:00 0 osder
14908497 luzmariahelguero Periodista, poeta, activista y deportista de remo. Fiel creyente en la democracia y la responsabilidad ciudadana. Peru   jsk-fellows2002 851 2008-05-26T12:33:00+00:00 0 luzmaria
19152977 Farai Chideya Creator/Host "Our Body Politic," about power and Black women/all women of color NYC and Globally http://farai.com/our-body-politic jsk-fellows2002 44762 2009-01-18T18:36:51+00:00 1 farai
19528008 sergey kuznetsov       jsk-fellows2002 787 2009-01-26T10:35:31+00:00 0 skuzn
21165536 james t. areddy jta formerly Shanghai http://www.suburbaphobia.com jsk-fellows2002 2840 2009-02-18T03:38:23+00:00 1 jamestareddy
21783956 gary marx Chicago Tribune investigative reporter. Chicago http://trib.in/2aLM20k jsk-fellows2002 2139 2009-02-24T19:09:20+00:00 0 garyjmarx
28113052 Beth Fouhy Senior editor, politics, NBC News and MSNBC New York, NY http://www.msnbc.com jsk-fellows2002 14638 2009-04-01T14:15:21+00:00 1 bfouhy
31303305 agnes cusack Journalist Melbourne http://www.newaustraliamedia.org jsk-fellows2002 108 2009-04-15T01:57:51+00:00 0 agnescusack
50379519 Sonni Efron President & COO, National Press Foundation. Journalism, foreign policy, democracy, human rights, technology, free expression, opinions my own, RTs not. Washington DC http://www.nationalpress.org jsk-fellows2002 410 2009-06-24T17:55:58+00:00 0 sonniefron
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
80089310 Andrew Lam #Lecturer, #journalist & #Author of Perfume Dreams: Reflections on the #Vietnamese Diaspora, East Eats West: Writing in Two Hemisphere, & Birds of Paradise Lost San Francisco http://www.huffingtonpost.com/andrew-lam/ jsk-fellows2002 1429 2009-10-05T18:19:44+00:00 1 andrewqlam
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
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
246041730 Serif Turgut Peace at Home, Peace in the World-Atatürk     jsk-fellows2002 23936 2011-02-02T00:36:54+00:00 0 Ljiljantr
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
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
22252782 Julie M. McCarthy National Public Radio Southeast Asia Correspondent. Currently Manila Bureau Chief. Any opinion expressed here is my own, and re-tweets are not endorsements. Southeast Asia http://www.npr.org jsk-fellows2003 4856 2009-02-28T13:03:53+00:00 1 JulieMcCarthyJM
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
23795899 Jim Walsh Mr. Brightside Minneapolis, MN   jsk-fellows2003 3132 2009-03-11T17:33:08+00:00 0 saintfabio
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
26334203 Andrew Maykuth Philadelphia Inquirer business reporter. I cover energy and gambling. Go figure. Philadelphia, Pa. http://www.philly.com jsk-fellows2003 2641 2009-03-24T21:52:53+00:00 1 Maykuth
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 jsk-fellows2003 1208 2009-04-21T10:48:03+00:00 0 jodiupton
60664050 Hannah Bloch @NPR lead international digital editor. Former WSJ Work in Progress columnist; TIME Pakistan & Afghanistan correspondent; National Geographic writer. Xenophile. Washington, DC   jsk-fellows2003 4034 2009-07-27T18:02:27+00:00 1 HannahBloch
66732477 Bonnie Jo Mount       jsk-fellows2003 118 2009-08-18T16:58:07+00:00 0 bonjomo
82976044 Jon Christensen Wrangling this and that @UCLAIoES, @LENSatUCLA, @LuskinCenter, @UCLA_DH, @Stamen, @LibertyHill, @KCET 'Earth Focus,' @LARiverParks, and beyond. UCLA http://christensenlab.net jsk-fellows2003 6213 2009-10-16T21:19:49+00:00 0 the_wrangler
144361718 Mainul Khan       jsk-fellows2003 98 2010-05-16T02:44:34+00:00 0 mainulislamkhan
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
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
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
14849874 Matt Crenson Opinions are my own. Facts belong to no one. Washington, DC   jsk-fellows2004 189 2008-05-20T23:21:58+00:00 0 mmcrenson
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   jsk-fellows2004 1468 2008-09-27T02:34:03+00:00 0 lkvarner
20632365 barbara roessner       jsk-fellows2004 20 2009-02-11T21:54:11+00:00 0 broessner
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
21404432 Eric Weiner NYT bestselling author. Wanderer. @NPR alum. My new book, THE SOCRATES EXPRESS, is out now! Washington, DC http://www.ericweinerbooks.com jsk-fellows2004 6707 2009-02-20T15:21:40+00:00 1 Eric_Weiner
49554368 Kay Johnson Reuters bureau chief for Thailand, Cambodia and Laos. RT = not endorsements, sometimes bookmarks. Asia   jsk-fellows2004 2483 2009-06-22T06:13:15+00:00 1 kayatrtrz
51893064 Pablo González Journalist. Former Bloomberg, Debtwire, 3 Puntos, Perfil, Pagina/12, Jornal do Brasil. Stanford Knight Fellow. UNC. Cordoba, Buenos Aires, Palo Alto, Sao Paulo. South America   jsk-fellows2004 2681 2009-06-29T00:16:32+00:00 1 Pablo_Rosendo
133891833 Mika Mäkeläinen Foreign news journalist at Finland's @yleuutiset. Ex-China & USA. @JSKstanford 2004. RT/like=FYI. Author of Kimlandia. http://facebook.com/Mikareport Finland http://yle.fi/uutiset/ jsk-fellows2004 5536 2010-04-16T22:49:20+00:00 1 Mikareport
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
253711352 Torsten Kjellstrand Torsten is a staff photographer at The Oregonian, where he makes photographs and videos. He likes snow more than rain. Portland, Oregon, USA http://oregonlive.com jsk-fellows2004 104 2011-02-17T20:26:16+00:00 0 otorsten
365973699 Azmat Abbas   Islamabad   jsk-fellows2004 73 2011-09-01T10:34:49+00:00 0 Azmat_Abbas
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
20846696 Tomasz Deptula       jsk-fellows2005 15 2009-02-14T13:27:41+00:00 0 tomekdep
26336913 Frances Robles I cover Puerto Rico, Central America, and file investigative reports from Florida and beyond for the @nytimes. https://www.nytimes.com/by/frances-robles?8qa Florida, USA http://www.nytimes.com/by/frances-robles jsk-fellows2005 23422 2009-03-24T22:05:08+00:00 1 FrancesRobles
43439375 Carlos Dada Periodista @_ElFaro_ La Libertad, El Salvador http://www.elfaro.net jsk-fellows2005 50917 2009-05-29T23:59:05+00:00 0 CarlosDada
44067999 Geri Migielicz Lorry I Lokey Professional of Journalism Practice Stanford University Graduate Program in Journalism Santa Cruz, Ca, USA http://story4.org jsk-fellows2005 319 2009-06-02T05:41:47+00:00 0 gmigielicz
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
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
164206121 Akaki Gogichaishvili       jsk-fellows2005 174 2010-07-08T08:49:13+00:00 0 BizCourier
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
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
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
16556482 Emily Harris Journalist with Reveal, from The Center for Investigative Reporting United States   jsk-fellows2006 1751 2008-10-02T07:07:28+00:00 1 emilygharris
17768092 carola fuentes Periodista, documentalista y socia de @laventanacine. Nuestro propósito: investigar, producir y difundir contenidos que generen impacto positivo en la audiencia chile http://www.laventanacine.com jsk-fellows2006 90026 2008-12-01T01:35:13+00:00 0 carolafuentes
18433533 Janet Rae-Dupree Freelance Unboxed Media writer covering innovation, emerging tech, science and more #Binders Silicon Valley http://www.linkedin.com/in/jraedupree jsk-fellows2006 2473 2008-12-28T20:25:40+00:00 0 jraedupree
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
46241234 Mike Swift Journalist at global crossroad of tech & law, focused on privacy, security. Chief Digital Risk Correspondent for @MLexclusive. Frmr @JSKStanford: swift@mlex.com Half Moon Bay, CA http://mlexmarketinsight.com/mike-swift/ jsk-fellows2006 6048 2009-06-10T22:14:58+00:00 1 Swiftstories
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/ jsk-fellows2006 4483 2009-09-09T19:26:27+00:00 0 ivanlpenn
86097492 jo-ann armao       jsk-fellows2006 178 2009-10-29T15:52:11+00:00 0 armaoj
163422349 inday espina varona journalist. gadabout. scarred cat. I stand by my tweets. Philippines http://indayvarona.wordpress.com/ jsk-fellows2006 31343 2010-07-06T11:18:02+00:00 1 indayevarona
174492304 Daniel Coronell Periodista.     jsk-fellows2006 1443731 2010-08-04T01:56:08+00:00 1 DCoronell
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
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
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
18197783 Leslie Casimir Freelance journalist San Francisco   jsk-fellows2007 48 2008-12-17T19:54:56+00:00 0 lcasimir
20253808 Andrea Bernstein Co-host Trump, Inc. podcast from @WNYC & @ProPublica; NYT best-selling author: AMERICAN OLIGARCHS: The Kushners, The Trumps, and the Marriage of Money and Power New York, NY http://AndreaBernsteinBook.com jsk-fellows2007 28333 2009-02-06T17:29:43+00:00 1 AndreaWNYC
20932059 Imtiaz Ali   Peshawar -- Washington D.C   jsk-fellows2007 681 2009-02-15T19:51:32+00:00 0 imtiaz999
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 jsk-fellows2007 1224 2009-04-24T03:08:16+00:00 1 justinegub
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
55273455 Christianne Gonzalez Online media consultant Silicon Valley http://www.brasilnewscom.com jsk-fellows2007 66 2009-07-09T15:52:45+00:00 0 brasilnewscom
96941094 Andrew M. Mwenda The Old Man of the Clan against common nonsense Kampala, Uganda http://independent.co.ug/andrewmwenda jsk-fellows2007 358504 2009-12-15T08:24:17+00:00 1 AndrewMwenda
139161166 Kevin Fagan Reporter at the San Francisco Chronicle. Specialties: Human interest, poverty & homelessness, breaking news, The American West. San Francisco Chronicle http://sfgate.com jsk-fellows2007 7436 2010-05-01T18:54:53+00:00 1 KevinChron
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
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
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
9443532 Rick Attig Dad, Writer and Journalist Portland, Oregon   jsk-fellows2008 181 2007-10-14T21:35:46+00:00 0 Rickattig
9486682 Ezequiel Abiú López Personal tweets by Ezequiel Abiú López. Executive Producer at Noticias SIN @SIN24Horas http://www.noticiassin.com and Foreign correspondent in the Dominican Republic. Santo Domingo   jsk-fellows2008 895 2007-10-16T21:38:33+00:00 0 Ezequiel_Abiu
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
17667060 Eric Pape Writer, editor, immersive storyteller. Ex-correspondent: @Newsweek, @Spin, @CivilBeat. Ex-contributor: @LATimes, @ForeignPolicy, @DailyBeast. Bylines: @NYT... Los Angeles, CA https://ericpape.journoportfolio.com/ jsk-fellows2008 1433 2008-11-27T02:30:32+00:00 1 ericpape
21538116 Helen Ubiñas Columnist. Welcome to my newsletter. Fact: There aren’t enough journalists of color in your local newsroom. Fact: No one is voiceless. Fact: This mic is mine. Philadelphia, PA http://www.philly.com/philly/columnists/helen_ubinas jsk-fellows2008 12072 2009-02-22T02:29:10+00:00 1 NotesFromHeL
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

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