users

26 rows where geo_enabled = 0 and has_extended_profile = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, location, verified, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_background_tile, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, default_profile, following, translator_type, created_at (date)

has_extended_profile ✖

geo_enabled ✖

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
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
14305753 jczamora 𝙟𝙤𝙨𝙚 𝙯𝙖𝙢𝙤𝙧𝙖 • Comms. @UniNoticias. // @JSKstanford Fellow. Prof. @univmiami. Former @knightfdn @el_Periodico @UFMedu Law @UniofOxford MediaLaw @UTAustin MPA. OAS Scholar. Miami, FL http://www.linkedin.com/in/josecarloszamora 0 7902 3740 403 2008-04-04T20:04:23+00:00 102245     0 1 55144   0 0 0 FFFFFF 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/1318413389585154048/l7E2ESTq_normal.jpg https://pbs.twimg.com/profile_images/1318413389585154048/l7E2ESTq_normal.jpg https://pbs.twimg.com/profile_banners/14305753/1603170737 75858A FFFFFF FFFFFF 000000 1 1 0 0 1 0 none
14381600 TMPowell Tracie Powell Connector. Change maker. Founder. Passionate about all things digital & media. Program Officer, Borealis Philanthropy & 2016 JSK Fellow. RT ≠ endorsement Washington, DC http://www.alldigitocracy.org 0 3059 3330 182 2008-04-14T05:29:35+00:00 5550     0 0 25373   0 0 0 B5BFC4 http://abs.twimg.com/images/themes/theme5/bg.gif https://abs.twimg.com/images/themes/theme5/bg.gif 1 http://pbs.twimg.com/profile_images/458801948028698624/r_6sGCev_normal.jpeg https://pbs.twimg.com/profile_images/458801948028698624/r_6sGCev_normal.jpeg https://pbs.twimg.com/profile_banners/14381600/1461613448 990000 FFFFFF 99CC33 3E4415 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
16212914 NataliaMazotte Natalia Mazotte Journalist & consultant working w/ data, tech, media & innovation. @jskstanford ‘20. @Abraji Director. @okfnbr ex-CEO. @escoladedados & @generonumero co-founder   https://medium.com/@NataliaMazotte 0 6143 2700 205 2008-09-09T23:02:25+00:00 8748     0 1 5620   0 0 0 EDECE9 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/1187231351600103424/9hhuJIn4_normal.jpg https://pbs.twimg.com/profile_images/1187231351600103424/9hhuJIn4_normal.jpg https://pbs.twimg.com/profile_banners/16212914/1506392495 088253 D3D2CF E3E2DE 634047 1 1 0 0 1 0 regular
25029808 guilherme_amado Guilherme Amado Jornalista. Colunista na @RevistaEpoca e na @cbnoficial. @ICIJorg member. @Abraji VP. @JSKStanford fellow. http://Instagram.com/guilhermeamado Brazil https://epoca.globo.com/guilherme-amado/ 0 41787 2021 305 2009-03-18T04:47:23+00:00 6692     0 1 15307   0 0 0 000000 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/1086973470410457088/fwJv97SS_normal.jpg https://pbs.twimg.com/profile_images/1086973470410457088/fwJv97SS_normal.jpg https://pbs.twimg.com/profile_banners/25029808/1547950542 ABB8C2 000000 000000 000000 0 1 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
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
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
31150056 izamoi izabela moi journalist. jornalista. journaliste. periodista. giornalista.     0 312 149 20 2009-04-14T15:43:48+00:00 43     0 0 14   0 0 0 B2DFDA http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 0 http://pbs.twimg.com/profile_images/959122174568169473/Big4ESpN_normal.jpg https://pbs.twimg.com/profile_images/959122174568169473/Big4ESpN_normal.jpg   93A644 EEEEEE FFFFFF 333333 1 1 0 0 0 0 none
50379519 sonniefron Sonni Efron President & COO, National Press Foundation. Journalism, foreign policy, democracy, human rights, technology, free expression, opinions my own, RTs not. Washington DC http://www.nationalpress.org 0 410 422 16 2009-06-24T17:55:58+00:00 205     0 0 813   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/499964856099819520/eHWLlmXV_normal.jpeg https://pbs.twimg.com/profile_images/499964856099819520/eHWLlmXV_normal.jpeg   0084B4 000000 000000 000000 0 1 0 0 0 0 none
67942338 Musikilu Musikilu Mojeed Editor-in-Chief/Chief Operating Officer -- @premiumtimesng; Co-Founder -- @ptcij; founder - @TheImoleProject; founder, @naijapolizwatch; member, @ICIJorg Abuja http://www.premiumtimesng.com 0 2375 192 46 2009-08-22T17:53:27+00:00 4     0 0 1033   0 0 0 709397 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/544059982413455361/dk08h8Lx_normal.png https://pbs.twimg.com/profile_images/544059982413455361/dk08h8Lx_normal.png   FF3300 86A4A6 A0C5C7 333333 1 1 0 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
107911169 kelsosCorner Nathaniel V. KELSO Map geek & cartographer @snap. Prior @mapzen, @apple, @stamen, @washingtonpost, @nationalgeographic. See http://NaturalEarthData.com! Views my own, RT != +1. SF-DC-NULL http://kelsocartography.com/blog/ 0 5545 3744 379 2010-01-24T05:00:31+00:00 26817     0 0 15092   0 0 0 022330 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/669581121/Screen_shot_2010-02-01_at_11.47.52_AM_normal.png https://pbs.twimg.com/profile_images/669581121/Screen_shot_2010-02-01_at_11.47.52_AM_normal.png https://pbs.twimg.com/profile_banners/107911169/1363739004 0084B4 A8C7F7 C0DFEC 333333 1 1 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
111183422 HBCompass Heather Bryant The future of journalism is collaborative. Partnerships not parachutes. Journalism For & With. Read Curiously. @ProjectFacet @newscatalyst @wellreadio she/her CA | AK http://www.hbcompass.io/ 0 5788 5797 389 2010-02-04T02:08:38+00:00 23291     0 0 18347   0 0 0 010D12 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/757724709140041730/_gJUlesG_normal.jpg https://pbs.twimg.com/profile_images/757724709140041730/_gJUlesG_normal.jpg https://pbs.twimg.com/profile_banners/111183422/1543269459 252525 FFFFFF C0DFEC 333333 1 1 0 0 1 0 regular
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
316717535 SShourd Sarah Shourd Trauma-informed journalist. Advocate for alternatives to incarceration and restorative justice. Playwright and Director. Lover of popcorn and redwood trees. Oakland, CA https://pulitzercenter.org/event/box-virtual-performances 0 3275 1725 122 2011-06-13T21:27:49+00:00 1751     0 0 5280   0 0 0 5D12CC http://abs.twimg.com/images/themes/theme12/bg.gif https://abs.twimg.com/images/themes/theme12/bg.gif 0 http://pbs.twimg.com/profile_images/1191745122800721921/Pw6Mm8S-_normal.jpg https://pbs.twimg.com/profile_images/1191745122800721921/Pw6Mm8S-_normal.jpg https://pbs.twimg.com/profile_banners/316717535/1572969203 141313 000000 A0C5C7 333333 1 1 0 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
516794788 cherokee_editor Bryan Pollard associate director, @najournalists; former JSK Fellow, @jskstanford; former exec editor, @CherokeePhoenix; founder @streetroots, board member, @highcountrynews Fayetteville, AR   0 973 143 15 2012-03-06T19:10:04+00:00 407     0 0 298   0 0 0 000000 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/1202017989794512897/b5TBWCxa_normal.jpg https://pbs.twimg.com/profile_images/1202017989794512897/b5TBWCxa_normal.jpg https://pbs.twimg.com/profile_banners/516794788/1594162479 981CEB 000000 000000 000000 0 1 0 0 1 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
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
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

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