This article highlights 'Canada Spends,' a project by Build Canada, a volunteer-driven non-profit, aimed at democratizing Canadian government financial data. The initiative leverages Datasette for data exploration and combines custom frontend design with Ruby ingestion scripts and sqlite-utils. A key innovation is the use of LLM-powered PDF extraction, specifically Google's Gemini, to process audited financial statements—a common but challenging source of government data. The article also touches upon the project's data sources, crowdsourcing efforts, ingestion code, and the rationale behind using SQLite for data distribution. It emphasizes the project's goal of transparency and accessibility for complex government financial information.

