tweets
18 rows where "created_at" is on date 2021-07-27 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1419836176681213952 | swyx 33521530 | 2021-07-27T01:44:58+00:00 | Suddenly reminded of this @bcantrill talk: https://youtu.be/30jNsCVLpAE and I think I have my answer - If it takes you 2 days to chase down an intermittent bug, perhaps that *IS* the bug. Even though this talk is 4 years old but feels like @mipsytipsy is beating the same drum today. https://twitter.com/swyx/status/1419434119319093250 | 1419434119319093250 1419434119319093250 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 3 | 15 | 0 | 0 | 0 | en | |||||||||
| 1419880024929415173 | Loren 🤓 215488966 | 2021-07-27T04:39:12+00:00 | Is it just me or can the 2nd edition of Designing Data-Intensive Applications be: "Just use @apollographql Federation for reads and @temporalio for writes" 😄 1/4 https://twitter.com/lorendsr/status/1419880024929415173/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 163] | 0 | 9 | 34 | 0 | 1 | 0 | en | ||||||||||
| 1420012738412220425 | Amanda Goetz 23698119 | 2021-07-27T13:26:34+00:00 | Things I know at 35, I wish I had known at 25. 🧵/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 52] | 0 | 8283 | 34444 | 0 | 0 | en | |||||||||||
| 1420043000344768517 | Supabase 1219566488325017602 | 2021-07-27T15:26:49+00:00 | #supalaunchweek Day 2: 🔥 Supabase Storage is now in Beta 🔥 https://supabase.io/blog/2021/07/27/storage-beta - Streaming Media - Public Buckets - NodeJS support - Storage supported in Local Emulator - Upload folders - Updated Policy editor - Performance improvements to handle recursive cat uploads 😹 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 32 | 204 | 0 | 1 | 0 | en | ||||||||||
| 1420050980310183936 | swyx 33521530 | 2021-07-27T15:58:31+00:00 | This is an incredible video: https://twitter.com/discord/status/1418617539404308482?s=20 Writeup: https://blog.discord.com/meet-the-discord-users-who-imagined-a-place-657325b75fa6 It's a quirky amalgam of Discord memes with Awkwafina, Danny Devito, Grimes, MKBHD, flying flaming cows, and eggs. Totally ineffective at explaining what Discord is, but captures how it FEELS. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1378408503597965316 | 33521530 | swyx | 1 | 1 | 8 | 0 | 0 | 0 | en | |||||||
| 1420051311244894220 | swyx 33521530 | 2021-07-27T15:59:50+00:00 | @willjohnsonio record yourself on a podcast every day :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 56] | 1420043153516765193 | 917069583097397248 | willjohnsonio | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1420053240717086721 | John Ousterhout 2730347034 | 2021-07-27T16:07:30+00:00 | I'm excited to announced that I've just released the 2nd Edition of "A Philosophy of Software Design". See https://web.stanford.edu/~ouster/cgi-bin/book.php for more info (including free download of new chapters). | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 187] | 0 | 179 | 670 | 0 | 0 | 0 | en | ||||||||||
| 1420055275847839746 | swyx 33521530 | 2021-07-27T16:15:35+00:00 | RT @lorendsr: Is it just me or can the 2nd edition of Designing Data-Intensive Applications be: "Just use @apollographql Federation for re… | 1419880024929415173 1419880024929415173 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 9 | 0 | 0 | 1 | en | ||||||||||
| 1420085405349662721 | Dominik Tornow 1125559272232837121 | 2021-07-27T18:15:19+00:00 | @temporalio is all about scalability and reliability while guaranteeing functional correctness. There is a lot to unpack here! 🧵 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 130] | 1204202807298969600 | temporalio | 0 | 7 | 22 | 0 | 1 | en | |||||||||
| 1420086929261961217 | swyx 33521530 | 2021-07-27T18:21:22+00:00 | Feeling this again. Really humbling to interview people (eg early Google and Docker) and understanding how great problems attract great talent. https://twitter.com/swyx/status/1189555830544355330 | 1189555830544355330 1189555830544355330 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 143] | 1 | 0 | 26 | 0 | 0 | 0 | en | |||||||||
| 1420104010313265152 | swyx 33521530 | 2021-07-27T19:29:14+00:00 | @DavidAMaier @temporalio haha thanks! urgently? what do you mean? happy to chat offline but also could be useful for others if you elaborated | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 141] | 1420102177310314504 | 1200337361734946817 | DavidAMaier | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1420118742898380801 | swyx 33521530 | 2021-07-27T20:27:47+00:00 | @BenLesh github follows > twitter follows, this is straight facts | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 68] | 1420065552505114628 | 23795212 | BenLesh | 0 | 0 | 40 | 0 | 0 | en | ||||||||
| 1420119069324300291 | swyx 33521530 | 2021-07-27T20:29:05+00:00 | @willklein_ i need question prompts for a blogpost! esp from new dev advocates like @Nutlope @kevmodrome and @jkup. what are your nonobvious concerns and questions! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 164] | 1420099879481667584 | 17496447 | willklein_ | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1420126851314323456 | swyx 33521530 | 2021-07-27T21:00:00+00:00 | @DavidAMaier @temporalio awesome!! @code_barbarian is ramping up more samples and docs on our Node SDK, perhaps a good opportunity to make sure our stuff speaks to your usecases. Join the slack (http://temporal.io/slack) and give feedback anytime! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 246] | 1420120479428399110 | 1200337361734946817 | DavidAMaier | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
| 1420135785987117060 | Cindy Sridharan 161667651 | 2021-07-27T21:35:30+00:00 | Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even if the second edition just had minor typo fixes, I’d buy it and read it all over again! https://twitter.com/JohnOusterhout/status/1420053240717086721 | 1420053240717086721 1420053240717086721 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 207] | 1 | 6 | 86 | 0 | 1 | 0 | en | |||||||||
| 1420136685472342016 | swyx 33521530 | 2021-07-27T21:39:05+00:00 | RT @copyconstruct: Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even… | 1420135785987117060 1420135785987117060 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 1 | 6 | 0 | 0 | 1 | en | ||||||||||
| 1420136958416678912 | swyx 33521530 | 2021-07-27T21:40:10+00:00 | @zpao ooh you doing much CNCF work? we’ve just joined at the startup tier… trying to figure out how to navigate this behemoth ecosystem | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 135] | 1420136460087218180 | 764166 | zpao | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1420141917812060163 | swyx 33521530 | 2021-07-27T21:59:52+00:00 | @zpao easy to have a huge ecosystem when everyone has their own definition of what you mean! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 92] | 1420138159405367299 | 764166 | zpao | 0 | 0 | 1 | 0 | 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]);