tweets
4 rows where display_text_range = "[0, 260]" and lang = "en"
This data as json, CSV (advanced)
Suggested facets: user, source, retweet_count, favorited, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1425514852999745547 | egghead.io 921398240 | 2021-08-11T17:50:00+00:00 | Go deep with @supabase In this new course from @signalnerve you'll: 📀 Create a Postgres database 🔐 Authorize users with GitHub 🔌 Set up real-time data 🌩 Deploy to Cloudlflare Pages Build a real-time chat app with Next and Supabase https://bit.ly/3AsYhJh | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 260] | 0 | 28 | 128 | 0 | 1 | 0 | en | ||||||||||
1431454424153604098 | swyx 33521530 | 2021-08-28T03:11:44+00:00 | 🏃♀️ Time to Implement Change Anyone can build brittle systems. But great DX optimizes for 1-2 standard deviation changes in requirements: - find helpful docs fast (better: no docs needed) - low edit distance - smooth migration paths https://twitter.com/swyx/status/1395172543565344770?s=20 | 1395172543565344770 1395172543565344770 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 260] | 1431454422886924293 | 33521530 | swyx | 1 | 0 | 7 | 0 | 0 | 0 | en | ||||||
1454258287868723204 | swyx 33521530 | 2021-10-30T01:26:09+00:00 | Met @ubique_terrarum to hear the full Utopia pitch today. Was prepared to dismiss it as "@Webflow but React" but that understates it! The key thing here is the two way editing that keeps you in flow. Also: @Tailwindcss, S-C, and Vue/Svelte support on horizon! https://twitter.com/RheeseyB/status/1404831547354648577 | 1404831547354648577 1404831547354648577 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 260] | 1 | 0 | 3 | 0 | 0 | 0 | en | |||||||||
1470487534132154378 | Jason Laster 312750384 | 2021-12-13T20:15:23+00:00 | This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It doesn't matter if you're technically support, success, product, qa, leadership, or dev, if you care about quality, we want to talk to you! 🐛👋 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 260] | 0 | 2 | 4 | 1 | 1 | 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]);