users

12 rows where profile_background_image_url_https = "https://abs.twimg.com/images/themes/theme7/bg.gif"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, geo_enabled, verified, profile_background_color, profile_background_tile, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, following, created_at (date)

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
5202671 martyn_williams Martyn Williams North Korea-focused journalist/researcher @NorthKoreaTech @38NorthNK. Non-resident fellow @stimsoncenter. Author @committeeHRNK. Also KJ6SDF. Washington, DC http://www.northkoreatech.org 0 24339 900 1452 2007-04-19T08:11:12+00:00 1803     1 1 10635   0 0 0 EBEBEB 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/689273723333955584/_WBnXDWi_normal.jpg https://pbs.twimg.com/profile_images/689273723333955584/_WBnXDWi_normal.jpg   990000 DFDFDF F3F3F3 333333 1 0 0 0 0 0 none
14173930 s_m_i stacy-marie ishmael Trinidadian-at-large. Header by Alex Smailes; headshot by Kevin Abosch. She/her/they/them. My superpower is I read to the end.     0 40331 9836 1022 2008-03-19T01:40:02+00:00 38744     0 1 6070   0 0 0 970E22 http://abs.twimg.com/images/themes/theme7/bg.gif https://abs.twimg.com/images/themes/theme7/bg.gif 1 http://pbs.twimg.com/profile_images/1186116359941447682/8gyoz2ST_normal.jpg https://pbs.twimg.com/profile_images/1186116359941447682/8gyoz2ST_normal.jpg https://pbs.twimg.com/profile_banners/14173930/1398196629 84878C 120000 FFF2F3 E81C35 1 0 0 0 0 0 none
16259364 mlh_holmes Michelle Holmes 📍 Free human, looking for adventure Indiana, USA https://www.linkedin.com/in/michelle-holmes-924b2b11/ 0 4655 3635 224 2008-09-12T17:26:14+00:00 6912     1 1 12802   0 0 0 D6C5D6 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/1261462736791273472/Ncp72CNd_normal.jpg https://pbs.twimg.com/profile_images/1261462736791273472/Ncp72CNd_normal.jpg https://pbs.twimg.com/profile_banners/16259364/1589591129 990000 FFFFFF F3F3F3 333333 1 0 0 0 0 0 none
16700673 jenniferdargan Rock’em Sock’em Rosie @WPR, @JSKstanford ‘18, public radio fanatic, often on eight wheels. Madison, WI   0 434 699 21 2008-10-11T21:50:07+00:00 1837     0 0 764   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/1009887538893357056/bPUYbyW-_normal.jpg https://pbs.twimg.com/profile_images/1009887538893357056/bPUYbyW-_normal.jpg https://pbs.twimg.com/profile_banners/16700673/1510276807 990000 FFFFFF F3F3F3 333333 0 0 0 0 0 0 none
17027157 JuanCastilloAAS Juan Castillo Editorial Page Editor at the Austin American-Statesman. Austin, TX, USA   0 1101 702 72 2008-10-28T19:42:55+00:00 14     0 0 1504   0 0 0 EBEBEB 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/789155874946158592/27pbzS0d_normal.jpg https://pbs.twimg.com/profile_images/789155874946158592/27pbzS0d_normal.jpg https://pbs.twimg.com/profile_banners/17027157/1403529642 990000 DEDEDE F2F2F2 333333 1 0 0 0 0 0 none
22723759 mimileitsinger Miranda Leitsinger @KQEDnews, formerly @NBC News, @CNN, @AP, @AFP. From breaking news to investigative reporting, with a passion for gender and culture. San Francisco, CA http://www.kqed.org 0 1814 3751 87 2009-03-04T02:58:25+00:00 810     1 0 9547   0 0 0 EBEBEB 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/604387454800404481/7f7bfBao_normal.jpg https://pbs.twimg.com/profile_images/604387454800404481/7f7bfBao_normal.jpg https://pbs.twimg.com/profile_banners/22723759/1398888304 990000 DFDFDF F3F3F3 333333 1 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
49565987 dionnebunsha Dionne Bunsha Journalist-author from India, works on human rights, environment, social justice. Loves the sea and sun. Always asking why? Vancouver, Canada http://www.dionnebunsha.com 0 400 740 18 2009-06-22T07:29:17+00:00 131     0 0 274   0 0 0 EBEBEB 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/1868930857/photo_normal.JPG https://pbs.twimg.com/profile_images/1868930857/photo_normal.JPG https://pbs.twimg.com/profile_banners/49565987/1390007363 990000 DFDFDF F3F3F3 333333 1 0 0 0 0 0 none
78114269 MarinaWalkerG Marina Walker Executive editor @Pulitzercenter. Mother of 2, builder of teams & @JSKStanford 2019 fellow. Always, @ICIJorg Washington, DC http://www.pulitzercenter.org 0 9876 2633 238 2009-09-28T20:31:14+00:00 2863     1 0 2703   0 0 0 EBEBEB 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/937897924624863232/4gV75E1f_normal.jpg https://pbs.twimg.com/profile_images/937897924624863232/4gV75E1f_normal.jpg https://pbs.twimg.com/profile_banners/78114269/1569711741 990000 DFDFDF F3F3F3 333333 1 0 0 0 1 0 none
78791558 StanfordPACS Stanford PACS Engaging scholars, practitioners, and leaders to improve philanthropy and strengthen civil society. Publisher of @SSIReview. RT ≠ endorsement. Stanford, CA, USA http://pacscenter.stanford.edu 0 5740 1385 258 2009-10-01T03:33:27+00:00 2453     1 0 3187   0 0 0 EBEBEB http://abs.twimg.com/images/themes/theme7/bg.gif https://abs.twimg.com/images/themes/theme7/bg.gif 1 http://pbs.twimg.com/profile_images/943978188903813120/Fm6EPDGM_normal.jpg https://pbs.twimg.com/profile_images/943978188903813120/Fm6EPDGM_normal.jpg https://pbs.twimg.com/profile_banners/78791558/1473867194 990000 FFFFFF F3F5BF 3F5936 1 0 0 0 0 0 none
86152476 masoodfarivar Masood Farivar I cover the Justice Department and the FBI for Voice of America. @capitals and @dcunited fan. Washington, D.C. http://www.voanews.com/ 0 6809 5537 159 2009-10-29T20:18:15+00:00 2462     1 0 11603   0 0 0 EBEBEB 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/931312205911470081/eX8YM1J1_normal.jpg https://pbs.twimg.com/profile_images/931312205911470081/eX8YM1J1_normal.jpg https://pbs.twimg.com/profile_banners/86152476/1489942546 990000 DFDFDF F3F3F3 333333 1 0 0 0 0 0 none
230336117 janegross jane gross Recovering New York Times journalist. Founder New Old Age blog. Author of A Bittersweet Season (Knopf/Vintage) Lecturer. new york city https://twitter.com/janegross 0 581 218 47 2010-12-25T03:04:16+00:00 3     0 0 409   0 0 0 EBEBEB 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/1536497618/Authors-Night-East-Hampton-Th_normal.jpg https://pbs.twimg.com/profile_images/1536497618/Authors-Night-East-Hampton-Th_normal.jpg   990000 DFDFDF F3F3F3 333333 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 114.063ms · About: simonw/jsk-fellows-on-twitter