users
5 rows
where location = "Washington DC"
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: geo_enabled, verified, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, has_extended_profile, default_profile, 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
|
| 15035816 |
TomokoHosaka |
Tomoko Hosaka Mullaney |
Japan VP @TheAsiaGroup | @AAJA Media Institute co-director | @Northwestern @waseda_univ alum | Past: @AP @DowJones @Plympton & Ustream | Journalist at heart |
Washington DC |
|
0 |
14359 |
3590 |
1137 |
2008-06-07T04:52:02+00:00 |
1155 |
|
|
1 |
1 |
11394 |
|
0 |
0 |
0 |
9AE4E8 |
http://abs.twimg.com/images/themes/theme16/bg.gif |
https://abs.twimg.com/images/themes/theme16/bg.gif |
0 |
http://pbs.twimg.com/profile_images/707943808487596032/bZeGOEAF_normal.jpg |
https://pbs.twimg.com/profile_images/707943808487596032/bZeGOEAF_normal.jpg |
https://pbs.twimg.com/profile_banners/15035816/1448032939 |
0084B4 |
333333 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
| 17018840 |
sullivank |
Kevin Sullivan |
Washington Post Senior Correspondent. Author, with Mary Jordan, of 'Trump on Trial.' Out 8/25/2020. Pre-orders now! |
Washington DC |
http://washingtonpost.com |
0 |
4364 |
1040 |
153 |
2008-10-28T10:42:23+00:00 |
1327 |
|
|
1 |
1 |
39 |
|
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/940644334558498818/t3l52xkA_normal.jpg |
https://pbs.twimg.com/profile_images/940644334558498818/t3l52xkA_normal.jpg |
https://pbs.twimg.com/profile_banners/17018840/1602020607 |
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
none |
| 36406587 |
jonresnickUAS |
Jon Resnick |
Producer for Fox Business Network covering the White House, Hill and Federal agencies. Tweets are definitely my own. |
Washington DC |
|
0 |
2786 |
2224 |
125 |
2009-04-29T16:55:18+00:00 |
475 |
|
|
1 |
0 |
4766 |
|
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/1073237802400137216/6q3Npa5i_normal.jpg |
https://pbs.twimg.com/profile_images/1073237802400137216/6q3Npa5i_normal.jpg |
https://pbs.twimg.com/profile_banners/36406587/1420422557 |
0084B4 |
333333 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
| 50379519 |
sonniefron |
Sonni Efron |
President & COO, National Press Foundation. Journalism, foreign policy, democracy, human rights, technology, free expression, opinions my own, RTs not. |
Washington DC |
http://www.nationalpress.org |
0 |
410 |
422 |
16 |
2009-06-24T17:55:58+00:00 |
205 |
|
|
0 |
0 |
813 |
|
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/499964856099819520/eHWLlmXV_normal.jpeg |
https://pbs.twimg.com/profile_images/499964856099819520/eHWLlmXV_normal.jpeg |
|
0084B4 |
000000 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
none |
| 531407250 |
andrewzajac1 |
Andrew Zajac |
Legal reporter for Bloomberg News |
Washington DC |
|
0 |
151 |
128 |
20 |
2012-03-20T14:55:56+00:00 |
3 |
|
|
1 |
0 |
250 |
|
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/3688038302/73f13aae68380e11f900493f999b920f_normal.jpeg |
https://pbs.twimg.com/profile_images/3688038302/73f13aae68380e11f900493f999b920f_normal.jpeg |
|
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);
