tweets
14 rows where "created_at" is on date 2021-09-30 and possibly_sensitive = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, quoted_status, source, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, retweeted
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 | ||||||
1443446972313006084 | swyx 33521530 | 2021-09-30T05:25:50+00:00 | 1 year ago https://twitter.com/swyx/status/1311775898958323714?s=20 | 1311775898958323714 1311775898958323714 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 34] | 1443446713591623681 | 33521530 | swyx | 1 | 0 | 8 | 0 | 0 | 0 | en | ||||||
1443467407352205312 | swyx 33521530 | 2021-09-30T06:47:02+00:00 | It really is a tall order to retell the Apple origin story in an engaging way, when so much of it is well known. So I really mean it when I say @pkafka has done the best ~40 minute recap of the story from Homebrew to iPhone I've ever heard. Recommend. https://www.listennotes.com/podcasts/land-of-the-giants/how-apple-got-its-groove-back-vTYLIF5XaSD/ https://twitter.com/waltmossberg/status/1443242219650142209 | 1443242219650142209 1443242219650142209 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1 | 3 | 18 | 0 | 0 | 0 | en | |||||||||
1443473925304827906 | swyx 33521530 | 2021-09-30T07:12:56+00:00 | @geddski more reading to nerd snipe you :) https://twitter.com/swyx/status/1417165270641045505 | 1417165270641045505 1417165270641045505 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 66] | 1443469847514402821 | 39607761 | geddski | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1443478084385009667 | swyx 33521530 | 2021-09-30T07:29:28+00:00 | Added a few more offending sites today after the recent feature on @CSS Tricks cc @mxbck https://twitter.com/swyx/status/1443478084385009667/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 88] | 1344116697347735553 | 33521530 | swyx | 0 | 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 | ||||||
1443510896676859906 | swyx 33521530 | 2021-09-30T09:39:51+00:00 | So @spenserskates' AMA (on the occasion of @Amplitude_HQ's IPO) is just an all-timer HN fairytale: https://news.ycombinator.com/item?id=28696641 - disrupting competitor @Mixpanel - Mixpanel founder @suhail congratulating them - @patio11 "Charge more" taken to heart - @bgurley style IPO rant https://twitter.com/swyx/status/1443510896676859906/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 272] | 0 | 29 | 253 | 0 | 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 | ||||||
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 | ||||||
1443621707999232000 | GitHub 13334762 | 2021-09-30T17:00:11+00:00 | Footnotes are a great way to reference notes and relevant information without disrupting the flow of your content. Now you can use footnotes in Markdown fields on GitHub! https://github.blog/changelog/2021-09-30-footnotes-now-supported-in-markdown-fields/ | Sprout Social 2feaa4497dbf2f5efce3ede84518b1db6517855c | 0 | [0, 194] | 0 | 142 | 649 | 0 | 1 | 0 | en | ||||||||||
1443644578700017667 | swyx 33521530 | 2021-09-30T18:31:03+00:00 | @gethackteam @SlackHQ different infra including different domain (http://slackstatus.com ?) and different provider yea wouldve been nice | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 137] | 1443644293047062538 | 798259732263956480 | gethackteam | 0 | 0 | 0 | 0 | 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 | |||||||
1443648184400502785 | swyx 33521530 | 2021-09-30T18:45:23+00:00 | @analyseian @wongmjane @SlackHQ hmm... https://twitter.com/search?q=slack%20down&src=typed_query | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 62] | 1443645544879075336 | 1017496907013394432 | analyseian | 0 | 0 | 0 | 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]);