users

119 rows where profile_use_background_image = 0 sorted by profile_link_color

✎ 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
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
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
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
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
224059040 SheilaLKaplan Sheila Kaplan Prohibited disclosure NY student contact info/DOB/birthplace/+ w/w out consent via CPO & regs. Now alarmed by @privacyforum directory info findings; work ahead Brooklyn NY https://www.worldprivacyforum.org/2020/04/without-consent/ 0 1855 2733 139 2010-12-08T01:43:54+00:00 2999     0 0 48584   0 0 0 CCCCCC 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/1315813855365398530/vkREFd1D_normal.jpg https://pbs.twimg.com/profile_images/1315813855365398530/vkREFd1D_normal.jpg https://pbs.twimg.com/profile_banners/224059040/1602554098 F58EA8 000000 DDEEF6 333333 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
20253808 AndreaWNYC Andrea Bernstein Co-host Trump, Inc. podcast from @WNYC & @ProPublica; NYT best-selling author: AMERICAN OLIGARCHS: The Kushners, The Trumps, and the Marriage of Money and Power New York, NY http://AndreaBernsteinBook.com 0 28333 1906 726 2009-02-06T17:29:43+00:00 4997     1 1 3349   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/918152096834351104/A_PEmQWi_normal.jpg https://pbs.twimg.com/profile_images/918152096834351104/A_PEmQWi_normal.jpg https://pbs.twimg.com/profile_banners/20253808/1597421977 FA743E 000000 000000 000000 0 0 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
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
29932001 BA1245 Barbara E. Allen   Stanford!   0 269 442 11 2009-04-09T05:47:18+00:00 3202     0 0 714   0 0 0 642D8B http://abs.twimg.com/images/themes/theme10/bg.gif https://abs.twimg.com/images/themes/theme10/bg.gif 1 http://pbs.twimg.com/profile_images/378800000141484301/02014c3a8ae7efdbadbf9509de30b920_normal.jpeg https://pbs.twimg.com/profile_images/378800000141484301/02014c3a8ae7efdbadbf9509de30b920_normal.jpeg https://pbs.twimg.com/profile_banners/29932001/1373962775 FF0000 65B0DA 7AC3EE 3D1957 0 1 0 0 0 0 none
117101072 CurtisWrites Curtis Krueger PR professional sharing awesome health news, top journalism, great photos. APR. Previous: @bluepearlvet plus 2 decades reporting for @TB_Times. Tampa Bay http://www.curtiskruegermedia.com 0 1562 1989 62 2010-02-24T14:53:27+00:00 978     0 0 2479   0 0 0 BF530B http://abs.twimg.com/images/themes/theme10/bg.gif https://abs.twimg.com/images/themes/theme10/bg.gif 0 http://pbs.twimg.com/profile_images/2557826272/no7vbstt4qk4syx3ztmf_normal.jpeg https://pbs.twimg.com/profile_images/2557826272/no7vbstt4qk4syx3ztmf_normal.jpeg https://pbs.twimg.com/profile_banners/117101072/1475617073 FF0000 FFFFFF 7AC3EE 3D1957 0 0 0 0 0 0 none
15315979 nuncaduermo Carolina Guerrero CEO of @NPR's @RadioAmbulante + @elhilopodcast. Breaking the language barrier with @LupaApp. @JSKStanford Fellow. Personal Assistant to León & Eliseo. New York, NY http://radioambulante.org 0 15419 4134 279 2008-07-04T07:42:02+00:00 32727     0 0 22405   0 0 0 13BA07 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/1111539185050157056/bKmpwrIb_normal.jpg https://pbs.twimg.com/profile_images/1111539185050157056/bKmpwrIb_normal.jpg https://pbs.twimg.com/profile_banners/15315979/1571587045 FF2F00 14BA16 D6D6D6 000000 0 0 0 0 0 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
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
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
85507898 LarsonWrites Christine Larson Exuberantly curious. Assistant Professor of Journalism at University of Colorado, Boulder. Mother of (twin teenage) Dragons. Boulder, CO http://www.christinelarson.com 0 766 582 46 2009-10-27T05:52:33+00:00 1209     1 0 923   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/776242884190228480/O1WzKySi_normal.jpg https://pbs.twimg.com/profile_images/776242884190228480/O1WzKySi_normal.jpg https://pbs.twimg.com/profile_banners/85507898/1474498613 FF691F 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
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
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

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