Unemployment Rates for Geographical Regions

467 views (6 recent)

Published by the Ministry of Jobs, Trade and Technology - International Marketing
Licensed under Access Only

This dataset contains the latest monthly unemployment rate for certain geographical regions in B.C., as calculated by Statistics Canada in the Labour Force Survey. The geographical regions included are: Census Metropolitan Area (CMA), Census Agglomeration (CA), and Economic Region (ER). For the Economic Regions, the annual unemployment rate is also forecasted two years ahead; these projections are from the British Columbia Labour Market Outlook.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

Application-specific for the Trade and Invest British Columbia website (https://www.britishcolumbia.ca/). The data can be viewed through that website.

Lineage Statement

BC Ministry of Jobs, Tourism and Skills Training (Labour Market Outlook Model), 2015

Contact Information

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2016-06-17
Record Last Modified 2019-08-29
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_UNEMPLOYMENT_PRJCTNS

Short Name: UNEMP_PRJ
Comments: Latest monthly unemployment rate for certain geographical regions in B.C., as calculated by Statistics Canada in the Labour Force Survey. The geographical regions included are: Census Metropolitan Area (CMA), Census Agglomeration (CA), and Economic Region (ER). For the Economic Regions, the annual unemployment rate is also forecasted two years ahead; these projections are from the British Columbia Labour Market Outlook.

Column Name Short Name Data Type Data Precision Comments
CENSUS_YEAR NUMBER 4 CENSUS_YEAR: is the census year associated with the GEOGRAPHY_ID value. e.g., 2006, 2011. This field combining with GEOGRAPHY_ID is the primary key of ECON_UNEMPLOYMENT_PRJECTNS_TBL table.
GEOGRAPHY_ID VARCHAR2 5 GEOGRAPHY_ID: is a foreign Key to link to IDs in CEN_CENSUS_ECONOMIC_REGIONS or CEN_CENSUS_METRO_AREAS. e.g., 59933
GEOGRAPHY_TYPE_CODE VARCHAR2 7 GEOGRAPHY_TYPE_CODE: indicates where the geography boundary came from. The code includes PR (Province), ER (Economic Region) and CMA/CA (Census Metropolitan Area / Census Agglomeration)
UNEMPLOYMENT_CURRENT_YEAR NUMBER 4 UNEMPLOYMENT_CURRENT_YEAR: the year to which the (monthly) UNEMPLOYMENT_CURRENT_RATE pertains, e.g., 2014
UNEMPLOYMENT_CURRENT_MONTH VARCHAR2 10 UNEMPLOYMENT_CURRENT_MONTH: the month to which the (monthly) UNEMPLOYMENT_CURRENT_VALUE pertains, e.g., September
UNEMPLOYMENT_CURRENT_RATE NUMBER 3 UNEMPLOYMENT_CURRENT_RATE: Current (monthly) unemployment (percentage). e.g., 6.8
FORECAST_YEAR NUMBER 4 FORECAST_YEAR: the base year for the year+1 and year+2 forecasts, e.g., 2014
UNEMPLOYMENT_FORECAST_YR1_RATE NUMBER 3 UNEMPLOYMENT_FORECAST_YR1_RATE: Annually forecasted unemployment (percentage) in FORECAST YEAR+1. e.g., 6.8
UNEMPLOYMENT_FORECAST_YR2_RATE NUMBER 3 UNEMPLOYMENT_FORECAST_YR2_RATE: Annually forecasted unemployment (percentage) in FORECAST YEAR+2. e.g., 6.8