users

13 rows where profile_background_tile = 1 and profile_use_background_image = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, favourites_count, geo_enabled, verified, profile_background_image_url, profile_background_image_url_https, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, has_extended_profile, following, created_at (date)

profile_use_background_image ✖

profile_background_tile ✖

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
6278622 kathykiely Kathy Kiely Professional pest. Longtime Washington journalist who self-deported to train new pests. Now at Mizzou J-school. Columbia, MO http://www.kathykiely.info 0 2648 1017 132 2007-05-24T04:12:12+00:00 526     1 0 3277   0 0 0 ABB8C2 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/22702442/notebook_normal.jpg https://pbs.twimg.com/profile_images/22702442/notebook_normal.jpg   981CEB F5D3A9 0F0704 F5F5F5 0 0 0 0 0 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
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
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
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
26334203 Maykuth Andrew Maykuth Philadelphia Inquirer business reporter. I cover energy and gambling. Go figure. Philadelphia, Pa. http://www.philly.com 0 2641 291 183 2009-03-24T21:52:53+00:00 16     0 1 3990   0 0 0 313670 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/723519448578068480/C0ClxES7_normal.jpg https://pbs.twimg.com/profile_images/723519448578068480/C0ClxES7_normal.jpg https://pbs.twimg.com/profile_banners/26334203/1563976221 0084B4 FFFFFF C1EBD4 333333 0 0 0 0 0 0 none
29932001 BA1245 Barbara E. Allen   Stanford!   0 269 442 11 2009-04-09T05:47:18+00:00 3202     0 0 714   0 0 0 642D8B http://abs.twimg.com/images/themes/theme10/bg.gif https://abs.twimg.com/images/themes/theme10/bg.gif 1 http://pbs.twimg.com/profile_images/378800000141484301/02014c3a8ae7efdbadbf9509de30b920_normal.jpeg https://pbs.twimg.com/profile_images/378800000141484301/02014c3a8ae7efdbadbf9509de30b920_normal.jpeg https://pbs.twimg.com/profile_banners/29932001/1373962775 FF0000 65B0DA 7AC3EE 3D1957 0 1 0 0 0 0 none
73257410 GWSchulz30 G.W. Schulz Hooman | It’s only fly-over country if you never land. http://SeeDisclaimer.com http://gwschulz.pressfolios.com     0 1474 1352 156 2009-09-10T23:59:12+00:00 205     0 0 2356   0 0 0 121010 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/557320335066804225/NsnhMMg6_normal.jpeg https://pbs.twimg.com/profile_images/557320335066804225/NsnhMMg6_normal.jpeg https://pbs.twimg.com/profile_banners/73257410/1397073159 D90B0B FFFFFF 080212 020C12 0 0 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
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
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
1356019962 hello_lope Lope Gutierrez-Ruiz @JSKstanford and @TEDFellow. Co-Founder of Gopher Magazine & In-House International. Exploring the future of our cities, open data, design, cultural management. Austin, TX http://weareinhouse.com 0 540 1398 42 2013-04-16T04:34:00+00:00 28169     1 0 853   0 0 0 00282A 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/472125271030497280/Fmp50e3j_normal.jpeg https://pbs.twimg.com/profile_images/472125271030497280/Fmp50e3j_normal.jpeg https://pbs.twimg.com/profile_banners/1356019962/1576599587 094142 390405 B7FFF3 A9D606 0 0 0 0 0 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

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