tweets

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

9 rows where "created_at" is on date 2021-11-27, is_quote_status = 0 and user = 33521530

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count, lang, 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
1464411974851129344 swyx 33521530 2021-11-27T01:53:16+00:00 @hhg2288 nice one Horacio!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 26] 1464386190841458698 24702345 hhg2288       0 0 1 0 0   es  
1464423478950457344 swyx 33521530 2021-11-27T02:38:59+00:00 AWS responds: https://aws.amazon.com/about-aws/whats-new/2021/11/aws-price-reduction-data-transfers-internet/ Each month: - First TB: Free - First 10m requests: Free - First 2m functions: Free - Applies to Year 2+ "All AWS customers will benefit from these pricing changes, and millions of customers will see no data transfer charges as a result."       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1454251874849202185 33521530 swyx       0 4 38 0 0 0 en  
1464691627423776768 swyx 33521530 2021-11-27T20:24:31+00:00 Making some moves to declutter my apartment. Been using @Clutter for the past ~6 years. Did some price checks for this round - its 30% *cheaper* than the self storage 2 blocks from me and does modular pickup/dropoff! $100 off with my referral code FKC7DH https://www.clutter.com/r/t/d?code=FKC7DH https://twitter.com/swyx/status/1464691627423776768/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 0 8 0 0 0 en  
1464721860097052672 swyx 33521530 2021-11-27T22:24:39+00:00 @chancethedev @Clutter i think you'd have to setup something special with them to do direct access, by default it is just pickup/dropoff. i think part of why it is so cheap is their storage facility is quite a ways outside the main city       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 236] 1464714088479485953 964202120361709569 chancethedev       0 0 1 0 0   en  
1464724371038040065 swyx 33521530 2021-11-27T22:34:37+00:00 @shreyas also has a whiff of taking credit and not acknowledging others who worked hard to solve this emergency without making noise about it. part of good PMing is giving recognition.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 185] 1464721736109203460 2048741 shreyas       0 0 9 0 0   en  
1464738098806358020 swyx 33521530 2021-11-27T23:29:10+00:00 I can't decide if @goEnjoy is overrated or a stroke of genius. Their whole thing is that "the store comes to you." When I ordered my new iPhone, I could either wait 2-3 weeks, or it could be hand-delivered - with setup - for free, **the next day**. Guess which button I hit. https://twitter.com/swyx/status/1464738098806358020/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 0 13 0 0 0 en  
1464739372167688193 swyx 33521530 2021-11-27T23:34:14+00:00 @goEnjoy Today, a FANTASTIC rep named Lolli showed up at my door, suitcase and iPhone in hand. She talked me through the transfer, answered all my questions. I didn't *really* need help, but I could see how less tech-literate people would LOVE this. Entire thing was done in <10 mins. https://twitter.com/swyx/status/1464739372167688193/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 288] 1464738098806358020 33521530 swyx       0 0 4 0 0 0 en  
1464740702714155008 swyx 33521530 2021-11-27T23:39:31+00:00 @goEnjoy How do they make money? The suitcase has upsells - airpods, phone cases and such. They also get compensated for every install of Apple Services, e.g. if I sign up for a free month of Apple One through them. Went public at $1.1b via SPAC last month. SPAC holders *hate it* lol https://twitter.com/swyx/status/1464740702714155008/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 286] 1464739372167688193 33521530 swyx       0 0 5 0 0 0 en  
1464741047741804544 swyx 33521530 2021-11-27T23:40:54+00:00 @isakkeyten @goEnjoy next tweet explains       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 40] 1464738607080554501 21492600 isakkeyten       0 0 1 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]);