tweets
5 rows where display_text_range = "[0, 242]" and lang = "en"
This data as json, CSV (advanced)
Suggested facets: user, is_quote_status, retweet_count, favorited, retweeted, created_at (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1245551305881317378 | Aella 795885295 | 2020-04-02T03:19:07+00:00 | Here's all of my twitter polls, in a google spreadsheet: https://docs.google.com/spreadsheets/d/1q2plaBw2UEYelx8bFP1dEi9zAcH5se_ZJvxLZISdN8o/edit?usp=sharing It's not fully updated, missing a few months. I'm getting tired of manually inputting polls; is anybody bored and/or skilled and feels like updating the sheet? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 0 | 0 | 17 | 0 | 0 | 0 | en | ||||||||||
1423005684057079813 | swyx 33521530 | 2021-08-04T19:39:27+00:00 | Confluent launches their own developer learning portal, presumably entirely custom built. How much faster could they have got to market, how much more educational content produced, if they had a service to help them? https://twitter.com/rmoff/status/1422957383387688968?s=20 https://twitter.com/swyx/status/1423005684057079813/photo/1 | 1422957383387688968 1422957383387688968 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 1398354955686191105 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1428149223850012673 | swyx 33521530 | 2021-08-19T00:18:03+00:00 | ⚛️ Using MDX to progressively upgrade Docs Links with @reactjs https://youtu.be/LbC4WZoyinI Perhaps a fun @docusaurus hack - you can swizzle MDX components and write your own custom HTML elements that enhance user experience. #extendThePlatform? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 0 | 2 | 24 | 0 | 0 | 0 | en | ||||||||||
1440666213382717453 | Sean C Davis 23583938 | 2021-09-22T13:16:06+00:00 | I really this article from @swyx because it reframes the GraphQL vs REST debate. There's much more nuance to the conversation on how data is passed between the client and the server, and this essay summarizes it well. https://www.swyx.io/client-server-battle/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 0 | 2 | 13 | 0 | 1 | 0 | en | ||||||||||
1461748429764239361 | Andrew Culver 11467732 | 2021-11-19T17:29:18+00:00 | Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @swyx's recent post which I think is one of the most important things written in software development in the last ten years. https://twitter.com/andrewculver/status/1461748429764239361/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 1461746021306830852 | 11467732 | andrewculver | 0 | 2 | 10 | 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]);