Statistics Canada Web Data Service Scraper

Statistics Canada Web Data Service Scraper

Scrape Statistics Canada cubes, vectors, and time-series data directly from the Web Data Service. Get full catalogue listings, cube metadata, or the latest N periods of any economic indicator. No API key required. Export to CSV, JSON, Excel, or XML.

Statistics Canada's Web Data Service (WDS) is the authoritative source for Canadian economic and social data, but navigating its cube and vector structure programmatically is complex. This Actor reads the public SODA-compliant API endpoints directly, fetching catalogue entries, cube metadata, or time-series observations by product ID or vector ID. You get clean, flat rows ready for analysis without building a custom client.

Who uses it	What they scrape Statistics Canada for
Economic analysts	Pull the latest CPI, GDP, or labour force survey figures into a spreadsheet automatically.
Data journalists	Fetch building permit, trade, or demographic data for a story on regional trends.
Academic researchers	Assemble time-series datasets across multiple StatCan vectors for longitudinal studies.
Real estate professionals	Monitor housing starts, building permits, and construction investment by geography.
Supply chain planners	Track manufacturing shipments, wholesale trade, and retail sales indicators monthly.

What it does

This Actor collects data from Statistics Canada's Web Data Service by catalogue, cube, coordinate, or vector ID, and returns each record as a flat row.

• 📋 Catalogue mode: fetch the complete list of all available data cubes from Statistics Canada in one run.
• 🧊 Cube metadata mode: retrieve dimensions, members, and notes for a single cube or batch up to 100 product IDs.
• 📈 Data from cube mode: pull the latest N periods of observations for a specific coordinate within a cube.
• 🔢 Vector mode: get the most recent N periods of a time-series by one or more comma-separated vector IDs.

Results export to CSV, JSON, Excel, or XML, or straight from the API.

What you can do with Statistics Canada data

📊 Monitor monthly economic indicators.

An economist runs vector mode with a list of CPI and GDP vector IDs every month, setting latestN to 1, to update a dashboard with the newest release.

🏗️ Track regional construction activity.

A real estate analyst pulls data from the Building Permits cube (productId 34100007) by coordinate for specific provinces, comparing month-over-month changes.

📚 Build a research dataset.

A graduate student fetches the full catalogue, identifies relevant labour force cubes, then extracts time-series for multiple vectors to study employment patterns.

🗞️ Power a data-driven news story.

A journalist scrapes trade balance vectors and retail trade cubes to report on Canada's economic performance with official source data.

🔍 Audit available data cubes.

A data librarian runs catalogue mode periodically to inventory all Statistics Canada cubes, noting new additions and deprecated products.

Why choose this scraper

	What you get
No API key	Statistics Canada's WDS is public. This Actor handles the endpoint construction and pagination for you.
Four retrieval modes	Catalogue, cube metadata, coordinate observations, and vector time-series cover the full WDS surface.
Batch metadata lookup	Pass up to 100 product IDs in one run to get cube dimensions and members in bulk.
Flat row output	Every observation or metadata record lands as one row in your dataset, ready for CSV, JSON, Excel, or XML.
Latest N periods	Set latestN to pull only the most recent observations, keeping datasets small and current.

How it compares

No other Store actor targets Statistics Canada the same way, so the honest comparison is with the alternatives teams actually weigh.

	Statistics Canada Web Data Service Scraper	Build it in-house	By hand
Setup	Run it now, zero config	Days of engineering	None, but hours per pull
When Statistics Canada changes	Maintained for you	You fix it	You re-learn the page
Proxies, retries, anti-bot	Built in	Your problem	Browser only
Output	Fixed JSON schema, CSV/Excel export	Whatever you build	Copy-paste
Cost	Pay per result	Engineering time	Analyst hours

Configure the run

Drive the Actor by selecting a mode, then supplying a product ID, coordinate, or vector IDs. The latestN and maxItems parameters control how many periods and total records you collect per run. The Input tab lists every parameter.

A first run with the defaults:

{
  "mode": "catalogue",
  "productId": 34100007,
  "latestN": 10,
  "maxItems": 10
}

A larger pull:

{
  "mode": "catalogue",
  "productId": 34100007,
  "latestN": 10,
  "maxItems": 200
}

Pricing

Pay-per-result: $0.0355 per result collected. You pay only for the results written to your dataset.

