jsk_fellows (view)

365 rows sorted by description

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: verified

id name description ▼ location url fellowship followers_count created_at verified screen_name
14766481 RODRIGOCARPIO   Fort Lauderdale, FL, USA http://www.zajorynproductions.com jsk-fellows1997 60 2008-05-13T23:45:17+00:00 0 zajoryn
15607854 MarshaMcFadden   ÜT: 21.339917,-157.925875   jsk-fellows1995 228 2008-07-26T04:50:00+00:00 0 marshamcfadden
15900236 Harriet A.Washington   New York City, Las Vegas, NV   jsk-fellows1998 5650 2008-08-19T03:44:42+00:00 0 haw95
17787248 Richard Gonzales NPR       jsk-fellows1995 228 2008-12-01T19:55:08+00:00 0 RichardGonzalesNPR
19528008 sergey kuznetsov       jsk-fellows2002 787 2009-01-26T10:35:31+00:00 0 skuzn
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
20932059 Imtiaz Ali   Peshawar -- Washington D.C   jsk-fellows2007 681 2009-02-15T19:51:32+00:00 0 imtiaz999
23757441 Hugo Rupert   stanford U   jsk-fellows2011 90 2009-03-11T12:50:26+00:00 0 hugorupert
28293072 who   Kowloon City District   jsk-fellows1995 6203 2009-04-02T06:12:42+00:00 0 who_blgw2017
29932001 Barbara E. Allen   Stanford!   jsk-fellows2013 269 2009-04-09T05:47:18+00:00 0 BA1245
30117765 Marcelo Rubens Paiva     http://blog.estadao.com.br/blog/marcelorubenspaiva/ jsk-fellows1995 829946 2009-04-10T01:14:01+00:00 1 marcelorubens
40381878 Kim Komenich   Mill Valley, CA http://kimkom.com jsk-fellows1994 107 2009-05-16T01:35:04+00:00 0 kimkom
41007644 Matthew B. Stannard       jsk-fellows2008 16 2009-05-19T00:11:54+00:00 0 MBStannard
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
86097492 jo-ann armao       jsk-fellows2006 178 2009-10-29T15:52:11+00:00 0 armaoj
115359136 Andrew Losowsky   New York, NY   jsk-fellows2014 8023 2010-02-18T12:03:16+00:00 1 losowsky
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
284593852 William McNulty   Santa Cruz CA   jsk-fellows2013 469 2011-04-19T15:40:58+00:00 0 wemcn
365973699 Azmat Abbas   Islamabad   jsk-fellows2004 73 2011-09-01T10:34:49+00:00 0 Azmat_Abbas
386183180 Girma T Fantaye       jsk-fellows2012 1229 2011-10-06T20:15:31+00:00 0 Girmatf
1003951466 Slawomir Zagorski       jsk-fellows1997 32 2012-12-11T12:35:36+00:00 0 SlawomirZagorsk
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
2802357499 Heather Dewar       jsk-fellows1993 20 2014-09-10T19:29:28+00:00 0 heatherjodewar
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
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
6423572 Tom Van de Weghe #AI strategist @VRT & #deepfakes expert | Research Fellow @Stanford | Investigative journalist | former Correspondent & Bureau Chief 🇺🇸&🇨🇳 | Author+Speaker Stanford, CA https://www.linkedin.com/in/tomvandeweghe jsk-fellows-2019 26058 2007-05-29T20:01:06+00:00 1 tomvandeweghe
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
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
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
21901213 Paddy Hirsch ...... ..... http://www.paddyhirsch.com jsk-fellows2011 7337 2009-02-25T18:49:06+00:00 1 paddyhirsch
70574113 Djordje Padejski @JSKStanford Associate Director, investigative/data journalist, @ICIJorg member, @FOIAMACHINE founder, alum: @CIRonline @OCCRP @CINSerbia Stanford, CA http://jsk.stanford.edu jsk-fellows2012 2197 2009-09-01T02:29:07+00:00 1 djordjepadejski
41653397 Anna Gielewska @JSKstanford Fellow20 | Vice-chairman @FReporterow |@vsquare_project | Political and investigative journalist, focused on countering disinformation. Warsaw, Poland   jsk-fellows-2020 7288 2009-05-21T19:10:06+00:00 0 agielewska
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
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
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
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
16700673 Rock’em Sock’em Rosie @WPR, @JSKstanford ‘18, public radio fanatic, often on eight wheels. Madison, WI   jsk-fellows-2018 434 2008-10-11T21:50:07+00:00 0 jenniferdargan
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
180388029 agg @spaceship_media problem solver. journalist. designer. lover of high x-heights. favorite color: CMYK. JSK ‘17 Space   jsk-fellows2017 334 2010-08-19T14:25:49+00:00 0 iamlaggr
14743741 federica bianchi A European storyteller fascinated by International Affairs and economic trends Rome   jsk-fellows2009 1030 2008-05-12T13:18:08+00:00 0 federicabianchi
17272464 aaronhuey Aaron Huey is a National Geographic photographer, a Stanford http://d.School Global Ambassador, and the father of Hawkeye and Juno. Seattle http://www.aaronhuey.com jsk-fellows2012 3683 2008-11-09T19:11:32+00:00 0 aaronhuey
33964434 Donna Borak Adjunct Faculty @NYU. Senior Economics Journalist. Alum of @CNN @WSJ @AP @AmerBanker and @UPI. 2015 JSK @Stanford Fellow. Yoga teacher. 🧘‍♀️ Globetrotter. Washington   jsk-fellows2015 5956 2009-04-21T17:00:53+00:00 1 donnaborak
6827702 André Natta Always: Urban conversationalist. Bronx native. 2018 @JSKStanford Fellow. Past: @resolvephilly @lenfestlab @wbhm @bhamterminal @Poynter #wjchat. Love ⚾. Birmingham, AL https://acnatta.substack.com/ jsk-fellows-2018 4233 2007-06-15T06:50:32+00:00 1 acnatta
46518958 Chloe Veltman Arts & Culture Reporter at @KQED San Francisco, CA http://www.chloeveltman.com jsk-fellows2012 2187 2009-06-11T23:14:41+00:00 0 chloeveltman
15587316 JocelynNoveckAP Associated Press national culture and feature writer NYC   jsk-fellows1996 867 2008-07-24T19:25:41+00:00 0 JocelynNoveckAP
7809252 wendy norris Asst Prof @NazarethCollege exploring socially intelligent computing in humanitarian crisis response | @JSKStanford + @cuinfoscience alum | @PeaceCorps Vanuatu Rochester, NY http://wendynorris.com jsk-fellows2011 3121 2007-07-30T03:13:25+00:00 0 WendyNorris
19244373 Tom Davidson Attempting to invent the future of media without blowing up Beeker in the process. Opinions here are mine, not those of employers past, present or future. SEVa, Tysons Corner, and I-95 http://tgdavidson.com jsk-fellows1999 845 2009-01-20T16:47:45+00:00 0 tgdavidson
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
76971595 Dickens Olewe BBC journo @JSKStanford journalism fellow. Media. Tech. Politics. I have a podcast. Kenya is home. London http://www.dickensolewe.com jsk-fellows2015 4646 2009-09-24T15:54:14+00:00 0 DickensOlewe
19257632 Scarin’ Foley 🎃 Black Media Initiative director @CCMNewmarkJ | priors @jskstanford '20, @cityofdetroit storyteller | ✊🏽🏳️‍🌈 | books @belt_publishing | email 👍🏽, DMs 👎🏽 NY borough/Detroit thorough http://www.aaronkfoley.com jsk-fellows-2020 6808 2009-01-20T21:10:41+00:00 0 aaronkfoley
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
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
17033026 Gabriela Mafort Branded Content and Video Branding Consultant. Rio de Janeiro, Brazil http://about.me/gmafort jsk-fellows2011 453 2008-10-29T01:22:33+00:00 0 gmafort
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
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
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
20951229 Mary Aviles But first, the facts. Bay Area   jsk-fellows2013 982 2009-02-16T00:45:08+00:00 0 Avilesm
44911552 Mariana Santos CEO @poderosaschicas Stanford @JSK Fellow @KnightFoundation Innovation Chair @FIU @ICFJKnight @guardian swim & surf Rio de Janeiro, Brazil https://about.me/mariana.santos jsk-fellows2015 7628 2009-06-05T15:07:34+00:00 0 marysaints
197220475 Madhu Acharya CEO @sharecastNP; @JSKstanford Fellow (2010-11). madhu@sharecast.org.np http://www.sharecast.org.np jsk-fellows2011 5262 2010-09-30T23:12:28+00:00 0 Madhu2067
43767782 Elodie MaillietStorm CEO at CatchLight. Los Gatos, CA   jsk-fellows2017 619 2009-05-31T22:18:52+00:00 0 elodiemailliet
15315979 Carolina Guerrero CEO of @NPR's @RadioAmbulante + @elhilopodcast. Breaking the language barrier with @LupaApp. @JSKStanford Fellow. Personal Assistant to León & Eliseo. New York, NY http://radioambulante.org jsk-fellows2015 15419 2008-07-04T07:42:02+00:00 0 nuncaduermo
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
2241921 Pamela Chen 🙋🏻‍♀️🤦🏻‍♀️ Camera & Photos @apple, curious at heart. 2020 @JSKStanford-@StanfordHAI Fellow, board @magnumfnd, alumna @instagram @natgeo @opensociety ☁️ Stanford, CA https://stanford.io/2O6sojp jsk-fellows-2020 13155 2007-03-26T02:40:05+00:00 0 pc
13371202 john temple Chairman and Co-founder, Amuse Labs San Francisco, CA https://amuselabs.com/ jsk-fellows2014 3168 2008-02-12T01:13:01+00:00 0 jtemplejrnalist
21783956 gary marx Chicago Tribune investigative reporter. Chicago http://trib.in/2aLM20k jsk-fellows2002 2139 2009-02-24T19:09:20+00:00 0 garyjmarx
112265447 Kristen "you're on mute" Muller Chief Content Officer @KPCC @LAist. Fan of the First Amendment & Arnold Palmers. http://kpcc.org & http://laist.com Pasadena, CA http://www.kpcc.org jsk-fellows2016 2913 2010-02-07T21:17:58+00:00 0 KrisMul
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
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
8956962 Kirk Caraway Co-founder Megafone/NowAds, 2012-13 John S. Knight Fellow at Stanford University, online news entrepreneur http://GetMegafone.biz http://NowAds.biz jsk-fellows2013 270 2007-09-18T18:11:50+00:00 0 kirkcaraway
184814522 Lisa Rossi Co-founder: Bonfire Strategy. Delivering powerful experiences to spur creative ideas that resonate. Passionate about: Building stronger teams and communities. Des Moines, IA   jsk-fellows-2018 2060 2010-08-30T15:09:19+00:00 1 LisaARossi
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
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
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
119341695 Cordelia Hebblethwaite Commissioning editor for @bbcideas  -  short films for curious minds http://bbc.co.uk/ideas💡 Via @BBCNewsnight, @JSKStanford, @BBCWorldService etc Oxfordshire, UK http://socialmediareporter.org jsk-fellows2015 3364 2010-03-03T10:33:05+00:00 0 CordeliaHeb
15751494 Roberta Oster Communications Director for @vainterfaith. Advocating economic, racial & environmental justice. Former TV news producer. tweets are my own. Richmond, Virginia http://www.robertaoster.com jsk-fellows1998 405 2008-08-06T15:57:15+00:00 0 robertaoster
67227724 Gabriel Spitzer Communications Specialist @KCPubHealth, Science writer. Fmr @KNKXfm @JSKstanford @WBEZ. Seattle, WA http://www.transmissionpodcast.org jsk-fellows2017 1999 2009-08-20T04:28:57+00:00 1 gabrielspitzer
186997686 DjurdjaPadejski Communications at @StanfordPACS/@DigCivSoc, ex @StanfordCDDRL. Bilingual tweets, my own, not my org’s. Palo Alto, CA   jsk-fellows2012 1331 2010-09-05T00:14:13+00:00 0 DjurdjaPadejski
14381600 Tracie Powell Connector. Change maker. Founder. Passionate about all things digital & media. Program Officer, Borealis Philanthropy & 2016 JSK Fellow. RT ≠ endorsement Washington, DC http://www.alldigitocracy.org jsk-fellows2016 3059 2008-04-14T05:29:35+00:00 0 TMPowell
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
32129142 Carol Rosenberg Covers Guantánamo, the place, policy, people and war court for The New York Times with the generous support of the Pulitzer Center. USA https://www.nytimes.com/by/carol-rosenberg jsk-fellows1995 35166 2009-04-16T19:52:21+00:00 1 carolrosenberg
101255581 Theo Stein Cranky Yankee besotted by the West. Lafayette, Colo.   jsk-fellows2000 116 2010-01-02T16:13:01+00:00 0 theoestein
12497 Simon Willison Creator of @datasetteproj, co-creator Django. Fellow at @JSKstanford. Collector of @nichemuseums. Usually hanging out with @natbat and @cleopaws. He/Him San Francisco, CA https://simonwillison.net/ jsk-fellows-2020 21461 2006-11-15T13:18:50+00:00 1 simonw
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
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
14478614 Jeff Elder Cybersecurity reporter for Business Insider. DMs open for news tips, or email jelder@businessinsider dot com. Signal 4157999085 San Francisco, CA https://www.businessinsider.com/author/jeff-elder jsk-fellows2009 87727 2008-04-22T18:54:22+00:00 1 JeffElder
29006114 Latoya Peterson Cyborg // Goddess // Storyteller //Technologist. Cofounder/CXO ✨@GlowUpGames✨Making: @InsecureGame Always: @Racialicious. @Techstars '20. Chillin on Clubhouse Quarantined http://glowup.games/ jsk-fellows2013 15237 2009-04-05T15:45:34+00:00 1 LatoyaPeterson
9443532 Rick Attig Dad, Writer and Journalist Portland, Oregon   jsk-fellows2008 181 2007-10-14T21:35:46+00:00 0 Rickattig
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
17677665 Geoff McGhee Data vis & multimedia journalism, variously @TheWaterDesk @WestCenter. Former @jskstanford, @lemondefr, @nytimes, @NatGeo My opinions only. Seattle http://www.geoffmcghee.com jsk-fellows2010 3119 2008-11-27T13:26:22+00:00 0 mcgeoff
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
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
14985683 Jigar Mehta Deputy Managing Director of @dohadebates. A new project to inspire solutions to global challenges through civil discourse and debate. New York, USA http://dohadebates.com jsk-fellows2011 3619 2008-06-02T21:53:47+00:00 1 jigarmehta
19727405 Michael Lindenberger Deputy Opinion Editor at Houston Chronicle | Ex: DC correspondent & edit board @dallasnews | ‘13 @jskstanford | @LouisvilleLaw grad | @Time @TNR Dallas, TX http://about.me/lindenberger jsk-fellows2013 2410 2009-01-29T19:11:06+00:00 1 Lindenberger
14699813 Zena Barakat Design director @ideo San Francisco, CA   jsk-fellows2015 2996 2008-05-08T12:55:09+00:00 1 zena_b
225505935 Subbu Despite all the jargon you hear, democratizing journalism and social media are part of the same journey. @jmethics. Book chapter: https://bit.ly/3m1ikb7 SF Bay Area, CA https://www.scu.edu/ethics/about-the-center/people/subramaniam-vincent/ jsk-fellows2016 1537 2010-12-11T18:51:16+00:00 0 subbuvincent

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