users

17 rows where profile_background_image_url = "http://abs.twimg.com/images/themes/theme9/bg.gif"

View and edit SQL

Suggested facets: listed_count, geo_enabled, verified, profile_background_color, profile_background_tile, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_use_background_image, has_extended_profile, following, created_at (date)

profile_text_color

profile_background_image_url_https

profile_background_image_url

  • http://abs.twimg.com/images/themes/theme9/bg.gif · 17
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
8441632 burtherman Burt Herman Entrepreneurial journalist finding meaning in the noise. Now: Product @CondeNast. Always: @HacksHackers. Previous: @LenfestInst, Co-founder @Storify, @AP New York, NY http://burtherman.com 0 9235 1964 971 2007-08-26T14:23:45+00:00 1951     1 1 6762   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/67612383/XWS147_normal.jpg https://pbs.twimg.com/profile_images/67612383/XWS147_normal.jpg https://pbs.twimg.com/profile_banners/8441632/1537899498 181A1E 252429 666666 1 1 0 0 0 0 none
9078442 agventcnn Greg Agvent Senior Director CNN Aerial Imagery &. Reporting Atlanta, USA   0 2192 292 57 2007-09-24T21:20:08+00:00 17     1 0 300   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/652194249329541120/IiWdURMo_normal.jpg https://pbs.twimg.com/profile_images/652194249329541120/IiWdURMo_normal.jpg   181A1E 252429 666666 1 0 0 0 0 0 none
14766481 zajoryn RODRIGOCARPIO   Fort Lauderdale, FL, USA http://www.zajorynproductions.com 0 60 425 3 2008-05-13T23:45:17+00:00 16     1 0 4558   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1012195814721118208/fL2SC42w_normal.jpg https://pbs.twimg.com/profile_images/1012195814721118208/fL2SC42w_normal.jpg https://pbs.twimg.com/profile_banners/14766481/1530161449 181A1E 252429 666666 1 1 0 0 0 0 none
17714681 filloux Frederic Filloux Entrepreneur (http://Deepnews.ai), editor of http://mondaynote.com, associate journalism professor at Sciences Po J-school in Paris. Paris, France https://mondaynote.com 0 9008 836 601 2008-11-28T18:03:11+00:00 400     0 0 2519   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/651008959625699328/k9xO_jl9_normal.jpg https://pbs.twimg.com/profile_images/651008959625699328/k9xO_jl9_normal.jpg https://pbs.twimg.com/profile_banners/17714681/1444047489 181A1E 252429 666666 1 0 0 0 0 0 none
20951229 Avilesm Mary Aviles But first, the facts. Bay Area   0 982 1645 100 2009-02-16T00:45:08+00:00 2175     1 0 10648   0 0 0 000000 http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/774407383225241600/ova_ee1L_normal.jpg https://pbs.twimg.com/profile_images/774407383225241600/ova_ee1L_normal.jpg https://pbs.twimg.com/profile_banners/20951229/1469737117 000000 000000 000000 0 0 0 0 0 0 none
24661811 mikegrantme Michael Grant Teaching Fellow @Google News Lab. Founder @GetCurrentNow. Priors: UX @Reveal, @JSKstanford Fellow '18, @StarTribune + @SFChronicle. Views are my own. Menlo Park, CA https://mikegrant.me 0 2461 2705 142 2009-03-16T07:02:19+00:00 2980     1 0 2155   0 0 0 000000 http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1315155250240614401/YImoCG-K_normal.jpg https://pbs.twimg.com/profile_images/1315155250240614401/YImoCG-K_normal.jpg https://pbs.twimg.com/profile_banners/24661811/1602392657 000000 000000 000000 0 1 0 0 1 0 none
57621331 watchup Watchup Unleash the power of video journalism. On iOS, Android, Amazon Fire & Wii U Menlo Park, California http://watchup.com 0 2329 443 133 2009-07-17T11:43:04+00:00 1059     1 0 6634   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/452568953965903872/P4aLaoqW_normal.png https://pbs.twimg.com/profile_images/452568953965903872/P4aLaoqW_normal.png https://pbs.twimg.com/profile_banners/57621331/1462470271 181A1E 252429 666666 1 0 0 0 0 0 none
84472525 stanfordstory Stanford Storytelling Project An arts program at Stanford University exploring the power & craft of great, oral storytelling, traditional or modern, from Lakota tales to Radiolab. Stanford, CA http://storytelling.stanford.edu 0 5578 707 222 2009-10-23T01:20:40+00:00 1225     1 0 1884   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 1 http://pbs.twimg.com/profile_images/1263170445685035009/KDT7AOs6_normal.jpg https://pbs.twimg.com/profile_images/1263170445685035009/KDT7AOs6_normal.jpg https://pbs.twimg.com/profile_banners/84472525/1589924007 181A1E 252429 666666 1 0 0 0 0 0 none
103761767 Skellor Russell Skelton Director RMIT ABC Fact Check. Views my own, links and retweets not. Melbourne, Victoria   0 3301 1197 133 2010-01-11T04:57:36+00:00 1019     1 0 15151   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/378800000042613328/086cee2400eef0b85b6ada6e1862dd38_normal.jpeg https://pbs.twimg.com/profile_images/378800000042613328/086cee2400eef0b85b6ada6e1862dd38_normal.jpeg   181A1E 252429 666666 1 0 0 0 0 0 none
105381785 susrust Susanne Rust Investigative Reporter @latimes California, USA http://www.latimes.com/la-bio-susanne-rust-staff.html 0 2012 1271 0 2010-01-16T05:17:40+00:00 3092     1 1 2332   0 0 0 1B1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 1 http://pbs.twimg.com/profile_images/689837497254154241/LcY_jR_k_normal.jpg https://pbs.twimg.com/profile_images/689837497254154241/LcY_jR_k_normal.jpg https://pbs.twimg.com/profile_banners/105381785/1453305385 181A1E 252429 9294A1 1 0 0 0 0 0 none
200120015 katywnewton Katy Newton UX Researcher + Developer, Emergent Media, Stanford http://d.school Media Experiments Resident, IDEONY, @JSKStanford Fellow @latimes Brooklyn, San Francisco http://katynewton.com 0 793 469 57 2010-10-08T14:02:56+00:00 2065     1 0 1246   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1218264364148514816/t3NOeQQn_normal.jpg https://pbs.twimg.com/profile_images/1218264364148514816/t3NOeQQn_normal.jpg https://pbs.twimg.com/profile_banners/200120015/1485380832 181A1E 252429 666666 1 0 0 0 0 0 none
263734042 DBleizeffer Dustin Bleizeffer Freelance journalist, John S. Knight Journalism fellow-2017, former @WyoFile, @CSTribune, always #Wyoming #WestNext #ruralwest #climate #energy   http://dustinbleizeffer.com 0 2004 1969 133 2011-03-10T16:50:22+00:00 11265     1 0 8821   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/3154277300/8237da00a2e69e95123c62a63c29ba59_normal.jpeg https://pbs.twimg.com/profile_images/3154277300/8237da00a2e69e95123c62a63c29ba59_normal.jpeg https://pbs.twimg.com/profile_banners/263734042/1398258674 000000 000000 000000 1 0 0 0 0 0 none
286957126 Hoshmedia Hosh media Pakistan's media 2.0. For the youth, by the youth. Pakistan http://hoshmedia.org 0 139 127 4 2011-04-24T01:44:46+00:00 0     0 0 420   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1342194177/favicon1_normal.jpg https://pbs.twimg.com/profile_images/1342194177/favicon1_normal.jpg   181A1E 131314 F5F5F5 1 0 0 0 0 0 none
516794788 cherokee_editor Bryan Pollard associate director, @najournalists; former JSK Fellow, @jskstanford; former exec editor, @CherokeePhoenix; founder @streetroots, board member, @highcountrynews Fayetteville, AR   0 973 143 15 2012-03-06T19:10:04+00:00 407     0 0 298   0 0 0 000000 http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1202017989794512897/b5TBWCxa_normal.jpg https://pbs.twimg.com/profile_images/1202017989794512897/b5TBWCxa_normal.jpg https://pbs.twimg.com/profile_banners/516794788/1594162479 000000 000000 000000 0 1 0 0 1 0 none
607245696 BrownInstitute The Brown Institute The David and Helen Gurley Brown Institute for Media Innovation. A joint endeavor of Columbia and Stanford Universities for shaping the future of media. New York City and Stanford http://browninstitute.org 0 3827 483 162 2012-06-13T12:21:42+00:00 309     1 0 2186   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/530452918873231360/w4E2GTrg_normal.jpeg https://pbs.twimg.com/profile_images/530452918873231360/w4E2GTrg_normal.jpeg https://pbs.twimg.com/profile_banners/607245696/1426524703 181A1E 252429 666666 1 0 0 0 0 0 none
749768262 KO_616 Akoto Ofori-Atta managing editor @teamtrace. @jskstanford 2014-2015/for life. BK/NJ/Ghana. Brooklyn, NY   0 3289 2237 111 2012-08-10T17:50:25+00:00 5271     1 1 3632   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/433027900372439040/juWad5F3_normal.jpeg https://pbs.twimg.com/profile_images/433027900372439040/juWad5F3_normal.jpeg https://pbs.twimg.com/profile_banners/749768262/1418086499 181A1E 252429 666666 1 0 0 0 0 0 none
1053480468 iGregoryJohnson Gregory Johnson modernizing tech for cities | http://CodeforSouth.org director | JSK @Stanford Fellow ‘20-21 | 🇯🇲 Florida http://www.higregory.com/about 0 939 366 79 2013-01-01T21:08:57+00:00 3334     1 0 4039   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1315100277880565760/Rw606ewD_normal.jpg https://pbs.twimg.com/profile_images/1315100277880565760/Rw606ewD_normal.jpg https://pbs.twimg.com/profile_banners/1053480468/1598846198 FFFFFF 252429 666666 0 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.112ms · About: simonw/jsk-fellows-on-twitter