users

119 rows where profile_use_background_image = 0 sorted by profile_background_color

✎ View and edit SQL

This data as json, CSV (advanced)

profile_use_background_image ✖

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
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
14130084 shazna Shazna Nessa Global Head of Visuals @WSJ + President, @ONA Board of Directors / Former Director, Journalism @knightfdn + @AP @CondeNast New York, NY   0 4991 1060 374 2008-03-12T04:35:38+00:00 1789     1 0 1599   0 0 0 D15C0F 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/907373509961289729/Vqo9wZWD_normal.jpg https://pbs.twimg.com/profile_images/907373509961289729/Vqo9wZWD_normal.jpg https://pbs.twimg.com/profile_banners/14130084/1376351790 0084B4 FFFFFF C0DFEC 333333 0 0 0 0 0 0 none
86776199 jmckellogg JulieAnn McKellogg Making texts fetch @joinsubtext | Builder and storyteller @JSKstanford @pactio_us @mcclatchy @washingtonpost @voanews @UNCHussman San Francisco, CA http://joinsubtext.com 0 1576 946 73 2009-11-01T18:44:39+00:00 10280     1 0 5563   0 0 0 DBE9ED http://abs.twimg.com/images/themes/theme17/bg.gif https://abs.twimg.com/images/themes/theme17/bg.gif 0 http://pbs.twimg.com/profile_images/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_images/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_banners/86776199/1448332496 91D2FA FFFFFF 252429 666666 0 0 0 0 1 0 none
19425169 StanfordEng Stanford Engineering At the Stanford School of Engineering, we seek solutions to important global problems and educate leaders who will make the world a better place. Stanford, CA http://engineering.stanford.edu 0 65412 1547 1291 2009-01-24T00:45:02+00:00 647     0 1 12484   0 0 0 DDCF99 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/879466804854181889/tqXd2ZQd_normal.jpg https://pbs.twimg.com/profile_images/879466804854181889/tqXd2ZQd_normal.jpg https://pbs.twimg.com/profile_banners/19425169/1457556622 990000 FFFFFF 000000 999999 0 0 0 0 0 0 none
110727296 lyndseygilpin Lyndsey Gilpin Founder & Editor-in-Chief, @southerlymag. Kentuckian. @JSKstanford Community Impact Fellow. North Carolina, USA http://www.lyndseygilpin.com 0 11425 1463 332 2010-02-02T15:25:31+00:00 10848     0 0 7395   0 0 0 F08C57 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/1261357987639279616/L4Y06cko_normal.jpg https://pbs.twimg.com/profile_images/1261357987639279616/L4Y06cko_normal.jpg https://pbs.twimg.com/profile_banners/110727296/1539037292 4A913C FFFFFF A0C5C7 333333 0 1 0 0 0 0 none
186997686 DjurdjaPadejski DjurdjaPadejski Communications at @StanfordPACS/@DigCivSoc, ex @StanfordCDDRL. Bilingual tweets, my own, not my org’s. Palo Alto, CA   0 1331 1462 22 2010-09-05T00:14:13+00:00 100808     1 0 17262   0 0 0 F4C152 http://abs.twimg.com/images/themes/theme15/bg.png https://abs.twimg.com/images/themes/theme15/bg.png 1 http://pbs.twimg.com/profile_images/1267997614881964033/phIs-X2i_normal.jpg https://pbs.twimg.com/profile_images/1267997614881964033/phIs-X2i_normal.jpg https://pbs.twimg.com/profile_banners/186997686/1559461460 C4AF4E 000000 A54937 3BA2A6 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
18036441 Stanford Stanford University Stanford is one of the world's leading research and teaching institutions. Official Twitter feed by University Communications. Stanford, CA http://stanford.edu/ 0 796766 516 7132 2008-12-11T01:06:56+00:00 67     0 1 20039   0 0 0 F6F3E5 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/875395483128049664/8z_jvdLB_normal.jpg https://pbs.twimg.com/profile_images/875395483128049664/8z_jvdLB_normal.jpg https://pbs.twimg.com/profile_banners/18036441/1403030942 820000 FFFFFF DDCF99 3F3C30 0 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
14282158 chrisallbritton Chris Allbritton Former journalist with @Time, @Reuters, and others. Knight '09, writer/editor. Washington, DC http://www.christopherallbritton.com 0 2842 1886 0 2008-04-02T10:54:43+00:00 1348     0 0 10947   0 0 0 FFFFFF 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/1271589235263451138/ZzxjG08j_normal.jpg https://pbs.twimg.com/profile_images/1271589235263451138/ZzxjG08j_normal.jpg https://pbs.twimg.com/profile_banners/14282158/1561141342 3B94D9 FFFFFF C0DFEC 333333 0 1 0 0 0 0 regular
21350494 ECorner Stanford eCorner Our mission: help entrepreneurs bring bold ideas to life & help educators develop thoughtful innovators. | A product of Stanford Technology Ventures Program. Stanford, CA http://ecorner.stanford.edu 0 17541 1842 992 2009-02-19T23:08:09+00:00 2501     1 0 10881   0 0 0 FFFFFF 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/1121079791765995520/mcKue8B5_normal.png https://pbs.twimg.com/profile_images/1121079791765995520/mcKue8B5_normal.png https://pbs.twimg.com/profile_banners/21350494/1556121377 BF2429 DA9098 DBDBDB 990000 0 0 0 0 0 0 none
21901213 paddyhirsch Paddy Hirsch ...... ..... http://www.paddyhirsch.com 0 7337 2144 298 2009-02-25T18:49:06+00:00 2016     1 1 18237   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png   0084B4 BDDCAD FFFFFF 333333 0 0 0 1 0 0 none
68204242 japokh Jagadish Pokhrel Hubby, dad, son, brother. Chief Editor of The Rising Nepal until 16/08/2020. Interest in how digits are churning #NEWS and turning it into #KNOWLEDGE. Kasthamandap https://www.vizify.com/jagadish-pokhrel/twitter-video 0 714 425 13 2009-08-23T18:31:54+00:00 942     1 0 2259   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/1281493800209149952/L907byMG_normal.jpg https://pbs.twimg.com/profile_images/1281493800209149952/L907byMG_normal.jpg https://pbs.twimg.com/profile_banners/68204242/1411832139 118F44 000000 FFFFFF 5C4D30 0 0 0 0 0 0 regular
72928579 ivanlpenn Ivan Penn Ivan Penn is a Los Angeles-based energy correspondent for @nytimes, 2006 @JSKstanford fellow and 2014 @LoebAwards winner. Los Angeles, CA https://www.nytco.com/ivan-penn-joins-business-day/ 0 4483 1329 238 2009-09-09T19:26:27+00:00 893     1 0 2493   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/637011735522623488/gEya-1DU_normal.jpg https://pbs.twimg.com/profile_images/637011735522623488/gEya-1DU_normal.jpg https://pbs.twimg.com/profile_banners/72928579/1515718459 0084B4 666666 FFFFFF 333333 0 1 0 0 0 0 none
110905920 wjchat wjchat #wjchat is a chat for web journalists on Wednesdays at 5 p.m. PT. We talk about all things content, technology, ethics, & business of journalism on the web. Everywhere you are http://wjchat.com 0 8759 0 669 2010-02-03T04:38:38+00:00 0     0 0 24074   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/1830163265/wjchat-twitter-icon_normal.png https://pbs.twimg.com/profile_images/1830163265/wjchat-twitter-icon_normal.png   0B0061 C0DEED 08BDFF 000000 0 0 0 0 0 0 none
162581795 StanfordCDDRL Stanford CDDRL The Center on Democracy, Development, and the Rule of Law produces policy-relevant research to advance political development. RTs do not equal endorsements. Stanford University http://cddrl.fsi.stanford.edu 0 15377 879 371 2010-07-04T03:03:42+00:00 3099     1 1 5466   0 0 0 FFFFFF 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/875403533595496448/98zishL1_normal.jpg https://pbs.twimg.com/profile_images/875403533595496448/98zishL1_normal.jpg https://pbs.twimg.com/profile_banners/162581795/1398450261 1B95E0 000000 F6F6F6 333333 0 0 0 0 0 0 none
500219903 CReporting Compu Reporting Computational Reporting. All about Data Mining US http://computationalreporting.com 0 59 57 11 2012-02-22T22:40:11+00:00 0     1 0 147   0 0 0 FFFFFF 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/1872022267/logocr_normal.gif https://pbs.twimg.com/profile_images/1872022267/logocr_normal.gif   F91717 DFD5A7 FF6600 535252 0 0 0 0 0 0 none
1053480468 iGregoryJohnson Gregory Johnson modernizing tech for cities | http://CodeforSouth.org director | JSK @Stanford Fellow ‘20-21 | 🇯🇲 Florida http://www.higregory.com/about 0 939 366 79 2013-01-01T21:08:57+00:00 3334     1 0 4039   0 0 0 FFFFFF 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/1315100277880565760/Rw606ewD_normal.jpg https://pbs.twimg.com/profile_images/1315100277880565760/Rw606ewD_normal.jpg https://pbs.twimg.com/profile_banners/1053480468/1598846198 005C9D FFFFFF 252429 666666 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 6.089ms · About: simonw/jsk-fellows-on-twitter