tweets
5 rows where display_text_range = "[0, 240]" sorted by coordinates
This data as json, CSV (advanced)
Suggested facets: user, favorited, retweeted, created_at (date)
source 2 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1417165270641045505 | swyx 33521530 | 2021-07-19T16:51:44+00:00 | I'm excited to finally share why I've joined @temporalio as Head of Developer Experience! Here's my explainer on 3 core opinions of Temporal, why they're hard to do well, and the business opportunities it presents: https://www.swyx.io/why-temporal/ | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 240] | 0 | 30 | 396 | 0 | 0 | 0 | en | ||||||||||
| 1421069160973434880 | Andrew Gazdecki 1511333035 | 2021-07-30T11:24:24+00:00 | July update for @microacquire! - $700,000 in ARR - 16% MoM growth - $400m combined revenue - $82m combined revenue in July - 34% company size increase YTD - 4x'ed registered buyers in 2021 - 250+ startups listed More micro-details below 👇 https://twitter.com/agazdecki/status/1421069160973434880/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 240] | 0 | 36 | 569 | 0 | 0 | 0 | en | ||||||||||
| 1427351643985629212 | swyx 33521530 | 2021-08-16T19:28:45+00:00 | 💡 Product focused DevRel is the most ill-defined path. Most devrels spend most of their time advocating TO developers than FOR them. But DevRel can provide tremendous value for product launches and building integrations, tooling, and MVPs. https://twitter.com/swyx/status/1427351643985629212/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 240] | 1427351641095753755 | 33521530 | swyx | 0 | 3 | 17 | 0 | 0 | 0 | en | |||||||
| 1454261201207054339 | swyx 33521530 | 2021-10-30T01:37:43+00:00 | Soft shipped the new https://docs.temporal.io/ Many thanks to @thisismahmoud_, @flossypurse, @taillogs and others, and built with @docusaurus and now @tailwindcss Shipped fearlessly on Friday afternoon thanks to @Netlify immutable deploys 💪 https://twitter.com/swyx/status/1454261201207054339/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 240] | 0 | 7 | 79 | 0 | 0 | 0 | en | ||||||||||
| 1460974396382736391 | Den Delimarsky 47547933 | 2021-11-17T14:13:34+00:00 | Today we're taking the first step in making integrating web services in your web applications easier - API Authentication on @Netlify ✨ No more writing auth code from scratch for every API you use. 👉 How it works: https://ntl.fyi/api-auth https://twitter.com/DennisCode/status/1460974396382736391/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 240] | 0 | 16 | 147 | 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]);