users
11 rows
where protected = 1 sorted by is_translator
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: location, listed_count, favourites_count, geo_enabled, 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, 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
|
16679508 |
GeriLSmith |
Geri Smith |
Spent 3 decades as foreign correspondent in Latin America. Handle media relations for Inter-American Development Bank. All postings reflect personal views only. |
Washington, D.C. |
|
1 |
774 |
414 |
52 |
2008-10-10T04:43:07+00:00 |
15 |
|
|
0 |
0 |
532 |
|
0 |
0 |
0 |
D6CBAB |
http://abs.twimg.com/images/themes/theme3/bg.gif |
https://abs.twimg.com/images/themes/theme3/bg.gif |
0 |
http://pbs.twimg.com/profile_images/66177253/052308_gsmith_lowrez_03_square_normal.jpg |
https://pbs.twimg.com/profile_images/66177253/052308_gsmith_lowrez_03_square_normal.jpg |
|
088253 |
332729 |
1 |
0 |
0 |
0 |
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 |
333333 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
none |
20188770 |
gannonbill |
\ |
Tweets are my own |
|
|
1 |
454 |
3 |
41 |
2009-02-05T21:11:25+00:00 |
212 |
|
|
0 |
0 |
800 |
|
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/1245208092159205380/0EIOGf2k_normal.jpg |
https://pbs.twimg.com/profile_images/1245208092159205380/0EIOGf2k_normal.jpg |
|
038543 |
333333 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
22746299 |
ariehos |
Arieh O'Sullivan |
I am a correspondent and anchor at Israel Public Radio English news in Israel, registered Tour Guide, whiskey brewer and storyteller from Elah Valley |
|
|
1 |
151 |
397 |
4 |
2009-03-04T07:34:23+00:00 |
147 |
|
|
1 |
0 |
424 |
|
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/1135873070403641344/hqT_UIZB_normal.jpg |
https://pbs.twimg.com/profile_images/1135873070403641344/hqT_UIZB_normal.jpg |
https://pbs.twimg.com/profile_banners/22746299/1559648097 |
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 |
41007644 |
MBStannard |
Matthew B. Stannard |
|
|
|
1 |
16 |
140 |
8 |
2009-05-19T00:11:54+00:00 |
2 |
|
|
0 |
0 |
449 |
|
0 |
0 |
0 |
9AE4E8 |
http://abs.twimg.com/images/themes/theme1/bg.png |
https://abs.twimg.com/images/themes/theme1/bg.png |
1 |
http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png |
https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png |
|
0084B4 |
333333 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
none |
48193439 |
drigarcia |
drigarcia |
Journalism, Creativity, Innovation. Teaching Fellow at Google News Initiative. Co-founder of Orbital Midia. @jskstanford 12'/13' |
São Paulo, Brasil |
http://about.me/adrianagarciamartinez |
1 |
511 |
790 |
44 |
2009-06-18T01:20:51+00:00 |
2100 |
|
|
0 |
0 |
3142 |
|
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/449646491947118592/ctJTDH3m_normal.jpeg |
https://pbs.twimg.com/profile_images/449646491947118592/ctJTDH3m_normal.jpeg |
https://pbs.twimg.com/profile_banners/48193439/1357324067 |
94D487 |
000000 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
113442154 |
GrazePRTX |
Gregory Graze |
senior PR pro and former journalist helping post-start-up and mature companies in IT, medical tech/health care, water tech, public affairs, and more. |
Dallas, TX |
http://www.grazepr.com |
1 |
39 |
71 |
4 |
2010-02-11T19:38:18+00:00 |
1 |
|
|
0 |
0 |
106 |
|
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/690027097/GGG_biz_view2_normal.JPG |
https://pbs.twimg.com/profile_images/690027097/GGG_biz_view2_normal.JPG |
|
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
none |
315834402 |
wanjasnotebook |
Wanja Njuguna |
Mother, writer, editor, journalism/communication lecturer, human rights defende. Loves reading voraciously, mentoring, birding, environment, fun. I hate liers! |
The World |
http://wanjasnotebook.blogspot.com |
1 |
123 |
527 |
5 |
2011-06-12T14:35:11+00:00 |
126 |
|
|
0 |
0 |
6423 |
|
0 |
0 |
0 |
FFF04D |
http://abs.twimg.com/images/themes/theme19/bg.gif |
https://abs.twimg.com/images/themes/theme19/bg.gif |
0 |
http://pbs.twimg.com/profile_images/741570115255336960/J4h2xzYQ_normal.jpg |
https://pbs.twimg.com/profile_images/741570115255336960/J4h2xzYQ_normal.jpg |
https://pbs.twimg.com/profile_banners/315834402/1536599976 |
C5CC00 |
333333 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
588357987 |
semaanmariam |
mariam semaan |
#Knight #Fellow 2012/13 #Stanford #University #DesignThinking#Media expert #Designer of #Experiences #vintage clothes and accessories #collector |
|
|
1 |
207 |
219 |
16 |
2012-05-23T13:11:28+00:00 |
59 |
|
|
0 |
0 |
694 |
|
0 |
0 |
0 |
642D8B |
http://abs.twimg.com/images/themes/theme10/bg.gif |
https://abs.twimg.com/images/themes/theme10/bg.gif |
1 |
http://pbs.twimg.com/profile_images/2243512422/1985-monet-ad_normal.jpg |
https://pbs.twimg.com/profile_images/2243512422/1985-monet-ad_normal.jpg |
|
FF3300 |
333333 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
none |
619420043 |
JoelGutierrezG |
Joel Gutierrez |
Periodista nicaragüense, Knight Fellow de la Universidad de Stanford |
Nicaragua |
|
1 |
52 |
254 |
0 |
2012-06-26T21:03:38+00:00 |
16 |
|
|
0 |
0 |
17 |
|
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/3392865003/b895e25dbd66af6e16a49344db47d93a_normal.jpeg |
https://pbs.twimg.com/profile_images/3392865003/b895e25dbd66af6e16a49344db47d93a_normal.jpeg |
https://pbs.twimg.com/profile_banners/619420043/1363542500 |
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);