Property Data SchemaNormalized Countries & Provinces

Normalized Countries & Provinces

Country and Province Normalization

Datafiniti runs a normalization process across our entire property database. We normalize our countries and provinces converting them into 2 character abbreviations. Seen in the table below.

Countries

CountryNormalized Term
AfghanistanAF
AlbaniaAL
AlgeriaDZ
American SamoaAS
AndorraAD
AngolaAO
AnguillaAI
AntarcticaAQ
Antigua and BarbudaAG
AntiguaAG
ArgentinaAR
ArmeniaAM
ArubaAW
AustraliaAU
AustriaAT
AzerbaijanAZ
BahamasBS
BahrainBH
BangladeshBD
BarbadosBB
BelarusBY
BelgiumBE
BelizeBZ
BeninBJ
BermudaBM
BhutanBT
BoliviaBO
BonaireBQ
Bosnia and HerzegovinaBA
BotswanaBW
Bouvet IslandBV
BrazilBR
British Indian Ocean TerritoryIO
Brunei DarussalamBN
BulgariaBG
Burkina FasoBF
BurundiBI
CambodiaKH
CameroonCM
CanadaCA
Cape VerdeCV
Grand CaymanKY
Grand Cayman IslandsKY
Cayman IslandsKY
Central African RepublicCF
ChadTD
ChileCL
ChinaCN
Christmas IslandCX
Cocos IslandsCC
ColombiaCO
ComorosKM
CongoCG
Democratic Republic of the CongoCD
Cook IslandsCK
Costa RicaCR
CroatiaHR
CubaCU
CuraçaoCW
CyprusCY
Czech RepublicCZ
Côte d'IvoireCI
DenmarkDK
DjiboutiDJ
DominicaDM
Dominican RepublicDO
EcuadorEC
EgyptEG
El SalvadorSV
Equatorial GuineaGQ
EritreaER
EstoniaEE
EthiopiaET
Falkland Islands (Malvinas)FK
Faroe IslandsFO
FijiFJ
FinlandFI
FranceFR
French GuianaGF
French PolynesiaPF
French Southern TerritoriesTF
GabonGA
GambiaGM
GeorgiaGE
GermanyDE
GhanaGH
GibraltarGI
GreeceGR
GreenlandGL
GrenadaGD
GuadeloupeGP
GuamGU
GuatemalaGT
GuernseyGG
GuineaGN
Guinea-BissauGW
GuyanaGY
HaitiHT
Heard Island and McDonald Mcdonald IslandsHM
Holy SeeVA
HondurasHN
Hong KongHK
HungaryHU
IcelandIS
IndiaIN
IndonesiaID
Iran, Islamic Republic ofIR
IraqIQ
IrelandIE
Isle of ManIM
IsraelIL
ItalyIT
JamaicaJM
JapanJP
JerseyJE
JordanJO
KazakhstanKZ
KenyaKE
KiribatiKI
Korea, Democratic People's Republic ofKP
Korea, Republic ofKR
KuwaitKW
KyrgyzstanKG
Lao People's Democratic RepublicLA
LatviaLV
LebanonLB
LesothoLS
LiberiaLR
LibyaLY
LiechtensteinLI
LithuaniaLT
LuxembourgLU
MacaoMO
Macedonia, the Former Yugoslav Republic ofMK
MadagascarMG
MalawiMW
MalaysiaMY
MaldivesMV
MaliML
MaltaMT
Marshall IslandsMH
MartiniqueMQ
MauritaniaMR
MauritiusMU
MayotteYT
MexicoMX
Micronesia, Federated States ofFM
Moldova, Republic ofMD
MonacoMC
MongoliaMN
MontenegroME
MontserratMS
MoroccoMA
MozambiqueMZ
MyanmarMM
NamibiaNA
NauruNR
NepalNP
NetherlandsNL
The NetherlandsNL
New CaledoniaNC
New ZealandNZ
NicaraguaNI
NigerNE
NigeriaNG
NiueNU
Norfolk IslandNF
Northern Mariana IslandsMP
NorwayNO
OmanOM
PakistanPK
PalauPW
Palestine, State ofPS
PanamaPA
Papua New GuineaPG
ParaguayPY
PeruPE
PhilippinesPH
PitcairnPN
PolandPL
PortugalPT
Puerto RicoPR
QatarQA
RomaniaRO
Russian FederationRU
RwandaRW
ReunionRE
Saint BarthelemyBL
Saint HelenaSH
St. KittsKN
St Kitts and NevisKN
Saint Kitts and NevisKN
St LuciaLC
Saint LuciaLC
Saint MartinMF
Saint Pierre and MiquelonPM
St. VincentVC
St VincentVC
Saint VincentVC
Saint Vincent and the GrenadinesVC
Saint Vincent and the GrenadinesVC
SamoaWS
San MarinoSM
Sao Tome and PrincipeST
Saudi ArabiaSA
SenegalSN
SerbiaRS
SeychellesSC
Sierra LeoneSL
SingaporeSG
Sint MaartenSX
SlovakiaSK
SloveniaSI
Solomon IslandsSB
SomaliaSO
South AfricaZA
South Georgia and the South Sandwich IslandsGS
South SudanSS
SpainES
Sri LankaLK
SudanSD
SurinameSR
Svalbard and Jan MayenSJ
SwazilandSZ
SwedenSE
SwitzerlandCH
Syrian Arab RepublicSY
Taiwan, Province of ChinaTW
TajikistanTJ
United Republic of TanzaniaTZ
ThailandTH
Timor-LesteTL
TogoTG
TokelauTK
TongaTO
TrinidadTT
Trinidad and TobagoTT
TunisiaTN
TurkeyTR
TurkmenistanTM
Turks and caicosTC
Turks and CaicosTC
Turks and Caicos IslandsTC
TuvaluTV
UgandaUG
UkraineUA
United Arab EmiratesAE
United KingdomGB
British Virgin IslandsVG
United StatesUS
United States Minor Outlying IslandsUM
US Virgin IslandsVI
United States Virgin IslandsVI
UruguayUY
UzbekistanUZ
VanuatuVU
VenezuelaVE
Viet NamVN
VietnamVN
Wallis and FutunaWF
Western SaharaEH
YemenYE
ZambiaZM
ZimbabweZW
Aland IslandsAX
KosovoXK

