tweets

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

10 rows where "created_at" is on date 2021-12-05 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, retweeted, lang

favorite_count 6 ✖

source 1 ✖

  • Twitter for iPhone · 10 ✖

created_at (date) 1 ✖

  • 2021-12-05 · 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
1467291914571374596 swyx 33521530 2021-12-05T00:37:08+00:00 @ken_wheeler wow thats brutal honesty only a brother can give lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 65] 1467291204249432069 167193309 ken_wheeler       0 0 2 0 0   en  
1467347814686416898 swyx 33521530 2021-12-05T04:19:15+00:00 RT @acemarke: I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thor… 1467343720936792071 1467343720936792071     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 5 0 1 1   en  
1467348146866982914 swyx 33521530 2021-12-05T04:20:34+00:00 @acemarke thanks for the very kind words Mark!! let’s do a chat sometime when you have a meta rant to mouthblog!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 112] 1467343720936792071 727704217012604928 acemarke       0 0 3 0 0   en  
1467454039935762432 swyx 33521530 2021-12-05T11:21:21+00:00 @ManuSchiller @acemarke the audio version is released as any podcast should: https://twitter.com/swyx/status/1467306058540470275?s=21 spotify can have it as and when they feel like recognizing that podcasting is an open format and not something to fuck over with proprietary bs   1467306058540470275 1467306058540470275   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 245] 1467452858454978560 1001727178151792640 ManuSchiller       1 0 1 0 0 0 en  
1467496371821465602 Sarah Dayan 937000244650192897 2021-12-05T14:09:34+00:00 @swyx My wife is studying psychology and currently works on confidence. Some interesting points she shared (simplified and filtered by my own perception, not her exact words): Acting under or overconfident are both signs of a lack of confidence. They’re both defense mechanisms.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 279] 1467249786604584961 33521530 swyx       0 0 23 0 0   en  
1467597994870521856 swyx 33521530 2021-12-05T20:53:23+00:00 @rblalock thanks Rick! very kind of you!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 40] 1467474088058892294 9083902 rblalock       0 0 1 0 0   en  
1467598568600989696 swyx 33521530 2021-12-05T20:55:40+00:00 Wonderful notes from the psychology of confidence: https://twitter.com/frontstuff_io/status/1467496371821465602   1467496371821465602 1467496371821465602   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 50] 1467294016995688449 33521530 swyx       1 0 8 0 0 0 en  
1467598761673117699 swyx 33521530 2021-12-05T20:56:26+00:00 @benediktms doubt it bc i try not to run docker locally since i adopted @gitpod       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 79] 1467512180597837825 390272424 benediktms       0 0 0 0 0   en  
1467598860801302534 swyx 33521530 2021-12-05T20:56:49+00:00 @tsnmp @argyleink thanks Jonas! very kind!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 42] 1467532393250701328 46692667 tsnmp       0 0 1 0 0   en  
1467417453815013377 swyx 33521530 2021-12-05T08:55:58+00:00 @BrittneyPostma @SvelteSirens 🔥 🔥🔥🔥       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [30, 35] 1467136805560631297 36686876 BrittneyPostma       0 0 3 0 0   und  

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]);