jsk_fellows (view)

257 rows where verified = 0 sorted by description

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
101255581 Theo Stein Cranky Yankee besotted by the West. Lafayette, Colo.   jsk-fellows2000 116 2010-01-02T16:13:01+00:00 0 theoestein
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
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
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
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
34060703 Juan Pablo Meneses Director en @UniPortatil /Profesor en @Uchile y @UABBarcelona /Antes @Stanford, @NYUniversity, @Usach /Escritor de no ficción / Seguidor de la religión portátil Santiago, Chile http://uportatil.org jsk-fellows2017 9830 2009-04-21T22:03:56+00:00 0 menesesportatil
14715942 Umbreen Bhatti Director of @barnard_athena || Fmr Director of @KQED's innovation lab, @JSKStanford fellow, and lawyer. Tweets 100% mine. NYC https://www.linkedin.com/in/umbreenbhatti jsk-fellows2014 1993 2008-05-09T17:44:15+00:00 0 ub14
16248718 LisaHsia EVP Digital media at @bravotv @oxygen @universalkids New York, NY http://www.bravotv.com jsk-fellows1993 1374 2008-09-11T22:17:50+00:00 0 LisaHsia
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
82422512 AlexBeam Early Twitter non-adopter, journalist, author and so on Boston   jsk-fellows1997 1650 2009-10-14T18:22:51+00:00 0 imalexbeamyrnot
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
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
104733894 Eric Ortiz Editor @stadiumtalkcom @Granite_Media. Also @Lawatmargins Former @ESPN @NESN @JSKStanford @Truthdig. Founder @evrybit. #news #sports #journalism #storytelling Minneapolis, MN http://lawatthemargins.com/category/community-based-news-room-cbnr/ jsk-fellows2014 1055 2010-01-14T06:32:00+00:00 0 erictortiz
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
16350120 Claudia Nunez Editor at @latimesespanol and @hrw_espanol Founder of @Migrahack immigration stories with data+tech. Love maps and lose sleep. Knight fellow ’12 @JSKstanford Los Angeles,CA   jsk-fellows2012 1428 2008-09-18T17:55:37+00:00 0 nunezcla
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
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
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
17714681 Frederic Filloux Entrepreneur (http://Deepnews.ai), editor of http://mondaynote.com, associate journalism professor at Sciences Po J-school in Paris. Paris, France https://mondaynote.com jsk-fellows2017 9008 2008-11-28T18:03:11+00:00 0 filloux
29674586 Chanda Chisala Entrepreneur and writer. Los Angeles / NYC   jsk-fellows2009 489 2009-04-08T08:30:21+00:00 0 chandachisala
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
236583412 Gary Polakovic Environmental pro for 30 yrs @ Coalition for Clean Air, L.A. Times, http://SEJ.org, Calif State Parks Fdtn., & Make Over Earth, Inc., consulting. Los Angeles, CA http://MakeOverEarth.com jsk-fellows1998 169 2011-01-10T22:50:16+00:00 0 MakeOverEarth
19086064 janinezacharia Ex-WashPost Jerusalem/Mideast correspondent. Now teaching journalism at Stanford, writing on tech/national security, international affairs, media. Stanford http://janinezacharia.net jsk-fellows2009 4087 2009-01-16T21:18:26+00:00 0 janinezacharia
78114269 Marina Walker Executive editor @Pulitzercenter. Mother of 2, builder of teams & @JSKStanford 2019 fellow. Always, @ICIJorg Washington, DC http://www.pulitzercenter.org jsk-fellows-2019 9876 2009-09-28T20:31:14+00:00 0 MarinaWalkerG
240393453 Marcelle Hopkins Executive producer of VR/AR and deputy editor of video at The New York Times. Formerly Al Jazeera. New York, NY http://nytimes.com jsk-fellows-2020 4776 2011-01-19T20:43:47+00:00 0 marcellehopkins
55363786 Jerry Capeci Expert on the American Mafia and organized crime. Award-winning journalist. Gang Land News columnist. Contact Jerry at column02@ganglandnews.com New York http://ganglandnews.com jsk-fellows1996 1559 2009-07-09T21:11:39+00:00 0 ganglandnews
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
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
17290577 Diane Cardwell Former @nytimes reporter. Author ROCKAWAY: Surfing Headlong Into a New Life, a surfing memoir. 7/7/2020, @HMHbooks. Lives, gardens & surfs in Rockaway Beach. New York https://dianecardwell.com jsk-fellows2009 3617 2008-11-10T17:25:04+00:00 0 ByDianeCardwell

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