users

119 rows where profile_use_background_image = 0 sorted by following

✎ 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
904064391112306688 _trustproject The Trust Project The Trust Project is an international consortium of news organizations collaborating to use transparency to build a more trustworthy and trusted press. Santa Clara, CA http://thetrustproject.org 0 3287 172 132 2017-09-02T19:32:02+00:00 1452     0 0 880   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/926315631783247872/hWrUVvG__normal.jpg https://pbs.twimg.com/profile_images/926315631783247872/hWrUVvG__normal.jpg https://pbs.twimg.com/profile_banners/904064391112306688/1509686473 ABB8C2 000000 000000 000000 0 0 0 0 0 0 none
974442329791582208 pactio_us Pactio Us Pactio reinvents the way local journalism is created and funded by enabling newsrooms to better connect with and get ongoing support from their audience. Bay Area http://pactio.us 0 364 112 13 2018-03-16T00:28:50+00:00 345     1 0 189   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/1108233880228626433/HFK4eWht_normal.png https://pbs.twimg.com/profile_images/1108233880228626433/HFK4eWht_normal.png https://pbs.twimg.com/profile_banners/974442329791582208/1552949147 F0951C 000000 000000 000000 0 0 0 0 0 0 none
12655722 IRE_NICAR IRE and NICAR Investigative Reporters and Editors is a nonprofit organization dedicated to improving the quality of investigative reporting. Missouri School of Journalism http://ire.org 0 35319 711 1540 2008-01-24T20:31:29+00:00 1620     1 0 7700   0 0 0 000000 http://abs.twimg.com/images/themes/theme14/bg.gif https://abs.twimg.com/images/themes/theme14/bg.gif 0 http://pbs.twimg.com/profile_images/1219335849789145090/vg451ba8_normal.jpg https://pbs.twimg.com/profile_images/1219335849789145090/vg451ba8_normal.jpg https://pbs.twimg.com/profile_banners/12655722/1579547267 1B95E0 000000 000000 000000 0 0 0 0 1 0 none
13745872 ONA Online News Association Inspiring innovation in digital journalism since 1999 through yearlong programs, @ONAconf #ONA20 and the Online Journalism Awards #OJA20. Worldwide https://journalists.org/ 0 57314 8183 2528 2008-02-20T23:27:42+00:00 5996     1 1 17605   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/1103396638880657412/YxUu9sCC_normal.png https://pbs.twimg.com/profile_images/1103396638880657412/YxUu9sCC_normal.png https://pbs.twimg.com/profile_banners/13745872/1590516266 2AB7CA 5C5C5C E6E6E6 000000 0 0 0 0 1 0 none
17677665 mcgeoff Geoff McGhee Data vis & multimedia journalism, variously @TheWaterDesk @WestCenter. Former @jskstanford, @lemondefr, @nytimes, @NatGeo My opinions only. Seattle http://www.geoffmcghee.com 0 3119 4130 325 2008-11-27T13:26:22+00:00 6050     1 0 4389   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/1179861786939416576/P68PZvpH_normal.jpg https://pbs.twimg.com/profile_images/1179861786939416576/P68PZvpH_normal.jpg https://pbs.twimg.com/profile_banners/17677665/1589330268 1B95E0 000000 000000 000000 0 0 0 0 1 0 regular
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
18454770 DonLDay 🔅Don Day http://BoiseDev.com publisher covering the story of Idaho’s future. @JSKstanford Fellow. Spent 18 years in traditional media, now reinventing local news. Boise, ID http://linkedin.com/in/donday 0 7036 1106 247 2008-12-29T17:56:56+00:00 24683     1 1 43166   0 0 0 000000 http://abs.twimg.com/images/themes/theme14/bg.gif https://abs.twimg.com/images/themes/theme14/bg.gif 0 http://pbs.twimg.com/profile_images/1283121755129696257/vyI7a6eY_normal.jpg https://pbs.twimg.com/profile_images/1283121755129696257/vyI7a6eY_normal.jpg https://pbs.twimg.com/profile_banners/18454770/1586473612 FF691F 000000 000000 000000 0 1 0 0 1 0 none
19257632 aaronkfoley Scarin’ Foley 🎃 Black Media Initiative director @CCMNewmarkJ | priors @jskstanford '20, @cityofdetroit storyteller | ✊🏽🏳️‍🌈 | books @belt_publishing | email 👍🏽, DMs 👎🏽 NY borough/Detroit thorough http://www.aaronkfoley.com 0 6808 1606 175 2009-01-20T21:10:41+00:00 8946     0 0 41796   0 0 0 000000 http://abs.twimg.com/images/themes/theme14/bg.gif https://abs.twimg.com/images/themes/theme14/bg.gif 0 http://pbs.twimg.com/profile_images/1304863918255464449/crvCxgI4_normal.jpg https://pbs.twimg.com/profile_images/1304863918255464449/crvCxgI4_normal.jpg https://pbs.twimg.com/profile_banners/19257632/1567314628 FAB81E 000000 000000 000000 0 0 0 0 1 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 6442FF 000000 000000 000000 0 1 0 0 1 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
86776199 jmckellogg JulieAnn McKellogg Making texts fetch @joinsubtext | Builder and storyteller @JSKstanford @pactio_us @mcclatchy @washingtonpost @voanews @UNCHussman San Francisco, CA http://joinsubtext.com 0 1576 946 73 2009-11-01T18:44:39+00:00 10280     1 0 5563   0 0 0 DBE9ED http://abs.twimg.com/images/themes/theme17/bg.gif https://abs.twimg.com/images/themes/theme17/bg.gif 0 http://pbs.twimg.com/profile_images/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_images/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_banners/86776199/1448332496 91D2FA FFFFFF 252429 666666 0 0 0 0 1 0 none
97459086 magiccia mago torres journalist, researcher • @JSKstanford fellow 2017-2018 • happily sharing a Pulitzer with 370+ journalists #PanamaPapers • amable damisela.   http://www.magotorres.net/ 0 3081 2534 108 2009-12-17T14:59:49+00:00 4826     1 0 5146   0 0 0 000000 http://abs.twimg.com/images/themes/theme5/bg.gif https://abs.twimg.com/images/themes/theme5/bg.gif 0 http://pbs.twimg.com/profile_images/1285735985075097605/pD1dUHaV_normal.jpg https://pbs.twimg.com/profile_images/1285735985075097605/pD1dUHaV_normal.jpg https://pbs.twimg.com/profile_banners/97459086/1489878585 E81C4F 000000 000000 000000 0 0 0 0 1 0 none
106475977 KristaAlmanzan Krista Almanzan Senior Journalism Fellow @JSKStanford experimenting with audio in local news Palo Alto, CA   0 323 1422 9 2010-01-19T17:48:49+00:00 1248     0 0 209   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/1115369630913011712/ff0KW5l8_normal.png https://pbs.twimg.com/profile_images/1115369630913011712/ff0KW5l8_normal.png https://pbs.twimg.com/profile_banners/106475977/1554760966 19CF86 000000 000000 000000 0 0 0 0 1 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
186997686 DjurdjaPadejski DjurdjaPadejski Communications at @StanfordPACS/@DigCivSoc, ex @StanfordCDDRL. Bilingual tweets, my own, not my org’s. Palo Alto, CA   0 1331 1462 22 2010-09-05T00:14:13+00:00 100808     1 0 17262   0 0 0 F4C152 http://abs.twimg.com/images/themes/theme15/bg.png https://abs.twimg.com/images/themes/theme15/bg.png 1 http://pbs.twimg.com/profile_images/1267997614881964033/phIs-X2i_normal.jpg https://pbs.twimg.com/profile_images/1267997614881964033/phIs-X2i_normal.jpg https://pbs.twimg.com/profile_banners/186997686/1559461460 C4AF4E 000000 A54937 3BA2A6 0 0 0 0 1 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
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 981CEB 000000 000000 000000 0 1 0 0 1 0 none
3473664018 ProjectFacet Project Facet The Future of Journalism is Collaborative. Facet is an open source project to help newsrooms create and manage effective editorial collaborations. San Francisco, CA http://projectfacet.org 0 1030 235 46 2015-09-06T19:26:43+00:00 27     0 0 159   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/980586215878488066/sutDTgCF_normal.jpg https://pbs.twimg.com/profile_images/980586215878488066/sutDTgCF_normal.jpg https://pbs.twimg.com/profile_banners/3473664018/1522625220 084250 000000 000000 000000 0 0 0 0 1 0 none
4250629253 jopoliszuk Joseph Poliszuk Periodista | Coeditor-Fundador de @ArmandoInfo | @JSKstanford Fellow   http://www.armando.info 0 28424 2215 245 2015-11-22T15:54:57+00:00 4258     0 0 7045   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/1178560118952091648/qFUmY0F1_normal.jpg https://pbs.twimg.com/profile_images/1178560118952091648/qFUmY0F1_normal.jpg   1B95E0 000000 000000 000000 0 0 0 0 1 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 5.399ms · About: simonw/jsk-fellows-on-twitter