Build Canada Launches Canada Spends Data Portal
Build Canada, a volunteer non-profit, showcases Canada Spends on Dec. 9, 2025, a project making Canadian government financial data accessible using Datasette, sqlite-utils, Ruby ingestion scripts, and LLM-powered PDF extraction. The project hosts over 2 million rows and a denormalized search index, relying on Gemini to extract audited financial statements that are cross-checked via sums for validation. It improves transparency and reuse for analysts.
Key Points
- 1Publishes searchable government finance dataset with over 2 million rows and denormalized search index
- 2Uses Datasette, sqlite-utils, Ruby ingestion, and Gemini LLM for PDF extraction and validation
- 3Enables auditors, journalists, and analysts to explore, cross-check, and reuse public financial data programmatically
Scoring Rationale
Practical open-data release and LLM extraction tools enable reuse, but scope limited to Canadian government finance and single-source coverage.
Sources
Public references used for this report.
Practice with real Logistics & Shipping data
90 SQL & Python problems · 15 industry datasets
250 free problems · No credit card
See all Logistics & Shipping problems
