pdCountry – File Layout & Data Definitions

Printable PDF version >>

Field: name of the field. Type: field type; Chr = character or alphanumeric, Num = numeric. Width: field width. Dec: number of decimal points. From: field starting point. To: field ending point. Description: data definition of the field contents.

Field Type Width Dec From To Description
PEACOCK_ID Chr 10   1 10 Unique ID number assigned to each record
ABBR Chr 2   11 12 ISO 3166-1 alpha-2 - two-letter country code (most commonly used)
ABBR3 Chr 3   13 15 ISO 3166-1 alpha-3 - three-letter country code
NUM Chr 3   16 18 ISO 3166-1 numeric - three-digit country code
NAME Chr 80   19 98 Full name
SHORTNAME Chr 50   99 148 Short name
LAT Num 9 6 149 157 Latitude coordinate (average or capital)
LATHEM Chr 1   158 158 Latitude Hemisphere (key):
N = Northern Hemisphere
S = Southern Hemisphere
LONG Num 10 6 159 168 Longitude coordinate (average or capital)
LONHEM Chr 1   169 169 Longitude Hemisphere (key):
E = Eastern Hemisphere
W = Western Hemisphere
LATRAD Num 18 15 170 187 Latitude coordinate converted to radians for use in trigonometry functions - 15 numeric places
LONRAD Num 18 15 188 205 Longitude coordinate converted to radians for use in trigonometry functions - 15 numeric places
LATDMS Chr 14   206 219 Latitude coordinate - Degrees/Minutes/Seconds
LONDMS Chr 15   220 234 Longitude coordinate - Degrees/Minutes/Seconds
CAPITAL Chr 35   235 269 Capital city
CITIZENS Chr 50   270 319 Preferred noun for citizenry
ADJECTIVE Chr 50   320 369 Preferred adjective for citizenry
CURRENCY Chr 50   370 419 Name of currency
CURRENCYCD Chr 10   420 429 ISO 4217 currency code
CURRENCYSB Chr 25   430 454 Currency subunit
CALLING Chr 70   455 524 ITU country calling code
INTERNET Chr 3   525 527 Internet URL extension for top-level domains