tweets
3 rows where favorite_count = 159 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, is_quote_status, retweeted
created_at (date) 3 ✖
- 2018-09-12 1
- 2021-07-29 1
- 2021-09-11 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1039903000511143936 | swyx 33521530 | 2018-09-12T15:46:10+00:00 | ⚛️Next of my op-eddy pieces on the @Netlify blog: Looking at @mweststrate's Immer, one of the most successful open source launches of 2018, and speculating on why it has taken the @reactjs community by storm this year! ⚡ 👇👇👇 https://www.netlify.com/blog/2018/09/12/the-rise-of-immer-in-react/ 👆👆👆 https://twitter.com/swyx/status/1039903000511143936/photo/1 | Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 | 0 | [0, 256] | 0 | 45 | 159 | 0 | 0 | 0 | en | ||||||||||
1420584976576286722 | kennethcassel.eth 🍊 1319269656264409088 | 2021-07-29T03:20:26+00:00 | I'm building a new course on @SlipApp! If you've ever wanted to go the extra mile and delight your users, If you've ever wanted someone to share your website because the experience made them happy, This is the course for you. I'm calling it "Animated Applications" https://twitter.com/KennethCassel/status/1420584976576286722/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 23 | 159 | 0 | 1 | 0 | en | ||||||||||
1436720513049669632 | swyx 33521530 | 2021-09-11T15:57:17+00:00 | I'm no perf expert or perf shamer (let he who is without sin...) But here's what I do believe: 1. local Lighthouse runs are not credible. Use webpagetest or http://web.dev/measure. 2. you do NOT have to use the same tech for app and site! :) https://twitter.com/swyx/status/1317635707838496768?lang=en | 1317635707838496768 1317635707838496768 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 1436689311315890177 | 33521530 | swyx | 1 | 10 | 159 | 0 | 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]);