users

119 rows where profile_use_background_image = 0 sorted by verified

✎ 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
21901213 paddyhirsch Paddy Hirsch ...... ..... http://www.paddyhirsch.com 0 7337 2144 298 2009-02-25T18:49:06+00:00 2016     1 1 18237   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png   0084B4 BDDCAD FFFFFF 333333 0 0 0 1 0 0 none
22929310 jseiken Jason Seiken Digital since before digital was a thing. Washington Post, PBS, Daily Telegraph, etc.. Non-digital father and husband. London http://www.qcatalyst.com 0 2684 431 160 2009-03-05T15:10:52+00:00 1130     1 1 2729   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/1197136052756058112/KSPIGpL-_normal.jpg https://pbs.twimg.com/profile_images/1197136052756058112/KSPIGpL-_normal.jpg https://pbs.twimg.com/profile_banners/22929310/1456049661 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
25029808 guilherme_amado Guilherme Amado Jornalista. Colunista na @RevistaEpoca e na @cbnoficial. @ICIJorg member. @Abraji VP. @JSKStanford fellow. http://Instagram.com/guilhermeamado Brazil https://epoca.globo.com/guilherme-amado/ 0 41787 2021 305 2009-03-18T04:47:23+00:00 6692     0 1 15307   0 0 0 000000 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/1086973470410457088/fwJv97SS_normal.jpg https://pbs.twimg.com/profile_images/1086973470410457088/fwJv97SS_normal.jpg https://pbs.twimg.com/profile_banners/25029808/1547950542 ABB8C2 000000 000000 000000 0 1 0 0 0 0 none
26006398 jdesmondharris Jenée Editor. Writer. Subtweeter. Now: @NYTOpinion staff editor, @TheOpedProject mentor + sensitivity reader for hire. Then: @Voxdotcom @TheRoot @Harvard Law @HowardU   https://www.linkedin.com/in/jeneed/ 0 29294 6548 514 2009-03-23T14:08:25+00:00 50348     0 1 29791   0 0 0 000000 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/1309645030110314498/LkV85279_normal.jpg https://pbs.twimg.com/profile_images/1309645030110314498/LkV85279_normal.jpg https://pbs.twimg.com/profile_banners/26006398/1414882009 FA743E 000000 000000 000000 0 1 0 0 0 0 none
26334203 Maykuth Andrew Maykuth Philadelphia Inquirer business reporter. I cover energy and gambling. Go figure. Philadelphia, Pa. http://www.philly.com 0 2641 291 183 2009-03-24T21:52:53+00:00 16     0 1 3990   0 0 0 313670 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/723519448578068480/C0ClxES7_normal.jpg https://pbs.twimg.com/profile_images/723519448578068480/C0ClxES7_normal.jpg https://pbs.twimg.com/profile_banners/26334203/1563976221 0084B4 FFFFFF C1EBD4 333333 0 0 0 0 0 0 none
27469953 lbranham Lorraine Branham Dean @NewhouseSU; former director of Journalism at UT Austin. Spent 25 years as a journalist, reporter, editor. Syracuse, NY   0 1228 740 59 2009-03-29T18:02:07+00:00 64     1 1 416   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/292357248/Branham_Lorraine_small_0382__photo__normal.jpg https://pbs.twimg.com/profile_images/292357248/Branham_Lorraine_small_0382__photo__normal.jpg https://pbs.twimg.com/profile_banners/27469953/1507231570 FF691F 000000 000000 000000 0 1 0 0 0 0 none
33964434 donnaborak Donna Borak Adjunct Faculty @NYU. Senior Economics Journalist. Alum of @CNN @WSJ @AP @AmerBanker and @UPI. 2015 JSK @Stanford Fellow. Yoga teacher. 🧘‍♀️ Globetrotter. Washington   0 5956 3161 266 2009-04-21T17:00:53+00:00 1464     0 1 9718   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/883050113882521601/5_6nNAs7_normal.jpg https://pbs.twimg.com/profile_images/883050113882521601/5_6nNAs7_normal.jpg https://pbs.twimg.com/profile_banners/33964434/1584126644 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
34687443 kristianiaclark krissy clark Host/co-creator: The Uncertain Hour podcast @Marketplace Stories: @reveal @99piorg @PopUpMag @slate Past @JSKstanford fellow 🌖ing at http://storieseverywherere.org los angeles https://itunes.apple.com/us/podcast/the-uncertain-hour/id1091031079?mt=2 0 3758 2147 190 2009-04-23T18:28:03+00:00 791     1 1 1554   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/2116171461/image_normal.jpg https://pbs.twimg.com/profile_images/2116171461/image_normal.jpg https://pbs.twimg.com/profile_banners/34687443/1416800787 FF691F 000000 000000 000000 0 0 0 0 0 0 none
39021657 Zielina Anita Zielina Innovation, product, biz models, change in digital/media. 💪 Training innovative leaders @newmarkjschool. Alum @insead @jskstanford @nzz @sternde @derstandardat New York, USA https://www.journalism.cuny.edu/executive-ed 0 46520 4387 810 2009-05-10T09:02:13+00:00 21882     1 1 19725   0 0 0 000000 http://abs.twimg.com/images/themes/theme7/bg.gif https://abs.twimg.com/images/themes/theme7/bg.gif 0 http://pbs.twimg.com/profile_images/926560081562435584/ylWz4hwa_normal.jpg https://pbs.twimg.com/profile_images/926560081562435584/ylWz4hwa_normal.jpg https://pbs.twimg.com/profile_banners/39021657/1549242812 1B95E0 000000 000000 000000 0 0 0 0 1 0 none
106430958 Aaron_Glantz Aaron Glantz Senior Reporter @Reveal, Pulitzer Finalist, Author, HOMEWRECKERS from HarperCollins, Peabody & duPont Award-winning journalist, 2016 JSK Fellow at Stanford San Francisco, CA http://www.aglantz.com/ 0 7366 2169 260 2010-01-19T14:53:25+00:00 1983     0 1 11383   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/1130878485705109504/hAHCW38J_normal.png https://pbs.twimg.com/profile_images/1130878485705109504/hAHCW38J_normal.png https://pbs.twimg.com/profile_banners/106430958/1562784141 DD2E44 000000 000000 000000 0 0 0 0 0 0 none
162581795 StanfordCDDRL Stanford CDDRL The Center on Democracy, Development, and the Rule of Law produces policy-relevant research to advance political development. RTs do not equal endorsements. Stanford University http://cddrl.fsi.stanford.edu 0 15377 879 371 2010-07-04T03:03:42+00:00 3099     1 1 5466   0 0 0 FFFFFF 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/875403533595496448/98zishL1_normal.jpg https://pbs.twimg.com/profile_images/875403533595496448/98zishL1_normal.jpg https://pbs.twimg.com/profile_banners/162581795/1398450261 1B95E0 000000 F6F6F6 333333 0 0 0 0 0 0 none
185809250 CivilEats Civil Eats Daily news about the U.S. food system. James Beard Publication of the Year. Support independent media: https://civileats.com/donate/ http://civileats.com/subscribe/ USA http://www.civileats.com 0 108199 561 3134 2010-09-01T22:05:47+00:00 59737     0 1 46095   0 0 0 89C9FA 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/1212811642389647361/ARSfwGW8_normal.jpg https://pbs.twimg.com/profile_images/1212811642389647361/ARSfwGW8_normal.jpg https://pbs.twimg.com/profile_banners/185809250/1583358936 0084B4 FFFFFF DDEEF6 333333 0 0 0 0 0 0 none
213689248 DoctorYasmin Dr. Seema Yasmin MD + Epidemiologist + Journalist | Fmr Epidemic Intelligence Service Officer| Study: infodemics |Teach: sci journalism | Direct: Stanford Health Comm Initiative Hackney girl in California https://linktr.ee/SeemaYasmin 0 66115 5196 1272 2010-11-09T15:06:40+00:00 34462     1 1 78001   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/855053296347881472/MCPljb6B_normal.jpg https://pbs.twimg.com/profile_images/855053296347881472/MCPljb6B_normal.jpg https://pbs.twimg.com/profile_banners/213689248/1602267253 FF691F 000000 000000 000000 0 1 0 0 0 0 none
250010900 Julie_Makinen Julie Makinen Executive Editor, The Desert Sun, Palm Springs, CA. JSK fellow @Stanford 2016-17. Past: L.A. Times, Intl. N.Y. Times, Washington Post. Traveler. Chocoholic. Palm Springs, CA http://desertsun.com 0 4665 806 339 2011-02-10T06:46:14+00:00 3408     1 1 5522   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/1037387370239164416/3t8vBmtH_normal.jpg https://pbs.twimg.com/profile_images/1037387370239164416/3t8vBmtH_normal.jpg https://pbs.twimg.com/profile_banners/250010900/1536175716 1B95E0 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
306428731 martin_k Martin Kotynek editor-in-chief / Chefredakteur @ DER STANDARD in Vienna // past: deputy editor-in-chief @ ZEIT ONLINE in Berlin // Knight Fellow '14 @ Stanford University Wien, Österreich http://linkedin.com/in/mkotynek 0 8564 2465 240 2011-05-27T21:30:08+00:00 4143     1 1 3256   0 0 0 4E97CE 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/1214675875486191616/tQYxCQLL_normal.jpg https://pbs.twimg.com/profile_images/1214675875486191616/tQYxCQLL_normal.jpg https://pbs.twimg.com/profile_banners/306428731/1584826733 4E97CE FFFFFF 050505 B8B6B8 0 0 0 0 0 0 none
423511427 CODaleyNews John Daley Multi-media journalist, covering health news for Colorado Public Radio, aka CPRNews A link or retweet does not = endorsement. USA http://cpr.org 0 2351 939 131 2011-11-28T16:05:17+00:00 3772     0 1 5025   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/1156307032892477440/BLv5vRSo_normal.jpg https://pbs.twimg.com/profile_images/1156307032892477440/BLv5vRSo_normal.jpg https://pbs.twimg.com/profile_banners/423511427/1442034198 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
454099919 McFaul Michael McFaul Professor. http://michaelmcfaul.com/ Stanford, California http://www.facebook.com/amb.mcfaul 0 526294 1701 4974 2012-01-03T16:36:02+00:00 33719     0 1 87525   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/640815361638535169/L5CJEZkw_normal.jpg https://pbs.twimg.com/profile_images/640815361638535169/L5CJEZkw_normal.jpg https://pbs.twimg.com/profile_banners/454099919/1532108947 1B95E0 C0DEED DDEEF6 333333 0 0 0 0 1 0 none
1548898596 Ericnpr Eric Westervelt @NPR journalist. Recovering foreign correspondent. Occasional host. Musician by moonlight http://SecureDrop.npr.org/ http://SeeDisclaimer.com San Francisco, CA https://www.npr.org/people/2101350/eric-westervelt 0 4897 2014 210 2013-06-26T19:27:15+00:00 680     0 1 2353   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/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_banners/1548898596/1406506418 3B94D9 000000 000000 000000 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.333ms · About: simonw/jsk-fellows-on-twitter