tweets

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

6 rows where favorite_count = 8, in_reply_to_screen_name = "swyx" and is_quote_status = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, retweet_count, 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
1422043347011600386 swyx 33521530 2021-08-02T03:55:28+00:00 some updates on HN infra — pretty much the same details https://news.ycombinator.com/item?id=26469566 - still one production server & one failover, in same DC - no longer using Cloudflare - 6m requests a day       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 191] 1377394233225572355 33521530 swyx       0 0 8 0 0 0 en  
1432536380706410501 swyx 33521530 2021-08-31T02:51:03+00:00 @shangchi @SimuLiu Marvel was SO SMART to turn these into arm rings. These are the original comic book rings worn by the Mandarin. Cool, but too similar to the Infinity Glove. Turn them into LEVITATING ARM RINGS THO and all sorts of CGI badassery unlocked!!!! WHOSE IDEA WAS THIS https://twitter.com/swyx/status/1432536380706410501/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 282] 1432533812500578304 33521530 swyx       0 0 8 0 0 0 en  
1433117668156928004 swyx 33521530 2021-09-01T17:20:52+00:00 This is not to say that if you can’t figure it out, it’s not your fault: we are tremendously bad at documenting our code, and documenting our journeys. Seek out your dev community for help, and remember how this feels when its your turn to see newer devs struggling.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 267] 1432977957388120064 33521530 swyx       0 1 8 0 0   en  
1445886812279300101 swyx 33521530 2021-10-06T23:00:53+00:00 This is the closest thing to a Director’s commentary I’ve found and it’s fantastic. they put so much thought into the games, the set and costume design. the show’s Art Director is incredible, I hope she wins an award or something https://youtu.be/xc61U1aFkik       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 254] 1443997105790459905 33521530 swyx       0 1 8 0 0 0 en  
1449609391666171906 swyx 33521530 2021-10-17T05:33:06+00:00 Re: the dark arts of launch timing. There’s a bell curve: The mediocre makers do it because they value the wrong things. The big players do it because media cycles matter. The rest should build async distribution and focus on shipping great work, as often as they can manage.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 279] 1449465216199061507 33521530 swyx       0 1 8 0 0   en  
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  

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