users

5 rows where geo_enabled = 0 and profile_background_image_url_https = "https://abs.twimg.com/images/themes/theme4/bg.gif"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: verified, profile_background_color, profile_background_tile, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, created_at (date)

profile_background_image_url_https ✖

  • https://abs.twimg.com/images/themes/theme4/bg.gif · 5 ✖

geo_enabled ✖

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
8956962 kirkcaraway Kirk Caraway Co-founder Megafone/NowAds, 2012-13 John S. Knight Fellow at Stanford University, online news entrepreneur http://GetMegafone.biz http://NowAds.biz 0 270 305 15 2007-09-18T18:11:50+00:00 5     0 0 574   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/1380527410/6928_1211958972974_1048746940_945503_2872192_n_normal.jpg https://pbs.twimg.com/profile_images/1380527410/6928_1211958972974_1048746940_945503_2872192_n_normal.jpg   0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
15120110 praeburn Paul Raeburn Journalist. Author. Producer, Gilbert Gottfried's Amazing Colossal Podcast. Passionate about journalism. Excited about comedy. New York, NY http://www.paulraeburn.com 0 3902 648 228 2008-06-14T21:45:49+00:00 545     0 0 5132   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 1 http://pbs.twimg.com/profile_images/55460608/Author_photo__color__normal.jpg https://pbs.twimg.com/profile_images/55460608/Author_photo__color__normal.jpg https://pbs.twimg.com/profile_banners/15120110/1357091546 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
16616757 IJNet IJNet IJNet offers journalism opportunities + resources in 8 languages. Also follow: @ICFJ @IJNetArabic @IJNetPortugues @IJNet_Russian @ijnetEs @IJNetPersian @IJNetfr Washington, D.C. http://ijnet.org 0 43360 1735 1506 2008-10-06T17:41:24+00:00 3987     0 1 45126   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 1 http://pbs.twimg.com/profile_images/1081270424548360192/o4WozzAX_normal.jpg https://pbs.twimg.com/profile_images/1081270424548360192/o4WozzAX_normal.jpg https://pbs.twimg.com/profile_banners/16616757/1541564431 009FDA 5ED4DC F3C262 3C3940 1 0 0 0 0 0 none
27981533 theparagrapher Elaine Ray Journalist, writer, family historian, Stanford, CA http://www.ebenezerray.com 0 138 197 6 2009-03-31T22:31:19+00:00 21     0 0 248   0 0 0 000000 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/854198940387778560/SDp4hKIn_normal.jpg https://pbs.twimg.com/profile_images/854198940387778560/SDp4hKIn_normal.jpg   E81C4F 000000 000000 000000 0 0 0 0 0 0 none
2373280040 HiromiSHorie 堀江広美 Bloomberg News東京支局記者・編集者/JBN Finance&Credit TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解   https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie 0 1602 1012 26 2014-03-05T06:33:39+00:00 2257     0 1 4244   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/441103544498667520/VOQ6QSVn_normal.jpeg https://pbs.twimg.com/profile_images/441103544498667520/VOQ6QSVn_normal.jpeg https://pbs.twimg.com/profile_banners/2373280040/1523746300 0099B9 5ED4DC 95E8EC 3C3940 1 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 120.898ms · About: simonw/jsk-fellows-on-twitter