tweets
8 rows where "created_at" is on date 2021-07-27 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, 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 | |||||||||
| 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 | |||||||||||
| 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 |
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]);