tweets

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

5 rows where "created_at" is on date 2021-07-27 and is_quote_status = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, display_text_range, retweet_count, retweeted, 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
1419836176681213952 swyx 33521530 2021-07-27T01:44:58+00:00 Suddenly reminded of this @bcantrill talk: https://youtu.be/30jNsCVLpAE and I think I have my answer - If it takes you 2 days to chase down an intermittent bug, perhaps that *IS* the bug. Even though this talk is 4 years old but feels like @mipsytipsy is beating the same drum today. https://twitter.com/swyx/status/1419434119319093250   1419434119319093250 1419434119319093250   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 3 15 0 0 0 en  
1420050980310183936 swyx 33521530 2021-07-27T15:58:31+00:00 This is an incredible video: https://twitter.com/discord/status/1418617539404308482?s=20 Writeup: https://blog.discord.com/meet-the-discord-users-who-imagined-a-place-657325b75fa6 It's a quirky amalgam of Discord memes with Awkwafina, Danny Devito, Grimes, MKBHD, flying flaming cows, and eggs. Totally ineffective at explaining what Discord is, but captures how it FEELS.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1378408503597965316 33521530 swyx       1 1 8 0 0 0 en  
1420086929261961217 swyx 33521530 2021-07-27T18:21:22+00:00 Feeling this again. Really humbling to interview people (eg early Google and Docker) and understanding how great problems attract great talent. https://twitter.com/swyx/status/1189555830544355330   1189555830544355330 1189555830544355330   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 143]             1 0 26 0 0 0 en  
1420135785987117060 Cindy Sridharan 161667651 2021-07-27T21:35:30+00:00 Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even if the second edition just had minor typo fixes, I’d buy it and read it all over again! https://twitter.com/JohnOusterhout/status/1420053240717086721   1420053240717086721 1420053240717086721   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 207]             1 6 86 0 1 0 en  
1420136685472342016 swyx 33521530 2021-07-27T21:39:05+00:00 RT @copyconstruct: Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even… 1420135785987117060 1420135785987117060     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             1 6 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]);