tweets
10 rows where "created_at" is on date 2021-12-22, favorited = 0 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: favorite_count, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1473485957940740101 | swyx 33521530 | 2021-12-22T02:50:03+00:00 | @geddski @Shopify ahhh what a perfect fit!! congrats! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 53] | 1473323626925596687 | 39607761 | geddski | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1473501367432286211 | swyx 33521530 | 2021-12-22T03:51:16+00:00 | @_powellmark1 what? they're not? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 32] | 1435493972911144961 | 1097577939745394690 | _powellmark1 | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1473695980604305409 | Nick Beauchamp 594048820 | 2021-12-22T16:44:36+00:00 | @drewtoothpaste Btw, I wouldn't take this too seriously. Even looking at percentages, there seems to be a seasonal surge in "no smell" each winter. The recent Covid surges are larger, and the first wave is possibly visible as well, but this is also sensitive to how you smooth the data. https://twitter.com/nick_beauchamp/status/1473695980604305409/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 286] | 1473555762110767109 | 594048820 | nick_beauchamp | 0 | 66 | 607 | 0 | 0 | 0 | en | |||||||
1473712841278779396 | swyx 33521530 | 2021-12-22T17:51:36+00:00 | @JoshWComeau @FrontendHorse omg @trostcodes your video quality is amazing + all the animations!!! idk how you do it! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 116] | 1473692320042258437 | 2308474213 | JoshWComeau | 0 | 1 | 6 | 0 | 0 | en | ||||||||
1473712907351650304 | swyx 33521530 | 2021-12-22T17:51:52+00:00 | @nirajtolia @gwenshap appreciate the shoutout! :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 49] | 1473703057041072130 | 24314051 | nirajtolia | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1473716828862132226 | swyx 33521530 | 2021-12-22T18:07:26+00:00 | @yongfook honestly this reads like a google problem. sure, a very all set of sites will serve different content based on the slash, but google should follow what users experience on their browsers, no? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 201] | 1473580970204827649 | 7895442 | yongfook | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1473747284286644224 | swyx 33521530 | 2021-12-22T20:08:28+00:00 | @wesley83 @rosiesherry I have similar in my bio :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 50] | 1473651128608952328 | 8925602 | wesley83 | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1473751452225003521 | Netlify 2571501973 | 2021-12-22T20:25:01+00:00 | Navigate through the Netlify UI faster than ever before with our new Command Palette! 🧪 Available now in Netlify Labs. https://ntl.fyi/cmdk-readme https://twitter.com/Netlify/status/1473751452225003521/photo/1 | Sprout Social 2feaa4497dbf2f5efce3ede84518b1db6517855c | 0 | [0, 146] | 0 | 13 | 106 | 0 | 0 | 0 | en | ||||||||||
1473763346126340097 | swyx 33521530 | 2021-12-22T21:12:17+00:00 | @theDevBee congrats! every office should have dogs!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 52] | 1473081449855303680 | 1309615935532261377 | theDevBee | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1473761201968812032 | swyx 33521530 | 2021-12-22T21:03:46+00:00 | https://twitter.com/netlify/status/1473751452225003521?s=21 https://twitter.com/swyx/status/1473761201968812032/photo/1 | 1473751452225003521 1473751452225003521 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 23] | 1173754563351973888 | 33521530 | swyx | 1 | 0 | 7 | 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]);