Data Reference Standard on Countries, Territories and Geographic areas - Data Reference Standard on Countries, Territories and Geographic areas
Data Dictionary
- ID
- GC_HIST_ID
- Type
- text
- Label
- GC Historic Country Identifier
- Description
Unique numeric identifier corresponding to a unique record of an entity in this list. The GC_HIST_ID is the GC_ID with the addition of a version number at the end. Every row must have a value in this column.
- ID
- GC_ID
- Type
- text
- Label
- GC Country Identifier
- Description
Unique numeric identifier of a country, territory or geographical area of the world. The number was arbitrarily assigned by GAC to the initial set of rows starting with 10001. Future rows will be assigned the next number in sequence. There is no business (or technical) meaning to the assignment of the value to the row. Every row must have a value in this column.
- ID
- GC_NM_OFF_EN
- Type
- text
- Label
- GC Country Full Name English
- Description
The complete English name for this row as defined by GAC.
- ID
- GC_NM_OFF_FR
- Type
- text
- Label
- GC Country Full Name French
- Description
The complete French name for this row as defined by GAC.
- ID
- GC_NM_AB_EN
- Type
- text
- Label
- GC Country Short Name English
- Description
The shortened (or common) English name for this row as defined by GAC.
- ID
- GC_NM_AB_FR
- Type
- text
- Label
- GC Country Short Name French
- Description
The shortened (or common) French name for this row as defined by GAC.
- ID
- STAT_CD
- Type
- text
- Label
- GC Country Status Code
- Description
An identifier to denote the current or historical status of a record. Values:
-
1 - 'Active' records on this list correspond to the current valid name for the country or area of interest.
-
2 - 'Inactive' records include countries that are no longer recognised as sovereign states by the Canadian government (e.g. USSR, Yougoslavia, etc.) or previous names of 'active' country or area of interest (e.g. Burma --> Myanmar)
-
- ID
- STAT_DESC_EN
- Type
- text
- Label
- Country Status Description
- Description
Current or historical status of a record.
- ID
- STAT_DESC_FR
- Type
- text
- Label
- Country Status Description (French)
- Description
Current or historical status of a record.
- ID
- TYPE_CD
- Type
- text
- Label
- GC Country Type Code
- Description
Indicates whether the row represents a country, territory, geographical area or disputed territory, or a special case.
There are 6 possible values for this row:
-
1 - Country: A country (nation state) that has jurisdiction over itself. In ISO terms, this is either a UN Member State or a UN Observer State. It may also be a country recognized by Canada but NOT recognized by the UN nor ISO.
-
2 - Territory: A territory over which a country claims jurisdiction and exists either outside the primary borders of its parent country or of the territorial waters of its parent country.
-
3 - Geographical area: A geographical area over which no country claims jurisdiction and exists outside any country's borders.
-
4 - Disputed territory: A territory over which more than one country claims jurisdiction and where the dispute has not been resolved.
-
5 - Special case: The remarks field will provide additional information to the reader.
-
6 - Non-self-governing Territory: A territory identified by the UN as a non-self-governing territory.
-
- ID
- TYPE_DESC_EN
- Type
- text
- Label
- Country Type Description
- Description
Indicates whether the row represents a country, territory, geographical area or disputed territory, or a special case.
- ID
- TYPE_DESC_FR
- Type
- text
- Label
- Country Type Description (French)
- Description
Indicates whether the row represents a country, territory, geographical area or disputed territory, or a special case.
- ID
- RECENT_IND
- Type
- text
- Label
- Latest value indicator
- Description
Indicates the latest value of a country's information, including countries or territories that are no longer active (such as the former Yugoslavia). It is set to 1 to identify the most recent record.
- ID
- EFF_DT
- Type
- timestamp
- Label
- Effective Date
- Description
Period of validity (start date) of the name of a country or area of interest, as of the time this name was recognised by the government of Canada. (*Note 1900 when start date is on or prior to 1900)
- ID
- EFF_FN_DT
- Type
- timestamp
- Label
- Effective End Date
- Description
Period of validity (end date) of the name of a country or area of interest, as of the time this name was deprecated by the government of Canada. (*Note end date is set to 2100 when the name of the country or area of interest is still current).
- ID
- OBSERVATIONS_EN
- Type
- text
- Label
- Observations
- Description
English observations by data steward.
- ID
- OBSERVATIONS_FR
- Type
- text
- Label
- Observations (French)
- Description
French observations by data steward.
- ID
- GC_PAR_ID
- Type
- text
- Label
- Parent country ID
- Description
The GC_ID of the geographic entity from which this country or area of interest originated, through seceding from, or dissolution of a country or area of interest.
- ID
- GC_JUR_ID
- Type
- text
- Label
- Administrative Jurisdiction ID
- Description
The GC_ID of the country that has administrative jurisdiction over the territory. Only rows where the GC Country Type code is 'Territory' (2) and the GC Country Status Code is 'Active' (1) will have a value. If there is no value, that means:
1) it's a country
2) it's a geographical area and there is no country that claims jurisdiction
3) it's a territory that has expired
4) it's an area where there is a dispute or a special case (from Canada's perspective). The dispute may involve the countries that claim jurisdiction over the area, or the dispute may involve the nature of the area itself (is it a country or a territory).
When a value is assigned it must reference an existing GC_ID where the TYPE_CD is 1.
- ID
- ISO_ALPHA_2_CD
- Type
- text
- Label
- ISO Alpha-2 Code
- Description
The 2 digit code for this row as defined by the ISO standard 3166 part 1 or part 3. For rows not recognized on ISO 3166 (part 1 and part 3) no value will be provided. For additional information on the ISO 3166 standard, see https://www.iso.org/iso-3166-country-codes.html
- ID
- ISO_ALPHA_3_CD
- Type
- text
- Label
- ISO Alpha-3 Code
- Description
The 3 digit code for this row as defined by the ISO standard 3166 part 1 or part 3. For rows not recognized on ISO 3166 (part 1 and part 3) no value will be provided. For additional information on the ISO 3166 standard, see https://www.iso.org/iso-3166-country-codes.html
- ID
- UN_ONU_CD
- Type
- text
- Label
- UN Country Numeric Code
- Description
The Numeric code for this row as defined by the United Nations (UN). UN M49 or the Standard Country or Area Codes for Statistical Use (Series M, No. 49) is a standard for area codes used by the United Nations for statistical purposes, developed and maintained by the United Nations Statistics Division (https://unstats.un.org/unsd/methodology/m49/). For rows not recognized by this UN standard no value will be provided. For additional information, see https://unstats.un.org/unsd/classifications/Family/Detail/12
- ID
- MODIF_DT
- Type
- timestamp
- Label
- Date Modified
- Description
Date record was modified.
Additional Information
Data last updated | August 16, 2024 |
---|---|
Metadata last updated | December 9, 2024 |
Created | May 23, 2024 |
Format | CSV |
Title | Data Reference Standard on Countries, Territories and Geographic areas |
Date Published | 2024-08-05 |
Resource Type | Dataset |
Size | 71.0 kB(70,953 bytes) |
Character Set | UTF-8 |
Language | English French |
Validation status | Valid data |
Validation timestamp | December 9, 2024, 16:46 (UTC) |