tweets

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

5 rows where "created_at" is on date 2021-08-31, in_reply_to_screen_name = "swyx" and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: retweet_count

in_reply_to_screen_name 1 ✖

  • swyx · 5 ✖

created_at (date) 1 ✖

  • 2021-08-31 · 5 ✖
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
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  
1432598502060675073 swyx 33521530 2021-08-31T06:57:53+00:00 here's 91 quotes from Warren Buffett, who just turned 91. https://twitter.com/GRDecter/status/1432365846438027276?s=20 This one stuck out given my recent blogpost on devrel metrics: "Games are won by players who focus on the playing field –- not by those whose eyes are glued to the scoreboard." 🎯   1432365846438027276 1432365846438027276   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 265] 1386482851026112515 33521530 swyx       1 1 7 0 0 0 en  
1432797787863744519 swyx 33521530 2021-08-31T20:09:47+00:00 just discovered this MongoDB song parody *from MongoDB*, promoting Atlas: https://www.youtube.com/watch?v=0vPt7GI-2kc holy crap seems like a fun company to work at!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 145] 1432569213688823810 33521530 swyx       0 0 6 0 0 0 en  
1432848411418529797 swyx 33521530 2021-08-31T23:30:56+00:00 @zkwentz counter point - v few agencies/service companies ever ACTUALLY successfully transition to product, there seems to be an insurmountable cultural shift needed. see Heptio: https://www.listennotes.com/podcasts/the-swyx-mixtape/the-origin-of-kubernetes-and-UI2E4z3BaVu/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 202] 1432848155129704449 33521530 swyx       0 2 1 0 0 0 en  
1432848974902284289 swyx 33521530 2021-08-31T23:33:11+00:00 @jrhunt “full stack #jamstack” https://twitter.com/swyx/status/1432848974902284289/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 30] 1432848799353819138 33521530 swyx       0 1 24 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]);