tweets
11 rows where "created_at" is on date 2021-09-12 and possibly_sensitive = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, created_at (date)
quoted_status 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1436890184449236994 | Ben Lesh 👈😎👈 23795212 | 2021-09-12T03:11:30+00:00 | Okay, I've taken the time to articulate all of my thoughts in a single space about the current pipeline proposal. I've also included as much information as I can about functional piping, and the two most popular pipelines. (It's opinionated, sorry) https://benlesh.com/posts/tc39-pipeline-proposal-hack-vs-f-sharp/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 143 | 555 | 0 | 0 | 0 | en | ||||||||||
1436966057563013120 | swyx 33521530 | 2021-09-12T08:13:00+00:00 | @PCurell not exact answer but heres my research https://twitter.com/swyx/status/1239756967423467522 | 1239756967423467522 1239756967423467522 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 47] | 1436731423663267843 | 375232562 | PCurell | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
1436973708304863238 | swyx 33521530 | 2021-09-12T08:43:24+00:00 | Lifechanging travel tip I am only learning too late in life: You can travel in shorts! Nothing in the flight rules that say you have to be in tight jeans or nice shoes. And most airports require waaay too much walking. (yes, looking at you, @Airport_FRA!) https://twitter.com/swyx/status/1436973708304863238/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 256] | 0 | 4 | 80 | 0 | 0 | 0 | en | ||||||||||
1437026369163124740 | swyx 33521530 | 2021-09-12T12:12:39+00:00 | @QuinnyPig @awscloud @AWScwoud this was an absolute mangled mess lmao https://twitter.com/awscwoud/status/1436520685778530307?s=21 | 1436520685778530307 1436520685778530307 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [31, 94] | 1436524584681963522 | 97114171 | QuinnyPig | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
1437039454967975938 | Thomas Dhondt 1327740164328878081 | 2021-09-12T13:04:39+00:00 | Wrote a quick post why I changed my mind about @tailwindcss. I used to think it was quite messy early on in my dev career, now I actually love it! https://www.thomasdhondt.be/blog/i-changed-my-mind-about-tailwind-css | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 171] | 0 | 31 | 257 | 0 | 0 | 0 | en | ||||||||||
1437048380958679042 | swyx 33521530 | 2021-09-12T13:40:07+00:00 | Valuable peek into what it is like to debate syntax inside @TC39, from someone who was actively involved but no longer is. This sort of thing is above my paygrade, but standards work affects us all, and I’m glad people this passionate have a voice in the future of JavaScript. https://twitter.com/BenLesh/status/1436890184449236994 | 1436890184449236994 1436890184449236994 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 1 | 1 | 33 | 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 | ||||||
1437109166334783494 | swyx 33521530 | 2021-09-12T17:41:40+00:00 | 👀 Working on next post: "Why do webdevs keep trying to kill REST?" This one's been baking for a while - ever since I saw the innovation in @Reactjs Server Components and Rails Hotwire. Subscribe if you'd like to read a draft tonight! https://swyx.io/subscribe 🙏🏽 https://twitter.com/swyx/status/1437109166334783494/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 263] | 0 | 6 | 186 | 0 | 0 | 0 | en | ||||||||||
1437125387595698176 | swyx 33521530 | 2021-09-12T18:46:07+00:00 | @colinhacks ah. your own HTTP rpc spec? https://trpc.io/docs/rpc | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 63] | 1437125150965653511 | 33521530 | swyx | 0 | 0 | 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 |
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]);