tweets
4 rows where "created_at" is on date 2021-12-21 and favorited = 1 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1473192929414070273 | Nina 1354787371494084612 | 2021-12-21T07:25:39+00:00 | Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "what we're really talking about here is turning fixed costs to variable costs which makes sense for a startup getting off the ground." https://twitter.com/briansowards/status/1472731566732414979 | 1472731566732414979 1472731566732414979 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 255] | 1 | 2 | 12 | 1 | 1 | 0 | en | |||||||||
1473206717403959297 | swyx 33521530 | 2021-12-21T08:20:26+00:00 | RT @Nina_Ledid: Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "wh… | 1473192929414070273 1473192929414070273 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 2 | 0 | 1 | 1 | en | ||||||||||
1473316076893081602 | Coding Career Community 1249002899897647105 | 2021-12-21T15:35:00+00:00 | "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to perform, and there is space for your performance to really make an impact." @li_haoyi with some gold career advice on where to work: https://www.lihaoyi.com/post/ReflectingonFourYearsatDatabricks.html https://twitter.com/Coding_Career/status/1473316076893081602/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 4 | 17 | 1 | 1 | 0 | en | ||||||||||
1473343069819142144 | swyx 33521530 | 2021-12-21T17:22:15+00:00 | RT @Coding_Career: "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to… | 1473316076893081602 1473316076893081602 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 4 | 0 | 1 | 1 | 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]);