tweets

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

5 rows where "created_at" is on date 2021-10-23 and is_quote_status = 1 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: quoted_status, retweet_count

favorite_count 4 ✖

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-10-23 · 5 ✖
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
1452039247347605504 swyx 33521530 2021-10-23T22:28:28+00:00 @ZTHall @kyleshevlin my answer last time this came up https://twitter.com/swyx/status/1420211877276049408   1420211877276049408 1420211877276049408   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 53] 1452013758923038726 52961768 ZTHall       1 0 1 0 0 0 en  
1452039280222617602 swyx 33521530 2021-10-23T22:28:36+00:00 @sarocodes @kyleshevlin here you go https://twitter.com/swyx/status/1420211877276049408   1420211877276049408 1420211877276049408   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 35] 1452011456019542023 1142496292028985350 sarocodes       1 0 1 0 0 0 en  
1452039338619899913 swyx 33521530 2021-10-23T22:28:50+00:00 @ChopFitzroy @kyleshevlin here https://twitter.com/swyx/status/1420211877276049408   1420211877276049408 1420211877276049408   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 30] 1452034379446816768 955233524587483136 ChopFitzroy       1 0 15 0 0 0 en  
1452040257805819910 swyx 33521530 2021-10-23T22:32:29+00:00 @kyleshevlin @matiasfha what if i told you you can 100% replicate this svelte syntax in react to prove how not different it is https://twitter.com/swyx/status/1294310598419689472?s=21   1294310598419689472 1294310598419689472   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 151] 1452039656887885836 85008547 kyleshevlin       1 0 2 0 0 0 en  
1452046180683161609 swyx 33521530 2021-10-23T22:56:01+00:00 it worries me that there’s an uncritical acceptance of @Reactjs conclusions without examining if those assumptions apply to you. React is verbose React is successful Must be verbose to be successful Here’s my attempt to articulate more timeless lessons than “2 way binding bad”: https://twitter.com/swyx/status/1383516418205835264   1383516418205835264 1383516418205835264   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 2 49 0 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]);