users

31 rows where profile_text_color = 000000 and verified = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, geo_enabled, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_background_tile, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_use_background_image, has_extended_profile, following, translator_type, created_at (date)

verified ✖

profile_text_color ✖

  • 000000 · 31 ✖
id ▼ screen_name name description location url protected followers_count friends_count listed_count created_at favourites_count utc_offset time_zone geo_enabled verified statuses_count lang contributors_enabled is_translator is_translation_enabled profile_background_color profile_background_image_url profile_background_image_url_https profile_background_tile profile_image_url profile_image_url_https profile_banner_url profile_link_color profile_sidebar_border_color profile_sidebar_fill_color profile_text_color profile_use_background_image has_extended_profile default_profile default_profile_image following notifications translator_type
12497 simonw 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/ 0 21461 4245 1265 2006-11-15T13:18:50+00:00 32193     1 1 24125   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/378800000261649705/be9cc55e64014e6d7663c50d7cb9fc75_normal.jpeg https://pbs.twimg.com/profile_images/378800000261649705/be9cc55e64014e6d7663c50d7cb9fc75_normal.jpeg https://pbs.twimg.com/profile_banners/12497/1347977147 0000FF FFFFFF FFFFFF 000000 1 1 0 0 0 0 regular
770729 lizgannes Liz Gannes My last name rhymes with braaains. San Francisco http://60db.co 0 68124 2906 2171 2007-02-13T23:05:04+00:00 1015     1 1 6246   0 0 0 8EDA42 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 1 http://pbs.twimg.com/profile_images/471712372659216385/eM4o7S3H_normal.jpeg https://pbs.twimg.com/profile_images/471712372659216385/eM4o7S3H_normal.jpeg https://pbs.twimg.com/profile_banners/770729/1401690657 0000FF 87BC44 E0FF91 000000 1 0 0 0 1 0 none
7805322 Rosental Rosental Professor, Knight Chair in Journalism/UNESCO Chair in Communication, founder/director Knight Center for Journalism in the Americas,University of Texas at Austin Austin, Texas http://knightcenter.utexas.edu 0 28097 1327 1479 2007-07-29T22:59:41+00:00 4211     1 1 28632   0 0 0 9AE4E8 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/728995740270268416/DzENDi1E_normal.jpg https://pbs.twimg.com/profile_images/728995740270268416/DzENDi1E_normal.jpg https://pbs.twimg.com/profile_banners/7805322/1595091309 0000FF 87BC44 E0FF92 000000 1 0 0 0 0 0 none
13745872 ONA Online News Association Inspiring innovation in digital journalism since 1999 through yearlong programs, @ONAconf #ONA20 and the Online Journalism Awards #OJA20. Worldwide https://journalists.org/ 0 57314 8183 2528 2008-02-20T23:27:42+00:00 5996     1 1 17605   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1103396638880657412/YxUu9sCC_normal.png https://pbs.twimg.com/profile_images/1103396638880657412/YxUu9sCC_normal.png https://pbs.twimg.com/profile_banners/13745872/1590516266 2AB7CA 5C5C5C E6E6E6 000000 0 0 0 0 1 0 none
14145296 susie_c Susie Cagle 🔍👀💻✍️🎨 / climate, crisis, labor, business, technology, California +++ / susie.cagle@gmail / DMs always open Oakland, CA http://susiecagle.com 0 23441 2692 1120 2008-03-14T06:12:34+00:00 35932     0 1 45861   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/881381260794318848/H0-Qgb48_normal.jpg https://pbs.twimg.com/profile_images/881381260794318848/H0-Qgb48_normal.jpg https://pbs.twimg.com/profile_banners/14145296/1561081102 299EE9 FFFFFF FFFFFF 000000 0 1 0 0 0 0 none
14305753 jczamora 𝙟𝙤𝙨𝙚 𝙯𝙖𝙢𝙤𝙧𝙖 • Comms. @UniNoticias. // @JSKstanford Fellow. Prof. @univmiami. Former @knightfdn @el_Periodico @UFMedu Law @UniofOxford MediaLaw @UTAustin MPA. OAS Scholar. Miami, FL http://www.linkedin.com/in/josecarloszamora 0 7902 3740 403 2008-04-04T20:04:23+00:00 102245     0 1 55144   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 1 http://pbs.twimg.com/profile_images/1318413389585154048/l7E2ESTq_normal.jpg https://pbs.twimg.com/profile_images/1318413389585154048/l7E2ESTq_normal.jpg https://pbs.twimg.com/profile_banners/14305753/1603170737 75858A FFFFFF FFFFFF 000000 1 1 0 0 1 0 none
14478614 JeffElder 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 0 87727 13602 1123 2008-04-22T18:54:22+00:00 10867     1 1 24941   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 1 http://pbs.twimg.com/profile_images/864507389734666240/KWb2Kn_D_normal.jpg https://pbs.twimg.com/profile_images/864507389734666240/KWb2Kn_D_normal.jpg https://pbs.twimg.com/profile_banners/14478614/1602986642 000000 FFFFFF FFFFFF 000000 1 0 0 0 0 0 regular
14716014 laurahertzfeld Laura Hertzfeld Storyteller, LA ambassador, midnight baker. Lost to Jeopardy James. Now #XR @thisisryot @yahoonews Then @Journalism_360 @EW @PBS Always @jskstanford #binders Los Angeles, CA http://www.newsvagabond.com/ 0 3387 1793 178 2008-05-09T17:50:31+00:00 10732     0 1 10273   0 0 0 2428D7 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 1 http://pbs.twimg.com/profile_images/753039104384704512/ONQenZkb_normal.jpg https://pbs.twimg.com/profile_images/753039104384704512/ONQenZkb_normal.jpg https://pbs.twimg.com/profile_banners/14716014/1402504446 29DBFF 12EBFF 8512FF 000000 1 0 0 0 1 0 none
16556482 emilygharris Emily Harris Journalist with Reveal, from The Center for Investigative Reporting United States   0 1751 271 130 2008-10-02T07:07:28+00:00 56     0 1 560   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1525186668/Photo_on_2011-08-30_at_22.07_normal.jpg https://pbs.twimg.com/profile_images/1525186668/Photo_on_2011-08-30_at_22.07_normal.jpg https://pbs.twimg.com/profile_banners/16556482/1461762092 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
16672162 vxflores 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 0 3951 3542 200 2008-10-09T19:37:34+00:00 4810     1 1 12178   0 0 0 000000 http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/951839489705439232/QQix8IDA_normal.jpg https://pbs.twimg.com/profile_images/951839489705439232/QQix8IDA_normal.jpg https://pbs.twimg.com/profile_banners/16672162/1533060691 981CEB 000000 000000 000000 0 0 0 0 0 0 none
17684905 svwriter John Boudreau Vietnam bureau chief, Bloomberg News; formerly @mercnews Retweet ≠ endorsement. Hanoi, Vietnam http://www.bloomberg.com 0 1776 1695 105 2008-11-27T18:31:36+00:00 793     0 1 1623   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/985803632565080064/oCfuC6Fb_normal.jpg https://pbs.twimg.com/profile_images/985803632565080064/oCfuC6Fb_normal.jpg https://pbs.twimg.com/profile_banners/17684905/1359234014 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
17813899 StanfordGSB Stanford Business Business research, insights, & ideas from Stanford Graduate School of Business. Stanford, California, USA http://gsb.stanford.edu/insights 0 494834 1487 6920 2008-12-02T18:15:00+00:00 3908     0 1 22891   0 0 0 990000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/997216596597784577/2Mhi4lR2_normal.jpg https://pbs.twimg.com/profile_images/997216596597784577/2Mhi4lR2_normal.jpg https://pbs.twimg.com/profile_banners/17813899/1598495920 BD2031 FFFFFF E7D19A 000000 0 0 0 0 0 0 none
18454770 DonLDay 🔅Don Day http://BoiseDev.com publisher covering the story of Idaho’s future. @JSKstanford Fellow. Spent 18 years in traditional media, now reinventing local news. Boise, ID http://linkedin.com/in/donday 0 7036 1106 247 2008-12-29T17:56:56+00:00 24683     1 1 43166   0 0 0 000000 http://abs.twimg.com/images/themes/theme14/bg.gif https://abs.twimg.com/images/themes/theme14/bg.gif 0 http://pbs.twimg.com/profile_images/1283121755129696257/vyI7a6eY_normal.jpg https://pbs.twimg.com/profile_images/1283121755129696257/vyI7a6eY_normal.jpg https://pbs.twimg.com/profile_banners/18454770/1586473612 FF691F 000000 000000 000000 0 1 0 0 1 0 none
18912392 attilamong Attila Mong journalist//consultant @DW_Akademie // Europe correspondent for @pressfreedom // board member @Atlatszo // @JSKStanford Fellow//Stronger& lighter after #cancer. Berlin   0 9395 1498 335 2009-01-12T19:45:35+00:00 3757     1 1 15706   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/636421944485781504/r6WL-rE7_normal.jpg https://pbs.twimg.com/profile_images/636421944485781504/r6WL-rE7_normal.jpg https://pbs.twimg.com/profile_banners/18912392/1441923873 1B95E0 000000 000000 000000 0 1 0 0 0 0 none
20253808 AndreaWNYC 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 0 28333 1906 726 2009-02-06T17:29:43+00:00 4997     1 1 3349   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/918152096834351104/A_PEmQWi_normal.jpg https://pbs.twimg.com/profile_images/918152096834351104/A_PEmQWi_normal.jpg https://pbs.twimg.com/profile_banners/20253808/1597421977 FA743E 000000 000000 000000 0 0 0 0 0 0 none
22929310 jseiken Jason Seiken Digital since before digital was a thing. Washington Post, PBS, Daily Telegraph, etc.. Non-digital father and husband. London http://www.qcatalyst.com 0 2684 431 160 2009-03-05T15:10:52+00:00 1130     1 1 2729   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1197136052756058112/KSPIGpL-_normal.jpg https://pbs.twimg.com/profile_images/1197136052756058112/KSPIGpL-_normal.jpg https://pbs.twimg.com/profile_banners/22929310/1456049661 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
25029808 guilherme_amado Guilherme Amado Jornalista. Colunista na @RevistaEpoca e na @cbnoficial. @ICIJorg member. @Abraji VP. @JSKStanford fellow. http://Instagram.com/guilhermeamado Brazil https://epoca.globo.com/guilherme-amado/ 0 41787 2021 305 2009-03-18T04:47:23+00:00 6692     0 1 15307   0 0 0 000000 http://abs.twimg.com/images/themes/theme15/bg.png https://abs.twimg.com/images/themes/theme15/bg.png 0 http://pbs.twimg.com/profile_images/1086973470410457088/fwJv97SS_normal.jpg https://pbs.twimg.com/profile_images/1086973470410457088/fwJv97SS_normal.jpg https://pbs.twimg.com/profile_banners/25029808/1547950542 ABB8C2 000000 000000 000000 0 1 0 0 0 0 none
25427470 StanfordDaily The Stanford Daily Independent student newspaper serving Stanford and surrounding cities since 1892. RTs / likes don't imply endorsement Stanford, CA http://www.stanforddaily.com 0 14617 127 508 2009-03-20T01:15:08+00:00 361     1 1 10264   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 1 http://pbs.twimg.com/profile_images/828118030605381636/G3wb0UIB_normal.jpg https://pbs.twimg.com/profile_images/828118030605381636/G3wb0UIB_normal.jpg https://pbs.twimg.com/profile_banners/25427470/1600026002 990000 990000 FFFFFF 000000 1 0 0 0 0 0 none
26006398 jdesmondharris Jenée Editor. Writer. Subtweeter. Now: @NYTOpinion staff editor, @TheOpedProject mentor + sensitivity reader for hire. Then: @Voxdotcom @TheRoot @Harvard Law @HowardU   https://www.linkedin.com/in/jeneed/ 0 29294 6548 514 2009-03-23T14:08:25+00:00 50348     0 1 29791   0 0 0 000000 http://abs.twimg.com/images/themes/theme6/bg.gif https://abs.twimg.com/images/themes/theme6/bg.gif 0 http://pbs.twimg.com/profile_images/1309645030110314498/LkV85279_normal.jpg https://pbs.twimg.com/profile_images/1309645030110314498/LkV85279_normal.jpg https://pbs.twimg.com/profile_banners/26006398/1414882009 FA743E 000000 000000 000000 0 1 0 0 0 0 none
27469953 lbranham Lorraine Branham Dean @NewhouseSU; former director of Journalism at UT Austin. Spent 25 years as a journalist, reporter, editor. Syracuse, NY   0 1228 740 59 2009-03-29T18:02:07+00:00 64     1 1 416   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/292357248/Branham_Lorraine_small_0382__photo__normal.jpg https://pbs.twimg.com/profile_images/292357248/Branham_Lorraine_small_0382__photo__normal.jpg https://pbs.twimg.com/profile_banners/27469953/1507231570 FF691F 000000 000000 000000 0 1 0 0 0 0 none
33964434 donnaborak Donna Borak Adjunct Faculty @NYU. Senior Economics Journalist. Alum of @CNN @WSJ @AP @AmerBanker and @UPI. 2015 JSK @Stanford Fellow. Yoga teacher. 🧘‍♀️ Globetrotter. Washington   0 5956 3161 266 2009-04-21T17:00:53+00:00 1464     0 1 9718   0 0 0 000000 http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/883050113882521601/5_6nNAs7_normal.jpg https://pbs.twimg.com/profile_images/883050113882521601/5_6nNAs7_normal.jpg https://pbs.twimg.com/profile_banners/33964434/1584126644 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
34687443 kristianiaclark krissy clark Host/co-creator: The Uncertain Hour podcast @Marketplace Stories: @reveal @99piorg @PopUpMag @slate Past @JSKstanford fellow 🌖ing at http://storieseverywherere.org los angeles https://itunes.apple.com/us/podcast/the-uncertain-hour/id1091031079?mt=2 0 3758 2147 190 2009-04-23T18:28:03+00:00 791     1 1 1554   0 0 0 000000 http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 0 http://pbs.twimg.com/profile_images/2116171461/image_normal.jpg https://pbs.twimg.com/profile_images/2116171461/image_normal.jpg https://pbs.twimg.com/profile_banners/34687443/1416800787 FF691F 000000 000000 000000 0 0 0 0 0 0 none
39021657 Zielina Anita Zielina Innovation, product, biz models, change in digital/media. 💪 Training innovative leaders @newmarkjschool. Alum @insead @jskstanford @nzz @sternde @derstandardat New York, USA https://www.journalism.cuny.edu/executive-ed 0 46520 4387 810 2009-05-10T09:02:13+00:00 21882     1 1 19725   0 0 0 000000 http://abs.twimg.com/images/themes/theme7/bg.gif https://abs.twimg.com/images/themes/theme7/bg.gif 0 http://pbs.twimg.com/profile_images/926560081562435584/ylWz4hwa_normal.jpg https://pbs.twimg.com/profile_images/926560081562435584/ylWz4hwa_normal.jpg https://pbs.twimg.com/profile_banners/39021657/1549242812 1B95E0 000000 000000 000000 0 0 0 0 1 0 none
106430958 Aaron_Glantz Aaron Glantz Senior Reporter @Reveal, Pulitzer Finalist, Author, HOMEWRECKERS from HarperCollins, Peabody & duPont Award-winning journalist, 2016 JSK Fellow at Stanford San Francisco, CA http://www.aglantz.com/ 0 7366 2169 260 2010-01-19T14:53:25+00:00 1983     0 1 11383   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1130878485705109504/hAHCW38J_normal.png https://pbs.twimg.com/profile_images/1130878485705109504/hAHCW38J_normal.png https://pbs.twimg.com/profile_banners/106430958/1562784141 DD2E44 000000 000000 000000 0 0 0 0 0 0 none
124531391 MuckRock MuckRock MuckRock is the easy way to request, analyze & share public records, making government more transparent and democracies more informed. info@muckrock.com Coast to Coast https://muckrock.com 0 36533 4415 1228 2010-03-19T18:13:26+00:00 2074     1 1 66270   0 0 0 BBD6FA http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/681918417213894656/tAynDJGw_normal.png https://pbs.twimg.com/profile_images/681918417213894656/tAynDJGw_normal.png https://pbs.twimg.com/profile_banners/124531391/1451425421 4582CC 000000 000000 000000 1 0 0 0 0 0 none
213689248 DoctorYasmin Dr. Seema Yasmin MD + Epidemiologist + Journalist | Fmr Epidemic Intelligence Service Officer| Study: infodemics |Teach: sci journalism | Direct: Stanford Health Comm Initiative Hackney girl in California https://linktr.ee/SeemaYasmin 0 66115 5196 1272 2010-11-09T15:06:40+00:00 34462     1 1 78001   0 0 0 000000 http://abs.twimg.com/images/themes/theme16/bg.gif https://abs.twimg.com/images/themes/theme16/bg.gif 0 http://pbs.twimg.com/profile_images/855053296347881472/MCPljb6B_normal.jpg https://pbs.twimg.com/profile_images/855053296347881472/MCPljb6B_normal.jpg https://pbs.twimg.com/profile_banners/213689248/1602267253 FF691F 000000 000000 000000 0 1 0 0 0 0 none
250010900 Julie_Makinen Julie Makinen Executive Editor, The Desert Sun, Palm Springs, CA. JSK fellow @Stanford 2016-17. Past: L.A. Times, Intl. N.Y. Times, Washington Post. Traveler. Chocoholic. Palm Springs, CA http://desertsun.com 0 4665 806 339 2011-02-10T06:46:14+00:00 3408     1 1 5522   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1037387370239164416/3t8vBmtH_normal.jpg https://pbs.twimg.com/profile_images/1037387370239164416/3t8vBmtH_normal.jpg https://pbs.twimg.com/profile_banners/250010900/1536175716 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
264340567 txtianmiller T. Christian Miller Senior investigative reporter @Propublica. Co-author of http://afalsereport.com. Into journalism that counts. And bacon. Pulitzer winner. Berkeley, CA http://www.propublica.org 0 8847 2015 329 2011-03-11T19:00:34+00:00 4504     1 1 6049   0 0 0 000000 http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 0 http://pbs.twimg.com/profile_images/545792431778590720/bdEY0hf7_normal.jpeg https://pbs.twimg.com/profile_images/545792431778590720/bdEY0hf7_normal.jpeg https://pbs.twimg.com/profile_banners/264340567/1573861549 19CF86 000000 000000 000000 0 0 0 0 0 0 none
423511427 CODaleyNews John Daley Multi-media journalist, covering health news for Colorado Public Radio, aka CPRNews A link or retweet does not = endorsement. USA http://cpr.org 0 2351 939 131 2011-11-28T16:05:17+00:00 3772     0 1 5025   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1156307032892477440/BLv5vRSo_normal.jpg https://pbs.twimg.com/profile_images/1156307032892477440/BLv5vRSo_normal.jpg https://pbs.twimg.com/profile_banners/423511427/1442034198 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
1548898596 Ericnpr 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 0 4897 2014 210 2013-06-26T19:27:15+00:00 680     0 1 2353   0 0 0 000000 http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 0 http://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_banners/1548898596/1406506418 3B94D9 000000 000000 000000 0 0 0 0 0 0 none
3314775459 firstdraftnews First Draft We work to protect communities from harmful disinformation by sharing tips and resources to build resilience and improve access to accurate information. Global http://firstdraftnews.org 0 32047 1981 1547 2015-06-09T11:01:31+00:00 3491     0 1 9820   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1278452041090830337/TFHOyXrO_normal.jpg https://pbs.twimg.com/profile_images/1278452041090830337/TFHOyXrO_normal.jpg https://pbs.twimg.com/profile_banners/3314775459/1593641694 9F1924 000000 000000 000000 1 0 0 0 0 0 none

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [users] (
   [id] INTEGER PRIMARY KEY,
   [screen_name] TEXT,
   [name] TEXT,
   [description] TEXT,
   [location] TEXT
, [url] TEXT, [protected] INTEGER, [followers_count] INTEGER, [friends_count] INTEGER, [listed_count] INTEGER, [created_at] TEXT, [favourites_count] INTEGER, [utc_offset] TEXT, [time_zone] TEXT, [geo_enabled] INTEGER, [verified] INTEGER, [statuses_count] INTEGER, [lang] TEXT, [contributors_enabled] INTEGER, [is_translator] INTEGER, [is_translation_enabled] INTEGER, [profile_background_color] TEXT, [profile_background_image_url] TEXT, [profile_background_image_url_https] TEXT, [profile_background_tile] INTEGER, [profile_image_url] TEXT, [profile_image_url_https] TEXT, [profile_banner_url] TEXT, [profile_link_color] TEXT, [profile_sidebar_border_color] TEXT, [profile_sidebar_fill_color] TEXT, [profile_text_color] TEXT, [profile_use_background_image] INTEGER, [has_extended_profile] INTEGER, [default_profile] INTEGER, [default_profile_image] INTEGER, [following] INTEGER, [follow_request_sent] INTEGER, [notifications] INTEGER, [translator_type] TEXT);
Powered by Datasette · Query took 110.734ms · About: simonw/jsk-fellows-on-twitter