LCBO Car Fuel Index

Pull the LCBO REST API into a ~200MB sqlite database. Originally intended to be used to figure out the least expensive volume of ethanol at a specific location, but can be used to explore other interesting correlations.

Requirements

• Linux, MacOS, or WSL under Windows.
• nix

Usage

Open a shell with the dependencies.

$ nix-shell

Scrape api.lcbo.com into a sqlite database, as defined in .env.

$ bin/fetch all # Takes about 1hr
$ bin/tune-db

Optionally, explore the data with metabase

$ metabase

Questions

• Most represented country, alcohol, etc by total volume, price adjusted, etc.
• Wine vs Beer popularity
• Geographic distributions