Physicians for each census subdivision

166 views (4 recent)

Published by the Ministry of Jobs, Economic Recovery and Innovation - International Marketing
Licensed under Access Only

This dataset contains the number of physicians for each census subdivision in British Columbia.

Data and Resources

Dataset Extent

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

Additional Information


Application-specific for the Trade and Invest British Columbia website (

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 2020-11-03
Resource Status completed

Object Description



Column Name Short Name Data Type Data Precision Comments
PHYSICIAN_ID NUMBER 10 PHYSICIAN ID is a system generated unique identification number, e.g., 1
CENSUS_YEAR NUMBER 4 CENSUS YEAR is the census year to which CENSUS SUBDIVISION ID pertains. e.g., 2006, 2011. With CENSUS SUBDIVISION ID, this forms a foreign key linking to CENSUS YEAR + CENSUS SUBDIVISION ID in CEN CENSUS SUBDIVISIONS SP
CENSUS_SUBDIVISION_ID VARCHAR2 7 CENSUS SUBDIVISION ID together with CENSUS YEAR is used to form a foreign Key, linking to CENSUS_YEAR + CENSUS_SUBDIVISION_ID in CEN_CENSUS_SUBDIVISIONS_SP, e.g., 5901022. With CENSUS_YEAR, this identifies the community in which the customs port of entry is located.
NUMBER_OF_PHYSICIANS NUMBER 5 NUMBER OF PHYSICIANS: The number of physicians in the census subdivision, e.g., 216
DATA_PUBLICATION_YEAR NUMBER 4 DATE PUBLICATION YEAR: The year in which the source of the information in this table was published, e.g., 2014