I downloaded everything Google knows about me and queried it like a database

I knew Google had a lot on me. I didn't expect it to show up as several gigabytes of raw files that basically amounted to a relational database of my own life. So that's what I decided to do with it — I grabbed my full Google Takeout archive, dumped the JSON into a local SQLite database, and started running SQL queries against my own habits.

Read the full article at the source.