tweets
15 rows where "created_at" is on date 2021-10-03 and retweet_count = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, lang
quoted_status 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1444468204223426563 | swyx 33521530 | 2021-10-03T01:03:51+00:00 | welp i just got done editing and forgot it needs time to output the video https://twitter.com/swyx/status/1444468204223426563/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 73] | 1444408212707438594 | 33521530 | swyx | 0 | 0 | 7 | 0 | 0 | 0 | en | |||||||
1444498121854124035 | swyx 33521530 | 2021-10-03T03:02:44+00:00 | this is a worthwhile talk (direct link https://youtu.be/hV3dJur69SU) We are dealing w/ similar issues at @temporalio: how to guide someone to learn your system and be able to find the answer to every important question in the shortest time? Docs, like the SDLC, should be nonlinear. https://twitter.com/editingemily/status/1443381760935534592 | 1443381760935534592 1443381760935534592 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 0 | 5 | 0 | 0 | 0 | en | |||||||||
1444498974283423746 | swyx 33521530 | 2021-10-03T03:06:07+00:00 | @threehourcoffee @MeetKevon fwiw i watched on 1.5x and aggressively used the time skip button. life is too short for slow pacing! but episode 6 is worth taking slow | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 164] | 1444476922474352643 | 28257675 | threehourcoffee | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1444500678806630402 | swyx 33521530 | 2021-10-03T03:12:54+00:00 | @lucperkins @cohix @planetscaledata @Cloudflare @CivoCloud @PulumiCorp @SuborbitalDev @temporalio what techs would you use if you didnt have Temporal? just trying to see where it sits in your mind | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [98, 196] | 1444388249338662914 | 68474641 | lucperkins | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1444503472699707395 | swyx 33521530 | 2021-10-03T03:24:00+00:00 | @ken_wheeler have i introduced you to the “Mystery Recapped” and “Movie Recapped” channels on youtube yet? just browse the most popular videos | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 142] | 1444440727115665420 | 167193309 | ken_wheeler | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1444511985832382468 | swyx 33521530 | 2021-10-03T03:57:49+00:00 | @tannerlinsley @kentcdodds tanner i was only joking | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 51] | 1444482851160817674 | 50136899 | tannerlinsley | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1444551050967465986 | swyx 33521530 | 2021-10-03T06:33:03+00:00 | @ejames_c "I am a postgresql specialist because it is open source and reliable af" is a pretty good reason not to know anything else about database implementations and just spend the rest of your career knowing postgres nuances tbh. not everyone needs to be horizontally aware | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 276] | 1444549924108976130 | 14243237 | ejames_c | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1444560899797176321 | swyx 33521530 | 2021-10-03T07:12:11+00:00 | Unsolicited compliment: I am enjoying watching along how @9ranty is building his Loom competitor in public. Lots of little gems and the video result looks great! Worth checking out http://tella.tv Am not a regular user yet but #BuildInPublic updates keep me interested. https://twitter.com/TellaHQ/status/1443129037854019589 | 1443129037854019589 1443129037854019589 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 0 | 14 | 0 | 0 | 0 | en | |||||||||
1444576026852397060 | swyx 33521530 | 2021-10-03T08:12:18+00:00 | @dtinth love it 🔥 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 17] | 1444575699663081480 | 12740012 | dtinth | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1444577475552432131 | swyx 33521530 | 2021-10-03T08:18:03+00:00 | @dtinth this would be a good talk/blogpost, in case you ever want content ideas :) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 82] | 1444576307786883072 | 12740012 | dtinth | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1444737301611827202 | swyx 33521530 | 2021-10-03T18:53:09+00:00 | @SoftwareSocPod you two have amazing chemistry and are both working on interesting projects! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 92] | 1444312230162534401 | 1288427219786891265 | SoftwareSocPod | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1444737590901411846 | swyx 33521530 | 2021-10-03T18:54:18+00:00 | @skynetcap @fipsyfip @eastdakota @Cloudflare this aged well. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [45, 60] | 1198716154987962368 | 999128303179976704 | skynetcap | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1444477575401590787 | swyx 33521530 | 2021-10-03T01:41:05+00:00 | @suiteasdesign yup http://swyx.transistor.fm | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 42] | 1444475505638449157 | 1223050713674027008 | suiteasdesign | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1444500886546305033 | swyx 33521530 | 2021-10-03T03:13:43+00:00 | @flybayer @cohix @planetscaledata @Cloudflare @CivoCloud @PulumiCorp @SuborbitalDev @Flightcontrolhq @temporalio https://twitter.com/swyx/status/1444500886546305033/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [112, 112] | 1444313802162454532 | 2826554209 | flybayer | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1444781745409179655 | swyx 33521530 | 2021-10-03T21:49:45+00:00 | @threepointone 👁️👄👁️ https://twitter.com/swyx/status/1417165280522821632 | 1417165280522821632 1417165280522821632 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 46] | 1444737710116196353 | 1593171 | threepointone | 1 | 0 | 12 | 0 | 0 | 0 | und |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);