users

28 rows where default_profile = 1, following = 0 and verified = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, geo_enabled, is_translation_enabled, has_extended_profile, created_at (date)

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
13690462 Bonnie_D_Ford Bonnie D. Ford http://ESPN.com storyteller. Proud Oberlin alum. Omnivorous reader, traveler, viewer & listener.     0 14857 652 845 2008-02-19T21:20:30+00:00 9534     0 1 28401   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/746125445830221824/thkkND8v_normal.jpg https://pbs.twimg.com/profile_images/746125445830221824/thkkND8v_normal.jpg https://pbs.twimg.com/profile_banners/13690462/1501038266 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
14699813 zena_b Zena Barakat Design director @ideo San Francisco, CA   0 2996 2458 114 2008-05-08T12:55:09+00:00 964     0 1 1711   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/457502112784474112/dcbL1QWX_normal.jpeg https://pbs.twimg.com/profile_images/457502112784474112/dcbL1QWX_normal.jpeg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
14769899 TimJohnson4 TimJohnson Former cybersecurity reporter at @McClatchyDC, frmr correspondent in Mexico, China. Part of 2017 Pulitzer Prize-winning team on Panama Papers Washington, DC http://www.mcclatchydc.com 0 5240 770 335 2008-05-14T06:13:22+00:00 137     1 1 11837   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/1221873955/IMG_0415_2_normal.JPG https://pbs.twimg.com/profile_images/1221873955/IMG_0415_2_normal.JPG https://pbs.twimg.com/profile_banners/14769899/1534771290 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
16288136 melissakchan Melissa Chan reporter, writer | sometimes @dwnews | latest on VICE News Tonight, Foreign Policy, @GlobalRepCentre. Formerly London, China/Asia, Doha, California, more 🌎.   http://www.melissachan.com 0 75679 2211 1877 2008-09-14T22:25:38+00:00 12     0 1 36229   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/1286882730626519040/pUjaO5Xz_normal.jpg https://pbs.twimg.com/profile_images/1286882730626519040/pUjaO5Xz_normal.jpg https://pbs.twimg.com/profile_banners/16288136/1591925238 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
16911536 amyvirshup Amy Virshup Travel editor of @nytimes. @nytimestravel I've traded Metro for the world. Follow me! New York, NY https://www.nytimes.com/section/travel 0 9207 778 203 2008-10-22T19:41:36+00:00 1801     1 1 6809   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/1151524527576354817/rkr0XiO5_normal.png https://pbs.twimg.com/profile_images/1151524527576354817/rkr0XiO5_normal.png   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
17018840 sullivank Kevin Sullivan Washington Post Senior Correspondent. Author, with Mary Jordan, of 'Trump on Trial.' Out 8/25/2020. Pre-orders now! Washington DC http://washingtonpost.com 0 4364 1040 153 2008-10-28T10:42:23+00:00 1327     1 1 39   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/940644334558498818/t3l52xkA_normal.jpg https://pbs.twimg.com/profile_images/940644334558498818/t3l52xkA_normal.jpg https://pbs.twimg.com/profile_banners/17018840/1602020607 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
17455049 georgehaj George Haj President, @hajmediainc, a strategic communications firm. Recovering journalist. Former @miamiherald, @jskstanford, @ALMMedia, @houstonchron   http://hajmedia.com 0 3070 1610 175 2008-11-18T00:57:30+00:00 9527     1 1 16737   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/976110833997672449/c0XkkMPU_normal.jpg https://pbs.twimg.com/profile_images/976110833997672449/c0XkkMPU_normal.jpg https://pbs.twimg.com/profile_banners/17455049/1521834067 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
18149456 jerrylarge jerrylarge Seattle Times columnist. jlarge@seattletimes.com, Column interests: education, inequality, science and technology and interesting people. Seattle, WA   0 1349 604 54 2008-12-15T23:00:06+00:00 7     1 1 1193   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/2773250205/0c20f9070c39871c7af3ef93b9f2110b_normal.jpeg https://pbs.twimg.com/profile_images/2773250205/0c20f9070c39871c7af3ef93b9f2110b_normal.jpeg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
18741571 VaughnPalmer VaughnPalmer Vancouver Sun's provincial affairs political columnist, based in Victoria. Victoria http://www.vancouversun.com/columnists/Vaughn_Palmer.html 0 30532 382 659 2009-01-07T22:17:43+00:00 20     0 1 11337   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/70090482/Vaughn_Palmer_normal.jpg https://pbs.twimg.com/profile_images/70090482/Vaughn_Palmer_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
21538116 NotesFromHeL Helen Ubiñas Columnist. Welcome to my newsletter. Fact: There aren’t enough journalists of color in your local newsroom. Fact: No one is voiceless. Fact: This mic is mine. Philadelphia, PA http://www.philly.com/philly/columnists/helen_ubinas 0 12072 3196 379 2009-02-22T02:29:10+00:00 6103     1 1 50358   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/1315040614531166208/wI2AS5Jj_normal.jpg https://pbs.twimg.com/profile_images/1315040614531166208/wI2AS5Jj_normal.jpg https://pbs.twimg.com/profile_banners/21538116/1602365127 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
26336913 FrancesRobles Frances Robles I cover Puerto Rico, Central America, and file investigative reports from Florida and beyond for the @nytimes. https://www.nytimes.com/by/frances-robles?8qa Florida, USA http://www.nytimes.com/by/frances-robles 0 23422 4392 801 2009-03-24T22:05:08+00:00 2341     1 1 14972   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/623621720222502913/Y8-grpFh_normal.jpg https://pbs.twimg.com/profile_images/623621720222502913/Y8-grpFh_normal.jpg https://pbs.twimg.com/profile_banners/26336913/1590343259 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
34827824 justinegub Justine Gubar Docs, News, Investigations. Author of Fanaticus. National Academy of Television Arts & Sciences. Wes grad. Former Knight Fellow. Back in NYC. New York, NY http://www.Fanaticusthebook.com 0 1224 1676 48 2009-04-24T03:08:16+00:00 8327     0 1 3217   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/2622106690/gvmutgm6ingsp9ct8sot_normal.jpeg https://pbs.twimg.com/profile_images/2622106690/gvmutgm6ingsp9ct8sot_normal.jpeg https://pbs.twimg.com/profile_banners/34827824/1439847158 1DA1F2 C0DEED DDEEF6 333333 1 0 1 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
62611102 dpinheiro_press daniela pinheiro journalist/ MCC @NOVAunl/@risj_oxford fellow 2020/@JSKstanford fellow 2016 Lisboa, Portugal   0 5379 1103 95 2009-08-03T20:18:31+00:00 4507     1 1 7006   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/623485172240007168/f4zR0BNd_normal.jpg https://pbs.twimg.com/profile_images/623485172240007168/f4zR0BNd_normal.jpg https://pbs.twimg.com/profile_banners/62611102/1547592382 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
63027773 wlievano Wilson Lievano Senior Digital Editor @GroundTruth. News animator. Knight Fellow. Explaining the world one keyframe at a time. Boston, MA http://www.animatedpress.com 0 514 364 34 2009-08-05T04:08:38+00:00 75     1 1 165   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/990835621072519168/fLlhpOpG_normal.jpg https://pbs.twimg.com/profile_images/990835621072519168/fLlhpOpG_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
67227724 gabrielspitzer Gabriel Spitzer Communications Specialist @KCPubHealth, Science writer. Fmr @KNKXfm @JSKstanford @WBEZ. Seattle, WA http://www.transmissionpodcast.org 0 1999 1243 151 2009-08-20T04:28:57+00:00 2597     0 1 3441   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/2607119107/6dcs4205aqqkw71e703l_normal.jpeg https://pbs.twimg.com/profile_images/2607119107/6dcs4205aqqkw71e703l_normal.jpeg https://pbs.twimg.com/profile_banners/67227724/1386977390 1DA1F2 C0DEED DDEEF6 333333 1 0 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
80089310 andrewqlam Andrew Lam #Lecturer, #journalist & #Author of Perfume Dreams: Reflections on the #Vietnamese Diaspora, East Eats West: Writing in Two Hemisphere, & Birds of Paradise Lost San Francisco http://www.huffingtonpost.com/andrew-lam/ 0 1429 146 56 2009-10-05T18:19:44+00:00 1304     1 1 3702   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/1108247542/Andrewinpetra_normal.JPG https://pbs.twimg.com/profile_images/1108247542/Andrewinpetra_normal.JPG https://pbs.twimg.com/profile_banners/80089310/1360953750 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
137429134 janjlab Jan Schaffer J-Lab's Founder & Executive Director; Ombudsman, Corp. for Public Broadcasting, News Startups, Emerging Media, Journalism Innovations Washington, DC http://j-lab.org 0 1890 379 213 2010-04-26T18:37:36+00:00 133     1 1 1892   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/855254036/Jan100px_normal.jpg https://pbs.twimg.com/profile_images/855254036/Jan100px_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
139161166 KevinChron Kevin Fagan Reporter at the San Francisco Chronicle. Specialties: Human interest, poverty & homelessness, breaking news, The American West. San Francisco Chronicle http://sfgate.com 0 7436 851 259 2010-05-01T18:54:53+00:00 3630     0 1 4284   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/865435991/Me_mugshot_with_Blue_Angels_normal.jpg https://pbs.twimg.com/profile_images/865435991/Me_mugshot_with_Blue_Angels_normal.jpg https://pbs.twimg.com/profile_banners/139161166/1411492014 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
174492304 DCoronell Daniel Coronell Periodista.     0 1443731 1575 3754 2010-08-04T01:56:08+00:00 17241     1 1 82079   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/1062476450035568641/KyCPtJOf_normal.jpg https://pbs.twimg.com/profile_images/1062476450035568641/KyCPtJOf_normal.jpg https://pbs.twimg.com/profile_banners/174492304/1597667667 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
180871553 MikeRezendes Michael Rezendes Global investigations @AP. Formerly @GlobeSpotlight.   http://ap.org 0 14387 1483 321 2010-08-20T18:17:18+00:00 9017     0 1 5556   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/1171165560454950919/0_SW7Xwe_normal.jpg https://pbs.twimg.com/profile_images/1171165560454950919/0_SW7Xwe_normal.jpg https://pbs.twimg.com/profile_banners/180871553/1570314104 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
256498570 cpassariello Christina Passariello Technology editor @WashingtonPost. Ex @WSJ. Former @JSKstanford Fellow. Parisian by adoption. Super Bowl halftime show performer. Palo Alto, CA   0 5168 1588 288 2011-02-23T13:18:37+00:00 1105     0 1 67   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/378800000580715706/28055e4c53ea9839ab73dcc2248bc452_normal.jpeg https://pbs.twimg.com/profile_images/378800000580715706/28055e4c53ea9839ab73dcc2248bc452_normal.jpeg https://pbs.twimg.com/profile_banners/256498570/1381508339 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
262793826 josephcneff Joseph Neff Investigative reporter at The Marshall Project Durham, NC http://themarshallproject.org 0 2247 709 94 2011-03-08T19:38:26+00:00 74     0 1 6362   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/676840172005097473/pJK3i-Sf_normal.jpg https://pbs.twimg.com/profile_images/676840172005097473/pJK3i-Sf_normal.jpg https://pbs.twimg.com/profile_banners/262793826/1450206354 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
293673969 cecileprieur Cécile Prieur Directrice adjointe de la rédaction @lemondefr / Deputy Editor / Proud @JSKStanford Journalism Fellow 2019 and @ICIJorg member Paris, France http://www.lemonde.fr 0 14291 1923 283 2011-05-05T19:29:32+00:00 6631     1 1 6774   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/1175798081717252097/g_wDBOyu_normal.jpg https://pbs.twimg.com/profile_images/1175798081717252097/g_wDBOyu_normal.jpg https://pbs.twimg.com/profile_banners/293673969/1569161905 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
430250670 FukuyamaFrancis Francis Fukuyama Senior Fellow at Stanford's Freeman Spogli Institute, and Mosbacher Director, @StanfordCDDRL Instagram: francis.fukuyama Stanford, CA http://francisfukuyama.com 0 146506 546 2073 2011-12-06T23:09:59+00:00 3662     1 1 5186   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/2908541118/78cf45de12d324a5c6ef1113ad2263ca_normal.jpeg https://pbs.twimg.com/profile_images/2908541118/78cf45de12d324a5c6ef1113ad2263ca_normal.jpeg https://pbs.twimg.com/profile_banners/430250670/1521517508 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
437729436 susanferriss Susan Ferriss Reporter, immigration editor @publicintegrity The Fight in the Fields co-author, former Mexico-based news correspondent. Welcome tips. Washington, D.C. http://www.publicintegrity.org/ 0 2121 1004 127 2011-12-15T19:24:06+00:00 631     0 1 3671   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/1708231141/New_Image_normal.JPG https://pbs.twimg.com/profile_images/1708231141/New_Image_normal.JPG   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
573764891 OTMBrooke Brooke Gladstone Co-Host, Editor of WNYC's On the Media, author of "The Influencing Machine" and "The Trouble with Reality: A Rumination on Moral Panic" and so on. Brooklyn, New York http://onthemedia.org 0 25749 321 689 2012-05-07T16:15:11+00:00 342     1 1 1266   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/2199145153/gladstone_normal.jpg https://pbs.twimg.com/profile_images/2199145153/gladstone_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 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 111.08ms · About: simonw/jsk-fellows-on-twitter