tweets
7 rows where "created_at" is on date 2021-10-12, is_quote_status = 1 and possibly_sensitive = 0
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, lang, created_at (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1447782020860375040 | swyx 33521530 | 2021-10-12T04:31:46+00:00 | @tylermcginnis @remix_run @Netlify @vercel lately ive been wondering if i’m being grossly underpaid https://twitter.com/swyx/status/1447477307141079040?s=21 | 1447477307141079040 1447477307141079040 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [43, 123] | 1447771655334338565 | 380724965 | tylermcginnis | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
| 1447783075820158985 | swyx 33521530 | 2021-10-12T04:35:58+00:00 | @adrian_twarog https://twitter.com/swyx/status/1234181016367063040?s=21 | 1234181016367063040 1234181016367063040 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 38] | 1447762596774363140 | 945877361844568064 | adrian_twarog | 1 | 0 | 3 | 0 | 0 | 0 | und | ||||||
| 1448024107618947072 | swyx 33521530 | 2021-10-12T20:33:44+00:00 | Probably my biggest test of confidence was in March when @martin_casado and @davidu pushed back on the open source religion - if your monetization is SaaS, then open source is just marketing (there's nuance here, pls read his replies before reacting) https://twitter.com/swyx/status/1373425786351284228 | 1373425786351284228 1373425786351284228 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 1448024106633363456 | 33521530 | swyx | 1 | 2 | 12 | 0 | 0 | 0 | en | ||||||
| 1448040791629185025 | swyx 33521530 | 2021-10-12T21:40:02+00:00 | Now the hard question: Could Amazon host Temporal as a service? Yes. Just like Hashicorp does (https://twitter.com/mitchellh/status/1316510643030114304?s=20), or Stripe (come learn more at our Nov meetup http://temporal.io/meetup), or {REDACTED_BIGCORP}, in a long tradition that goes back to our origins at Uber. | 1316510643030114304 1316510643030114304 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 274] | 1448027264289959938 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
| 1448047600318365697 | swyx 33521530 | 2021-10-12T22:07:05+00:00 | @temporalio The rest of OSS startup moat I reckon comes down to 2 things: - Sweat the DX: Intuitive, honest docs. Treating onboarding like game design. Handling exceptions (https://twitter.com/swyx/status/1294689838872981506?lang=en). Build a media company around domain, then build community. Mindshare -> market share. | 1294689838872981506 1294689838872981506 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 289] | 1448044941679022083 | 33521530 | swyx | 1 | 4 | 15 | 0 | 0 | 0 | en | ||||||
| 1448049750901551108 | swyx 33521530 | 2021-10-12T22:15:38+00:00 | @temporalio - Product: what else can you build to serve power users? eg Apollo Studio, MongoDB Atlas, Hashicorp Vault Companies become platforms when they ship the *2nd* blockbuster product. They become generational when their loops make any product a blockbuster. https://twitter.com/swyx/status/1367518496326709251 https://twitter.com/swyx/status/1448049750901551108/photo/1 | 1367518496326709251 1367518496326709251 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 290] | 1448047600318365697 | 33521530 | swyx | 1 | 1 | 8 | 0 | 0 | 0 | en | ||||||
| 1448053408393428996 | swyx 33521530 | 2021-10-12T22:30:10+00:00 | ok, ok, 1 more way you can beat Amazon: Support. Offer a shared Slack with SLA. Enterprise contracts are being closed on basic premise that "someone who knows what the heck is going on is on Slack with you, whether we are down or you are". Beats this: https://twitter.com/QuinnyPig/status/1402049900079026184 | 1402049900079026184 1402049900079026184 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 1448049750901551108 | 33521530 | swyx | 1 | 3 | 16 | 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]);