jsk

Custom SQL query returning 2 rows (hide)

select 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_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, has_extended_profile, default_profile, default_profile_image, following, follow_request_sent, notifications, translator_type from users where date("created_at") = :p0 and "profile_background_image_url_https" = :p1 order by id limit 101

Query parameters

This data as json, CSV

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_sidebar_border_color	profile_sidebar_fill_color	profile_text_color	profile_use_background_image	has_extended_profile	default_profile	default_profile_image	following	follow_request_sent	notifications	translator_type
106430958	Aaron_Glantz	Aaron Glantz	Senior Reporter @Reveal, Pulitzer Finalist, Author, HOMEWRECKERS from HarperCollins, Peabody & duPont Award-winning journalist, 2016 JSK Fellow at Stanford	San Francisco, CA	http://www.aglantz.com/	0	7366	2169	260	2010-01-19T14:53:25+00:00	1983			0	1	11383		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/1130878485705109504/hAHCW38J_normal.png	https://pbs.twimg.com/profile_images/1130878485705109504/hAHCW38J_normal.png	https://pbs.twimg.com/profile_banners/106430958/1562784141	DD2E44	000000	000000	000000	0	0	0	0	0	0	0	none
106475977	KristaAlmanzan	Krista Almanzan	Senior Journalism Fellow @JSKStanford experimenting with audio in local news	Palo Alto, CA		0	323	1422	9	2010-01-19T17:48:49+00:00	1248			0	0	209		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/1115369630913011712/ff0KW5l8_normal.png	https://pbs.twimg.com/profile_images/1115369630913011712/ff0KW5l8_normal.png	https://pbs.twimg.com/profile_banners/106475977/1554760966	19CF86	000000	000000	000000	0	0	0	0	1	0	0	none