{"schema_version":1,"export_version":"economic-export-v1","generated_at":"2026-11-10T05:24:08.137Z","series":{"id":"WDS.CAN.GOODS.BALANCE.BOP.NSA.CALC.M","label":"Canada Trade Balance, Goods, Balance of Payments Basis (Monthly, NSA, calculated from Statistics Canada exports and imports)","unit":"million CAD","freq":"M","decimals":1,"format":"number","source_id":"statcan_wds","source_name":"Statistics Canada","source_url":"https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210001101","licence":"Statistics Canada Open Licence","redistribution_permitted":true,"resale_permitted":true,"attribution_text":"Adapted from Statistics Canada, Table 12-10-0011-01 International merchandise trade for all countries and by Principal Trading Partners, monthly, balance of payments basis, unadjusted (v87008926 exports and v87008810 imports), 2026-09, accessed 2026-11-09. Balance calculated by Statistics of the World. This does not constitute an endorsement by Statistics Canada of this product.","notes":"Canada merchandise trade balance with all countries, balance-of-payments basis, not seasonally adjusted, million Canadian dollars: exports minus imports, both as Statistics Canada publishes them at one decimal. Statistics Canada publishes this balance only seasonally adjusted, so SOTW subtracts the unadjusted flows. Release times come from the Web Data Service; vintages are unknown.","topic":"trade","definition":{"unit":"million CAD","concept":"Merchandise trade balance (exports minus imports), all countries, balance-of-payments basis","dataset":"Statistics Canada table 12-10-0011-01","selection":{"exports":{"title":"Canada;Export;Balance of payments;Unadjusted;All countries","vector":87008926,"product":12100011,"coordinate":"1.2.2.1.1.0.0.0.0.0"},"imports":{"title":"Canada;Import;Balance of payments;Unadjusted;All countries","vector":87008810,"product":12100011,"coordinate":"1.1.2.1.1.0.0.0.0.0"},"frequency":"M","geography":"CAN"},"basis_note":"The balance-of-payments basis adjusts customs records for coverage, valuation and timing; it is the basis of Statistics Canada's headline trade release. The customs-basis flows (coordinates 1.x.1.1.1) are not read.","rights_url":"https://www.statcan.gc.ca/en/terms-conditions/open-licence","status_rule":"Any WDS symbol, status or security code other than 0 refuses the family; finality is unknown.","balance_rule":"Exports minus imports of the same month, at the published one decimal, exact (no rounding); both flows kept on every row.","rights_scope":"Statistics Canada Open Licence: use, reproduce, distribute or sell, with the prescribed adapted-product credit.","source_updated":{"latest_period":"2026-09","licence_page_sha256":"8d4bca4e9c44a39c56d13e770d135ea7c2bc937aff65c663a7702df5f8c85454","latest_release_time_text":"2026-11-04T08:30","actual_source_availability_at":null,"original_publisher_release_at":null},"admitted_history":"Every published month from 1997-01","seasonal_adjustment":"not seasonally adjusted","publisher_balance_note":"Statistics Canada publishes no unadjusted balance vector for this selection (coordinates 1.3.2.1.1 and 1.3.1.1.1 do not exist).","native_values_recomputed":false,"seasonal_adjustment_basis":"The Unadjusted member of table 12-10-0011-01; the table's balance members are published only seasonally adjusted (v87008984), so the unadjusted balance is calculated from the unadjusted flows.","private_raw_source_bodies_publicly_redistributed":false},"definition_hash":"9ddf617beff39777d6599649cf74c9cdd086d712823b80628c63c6763f860bd4","source_captures":[{"url":"https://www150.statcan.gc.ca/t1/wds/rest/getDataFromVectorByReferencePeriodRange?vectorIds=%2287008926%22&startRefPeriod=1997-01-01&endReferencePeriod=2100-12-01","method":"GET","sha256":"df29f06ee04744dfd55e84817b228d81920ce9f02db39f3c73bb9fe5350bcd11","byte_count":82619,"retrieved_at":"2026-11-09T13:55:04.737035+00:00","capture_sha256":"e9cf4e396a6016af75c33e940604790a7728532c713361198cd19ca0429af9db","request_body_sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"},{"url":"https://www150.statcan.gc.ca/t1/wds/rest/getDataFromVectorByReferencePeriodRange?vectorIds=%2287008810%22&startRefPeriod=1997-01-01&endReferencePeriod=2100-12-01","method":"GET","sha256":"69032b01b650817a0418e0f57087efc318090275ff1d60d083517c2f4bcac772","byte_count":82619,"retrieved_at":"2026-11-09T13:55:06.396630+00:00","capture_sha256":"d0edbc180fd20bd2fa8b2b666694575ff337230378e28ea5f1949f33b2114ed9","request_body_sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"},{"url":"https://www.statcan.gc.ca/en/terms-conditions/open-licence","method":"GET","sha256":"8d4bca4e9c44a39c56d13e770d135ea7c2bc937aff65c663a7702df5f8c85454","byte_count":27005,"retrieved_at":"2026-11-09T13:55:02.742965+00:00","capture_sha256":"bccac7b84e902457f0b10f193239e87da28f4b02c9d18478c1547833852a66e3","request_body_sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"}],"processing_version":"macro-expansion-v1","generation":"4a03de13-f7fa-4310-84ee-1f2e504926e1","published_at":"2026-11-09T13:55:09.0615+00:00","coverage":{"latest":"2026-09-01","earliest":"1997-01-01","geographies":1,"observations":357},"freshness_policy":{"version":"reference-age-v1","reference":"period_end","window_days":100,"description":"Reference periods ending within 100 days of the screening date pass this conservative coverage screen. This is not a verified publication deadline or a guarantee of current source availability. Collection dates do not refresh an old reference period."},"comparability_policy":{"cross_geography_levels":false,"reason":"This reviewed definition covers one geography (Brazil, Canada, France, Germany, Japan, the United Kingdom, the United States or the fixed EU27 aggregate) with its publisher’s own method, scope and adjustment. View that history; a comparable international cohort is not established."}},"selection":{"series":"WDS.CAN.GOODS.BALANCE.BOP.NSA.CALC.M","latest":false,"geo":"CAN","from":null,"to":null,"limit":2000,"generation":"4a03de13-f7fa-4310-84ee-1f2e504926e1"},"count":357,"truncated":false,"columns":["series_id","series_label","geo","frequency","period","period_start","value","raw_value","quality","complete_status","unit","source_id","source_name","source_url","licence","redistribution_permitted","resale_permitted","attribution_text","definition_sha256","source_evidence_id","source_attributes_json","publication_generation","sotw_published_at","processing_version","reference_period_end"],"encoding":"UTF-8","line_endings":"CRLF","spreadsheet_text_escaping":"Potential formula-like source text is prefixed with an apostrophe; numeric values are unchanged.","csv":{"url":"/api/v1/economic-data?format=csv&series=WDS.CAN.GOODS.BALANCE.BOP.NSA.CALC.M&generation=4a03de13-f7fa-4310-84ee-1f2e504926e1&geo=CAN&limit=2000","sha256":"5141907710688ed15844fa4df1f832251afc7b0ae11b806975caef6fbc98b14e","byte_count":718985},"data_sha256":"e5711d8d7b638989148a04ac8c70be10ed633c70b2bfdf2735f160b3d1f6ce5f","data_hash_basis":"source-observation-fields-v1 (geo, period, period_start, value, raw_value, quality, complete_status, source_attributes); clock-derived freshness is excluded","freshness":{"checked_at":"2026-11-10T05:24:08.137Z","policy":{"version":"reference-age-v1","reference":"period_end","window_days":100,"description":"Reference periods ending within 100 days of the screening date pass this conservative coverage screen. This is not a verified publication deadline or a guarantee of current source availability. Collection dates do not refresh an old reference period."},"within_window":2,"older":355},"evidence":[{"evidence_id":"a3cd0e3b931c33ef158f969b0ba274370cf0ff5aa29c377f2957b9a64e848b32","series_id":"WDS.CAN.GOODS.BALANCE.BOP.NSA.CALC.M","definition":{"unit":"million CAD","concept":"Merchandise trade balance (exports minus imports), all countries, balance-of-payments basis","dataset":"Statistics Canada table 12-10-0011-01","selection":{"exports":{"title":"Canada;Export;Balance of payments;Unadjusted;All countries","vector":87008926,"product":12100011,"coordinate":"1.2.2.1.1.0.0.0.0.0"},"imports":{"title":"Canada;Import;Balance of payments;Unadjusted;All countries","vector":87008810,"product":12100011,"coordinate":"1.1.2.1.1.0.0.0.0.0"},"frequency":"M","geography":"CAN"},"basis_note":"The balance-of-payments basis adjusts customs records for coverage, valuation and timing; it is the basis of Statistics Canada's headline trade release. The customs-basis flows (coordinates 1.x.1.1.1) are not read.","rights_url":"https://www.statcan.gc.ca/en/terms-conditions/open-licence","status_rule":"Any WDS symbol, status or security code other than 0 refuses the family; finality is unknown.","balance_rule":"Exports minus imports of the same month, at the published one decimal, exact (no rounding); both flows kept on every row.","rights_scope":"Statistics Canada Open Licence: use, reproduce, distribute or sell, with the prescribed adapted-product credit.","source_updated":{"latest_period":"2026-09","licence_page_sha256":"8d4bca4e9c44a39c56d13e770d135ea7c2bc937aff65c663a7702df5f8c85454","latest_release_time_text":"2026-11-04T08:30","actual_source_availability_at":null,"original_publisher_release_at":null},"admitted_history":"Every published month from 1997-01","seasonal_adjustment":"not seasonally adjusted","publisher_balance_note":"Statistics Canada publishes no unadjusted balance vector for this selection (coordinates 1.3.2.1.1 and 1.3.1.1.1 do not exist).","native_values_recomputed":false,"seasonal_adjustment_basis":"The Unadjusted member of table 12-10-0011-01; the table's balance members are published only seasonally adjusted (v87008984), so the unadjusted balance is calculated from the unadjusted flows.","private_raw_source_bodies_publicly_redistributed":false},"definition_hash":"9ddf617beff39777d6599649cf74c9cdd086d712823b80628c63c6763f860bd4","source_captures":[{"url":"https://www150.statcan.gc.ca/t1/wds/rest/getDataFromVectorByReferencePeriodRange?vectorIds=%2287008926%22&startRefPeriod=1997-01-01&endReferencePeriod=2100-12-01","method":"GET","sha256":"df29f06ee04744dfd55e84817b228d81920ce9f02db39f3c73bb9fe5350bcd11","byte_count":82619,"retrieved_at":"2026-11-09T13:55:04.737035+00:00","capture_sha256":"e9cf4e396a6016af75c33e940604790a7728532c713361198cd19ca0429af9db","request_body_sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"},{"url":"https://www150.statcan.gc.ca/t1/wds/rest/getDataFromVectorByReferencePeriodRange?vectorIds=%2287008810%22&startRefPeriod=1997-01-01&endReferencePeriod=2100-12-01","method":"GET","sha256":"69032b01b650817a0418e0f57087efc318090275ff1d60d083517c2f4bcac772","byte_count":82619,"retrieved_at":"2026-11-09T13:55:06.396630+00:00","capture_sha256":"d0edbc180fd20bd2fa8b2b666694575ff337230378e28ea5f1949f33b2114ed9","request_body_sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"},{"url":"https://www.statcan.gc.ca/en/terms-conditions/open-licence","method":"GET","sha256":"8d4bca4e9c44a39c56d13e770d135ea7c2bc937aff65c663a7702df5f8c85454","byte_count":27005,"retrieved_at":"2026-11-09T13:55:02.742965+00:00","capture_sha256":"bccac7b84e902457f0b10f193239e87da28f4b02c9d18478c1547833852a66e3","request_body_sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"}],"processing_version":"macro-expansion-v1","created_at":"2026-11-09T13:55:09.0615+00:00"}],"notice":"The CSV is pinned to this publication and the manifest checks its exact bytes. A superseded current publication returns 409; recorded-state pins support archive replay where available. Acquisition times do not establish publisher release or commit availability. Preserve both files together."}