tweets
3 rows where favorite_count = 64 sorted by lang
This data as json, CSV (advanced)
Suggested facets: retweeted
created_at (date) 3 ✖
- 2021-05-20 1
- 2021-08-15 1
- 2021-11-23 1
user 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1395172543565344770 | swyx 33521530 | 2021-05-20T00:20:30+00:00 | 🆕 How to Optimize for Change My first post on the @freeCodeCamp blog in a while! 2 years ago, @dan_abramov told us *why* to optimize for change. Ever since then, I've been exploring the obvious next question: How? https://www.freecodecamp.org/news/how-to-optimize-for-change-software-development/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 243] | 0 | 5 | 64 | 0 | 0 | 0 | en | ||||||||||
1426937335460114441 | Maggie Appleton 🧭 1343443016 | 2021-08-15T16:02:26+00:00 | @swyx 17. This collection has now matured into a full grown essay documenting the history of "digital gardening" as an ethos 🌲 https://maggieappleton.com/garden-history | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 150] | 1260966673714221056 | 1343443016 | Mappletons | 0 | 16 | 64 | 0 | 1 | 0 | en | |||||||
1463282463333965826 | swyx 33521530 | 2021-11-23T23:05:00+00:00 | Building community is so underrated. The "product" is the friends we made along the way! But when it gets ugly it can get really ugly. Higher highs, lower lows. People are messy. 3 main tools to manage this: - Code of Conduct - Mission, Vision, Values - Accountability/Checks | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 4 | 64 | 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]);