tweets

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

13 rows where "created_at" is on date 2021-09-29, retweet_count = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, is_quote_status, created_at (date)

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
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  
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  
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  
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  

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