users

6 rows where profile_background_image_url_https = "https://abs.twimg.com/images/themes/theme2/bg.gif" and verified = 1

Search:

descending

id ▼	screen_name	name	description	location	url	followers_count	friends_count	listed_count	created_at	favourites_count	geo_enabled	verified	statuses_count	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_sidebar_border_color	profile_sidebar_fill_color	profile_text_color	profile_use_background_image	has_extended_profile	following	translator_type
6181532	morisy	Michael Morisy	Founder and chief executive @MuckRock, helping run @FOIAMachine @DocumentCloud QuackBot @oTranscribe. Board @NFOIC @asapACCESSPRO @CornellSun. He/him.	Undisclosed Bunker, Cambridge	https://www.muckrock.com	9862	9331	519	2007-05-20T16:43:11+00:00	30037	1	1	2457	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/798990090336866304/yh-_aB1C_normal.jpg	https://pbs.twimg.com/profile_images/798990090336866304/yh-_aB1C_normal.jpg	https://pbs.twimg.com/profile_banners/6181532/1424567511	0B23BD	C6E2EE	DAECF4	663B12	1	1	1	none
19727405	Lindenberger	Michael Lindenberger	Deputy Opinion Editor at Houston Chronicle \| Ex: DC correspondent & edit board @dallasnews \| ‘13 @jskstanford \| @LouisvilleLaw grad \| @Time @TNR	Dallas, TX	http://about.me/lindenberger	2410	1606	162	2009-01-29T19:11:06+00:00	3946	1	1	10702	07090B	http://abs.twimg.com/images/themes/theme2/bg.gif	https://abs.twimg.com/images/themes/theme2/bg.gif	1	http://pbs.twimg.com/profile_images/1061098108463927296/0w39uGLf_normal.jpg	https://pbs.twimg.com/profile_images/1061098108463927296/0w39uGLf_normal.jpg	https://pbs.twimg.com/profile_banners/19727405/1556727867	B50E0E	BFBFBF	C9C9C9	1C1F23	1	0	0	none
32129142	carolrosenberg	Carol Rosenberg	Covers Guantánamo, the place, policy, people and war court for The New York Times with the generous support of the Pulitzer Center.	USA	https://www.nytimes.com/by/carol-rosenberg	35166	1078	1116	2009-04-16T19:52:21+00:00	2247	1	1	41926	FF5100	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/378800000244795560/926eb013495c2e5f16b416ad168307e4_normal.jpeg	https://pbs.twimg.com/profile_images/378800000244795560/926eb013495c2e5f16b416ad168307e4_normal.jpeg	https://pbs.twimg.com/profile_banners/32129142/1483651367	FF5100	FF5100	B5B9BF	171717	1	0	0	none
34687443	kristianiaclark	krissy clark	Host/co-creator: The Uncertain Hour podcast @Marketplace Stories: @reveal @99piorg @PopUpMag @slate Past @JSKstanford fellow 🌖ing at http://storieseverywherere.org	los angeles	https://itunes.apple.com/us/podcast/the-uncertain-hour/id1091031079?mt=2	3758	2147	190	2009-04-23T18:28:03+00:00	791	1	1	1554	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/2116171461/image_normal.jpg	https://pbs.twimg.com/profile_images/2116171461/image_normal.jpg	https://pbs.twimg.com/profile_banners/34687443/1416800787	FF691F	000000	000000	000000	0	0	0	none
264340567	txtianmiller	T. Christian Miller	Senior investigative reporter @Propublica. Co-author of http://afalsereport.com. Into journalism that counts. And bacon. Pulitzer winner.	Berkeley, CA	http://www.propublica.org	8847	2015	329	2011-03-11T19:00:34+00:00	4504	1	1	6049	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/545792431778590720/bdEY0hf7_normal.jpeg	https://pbs.twimg.com/profile_images/545792431778590720/bdEY0hf7_normal.jpeg	https://pbs.twimg.com/profile_banners/264340567/1573861549	19CF86	000000	000000	000000	0	0	0	none
1548898596	Ericnpr	Eric Westervelt	@NPR journalist. Recovering foreign correspondent. Occasional host. Musician by moonlight http://SecureDrop.npr.org/ http://SeeDisclaimer.com	San Francisco, CA	https://www.npr.org/people/2101350/eric-westervelt	4897	2014	210	2013-06-26T19:27:15+00:00	680	0	1	2353	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/617350595511324672/WKSuKLYH_normal.jpg	https://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg	https://pbs.twimg.com/profile_banners/1548898596/1406506418	3B94D9	000000	000000	000000	0	0	0	none

Advanced export

JSON shape: default, array, newline-delimited, object

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);