tweets

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

10 rows where "created_at" is on date 2021-07-27 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, retweet_count, favorite_count, retweeted

source 1 ✖

  • Twitter Web App · 10 ✖

created_at (date) 1 ✖

  • 2021-07-27 · 10 ✖
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
1419880024929415173 Loren 🤓 215488966 2021-07-27T04:39:12+00:00 Is it just me or can the 2nd edition of Designing Data-Intensive Applications be: "Just use @apollographql Federation for reads and @temporalio for writes" 😄 1/4 https://twitter.com/lorendsr/status/1419880024929415173/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 163]             0 9 34 0 1 0 en  
1420043000344768517 Supabase 1219566488325017602 2021-07-27T15:26:49+00:00 #supalaunchweek Day 2: 🔥 Supabase Storage is now in Beta 🔥 https://supabase.io/blog/2021/07/27/storage-beta - Streaming Media - Public Buckets - NodeJS support - Storage supported in Local Emulator - Upload folders - Updated Policy editor - Performance improvements to handle recursive cat uploads 😹       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 32 204 0 1 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  
1420051311244894220 swyx 33521530 2021-07-27T15:59:50+00:00 @willjohnsonio record yourself on a podcast every day :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 56] 1420043153516765193 917069583097397248 willjohnsonio       0 0 1 0 0   en  
1420053240717086721 John Ousterhout 2730347034 2021-07-27T16:07:30+00:00 I'm excited to announced that I've just released the 2nd Edition of "A Philosophy of Software Design". See https://web.stanford.edu/~ouster/cgi-bin/book.php for more info (including free download of new chapters).       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 187]             0 179 670 0 0 0 en  
1420055275847839746 swyx 33521530 2021-07-27T16:15:35+00:00 RT @lorendsr: Is it just me or can the 2nd edition of Designing Data-Intensive Applications be: "Just use @apollographql Federation for re… 1419880024929415173 1419880024929415173     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 9 0 0 1   en  
1420085405349662721 Dominik Tornow 1125559272232837121 2021-07-27T18:15:19+00:00 @temporalio is all about scalability and reliability while guaranteeing functional correctness. There is a lot to unpack here! 🧵       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 130]   1204202807298969600 temporalio       0 7 22 0 1   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  
1420104010313265152 swyx 33521530 2021-07-27T19:29:14+00:00 @DavidAMaier @temporalio haha thanks! urgently? what do you mean? happy to chat offline but also could be useful for others if you elaborated       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 141] 1420102177310314504 1200337361734946817 DavidAMaier       0 0 1 0 0   en  
1420141917812060163 swyx 33521530 2021-07-27T21:59:52+00:00 @zpao easy to have a huge ecosystem when everyone has their own definition of what you mean!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 92] 1420138159405367299 764166 zpao       0 0 1 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]);