tweets
5 rows where in_reply_to_screen_name = "gr2m" sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, is_quote_status
created_at (date) 3 ✖
- 2021-08-10 2
- 2021-12-07 2
- 2021-11-23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1425211431104835585 | swyx 33521530 | 2021-08-10T21:44:18+00:00 | @gr2m its great! but it is very flaky: https://github.com/sw-yx/gh-action-data-scraping/actions?query=is%3Afailure 2 failures in the last day alone | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 96] | 1425210809555177472 | 11754732 | gr2m | 0 | 0 | 7 | 0 | 0 | 0 | en | |||||||
1425212958460633089 | swyx 33521530 | 2021-08-10T21:50:23+00:00 | @gr2m and version controlled! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 29] | 1425212570424668162 | 11754732 | gr2m | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1463069720802783244 | swyx 33521530 | 2021-11-23T08:59:38+00:00 | @gr2m @temporalio we frame it as “It is designed with TypeScript-first developer experience in mind, but works equally well with JavaScript.” in our docs this is because the team feels strongly that type safety should be heavily recommended as part of the DX of using Temporal. Eliminates footguns | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 298] | 1462998929562214404 | 11754732 | gr2m | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1468016734044966914 | swyx 33521530 | 2021-12-07T00:37:18+00:00 | @gr2m i discussed the SDKs over APIs thesis here at the 27ish minute mark! https://twitter.com/swyx/status/1467978846150430724 | 1467978846150430724 1467978846150430724 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 98] | 1452803275930017794 | 11754732 | gr2m | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1468027532033200130 | swyx 33521530 | 2021-12-07T01:20:12+00:00 | @gr2m haha im the king of necrotweeting | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 39] | 1468022591440912388 | 11754732 | gr2m | 0 | 0 | 1 | 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]);