tweets

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

8 rows where "created_at" is on date 2021-12-13 and possibly_sensitive = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, retweet_count, favorited, 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
1470313547858993152 swyx 33521530 2021-12-13T08:44:01+00:00 @sarah_edo @brad_frost Immediately reminded me of this https://www.youtube.com/watch?v=abn6cPxrc5w       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 78] 1470300256944340995 813333008 sarah_edo       0 0 3 0 0 0 en  
1470330844896059394 Dan Luu 18275645 2021-12-13T09:52:45+00:00 How I think about writing https://danluu.com/writing-non-advice/ https://twitter.com/danluu/status/1470330844896059394/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 50]             0 39 259 1 1 0 en  
1470335838349238272 swyx 33521530 2021-12-13T10:12:36+00:00 RT @danluu: How I think about writing https://danluu.com/writing-non-advice/ https://twitter.com/danluu/status/1470330844896059394/photo/1 1470330844896059394 1470330844896059394     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 86]             0 39 0 1 1 0 en  
1470366530936483841 Intercontinental Breakfast Missile 41402543 2021-12-13T12:14:33+00:00 Still thinking about this bird's nest made out of anti-bird spikes https://twitter.com/potatojunkie/status/1470366530936483841/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 66]             0 2365 16602 0 0 0 en  
1470483442303393793 swyx 33521530 2021-12-13T19:59:07+00:00 @bradgarropy @Netlify @vercel nice! fwiw Netlify's serverless function signature is exactly what AWS Lambda has, up to you on what "non-standard" means :) https://docs.aws.amazon.com/lambda/latest/dg/nodejs-handler.html       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 178] 1470477575990435849 271545570 bradgarropy       0 0 4 0 0 0 en  
1470487534132154378 Jason Laster 312750384 2021-12-13T20:15:23+00:00 This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It doesn't matter if you're technically support, success, product, qa, leadership, or dev, if you care about quality, we want to talk to you! 🐛👋       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 260]             0 2 4 1 1 0 en  
1470487931332792324 swyx 33521530 2021-12-13T20:16:57+00:00 RT @jasonlaster11: This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It d… 1470487534132154378 1470487534132154378     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1 0 en  
1470489155725578262 Arthur Wu 🍊 2477624389 2021-12-13T20:21:49+00:00 What makes Gmail performant is different than what makes Instagram performant. In "Application Holotypes", @_developit made a starting taxonomy of web app types and good architecture traits for each one. Many cite it as an impt read, and I've made it more visual 🧵: https://twitter.com/arthurwuhoo/status/1470489155725578262/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 269]             0 15 69 1 1 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]);