users

12 rows where default_profile_image = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, location, protected, friends_count, listed_count, favourites_count, geo_enabled, verified, statuses_count, profile_background_color, profile_background_tile, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, default_profile, created_at (date)

profile_use_background_image ✖

  • 1 11
  • 0 1

default_profile_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
17787248 RichardGonzalesNPR Richard Gonzales NPR       0 228 1 30 2008-12-01T19:55:08+00:00 0     0 0 0   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
20632365 broessner barbara roessner       0 20 1 1 2009-02-11T21:54:11+00:00 0     0 0 0   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 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
31303305 agnescusack agnes cusack Journalist Melbourne http://www.newaustraliamedia.org 0 108 508 4 2009-04-15T01:57:51+00:00 45     1 0 14   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
40381878 kimkom Kim Komenich   Mill Valley, CA http://kimkom.com 0 107 24 11 2009-05-16T01:35:04+00:00 1     0 0 62   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
41007644 MBStannard Matthew B. Stannard       1 16 140 8 2009-05-19T00:11:54+00:00 2     0 0 449   0 0 0 9AE4E8 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 1 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 323630 EAECE9 333333 1 0 0 1 0 0 none
66732477 bonjomo Bonnie Jo Mount       0 118 234 11 2009-08-18T16:58:07+00:00 127     0 0 54   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
86097492 armaoj jo-ann armao       0 178 471 20 2009-10-29T15:52:11+00:00 95     0 0 91   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
157531033 watsonmeng watson ,meng       0 38 0 2 2010-06-20T03:08:34+00:00 0     0 0 0   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
915830820 VVuorikoski Veikko Vuorikoski       0 3 22 2 2012-10-31T00:53:25+00:00 12     0 0 0   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
1003951466 SlawomirZagorsk Slawomir Zagorski       0 32 0 2 2012-12-11T12:35:36+00:00 0     0 0 1   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 0 0 none
1343792784 AnimatedPress Animated Press       0 19 0 1 2013-04-11T07:54:02+00:00 0     0 0 0   0 0 0 C0DEED 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   1DA1F2 C0DEED DDEEF6 333333 1 0 1 1 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 116.019ms · About: simonw/jsk-fellows-on-twitter