gpc-data

GeoPostcodes public datasets. All files are in CSV format, with UTF-8 encoding and ; as delimiter.

GeoPC_Countries.csv

Country codes and names with their postal code schemes. This list is based on the cartographic section of the United Nations.

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
Sovereign	Char(2)	Sovereign country code
Capital	Char(60)	Capital city
PostalFormat	Char(10)	Postal code format
PostalName	Char(30)	Postal code name
Comments	Char(30)	Comments

#### GeoPC_Admin.csv All official administrative division names included in the GeoPostcodes datasets.

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
Sovereign	Char(2)	Sovereign country code
Level	Smallint	Administrative level
Name	Char(60)	Division name
Name_EN	Char(60)	English name
Total	Integer	Number of divisions

#### GeoPC_Timezones.csv World time zone names and codes including Daylight Saving Time (DST), data maintained by IANA.

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
Olson	Char(40)	Olson Time zone code
UTC	Char(6)	UTC Offset
DST	Char(6)	Daylight Saving Time
Zone	Char(10)	Time zone abbreviation
ZoneName	Char(50)	Time zone name

#### GeoPC_Currencies.csv Currency codes ISO 4217 standard as published by the International Organization for Standardization (ISO).

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
Currency	Char(40)	Currency name
Code	Char(3)	Currency code
Symbol	Char(5)	Currency symbol
NumCode	Char(3)	Currency numeric code
Decimal	Integer	Decimal positions

#### GeoPC_Statistics.csv Statistical offices by country. Whenever possible we provide the statistical codes provided by these organisations in our region datasets.

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
Name	Char(100)	Statistical organisation name
Abbreviation	Char(20)	Statistical organisation abbreviation
Website	Char(100)	Website URL

#### GeoPC_Languages.csv Official languages list by country. ISO 639-1 and ISO 639-2 standards are published by the International Organization for Standardization (ISO).

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
LanguageEN	Char(40)	English language name
Language	Char(40)	Language name
Code1	Char(2)	ISO 639-1 language code
Code2	Char(3)	ISO 639-2 language code

#### GeoPC_Callingcodes.csv International dialling codes by country.

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
CCode	Char(3)	Currency code

#### GeoPC_ISO3166-2.csv Principal subdivisions by country. ISO 3166-2 standard as published by the International Organization for Standardization (ISO).

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
Code	Char(5)	ISO 3166-2 Region code
Name	Char(80)	Region name
AltName	Char(80)	Alternative region name

#### GeoPC_NUTS.csv Nomenclature of Territorial Units for Statistics (NUTS) standard as provided by the European Commission for statistical purposes.

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
Country	Char(50)	Country name
Code	Char(5)	NUTS code
Level	Integer	NUTS Level
Name	Char(80)	Statistical region name
AltName	Char(80)	Alternative statistical region name

#### GeoPC_NGA.csv NGA Geopolitical codes (Formerly known as FIPS PUB 10-4) standard as published by the U.S. National Geospatial Intelligence Agency. The file contains countries, dependencies, areas of special sovereignty and their principal administrative divisions.

Field name	Field type	Description
ISO	Char(2)	ISO 3166-1 Country code
NGA	Char(2)	NGA Country code
Country	Char(50)	Country name
Code	Char(4)	NGA region code (FIPS)
Name	Char(80)	Administrative division name
Class	Char(60)	Administrative division class