3 ms·
SELECT substr(date,1,7) as d, count(*), min(likes+retweets) FROM tweets GROUP BY d ORDER BY d DESC; Yep, looks like you mostly tossed tweets over a year old th
by banana_giraffe 6y ago
SELECT substr(date,1,7) as d, count(*), min(likes+retweets) FROM tweets GROUP BY d ORDER BY d DESC;
Yep, looks like you mostly tossed tweets over a year old that didn't meet some threshold. Very cool to play with in the browser.
- divyenduz 6y agoYeah, I am slowly removing myself from the internet, I don’t think that I follow anyone on any social network where ever I exist. This is also a great way to backup tweets etc. Of course I have multiple SQLite files with all the data, whenever I want to delete “more”, I just take a new Twitter dump.