Results collected	Approximate cost
100 results	$3.55
1,000 results	$35.50
10,000 results	$355.00

New Apify accounts start with $5 in free credit.

Free users

Free-plan runs return up to 10 results as a preview. Upgrade your Apify plan to collect up to 1,000,000 results per run.

Run it

1. Create a free Apify account with $5 in credit.
2. Open the Statistics Canada Web Data Service Scraper.
3. Set your inputs and any filters, then click Start.
4. Export the results as CSV, Excel, JSON, or XML from the Dataset tab.

Run it programmatically through the Apify API (run-sync-get-dataset-items) or the ApifyClient for JavaScript and Python.

Use with AI agents (MCP)

Give an AI agent live access to Statistics Canada through the Model Context Protocol. Add the Actor to Claude, Cursor, or any MCP client:

$claude mcp add --transport http apify "https://mcp.apify.com?tools=parseforge/statistics-canada-scraper"

Then prompt it in plain language to run the scraper and read back the results.

Troubleshooting

Why am I getting no results from dataFromCube mode?

Check that your coordinate string has the correct number of dimension positions and uses valid member IDs. Run cube metadata mode first to see the dimension structure and available member values for your product ID.

Why does my vector mode run return an error?

Ensure your vector IDs are comma-separated integers with no spaces or trailing commas. Also verify that each vector ID exists by checking the Statistics Canada vector catalogue or a known cube's metadata.

The Actor runs but the dataset is empty.

Confirm that your product ID is correct and that the cube has data for the coordinate or vector you requested. Some cubes are discontinued or have gaps. Try a known active product ID like 34100007.

I got a timeout or connection error.

Statistics Canada's WDS may occasionally be slow during high-traffic periods. Reduce maxItems or latestN to limit the request size, and retry the run. The Actor will respect the platform's retry logic.

How do I interpret the dimension position numbers in a coordinate?

Run cube metadata mode for your product ID. The response lists each dimension and its members with their position indices. Build your coordinate by selecting one position per dimension, using '0' for any trailing dimensions you do not need to constrain.

FAQ

Question	Answer
Do I need a Statistics Canada API key?	No. The Web Data Service is publicly accessible. This Actor constructs the correct SODA endpoint URLs and handles the requests for you.
What is a product ID?	A product ID is an 8-digit number that identifies a specific Statistics Canada data cube, such as 34100007 for Building Permits. You can find product IDs by running the Actor in catalogue mode first.
What is a coordinate?	A coordinate is a comma-separated string of dimension position values that pinpoints a specific slice of a cube, for example '1.1.1.1.0.0.0.0.0.0'. Use cube metadata mode to discover valid dimension members and their positions.
What is a vector ID?	A vector ID is a numeric identifier for a single time-series within Statistics Canada's system. You can supply multiple vector IDs separated by commas in vector mode to fetch several series at once.
How many periods can I fetch at once?	The latestN parameter lets you request between 1 and 36 of the most recent periods for a coordinate or vector. This keeps your dataset focused on current data.
Can I get metadata for multiple cubes in one run?	Yes. In cube metadata mode, pass an array of up to 100 product IDs in the productIds field to fetch dimensions and members for all of them in a single run.
What output formats are supported?	The Actor outputs data in CSV, JSON, Excel, and XML formats through the standard Apify dataset export options.
How do I find which cubes exist?	Run the Actor in catalogue mode. It returns every available cube with its product ID, title, frequency, and date range, giving you a searchable inventory.
Can I scrape data for a specific geography?	Yes. Geography is typically a dimension within a cube. Use cube metadata mode to see the geography dimension members, then construct a coordinate that selects your target region.
Is there a rate limit on the Statistics Canada WDS?	The Web Data Service is designed for automated access, but this Actor makes sequential, polite requests. The maxItems parameter lets you cap the total records per run.

Related actors

Browse the full ParseForge collection for more scrapers.

🆘 Need help? Email parseforge@protonmail.com with your run ID, your input, and what you expected.

⚠️ Disclaimer. This Actor is unofficial and is not affiliated with, endorsed by, or sponsored by Statistics Canada. It collects only publicly available data. You are responsible for using the collected data in compliance with the source's terms of service and applicable data-protection laws, including GDPR, CCPA, and PIPL. Do not use it to collect personal data unlawfully.