tweets
2 rows where "created_at" is on date 2021-10-11 and in_reply_to_user_id = 14756283 sorted by lang
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1447375260366499842 | swyx 33521530 | 2021-10-11T01:35:27+00:00 | @dunkhippo33 i’d love to hear from someone from this gov group - i think the Morris story is well told by now but governments everywhere will want to know the story and process of how this group did their thing. reshaped a nation for decades! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 242] | 1447291667552235520 | 14756283 | dunkhippo33 | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1447376702401769478 | swyx 33521530 | 2021-10-11T01:41:11+00:00 | @dunkhippo33 idk if this is nitpicking but if you are referring to gross margins, this would make sense for capex heavy products and be offset by depreciation. capex heavy commodity products *need* high gross margins as a biz model however TSMC has 30% op margin so your point stands :) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 287] | 1447291681909268483 | 14756283 | dunkhippo33 | 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]);