users

2 rows where "created_at" is on date 2009-01-20

View and edit SQL

created_at (date)

  • 2009-01-20 · 2
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
19244373 tgdavidson Tom Davidson Attempting to invent the future of media without blowing up Beeker in the process. Opinions here are mine, not those of employers past, present or future. SEVa, Tysons Corner, and I-95 http://tgdavidson.com 0 845 758 79 2009-01-20T16:47:45+00:00 185     1 0 2900   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/141192598/TomDavidsonLoRes_normal.jpg https://pbs.twimg.com/profile_images/141192598/TomDavidsonLoRes_normal.jpg   C0DEED DDEEF6 333333 1 0 1 0 0 0 none
19257632 aaronkfoley Scarin’ Foley 🎃 Black Media Initiative director @CCMNewmarkJ | priors @jskstanford '20, @cityofdetroit storyteller | ✊🏽🏳️‍🌈 | books @belt_publishing | email 👍🏽, DMs 👎🏽 NY borough/Detroit thorough http://www.aaronkfoley.com 0 6808 1606 175 2009-01-20T21:10:41+00:00 8946     0 0 41796   0 0 0 000000 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/1304863918255464449/crvCxgI4_normal.jpg https://pbs.twimg.com/profile_images/1304863918255464449/crvCxgI4_normal.jpg https://pbs.twimg.com/profile_banners/19257632/1567314628 000000 000000 000000 0 0 0 0 1 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 146.233ms · About: simonw/jsk-fellows-on-twitter