Statcan Table
statcan_tableWhole StatCan table (or a filtered slice) in ONE call, from a local Pipeworx copy of the table — full history, every coordinate, member labels included, instead of one coordinate per call. Use this instead of statcan_cube_data when the question spans more than one coordinate ("compare all provinces", "the whole eggs/milk/hydro table", "full history for this table"), or instead of statcan_csv_url when you need the DATA rather than a download URL. Covers a curated set of high-demand StatCan product ids only — call with just product_id to check coverage; an uncached product_id REFUSES with a clear message naming what is cached, it does not return an empty result. Data refreshes weekly from StatCan's official getFullTableDownloadCSV export; every response carries data_as_of. Statistics Canada Open Licence permits redistribution.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| geo | No | Optional: case-insensitive substring filter on the GEO column, e.g. "Quebec" or "Ontario". | |
| page | No | Page number, 1-based (default 1). | |
| limit | No | Max rows per page (default 500, max 1000). | |
| coordinate | No | Optional: restrict to one coordinate (as in statcan_cube_data), e.g. "1.1.1.1". Omit for the whole table. | |
| product_id | Yes | StatCan cube product ID, e.g. 42100037. | |
| ref_date_to | No | Optional: only rows with ref_date <= this value. | |
| ref_date_from | No | Optional: only rows with ref_date >= this value (matches the table's own date grain, e.g. "2022" or "2022-01"). |