users

10 rows where profile_sidebar_fill_color = "DDEEF6" and profile_use_background_image = 0 sorted by profile_link_color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, listed_count, geo_enabled, verified, profile_background_color, profile_background_tile, profile_link_color, profile_sidebar_border_color, has_extended_profile, following, created_at (date)

profile_use_background_image ✖

profile_sidebar_fill_color ✖

  • DDEEF6 · 10 ✖
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
19563420 rosey18 Robert J. Rosenthal Exec. Dir. @ Center for Investigative Reporting, lifelong journalist, NYTimes, Boston Globe, Philly Inquirer, SF Chronicle, Africa Correspondent. Berkeley, CA http://centerforinvestigativereporting.org/ 0 3097 310 197 2009-01-26T22:42:21+00:00 6     0 0 5390   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/835264071561682944/CUtK0Gwp_normal.jpg https://pbs.twimg.com/profile_images/835264071561682944/CUtK0Gwp_normal.jpg   0084B4 C0DEED DDEEF6 333333 0 0 0 0 0 0 none
33098630 writergirl Beatrice Motamedi John S. Knight Fellow at Stanford University 2014-15. Founder, Global Student Square. Co-director, Newsroom by the Bay. Adding youth voice to the news ecosystem Oakland, California http://beatricemotamedi.com/ 0 510 243 30 2009-04-19T02:26:00+00:00 14     1 0 968   0 0 0 3B94D9 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/455525318736896000/K3JBzvo9_normal.jpeg https://pbs.twimg.com/profile_images/455525318736896000/K3JBzvo9_normal.jpeg https://pbs.twimg.com/profile_banners/33098630/1430367133 0084B4 C0DEED DDEEF6 333333 0 0 0 0 0 0 none
104733894 erictortiz 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/ 0 1055 2041 193 2010-01-14T06:32:00+00:00 327     1 0 7772   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/701802765677297664/DkRwycV1_normal.jpg https://pbs.twimg.com/profile_images/701802765677297664/DkRwycV1_normal.jpg https://pbs.twimg.com/profile_banners/104733894/1456134569 0084B4 FFFFFF DDEEF6 333333 0 0 0 0 0 0 none
185809250 CivilEats Civil Eats Daily news about the U.S. food system. James Beard Publication of the Year. Support independent media: https://civileats.com/donate/ http://civileats.com/subscribe/ USA http://www.civileats.com 0 108199 561 3134 2010-09-01T22:05:47+00:00 59737     0 1 46095   0 0 0 89C9FA 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/1212811642389647361/ARSfwGW8_normal.jpg https://pbs.twimg.com/profile_images/1212811642389647361/ARSfwGW8_normal.jpg https://pbs.twimg.com/profile_banners/185809250/1583358936 0084B4 FFFFFF DDEEF6 333333 0 0 0 0 0 0 none
386183180 Girmatf Girma T Fantaye       0 1229 451 0 2011-10-06T20:15:31+00:00 471     0 0 1972   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/610040708083359744/gvvDe5SY_normal.jpg https://pbs.twimg.com/profile_images/610040708083359744/gvvDe5SY_normal.jpg   0084B4 FFFFFF DDEEF6 333333 0 0 0 0 0 0 none
454099919 McFaul Michael McFaul Professor. http://michaelmcfaul.com/ Stanford, California http://www.facebook.com/amb.mcfaul 0 526294 1701 4974 2012-01-03T16:36:02+00:00 33719     0 1 87525   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/640815361638535169/L5CJEZkw_normal.jpg https://pbs.twimg.com/profile_images/640815361638535169/L5CJEZkw_normal.jpg https://pbs.twimg.com/profile_banners/454099919/1532108947 1B95E0 C0DEED DDEEF6 333333 0 0 0 0 1 0 none
16291934 SND Society for News Design We create, promote and teach the world’s best visual journalism. http://snd.org International http://www.snd.org/ 0 8784 1289 495 2008-09-15T04:30:50+00:00 3607     1 0 6649   0 0 0 F4F5F0 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/742423324517662720/Tv1TPGB9_normal.jpg https://pbs.twimg.com/profile_images/742423324517662720/Tv1TPGB9_normal.jpg https://pbs.twimg.com/profile_banners/16291934/1597184436 527998 FFFFFF DDEEF6 333333 0 1 0 0 0 0 none
118263124 stanfordnlp Stanford NLP Group Computational Linguistics—Natural Language—Machine Learning—Deep Learning @chrmanning—@jurafsky—@percyliang—@ChrisGPotts—@tatsu_hashimoto at @StanfordAILab Stanford, CA, USA https://nlp.stanford.edu/ 0 96854 98 0 2010-02-28T03:28:05+00:00 1     0 0 7012   0 0 0 8C1515 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/1279513564793802752/UqI_jHb5_normal.jpg https://pbs.twimg.com/profile_images/1279513564793802752/UqI_jHb5_normal.jpg https://pbs.twimg.com/profile_banners/118263124/1524181760 8C1515 FFFFFF DDEEF6 333333 0 0 0 0 1 0 none
1635237446 datafest2013 Americas Datafest The first hemispheric hackathon on migration in the Americas November 2-3, 2013 || #americasdf || Lead organizer @terebouza   http://www.americas.datafest.net 0 253 351 8 2013-07-31T11:13:57+00:00 0     0 0 549   0 0 0 C3E2EB 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/378800000220880767/cf7cec0f50bfcfd61a468c5584cfd87d_normal.png https://pbs.twimg.com/profile_images/378800000220880767/cf7cec0f50bfcfd61a468c5584cfd87d_normal.png https://pbs.twimg.com/profile_banners/1635237446/1375577577 B33F00 FFFFFF DDEEF6 333333 0 0 0 0 0 0 none
224059040 SheilaLKaplan Sheila Kaplan Prohibited disclosure NY student contact info/DOB/birthplace/+ w/w out consent via CPO & regs. Now alarmed by @privacyforum directory info findings; work ahead Brooklyn NY https://www.worldprivacyforum.org/2020/04/without-consent/ 0 1855 2733 139 2010-12-08T01:43:54+00:00 2999     0 0 48584   0 0 0 CCCCCC 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/1315813855365398530/vkREFd1D_normal.jpg https://pbs.twimg.com/profile_images/1315813855365398530/vkREFd1D_normal.jpg https://pbs.twimg.com/profile_banners/224059040/1602554098 F58EA8 000000 DDEEF6 333333 0 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 125.283ms · About: simonw/jsk-fellows-on-twitter