Physicians for each census subdivision

166 views (4 recent)

Published by the Ministry of Jobs, Trade and Technology - 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

Purpose

Application-specific for the Trade and Invest British Columbia website (https://www.britishcolumbia.ca/).

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-05-04
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_PHYSICIANS

Short Name: PHYSICIANS

Column Name Short Name Data Type Data Precision Comments
PHYSICIAN_ID PHYSCN_ID NUMBER 10 PHYSICIAN ID is a system generated unique identification number, e.g., 1
CENSUS_YEAR CNSS_YR 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 CNSS_SB_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 NMBR_F_PHS NUMBER 5 NUMBER OF PHYSICIANS: The number of physicians in the census subdivision, e.g., 216
DATA_PUBLICATION_YEAR DT_PBLCTNR NUMBER 4 DATE PUBLICATION YEAR: The year in which the source of the information in this table was published, e.g., 2014