users

24 rows where profile_sidebar_border_color = "FFFFFF" and profile_use_background_image = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, listed_count, geo_enabled, verified, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_background_tile, profile_link_color, profile_sidebar_fill_color, profile_text_color, has_extended_profile, following, translator_type, created_at (date)

profile_use_background_image ✖

profile_sidebar_border_color ✖

  • FFFFFF · 24 ✖
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
14130084 shazna Shazna Nessa Global Head of Visuals @WSJ + President, @ONA Board of Directors / Former Director, Journalism @knightfdn + @AP @CondeNast New York, NY   0 4991 1060 374 2008-03-12T04:35:38+00:00 1789     1 0 1599   0 0 0 D15C0F 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/907373509961289729/Vqo9wZWD_normal.jpg https://pbs.twimg.com/profile_images/907373509961289729/Vqo9wZWD_normal.jpg https://pbs.twimg.com/profile_banners/14130084/1376351790 0084B4 FFFFFF C0DFEC 333333 0 0 0 0 0 0 none
14145296 susie_c Susie Cagle 🔍👀💻✍️🎨 / climate, crisis, labor, business, technology, California +++ / susie.cagle@gmail / DMs always open Oakland, CA http://susiecagle.com 0 23441 2692 1120 2008-03-14T06:12:34+00:00 35932     0 1 45861   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/881381260794318848/H0-Qgb48_normal.jpg https://pbs.twimg.com/profile_images/881381260794318848/H0-Qgb48_normal.jpg https://pbs.twimg.com/profile_banners/14145296/1561081102 299EE9 FFFFFF FFFFFF 000000 0 1 0 0 0 0 none
14282158 chrisallbritton Chris Allbritton Former journalist with @Time, @Reuters, and others. Knight '09, writer/editor. Washington, DC http://www.christopherallbritton.com 0 2842 1886 0 2008-04-02T10:54:43+00:00 1348     0 0 10947   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/1271589235263451138/ZzxjG08j_normal.jpg https://pbs.twimg.com/profile_images/1271589235263451138/ZzxjG08j_normal.jpg https://pbs.twimg.com/profile_banners/14282158/1561141342 3B94D9 FFFFFF C0DFEC 333333 0 1 0 0 0 0 regular
16291934 SND Society for News Design We create, promote and teach the world’s best visual journalism. http://snd.org International http://www.snd.org/ 0 8784 1289 495 2008-09-15T04:30:50+00:00 3607     1 0 6649   0 0 0 F4F5F0 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/742423324517662720/Tv1TPGB9_normal.jpg https://pbs.twimg.com/profile_images/742423324517662720/Tv1TPGB9_normal.jpg https://pbs.twimg.com/profile_banners/16291934/1597184436 527998 FFFFFF DDEEF6 333333 0 1 0 0 0 0 none
16700673 jenniferdargan Rock’em Sock’em Rosie @WPR, @JSKstanford ‘18, public radio fanatic, often on eight wheels. Madison, WI   0 434 699 21 2008-10-11T21:50:07+00:00 1837     0 0 764   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/1009887538893357056/bPUYbyW-_normal.jpg https://pbs.twimg.com/profile_images/1009887538893357056/bPUYbyW-_normal.jpg https://pbs.twimg.com/profile_banners/16700673/1510276807 990000 FFFFFF F3F3F3 333333 0 0 0 0 0 0 none
17808151 ICFJ ICFJ The International Center for Journalists (ICFJ) is a nonprofit that supports the truth tellers. Follow our @IJNet and @ICFJKnight accounts. #ItTakesAJournalist Washington, DC http://www.icfj.org 0 66829 1782 1985 2008-12-02T14:25:00+00:00 4201     1 1 38336   0 0 0 569BBD http://abs.twimg.com/images/themes/theme3/bg.gif https://abs.twimg.com/images/themes/theme3/bg.gif 0 http://pbs.twimg.com/profile_images/1006561573186539520/dlHJsiA3_normal.jpg https://pbs.twimg.com/profile_images/1006561573186539520/dlHJsiA3_normal.jpg https://pbs.twimg.com/profile_banners/17808151/1545167584 569BBD FFFFFF E3E2DE 5B5836 0 0 0 0 0 0 none
17813899 StanfordGSB Stanford Business Business research, insights, & ideas from Stanford Graduate School of Business. Stanford, California, USA http://gsb.stanford.edu/insights 0 494834 1487 6920 2008-12-02T18:15:00+00:00 3908     0 1 22891   0 0 0 990000 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/997216596597784577/2Mhi4lR2_normal.jpg https://pbs.twimg.com/profile_images/997216596597784577/2Mhi4lR2_normal.jpg https://pbs.twimg.com/profile_banners/17813899/1598495920 BD2031 FFFFFF E7D19A 000000 0 0 0 0 0 0 none
18036441 Stanford Stanford University Stanford is one of the world's leading research and teaching institutions. Official Twitter feed by University Communications. Stanford, CA http://stanford.edu/ 0 796766 516 7132 2008-12-11T01:06:56+00:00 67     0 1 20039   0 0 0 F6F3E5 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/875395483128049664/8z_jvdLB_normal.jpg https://pbs.twimg.com/profile_images/875395483128049664/8z_jvdLB_normal.jpg https://pbs.twimg.com/profile_banners/18036441/1403030942 820000 FFFFFF DDCF99 3F3C30 0 0 0 0 0 0 none
19425169 StanfordEng Stanford Engineering At the Stanford School of Engineering, we seek solutions to important global problems and educate leaders who will make the world a better place. Stanford, CA http://engineering.stanford.edu 0 65412 1547 1291 2009-01-24T00:45:02+00:00 647     0 1 12484   0 0 0 DDCF99 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/879466804854181889/tqXd2ZQd_normal.jpg https://pbs.twimg.com/profile_images/879466804854181889/tqXd2ZQd_normal.jpg https://pbs.twimg.com/profile_banners/19425169/1457556622 990000 FFFFFF 000000 999999 0 0 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
73257410 GWSchulz30 G.W. Schulz Hooman | It’s only fly-over country if you never land. http://SeeDisclaimer.com http://gwschulz.pressfolios.com     0 1474 1352 156 2009-09-10T23:59:12+00:00 205     0 0 2356   0 0 0 121010 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/557320335066804225/NsnhMMg6_normal.jpeg https://pbs.twimg.com/profile_images/557320335066804225/NsnhMMg6_normal.jpeg https://pbs.twimg.com/profile_banners/73257410/1397073159 D90B0B FFFFFF 080212 020C12 0 0 0 0 0 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
104733894 erictortiz Eric Ortiz Editor @stadiumtalkcom @Granite_Media. Also @Lawatmargins Former @ESPN @NESN @JSKStanford @Truthdig. Founder @evrybit. #news #sports #journalism #storytelling Minneapolis, MN http://lawatthemargins.com/category/community-based-news-room-cbnr/ 0 1055 2041 193 2010-01-14T06:32:00+00:00 327     1 0 7772   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/701802765677297664/DkRwycV1_normal.jpg https://pbs.twimg.com/profile_images/701802765677297664/DkRwycV1_normal.jpg https://pbs.twimg.com/profile_banners/104733894/1456134569 0084B4 FFFFFF DDEEF6 333333 0 0 0 0 0 0 none
107483740 lighthausinc Lighthaus Makers of Color Space + science and healthcare VR education. Supported by U.S. Dept of Education, National Institutes of Health. A new reality for education. California http://lighthaus.us 0 524 257 21 2010-01-22T18:21:08+00:00 377     0 0 159   0 0 0 131516 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/449636095433506816/gcw5NAxS_normal.jpeg https://pbs.twimg.com/profile_images/449636095433506816/gcw5NAxS_normal.jpeg https://pbs.twimg.com/profile_banners/107483740/1396036513 009999 FFFFFF EFEFEF 333333 0 0 0 0 0 0 none
110727296 lyndseygilpin Lyndsey Gilpin Founder & Editor-in-Chief, @southerlymag. Kentuckian. @JSKstanford Community Impact Fellow. North Carolina, USA http://www.lyndseygilpin.com 0 11425 1463 332 2010-02-02T15:25:31+00:00 10848     0 0 7395   0 0 0 F08C57 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/1261357987639279616/L4Y06cko_normal.jpg https://pbs.twimg.com/profile_images/1261357987639279616/L4Y06cko_normal.jpg https://pbs.twimg.com/profile_banners/110727296/1539037292 4A913C FFFFFF A0C5C7 333333 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
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
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
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
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
386183180 Girmatf Girma T Fantaye       0 1229 451 0 2011-10-06T20:15:31+00:00 471     0 0 1972   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/610040708083359744/gvvDe5SY_normal.jpg https://pbs.twimg.com/profile_images/610040708083359744/gvvDe5SY_normal.jpg   0084B4 FFFFFF DDEEF6 333333 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
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

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