users

19 rows where has_extended_profile = 1 and profile_sidebar_border_color = 000000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_count, geo_enabled, verified, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_background_tile, profile_link_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, following, created_at (date)

profile_sidebar_border_color ✖

  • 000000 · 19 ✖

has_extended_profile ✖

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
6423572 tomvandeweghe 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 0 26058 913 441 2007-05-29T20:01:06+00:00 1513     1 1 5377   0 0 0 EDECE9 http://abs.twimg.com/images/themes/theme3/bg.gif https://abs.twimg.com/images/themes/theme3/bg.gif 1 http://pbs.twimg.com/profile_images/1007556283904483328/1-vQ9svc_normal.jpg https://pbs.twimg.com/profile_images/1007556283904483328/1-vQ9svc_normal.jpg https://pbs.twimg.com/profile_banners/6423572/1556174198 000001 000000 75E6FF 634047 1 1 0 0 0 0 none
13575602 aparnamuk Aparna Mukherjee Heart born, lost in NYC | @JSKStanford ‘21 | 🎙 #SenseLA @FUSECorps | Priors @NYTimes @Bloomberg @CNBC @WSJ @AP @McKinsey |@Bagehots @Columbia @BrynMawrCollege Thai Town/Los Feliz https://sense.la 0 4515 5001 417 2008-02-17T05:28:57+00:00 117142     1 0 71459   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/1246913835291705344/UNdfSZP2_normal.jpg https://pbs.twimg.com/profile_images/1246913835291705344/UNdfSZP2_normal.jpg https://pbs.twimg.com/profile_banners/13575602/1398666652 3B94D9 000000 000000 000000 0 1 0 0 0 0 none
14140617 BAVC Bay Area Video Coalition Inspiring social change by empowering media makers to develop & share diverse stories. San Francisco https://linktr.ee/bavc 0 6808 2911 490 2008-03-13T16:41:47+00:00 4456     1 1 8582   0 0 0 9FC15F 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/948381251358007297/u0jyFHuC_normal.jpg https://pbs.twimg.com/profile_images/948381251358007297/u0jyFHuC_normal.jpg https://pbs.twimg.com/profile_banners/14140617/1514946705 A0C613 000000 E3E2DE 634047 0 1 0 0 0 0 none
17033026 gmafort Gabriela Mafort Branded Content and Video Branding Consultant. Rio de Janeiro, Brazil http://about.me/gmafort 0 453 508 15 2008-10-29T01:22:33+00:00 82     1 0 262   0 0 0 000000 http://abs.twimg.com/images/themes/theme5/bg.gif https://abs.twimg.com/images/themes/theme5/bg.gif 0 http://pbs.twimg.com/profile_images/1135637749619253250/2OUB9tnq_normal.png https://pbs.twimg.com/profile_images/1135637749619253250/2OUB9tnq_normal.png   E81C4F 000000 000000 000000 0 1 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
24164338 NABJ NABJ Headquarters | NABJ.org The National Association of Black Journalists provides innovative programs, training, career services & advocacy for Black #journalists worldwide. #NABJ Washington, DC http://nabj.org 0 45397 3696 879 2009-03-13T12:42:37+00:00 7667     1 1 29507   0 0 0 F5F8FA http://abs.twimg.com/images/themes/theme14/bg.gif https://abs.twimg.com/images/themes/theme14/bg.gif 1 http://pbs.twimg.com/profile_images/1311475321204551685/5ysXlwiY_normal.jpg https://pbs.twimg.com/profile_images/1311475321204551685/5ysXlwiY_normal.jpg https://pbs.twimg.com/profile_banners/24164338/1601670883 57072E 000000 EFEFEF 333333 1 1 0 0 0 0 none
24661811 mikegrantme Michael Grant Teaching Fellow @Google News Lab. Founder @GetCurrentNow. Priors: UX @Reveal, @JSKstanford Fellow '18, @StarTribune + @SFChronicle. Views are my own. Menlo Park, CA https://mikegrant.me 0 2461 2705 142 2009-03-16T07:02:19+00:00 2980     1 0 2155   0 0 0 000000 http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1315155250240614401/YImoCG-K_normal.jpg https://pbs.twimg.com/profile_images/1315155250240614401/YImoCG-K_normal.jpg https://pbs.twimg.com/profile_banners/24661811/1602392657 6442FF 000000 000000 000000 0 1 0 0 1 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
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
50379519 sonniefron 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 0 410 422 16 2009-06-24T17:55:58+00:00 205     0 0 813   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/499964856099819520/eHWLlmXV_normal.jpeg https://pbs.twimg.com/profile_images/499964856099819520/eHWLlmXV_normal.jpeg   0084B4 000000 000000 000000 0 1 0 0 0 0 none
96941094 AndrewMwenda Andrew M. Mwenda The Old Man of the Clan against common nonsense Kampala, Uganda http://independent.co.ug/andrewmwenda 0 358504 1304 559 2009-12-15T08:24:17+00:00 4711     1 1 26804   0 0 0 ADC786 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/1264059938411819008/y4L4QoAa_normal.jpg https://pbs.twimg.com/profile_images/1264059938411819008/y4L4QoAa_normal.jpg https://pbs.twimg.com/profile_banners/96941094/1516459006 A23315 000000 443123 71B687 1 1 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
316717535 SShourd Sarah Shourd Trauma-informed journalist. Advocate for alternatives to incarceration and restorative justice. Playwright and Director. Lover of popcorn and redwood trees. Oakland, CA https://pulitzercenter.org/event/box-virtual-performances 0 3275 1725 122 2011-06-13T21:27:49+00:00 1751     0 0 5280   0 0 0 5D12CC http://abs.twimg.com/images/themes/theme12/bg.gif https://abs.twimg.com/images/themes/theme12/bg.gif 0 http://pbs.twimg.com/profile_images/1191745122800721921/Pw6Mm8S-_normal.jpg https://pbs.twimg.com/profile_images/1191745122800721921/Pw6Mm8S-_normal.jpg https://pbs.twimg.com/profile_banners/316717535/1572969203 141313 000000 A0C5C7 333333 1 1 0 0 0 0 none
388030023 News_Kat 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 0 2285 2218 165 2011-10-10T02:15:17+00:00 2538     1 0 4595   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/959535064911462400/22iyhmXB_normal.jpg https://pbs.twimg.com/profile_images/959535064911462400/22iyhmXB_normal.jpg https://pbs.twimg.com/profile_banners/388030023/1562164037 1B95E0 000000 000000 000000 0 1 0 0 0 0 none
516794788 cherokee_editor Bryan Pollard associate director, @najournalists; former JSK Fellow, @jskstanford; former exec editor, @CherokeePhoenix; founder @streetroots, board member, @highcountrynews Fayetteville, AR   0 973 143 15 2012-03-06T19:10:04+00:00 407     0 0 298   0 0 0 000000 http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1202017989794512897/b5TBWCxa_normal.jpg https://pbs.twimg.com/profile_images/1202017989794512897/b5TBWCxa_normal.jpg https://pbs.twimg.com/profile_banners/516794788/1594162479 981CEB 000000 000000 000000 0 1 0 0 1 0 none
750919846330793984 YooHeeHong0916 YooHee Hong   San Francisco, CA http://ww.linkedin.com/in/yoohee-hong-6136b856 0 72 416 3 2016-07-07T05:10:17+00:00 27     0 0 110   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/750923750393073664/OmqpgBr__normal.jpg https://pbs.twimg.com/profile_images/750923750393073664/OmqpgBr__normal.jpg https://pbs.twimg.com/profile_banners/750919846330793984/1472532696 7FDBB6 000000 000000 000000 0 1 0 0 0 0 none
781961899835437056 spaceship_media Spaceship Media Journalism to bridge divides. Building communities, restoring trust in journalism, reducing polarization // spaceshipmedia@spaceshipmedia.org space http://spaceshipmedia.org 0 1410 743 59 2016-09-30T21:00:19+00:00 2020     0 0 501   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/1062126154742525952/veTD_qgm_normal.jpg https://pbs.twimg.com/profile_images/1062126154742525952/veTD_qgm_normal.jpg https://pbs.twimg.com/profile_banners/781961899835437056/1516413473 1B95E0 000000 000000 000000 0 1 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 117.537ms · About: simonw/jsk-fellows-on-twitter