tweets
5 rows where in_reply_to_screen_name = "sheldon_hull" sorted by lang
This data as json, CSV (advanced)
Suggested facets: favorite_count
created_at (date) 5 ✖
- 2021-08-28 1
- 2021-08-29 1
- 2021-10-21 1
- 2021-11-01 1
- 2021-12-19 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431728032167903237 | swyx 33521530 | 2021-08-28T21:18:57+00:00 | @sheldon_hull @temporalio ive never used Systems Manager! write that post! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 74] | 1431724797269004298 | 247477081 | sheldon_hull | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1431843588032262146 | swyx 33521530 | 2021-08-29T04:58:08+00:00 | @sheldon_hull nice! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 19] | 1431807700011307009 | 247477081 | sheldon_hull | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1450994309763796995 | swyx 33521530 | 2021-10-21T01:16:16+00:00 | @sheldon_hull @missingfaktor im gonna start ReusableButton Inc just for shits and giggles | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 89] | 1450993980112609281 | 247477081 | sheldon_hull | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1455313062915821570 | swyx 33521530 | 2021-11-01T23:17:27+00:00 | @sheldon_hull oh nice.. is powershell something that is default on most macs? my goal was to learn “universal” skills. never really come across pwsh scripts til today | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 166] | 1455311583488487428 | 247477081 | sheldon_hull | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1472636601796730880 | swyx 33521530 | 2021-12-19T18:35:00+00:00 | @sheldon_hull 3 of those 4 locations are free to access and the aquarium costs like 20 bucks. there is high inequality yes but it happens in private islands and compounds and stuff whereas the big things are all pretty accessible to all. migrant labor quality of life isnt great, I’ll say that | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 294] | 1472632603333251074 | 247477081 | sheldon_hull | 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]);