tweets
5 rows where favorite_count = 37 and favorited = 0
This data as json, CSV (advanced)
Suggested facets: user, source, is_quote_status, retweet_count, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1394332453892984835 | Dana Jones 5994002 | 2021-05-17T16:42:17+00:00 | Enough folks were interested that I have written up my thoughts on Identifying Checkout Behavior: recognizing signs of when an employee might be considering a breakup with your company. http://danabrit.blogspot.com/2021/05/identifying-checkout-behavior.html https://twitter.com/danabrit/status/1392515208611041283 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 209] | 1 | 1 | 37 | 0 | 0 | 0 | en | ||||||||||
1420428079294402563 | swyx 33521530 | 2021-07-28T16:56:59+00:00 | @DavidKPiano @threepointone 👆🏽 hey uh... you guys want to do a debate, with me as moderator? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 93] | 1420426673518960641 | 992126114 | DavidKPiano | 0 | 0 | 37 | 0 | 0 | en | ||||||||
1422286558070116359 | swyx 33521530 | 2021-08-02T20:01:54+00:00 | Got a 6 figure acquisition offer for @Coding_Career it just automated @IndieHackers email spam (they have no idea it's a book lol) but its nice to be reminded that its still selling decently after 13 months — thats even before v2.0 Infoproducts > SaaS for beginner creators https://twitter.com/swyx/status/1422286558070116359/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 0 | 0 | 37 | 0 | 0 | 0 | en | ||||||||||
1452464233996853249 | swyx 33521530 | 2021-10-25T02:37:13+00:00 | Read my latest: “[http://swyx.io] When You Stop Counting” https://www.getrevue.co/profile/swyx/archive/794799 | Revue e01d36c55a12ec4cf389049ec42665dce335b54e | 0 | [0, 90] | 0 | 2 | 37 | 0 | 0 | 0 | en | ||||||||||
1457799479076134917 | swyx 33521530 | 2021-11-08T19:57:35+00:00 | As much as I love studying past failures and successes, I definitely think that more people suffer from curse of knowledge/analysis paralysis than are helped by it. Those who don't bother learning history are 10x more likely to make it? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 237] | 0 | 0 | 37 | 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]);