users
6 rows
where default_profile = 1, following = 1 and verified = 1
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: location, geo_enabled, profile_background_color, 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
|
| 14636665 |
fcoel |
Flor Coelho |
La del #emojidelmate 🧉 (& Co.) / Proud @JSKStanford @LNdata & @LNnaturaleza. @ONA #HHBA #neverstoplearning |
Buenos Aires, Argentina |
|
0 |
11793 |
7140 |
446 |
2008-05-03T10:16:42+00:00 |
51469 |
|
|
1 |
1 |
57021 |
|
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/481530886522146816/5q27In5E_normal.jpeg |
https://pbs.twimg.com/profile_images/481530886522146816/5q27In5E_normal.jpeg |
|
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
1 |
0 |
0 |
regular |
| 47854857 |
aleithead |
Alastair Leithead |
Portugal-based journalist using BBC foreign correspondent skills to live off the grid, experiment with new ways of storytelling and work agains the infodemic |
Odemira, SW Portugal |
http://alastairleithead.com |
0 |
14982 |
690 |
563 |
2009-06-17T04:26:19+00:00 |
34 |
|
|
1 |
1 |
1382 |
|
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/1313772038515982336/qsvNyDg1_normal.jpg |
https://pbs.twimg.com/profile_images/1313772038515982336/qsvNyDg1_normal.jpg |
https://pbs.twimg.com/profile_banners/47854857/1602062638 |
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
1 |
0 |
0 |
none |
| 70574113 |
djordjepadejski |
Djordje Padejski |
@JSKStanford Associate Director, investigative/data journalist, @ICIJorg member, @FOIAMACHINE founder, alum: @CIRonline @OCCRP @CINSerbia |
Stanford, CA |
http://jsk.stanford.edu |
0 |
2197 |
1422 |
156 |
2009-09-01T02:29:07+00:00 |
5079 |
|
|
1 |
1 |
5810 |
|
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/594768300724199424/R380icBL_normal.jpg |
https://pbs.twimg.com/profile_images/594768300724199424/R380icBL_normal.jpg |
https://pbs.twimg.com/profile_banners/70574113/1390291654 |
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
1 |
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 |
333333 |
1 |
0 |
1 |
0 |
1 |
0 |
0 |
none |
| 778895864 |
RachelDissell |
Rachel Dissell |
Journalist. Former Plain Dealer reporter. Mama bear. Public records are my jam. Current @JSKstanford fellow. Send tips to rldissell@gmail.com |
Cleveland, Oh |
|
0 |
8014 |
2588 |
201 |
2012-08-24T20:16:33+00:00 |
9378 |
|
|
1 |
1 |
11781 |
|
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/691074780687142913/902N9itu_normal.jpg |
https://pbs.twimg.com/profile_images/691074780687142913/902N9itu_normal.jpg |
https://pbs.twimg.com/profile_banners/778895864/1552874644 |
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
1 |
0 |
0 |
none |
| 1067218780806307841 |
StanfordHAI |
Stanford HAI |
Advancing AI research, education, policy, and practice to improve the human condition. |
Stanford, CA |
https://hai.stanford.edu |
0 |
31130 |
117 |
616 |
2018-11-27T00:49:20+00:00 |
175 |
|
|
0 |
1 |
736 |
|
0 |
0 |
0 |
F5F8FA |
|
|
0 |
http://pbs.twimg.com/profile_images/1312204437172097024/AEjW7Yds_normal.jpg |
https://pbs.twimg.com/profile_images/1312204437172097024/AEjW7Yds_normal.jpg |
https://pbs.twimg.com/profile_banners/1067218780806307841/1601688894 |
1DA1F2 |
333333 |
1 |
0 |
1 |
0 |
1 |
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);
