tweets
22 rows where "created_at" is on date 2021-10-18 and retweet_count = 0 sorted by possibly_sensitive
This data as json, CSV (advanced)
Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, lang
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1449931762314846210 | swyx 33521530 | 2021-10-18T02:54:05+00:00 | @apartovi your honesty here showed that you're a genuine person who speaks truth regardless of your own financial interest. It was Jerry who screwed up, took you at your word and forgot you, and ultimately lost. ofc, Jerry did ok himself... | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 241] | 1449858297641717763 | 14485678 | apartovi | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449936775988666372 | swyx 33521530 | 2021-10-18T03:14:00+00:00 | @Swizec @jonathanstark yup jonathan beat me to it | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 49] | 1449936072343887874 | 15353121 | Swizec | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1450066984217972737 | swyx 33521530 | 2021-10-18T11:51:24+00:00 | @wongmjane there's verified, and then there's jane wong-level verified | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 70] | 1450061011604574214 | 337119125 | wongmjane | 0 | 0 | 11 | 0 | 0 | en | ||||||||
1450095547063279623 | swyx 33521530 | 2021-10-18T13:44:54+00:00 | @dkimot hey nice! lmk if any questions! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 39] | 1449817191386288128 | 2508137444 | dkimot | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1450143105651392512 | swyx 33521530 | 2021-10-18T16:53:53+00:00 | @michlbrmly @temporalio @vendure_io 1. its fine. most importantly your customers are in Slack all day so you should meet them where they are. both @CommonRoomHQ and @OrbitModel do free slack archival. 2. yes, didnt have char limit to express but growing mailing list is one of my goals of the year. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [36, 298] | 1450108501422919688 | 740059562 | michlbrmly | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1450151024509874176 | swyx 33521530 | 2021-10-18T17:25:21+00:00 | @pimterry @Cloudflare @gruseom @ycombinator ahh second chance pool is my lot in life, on HN and in dating apps lol | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [44, 114] | 1450150471163908097 | 20509812 | pimterry | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1450174336959062017 | swyx 33521530 | 2021-10-18T18:57:59+00:00 | @ryanchenkie been solely on it for a year doing full stack work where you been bruh | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 83] | 1450171128668905473 | 30654945 | ryanchenkie | 0 | 0 | 17 | 0 | 0 | en | ||||||||
1450183870762999808 | swyx 33521530 | 2021-10-18T19:35:52+00:00 | @FoolAllTheTime @brian_tran_dev follow new feed | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 47] | 1450172352793354241 | 986801772676157440 | FoolAllTheTime | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1450184449128206338 | swyx 33521530 | 2021-10-18T19:38:10+00:00 | @matteocollina @Cloudflare @pimterry haha thanks... yeah its pretty crazy that my random blogposts get something like 1-2m visitors a year... i feel embarrassed about the shitty design but i keep being too busy to update it properly | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [37, 232] | 1450181915852562438 | 15979784 | matteocollina | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1450187369076781056 | swyx 33521530 | 2021-10-18T19:49:46+00:00 | @jkup @Cloudflare @pimterry when it comes to $NET there are many reasons to only go up | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 86] | 1450186758457634817 | 255634108 | jkup | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1450187697004236805 | swyx 33521530 | 2021-10-18T19:51:04+00:00 | @lauragift_ @Cloudflare @pimterry its easy! just publish blogposts with titles that HN already agrees with without having to read it! /s | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [34, 136] | 1450148761569746945 | 3424878503 | lauragift_ | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1450191884287053826 | swyx 33521530 | 2021-10-18T20:07:43+00:00 | @emrahsamdan @Cloudflare @pimterry 🍻 and we can play Go! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [35, 56] | 1450187058618773511 | 3075701561 | emrahsamdan | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1450209199690948611 | swyx 33521530 | 2021-10-18T21:16:31+00:00 | @monicalent @Cloudflare @pimterry $MONICA | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [34, 41] | 1450209105440874509 | 1158897613 | monicalent | 0 | 0 | 0 | 0 | 0 | ca | ||||||||
1450220065186480129 | swyx 33521530 | 2021-10-18T21:59:41+00:00 | @monicalent @Cloudflare @pimterry Germans seem very intent on doing everything possible to make it difficult to do business with Germany | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [34, 136] | 1450209630555189256 | 1158897613 | monicalent | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1450236750685605890 | swyx 33521530 | 2021-10-18T23:06:00+00:00 | @shearichard oops yeah probably, will fix if i get time. thanks! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 64] | 1450219524834222080 | 20840116 | shearichard | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1449945890500669441 | swyx 33521530 | 2021-10-18T03:50:13+00:00 | preparing my @Coding_Career talk for @FITC's conf this wwek and ended up reminding myself how often performance review systems start out trying to be fair and end up fair-washing systems of oppression. Can't give career advice without acknowledging the elephant in the room. https://twitter.com/swyx/status/1449945890500669441/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 0 | 10 | 0 | 0 | 0 | en | ||||||||||
1449994225366421504 | swyx 33521530 | 2021-10-18T07:02:17+00:00 | @nikolasburk @ThePracticalDev they have the ID's but not the links. I use the "Display Anchors" chrome extension to surface them. https://twitter.com/swyx/status/1449994225366421504/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [30, 129] | 1449993133631094785 | 2384259584 | nikolasburk | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1450167481230786562 | swyx 33521530 | 2021-10-18T18:30:44+00:00 | @rafahari @soffes @superbryntendo @alongvideo going to take a wild guess that this is what was playing when you recorded that https://twitter.com/swyx/status/1450167481230786562/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [46, 125] | 1450123093578600448 | 42387965 | rafahari | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1450186580149211137 | swyx 33521530 | 2021-10-18T19:46:38+00:00 | @Cloudflare @pimterry Just noticed $NET is up 55% in the 2 weeks since I published this post #influencer #marketmoving #leakingalpha #dd #shilldevtoolsinpublic https://twitter.com/swyx/status/1450186580149211137/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 159] | 1450148471718043652 | 33521530 | swyx | 0 | 0 | 25 | 0 | 0 | 0 | en | |||||||
1450201578330222593 | swyx 33521530 | 2021-10-18T20:46:14+00:00 | and just found out that Cloudflare is sponsoring @SvelteSociety's next Summit! great minds think alike, Cloudflare has great taste 🥂 https://twitter.com/SvelteSociety/status/1450199092701892613?s=20 | 1450199092701892613 1450199092701892613 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 160] | 1450186580149211137 | 33521530 | swyx | 1 | 0 | 13 | 0 | 0 | 0 | en | ||||||
1450229964939292674 | swyx 33521530 | 2021-10-18T22:39:02+00:00 | @ObedParla @Swizec @Cloudflare @pimterry http://hnrankings.info | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [41, 64] | 1450222434334953489 | 138152969 | ObedParla | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1450231782918422534 | swyx 33521530 | 2021-10-18T22:46:15+00:00 | @hraffalli this is me every time i look at a Wardley Map... i'm sure its great but i need a tour guide around the map every time https://twitter.com/swyx/status/1450231782918422534/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 129] | 1450230071797501952 | 28612699 | hraffalli | 0 | 0 | 1 | 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]);