users

6 rows where profile_background_image_url = "http://abs.twimg.com/images/themes/theme13/bg.gif" sorted by has_extended_profile

View and edit SQL

Suggested facets: location, geo_enabled, 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, has_extended_profile, created_at (date)

profile_background_image_url

  • http://abs.twimg.com/images/themes/theme13/bg.gif · 6

default_profile

  • 0 6
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
15751494 robertaoster Roberta Oster Communications Director for @vainterfaith. Advocating economic, racial & environmental justice. Former TV news producer. tweets are my own. Richmond, Virginia http://www.robertaoster.com 0 405 835 13 2008-08-06T15:57:15+00:00 295     1 0 184   0 0 0 B2DFDA http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/760287215536726016/rp5iSRvK_normal.jpg https://pbs.twimg.com/profile_images/760287215536726016/rp5iSRvK_normal.jpg https://pbs.twimg.com/profile_banners/15751494/1554153355 EEEEEE FFFFFF 333333 1 0 0 0 0 0 none
16672162 vxflores Veronica Flores-Paniagua External Affairs Advisor @Chevron, ex-journo, #energy & #education policy junkie; @UHouston-ex; #runner; 2000 @JSKStanford fellow. RT ≠ endorsement iPhone: 29.463654,-98.473572 http://www.chevron.com 0 3951 3542 200 2008-10-09T19:37:34+00:00 4810     1 1 12178   0 0 0 000000 http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/951839489705439232/QQix8IDA_normal.jpg https://pbs.twimg.com/profile_images/951839489705439232/QQix8IDA_normal.jpg https://pbs.twimg.com/profile_banners/16672162/1533060691 000000 000000 000000 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 EEEEEE FFFFFF 333333 0 0 0 0 0 0 none
33964434 donnaborak Donna Borak Adjunct Faculty @NYU. Senior Economics Journalist. Alum of @CNN @WSJ @AP @AmerBanker and @UPI. 2015 JSK @Stanford Fellow. Yoga teacher. 🧘‍♀️ Globetrotter. Washington   0 5956 3161 266 2009-04-21T17:00:53+00:00 1464     0 1 9718   0 0 0 000000 http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/883050113882521601/5_6nNAs7_normal.jpg https://pbs.twimg.com/profile_images/883050113882521601/5_6nNAs7_normal.jpg https://pbs.twimg.com/profile_banners/33964434/1584126644 000000 000000 000000 0 0 0 0 0 0 none
31150056 izamoi izabela moi journalist. jornalista. journaliste. periodista. giornalista.     0 312 149 20 2009-04-14T15:43:48+00:00 43     0 0 14   0 0 0 B2DFDA http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/959122174568169473/Big4ESpN_normal.jpg https://pbs.twimg.com/profile_images/959122174568169473/Big4ESpN_normal.jpg   EEEEEE FFFFFF 333333 1 1 0 0 0 0 none
84439535 MaritzaLFelix Maritza L. Félix Periodista y amante de las letras. Me gustan los acentos bien puestos. Los gerundios me empachan. Fundadora de @ConectaArizona. Me dicen #ToñitaMachetes.   http://maritzafelix.com 0 1643 1456 24 2009-10-22T22:22:56+00:00 4094     1 0 5001   0 0 0 B2DFDA http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/1248379793789214723/axtyAxkC_normal.jpg https://pbs.twimg.com/profile_images/1248379793789214723/axtyAxkC_normal.jpg https://pbs.twimg.com/profile_banners/84439535/1594084778 EEEEEE FFFFFF 333333 1 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 165.884ms · About: simonw/jsk-fellows-on-twitter