Skip to content

Latest commit

 

History

History
35 lines (23 loc) · 808 Bytes

README.md

File metadata and controls

35 lines (23 loc) · 808 Bytes
Raw

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