Location History Extractor

This tool turns your Google Maps location history into a database.

It is crafted in Clojure and executed using nbb with Node.js. Its only dependency is sql.js.

Requirement: Node.js v18 or newer.

To install the necessary dependencies, run npm install.

Grab your location history from Google Takeout and unzip the file. Find those per-month timeline JSON files tucked away in Location History/Semantic Location History/.

Run the script on one or more files:

npm run timeline2sqlite 2023_MAY.json 2023_JUNE.json

This will generate a database named places.sqlite, overwriting it if it already exists. Open this file using the sqlite CLI, Datasette, or any other database management tool.