users

10 rows where geo_enabled = 0 and profile_background_image_url_https = "https://abs.twimg.com/images/themes/theme14/bg.gif"

Search:

descending

id ▼	screen_name	name	description	location	url	followers_count	friends_count	listed_count	created_at	favourites_count	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	following	translator_type
70269979	mendozamartha	Martha Mendoza	I'm a Pulitzer prize-winning Associated Press National Writer writing breaking news, enterprise and investigative reporting from Silicon Valley.	NorCal	http://www.ap.org	6465	406	289	2009-08-31T01:27:28+00:00	620	1	2144	131516	http://abs.twimg.com/images/themes/theme14/bg.gif	https://abs.twimg.com/images/themes/theme14/bg.gif	1	http://pbs.twimg.com/profile_images/3118150304/31c8df33074e95031aac1d6c25a59992_normal.jpeg	https://pbs.twimg.com/profile_images/3118150304/31c8df33074e95031aac1d6c25a59992_normal.jpeg	https://pbs.twimg.com/profile_banners/70269979/1358374412	009999	EEEEEE	EFEFEF	333333	1	0	none
103661473	voicebox_media	VoiceBox Media	VoiceBox is an eclectic public radio and podcast series about the voice. Tune in on Fridays at 10PM on 91.7 FM KALW. Listen live at http://www.kalw.org/	San Francisco	http://voicebox-media.org	151	105	12	2010-01-10T20:42:36+00:00	0	0	159	131516	http://abs.twimg.com/images/themes/theme14/bg.gif	https://abs.twimg.com/images/themes/theme14/bg.gif	1	http://pbs.twimg.com/profile_images/3521682516/ba39c7a4e0c50f47fc12a235f1661abf_normal.png	https://pbs.twimg.com/profile_images/3521682516/ba39c7a4e0c50f47fc12a235f1661abf_normal.png	https://pbs.twimg.com/profile_banners/103661473/1365967664	009999	EEEEEE	EFEFEF	333333	1	0	none
107483740	lighthausinc	Lighthaus	Makers of Color Space + science and healthcare VR education. Supported by U.S. Dept of Education, National Institutes of Health. A new reality for education.	California	http://lighthaus.us	524	257	21	2010-01-22T18:21:08+00:00	377	0	159	131516	http://abs.twimg.com/images/themes/theme14/bg.gif	https://abs.twimg.com/images/themes/theme14/bg.gif	0	http://pbs.twimg.com/profile_images/449636095433506816/gcw5NAxS_normal.jpeg	https://pbs.twimg.com/profile_images/449636095433506816/gcw5NAxS_normal.jpeg	https://pbs.twimg.com/profile_banners/107483740/1396036513	009999	FFFFFF	EFEFEF	333333	0	0	none
263852695	StanfordVR	Stanford VR	VHIL researches virtual social interaction, builds and tests applications which use VR to improve society. New book, Experience on Demand, now available.		http://www.experienceondemandbook.com/	13968	1699	633	2011-03-10T21:34:36+00:00	2693	0	5943	131516	http://abs.twimg.com/images/themes/theme14/bg.gif	https://abs.twimg.com/images/themes/theme14/bg.gif	1	http://pbs.twimg.com/profile_images/670339668169195520/5pGDWyMo_normal.jpg	https://pbs.twimg.com/profile_images/670339668169195520/5pGDWyMo_normal.jpg		009999	EEEEEE	EFEFEF	333333	1	0	none
1735721420	StanfordJourn	Stanford Journalism	Updates from @Stanford University's Journalism Program and Stanford Computational Journalism Lab, where we focus on multimedia storytelling and data journalism.	Stanford, CA	http://journalism.stanford.edu	6397	2579	283	2013-09-06T17:12:02+00:00	888	0	2909	8C1515	http://abs.twimg.com/images/themes/theme14/bg.gif	https://abs.twimg.com/images/themes/theme14/bg.gif	0	http://pbs.twimg.com/profile_images/876910043303600129/_9l65lJU_normal.jpg	https://pbs.twimg.com/profile_images/876910043303600129/_9l65lJU_normal.jpg	https://pbs.twimg.com/profile_banners/1735721420/1467306513	8C1515	000000	DDEEF6	333333	1	1	none
2149361988	Catanify	Sara Catania	Now: Solutions Journalism Network + USC Annenberg • Always: JSK Stanford 🍝 Catania rhymes with lasagna Headshot by Richa Syal		http://www.saracatania.com	1859	904	131	2013-10-22T16:47:07+00:00	6962	0	7924	131516	http://abs.twimg.com/images/themes/theme14/bg.gif	https://abs.twimg.com/images/themes/theme14/bg.gif	1	http://pbs.twimg.com/profile_images/1219705093634703360/4LQlgy_p_normal.jpg	https://pbs.twimg.com/profile_images/1219705093634703360/4LQlgy_p_normal.jpg	https://pbs.twimg.com/profile_banners/2149361988/1579635331	997800	FFFFFF	EFEFEF	333333	1	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);