users

119 rows where profile_use_background_image = 0 sorted by profile_sidebar_fill_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
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
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
21678279 agaricus Agaricus Random and untidy. For Personal Science/Quantified Self, follow @quantifiedself. Some archived journalism here: http://antephase.com/archives     0 4019 356 290 2009-02-23T18:39:32+00:00 234     0 0 5419   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/105835994/agaricus_normal.jpg https://pbs.twimg.com/profile_images/105835994/agaricus_normal.jpg https://pbs.twimg.com/profile_banners/21678279/1417844362 0084B4 BDDCAD DDFFCC 333333 0 0 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
17808151 ICFJ ICFJ The International Center for Journalists (ICFJ) is a nonprofit that supports the truth tellers. Follow our @IJNet and @ICFJKnight accounts. #ItTakesAJournalist Washington, DC http://www.icfj.org 0 66829 1782 1985 2008-12-02T14:25:00+00:00 4201     1 1 38336   0 0 0 569BBD http://abs.twimg.com/images/themes/theme3/bg.gif https://abs.twimg.com/images/themes/theme3/bg.gif 0 http://pbs.twimg.com/profile_images/1006561573186539520/dlHJsiA3_normal.jpg https://pbs.twimg.com/profile_images/1006561573186539520/dlHJsiA3_normal.jpg https://pbs.twimg.com/profile_banners/17808151/1545167584 569BBD FFFFFF E3E2DE 5B5836 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
16729309 p2173 Lucy Bernholz Philanthropy wonk (avatar = resting bird face) (B) https://philanthropy.blogspot.com/ (W) https://pacscenter.stanford.edu/research/digital-civil-society-lab/ about.me/lucybernholz http://lucybernholz.com/ 0 18512 6768 1201 2008-10-13T22:54:01+00:00 34801     0 0 47614   0 0 0 055F80 http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 1 http://pbs.twimg.com/profile_images/977978383500959744/yZzQWj3u_normal.jpg https://pbs.twimg.com/profile_images/977978383500959744/yZzQWj3u_normal.jpg https://pbs.twimg.com/profile_banners/16729309/1536531272 1B95E0 063F94 E6EFF2 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
17595439 chr1sa Chris Anderson Suddenly realized that this bio does not have to mirror LinkedIn. Also doesn't have to be a bio at all. Photo by @chrismichel Orinda http://about.me/andersonchris 0 192905 1568 8034 2008-11-24T16:57:51+00:00 15515     1 1 20163   0 0 0 131516 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/1317535678196903937/p4kcMMnF_normal.jpg https://pbs.twimg.com/profile_images/1317535678196903937/p4kcMMnF_normal.jpg https://pbs.twimg.com/profile_banners/17595439/1603147440 009999 EEEEEE EFEFEF 333333 0 0 0 0 0 0 none
18231471 questionswork Andrew Finlayson EVP Digital/Social Strategy @SmithGeiger Helping storytellers on screens with research on 📺 OTT, video, SEO, website, mobile Author "Questions That Work" 👇 818-874-2000 http://questionswork.com 0 1891 4758 91 2008-12-19T01:49:46+00:00 1703     1 0 2900   0 0 0 70191C 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/1103286408150769664/V5BZF_Is_normal.png https://pbs.twimg.com/profile_images/1103286408150769664/V5BZF_Is_normal.png https://pbs.twimg.com/profile_banners/18231471/1348586064 1B95E0 EEEEEE EFEFEF 333333 0 0 0 0 1 0 none
107483740 lighthausinc Lighthaus Makers of Color Space + science and healthcare VR education. Supported by U.S. Dept of Education, National Institutes of Health. A new reality for education. California http://lighthaus.us 0 524 257 21 2010-01-22T18:21:08+00:00 377     0 0 159   0 0 0 131516 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/449636095433506816/gcw5NAxS_normal.jpeg https://pbs.twimg.com/profile_images/449636095433506816/gcw5NAxS_normal.jpeg https://pbs.twimg.com/profile_banners/107483740/1396036513 009999 FFFFFF EFEFEF 333333 0 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
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
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
21404432 Eric_Weiner Eric Weiner NYT bestselling author. Wanderer. @NPR alum. My new book, THE SOCRATES EXPRESS, is out now! Washington, DC http://www.ericweinerbooks.com 0 6707 767 267 2009-02-20T15:21:40+00:00 14503     0 1 9758   0 0 0 A0BFBB http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 1 http://pbs.twimg.com/profile_images/1300182083407618049/GekHJiWR_normal.jpg https://pbs.twimg.com/profile_images/1300182083407618049/GekHJiWR_normal.jpg https://pbs.twimg.com/profile_banners/21404432/1598357672 4470A6 EEEEEE FFFFFF 333333 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

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 4.825ms · About: simonw/jsk-fellows-on-twitter