tweets

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

16 rows where "created_at" is on date 2021-11-19 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, retweet_count, favorite_count, favorited

created_at (date) 1 ✖

  • 2021-11-19 · 16 ✖
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
1461501344540344320 swyx 33521530 2021-11-19T01:07:28+00:00 @kpk ooh holiday? enjoy! 🏝       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [5, 26] 1461190455522050054 22915745 kpk       0 0 1 0 0   en  
1461501989775294466 swyx 33521530 2021-11-19T01:10:02+00:00 @amyngyn come join @temporalio and solve the distributed systems murder mystery! https://youtu.be/Crkcr1S-NSc       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 105] 1461406340174077952 961861063 amyngyn       0 1 9 0 0 0 en  
1461532422596481026 swyx 33521530 2021-11-19T03:10:58+00:00 @sebmarkbage the choices are weirdly picked; the middle two werent even in the first two avengers movies. perhaps you meant MCU instead? for phase 4-6 arguably will be Spider-man (respect the hyphen!) but Strange has good claim, more of a worthy bet       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 250] 1461520045469798406 18022416 sebmarkbage       0 0 6 0 0   en  
1461532733147025413 swyx 33521530 2021-11-19T03:12:12+00:00 @_DavidHead @supabase are nocoders even using supabase yet? this genuinely is news to me       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 88] 1461498967078813700 430387294 _DavidHead       0 0 3 0 0   en  
1461534174615986179 swyx 33521530 2021-11-19T03:17:55+00:00 @FriskyVideoChat i mean yes im boring but hell no lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 53] 1445403124823433230 1445019621040480256 FriskyVideoChat       0 0 0 0 0   en  
1461631990248079363 swyx 33521530 2021-11-19T09:46:36+00:00 @ronvoluted @kevmodrome @sveltejs @SvelteSociety THE VIEWERS DEMAND THE RETURN OF FLOATING HEAD       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [49, 95] 1461630249322500096 18333169 ronvoluted       0 0 5 0 0   en  
1461667143569731586 swyx 33521530 2021-11-19T12:06:18+00:00 🗽 Making the quick hop to Svelte Summit in NYC!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 47]             0 0 32 0 0   en  
1461670112633638913 swyx 33521530 2021-11-19T12:18:06+00:00 @zachleat @jdan underrated       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 26] 1405194112408694784 96383 zachleat       0 0 2 0 0   en  
1461730930897219584 swyx 33521530 2021-11-19T16:19:46+00:00 As a creator it is *so nice* to get encouraging comments on past work. Love that YouTube constantly surfaces my videos, despite *zero* promotion of it here on Twitter & negligible algorithm-optimising from me. I’ve been dabbling in YT for 3 years and think its time to step it up https://twitter.com/swyx/status/1461730930897219584/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 284]             0 0 57 0 0 0 en  
1461733733065580549 swyx 33521530 2021-11-19T16:30:54+00:00 @tnorthcutt ah but then i wouldnt get to humblebrag that i havent promoted it *taps head*       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 89] 1461731705060921345 18384476 tnorthcutt       0 0 1 0 0   en  
1461734686187687943 swyx 33521530 2021-11-19T16:34:41+00:00 @stolinski id love to!! definitely feeling the impostor syndrome because theres so much i dont know about video. hit me up if you have an idea for something and i’ll do the same, not suuper sure what my channel is about yet       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 223] 1461731095620292618 18727585 stolinski       0 0 2 0 0   en  
1461748429764239361 Andrew Culver 11467732 2021-11-19T17:29:18+00:00 Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @swyx's recent post which I think is one of the most important things written in software development in the last ten years. https://twitter.com/andrewculver/status/1461748429764239361/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 242] 1461746021306830852 11467732 andrewculver       0 2 10 1 1 0 en  
1461750746072899586 swyx 33521530 2021-11-19T17:38:30+00:00 RT @andrewculver: Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @sw… 1461748429764239361 1461748429764239361     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1   en  
1461763001829179396 swyx 33521530 2021-11-19T18:27:12+00:00 As an… – iOS user I want… – my apps to reload whenever I so much as glance at them so that… – I completely lose the screen I was on and have to find it again       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 162]             0 3 52 0 0   en  
1461766096139300865 swyx 33521530 2021-11-19T18:39:30+00:00 @Swizec i feel like they should sleep/wake for me based on LRU… ill close some apps thanks       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 90] 1461764900296925187 15353121 Swizec       0 0 0 0 0   en  
1461843236671131653 Brian Vaughn 🏳️‍🌈🖤 99973385 2021-11-19T23:46:02+00:00 Looking forward to going to the @sveltejs Summit tomorrow in NYC. Will I see any of you there? 🙂       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 96]             0 1 56 1 1   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]);