tweets

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

4 rows where favorited = 0 and retweet_count = 14 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, favorite_count

created_at (date) 3 ✖

user 2 ✖

retweeted 2 ✖

retweet_count 1 ✖

lang 1 ✖

is_quote_status 1 ✖

  • 0 4

quoted_status 0 ✖

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
1284597930398105600 swyx 33521530 2020-07-18T21:16:27+00:00 The primary beneficiary of you being #1 on Product Hunt is Product Hunt. The primary beneficiary of you being Employee of the Month is your Employer. The primary beneficiary of you going viral on Twitter is Twitter. Youre surprised *everything* around you is designed this way?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1284596781779767297 33521530 swyx       0 14 136 0 0   en  
1430880791316373512 Forrest Brazeal 3239330680 2021-08-26T13:12:19+00:00 The Cloud Resume Challenge Book has officially LAUNCHED! 🚀First 100 sales are 15% off with this link - move fast. https://forrestbrazeal.gumroad.com/l/cloud-resume-challenge-book/launch-deal But I haven't even told you the best part yet. Here is Cool Announcement #2 of the week:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 227]             0 14 93 0 1 0 en  
1430939976254988288 swyx 33521530 2021-08-26T17:07:30+00:00 RT @forrestbrazeal: The Cloud Resume Challenge Book has officially LAUNCHED! 🚀First 100 sales are 15% off with this link - move fast. https… 1430880791316373512 1430880791316373512     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 14 0 0 1   en  
1453489774073765888 swyx 33521530 2021-10-27T22:32:21+00:00 RT @swyx: The primary beneficiary of you being #1 on Product Hunt is Product Hunt. The primary beneficiary of you being Employee of the Mo… 1284597930398105600 1284597930398105600     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 14 0 0 1   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]);