users

7 rows where profile_background_image_url = "http://abs.twimg.com/images/themes/theme1/bg.png" and profile_sidebar_border_color = "87BC44"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, verified, profile_background_color, profile_background_tile, profile_link_color, profile_sidebar_fill_color, has_extended_profile, following, created_at (date)

profile_sidebar_border_color ✖

  • 87BC44 · 7 ✖

profile_background_image_url ✖

  • http://abs.twimg.com/images/themes/theme1/bg.png · 7 ✖
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
29283 tigerbeat Steve Rhodes Photojournalist Also @tigerbeat @instagram Don't embed my photos as tweets/Instagram in stories Pay for my work DM or srhodes gmail Signal available on request San Francisco http://www.flickr.com/ari 0 10265 11305 726 2006-11-29T01:51:08+00:00 528568     1 0 572750   0 0 0 9AE4E8 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/1763378768/image_normal.jpg https://pbs.twimg.com/profile_images/1763378768/image_normal.jpg https://pbs.twimg.com/profile_banners/29283/1396025539 0000FF 87BC44 E0FF92 000000 1 1 0 0 0 0 none
770729 lizgannes Liz Gannes My last name rhymes with braaains. San Francisco http://60db.co 0 68124 2906 2171 2007-02-13T23:05:04+00:00 1015     1 1 6246   0 0 0 8EDA42 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/471712372659216385/eM4o7S3H_normal.jpeg https://pbs.twimg.com/profile_images/471712372659216385/eM4o7S3H_normal.jpeg https://pbs.twimg.com/profile_banners/770729/1401690657 0000FF 87BC44 E0FF91 000000 1 0 0 0 1 0 none
2400471 tsar Kaizar Campwala Exploring the chasms and commons between good citizenship and good business | @abc New York   0 894 604 74 2007-03-27T04:02:02+00:00 1666     1 0 1844   0 0 0 9AE4E8 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/793220688999952386/xGmSs7Zj_normal.jpg https://pbs.twimg.com/profile_images/793220688999952386/xGmSs7Zj_normal.jpg   FA743E 87BC44 E0FF92 000000 1 1 0 0 0 0 none
6199412 jim_colgan Jim Colgan Radio/media/tech. Stanford JSK fellow. Previously Audible, WNYC, SoundCloud. California via New York via Dublin. San Francisco   0 2045 2277 89 2007-05-21T13:35:41+00:00 1513     1 0 4270   0 0 0 9AE4E8 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/1217308517494747136/8FDoKzpJ_normal.jpg https://pbs.twimg.com/profile_images/1217308517494747136/8FDoKzpJ_normal.jpg   4A913C 87BC44 E0FF92 000000 1 0 0 0 1 0 none
7805322 Rosental Rosental Professor, Knight Chair in Journalism/UNESCO Chair in Communication, founder/director Knight Center for Journalism in the Americas,University of Texas at Austin Austin, Texas http://knightcenter.utexas.edu 0 28097 1327 1479 2007-07-29T22:59:41+00:00 4211     1 1 28632   0 0 0 9AE4E8 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/728995740270268416/DzENDi1E_normal.jpg https://pbs.twimg.com/profile_images/728995740270268416/DzENDi1E_normal.jpg https://pbs.twimg.com/profile_banners/7805322/1595091309 0000FF 87BC44 E0FF92 000000 1 0 0 0 0 0 none
8143682 jure Jure Leskovec Professor of #computerscience @Stanford; Chief Scientist @Pinterest; Investigator @czbiohub. #datamining #machinelearning #networks. Stanford, CA http://cs.stanford.edu/~jure/ 0 26536 291 783 2007-08-12T18:14:57+00:00 314     1 0 929   0 0 0 9AE4E8 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/1685688919/Jure-6a_normal.jpg https://pbs.twimg.com/profile_images/1685688919/Jure-6a_normal.jpg   0000FF 87BC44 E0FF92 000000 1 0 0 0 0 0 none
10794392 kjmccoy Kathleen McCoy Good old dog Clare passed in May, 2014. Puppy arrived in August. Her name is Kiska. Anchorage   0 314 894 13 2007-12-02T21:45:12+00:00 494     1 0 374   0 0 0 9AE4E8 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/53077134/twitter2_normal.jpg https://pbs.twimg.com/profile_images/53077134/twitter2_normal.jpg   0000FF 87BC44 E0FF92 000000 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 117.368ms · About: simonw/jsk-fellows-on-twitter