users

17 rows where location = "New York, NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: friends_count, geo_enabled, 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, has_extended_profile, default_profile, following, 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
8441632 burtherman Burt Herman Entrepreneurial journalist finding meaning in the noise. Now: Product @CondeNast. Always: @HacksHackers. Previous: @LenfestInst, Co-founder @Storify, @AP New York, NY http://burtherman.com 0 9235 1964 971 2007-08-26T14:23:45+00:00 1951     1 1 6762   0 0 0 1A1B1F 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/67612383/XWS147_normal.jpg https://pbs.twimg.com/profile_images/67612383/XWS147_normal.jpg https://pbs.twimg.com/profile_banners/8441632/1537899498 2FC2EF 181A1E 252429 666666 1 1 0 0 0 0 none
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
14573694 grimesa Ann Grimes Knight-Bagehot Fellowship in Economics and Business Journalism/ Graduate School of Journalism / Columbia University New York, NY https://journalism.columbia.edu/kb 0 770 643 30 2008-04-28T19:12:26+00:00 1158     0 0 813   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/378800000507011222/b1c8e73f2815b558851d703daecd6fe4_normal.jpeg https://pbs.twimg.com/profile_images/378800000507011222/b1c8e73f2815b558851d703daecd6fe4_normal.jpeg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
15120110 praeburn Paul Raeburn Journalist. Author. Producer, Gilbert Gottfried's Amazing Colossal Podcast. Passionate about journalism. Excited about comedy. New York, NY http://www.paulraeburn.com 0 3902 648 228 2008-06-14T21:45:49+00:00 545     0 0 5132   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 1 http://pbs.twimg.com/profile_images/55460608/Author_photo__color__normal.jpg https://pbs.twimg.com/profile_images/55460608/Author_photo__color__normal.jpg https://pbs.twimg.com/profile_banners/15120110/1357091546 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
15315979 nuncaduermo Carolina Guerrero CEO of @NPR's @RadioAmbulante + @elhilopodcast. Breaking the language barrier with @LupaApp. @JSKStanford Fellow. Personal Assistant to León & Eliseo. New York, NY http://radioambulante.org 0 15419 4134 279 2008-07-04T07:42:02+00:00 32727     0 0 22405   0 0 0 13BA07 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/1111539185050157056/bKmpwrIb_normal.jpg https://pbs.twimg.com/profile_images/1111539185050157056/bKmpwrIb_normal.jpg https://pbs.twimg.com/profile_banners/15315979/1571587045 FF2F00 14BA16 D6D6D6 000000 0 0 0 0 0 0 none
16248718 LisaHsia LisaHsia EVP Digital media at @bravotv @oxygen @universalkids New York, NY http://www.bravotv.com 0 1374 459 92 2008-09-11T22:17:50+00:00 38     0 0 100   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/521737578894995456/skvtzN8B_normal.jpeg https://pbs.twimg.com/profile_images/521737578894995456/skvtzN8B_normal.jpeg   3B94D9 000000 000000 000000 0 0 0 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
17511846 cmdelaserna carlosmartinezserna Program Director @pressfreedom Journalism & human rights New York, NY   0 2014 643 149 2008-11-20T14:23:06+00:00 7399     1 0 14960   0 0 0 FFFFFF 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/1005128112332558338/cAchmFvV_normal.jpg https://pbs.twimg.com/profile_images/1005128112332558338/cAchmFvV_normal.jpg https://pbs.twimg.com/profile_banners/17511846/1485113035 5384CF FFFFFF FFFCFF 333333 1 0 0 0 0 0 none
20253808 AndreaWNYC Andrea Bernstein Co-host Trump, Inc. podcast from @WNYC & @ProPublica; NYT best-selling author: AMERICAN OLIGARCHS: The Kushners, The Trumps, and the Marriage of Money and Power New York, NY http://AndreaBernsteinBook.com 0 28333 1906 726 2009-02-06T17:29:43+00:00 4997     1 1 3349   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/918152096834351104/A_PEmQWi_normal.jpg https://pbs.twimg.com/profile_images/918152096834351104/A_PEmQWi_normal.jpg https://pbs.twimg.com/profile_banners/20253808/1597421977 FA743E 000000 000000 000000 0 0 0 0 0 0 none
22552271 NewsEditors News Leaders Association NLA believes all citizens should be informed by accurate, truthful, independent reporting so they can demand the best from our democratic institutions. New York, NY http://newsleaders.org 0 8562 1118 0 2009-03-02T23:26:59+00:00 1679     1 0 8113   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/1118867876717432834/eBIN-m3v_normal.png https://pbs.twimg.com/profile_images/1118867876717432834/eBIN-m3v_normal.png https://pbs.twimg.com/profile_banners/22552271/1588008780 DD2E44 000000 000000 000000 0 0 0 0 0 0 none
28113052 bfouhy Beth Fouhy Senior editor, politics, NBC News and MSNBC New York, NY http://www.msnbc.com 0 14638 2823 626 2009-04-01T14:15:21+00:00 4212     1 1 6769   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/694339732726288384/choRXTLd_normal.jpg https://pbs.twimg.com/profile_images/694339732726288384/choRXTLd_normal.jpg https://pbs.twimg.com/profile_banners/28113052/1489866966 CC3366 DBE9ED E6F6F9 333333 1 0 0 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
36063042 dipinheiro Di Pinheiro Journalist, 2011 Fellow @JSKStanford. Former Editor @WSJAmericas and @WSJPortugues; goes from flower girl to street fighter, batman style, whenever required. New York, NY http://wsj.com/brazil 0 486 1664 21 2009-04-28T13:24:41+00:00 110     0 0 572   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/674446152587157504/0suL4TOs_normal.jpg https://pbs.twimg.com/profile_images/674446152587157504/0suL4TOs_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
55300229 ronnyrojas Ronny Rojas Tico. Investigative reporter. @TelemundoNews @newmarkjschool @JSKstanford '19. Before @Uninoticias; @OCCRP; @nacion ronny.rojas@journalism.cuny.edu New York, NY   0 1752 831 109 2009-07-09T17:28:26+00:00 1014     1 0 3519   0 0 0 ABB8C2 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/858879547285979136/sQUJzNEF_normal.jpg https://pbs.twimg.com/profile_images/858879547285979136/sQUJzNEF_normal.jpg https://pbs.twimg.com/profile_banners/55300229/1600481706 4A913C C0DEED DDEEF6 333333 1 0 0 0 0 0 none
115359136 losowsky Andrew Losowsky   New York, NY   0 8023 2479 479 2010-02-18T12:03:16+00:00 62943     0 1 3762   0 0 0 0DFFEB 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/1172898126476169217/OuDBRUoS_normal.jpg https://pbs.twimg.com/profile_images/1172898126476169217/OuDBRUoS_normal.jpg https://pbs.twimg.com/profile_banners/115359136/1395183178 ABB8C2 DBE9ED E6F6F9 333333 1 0 0 0 0 0 none
240393453 marcellehopkins Marcelle Hopkins Executive producer of VR/AR and deputy editor of video at The New York Times. Formerly Al Jazeera. New York, NY http://nytimes.com 0 4776 506 260 2011-01-19T20:43:47+00:00 231     1 0 3169   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/1189023622838407171/dE-AtopQ_normal.jpg https://pbs.twimg.com/profile_images/1189023622838407171/dE-AtopQ_normal.jpg https://pbs.twimg.com/profile_banners/240393453/1428070937 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 1 0 none
310596714 radioambulante Radio Am-booo-lan-te 👻 Contamos tus historias: único podcast en español de @NPR / Tenemos un nuevo podcast: @elhilopodcast / Breaking the language barrier with @LupaApp. New York, NY http://www.radioambulante.org 0 323019 2303 972 2011-06-04T01:16:58+00:00 28539     1 1 40470   0 0 0 C6CBCC 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/1308783263478095872/eTkEs7WT_normal.jpg https://pbs.twimg.com/profile_images/1308783263478095872/eTkEs7WT_normal.jpg https://pbs.twimg.com/profile_banners/310596714/1603747127 F01D2F DBE9ED E6F6F9 333333 1 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 119.961ms · About: simonw/jsk-fellows-on-twitter