Provinces

CountryProvinceNormalized Term
CAAlbertaAB
CABritish ColumbiaBC
CAManitobaMB
CANew BrunswickNB
CANewfoundland and LabradorNL
CANorthwest TerritoriesNT
CANova ScotiaNS
CANunavutNU
CAOntarioON
CAPrince Edward IslandPE
CAQuebecQC
CASaskatchewanSK
CAYukonYT
USAlabamaAL
USAlaskaAK
USAmerican SamoaAS
USArizonaAZ
USArkansasAR
USCaliforniaCA
USColoradoCO
USConnecticutCT
USDelawareDE
USDistrict of ColumbiaDC
USFederated States of MicronesiaFM
USFloridaFL
USGeorgiaGA
USGuamGU
USHawaiiHI
USIdahoID
USIllinoisIL
USIndianaIN
USIowaIA
USKansasKS
USKentuckyKY
USLouisianaLA
USMaineME
USMarshall IslandsMH
USMarylandMD
USMassachusettsMA
USMichiganMI
USMinnesotaMN
USMississippiMS
USMissouriMO
USMontanaMT
USNebraskaNE
USNevadaNV
USNew HampshireNH
USNew JerseyNJ
USNew MexicoNM
USNew YorkNY
USNorth CarolinaNC
USNorth DakotaND
USNorthern Mariana IslandsMP
USOhioOH
USOklahomaOK
USOregonOR
USPalauPW
USPennsylvaniaPA
USPuerto RicoPR
USRhode IslandRI
USSouth CarolinaSC
USSouth DakotaSD
USTennesseeTN
USTexasTX
USUtahUT
USVermontVT
USVirgin IslandsVI
USVirginiaVA
USWashingtonWA
USWest VirginiaWV
USWisconsinWI
USWyomingWY