tweets
12 rows where "created_at" is on date 2021-08-11, is_quote_status = 0 and possibly_sensitive = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, retweet_count, favorite_count, retweeted, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1425253637979181061 | swyx 33521530 | 2021-08-11T00:32:01+00:00 | @ritakozlov_ it does look good! the problem (that we are also wrestling with) is when you tie API to cron its hard to do some things like "every 3rd wednesday" or "last day of the month" as this code sample was probably trying to do also we're designing for long running wfs that may overlap https://twitter.com/swyx/status/1425253637979181061/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 293] | 1425240576975278080 | 232076816 | ritakozlov_ | 0 | 0 | 5 | 0 | 0 | 0 | en | |||||||
1425476793327259651 | Trung Phan 🇨🇦 945817135816654848 | 2021-08-11T15:18:46+00:00 | 12/ Quick video cut of @elonmusk breaking down SpaceX’s 5-Step design and manufacturing process: https://twitter.com/TrungTPhan/status/1425476793327259651/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 96] | 1425474192925888515 | 945817135816654848 | TrungTPhan | 0 | 439 | 1935 | 0 | 1 | 0 | en | |||||||
1425487171172044815 | React Summit 🗓 June 17 & 21, 2022 3023155108 | 2021-08-11T16:00:00+00:00 | There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might trap yourself. @swyx zooms out from the state management library du jour to see what timeless lessons we can learn from #ReactJS: https://buff.ly/37tzisJ | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 274] | 0 | 6 | 11 | 0 | 1 | 0 | en | ||||||||||
1425505817827151872 | GitHub 13334762 | 2021-08-11T17:14:06+00:00 | 🤫 New shortcut: Press . on any GitHub repo. https://twitter.com/github/status/1425505817827151872/video/1 | Sprout Social 2feaa4497dbf2f5efce3ede84518b1db6517855c | 0 | [0, 44] | 0 | 5013 | 17116 | 0 | 0 | 0 | en | ||||||||||
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 | ||||||||||
1425529550377684996 | swyx 33521530 | 2021-08-11T18:48:24+00:00 | This move by @GitHub is bold and inspiring. https://github.blog/2021-08-11-githubs-engineering-team-moved-codespaces/ With GitHub aggressively dogfooding Codespaces, cloud dev environments just went from "haha cute toy" to "OK this has serious enterprise investment". You're also now using Azure without knowing it. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 266] | 0 | 62 | 368 | 0 | 0 | 0 | en | ||||||||||
1425560858353049601 | rita ❄️ 232076816 | 2021-08-11T20:52:48+00:00 | @swyx so i was totally wrong, and we do support that. TIL! thanks @_AlbertZhao for helping me figure it out! i present to you: third wednesday // last day of the month 👇 https://twitter.com/ritakozlov_/status/1425560858353049601/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 171] | 1425253637979181061 | 33521530 | swyx | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1425563097679372288 | swyx 33521530 | 2021-08-11T21:01:42+00:00 | @jbrancha @jessmartin @sidekiq yea exactly which was a bit of a surprise. is this the canonical one people use? https://github.com/ondrejbartas/sidekiq-cron | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [31, 135] | 1425234729708761090 | 190881605 | jbrancha | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1425564100256428032 | swyx 33521530 | 2021-08-11T21:05:41+00:00 | @laueist thank you for the tip! i wouldnt have thought of it. is this the canonical resource https://laravel.com/docs/8.x/scheduling any others you'd recommend? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 144] | 1425345686745272324 | 1145669760354607104 | laueist | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1425567535953448961 | swyx 33521530 | 2021-08-11T21:19:20+00:00 | @kirillgroshkov i've never used them, thank you for the pointer! https://cloud.google.com/tasks | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 88] | 1425226757645508610 | 2401378934 | kirillgroshkov | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1425599061063659526 | swyx 33521530 | 2021-08-11T23:24:37+00:00 | @maiertech @github ah you seem like the perfect person to ask... can it run docker compose? basically i'd like a one click "deploy to codespaces" button for this https://github.com/temporalio/docker-compose but all the examples i see are too simplistic | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 231] | 1425594330245382146 | 226148486 | maiertech | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1425569201670918149 | swyx 33521530 | 2021-08-11T21:25:58+00:00 | @tomcritchlow https://github.com/Bloomberg-Beta/Manual | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 37] | 1425568608160190471 | 6419982 | tomcritchlow | 0 | 0 | 1 | 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]);