tweets
21 rows where favorite_count = 4 and is_quote_status = 1 sorted by truncated
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, lang
created_at (date) 18 ✖
- 2021-09-12 3
- 2021-09-30 2
- 2021-08-17 1
- 2021-08-18 1
- 2021-08-31 1
- 2021-09-05 1
- 2021-09-11 1
- 2021-09-22 1
- 2021-09-23 1
- 2021-09-25 1
- 2021-10-01 1
- 2021-11-03 1
- 2021-11-22 1
- 2021-11-23 1
- 2021-11-25 1
- 2021-11-28 1
- 2021-12-07 1
- 2021-12-17 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1427497832848658434 | swyx 33521530 | 2021-08-17T05:09:39+00:00 | @jhooks https://twitter.com/celothedev/status/1427460022284419073?s=20 | 1427460022284419073 1427460022284419073 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 31] | 1427492570733584385 | 12087242 | jhooks | 1 | 0 | 4 | 0 | 0 | 0 | und | ||||||
1428103782810873859 | swyx 33521530 | 2021-08-18T21:17:29+00:00 | @mozzius @reactjs @jquery https://twitter.com/swyx/status/1093200303254466561 | 1093200303254466561 1093200303254466561 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [26, 49] | 1428103288537354241 | 1266850963429752832 | mozzius | 1 | 0 | 4 | 0 | 0 | 0 | und | ||||||
1432504165440184321 | swyx 33521530 | 2021-08-31T00:43:02+00:00 | @shreyas “Good Enough” is better than “Best”: https://twitter.com/swyx/status/1221129594146840577?s=21 | 1221129594146840577 1221129594146840577 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 70] | 1432501769989357568 | 2048741 | shreyas | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1434500277567115266 | swyx 33521530 | 2021-09-05T12:54:52+00:00 | awesome writeup on adding custom monaco autocompletes for in-app editors! https://twitter.com/tim_nolet/status/1402925458623172611 | 1402925458623172611 1402925458623172611 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 73] | 1321978673868599296 | 33521530 | swyx | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1436716037202980868 | swyx 33521530 | 2021-09-11T15:39:30+00:00 | @simonw i genuinely think this one assumption made many remaining decisions for them: https://twitter.com/slightlylate/status/1436708762115473411?s=20 I hear unexamined assumptions like these a lot and people don't realize these are far weightier decisions than they seem at first glance. Rhyme shortcircuits reason. | 1436708762115473411 1436708762115473411 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 276] | 1436710644045152262 | 12497 | simonw | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1437095732436258816 | swyx 33521530 | 2021-09-12T16:48:17+00:00 | @jamonholmgren yes! I call this Lampshading. Ignorance can be Power, when wielded correctly. https://twitter.com/swyx/status/1238321393374298112 | 1238321393374298112 1238321393374298112 | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [15, 117] | 1437089665018826754 | 30273948 | jamonholmgren | 1 | 1 | 4 | 0 | 0 | 0 | en | ||||||
1437132448798806017 | swyx 33521530 | 2021-09-12T19:14:11+00:00 | Another mindchanger on Tailwind! https://twitter.com/thamasky/status/1437039454967975938 | 1437039454967975938 1437039454967975938 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 32] | 1413018688077238273 | 33521530 | swyx | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1437132718928695301 | swyx 33521530 | 2021-09-12T19:15:15+00:00 | expanded in a blogpost: https://twitter.com/swyx/status/1312603851581652994?s=21 | 1312603851581652994 1312603851581652994 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 47] | 1253303455961079810 | 33521530 | swyx | 1 | 1 | 4 | 0 | 0 | 0 | en | ||||||
1440514869715898376 | swyx 33521530 | 2021-09-22T03:14:43+00:00 | @TrungTPhan damn son is there such a thing as a QT ratio cuz you got ratioed hard https://twitter.com/i_zzzzzz/status/1440053089822601216?s=21 | 1440053089822601216 1440053089822601216 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 105] | 1403475948477976577 | 945817135816654848 | TrungTPhan | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1441075713231175681 | swyx 33521530 | 2021-09-23T16:23:18+00:00 | @SvelteSociety @syntaxfm @stolinski @wesbos enjoyed this discussion! as well as the responsible disclaimer about it being apples vs oranges. also re: ecosystem - its growing, but also arguably bigger than React! https://twitter.com/SvelteSociety/status/1390082681753374723?s=20 | 1390082681753374723 1390082681753374723 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [44, 236] | 1441016244832849929 | 1176969867733479424 | SvelteSociety | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1441868475711037445 | swyx 33521530 | 2021-09-25T20:53:27+00:00 | Interesting alternative measure for the less biblically inclined: brain chemicals! https://twitter.com/shreyas/status/1441866360313634823?s=21 | 1441866360313634823 1441866360313634823 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 107] | 1411461620497223681 | 33521530 | swyx | 1 | 0 | 4 | 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 | ||||||
1443492279939842048 | swyx 33521530 | 2021-09-30T08:25:52+00:00 | @posobin launched @ampie_app today which is a nice take on this. I still prefer @round's extension for its minimalism (my fork https://github.com/sw-yx/Twitter-Links-beta) https://twitter.com/posobin/status/1443269476464664584?s=20 | 1443269476464664584 1443269476464664584 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 177] | 1240475079718420480 | 33521530 | swyx | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1444014341469081601 | swyx 33521530 | 2021-10-01T19:00:22+00:00 | @_developit @acemarke @alexandereardon prior art, for those who dont know what i am referencing https://twitter.com/swyx/status/1281896981049356288 | 1281896981049356288 1281896981049356288 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [39, 119] | 1443997699208933380 | 33521530 | swyx | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1455805392500318208 | swyx 33521530 | 2021-11-03T07:53:47+00:00 | @kiwicopple @supabase @zernonia this is incredible @zernonia! is it open source by any chance? wanted to see how you do search/tagging. idea for you - special "sea" view that just lists all the projects in one screen this way you can visualize the growth of the ecosystem like this https://twitter.com/mattturck/status/1445144517439541255 | 1445144517439541255 1445144517439541255 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 307] | 1455764288686080003 | 832817861844275200 | kiwicopple | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1462694167402844161 | swyx 33521530 | 2021-11-22T08:07:19+00:00 | @AntWilson @supabase this is the genre of “how it started/how its going” that @paulg likes to see in a yc company! https://twitter.com/paulg/status/403183731449413632?s=21 | 403183731449413632 403183731449413632 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 138] | 1462645962971566081 | 22399680 | AntWilson | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1463283116030652416 | swyx 33521530 | 2021-11-23T23:07:36+00:00 | @temporalio What is Temporal, and why should you care? I wrote about it earlier this year: https://twitter.com/swyx/status/1417165270641045505 https://twitter.com/swyx/status/1463283116030652416/photo/1 | 1417165270641045505 1417165270641045505 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 115] | 1463194116515196942 | 33521530 | swyx | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1463695718057578498 | swyx 33521530 | 2021-11-25T02:27:07+00:00 | @levelsio yes and here is the Singapore tax code! https://twitter.com/swyx/status/1381324888216981504 | 1381324888216981504 1381324888216981504 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 49] | 1463404709100736513 | 1577241403 | levelsio | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1464843139416346629 | swyx 33521530 | 2021-11-28T06:26:34+00:00 | @shreyas i am liking this genre https://twitter.com/shreyas/status/1459931369019035649 | 1459931369019035649 1459931369019035649 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 31] | 1464832326483939329 | 2048741 | shreyas | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1468158323992059904 | swyx 33521530 | 2021-12-07T09:59:56+00:00 | @jakobgreenfeld that's some pretty damn quick number crunching skills there! i have another fun metric for you to try: Number of PH #1 of the day winners that now 404. it was roughly 10-15% when i checked 2017's winners in 2018 https://twitter.com/swyx/status/970106789189636098?s=20 | 970106789189636098 970106789189636098 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 253] | 1468157620741722121 | 1285142519525892098 | jakobgreenfeld | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1471985415137726477 | swyx 33521530 | 2021-12-17T23:27:25+00:00 | @forrestbrazeal Postel's Law ("be conservative in what you do, be liberal in what you accept from others" aka Robustness Principle) becoming relevant as I learn about API design. However, too much defensive coding from too many layers can cause overhead & confusion. https://twitter.com/mfeathers/status/995896831165919232?s=20 | 995896831165919232 995896831165919232 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 296] | 1323643707271213056 | 33521530 | swyx | 1 | 0 | 4 | 0 | 0 | 0 | en |
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]);