users

14 rows where location = "San Francisco"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: protected, 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
29283 tigerbeat Steve Rhodes Photojournalist Also @tigerbeat @instagram Don't embed my photos as tweets/Instagram in stories Pay for my work DM or srhodes gmail Signal available on request San Francisco http://www.flickr.com/ari 0 10265 11305 726 2006-11-29T01:51:08+00:00 528568     1 0 572750   0 0 0 9AE4E8 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/1763378768/image_normal.jpg https://pbs.twimg.com/profile_images/1763378768/image_normal.jpg https://pbs.twimg.com/profile_banners/29283/1396025539 0000FF 87BC44 E0FF92 000000 1 1 0 0 0 0 none
770729 lizgannes Liz Gannes My last name rhymes with braaains. San Francisco http://60db.co 0 68124 2906 2171 2007-02-13T23:05:04+00:00 1015     1 1 6246   0 0 0 8EDA42 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/471712372659216385/eM4o7S3H_normal.jpeg https://pbs.twimg.com/profile_images/471712372659216385/eM4o7S3H_normal.jpeg https://pbs.twimg.com/profile_banners/770729/1401690657 0000FF 87BC44 E0FF91 000000 1 0 0 0 1 0 none
6199412 jim_colgan Jim Colgan Radio/media/tech. Stanford JSK fellow. Previously Audible, WNYC, SoundCloud. California via New York via Dublin. San Francisco   0 2045 2277 89 2007-05-21T13:35:41+00:00 1513     1 0 4270   0 0 0 9AE4E8 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/1217308517494747136/8FDoKzpJ_normal.jpg https://pbs.twimg.com/profile_images/1217308517494747136/8FDoKzpJ_normal.jpg   4A913C 87BC44 E0FF92 000000 1 0 0 0 1 0 none
14140617 BAVC Bay Area Video Coalition Inspiring social change by empowering media makers to develop & share diverse stories. San Francisco https://linktr.ee/bavc 0 6808 2911 490 2008-03-13T16:41:47+00:00 4456     1 1 8582   0 0 0 9FC15F 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/948381251358007297/u0jyFHuC_normal.jpg https://pbs.twimg.com/profile_images/948381251358007297/u0jyFHuC_normal.jpg https://pbs.twimg.com/profile_banners/14140617/1514946705 A0C613 000000 E3E2DE 634047 0 1 0 0 0 0 none
14192329 kvox Karen Wickre ☕️💻👀 Veteran word wrangler, ex @twitter, @google, etc. Media obsessive. Art & dog enthusiast. Boards: @JSKStanford, @NewsLitProject. Also #newsgeist, TED. She/her. San Francisco https://karenwickre.com 0 17370 4965 840 2008-03-21T17:02:43+00:00 6303     1 1 71317   0 0 0 2A2E1A 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/1040665182937047040/CdNBsuit_normal.jpg https://pbs.twimg.com/profile_images/1040665182937047040/CdNBsuit_normal.jpg https://pbs.twimg.com/profile_banners/14192329/1571088196 1B95E0 FFFFFF 999E86 7A4A1D 1 1 0 0 0 0 regular
17797390 5harad Sharad Goel Professor at @Stanford and director of @CompPolicyLab, where we work to drive reform in criminal justice, education, voting rights, and beyond. San Francisco https://5harad.com 0 3100 90 115 2008-12-02T02:50:36+00:00 146     0 0 371   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/1183191691/Sharad_Goel_normal.jpeg https://pbs.twimg.com/profile_images/1183191691/Sharad_Goel_normal.jpeg https://pbs.twimg.com/profile_banners/17797390/1594082537 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
18197783 lcasimir Leslie Casimir Freelance journalist San Francisco   1 48 173 4 2008-12-17T19:54:56+00:00 2     0 0 21   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/68344981/cafesperl_normal.jpg https://pbs.twimg.com/profile_images/68344981/cafesperl_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
19587103 ANDREWCPURVIS Andrew Purvis Journalist and bureau chief, formerly w/ @TIME in Africa, eastern Europe, Turkey, Balkans, Germany. Consultant w/ UN Refugee Agency. Missing...Beirut. San Francisco http://about.me/andrewcpurvis 0 1115 792 79 2009-01-27T11:19:44+00:00 6310     1 0 6958   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/1517265044/DSC01404_2_normal.JPG https://pbs.twimg.com/profile_images/1517265044/DSC01404_2_normal.JPG https://pbs.twimg.com/profile_banners/19587103/1420739696 1B95E0 000000 DDEEF6 333333 1 0 0 0 0 0 none
27921386 aschirtz alexa schirtzinger product marketing @box | former @google @salesforce @JSKStanford @columbiajourn | usual disclaimers San Francisco   0 2427 2073 0 2009-03-31T17:46:59+00:00 621     1 0 3872   0 0 0 A2C1E0 http://abs.twimg.com/images/themes/theme18/bg.gif https://abs.twimg.com/images/themes/theme18/bg.gif 1 http://pbs.twimg.com/profile_images/461933517245411328/2ktktWq3_normal.jpeg https://pbs.twimg.com/profile_images/461933517245411328/2ktktWq3_normal.jpeg https://pbs.twimg.com/profile_banners/27921386/1398206226 3B94D9 FFFFFF F6F6F6 333333 1 0 0 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
103661473 voicebox_media VoiceBox Media VoiceBox is an eclectic public radio and podcast series about the voice. Tune in on Fridays at 10PM on 91.7 FM KALW. Listen live at http://www.kalw.org/ San Francisco http://voicebox-media.org 0 151 105 12 2010-01-10T20:42:36+00:00 0     0 0 159   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/3521682516/ba39c7a4e0c50f47fc12a235f1661abf_normal.png https://pbs.twimg.com/profile_images/3521682516/ba39c7a4e0c50f47fc12a235f1661abf_normal.png https://pbs.twimg.com/profile_banners/103661473/1365967664 009999 EEEEEE EFEFEF 333333 1 0 0 0 0 0 none
183906947 steingreenberg Sarah SteinGreenberg   San Francisco http://dschool.stanford.edu 0 570 122 24 2010-08-28T05:06:00+00:00 57     0 0 193   0 0 0 ACDED6 http://abs.twimg.com/images/themes/theme18/bg.gif https://abs.twimg.com/images/themes/theme18/bg.gif 0 http://pbs.twimg.com/profile_images/893256670804967424/8qVnsTjg_normal.jpg https://pbs.twimg.com/profile_images/893256670804967424/8qVnsTjg_normal.jpg   038543 EEEEEE F6F6F6 333333 1 0 0 0 0 0 none
245587242 garanceburke Garance Burke Global investigative journalist @AP. 2020 @JSKStanford-@StanfordHAI Fellow. Pulitzer finalist. Your ideas welcome—DM for Signal. garanceburke@protonmail.com San Francisco http://www.ap.org 0 5807 5204 307 2011-02-01T01:16:48+00:00 2718     0 1 4181   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/528304938305064960/2TM8R2h5_normal.jpeg https://pbs.twimg.com/profile_images/528304938305064960/2TM8R2h5_normal.jpeg https://pbs.twimg.com/profile_banners/245587242/1414792879 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 1 0 none
1407123218 DroneDeploy DroneDeploy Cloud-based software enabling simple and reliable drone operations. Create maps & 3D models in two clicks. Over 100 million acres mapped. San Francisco http://www.dronedeploy.com 0 31334 794 529 2013-05-06T08:00:03+00:00 6458     0 1 8211   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/907391581220515840/LY88qfLd_normal.jpg https://pbs.twimg.com/profile_images/907391581220515840/LY88qfLd_normal.jpg https://pbs.twimg.com/profile_banners/1407123218/1516655339 2F85C7 C0DEED DDEEF6 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 120.453ms · About: simonw/jsk-fellows-on-twitter