tweets
4 rows where favorite_count = 30 and is_quote_status = 1 sorted by truncated
This data as json, CSV (advanced)
Suggested facets: source, display_text_range
created_at (date) 3 ✖
- 2021-09-03 2
- 2021-09-29 1
- 2021-11-22 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1433718525420470279 | swyx 33521530 | 2021-09-03T09:08:28+00:00 | If you work in Silicon Valley, or in the technology world, and you can explain complex topics / terms in an easy to understand* way, that’s an INSANELY valuable skill. *But don’t gloss over the details! All the good stuff is in the details - develop a keen eye for those! https://twitter.com/BullandBaird/status/1433424538025349120 | 1433424538025349120 1433424538025349120 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 272] | 1 | 2 | 30 | 0 | 0 | 0 | en | |||||||||
1433918146348343297 | swyx 33521530 | 2021-09-03T22:21:41+00:00 | I think why I struggle with OKRs so much: Suits set them as a system of external control, a way to manage by spreadsheet rather than get hands dirty, defining quality as quantity, when the best work of knowledge workers and creatives comes from doing epic shit for the sake of it. https://twitter.com/petergyang/status/1433807042590875654 | 1433807042590875654 1433807042590875654 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 1 | 30 | 0 | 0 | 0 | en | |||||||||
1443093060473090051 | swyx 33521530 | 2021-09-29T05:59:31+00:00 | It’s been incredible to watch @nutlope’s career grow ever since he joined webdev twitter in college! He’s been a daily positive presence in the @Coding_Career discord and I feel lucky to have met him before he was “famous” Great hire by @leeerob and @rauchg — only the beginning! https://twitter.com/Nutlope/status/1442926717635477504 | 1442926717635477504 1442926717635477504 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 2 | 30 | 0 | 0 | 0 | en | |||||||||
1462895745615351808 | swyx 33521530 | 2021-11-22T21:28:19+00:00 | My favorite nontraditional measure of dev community traction is # of mentions in job descriptions. By this measure, @Temporalio is in incredibly good company for a 2 year old startup: https://temporal.io/careers#external-jobs Help your users hire/get hired and they will be loyal for life. https://twitter.com/swyx/status/1427351638872772633 https://twitter.com/swyx/status/1462895745615351808/photo/1 | 1427351638872772633 1427351638872772633 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 297] | 1 | 1 | 30 | 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]);