users

22 rows where location = "San Francisco, CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: favourites_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, translator_type, 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
12497 simonw Simon Willison Creator of @datasetteproj, co-creator Django. Fellow at @JSKstanford. Collector of @nichemuseums. Usually hanging out with @natbat and @cleopaws. He/Him San Francisco, CA https://simonwillison.net/ 0 21461 4245 1265 2006-11-15T13:18:50+00:00 32193     1 1 24125   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/378800000261649705/be9cc55e64014e6d7663c50d7cb9fc75_normal.jpeg https://pbs.twimg.com/profile_images/378800000261649705/be9cc55e64014e6d7663c50d7cb9fc75_normal.jpeg https://pbs.twimg.com/profile_banners/12497/1347977147 0000FF FFFFFF FFFFFF 000000 1 1 0 0 0 0 regular
783324 maassive Dave Maass 🔦 Sr. researcher @EFF, w/eyes on cops and surveillance tech. Visiting Prof @RSJNevada. ❤️ terriers, journalism, altweeklies, FOIA, VR, audio drama. viewsrmineonly San Francisco, CA https://atlasofsurveillance.org/ 0 4661 1012 192 2007-02-20T15:24:29+00:00 10933     0 0 16275   0 0 0 131516 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/675097700279435264/n95a-GAh_normal.jpg https://pbs.twimg.com/profile_images/675097700279435264/n95a-GAh_normal.jpg https://pbs.twimg.com/profile_banners/783324/1439306484 009999 EEEEEE EFEFEF 333333 1 0 0 0 0 0 none
1169521 echeng Eric Cheng Photographer, technologist, drone guy, author, cellist, father. Head of Immersive Media @Oculus @Facebook. San Francisco, CA http://echeng.com 0 9168 1199 399 2007-03-14T17:43:08+00:00 665     1 0 13096   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/275256982/n224781_3464_normal.jpg https://pbs.twimg.com/profile_images/275256982/n224781_3464_normal.jpg https://pbs.twimg.com/profile_banners/1169521/1355422316 0084B4 A8C7F7 C0DFEC 333333 1 0 0 0 0 0 none
13371202 jtemplejrnalist john temple Chairman and Co-founder, Amuse Labs San Francisco, CA https://amuselabs.com/ 0 3168 559 276 2008-02-12T01:13:01+00:00 5725     1 0 2468   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/651401300194623488/R0dKYLXf_normal.jpg https://pbs.twimg.com/profile_images/651401300194623488/R0dKYLXf_normal.jpg https://pbs.twimg.com/profile_banners/13371202/1403487648 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
14478614 JeffElder Jeff Elder Cybersecurity reporter for Business Insider. DMs open for news tips, or email jelder@businessinsider dot com. Signal 4157999085 San Francisco, CA https://www.businessinsider.com/author/jeff-elder 0 87727 13602 1123 2008-04-22T18:54:22+00:00 10867     1 1 24941   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/864507389734666240/KWb2Kn_D_normal.jpg https://pbs.twimg.com/profile_images/864507389734666240/KWb2Kn_D_normal.jpg https://pbs.twimg.com/profile_banners/14478614/1602986642 000000 FFFFFF FFFFFF 000000 1 0 0 0 0 0 regular
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
14968475 jurafsky Dan Jurafsky Professor of linguistics and professor of computer science at Stanford and author of the James Beard award finalist "The Language of Food" San Francisco, CA http://www.stanford.edu/people/jurafsky 0 19245 282 475 2008-06-01T02:42:57+00:00 129     0 0 112   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/1644675738/portraits5med_normal.jpg https://pbs.twimg.com/profile_images/1644675738/portraits5med_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
17526481 YvonneLeow Yvonne Leow building @bewildercamp ⛺we're currently looking for beta campers! let us plan your next camping trip. San Francisco, CA http://www.yvonneleow.com 0 3655 601 302 2008-11-21T00:08:02+00:00 6597     1 0 9055   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/1204922150676643840/QaEWwill_normal.jpg https://pbs.twimg.com/profile_images/1204922150676643840/QaEWwill_normal.jpg https://pbs.twimg.com/profile_banners/17526481/1551395816 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
18917949 lilalahood Lila LaHood Publisher, San Francisco Public Press (@sfpublicpress) ~ lila [at] sfpublicpress [dot] org San Francisco, CA http://sfpublicpress.org 0 2257 2755 101 2009-01-12T22:15:43+00:00 994     0 0 1753   0 0 0 E6121E 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/580442162443251713/FFh1WoIV_normal.jpg https://pbs.twimg.com/profile_images/580442162443251713/FFh1WoIV_normal.jpg https://pbs.twimg.com/profile_banners/18917949/1400208834 EB1827 E1D8D4 D2D9DE 252F37 1 0 0 0 0 0 none
19002133 MonikaBauerlein Monika Bauerlein CEO, Mother Jones. Lover of politics, coffee, philosophy, debate, garlic. Views, RTs, lame jokes my own. She/they, and K not C. San Francisco, CA http://www.motherjones.com/authors/monika-bauerlein 0 13752 1813 469 2009-01-14T23:48:18+00:00 728     1 1 5198   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/550679254254366720/HznGJBcr_normal.png https://pbs.twimg.com/profile_images/550679254254366720/HznGJBcr_normal.png   0099B9 FFFFFF 95E8EC 3C3940 1 0 0 0 0 0 none
22257074 EricNewton1 Eric Newton Hoping for a fact-based future San Francisco, CA   0 3483 2772 249 2009-02-28T14:01:02+00:00 70     1 0 11244   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/1082429490821849089/975dkXqr_normal.jpg https://pbs.twimg.com/profile_images/1082429490821849089/975dkXqr_normal.jpg https://pbs.twimg.com/profile_banners/22257074/1364054088 0084B4 A8C7F7 C0DFEC 333333 1 0 0 0 0 0 none
22723759 mimileitsinger Miranda Leitsinger @KQEDnews, formerly @NBC News, @CNN, @AP, @AFP. From breaking news to investigative reporting, with a passion for gender and culture. San Francisco, CA http://www.kqed.org 0 1814 3751 87 2009-03-04T02:58:25+00:00 810     1 0 9547   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/604387454800404481/7f7bfBao_normal.jpg https://pbs.twimg.com/profile_images/604387454800404481/7f7bfBao_normal.jpg https://pbs.twimg.com/profile_banners/22723759/1398888304 990000 DFDFDF F3F3F3 333333 1 0 0 0 0 0 none
46518958 chloeveltman Chloe Veltman Arts & Culture Reporter at @KQED San Francisco, CA http://www.chloeveltman.com 0 2187 741 128 2009-06-11T23:14:41+00:00 434     1 0 5340   0 0 0 BADFCD 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/2147125530/twitter_photo_normal.png https://pbs.twimg.com/profile_images/2147125530/twitter_photo_normal.png https://pbs.twimg.com/profile_banners/46518958/1358380449 FF0000 F2E195 FFF7CC 0C3E53 1 0 0 0 0 0 none
86776199 jmckellogg JulieAnn McKellogg Making texts fetch @joinsubtext | Builder and storyteller @JSKstanford @pactio_us @mcclatchy @washingtonpost @voanews @UNCHussman San Francisco, CA http://joinsubtext.com 0 1576 946 73 2009-11-01T18:44:39+00:00 10280     1 0 5563   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/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_images/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_banners/86776199/1448332496 91D2FA FFFFFF 252429 666666 0 0 0 0 1 0 none
101789560 heathersomervil Heather Somerville Technology reporter @WSJ. Formerly @reuters @mercnews @fresnobee. Mountain climber in my spare time. heather.somerville@wsj.com/ http://protonmail.com. DM for Signal # San Francisco, CA https://www.wsj.com/ 0 5375 1459 346 2010-01-04T15:41:33+00:00 1462     0 1 5950   0 0 0 352726 http://abs.twimg.com/images/themes/theme5/bg.gif https://abs.twimg.com/images/themes/theme5/bg.gif 0 http://pbs.twimg.com/profile_images/1090374013258391552/Dh4-jAu2_normal.jpg https://pbs.twimg.com/profile_images/1090374013258391552/Dh4-jAu2_normal.jpg https://pbs.twimg.com/profile_banners/101789560/1402071935 9266CC 829D5E 99CC33 3E4415 1 0 0 0 0 0 none
106430958 Aaron_Glantz Aaron Glantz Senior Reporter @Reveal, Pulitzer Finalist, Author, HOMEWRECKERS from HarperCollins, Peabody & duPont Award-winning journalist, 2016 JSK Fellow at Stanford San Francisco, CA http://www.aglantz.com/ 0 7366 2169 260 2010-01-19T14:53:25+00:00 1983     0 1 11383   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/1130878485705109504/hAHCW38J_normal.png https://pbs.twimg.com/profile_images/1130878485705109504/hAHCW38J_normal.png https://pbs.twimg.com/profile_banners/106430958/1562784141 DD2E44 000000 000000 000000 0 0 0 0 0 0 none
577618330 KarendeSa1 Karen de Sa an investigative reporter for the San Francisco Chronicle San Francisco, CA http://www.sfchronicle.com 0 592 100 33 2012-05-12T01:22:24+00:00 0     0 0 50   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/2210800097/144_normal.JPG https://pbs.twimg.com/profile_images/2210800097/144_normal.JPG   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
1246512684 newstapes The Newstapes News you need for the time you have. One story per day, in 3 links, depending on how much time you have. (A project by @M_C_B, Knight fellow '13) San Francisco, CA http://www.newstap.es 0 271 590 15 2013-03-06T16:55:45+00:00 727     0 0 1017   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/378800000115313860/919cc0ac3111359f6838cc7334e7f2d7_normal.jpeg https://pbs.twimg.com/profile_images/378800000115313860/919cc0ac3111359f6838cc7334e7f2d7_normal.jpeg https://pbs.twimg.com/profile_banners/1246512684/1368745131 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
1548898596 Ericnpr Eric Westervelt @NPR journalist. Recovering foreign correspondent. Occasional host. Musician by moonlight http://SecureDrop.npr.org/ http://SeeDisclaimer.com San Francisco, CA https://www.npr.org/people/2101350/eric-westervelt 0 4897 2014 210 2013-06-26T19:27:15+00:00 680     0 1 2353   0 0 0 000000 http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 0 http://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_banners/1548898596/1406506418 3B94D9 000000 000000 000000 0 0 0 0 0 0 none
3245142196 GoogleNewsInit Google News Initiative Our effort to help news organizations and journalists thrive in the digital age. San Francisco, CA http://g.co/newsinitiative 0 111446 229 2229 2015-05-10T17:09:58+00:00 1934     1 1 3475   0 0 0 131516 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/976112586528784385/4WNT1R6Q_normal.jpg https://pbs.twimg.com/profile_images/976112586528784385/4WNT1R6Q_normal.jpg https://pbs.twimg.com/profile_banners/3245142196/1521558388 009999 EEEEEE EFEFEF 333333 1 0 0 0 1 0 none
3473664018 ProjectFacet Project Facet The Future of Journalism is Collaborative. Facet is an open source project to help newsrooms create and manage effective editorial collaborations. San Francisco, CA http://projectfacet.org 0 1030 235 46 2015-09-06T19:26:43+00:00 27     0 0 159   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/980586215878488066/sutDTgCF_normal.jpg https://pbs.twimg.com/profile_images/980586215878488066/sutDTgCF_normal.jpg https://pbs.twimg.com/profile_banners/3473664018/1522625220 084250 000000 000000 000000 0 0 0 0 1 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

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