users
3 rows
where location = "Chicago, IL"
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: verified, profile_background_tile, profile_text_color, 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_text_color
|
profile_use_background_image
|
has_extended_profile
|
default_profile
|
default_profile_image
|
following
|
follow_request_sent
|
notifications
|
translator_type
|
| 8119452 |
dansinker |
💀 damned sinker 💀 |
I did http://impeachment.fyi. Co-host of @sayswhopodcast, formerly @opennews, author of @MayorEmanuel, founder of Punk Planet (RIP), #1 Candle King of Kickstarter |
Chicago, IL |
http://dansinker.com |
0 |
28430 |
4171 |
1259 |
2007-08-11T05:51:44+00:00 |
103540 |
|
|
1 |
0 |
132008 |
|
0 |
0 |
0 |
C6E2EE |
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/552597001393561600/vhKa2xDz_normal.jpeg |
https://pbs.twimg.com/profile_images/552597001393561600/vhKa2xDz_normal.jpeg |
https://pbs.twimg.com/profile_banners/8119452/1347983122 |
1F98C7 |
663B12 |
1 |
1 |
0 |
0 |
1 |
0 |
0 |
regular |
| 16679681 |
sbanchero |
Stephanie Banchero |
Stephanie Banchero. Education Program Director at @JoyceFdn Former Wall Street Journal education reporter; Utah Jazz fan; shameless lover of corndogs & DWTS. |
Chicago, IL |
http://www.joycefdn.org |
0 |
9243 |
2241 |
414 |
2008-10-10T05:05:16+00:00 |
1323 |
|
|
1 |
1 |
4088 |
|
0 |
0 |
0 |
ADBFDE |
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/1029559885405593600/d2DaWybW_normal.jpg |
https://pbs.twimg.com/profile_images/1029559885405593600/d2DaWybW_normal.jpg |
https://pbs.twimg.com/profile_banners/16679681/1547853211 |
040485 |
333333 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
| 197940788 |
kscottAtLarge |
Kelly Scott |
Writer, editor, political obsessive, arts & culture enthusiast and @Dodgers fan. Proud mom of @DevinMitchell, @sc_mitchell. |
Chicago, IL |
|
0 |
1407 |
891 |
84 |
2010-10-02T22:13:14+00:00 |
1499 |
|
|
1 |
0 |
1243 |
|
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/1301349062185279488/hdOVr84b_normal.jpg |
https://pbs.twimg.com/profile_images/1301349062185279488/hdOVr84b_normal.jpg |
|
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);
