users

119 rows where profile_use_background_image = 0 sorted by geo_enabled

✎ 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
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
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
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
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
241747214 matisu19 matilde suescun Woman - Latina - Sin pelos en la lengua - Bloguera - Spanglish - JSK Knight Fellow @Stanford Miami, FL http://mujerconojosabiertos.com/ 0 341 519 20 2011-01-23T01:47:54+00:00 3270     1 0 1311   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/1250990136/matisu_normal.jpg https://pbs.twimg.com/profile_images/1250990136/matisu_normal.jpg https://pbs.twimg.com/profile_banners/241747214/1499803109 ABB8C2 000000 000000 000000 0 0 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
321603395 KJawoko Kennedy Jawoko I am a dad, writer, college professor, social entrep and media dev. expert, not always in that order. Toronto, Ontario https://www.linkedin.com/profile/preview?vpa=pub&locale=en_US 0 486 1064 18 2011-06-21T20:54:39+00:00 461     1 0 1492   0 0 0 000000 http://abs.twimg.com/images/themes/theme8/bg.gif https://abs.twimg.com/images/themes/theme8/bg.gif 0 http://pbs.twimg.com/profile_images/497529885749825536/_6_BCcbQ_normal.jpeg https://pbs.twimg.com/profile_images/497529885749825536/_6_BCcbQ_normal.jpeg https://pbs.twimg.com/profile_banners/321603395/1398627194 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
388030023 News_Kat Katherine A Rowlands I run http://BayCityNews.com + http://BayCityNews.org + http://LocalNewsMatters.org. Past Life: @JSKstanford @DiabloMagazine @mercnews @EastBayTimes @SLOTribune Bay Area, California http://www.baycitynews.org 0 2285 2218 165 2011-10-10T02:15:17+00:00 2538     1 0 4595   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/959535064911462400/22iyhmXB_normal.jpg https://pbs.twimg.com/profile_images/959535064911462400/22iyhmXB_normal.jpg https://pbs.twimg.com/profile_banners/388030023/1562164037 1B95E0 000000 000000 000000 0 1 0 0 0 0 none
400778798 MakenaWalker Makena   New York http://www.unglobalpulse.org 0 17 218 1 2011-10-29T15:19:42+00:00 13     1 0 2   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/783100911287664640/h0AtMgbA_normal.jpg https://pbs.twimg.com/profile_images/783100911287664640/h0AtMgbA_normal.jpg   1B95E0 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
500219903 CReporting Compu Reporting Computational Reporting. All about Data Mining US http://computationalreporting.com 0 59 57 11 2012-02-22T22:40:11+00:00 0     1 0 147   0 0 0 FFFFFF 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/1872022267/logocr_normal.gif https://pbs.twimg.com/profile_images/1872022267/logocr_normal.gif   F91717 DFD5A7 FF6600 535252 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
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
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
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.129ms · About: simonw/jsk-fellows-on-twitter