users

119 rows where profile_use_background_image = 0

✎ 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
627476459 fichtalina Alina Fichter Head of Digital Format Development at @DeutscheWelle, Advisory Board @Newsguardrating. 👉🏼User Centric Formats, Digital Transformation, Fighting Disinformation Berlin, Deutschland http://www.dw.com 0 3286 3237 135 2012-07-05T15:30:06+00:00 2879     0 0 2490   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/1312637081739501568/ICvGOp8X_normal.jpg https://pbs.twimg.com/profile_images/1312637081739501568/ICvGOp8X_normal.jpg https://pbs.twimg.com/profile_banners/627476459/1473390954 E81C4F 000000 000000 000000 0 0 0 0 0 0 none
860166914 Tandemvines Tandemvines Media Denise Clifton develops stories & writes for organizations like @projectfeast & @alaskaair. Always exploring stories behind food. (Book: Tables From The Rubble) Seattle https://www.tandemvines.com/ 0 230 817 17 2012-10-03T18:46:41+00:00 458     0 0 1242   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/908806865605214208/UIwNNBcj_normal.jpg https://pbs.twimg.com/profile_images/908806865605214208/UIwNNBcj_normal.jpg https://pbs.twimg.com/profile_banners/860166914/1508536427 32AC01 000000 000000 000000 0 0 0 0 0 0 none
1010044015 groundsource GroundSource A platform built for listening at scale to turn your most valued audiences into superfans through direct, two-way messaging over SMS, chat apps, voice. Global http://groundsource.co 0 1779 2305 99 2012-12-14T00:18:56+00:00 1140     1 0 1545   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/1121497402823856129/7IXKF2zi_normal.png https://pbs.twimg.com/profile_images/1121497402823856129/7IXKF2zi_normal.png https://pbs.twimg.com/profile_banners/1010044015/1556220679 3B94D9 000000 000000 000000 0 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 005C9D FFFFFF 252429 666666 0 0 0 0 0 0 none
1356019962 hello_lope Lope Gutierrez-Ruiz @JSKstanford and @TEDFellow. Co-Founder of Gopher Magazine & In-House International. Exploring the future of our cities, open data, design, cultural management. Austin, TX http://weareinhouse.com 0 540 1398 42 2013-04-16T04:34:00+00:00 28169     1 0 853   0 0 0 00282A 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/472125271030497280/Fmp50e3j_normal.jpeg https://pbs.twimg.com/profile_images/472125271030497280/Fmp50e3j_normal.jpeg https://pbs.twimg.com/profile_banners/1356019962/1576599587 094142 390405 B7FFF3 A9D606 0 0 0 0 0 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
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
1635237446 datafest2013 Americas Datafest The first hemispheric hackathon on migration in the Americas November 2-3, 2013 || #americasdf || Lead organizer @terebouza   http://www.americas.datafest.net 0 253 351 8 2013-07-31T11:13:57+00:00 0     0 0 549   0 0 0 C3E2EB 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/378800000220880767/cf7cec0f50bfcfd61a468c5584cfd87d_normal.png https://pbs.twimg.com/profile_images/378800000220880767/cf7cec0f50bfcfd61a468c5584cfd87d_normal.png https://pbs.twimg.com/profile_banners/1635237446/1375577577 B33F00 FFFFFF DDEEF6 333333 0 0 0 0 0 0 none
2432250330 getnod NOD - News On Demand All the news that fits your attention span. Catching up on major events made easy. Efficient, beautiful, free. English/Français. Knight Prototype Fund Recipient California http://www.get-nod.com 0 251 179 14 2014-04-07T16:01:54+00:00 1568     0 0 1054   0 0 0 33485C 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/522550029362294785/lAHk1giS_normal.png https://pbs.twimg.com/profile_images/522550029362294785/lAHk1giS_normal.png https://pbs.twimg.com/profile_banners/2432250330/1413421189 33485C FFFFFF C0DFEC 333333 0 0 0 0 0 0 none
3140544572 askwalterai Walter Building a two-way conversation between audiences and the news. What do you want to know? #AskWalter Palo Alto, CA http://www.waltervoice.com 0 28 32 1 2015-04-05T16:51:48+00:00 3     0 0 29   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/584768227877621761/k4eyudcY_normal.png https://pbs.twimg.com/profile_images/584768227877621761/k4eyudcY_normal.png https://pbs.twimg.com/profile_banners/3140544572/1454866653 3B94D9 000000 000000 000000 0 0 0 0 0 0 none
3177360083 JimmyGootz jimmy gutierrez filling Milwaukee's info gaps w #News414 | @JSKstanford community impact fellow | former hit maker @NHPR | jv baller | he/him Milwaukee   0 667 913 24 2015-04-17T17:03:51+00:00 9426     1 0 1328   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/1296206061813325831/LpxZmpA3_normal.jpg https://pbs.twimg.com/profile_images/1296206061813325831/LpxZmpA3_normal.jpg https://pbs.twimg.com/profile_banners/3177360083/1459517885 ABB8C2 000000 000000 000000 0 0 0 0 0 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
4083799919 JKonopo Joel Konopo | Innovator | Investigative journalist @ink_cij 🇧🇼 | Father of three | @jskstanford Fellow 19 | Botswana http://www.inkjournalism.org 0 2351 1768 21 2015-10-31T16:47:56+00:00 1111     1 0 760   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/1067702561485004800/cohjhObZ_normal.jpg https://pbs.twimg.com/profile_images/1067702561485004800/cohjhObZ_normal.jpg https://pbs.twimg.com/profile_banners/4083799919/1535169273 19CF86 000000 000000 000000 0 0 0 0 0 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
750919846330793984 YooHeeHong0916 YooHee Hong   San Francisco, CA http://ww.linkedin.com/in/yoohee-hong-6136b856 0 72 416 3 2016-07-07T05:10:17+00:00 27     0 0 110   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/750923750393073664/OmqpgBr__normal.jpg https://pbs.twimg.com/profile_images/750923750393073664/OmqpgBr__normal.jpg https://pbs.twimg.com/profile_banners/750919846330793984/1472532696 7FDBB6 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
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
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

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.448ms · About: simonw/jsk-fellows-on-twitter