users

119 rows where profile_use_background_image = 0 sorted by screen_name

✎ View and edit SQL

This data as json, CSV (advanced)

profile_use_background_image ✖

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
18231471 questionswork Andrew Finlayson EVP Digital/Social Strategy @SmithGeiger Helping storytellers on screens with research on 📺 OTT, video, SEO, website, mobile Author "Questions That Work" 👇 818-874-2000 http://questionswork.com 0 1891 4758 91 2008-12-19T01:49:46+00:00 1703     1 0 2900   0 0 0 70191C http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 0 http://pbs.twimg.com/profile_images/1103286408150769664/V5BZF_Is_normal.png https://pbs.twimg.com/profile_images/1103286408150769664/V5BZF_Is_normal.png https://pbs.twimg.com/profile_banners/18231471/1348586064 1B95E0 EEEEEE EFEFEF 333333 0 0 0 0 1 0 none
19563420 rosey18 Robert J. Rosenthal Exec. Dir. @ Center for Investigative Reporting, lifelong journalist, NYTimes, Boston Globe, Philly Inquirer, SF Chronicle, Africa Correspondent. Berkeley, CA http://centerforinvestigativereporting.org/ 0 3097 310 197 2009-01-26T22:42:21+00:00 6     0 0 5390   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/835264071561682944/CUtK0Gwp_normal.jpg https://pbs.twimg.com/profile_images/835264071561682944/CUtK0Gwp_normal.jpg   0084B4 C0DEED DDEEF6 333333 0 0 0 0 0 0 none
23795899 saintfabio Jim Walsh Mr. Brightside Minneapolis, MN   0 3132 2163 86 2009-03-11T17:33:08+00:00 19957     1 0 2359   0 0 0 000000 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/1298363089289506816/U7cEs4tl_normal.jpg https://pbs.twimg.com/profile_images/1298363089289506816/U7cEs4tl_normal.jpg https://pbs.twimg.com/profile_banners/23795899/1598390098 3B94D9 000000 000000 000000 0 0 0 0 0 0 none
1604288388 samsends Samaruddin Stewart Countering Disinformation @StateDept | Priors: @Journalism_360 & @ONA, Media + Tech @spj_tweets with @GoogleNewsInit, @knightfdn Grantee, @JSKStanford Fellow.. SF Bay Area http://www.linkedin.com/in/samaruddin/ 0 1222 2303 58 2013-07-18T20:50:38+00:00 6629     0 0 610   0 0 0 000000 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/378800000153153028/5493f08d616a25f43515ba2454ed61ec_normal.jpeg https://pbs.twimg.com/profile_images/378800000153153028/5493f08d616a25f43515ba2454ed61ec_normal.jpeg https://pbs.twimg.com/profile_banners/1604288388/1398957991 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
14130084 shazna Shazna Nessa Global Head of Visuals @WSJ + President, @ONA Board of Directors / Former Director, Journalism @knightfdn + @AP @CondeNast New York, NY   0 4991 1060 374 2008-03-12T04:35:38+00:00 1789     1 0 1599   0 0 0 D15C0F http://abs.twimg.com/images/themes/theme15/bg.png https://abs.twimg.com/images/themes/theme15/bg.png 0 http://pbs.twimg.com/profile_images/907373509961289729/Vqo9wZWD_normal.jpg https://pbs.twimg.com/profile_images/907373509961289729/Vqo9wZWD_normal.jpg https://pbs.twimg.com/profile_banners/14130084/1376351790 0084B4 FFFFFF C0DFEC 333333 0 0 0 0 0 0 none
50379519 sonniefron Sonni Efron President & COO, National Press Foundation. Journalism, foreign policy, democracy, human rights, technology, free expression, opinions my own, RTs not. Washington DC http://www.nationalpress.org 0 410 422 16 2009-06-24T17:55:58+00:00 205     0 0 813   0 0 0 000000 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/499964856099819520/eHWLlmXV_normal.jpeg https://pbs.twimg.com/profile_images/499964856099819520/eHWLlmXV_normal.jpeg   0084B4 000000 000000 000000 0 1 0 0 0 0 none
781961899835437056 spaceship_media Spaceship Media Journalism to bridge divides. Building communities, restoring trust in journalism, reducing polarization // spaceshipmedia@spaceshipmedia.org space http://spaceshipmedia.org 0 1410 743 59 2016-09-30T21:00:19+00:00 2020     0 0 501   0 0 0 000000 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/1062126154742525952/veTD_qgm_normal.jpg https://pbs.twimg.com/profile_images/1062126154742525952/veTD_qgm_normal.jpg https://pbs.twimg.com/profile_banners/781961899835437056/1516413473 1B95E0 000000 000000 000000 0 1 0 0 0 0 none
118263124 stanfordnlp Stanford NLP Group Computational Linguistics—Natural Language—Machine Learning—Deep Learning @chrmanning—@jurafsky—@percyliang—@ChrisGPotts—@tatsu_hashimoto at @StanfordAILab Stanford, CA, USA https://nlp.stanford.edu/ 0 96854 98 0 2010-02-28T03:28:05+00:00 1     0 0 7012   0 0 0 8C1515 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/1279513564793802752/UqI_jHb5_normal.jpg https://pbs.twimg.com/profile_images/1279513564793802752/UqI_jHb5_normal.jpg https://pbs.twimg.com/profile_banners/118263124/1524181760 8C1515 FFFFFF DDEEF6 333333 0 0 0 0 1 0 none
14145296 susie_c Susie Cagle 🔍👀💻✍️🎨 / climate, crisis, labor, business, technology, California +++ / susie.cagle@gmail / DMs always open Oakland, CA http://susiecagle.com 0 23441 2692 1120 2008-03-14T06:12:34+00:00 35932     0 1 45861   0 0 0 FFFFFF 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/881381260794318848/H0-Qgb48_normal.jpg https://pbs.twimg.com/profile_images/881381260794318848/H0-Qgb48_normal.jpg https://pbs.twimg.com/profile_banners/14145296/1561081102 299EE9 FFFFFF FFFFFF 000000 0 1 0 0 0 0 none
17684905 svwriter John Boudreau Vietnam bureau chief, Bloomberg News; formerly @mercnews Retweet ≠ endorsement. Hanoi, Vietnam http://www.bloomberg.com 0 1776 1695 105 2008-11-27T18:31:36+00:00 793     0 1 1623   0 0 0 000000 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/985803632565080064/oCfuC6Fb_normal.jpg https://pbs.twimg.com/profile_images/985803632565080064/oCfuC6Fb_normal.jpg https://pbs.twimg.com/profile_banners/17684905/1359234014 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
168580629 tayyebafridi Tayyeb Afridi Journalist| Radio & Online | Media Development | @JSKStanford |ICFJ 11 | RT≠Endorsement. Peshawar, Pakistan https://www.tnn.com.pk 0 877 747 28 2010-07-20T08:13:42+00:00 9507     1 0 7793   0 0 0 ABB8C2 http://abs.twimg.com/images/themes/theme6/bg.gif https://abs.twimg.com/images/themes/theme6/bg.gif 0 http://pbs.twimg.com/profile_images/1319780985454710785/s5YdeBTy_normal.jpg https://pbs.twimg.com/profile_images/1319780985454710785/s5YdeBTy_normal.jpg https://pbs.twimg.com/profile_banners/168580629/1602819977 FF691F FFFFFF A0C5C7 333333 0 1 0 0 0 0 none
880043087384412160 thebell_io The Bell 🔔The most important politics and business stories from Russia. Sign-up for our weekly email newsletter: http://thebell.io/en/   https://thebell.io/en/ 0 3160 103 101 2017-06-28T12:39:57+00:00 148     0 0 527   0 0 0 000000 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/1288083840972599298/kGAx_EWu_normal.jpg https://pbs.twimg.com/profile_images/1288083840972599298/kGAx_EWu_normal.jpg https://pbs.twimg.com/profile_banners/880043087384412160/1595938147 FF691F 000000 000000 000000 0 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
264340567 txtianmiller T. Christian Miller Senior investigative reporter @Propublica. Co-author of http://afalsereport.com. Into journalism that counts. And bacon. Pulitzer winner. Berkeley, CA http://www.propublica.org 0 8847 2015 329 2011-03-11T19:00:34+00:00 4504     1 1 6049   0 0 0 000000 http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 0 http://pbs.twimg.com/profile_images/545792431778590720/bdEY0hf7_normal.jpeg https://pbs.twimg.com/profile_images/545792431778590720/bdEY0hf7_normal.jpeg https://pbs.twimg.com/profile_banners/264340567/1573861549 19CF86 000000 000000 000000 0 0 0 0 0 0 none
16672162 vxflores Veronica Flores-Paniagua External Affairs Advisor @Chevron, ex-journo, #energy & #education policy junkie; @UHouston-ex; #runner; 2000 @JSKStanford fellow. RT ≠ endorsement iPhone: 29.463654,-98.473572 http://www.chevron.com 0 3951 3542 200 2008-10-09T19:37:34+00:00 4810     1 1 12178   0 0 0 000000 http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/951839489705439232/QQix8IDA_normal.jpg https://pbs.twimg.com/profile_images/951839489705439232/QQix8IDA_normal.jpg https://pbs.twimg.com/profile_banners/16672162/1533060691 981CEB 000000 000000 000000 0 0 0 0 0 0 none
423733810 weinmaier Klaus Weinmaier Digital Strategy & UserCentered Product Innovation, Founder http://TheEngagementLab.com; COO @tonioapp; Co-founder @derStandardat; Knight Affiliate '12 @JSKstanford New York, USA https://ch.linkedin.com/in/weinmaier 0 888 740 59 2011-11-28T21:38:46+00:00 304     1 0 1212   0 0 0 000000 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/3338702180/f5ea38075f4feeb90cec9ed1021b0e72_normal.jpeg https://pbs.twimg.com/profile_images/3338702180/f5ea38075f4feeb90cec9ed1021b0e72_normal.jpeg https://pbs.twimg.com/profile_banners/423733810/1550521929 ABB8C2 000000 000000 000000 0 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
159616650 womenjournos JAWS JAWS has been around for 35 years, fighting for the empowerment & growth of women journalists.   https://www.jaws.org 0 15010 9230 479 2010-06-25T21:58:49+00:00 11918     0 0 19703   0 0 0 000000 http://abs.twimg.com/images/themes/theme16/bg.gif https://abs.twimg.com/images/themes/theme16/bg.gif 0 http://pbs.twimg.com/profile_images/1263841746695454720/0thISQ9o_normal.png https://pbs.twimg.com/profile_images/1263841746695454720/0thISQ9o_normal.png https://pbs.twimg.com/profile_banners/159616650/1588867390 91D2FA 000000 000000 000000 0 0 0 0 0 0 none
33098630 writergirl Beatrice Motamedi John S. Knight Fellow at Stanford University 2014-15. Founder, Global Student Square. Co-director, Newsroom by the Bay. Adding youth voice to the news ecosystem Oakland, California http://beatricemotamedi.com/ 0 510 243 30 2009-04-19T02:26:00+00:00 14     1 0 968   0 0 0 3B94D9 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/455525318736896000/K3JBzvo9_normal.jpeg https://pbs.twimg.com/profile_images/455525318736896000/K3JBzvo9_normal.jpeg https://pbs.twimg.com/profile_banners/33098630/1430367133 0084B4 C0DEED DDEEF6 333333 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 6.3ms · About: simonw/jsk-fellows-on-twitter