tweets
3 rows where favorite_count = 16 and retweet_count = 3
This data as json, CSV (advanced)
Suggested facets: user, is_quote_status, favorited, created_at (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1448053408393428996 | swyx 33521530 | 2021-10-12T22:30:10+00:00 | ok, ok, 1 more way you can beat Amazon: Support. Offer a shared Slack with SLA. Enterprise contracts are being closed on basic premise that "someone who knows what the heck is going on is on Slack with you, whether we are down or you are". Beats this: https://twitter.com/QuinnyPig/status/1402049900079026184 | 1402049900079026184 1402049900079026184 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 1448049750901551108 | 33521530 | swyx | 1 | 3 | 16 | 0 | 0 | 0 | en | ||||||
1451156477587116040 | Jannik Wempe 1116441589012934657 | 2021-10-21T12:00:40+00:00 | You have a lot of influence on how much luck you have. Maybe you can't change the odds themselves, but you can change the "Luck Surface Area". This article by @swyx made me think quite a lot the last few days 🤔 https://www.swyx.io/create-luck/ | FeedHive.io 6746f3a6d1b3aa371a4a2dc1c08c7862cd6e911e | 0 | [0, 237] | 0 | 3 | 16 | 1 | 1 | 0 | en | ||||||||||
1464157681346748418 | swyx 33521530 | 2021-11-26T09:02:48+00:00 | Coworker got me hooked on @PokemonUnite recently. always struggled with the learning curve on MOBA games like LoL and HoTS but this is just perfect esp for busy parents (~10mins per game, low learning curve). add me @iamtanker if you play! https://twitter.com/swyx/status/1464157681346748418/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 239] | 0 | 3 | 16 | 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]);