users

19 rows where has_extended_profile = 1 and profile_sidebar_border_color = "C0DEED"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, location, followers_count, friends_count, listed_count, geo_enabled, verified, is_translation_enabled, profile_background_tile, profile_link_color, default_profile, following, created_at (date)

profile_sidebar_border_color ✖

  • C0DEED · 19 ✖

has_extended_profile ✖

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
1246761 CindyRoyal Cindy Royal Professor at TX State, teaching Web design, coding & digital product concepts. ‘13-‘14 JSK Fellow at Stanford. Live in Austin, loved live music, when we had it. Austin, TX http://www.cindyroyal.com 0 6563 2206 644 2007-03-15T20:58:07+00:00 8890     1 0 30004   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/979923691126468608/V_75j5G0_normal.jpg https://pbs.twimg.com/profile_images/979923691126468608/V_75j5G0_normal.jpg https://pbs.twimg.com/profile_banners/1246761/1413651872 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
14590178 michvinmar Michael V. Marcotte Rethinking news, entrepreneurship and Flintstone houses. UNM Professor of Practice. Started @NMNewsPort and @NVMediaAlliance. MVM Consulting for #pubmedia. Albuquerque, NM http://mikemarcotte.com 0 1176 1924 93 2008-04-29T20:21:00+00:00 1065     1 0 2585   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/59796146/Photo_18_normal.jpg https://pbs.twimg.com/profile_images/59796146/Photo_18_normal.jpg https://pbs.twimg.com/profile_banners/14590178/1425261303 3B94D9 C0DEED DDEEF6 333333 1 1 0 0 0 0 none
16018986 bedwardstiek Brian EdwardsTiekert Co-Host, UpFront 7-9am @kpfa | Environment, Politics, Housing, Police, CA & SFBay | @CWAUnion | Fmr @JSKStanford | he/him Berkeley, CA http://www.kpfa.org 0 3423 1947 86 2008-08-27T22:55:11+00:00 5108     0 0 7687   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/1204611998102650880/7L9HcsV6_normal.jpg https://pbs.twimg.com/profile_images/1204611998102650880/7L9HcsV6_normal.jpg https://pbs.twimg.com/profile_banners/16018986/1480406353 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
28293072 who_blgw2017 who   Kowloon City District   0 6203 0 204 2009-04-02T06:12:42+00:00 1     0 0 1   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/857785713852432384/wNGwoOD4_normal.jpg https://pbs.twimg.com/profile_images/857785713852432384/wNGwoOD4_normal.jpg https://pbs.twimg.com/profile_banners/28293072/1493343029 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
29006114 LatoyaPeterson Latoya Peterson Cyborg // Goddess // Storyteller //Technologist. Cofounder/CXO ✨@GlowUpGames✨Making: @InsecureGame Always: @Racialicious. @Techstars '20. Chillin on Clubhouse Quarantined http://glowup.games/ 0 15237 6543 737 2009-04-05T15:45:34+00:00 5292     1 1 26421   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/1045775960539185152/kTwuBv3b_normal.jpg https://pbs.twimg.com/profile_images/1045775960539185152/kTwuBv3b_normal.jpg https://pbs.twimg.com/profile_banners/29006114/1585705821 1B95E0 C0DEED DDEEF6 333333 1 1 0 0 0 0 none
46241234 Swiftstories Mike Swift Journalist at global crossroad of tech & law, focused on privacy, security. Chief Digital Risk Correspondent for @MLexclusive. Frmr @JSKStanford: swift@mlex.com Half Moon Bay, CA http://mlexmarketinsight.com/mike-swift/ 0 6048 1394 441 2009-06-10T22:14:58+00:00 2614     1 1 18347   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/787336416984338433/BFTjJx4O_normal.jpg https://pbs.twimg.com/profile_images/787336416984338433/BFTjJx4O_normal.jpg https://pbs.twimg.com/profile_banners/46241234/1405311520 000FB3 C0DEED DDEEF6 333333 1 1 0 0 0 0 none
51893064 Pablo_Rosendo Pablo González Journalist. Former Bloomberg, Debtwire, 3 Puntos, Perfil, Pagina/12, Jornal do Brasil. Stanford Knight Fellow. UNC. Cordoba, Buenos Aires, Palo Alto, Sao Paulo. South America   0 2681 1371 98 2009-06-29T00:16:32+00:00 2496     1 1 4341   0 0 1 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/727559202265280513/k1UQ7Juw_normal.jpg https://pbs.twimg.com/profile_images/727559202265280513/k1UQ7Juw_normal.jpg https://pbs.twimg.com/profile_banners/51893064/1603925211 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
59112161 violetgonda Violet Gonda Journalist/Hot Seat interviews/ 1stTV/Moderator of Debates/ Zim/ UK/ President: International Association of Women in Radio and TV - IAWRT/ Serena 💕 Nadal UK/Zimbabwe http://www.violetgonda.com 0 59714 2148 131 2009-07-22T12:29:44+00:00 9253     1 0 6458   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/1309189703552454658/cNjsceqQ_normal.jpg https://pbs.twimg.com/profile_images/1309189703552454658/cNjsceqQ_normal.jpg https://pbs.twimg.com/profile_banners/59112161/1509269541 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
69205157 cefeche Carlos F Chamorro Journalist/Periodista en Nicaragua. Director de Esta Semana y http://www.confidencial.com.ni     0 200958 394 434 2009-08-27T04:53:44+00:00 37     0 1 19682   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/1036683916957110272/wqVMomTX_normal.jpg https://pbs.twimg.com/profile_images/1036683916957110272/wqVMomTX_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
144361718 mainulislamkhan Mainul Khan       0 98 52 2 2010-05-16T02:44:34+00:00 2     0 0 48   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/2227810249/mainul_normal.jpg https://pbs.twimg.com/profile_images/2227810249/mainul_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
245720591 IDashboard Paul Radu Investigate & Innovate//co-founder@OCCRP//occrp.org//Ashoka fellow//id.occrp.org//riseproject.ro   https://occrp.org 0 5213 647 220 2011-02-01T09:48:07+00:00 2324     0 0 2797   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/918169921300979712/GDZ69Zo8_normal.jpg https://pbs.twimg.com/profile_images/918169921300979712/GDZ69Zo8_normal.jpg https://pbs.twimg.com/profile_banners/245720591/1524925950 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
376690985 UlrikHaagerup Ulrik Haagerup Founder and CEO of Constructive Institute. Former Executive Director of DR News and editor-in-chief - but always a journalist. Let's Make Journalism Great Again Aarhus, Denmark http://www.constructiveinstitute.org 0 10349 443 172 2011-09-20T10:14:47+00:00 400     1 0 1656   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/917966543178424322/xLb2JO0h_normal.jpg https://pbs.twimg.com/profile_images/917966543178424322/xLb2JO0h_normal.jpg https://pbs.twimg.com/profile_banners/376690985/1488636471 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
421725730 michaeljrain Michael Rain Digital Storyteller & Speaker // Founder @ENODI_ // @TEDtalks Speaker & Resident // Fellow @JSKstanford @TowKnightCenter // @Columbia alum 🇺🇸🇬🇭 Palo Alto, CA http://www.michaelra.in 0 922 818 57 2011-11-26T09:12:00+00:00 12413     0 0 5361   0 0 0 C0DEED 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/822773325650923520/EiDMafXm_normal.jpg https://pbs.twimg.com/profile_images/822773325650923520/EiDMafXm_normal.jpg https://pbs.twimg.com/profile_banners/421725730/1485196771 0084B4 C0DEED DDEEF6 333333 1 1 0 0 1 0 none
453900651 kanhema Newton Kanhema Journo | Father | Serving Humanity @UNICNAIROBI | Views are mine | With low handicap🏌🏾 | RTs not Endorsements Nairobi, Kenya http://www.unicnairobi.org 0 1430 1764 19 2012-01-03T12:04:25+00:00 1422     1 0 3747   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/425814011335417856/CMmgyM0P_normal.jpeg https://pbs.twimg.com/profile_images/425814011335417856/CMmgyM0P_normal.jpeg https://pbs.twimg.com/profile_banners/453900651/1452415721 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
520989810 village_scribe Divine Dube Local news #innovation geek. @JSKstanford Alum California, USA https://medium.com/@divine_dube 0 1591 2614 7 2012-03-11T04:04:01+00:00 850     1 0 697   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/1159329012944187392/LIljsPSG_normal.jpg https://pbs.twimg.com/profile_images/1159329012944187392/LIljsPSG_normal.jpg https://pbs.twimg.com/profile_banners/520989810/1567903216 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 1 0 none
556757858 ArifElsau Arif Elsaui journalist -media consultant-freelancer -kenya \Nairobi Kenya-Nairobi   0 922 587 12 2012-04-18T10:42:05+00:00 257     1 0 267   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/607129740680429568/VlKJEiM7_normal.jpg https://pbs.twimg.com/profile_images/607129740680429568/VlKJEiM7_normal.jpg https://pbs.twimg.com/profile_banners/556757858/1357977082 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
1379368854 PietroBahemuka Peter Bahemuka Keenly interested in media, communications, human rights, politics, business, international affairs, literature, film, music, sports, nature, history and travel Kampala, Uganda   0 274 970 7 2013-04-25T12:47:22+00:00 201     0 0 119   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/1238116282559606784/veTDpaXf_normal.jpg https://pbs.twimg.com/profile_images/1238116282559606784/veTDpaXf_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
2230646461 TNNEnglish Tribal News Network Providing Local News to the Tribal Areas of Pakistan KPK https://www.tnn.com.pk 0 5118 0 122 2013-12-04T23:53:56+00:00 0     1 0 42626   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/468514051446685696/OPrPCMds_normal.jpeg https://pbs.twimg.com/profile_images/468514051446685696/OPrPCMds_normal.jpeg https://pbs.twimg.com/profile_banners/2230646461/1437654873 1DA1F2 C0DEED DDEEF6 333333 1 1 1 0 0 0 none
2317636063 osetinskayaliza liza osetinskaya Russian journalist, editor, media manager. interested in Russian politics, digital media, perfect journalism. Stanford Jsk knight fellow 2017 Palo Alto, CA   0 3368 229 51 2014-01-29T18:50:40+00:00 15     0 0 212   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/482623420354404352/vc5VwMpa_normal.png https://pbs.twimg.com/profile_images/482623420354404352/vc5VwMpa_normal.png   1DA1F2 C0DEED DDEEF6 333333 1 1 1 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 115.989ms · About: simonw/jsk-fellows-on-twitter