tweets
11 rows where "created_at" is on date 2021-11-11, retweet_count = 0 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, favorite_count
quoted_status 0 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1458643184418914304 | swyx 33521530 | 2021-11-11T03:50:10+00:00 | @dabit3 @gitpod ayyy fellow gitpod convert | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 42] | 1458463243547070469 | 17189394 | dabit3 | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1458644215131303938 | swyx 33521530 | 2021-11-11T03:54:15+00:00 | @spitleaf third age of js man. it’s happening | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 45] | 1458468972785963008 | 357427736 | spitleaf | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1458652387313258500 | swyx 33521530 | 2021-11-11T04:26:44+00:00 | @dabit3 @gitpod for me it was general laziness, i understood the concept from Codespaces and @mikenikles like a year ago, but didnt switch because i didnt see examples that looked like my usecase, plus Docker Desktop had to degenerate to absolutely unacceptable levels of perf for me to do it 😅 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 294] | 1458651102715523073 | 17189394 | dabit3 | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1458659990219018245 | swyx 33521530 | 2021-11-11T04:56:56+00:00 | @acemarke any way you can record this in video form? show the use cases you want and the stuff you tried so far. kinda hard to follow from just this description. last resort is to change the api. generally subscribe to the idea that if its too hard to type you’re prob being too fancy | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 285] | 1458632138278899715 | 727704217012604928 | acemarke | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1458683314823315456 | swyx 33521530 | 2021-11-11T06:29:37+00:00 | @roguesherlock inverse applies if bad :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 40] | 1458682505528184833 | 921654041641304065 | roguesherlock | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1458685937907499011 | swyx 33521530 | 2021-11-11T06:40:03+00:00 | @philnash what % of visitors actually click those things? i admit i click them like <1% of the time | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 102] | 1458685670457679878 | 9152632 | philnash | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1458700727027585024 | swyx 33521530 | 2021-11-11T07:38:49+00:00 | @loujaybee @mikenikles @gitpod ah sad, i bet i couldve shown you some fun stuff in my first hour where i bounced between product and docs put a popup for people to signup for usability testing, some pple like me wouldve loved to take you up on it if i knew | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [31, 257] | 1458698942036815872 | 1290693397 | loujaybee | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1458868645577183237 | swyx 33521530 | 2021-11-11T18:46:04+00:00 | @mjwhansen @DeployEmpathy nice | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [26, 30] | 1458866685746819083 | 21612095 | mjwhansen | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1458876201884270596 | swyx 33521530 | 2021-11-11T19:16:05+00:00 | @levelsio my fave video on a topic https://www.youtube.com/watch?v=oAHbLRjF0vo that said.. i think the 2hrs includes cleaning and unloading luggage | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 128] | 1458871024141815845 | 1577241403 | levelsio | 0 | 0 | 19 | 0 | 0 | 0 | en | |||||||
1458876680257236998 | swyx 33521530 | 2021-11-11T19:17:59+00:00 | @levelsio Nomad Airlines when | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 29] | 1458876305437446146 | 1577241403 | levelsio | 0 | 0 | 15 | 0 | 0 | en | ||||||||
1458889246123565057 | swyx 33521530 | 2021-11-11T20:07:55+00:00 | @hunterwalk @calvinfo i call this my Lindy Library! top of the list is @patio11's classic on Negotiations https://www.kalzumeus.com/2012/01/23/salary-negotiation/ celebrating its 10th year in a couple months https://codingcareer.circle.so/c/lindy-library | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 199] | 1458849867233566727 | 46063 | hunterwalk | 0 | 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]);