tweets

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

11 rows where "created_at" is on date 2021-09-27, favorited = 0 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at, source, favorite_count

retweet_count 4 ✖

is_quote_status 2 ✖

user 1 ✖

retweeted 1 ✖

created_at (date) 1 ✖

  • 2021-09-27 · 11 ✖
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
1442310363681378312 swyx 33521530 2021-09-27T02:09:22+00:00 🔥 Just pushed my new @Revue newsletter! “[http://swyx.io] YouTube Podcasting - good idea, or bad idea?” https://www.getrevue.co/profile/swyx/archive/317891       Revue e01d36c55a12ec4cf389049ec42665dce335b54e 0 [0, 137]             0 0 12 0 0 0 en  
1442511237036720132 swyx 33521530 2021-09-27T15:27:34+00:00 @PKodmad @github yay congrats!!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 32] 1442396149860618242 1245747631 PKodmad       0 0 1 0 0   en  
1442513417248460806 swyx 33521530 2021-09-27T15:36:13+00:00 @andrewkrisyudha hey! yeah i need to figure out the magic incantations to put into Route53 with @ryan. thanks for the push.. it has been like this for a while because life got busy but i really should tackle this better       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 219] 1442507319057604612 1422210868666769409 andrewkrisyudha       0 0 1 0 0   en  
1442528022385479682 swyx 33521530 2021-09-27T16:34:16+00:00 God bless people who leave this kind of @GitHub comment, you know who you are https://twitter.com/swyx/status/1442528022385479682/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 77]             0 17 477 0 0 0 en  
1442580647759912960 swyx 33521530 2021-09-27T20:03:22+00:00 @derrickreimer only a bad idea if i'm not in it!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 48] 1442577237241327617 28679508 derrickreimer       0 0 3 0 0   en  
1442580918326026240 swyx 33521530 2021-09-27T20:04:27+00:00 Dear lazy Twitter, anyone have a good "Take this Slack chat and open an issue in GitHub" workflow/plugin/app to recommend? need to try new ways of tracking bc am dropping stuff       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 178]             0 1 25 0 0   en  
1442581670796804097 swyx 33521530 2021-09-27T20:07:26+00:00 @ellenchisa @marissamary well that was perfect + fast! ty and proposing internally 🙏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 84] 1442581180742881282 14620776 ellenchisa       0 0 4 0 0   en  
1442584581476020231 swyx 33521530 2021-09-27T20:19:00+00:00 @marissamary @ellenchisa yes ty! i dont want to get your hopes up, someone just suggested this in an internal meeting so am doing due diligence       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 143] 1442582236860084231 34507197 marissamary       0 0 2 0 0   en  
1442589511142166533 swyx 33521530 2021-09-27T20:38:36+00:00 @preritayadav welcome and excited to chat with you over the next 4 weeks!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 74] 1442587377709379584 159511130 preritayadav       0 0 1 0 0   en  
1442610193846603777 swyx 33521530 2021-09-27T22:00:47+00:00 "Let user group by business logic instead of force them to fit to your lifecycle method" is still the single most important lesson in API design I've ever learned. Used this exact diagram today in the design of @temporalio's JS SDK and so happy with the result. https://twitter.com/threepointone/status/1056594421079261185   1056594421079261185 1056594421079261185   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 262]             1 6 77 0 0 0 en  
1442610195339776004 swyx 33521530 2021-09-27T22:00:47+00:00 If the only thing you learned from React is React, look harder: https://twitter.com/swyx/status/1383516418205835264?lang=en   1383516418205835264 1383516418205835264   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 88] 1442610193846603777 33521530 swyx       1 0 16 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]);