users

19 rows where location = "Washington, DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_count, favourites_count, geo_enabled, verified, is_translation_enabled, 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, has_extended_profile, default_profile, following, created_at (date)

translator_type ✖

location ✖

  • Washington, DC · 19 ✖
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
5202671 martyn_williams Martyn Williams North Korea-focused journalist/researcher @NorthKoreaTech @38NorthNK. Non-resident fellow @stimsoncenter. Author @committeeHRNK. Also KJ6SDF. Washington, DC http://www.northkoreatech.org 0 24339 900 1452 2007-04-19T08:11:12+00:00 1803     1 1 10635   0 0 0 EBEBEB 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/689273723333955584/_WBnXDWi_normal.jpg https://pbs.twimg.com/profile_images/689273723333955584/_WBnXDWi_normal.jpg   990000 DFDFDF F3F3F3 333333 1 0 0 0 0 0 none
6819732 NAHJ NAHJ National Association of Hispanic Journalists/Asociación Nacional de Periodistas Hispanos Estamos aquí putting #MoreLatinosInNews. Washington, DC http://www.nahj.org 0 34217 10996 897 2007-06-14T20:37:24+00:00 15518     1 1 35925   0 0 0 0099B9 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/1248602262672310279/mursIaXj_normal.jpg https://pbs.twimg.com/profile_images/1248602262672310279/mursIaXj_normal.jpg https://pbs.twimg.com/profile_banners/6819732/1601595451 1F528F FFFFFF 9DC7F0 353131 1 0 0 0 0 0 none
11579212 StevenSternberg Steve Sternberg Award-winning journalist, ex-U.S. News & World Report + USA Today. #1 Fan of @ClaudiaKalb. Washington, DC http://usnews.com 0 16434 10444 737 2007-12-27T20:50:28+00:00 1178     0 1 10829   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/359142494/steve_normal.jpg https://pbs.twimg.com/profile_images/359142494/steve_normal.jpg https://pbs.twimg.com/profile_banners/11579212/1597192191 FF3300 FFFFFF A0C5C7 333333 1 0 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
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
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
14849874 mmcrenson Matt Crenson Opinions are my own. Facts belong to no one. Washington, DC   0 189 137 11 2008-05-20T23:21:58+00:00 1     0 0 82   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/378800000506322558/1164c14c9f7e2210d4d94d6e025c7b8f_normal.jpeg https://pbs.twimg.com/profile_images/378800000506322558/1164c14c9f7e2210d4d94d6e025c7b8f_normal.jpeg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
16390952 akjohnson1922 Akilah Johnson Now: @propublica DC. Then: @JSKstanford @BostonGlobe @SunSentinel. Always: Telling untold stories. Retweets not endorsements. she/her 💙🐩💛 Washington, DC https://www.propublica.org/people/akilah-johnson 0 7696 1887 332 2008-09-21T14:10:09+00:00 2398     1 1 7216   0 0 0 194B8A http://abs.twimg.com/images/themes/theme8/bg.gif https://abs.twimg.com/images/themes/theme8/bg.gif 0 http://pbs.twimg.com/profile_images/1072244732946870272/V2pSvuhA_normal.jpg https://pbs.twimg.com/profile_images/1072244732946870272/V2pSvuhA_normal.jpg   16160E D9B17E B9A031 181915 0 0 0 0 0 0 none
17188930 NoluCN Nolu Crockett-Ntonga Global Communications and Parternership Builder. Web Content Strategist. Africa Watcher, International Development Advocate. Washington, DC http://www.NoluCN.com 0 197 227 9 2008-11-05T14:11:41+00:00 3     1 0 388   0 0 0 0099B9 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/636266399921479680/nfopGlaC_normal.jpg https://pbs.twimg.com/profile_images/636266399921479680/nfopGlaC_normal.jpg https://pbs.twimg.com/profile_banners/17188930/1440531484 0099B9 5ED4DC 95E8EC 3C3940 1 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
21404432 Eric_Weiner Eric Weiner NYT bestselling author. Wanderer. @NPR alum. My new book, THE SOCRATES EXPRESS, is out now! Washington, DC http://www.ericweinerbooks.com 0 6707 767 267 2009-02-20T15:21:40+00:00 14503     0 1 9758   0 0 0 A0BFBB http://abs.twimg.com/images/themes/theme13/bg.gif https://abs.twimg.com/images/themes/theme13/bg.gif 1 http://pbs.twimg.com/profile_images/1300182083407618049/GekHJiWR_normal.jpg https://pbs.twimg.com/profile_images/1300182083407618049/GekHJiWR_normal.jpg https://pbs.twimg.com/profile_banners/21404432/1598357672 4470A6 EEEEEE FFFFFF 333333 0 0 0 0 0 0 none
22167981 craigtimberg Craig Timberg Longtime WashPost reporter, editor and author now covering technology Washington, DC https://www.washingtonpost.com/people/craig-timberg/?utm_term=.62c2bd0c02da 0 4923 182 332 2009-02-27T18:02:48+00:00 1     0 0 416   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/2511897517/41lg5w502tl0112mjr2z_normal.jpeg https://pbs.twimg.com/profile_images/2511897517/41lg5w502tl0112mjr2z_normal.jpeg   0084B4 A8C7F7 C0DFEC 333333 1 0 0 0 0 0 none
24164338 NABJ NABJ Headquarters | NABJ.org The National Association of Black Journalists provides innovative programs, training, career services & advocacy for Black #journalists worldwide. #NABJ Washington, DC http://nabj.org 0 45397 3696 879 2009-03-13T12:42:37+00:00 7667     1 1 29507   0 0 0 F5F8FA http://abs.twimg.com/images/themes/theme14/bg.gif https://abs.twimg.com/images/themes/theme14/bg.gif 1 http://pbs.twimg.com/profile_images/1311475321204551685/5ysXlwiY_normal.jpg https://pbs.twimg.com/profile_images/1311475321204551685/5ysXlwiY_normal.jpg https://pbs.twimg.com/profile_banners/24164338/1601670883 57072E 000000 EFEFEF 333333 1 1 0 0 0 0 none
36388506 BobDrogin Bob Drogin Washington Deputy Bureau Chief for Los Angeles Times / author of Curveball Washington, DC   0 663 578 78 2009-04-29T15:43:56+00:00 5     0 0 252   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/190511133/Author_shot_normal.JPG https://pbs.twimg.com/profile_images/190511133/Author_shot_normal.JPG   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
60664050 HannahBloch Hannah Bloch @NPR lead international digital editor. Former WSJ Work in Progress columnist; TIME Pakistan & Afghanistan correspondent; National Geographic writer. Xenophile. Washington, DC   0 4034 1621 123 2009-07-27T18:02:27+00:00 8908     0 1 7515   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/374692033/0527091435_normal.jpg https://pbs.twimg.com/profile_images/374692033/0527091435_normal.jpg https://pbs.twimg.com/profile_banners/60664050/1416086488 0084B4 FFFFFF DDEEF6 333333 1 0 0 0 0 0 none
78114269 MarinaWalkerG Marina Walker Executive editor @Pulitzercenter. Mother of 2, builder of teams & @JSKStanford 2019 fellow. Always, @ICIJorg Washington, DC http://www.pulitzercenter.org 0 9876 2633 238 2009-09-28T20:31:14+00:00 2863     1 0 2703   0 0 0 EBEBEB 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/937897924624863232/4gV75E1f_normal.jpg https://pbs.twimg.com/profile_images/937897924624863232/4gV75E1f_normal.jpg https://pbs.twimg.com/profile_banners/78114269/1569711741 990000 DFDFDF F3F3F3 333333 1 0 0 0 1 0 none
96366316 ShannonBrownlee Shannon Brownlee SVP Lown Institute, author of Overtreated, member of @RightCareNow, advocate for radically transforming our unjust, wasteful healthcare system, and potter. Washington, DC http://www.lowninstitute.org 0 5393 434 302 2009-12-12T15:55:30+00:00 3557     0 0 13550   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/571308501/0001589-R3-009-3_normal.jpg https://pbs.twimg.com/profile_images/571308501/0001589-R3-009-3_normal.jpg   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
209407086 sylvestermonroe Sylvester Monroe Europe and South Asia Editor for the Washington Post Washington, DC   0 779 245 34 2010-10-29T03:50:44+00:00 209     0 0 265   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/2534843731/4ya4z4jdebxpgcye8si6_normal.jpeg https://pbs.twimg.com/profile_images/2534843731/4ya4z4jdebxpgcye8si6_normal.jpeg   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 141.487ms · About: simonw/jsk-fellows-on-twitter