tweets

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

18 rows where "created_at" is on date 2021-09-29 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, favorite_count

retweet_count 6 ✖

created_at (date) 1 ✖

  • 2021-09-29 · 18 ✖
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
1443032123649241091 Taylor Poindexter 876448351268380672 2021-09-29T01:57:23+00:00 I told my friend I was both scared and excited to officially join Spotify next month and she pointed me to this excerpt. It was just the reminder I needed & this may be my new favorite rallying cry. https://twitter.com/engineering_bae/status/1443032123649241091/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 202]             0 16 135 0 0 0 en  
1443034093080375301 swyx 33521530 2021-09-29T02:05:12+00:00 The Man in the Arena - Teddy telling us to get in the ring, not to cheer or jeer from the sidelines. https://twitter.com/engineering_bae/status/1443032123649241091   1443032123649241091 1443032123649241091   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 100] 1376108052005351425 33521530 swyx       1 0 7 0 0 0 en  
1443034568978620419 swyx 33521530 2021-09-29T02:07:06+00:00 @samselikoff most annoying thing about create react app (i think) is it validates package json making you scared to do stuff like this when thats not its job       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 157] 1443031859663937541 131941348 samselikoff       0 0 15 0 0   en  
1443039203260919814 swyx 33521530 2021-09-29T02:25:31+00:00 @arvidkahl hey dont kink shame       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 30] 1442940646549905415 343990983 arvidkahl       0 0 1 0 0   en  
1443046610963865601 swyx 33521530 2021-09-29T02:54:57+00:00 RT @jarroddicker: 6 months of @darkstardao. 12 essays on Web3. In order-- March 1, 2021: A New Media Structure: The Ownership Economy b… 1443026395832127496 1443026395832127496     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 23 0 0 1   en  
1443049286376124423 swyx 33521530 2021-09-29T03:05:35+00:00 @elyktrix @foxtrotmarket 🎉 congrats!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 37] 1443012053535531014 223739217 elyktrix       0 0 1 0 0   en  
1443051720104316934 swyx 33521530 2021-09-29T03:15:15+00:00 @fortelabs you managed to squeeze a book into that subtitle huh that said, the pple following you here are likely to buy your book or just know your deal already; you may want to discount our opinions to reach the really mass market who dont know you from adam.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 262] 1442970778157281282 1909232666 fortelabs       0 0 7 0 0   en  
1443052316815290372 swyx 33521530 2021-09-29T03:17:37+00:00 @QuinenceHQ @serverless @jeremy_daly @mavi888uy @dynamodb so much infra engineering obsoleted by a good runtime       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [58, 111] 1443025649266880516 1204002279759630338 QuinenceHQ       0 0 2 0 0   en  
1443053999377117188 swyx 33521530 2021-09-29T03:24:18+00:00 One piece of writing advice I took from @patio11 goes something like “everyone writes the “101” intro, but there’s near infinite demand and no supply for 201-level stuff” and somehow thats become my entire writing M.O. Go deep! It’s not popular, but it’s badly needed! https://twitter.com/RandallKanna/status/1442870467950374912   1442870467950374912 1442870467950374912   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 269]             1 43 439 0 0 0 en  
1443057317470081029 swyx 33521530 2021-09-29T03:37:29+00:00 @brianleroux i saw jeremy casually log out of the @goserverless CLI and log back in like it was nothing on this live stream (early on like 5ish mins in) and mind was fcking blown. i dont recall it ever being that smooth at @netlify https://twitter.com/swyx/status/1443024483170729989   1443024483170729989 1443024483170729989   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 231] 1443012651039133698 676363 brianleroux       1 0 6 0 0 0 en  
1443081095231131653 swyx 33521530 2021-09-29T05:11:58+00:00 @pushmatrix i kiiinda want to join Shopify just to play this god damn       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 69] 1442839002432802818 91908253 pushmatrix       0 0 21 0 0   en  
1443088918455328769 swyx 33521530 2021-09-29T05:43:04+00:00 @vladchers sir this is a Wendys       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 31] 1443079225032990723 1260923246926594048 vladchers       0 0 4 0 0   en  
1443093060473090051 swyx 33521530 2021-09-29T05:59:31+00:00 It’s been incredible to watch @nutlope’s career grow ever since he joined webdev twitter in college! He’s been a daily positive presence in the @Coding_Career discord and I feel lucky to have met him before he was “famous” Great hire by @leeerob and @rauchg — only the beginning! https://twitter.com/Nutlope/status/1442926717635477504   1442926717635477504 1442926717635477504   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 2 30 0 0 0 en  
1443094813398626306 swyx 33521530 2021-09-29T06:06:29+00:00 @arvidkahl came for the feedback panda story, stayed for the earnest support of other indiehackers 💪🏽 congrats arvid!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 117] 1442956133275103232 343990983 arvidkahl       0 0 2 0 0   en  
1443112139976179714 swyx 33521530 2021-09-29T07:15:20+00:00 @spitleaf emphasizing performance over substance. lots of motivation to get started, but no viral loop to keep people coming back. am biased but like seeing “communities of practice” form on @Discord and @circleapp where the focus is work over profiles       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 253] 1442950472848089088 357427736 spitleaf       0 0 4 0 0   en  
1443112267483017220 swyx 33521530 2021-09-29T07:15:50+00:00 @stephsmithio amazing!!!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 25] 1442878012995907591 626691391 stephsmithio       0 0 1 0 0   en  
1443112483670032402 swyx 33521530 2021-09-29T07:16:42+00:00 @ritakozlov_ buy Netlify pls thx       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 32] 1442979853054058508 232076816 ritakozlov_       0 0 3 0 0   en  
1443242219650142209 Walt Mossberg 5746452 2021-09-29T15:52:13+00:00 Here’s another great episode of ⁦@Recode⁩’s podcast series about @Apple. ⁦@pkafka⁩ does a great job documenting “How Apple Got Its Groove Back” starting in 1997. A really worthwhile listen. https://podcasts.apple.com/us/podcast/land-of-the-giants/id1465767420?i=1000536965880       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 214]             0 15 93 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]);