twitter

Data source: swyx's twitter data

Custom SQL query returning 1 row (hide)

select id, user, created_at, full_text, retweeted_status, quoted_status, place, source, truncated, display_text_range, in_reply_to_status_id, in_reply_to_user_id, in_reply_to_screen_name, geo, coordinates, contributors, is_quote_status, retweet_count, favorite_count, favorited, retweeted, possibly_sensitive, lang, scopes from tweets where date("created_at") = :p0 and "is_quote_status" = :p1 and "retweeted" = :p2 and "source" = :p3 and "user" = :p4 order by lang limit 101

Query parameters

This data as json, CSV

id	user	created_at	full_text	retweeted_status	quoted_status	place	source	truncated	display_text_range	in_reply_to_status_id	in_reply_to_user_id	in_reply_to_screen_name	geo	coordinates	contributors	is_quote_status	retweet_count	favorite_count	favorited	retweeted	possibly_sensitive	lang	scopes
1441866360313634823	2048741	2021-09-25T20:45:03+00:00	How to pick a North Star Metric? Start with the chemical(s) your product deals with & consider the associated metric: Oxytocin - Brand metric Cortisol - Revenue metric Dopamine - Usage Frequency metric Adrenaline - Session Duration metric Endorphins - Freemium Conversion metric				1f89d6a41b1505a3071169f8d0d028ba9ad6f952	0	[0, 284]							0	219	1389	0	0		en