tweets
6 rows where display_text_range = "[0, 226]" sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, is_quote_status, retweet_count, retweeted
created_at (date) 6 ✖
- 2021-03-27 1
- 2021-07-30 1
- 2021-08-18 1
- 2021-09-11 1
- 2021-10-01 1
- 2021-10-12 1
user 3 ✖
- swyx 4
- Lauren Tan 1
- Michelle Lim 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1375835640919642122 | Michelle Lim 788501893878312961 | 2021-03-27T15:42:33+00:00 | I wrote a new essay! Speaking Chinese can feel like speaking in tales. Many of its everyday phrases refer to specific details of historical stories. I share my favorites and their epic stories here 👇 https://www.michellelim.org/writing/speaking-in-tales/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 226] | 0 | 3 | 53 | 0 | 0 | 0 | en | ||||||||||
1421140683021164558 | swyx 33521530 | 2021-07-30T16:08:37+00:00 | I think this was the second last React talk I ever gave. Still pretty happy with it, check it out if you’re interested in how “linguistics” and developer experience cross paths (and explain the trends in our evolving tooling) https://twitter.com/iBakasura/status/1421095739195756549 | 1421095739195756549 1421095739195756549 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 226] | 1 | 0 | 2 | 0 | 0 | 0 | en | |||||||||
1428061205902630916 | Lauren Tan 2832427459 | 2021-08-18T18:28:18+00:00 | I'm sorta back from a long twitter break! I've been spending my free time slowly getting through @thorstenball's excellent "Writing A Compiler In Go" in Rust (https://github.com/poteto/monkers), and also started playing FFXIV again lol. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 226] | 0 | 4 | 97 | 0 | 1 | 0 | en | ||||||||||
1436643604085235714 | swyx 33521530 | 2021-09-11T10:51:41+00:00 | @smc90 tries to get @BillCarr89 to defend "Are Right A Lot" in this podcast/blogpost on Future dot com and i'm sorry but blaming your direct reports for letting you ignore them is pretty damn toxic wtf https://future.a16z.com/podcasts/working-backwards-amazon-bezos-memos-releases-narratives/ https://twitter.com/swyx/status/1436643604085235714/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 226] | 1390439828571922432 | 33521530 | swyx | 0 | 0 | 11 | 0 | 0 | 0 | en | |||||||
1443843044386619394 | swyx 33521530 | 2021-10-01T07:39:41+00:00 | Wasn’t planning on it but just binged all of #SquidGame in one night. Holy crap it is so well written, directed, and acted! Also I guess I am a sucker for sudden death games (i loved Circle). Favorite memes without context: https://twitter.com/swyx/status/1443843044386619394/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 226] | 0 | 12 | 186 | 0 | 0 | 0 | en | ||||||||||
1448027264289959938 | swyx 33521530 | 2021-10-12T20:46:17+00:00 | They didn't ask permission to do that. We didn't anticipate them doing that. But they did it anyway. Every month our users teach us something new about the platform we built – because Open Source. https://community.temporal.io/t/using-dynamic-task-queues-for-traffic-routing/3045 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 226] | 1448027262121496578 | 33521530 | swyx | 0 | 3 | 24 | 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]);