twitter: tweets: 1 row where retweeted = 0 and user = 769920 sorted by lang

This is data scraped from swyx's timeline! See blog post

1 row where retweeted = 0 and user = 769920 sorted by lang

Search:

descending

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
1452445875159044098	Lívia Labate 769920	2021-10-25T01:24:16+00:00	A screw it, let's do it: TL,DR: AMP format doesn't support JavaScript in the way you can use it on regular web pages. This prevents publishers from using header bidding with AMP (limits how many ad exchanges one can connect to @ a time, making it less desirable/useful; see doc)				Twitter for Android f0976f342215a984184a13a54b26877ece8cebba	0	[0, 280]	1452430810880122885	769920	livlab				0	48	251	0	0		en

Advanced export

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

CREATE TABLE [tweets] (
   [id] INTEGER PRIMARY KEY,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [full_text] TEXT,
   [retweeted_status] INTEGER,
   [quoted_status] INTEGER,
   [place] TEXT REFERENCES [places]([id]),
   [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT,
   FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]),
   FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id])
);
CREATE INDEX [idx_tweets_source]
    ON [tweets] ([source]);