tweets

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

3 rows where "created_at" is on date 2021-09-11 and favorite_count = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, created_at (date)

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
1436704692868993034 swyx 33521530 2021-09-11T14:54:26+00:00 @therealboone progress is progress! what were the remaining things you couldn't take out?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 89] 1436703800442634244 35840006 therealboone       0 0 3 0 0   en  
1436718275585523730 swyx 33521530 2021-09-11T15:48:24+00:00 @slightlylate the reason i suggested templatizing, is your longform commentary on why X is bad and what could be done better is very valuable. webpagetest speaks to perf experts, but the rest of us have no idea what to do with all the info. maybe inject some humor to make it more appealing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 291] 1436716663013928961 229237555 slightlylate       0 0 3 0 0   en  
1436727623607066632 swyx 33521530 2021-09-11T16:25:33+00:00 @DasSurma oh for sure - my intent was to educate those who may be running local lighthouse on the current, post migration site, and seeing green and wondering whats the big fuss. i feel Chrome shouldnt even allow local lighthouse runs without this basic user education/warning       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 276] 1436724515040636932 15180856 DasSurma       0 0 3 0 0   en  

Advanced export

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

CSV options: 

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