tweets
9 rows where "created_at" is on date 2021-12-03 and possibly_sensitive = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, favorited, retweeted, lang
user 4 ✖
- swyx 6
- Paul Copplestone 1
- CoRecursive Podcast 1
- Relay 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1466650054232449028 | swyx 33521530 | 2021-12-03T06:06:36+00:00 | @LSrugo yeah im on a mac, i open Activity Monitor every now and then but the cause doesnt seem consistent. Today though, its very obviously @DescriptApp killing my machine. they were slow and unperformant before but god damn i am uninstalling this crap. Completely unacceptable https://twitter.com/swyx/status/1466650054232449028/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 278] | 1466646974015279104 | 825088906609696768 | LSrugo | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1466654816227057673 | swyx 33521530 | 2021-12-03T06:25:31+00:00 | @LSrugo @DescriptApp fascinating. i have 8gb memory and 9gb swap used. how do i kill this? https://twitter.com/swyx/status/1466654816227057673/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [21, 90] | 1466654473766404097 | 825088906609696768 | LSrugo | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1466678884540186626 | swyx 33521530 | 2021-12-03T08:01:10+00:00 | Dear all @TransistorFM users, please for the love of god customize your Transistor websites! They all look the same! Here's how: https://dev.to/swyx/how-to-customize-your-transistorfm-website-with-js-and-css-3afc https://twitter.com/swyx/status/1466678884540186626/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 154] | 0 | 0 | 9 | 0 | 0 | 0 | en | ||||||||||
1466801873373986819 | Paul Copplestone 832817861844275200 | 2021-12-03T16:09:53+00:00 | .@supabase is building a @PostgreSQL #graphql extension https://news.ycombinator.com/item?id=29430720 https://twitter.com/kiwicopple/status/1466801873373986819/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 80] | 0 | 31 | 260 | 0 | 0 | 0 | en | ||||||||||
1466828614247206913 | swyx 33521530 | 2021-12-03T17:56:08+00:00 | "Cloud vendors will increasingly focus on the lowest layers in the stack: basically leasing capacity in their data centers through an API. Other pure-software providers will build all the stuff on top of it. Databases, running code, you name it." https://twitter.com/bernhardsson/status/1465732837173252101?s=20 https://twitter.com/swyx/status/1466828614247206913/photo/1 | 1465732837173252101 1465732837173252101 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 1400228924307611649 | 33521530 | swyx | 1 | 1 | 9 | 0 | 0 | 0 | en | ||||||
1466846573078487043 | CoRecursive Podcast 947150325424803840 | 2021-12-03T19:07:30+00:00 | A great list to be a part of! 🏆 https://twitter.com/swyx/status/1466447829149237249 | 1466447829149237249 1466447829149237249 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 31] | 1 | 3 | 18 | 1 | 1 | 0 | en | |||||||||
1466859528528416775 | swyx 33521530 | 2021-12-03T19:58:59+00:00 | @twwilliams i have a whole book on the subject! :) @Coding_Career has more. start here https://www.swyx.io/LIP | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 112] | 1466859098826317827 | 52123 | twwilliams | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1466875921818861577 | Relay 1441943134112403460 | 2021-12-03T21:04:07+00:00 | Hey all, We've just published the first release candidate of the upcoming Relay v13 to NPM. This is very exciting for us, as it has the new version of the Relay Compiler that we've been working on for a few years now! https://github.com/facebook/relay/releases/tag/v13.0.0-rc.0 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 243] | 0 | 43 | 216 | 0 | 0 | 0 | en | ||||||||||
1466836389765402624 | swyx 33521530 | 2021-12-03T18:27:02+00:00 | @markdalgleish https://twitter.com/swyx/status/1466836389765402624/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 14] | 1466623507165417473 | 257765996 | markdalgleish | 0 | 0 | 4 | 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]);