tweets

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

16 rows where "created_at" is on date 2021-12-07, is_quote_status = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorited, retweeted, lang

favorite_count 9 ✖

source 1 ✖

  • Twitter for iPhone · 16 ✖

created_at (date) 1 ✖

  • 2021-12-07 · 16 ✖
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
1468185206628642816 swyx 33521530 2021-12-07T11:46:45+00:00 @peer_rich https://airbyte.io/connectors/google-analytics cc @AVaidyanatha gotchu fam       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 62] 1468182970750185477 1004742187 peer_rich       0 0 6 0 0 0 cy  
1468106726163447809 swyx 33521530 2021-12-07T06:34:54+00:00 and then there’s a whole nother tier to this game practiced by the elite - short (33char) titles with specific numbers and “You” - incomplete thumbnail - sound pings - story: relatable situation -> clash/misunderstanding-> new chars enter -> punchline https://youtu.be/c5-3gotpgz8       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 287] 1462659131815477252 33521530 swyx       0 0 8 0 0 0 en  
1468154498761650177 swyx 33521530 2021-12-07T09:44:44+00:00 @jakobgreenfeld got a chart for this but for product hunt?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 58] 1468143869426606081 1285142519525892098 jakobgreenfeld       0 0 1 0 0   en  
1468157229664591875 swyx 33521530 2021-12-07T09:55:35+00:00 @nextjs thank god how long did it take you to get this handle lmao from now on only OG nextjs users remember searching for nextjs twitter handle and coming up blank and dejectedly settling for #nextjs       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 202] 1468044361082580995 1467726470533754880 nextjs       0 0 73 0 0   en  
1468163148809048069 swyx 33521530 2021-12-07T10:19:06+00:00 @naz_avo @jakobgreenfeld evidently not true going by gumroad gmv probably more like ppl have caught on that shipping > talking https://twitter.com/swyx/status/1468163148809048069/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 130] 1468162122387447811 1335444805241896961 naz_avo       0 0 5 0 0 0 en  
1468179322296942592 swyx 33521530 2021-12-07T11:23:22+00:00 @tmcw @reactjs could be topic for a good blogpost! havent messed around with it yet either. intrigued by the screenshots       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 120] 1467888510967459847 1458271 tmcw       0 0 1 0 0   en  
1468181148971024384 swyx 33521530 2021-12-07T11:30:38+00:00 @dqmonn @peer_rich @CalcoM does business trademark + ad spend not help?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 71] 1468179795129376769 3097332387 dqmonn       0 0 0 0 0   en  
1468183578357874690 swyx 33521530 2021-12-07T11:40:17+00:00 @terribledustin @MarvelAssist @Polymail @typeform @stripe @Google @vercel first time hearing about it: - can you share some example posts on the landing page? - can you pin a “marvelassist tldr” tweet to the @MarvelAssist page? right now the bio is just marketing fluff, doesnt explain what you actually do (unsolicited so feel free to ignore)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [74, 345] 1467920938368966659 832314788487196672 terribledustin       0 0 2 0 0   en  
1468282142048206851 swyx 33521530 2021-12-07T18:11:56+00:00 RT @jhooks: these 20 awesome courses are free for the month https://egghead.io/20-days 1467892371480186886 1467892371480186886     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 83]             0 66 0 1 1 0 en  
1468290789683851264 swyx 33521530 2021-12-07T18:46:18+00:00 @abadir_ @harisvsulaiman @temporalio i dont know agendajs well but yeah what he said       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [37, 84] 1468257419956469768 14335431 abadir_       0 0 2 0 0   en  
1468340554534567941 swyx 33521530 2021-12-07T22:04:03+00:00 @jeffbcross love it! will take you up on that someday. in the meantime.. kudos for shaping the company you wanted!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 114] 1468112478630342656 16616694 jeffbcross       0 0 2 0 0   en  
1468340794067021828 swyx 33521530 2021-12-07T22:05:00+00:00 @JoshuaOgundu your sweater has arm sleeves, this totally breaks immersion       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 73] 1468339675660099584 1599986989 JoshuaOgundu       0 0 4 0 0   en  
1468118101598162946 swyx 33521530 2021-12-07T07:20:06+00:00 @dhaiwat10 🔥       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 12] 1468105564848672771 1025757442594889734 dhaiwat10       0 0 0 0 0   und  
1468156519808131075 swyx 33521530 2021-12-07T09:52:46+00:00 @jakobgreenfeld ☠️       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 18] 1468155042813419520 1285142519525892098 jakobgreenfeld       0 0 1 0 0   und  
1468157512490700804 swyx 33521530 2021-12-07T09:56:42+00:00 @cherthedev 👋 https://jobs.lever.co/temporal/19d191e0-69bb-4d06-933d-deecb51176a8       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 37] 1468057406601003010 15790639 cherthedev       0 0 0 0 0 0 und  
1468188704120336385 swyx 33521530 2021-12-07T12:00:39+00:00 @THyasser1 https://twitter.com/swyx/status/1468188704120336385/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 10] 1468188083246047234 876463068653510656 THyasser1       0 0 3 0 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]);