users
6 rows
where location = "California, USA"
✎ 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, 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_text_color
|
profile_use_background_image
|
has_extended_profile
|
default_profile
|
default_profile_image
|
following
|
follow_request_sent
|
notifications
|
translator_type
|
| 14370540 |
jeremyhay |
jeremyhay |
Journalist, entrepreneur, JSK Stanford fellow '15 |
California, USA |
http://www.jeremyhay.com |
0 |
897 |
853 |
43 |
2008-04-12T19:21:05+00:00 |
378 |
|
|
1 |
0 |
1004 |
|
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/2656133726/ea2fef8b3992d9126b581a730ab33abb_normal.png |
https://pbs.twimg.com/profile_images/2656133726/ea2fef8b3992d9126b581a730ab33abb_normal.png |
|
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
none |
| 24346858 |
jmbelding |
J. Mariani-Belding |
Writer. Communicator. Marketer. Lover of good wine and cheese. Living my best life, with gratitude. |
California, USA |
|
1 |
30 |
55 |
5 |
2009-03-14T08:10:36+00:00 |
8 |
|
|
0 |
0 |
38 |
|
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/750933072976064513/jVTPupJN_normal.jpg |
https://pbs.twimg.com/profile_images/750933072976064513/jVTPupJN_normal.jpg |
|
FF0000 |
0C3E53 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
| 56245064 |
SteveMagagnini |
Stephen Magagnini |
independent journalist covering ethnic affairs, race relations, immigration, tribal affairs, faith issues and human rights |
California, USA |
http://sacbee.com |
0 |
1124 |
1510 |
55 |
2009-07-13T01:12:53+00:00 |
481 |
|
|
0 |
0 |
2077 |
|
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/1716086271/HA_MAGAGNINI_normal.JPG |
https://pbs.twimg.com/profile_images/1716086271/HA_MAGAGNINI_normal.JPG |
|
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
none |
| 105381785 |
susrust |
Susanne Rust |
Investigative Reporter @latimes |
California, USA |
http://www.latimes.com/la-bio-susanne-rust-staff.html |
0 |
2012 |
1271 |
0 |
2010-01-16T05:17:40+00:00 |
3092 |
|
|
1 |
1 |
2332 |
|
0 |
0 |
0 |
1B1B1F |
http://abs.twimg.com/images/themes/theme9/bg.gif |
https://abs.twimg.com/images/themes/theme9/bg.gif |
1 |
http://pbs.twimg.com/profile_images/689837497254154241/LcY_jR_k_normal.jpg |
https://pbs.twimg.com/profile_images/689837497254154241/LcY_jR_k_normal.jpg |
https://pbs.twimg.com/profile_banners/105381785/1453305385 |
2FC2EF |
9294A1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
| 520989810 |
village_scribe |
Divine Dube |
Local news #innovation geek. @JSKstanford Alum |
California, USA |
https://medium.com/@divine_dube |
0 |
1591 |
2614 |
7 |
2012-03-11T04:04:01+00:00 |
850 |
|
|
1 |
0 |
697 |
|
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/1159329012944187392/LIljsPSG_normal.jpg |
https://pbs.twimg.com/profile_images/1159329012944187392/LIljsPSG_normal.jpg |
https://pbs.twimg.com/profile_banners/520989810/1567903216 |
1DA1F2 |
333333 |
1 |
1 |
1 |
0 |
1 |
0 |
0 |
none |
| 908496738 |
deepafern |
Deepa Fernandes |
Journalist, global & local, @kcrw @TheWorld. Fellow at Pacific Oaks College. I report about women, kids, migrants, the environment. Alum @jskstanford @IWMF. |
California, USA |
http://deepafernandes.com/ |
0 |
3062 |
2537 |
127 |
2012-10-27T16:58:11+00:00 |
3700 |
|
|
1 |
0 |
4296 |
|
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/1316151637950390272/j0M2cF4O_normal.jpg |
https://pbs.twimg.com/profile_images/1316151637950390272/j0M2cF4O_normal.jpg |
https://pbs.twimg.com/profile_banners/908496738/1507961378 |
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
none |
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);
