users

9 rows where profile_background_tile = 1 and profile_sidebar_border_color = "C0DEED"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, protected, geo_enabled, verified, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_link_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, has_extended_profile, following, created_at (date)

profile_sidebar_border_color ✖

  • C0DEED · 9 ✖

profile_background_tile ✖

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
34060703 menesesportatil Juan Pablo Meneses Director en @UniPortatil /Profesor en @Uchile y @UABBarcelona /Antes @Stanford, @NYUniversity, @Usach /Escritor de no ficción / Seguidor de la religión portátil Santiago, Chile http://uportatil.org 0 9830 455 264 2009-04-21T22:03:56+00:00 1949     1 0 7016   0 0 0 C0DEED 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/1089996441848897536/nDuc1zQi_normal.jpg https://pbs.twimg.com/profile_images/1089996441848897536/nDuc1zQi_normal.jpg https://pbs.twimg.com/profile_banners/34060703/1536602204 0084B4 C0DEED DDEEF6 333333 1 0 0 0 0 0 none
101255581 theoestein Theo Stein Cranky Yankee besotted by the West. Lafayette, Colo.   0 116 267 7 2010-01-02T16:13:01+00:00 1833     0 0 215   0 0 0 C0DEED 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/514914135675400192/PeDxFVZF_normal.jpeg https://pbs.twimg.com/profile_images/514914135675400192/PeDxFVZF_normal.jpeg https://pbs.twimg.com/profile_banners/101255581/1437846150 0084B4 C0DEED DDEEF6 333333 1 0 0 0 0 0 none
110905920 wjchat wjchat #wjchat is a chat for web journalists on Wednesdays at 5 p.m. PT. We talk about all things content, technology, ethics, & business of journalism on the web. Everywhere you are http://wjchat.com 0 8759 0 669 2010-02-03T04:38:38+00:00 0     0 0 24074   0 0 0 FFFFFF 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/1830163265/wjchat-twitter-icon_normal.png https://pbs.twimg.com/profile_images/1830163265/wjchat-twitter-icon_normal.png   0B0061 C0DEED 08BDFF 000000 0 0 0 0 0 0 none
165426547 jeremyadamsmith Jeremy Adam Smith I edit @greatergoodsc & write for @SFPublicPress @sciam & more. Former @JSKstanford. Contact: jeremysmith (at) http://berkeley.edu San Francisco Bay Area   0 4530 3943 157 2010-07-11T14:48:53+00:00 1206     1 0 8825   0 0 0 C0DEED 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/431901512193695744/h1DcujO__normal.jpeg https://pbs.twimg.com/profile_images/431901512193695744/h1DcujO__normal.jpeg https://pbs.twimg.com/profile_banners/165426547/1527894602 1B95E0 C0DEED DDEEF6 333333 1 0 0 0 0 0 none
168183999 peterdicampo Peter DiCampo Photographer. Cofounder @everydayafrica @evdayprojects. Co-author @photo_rights. 2019 @JSKstanford Fellow. Bad guitarist. Wannabe comic book writer.   https://www.everydayprojects.org/ 0 4238 1854 156 2010-07-18T16:49:04+00:00 1914     0 0 1433   0 0 0 C0DEED 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/542857997886554113/m1rb6hOg_normal.jpeg https://pbs.twimg.com/profile_images/542857997886554113/m1rb6hOg_normal.jpeg https://pbs.twimg.com/profile_banners/168183999/1564199885 0084B4 C0DEED DDEEF6 333333 1 0 0 0 1 0 none
331451880 karl_vick Karl Vick Editor at Large with TIME magazine in NYC, after 4 years in Jerusalem bureau, and 16 at the Washington Post in Rockville, Nairobi, Istanbul, Baghdad and LA.   http://time.com 0 4737 576 168 2011-07-08T05:52:41+00:00 1069     0 1 4080   0 0 0 C0DEED 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/1709758772/Kandahar_normal.jpg https://pbs.twimg.com/profile_images/1709758772/Kandahar_normal.jpg https://pbs.twimg.com/profile_banners/331451880/1456280984 0084B4 C0DEED DDEEF6 333333 1 0 0 0 0 0 none
421725730 michaeljrain Michael Rain Digital Storyteller & Speaker // Founder @ENODI_ // @TEDtalks Speaker & Resident // Fellow @JSKstanford @TowKnightCenter // @Columbia alum 🇺🇸🇬🇭 Palo Alto, CA http://www.michaelra.in 0 922 818 57 2011-11-26T09:12:00+00:00 12413     0 0 5361   0 0 0 C0DEED 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/822773325650923520/EiDMafXm_normal.jpg https://pbs.twimg.com/profile_images/822773325650923520/EiDMafXm_normal.jpg https://pbs.twimg.com/profile_banners/421725730/1485196771 0084B4 C0DEED DDEEF6 333333 1 1 0 0 1 0 none
555484188 edalziel Elizabeth Dalziel photographer specializing in everything London http://www.elizabethdalziel.com 0 435 357 30 2012-04-16T20:30:47+00:00 407     1 0 1010   0 0 0 C0DEED 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/2138810142/ElizabethDalziel_normal.jpg https://pbs.twimg.com/profile_images/2138810142/ElizabethDalziel_normal.jpg   0084B4 C0DEED DDEEF6 333333 1 0 0 0 0 0 none
588357987 semaanmariam mariam semaan #Knight #Fellow 2012/13 #Stanford #University #DesignThinking#Media expert #Designer of #Experiences #vintage clothes and accessories #collector     1 207 219 16 2012-05-23T13:11:28+00:00 59     0 0 694   0 0 0 642D8B http://abs.twimg.com/images/themes/theme10/bg.gif https://abs.twimg.com/images/themes/theme10/bg.gif 1 http://pbs.twimg.com/profile_images/2243512422/1985-monet-ad_normal.jpg https://pbs.twimg.com/profile_images/2243512422/1985-monet-ad_normal.jpg   FF3300 C0DEED DDEEF6 333333 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 98.456ms · About: simonw/jsk-fellows-on-twitter