users

12 rows where profile_background_image_url_https = "https://abs.twimg.com/images/themes/theme4/bg.gif"

✎ View and edit SQL

This data as json, CSV (advanced)

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

profile_background_tile ✖

  • 0 10
  • 1 2

has_extended_profile ✖

  • 0 11
  • 1 1

profile_background_image_url_https ✖

  • https://abs.twimg.com/images/themes/theme4/bg.gif · 12 ✖
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
8956962 kirkcaraway Kirk Caraway Co-founder Megafone/NowAds, 2012-13 John S. Knight Fellow at Stanford University, online news entrepreneur http://GetMegafone.biz http://NowAds.biz 0 270 305 15 2007-09-18T18:11:50+00:00 5     0 0 574   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/1380527410/6928_1211958972974_1048746940_945503_2872192_n_normal.jpg https://pbs.twimg.com/profile_images/1380527410/6928_1211958972974_1048746940_945503_2872192_n_normal.jpg   0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
9720702 psullivan1 Patricia Sullivan Washington Post reporter, old and new media. Founded Good Morning Silicon Valley, one of first blogs. patricia.sullivan@washpost.com D.C. http://muckrack.com/psullivan1 0 3116 815 144 2007-10-26T21:01:17+00:00 2470     1 1 10403   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/1094630331313987587/BzBcgPJO_normal.jpg https://pbs.twimg.com/profile_images/1094630331313987587/BzBcgPJO_normal.jpg https://pbs.twimg.com/profile_banners/9720702/1398288851 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
15120110 praeburn Paul Raeburn Journalist. Author. Producer, Gilbert Gottfried's Amazing Colossal Podcast. Passionate about journalism. Excited about comedy. New York, NY http://www.paulraeburn.com 0 3902 648 228 2008-06-14T21:45:49+00:00 545     0 0 5132   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 1 http://pbs.twimg.com/profile_images/55460608/Author_photo__color__normal.jpg https://pbs.twimg.com/profile_images/55460608/Author_photo__color__normal.jpg https://pbs.twimg.com/profile_banners/15120110/1357091546 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
16616757 IJNet IJNet IJNet offers journalism opportunities + resources in 8 languages. Also follow: @ICFJ @IJNetArabic @IJNetPortugues @IJNet_Russian @ijnetEs @IJNetPersian @IJNetfr Washington, D.C. http://ijnet.org 0 43360 1735 1506 2008-10-06T17:41:24+00:00 3987     0 1 45126   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 1 http://pbs.twimg.com/profile_images/1081270424548360192/o4WozzAX_normal.jpg https://pbs.twimg.com/profile_images/1081270424548360192/o4WozzAX_normal.jpg https://pbs.twimg.com/profile_banners/16616757/1541564431 009FDA 5ED4DC F3C262 3C3940 1 0 0 0 0 0 none
17188930 NoluCN Nolu Crockett-Ntonga Global Communications and Parternership Builder. Web Content Strategist. Africa Watcher, International Development Advocate. Washington, DC http://www.NoluCN.com 0 197 227 9 2008-11-05T14:11:41+00:00 3     1 0 388   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/636266399921479680/nfopGlaC_normal.jpg https://pbs.twimg.com/profile_images/636266399921479680/nfopGlaC_normal.jpg https://pbs.twimg.com/profile_banners/17188930/1440531484 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
19002133 MonikaBauerlein Monika Bauerlein CEO, Mother Jones. Lover of politics, coffee, philosophy, debate, garlic. Views, RTs, lame jokes my own. She/they, and K not C. San Francisco, CA http://www.motherjones.com/authors/monika-bauerlein 0 13752 1813 469 2009-01-14T23:48:18+00:00 728     1 1 5198   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/550679254254366720/HznGJBcr_normal.png https://pbs.twimg.com/profile_images/550679254254366720/HznGJBcr_normal.png   0099B9 FFFFFF 95E8EC 3C3940 1 0 0 0 0 0 none
27981533 theparagrapher Elaine Ray Journalist, writer, family historian, Stanford, CA http://www.ebenezerray.com 0 138 197 6 2009-03-31T22:31:19+00:00 21     0 0 248   0 0 0 000000 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/854198940387778560/SDp4hKIn_normal.jpg https://pbs.twimg.com/profile_images/854198940387778560/SDp4hKIn_normal.jpg   E81C4F 000000 000000 000000 0 0 0 0 0 0 none
55367101 degarciaknight Dawn Garcia Director, John S. Knight Journalism Fellowships, Stanford; #innovation #leadership #diversity Past President @womenjournos Former @mercnews @sfchronicle @modbee Stanford, California http://knight.stanford.edu 0 4022 1433 179 2009-07-09T21:24:01+00:00 9043     1 0 6860   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/1069095798699261953/ie9YN3yY_normal.jpg https://pbs.twimg.com/profile_images/1069095798699261953/ie9YN3yY_normal.jpg https://pbs.twimg.com/profile_banners/55367101/1398562860 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 1 0 none
141222005 TereBouza Teresa Bouza Innovation, Media, Tech || Knight Fellow '12 @Stanford || Columbia J-School '04 || 2012 IWMF grantee || Co-author of "A Sense of Something Greater" (Sept. 2018) Silicon Valley http://goo.gl/UCfsJc 0 1026 868 96 2010-05-07T13:49:50+00:00 357     1 0 1410   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/1663328827/Teresa_Bouza_normal.JPG https://pbs.twimg.com/profile_images/1663328827/Teresa_Bouza_normal.JPG https://pbs.twimg.com/profile_banners/141222005/1540056326 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
399433780 najiaashar Najia Ashar Broadcast Journalist-Entrepreneur-Founder @MBaithak - @Gnmionline - Knight Fellow @JSKStanford - Fellow @EastWestCenter - RTs are not endorsements Karachi, Pakistan http://www.gnmionline.org 0 226285 788 226 2011-10-27T13:58:52+00:00 5254     1 1 5556   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/718785979444805633/bY2RmUC5_normal.jpg https://pbs.twimg.com/profile_images/718785979444805633/bY2RmUC5_normal.jpg https://pbs.twimg.com/profile_banners/399433780/1555171216 0099B9 5ED4DC 95E8EC 3C3940 1 1 0 0 0 0 none
847882850 nicoleMfoy Nicole Foy Investigative reporter @IdahoStatesman & @JSKStanford fellow covering Latinos, agriculture & shady government. Formerly @TheIdahoPress & @TheLatinoCard Boise, ID https://www.idahostatesman.com/profile/231816898 0 3955 3647 95 2012-09-26T18:23:44+00:00 39115     1 0 12475   0 0 0 ACDED6 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/1275117721936519168/lAThpOVK_normal.jpg https://pbs.twimg.com/profile_images/1275117721936519168/lAThpOVK_normal.jpg https://pbs.twimg.com/profile_banners/847882850/1585518630 0FEFF7 FFFFFF 95E8EC 3C3940 1 0 0 0 0 0 none
2373280040 HiromiSHorie 堀江広美 Bloomberg News東京支局記者・編集者/JBN Finance&Credit TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解   https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie 0 1602 1012 26 2014-03-05T06:33:39+00:00 2257     0 1 4244   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/441103544498667520/VOQ6QSVn_normal.jpeg https://pbs.twimg.com/profile_images/441103544498667520/VOQ6QSVn_normal.jpeg https://pbs.twimg.com/profile_banners/2373280040/1523746300 0099B9 5ED4DC 95E8EC 3C3940 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 125.635ms · About: simonw/jsk-fellows-on-twitter