tweets

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

12 rows where "created_at" is on date 2021-09-30 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count

created_at (date) 1 ✖

  • 2021-09-30 · 12 ✖
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
1443381760935534592 emily freeman 1066151600 2021-09-30T01:06:43+00:00 I’m pretty proud of this. It represents roughly six months of my work and I’m hopeful that it will get the conversation started on what’s next for DevOps. More to come! https://flip.it/g7vdf2       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 196]             0 196 1575 0 0 0 en  
1443437632067813377 swyx 33521530 2021-09-30T04:48:43+00:00 @geddski join us, we need you, it would be helluva lot of fun https://twitter.com/swyx/status/1440389897336938502?s=21   1440389897336938502 1440389897336938502   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 86] 1443225300901507075 39607761 geddski       1 0 4 0 0 0 en  
1443448964737486848 swyx 33521530 2021-09-30T05:33:45+00:00 @TheEhsanSarshar it would break the comparison with the poll i did last year which is the main point of asking again this year :) 1 year ago nobody was considering anything but btc       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 180] 1443448568996581376 1269951243272806401 TheEhsanSarshar       0 0 3 0 0   en  
1443449499817447427 swyx 33521530 2021-09-30T05:35:53+00:00 @dabit3 @jkup nader’s magic internet money is no more real than my pretend shares in startup equity, respect (actually arguably more real since he can sell it whenever he wants and i have to wait for exit, however, another way to look at it, i have legally enforced diamond hands)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 281] 1443448390671650816 17189394 dabit3       0 0 9 0 0   en  
1443449763555209218 swyx 33521530 2021-09-30T05:36:56+00:00 @kpk @jkup defaults matter bc people are lazy :) also fiat-crypto conversion is a nonzero cost it would be a no for both of you and thats ok! just wanted to see the year on year shift       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 184] 1443448951047217152 22915745 kpk       0 0 1 0 0   en  
1443450015280615427 swyx 33521530 2021-09-30T05:37:56+00:00 @jcsrb oof. how much has that accountant cost you so far?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [7, 57] 1443449777027489792 35193525 jcsrb       0 0 1 0 0   en  
1443597354322460676 swyx 33521530 2021-09-30T15:23:24+00:00 @venikunche @webflow @canva @Netlify @temporalio here’s my blogpost about it! https://twitter.com/swyx/status/1417165270641045505   1417165270641045505 1417165270641045505   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [49, 77] 1443591935025942528 297102985 venikunche       1 0 1 0 0 0 en  
1443598625867644938 swyx 33521530 2021-09-30T15:28:27+00:00 @venikunche @webflow @canva @Netlify @temporalio haha thank you! 😇       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [49, 66] 1443598155308847116 297102985 venikunche       0 0 1 0 0   en  
1443603816247529473 swyx 33521530 2021-09-30T15:49:05+00:00 @Swizec @webflow @canva @Netlify @temporalio i tried to answer here, let me know if helps or something not clear https://twitter.com/swyx/status/1438939235801653249?s=21   1438939235801653249 1438939235801653249   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [45, 137] 1443601072602243072 15353121 Swizec       1 0 0 0 0 0 en  
1443604241927397379 swyx 33521530 2021-09-30T15:50:46+00:00 @mxstbr @webflow @canva @Netlify @temporalio @GraphCDN CDNs are an interesting thing to pitch. i think about Cloudflare: come for the performance, stay for the security. the closer you can tune to “painkiller” problems over “vitamin” the better       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [55, 245] 1443592026491027468 2451223458 mxstbr       0 0 4 0 0   en  
1443662436419047424 swyx 33521530 2021-09-30T19:42:01+00:00 @ByrneHobart @sriramk “Persona uncertainty tax” or “Focus dividend”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 67] 1443651110279987205 2723411 ByrneHobart       0 0 2 0 0   en  
1443671264091152396 youngmi mayer 50811421 2021-09-30T20:17:06+00:00 ok i made this really fast so it’s not very good but these are the small examples i could find in ten mins https://twitter.com/ymmayer/status/1443671264091152396/video/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 106] 1443615643920646145 50811421 ymmayer       0 13280 80248 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]);