tweets
9 rows where display_text_range = "[0, 264]"
This data as json, CSV (advanced)
Suggested facets: user, is_quote_status, retweet_count, favorited, retweeted, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1197199873331757056 | swyx 33521530 | 2019-11-20T17:07:47+00:00 | I think one of the best non-invasive (aka no surveying needed) metrics of company morale is employee referrals. If referrals are consistent and/or going up, you're doing great. If they're going down or nonexistent, look out. Even applies on a per employee basis. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 0 | 4 | 50 | 0 | 0 | en | |||||||||||
| 1427353055519920136 | swyx 33521530 | 2021-08-16T19:34:22+00:00 | Ultimately I hope for more intellectual honesty in this industry between merely "justifying your existence" and enabling creative risktaking and building multi-year relationships that don't fit in OKR review cycles. You can read more here: https://www.swyx.io/measuring-devrel/ https://twitter.com/swyx/status/1427353055519920136/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 1427351643985629212 | 33521530 | swyx | 0 | 1 | 11 | 0 | 0 | 0 | en | |||||||
| 1429501377722474496 | swyx 33521530 | 2021-08-22T17:51:01+00:00 | Sad to see @brianmcc sunset the Techmeme Ride Home+ podcast. The premise was exclusive interviews, but interviewees canceled when they learned he (#3 ranked podcaster in Tech News) only had 300 paying subs (@$5/mo). Big blow for @awilkinson's @supercast thesis? https://twitter.com/austin_rief/status/1393966359197933568 | 1393966359197933568 1393966359197933568 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 1 | 0 | 3 | 0 | 0 | 0 | en | |||||||||
| 1431454427668434944 | swyx 33521530 | 2021-08-28T03:11:45+00:00 | ❗ Total WTFs per Year Anyone can design for the happy path. Great DX handles not only the good, but also the bad AND the ugly: - Errors that don't make me think - Billing that is predictable and boring - Proactive warning of known issues https://twitter.com/swyx/status/1294689838872981506 | 1294689838872981506 1294689838872981506 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 1431454426175352837 | 33521530 | swyx | 1 | 0 | 8 | 0 | 0 | 0 | en | ||||||
| 1453585223594041351 | swyx 33521530 | 2021-10-28T04:51:38+00:00 | just found out Garry blocked me :( this was our last interaction…which he retweeted so i think he was ok with it? people can block or mute however they want, and i try not to care. but it hurts a little when its someone i look up to and i dont know what i did :( | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 264] | 1394440978199506947 | 33521530 | swyx | 0 | 1 | 17 | 0 | 0 | en | ||||||||
| 1455955781317132295 | Lucas Minter 1215752268160499712 | 2021-11-03T17:51:23+00:00 | @swyx has inspired me to make a public commitment: Next Friday, I'm going to kick off a book club with friends. We are going to read the @Coding_Career Handbook. We will meet once a week over zoom to discuss our takeaways. If anyone wants to join, send me a dm. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 33521530 | swyx | 0 | 5 | 25 | 1 | 1 | en | |||||||||
| 1456668099739111424 | Aliza Aufrichtig 49150150 | 2021-11-05T17:01:53+00:00 | Tune in today at 2pm ET / 11am PT to hear @Rich_Harris and me talk with my dear old pal @jeanqasaur on #PLTalk about the journey from JavaScript to TypeScript on the NYT coronavirus tracker, amongst other fun topics. Just one hour away! https://www.twitch.tv/jeanqasaur | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 0 | 6 | 38 | 1 | 1 | 0 | en | ||||||||||
| 1460973352613388290 | OneGraph 881672363779149824 | 2021-11-17T14:09:25+00:00 | Some exciting news for us and our customers - OneGraph is joining @Netlify! We'll make building on and connecting APIs in the modern web delightful for millions of devs. And we're also launching our first integration, API Authentication! https://www.onegraph.com/blog/post/9/onegraph-is-joining-netlify https://twitter.com/onegraph/status/1460973352613388290/photo/1 | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [0, 264] | 0 | 35 | 228 | 1 | 1 | 0 | en | ||||||||||
| 1464265965546483722 | Lea Verou 22199970 | 2021-11-26T16:13:05+00:00 | New blog post! On Yak Shaving and <md-block>, a new HTML element for Markdown https://lea.verou.me/2021/11/on-yak-shaving-and-md-block-an-html-element-for-markdown/ It talks about how my multi-levels deep yak shaving this week led me to create and release a new web component for Markdown, as well as Stretchy v2. Enjoy! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 0 | 14 | 62 | 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]);