tweets
6 rows where display_text_range = "[0, 269]" and retweeted = 1
This data as json, CSV (advanced)
Suggested facets: source, is_quote_status, favorited, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1311191397085491200 | swyx 33521530 | 2020-09-30T06:29:24+00:00 | Ancient Chinese had a saying: 修身, 齐家, 治国, 平天下. Fix yourself, your family, your country, then go for world peace. In that order. Shit's fucked up. You're allowed to be upset. But calibrate to your circle of influence. If it's too small, grow it. Doing > Yelling. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 123 | 729 | 0 | 1 | en | |||||||||||
1426405785832095749 | Charity Majors 90488576 | 2021-08-14T04:50:15+00:00 | Ever wondered what columnar databases are, or peered skeptically at my claim that you basically can't have observability without one? Read this piece, and wonder no more. (Also HOLY SHIT this blew my mind and is my favorite article of 2021 to date! Five stars ⭐⭐⭐⭐⭐) 🤣 https://twitter.com/honeycombio/status/1425853831775129601 | 1425853831775129601 1425853831775129601 | San Francisco 5a110d312052166f | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 269] | 1 | 43 | 243 | 0 | 1 | 0 | en | ||||||||
1427363684037369866 | Will Lawrence ⭕️ 840115172 | 2021-08-16T20:16:36+00:00 | Still in love with this piece by @swyx. I feel like creating + working is a good mix for me. My work informs my writing and my writing helps me be better in my job. The challenge is managing scope creep when creating. Timeboxing helps here ☺️ https://www.swyx.io/part-time-creator-manifesto/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 2 | 25 | 0 | 1 | 0 | en | ||||||||||
1429608015057981446 | Ben Thompson 40273 | 2021-08-23T00:54:46+00:00 | If I could convince everyone in the world to read and understand one article about COVID it would be this one. FWIW it very closely tracks the understanding I’ve developed over many months now, and explains all of the twists and turns to date. https://cspicenter.org/blog/waronscience/why-covid-19-is-here-to-stay-and-why-you-shouldnt-worry-about-it/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 269] | 0 | 295 | 1430 | 0 | 1 | 0 | en | ||||||||||
1446268135078699012 | Common Room 1331053779341348864 | 2021-10-08T00:16:08+00:00 | It's @swyx! Head of Developer Experience at @temporalio and tech meetup connoisseur. We asked Shawn everything from his favorite part of working in community (it's an "infinite game") to advice he'd give now, and none of the answers disappoint. https://www.commonroom.io/uncommon/blog/the-rise-of-the-community-leader-meet-shawn-wang/?utm_medium=social&utm_source=twitter&utm_campaign=TL&utm_content=rise-of-the-community-leader | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 5 | 18 | 0 | 1 | 0 | en | ||||||||||
1470489155725578262 | Arthur Wu 🍊 2477624389 | 2021-12-13T20:21:49+00:00 | What makes Gmail performant is different than what makes Instagram performant. In "Application Holotypes", @_developit made a starting taxonomy of web app types and good architecture traits for each one. Many cite it as an impt read, and I've made it more visual 🧵: https://twitter.com/arthurwuhoo/status/1470489155725578262/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 15 | 69 | 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]);