tweets

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

16 rows where "created_at" is on date 2021-08-14 and retweeted = 0 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, is_quote_status, favorite_count

retweet_count 2 ✖

user 1 ✖

retweeted 1 ✖

quoted_status 1 ✖

created_at (date) 1 ✖

  • 2021-08-14 · 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
1426398256494366724 swyx 33521530 2021-08-14T04:20:20+00:00 @cunrakes @FinJoTheGreat @cherthedev @eerac solution to problem shouldnt exist because problem shouldnt exist       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [44, 109] 1426318578282909696 50191852 cunrakes       0 0 1 0 0   en  
1426404062916878338 swyx 33521530 2021-08-14T04:43:24+00:00 @remix_run woww some movement again! congrats team!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 51] 1426293872972361735 1250847387062419456 remix_run       0 0 8 0 0   en  
1426410836784861187 swyx 33521530 2021-08-14T05:10:19+00:00 @anothercohen doing this with devtools if anyone else browsing this is a developer https://twitter.com/swyx/status/1357105644810063873   1357105644810063873 1357105644810063873   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 82] 1426397577218457602 557440724 anothercohen       1 0 2 0 0 0 en  
1426600767465529346 swyx 33521530 2021-08-14T17:45:02+00:00 @tweeshan we will start work on it once we can hire someone to work on it :) any referrals appreciated https://jobs.lever.co/temporal/635c41e4-583f-4598-9da5-24cf14b69751       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 126] 1426490612774170624 37069005 tweeshan       0 0 1 0 0 0 en  
1426628337137459200 swyx 33521530 2021-08-14T19:34:35+00:00 @earthlingworks white guy gets opportunity he is completely unqualified for and gains acceptance anyway with hokey aphorisms and faith in humanity. i enjoy it but totally get that escapist fantasy is a reason for its popularity.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 228] 1426379951830224900 15554773 earthlingworks       0 0 4 0 0   en  
1426638568714227712 swyx 33521530 2021-08-14T20:15:15+00:00 i was wondering how long until i saw my meme in the wild. https://twitter.com/sparkleops/status/1426401808814018563?s=21 10 days. it took 10 days       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 108] 1423025792783568899 33521530 swyx       1 0 17 0 0 0 en  
1426641493784096770 swyx 33521530 2021-08-14T20:26:52+00:00 @theshteves only if it gets more and more deep fried each time preferably with people taking photos of their screens with phone camera and bad lighting       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 151] 1426641076086087682 805074422 theshteves       0 0 1 0 0   en  
1426652916534845441 swyx 33521530 2021-08-14T21:12:15+00:00 @rishmishra ok i will have to give it another go again. first few episodes i got confused with all the locations and names and never really got invested in the story       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 165] 1426636171665461249 331639736 rishmishra       0 0 6 0 0   en  
1426653705567277060 swyx 33521530 2021-08-14T21:15:24+00:00 @joshnuss @stolinski this is the serverless version of Jamstack 👍 started with the “just static files” stuff but as serverless becomes more commoditized it is spreading out. commercial incentives to tie to proprietary features are very high but Sveltekit is the first independent implementation.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 297] 1426379638788534274 14144788 joshnuss       0 0 8 0 0   en  
1426655419611508736 swyx 33521530 2021-08-14T21:22:12+00:00 @rishmishra makes sense! had to be more patient i guess. very used to wow-moment-it-all-clicks-together pilot episodes       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [12, 118] 1426653814174756866 331639736 rishmishra       0 0 1 0 0   en  
1426668827585118208 swyx 33521530 2021-08-14T22:15:29+00:00 @rishmishra @tonycassara2 new aspiration: be so rich i can rescue my favorite shows       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 83] 1426668464828256265 331639736 rishmishra       0 0 2 0 0   en  
1426670450613002241 swyx 33521530 2021-08-14T22:21:56+00:00 @simonw @rachelnabors the economist’s explanation is underrated: you can decompose an economy’s total output into a mix of capital and labor multiplied by technology as a dev your labor (code) can harness capital (computers) far more than anyone bar financiers, plus a % chance of improving technology       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 302] 1426632495957561345 12497 simonw       0 0 0 0 0   en  
1426672482975551490 swyx 33521530 2021-08-14T22:30:00+00:00 Passwordless no code low code creator economy cohort based buy now pay later mRNA CRISPR lab grown space blockchain       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 115]             0 40 522 0 0   en  
1426675172157788163 swyx 33521530 2021-08-14T22:40:42+00:00 @jsjoeio i just realized i forgot “metaverse” i must now go face a virtual wall and reflect on my inadequacies       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 110] 1426672998552006659 1567529924 jsjoeio       0 0 40 0 0   en  
1426605467829039104 swyx 33521530 2021-08-14T18:03:43+00:00 @mtliendo @hashnode excellent choice       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [20, 36] 1426274840529494017 749995687 mtliendo       0 0 2 0 0   fr  
1426651460901642242 swyx 33521530 2021-08-14T21:06:28+00:00 @theshteves https://knowyourmeme.com/memes/deep-fried-memes       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 35] 1426642548492222465 805074422 theshteves       0 0 0 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]);