Toggle navigation

Data Files

Odoo is greatly data-driven, and a big part of modules definition is thus the definition of the various records it manages: UI (menus and views), security (access rights and access rules), reports and plain data are all defined via records.

Structure

The main way to define data in Odoo is via XML data files: The broad structure of an XML data file is the following:

  • Any number of operation elements within the root element odoo
<!-- the root elements of the data file -->
<?xml version="1.0" encoding="UTF-8"?>
<odoo>
  <operation/>
  ...
</odoo>

Data files are executed sequentially, operations can only refer to the result of operations defined previously

Core operations

record

record appropriately defines or updates a database record, it has the following attributes:

model (required)
name of the model to create (or update)
id

the external identifier for this record. It is strongly recommended to provide one

  • for record creation, allows subsequent definitions to either modify or refer to this record
  • for record modification, the record to modify
context
context to use when creating the record
forcecreate

in update mode whether the record should be created if it doesn’t exist

Requires an external id, defaults to True.

field

Each record can be composed of field tags, defining values to set when creating the record. A record with no field will use all default values (creation) or do nothing (update).

A field has a mandatory name attribute, the name of the field to set, and various methods to define the value itself:

Nothing
if no value is provided for the field, an implicit False will be set on the field. Can be used to clear a field, or avoid using a default value for the field.
search

for relational fields, should be a domain on the field’s model.

Will evaluate the domain, search the field’s model using it and set the search’s result as the field’s value. Will only use the first result if the field is a Many2one

ref

if a ref attribute is provided, its value must be a valid external id, which will be looked up and set as the field’s value.

Mostly for Many2one and Reference fields

type

if a type attribute is provided, it is used to interpret and convert the field’s content. The field’s content can be provided through an external file using the file attribute, or through the node’s body.

Available types are:

xml, html
extracts the field’s children as a single document, evaluates any external id specified with the form %(external_id)s. %% can be used to output actual % signs.
file
ensures that the field content is a valid file path in the current model, saves the pair module,path as the field value
char
sets the field content directly as the field’s value without alterations
base64
base64-encodes the field’s content, useful combined with the file attribute to load e.g. image data into attachments
int
converts the field’s content to an integer and sets it as the field’s value
float
converts the field’s content to a float and sets it as the field’s value
list, tuple
should contain any number of value elements with the same properties as field, each element resolves to an item of a generated tuple or list, and the generated collection is set as the field’s value
eval

for cases where the previous methods are unsuitable, the eval attributes simply evaluates whatever Python expression it is provided and sets the result as the field’s value.

The evaluation context contains various modules (time, datetime, timedelta, relativedelta), a function to resolve external identifiers (ref) and the model object for the current field if applicable (obj)

delete

The delete tag can remove any number of records previously defined. It has the following attributes:

model (required)
the model in which a specified record should be deleted
id
the external id of a record to remove
search
a domain to find records of the model to remove

id and search are exclusive

function

The function tag calls a method on a model, with provided parameters. It has two mandatory parameters model and name specifying respectively the model and the name of the method to call.

Parameters can be provided using eval (should evaluate to a sequence of parameters to call the method with) or value elements (see list values).

<odoo>
    <data noupdate="1">
        <record name="partner_1" model="res.partner">
            <field name="name">Odude</field>
        </record>

        <function model="res.partner" name="send_inscription_notice"
            eval="[[ref('partner_1'), ref('partner_2')]]"/>

        <function model="res.users" name="send_vip_inscription_notice">
            <function eval="[[('vip','=',True)]]" model="res.partner" name="search"/>
        </function>
    </data>

    <record id="model_form_view" model="ir.ui.view">

    </record>
</odoo>

Shortcuts

Because some important structural models of Odoo are complex and involved, data files provide shorter alternatives to defining them using record tags:

template

Creates a QWeb view requiring only the arch section of the view, and allowing a few optional attributes:

id
the view’s external identifier
name, inherit_id, priority
same as the corresponding field on ir.ui.view (nb: inherit_id should be an external identifier)
primary
if set to True and combined with a inherit_id, defines the view as a primary
groups
comma-separated list of group external identifiers
page
if set to "True", the template is a website page (linkable to, deletable)
optional
enabled or disabled, whether the view can be disabled (in the website interface) and its default status. If unset, the view is always enabled.

report

Creates a IrActionsReport record with a few default values.

Mostly just proxies attributes to the corresponding fields on ir.actions.report, but also automatically creates the item in the More menu of the report’s model.

CSV data files

XML data files are flexible and self-descriptive, but very verbose when creating a number of simple records of the same model in bulk.

For this case, data files can also use csv, this is often the case for access rights:

  • the file name is model_name.csv
  • the first row lists the fields to write, with the special field id for external identifiers (used for creation or update)
  • each row thereafter creates a new record

Here’s the first lines of the data file defining US states res.country.state.csv

"id","country_id:id","name","code"
state_au_1,au,"Australian Capital Territory","ACT"
state_au_2,au,"New South Wales","NSW"
state_au_3,au,"Northern Territory","NT"
state_au_4,au,"Queensland","QLD"
state_au_5,au,"South Australia","SA"
state_au_6,au,"Tasmania","TAS"
state_au_7,au,"Victoria","VIC"
state_au_8,au,"Western Australia","WA"
state_us_1,us,"Alabama","AL"
state_us_2,us,"Alaska","AK"
state_us_3,us,"Arizona","AZ"
state_us_4,us,"Arkansas","AR"
state_us_5,us,"California","CA"
state_us_6,us,"Colorado","CO"

rendered in a more readable format:

idcountry_id:idnamecode
state_au_1auAustralian Capital TerritoryACT
state_au_2auNew South WalesNSW
state_au_3auNorthern TerritoryNT
state_au_4auQueenslandQLD
state_au_5auSouth AustraliaSA
state_au_6auTasmaniaTAS
state_au_7auVictoriaVIC
state_au_8auWestern AustraliaWA
state_us_1usAlabamaAL
state_us_2usAlaskaAK
state_us_3usArizonaAZ
state_us_4usArkansasAR
state_us_5usCaliforniaCA
state_us_6usColoradoCO
state_us_7usConnecticutCT
state_us_8usDelawareDE
state_us_9usDistrict of ColumbiaDC
state_us_10usFloridaFL
state_us_11usGeorgiaGA
state_us_12usHawaiiHI
state_us_13usIdahoID
state_us_14usIllinoisIL
state_us_15usIndianaIN
state_us_16usIowaIA
state_us_17usKansasKS
state_us_18usKentuckyKY
state_us_19usLouisianaLA
state_us_20usMaineME
state_us_21usMontanaMT
state_us_22usNebraskaNE
state_us_23usNevadaNV
state_us_24usNew HampshireNH
state_us_25usNew JerseyNJ
state_us_26usNew MexicoNM
state_us_27usNew YorkNY
state_us_28usNorth CarolinaNC
state_us_29usNorth DakotaND
state_us_30usOhioOH
state_us_31usOklahomaOK
state_us_32usOregonOR
state_us_33usMarylandMD
state_us_34usMassachusettsMA
state_us_35usMichiganMI
state_us_36usMinnesotaMN
state_us_37usMississippiMS
state_us_38usMissouriMO
state_us_39usPennsylvaniaPA
state_us_40usRhode IslandRI
state_us_41usSouth CarolinaSC
state_us_42usSouth DakotaSD
state_us_43usTennesseeTN
state_us_44usTexasTX
state_us_45usUtahUT
state_us_46usVermontVT
state_us_47usVirginiaVA
state_us_48usWashingtonWA
state_us_49usWest VirginiaWV
state_us_50usWisconsinWI
state_us_51usWyomingWY
state_us_asusAmerican SamoaAS
state_us_fmusFederated States of MicronesiaFM
state_us_guusGuamGU
state_us_mhusMarshall IslandsMH
state_us_mpusNorthern Mariana IslandsMP
state_us_pwusPalauPW
state_us_prusPuerto RicoPR
state_us_viusVirgin IslandsVI
state_us_aausArmed Forces AmericasAA
state_us_aeusArmed Forces EuropeAE
state_us_apusArmed Forces PacificAP
state_br_acbrAcreAC
state_br_albrAlagoasAL
state_br_apbrAmapáAP
state_br_ambrAmazonasAM
state_br_babrBahiaBA
state_br_cebrCearáCE
state_br_dfbrDistrito FederalDF
state_br_esbrEspírito SantoES
state_br_gobrGoiásGO
state_br_mabrMaranhãoMA
state_br_mtbrMato GrossoMT
state_br_msbrMato Grosso do SulMS
state_br_mgbrMinas GeraisMG
state_br_pabrParáPA
state_br_pbbrParaíbaPB
state_br_prbrParanáPR
state_br_pebrPernambucoPE
state_br_pibrPiauíPI
state_br_rjbrRio de JaneiroRJ
state_br_rnbrRio Grande do NorteRN
state_br_rsbrRio Grande do SulRS
state_br_robrRondôniaRO
state_br_rrbrRoraimaRR
state_br_scbrSanta CatarinaSC
state_br_spbrSão PauloSP
state_br_sebrSergipeSE
state_br_tobrTocantinsTO
state_ru_adruRepublic of AdygeyaAD
state_ru_alruAltai RepublicAL
state_ru_altruAltai KraiALT
state_ru_amuruAmur OblastAMU
state_ru_arkruArkhangelsk OblastARK
state_ru_astruAstrakhan OblastAST
state_ru_baruRepublic of BashkortostanBA
state_ru_belruBelgorod OblastBEL
state_ru_bryruBryansk OblastBRY
state_ru_buruRepublic of BuryatiaBU
state_ru_ceruChechen RepublicCE
state_ru_cheruChelyabinsk OblastCHE
state_ru_churuChukotka Autonomous OkrugCHU
state_ru_curuChuvash RepublicCU
state_ru_daruRepublic of DagestanDA
state_ru_inruRepublic of IngushetiaIN
state_ru_irkruIrkutsk OblastIRK
state_ru_ivaruIvanovo OblastIVA
state_ru_kamruKamchatka KraiKAM
state_ru_kbruKabardino-Balkarian RepublicKB
state_ru_kgdruKaliningrad OblastKGD
state_ru_klruRepublic of KalmykiaKL
state_ru_kluruKaluga OblastKLU
state_ru_kcruKarachay–Cherkess RepublicKC
state_ru_krruRepublic of KareliaKR
state_ru_kemruKemerovo OblastKEM
state_ru_kharuKhabarovsk KraiKHA
state_ru_kkruRepublic of KhakassiaKK
state_ru_khmruKhanty-Mansi Autonomous OkrugKHM
state_ru_kirruKirov OblastKIR
state_ru_koruKomi RepublicKO
state_ru_kosruKostroma OblastKOS
state_ru_kdaruKrasnodar KraiKDA
state_ru_kyaruKrasnoyarsk KraiKYA
state_ru_kgnruKurgan OblastKGN
state_ru_krsruKursk OblastKRS
state_ru_lenruLeningrad OblastLEN
state_ru_lipruLipetsk OblastLIP
state_ru_magruMagadan OblastMAG
state_ru_meruMari El RepublicME
state_ru_moruRepublic of MordoviaMO
state_ru_mosruMoscow OblastMOS
state_ru_mowruMoscowMOW
state_ru_murruMurmansk OblastMUR
state_ru_nizruNizhny Novgorod OblastNIZ
state_ru_ngrruNovgorod OblastNGR
state_ru_nvsruNovosibirsk OblastNVS
state_ru_omsruOmsk OblastOMS
state_ru_oreruOrenburg OblastORE
state_ru_orlruOryol OblastORL
state_ru_pnzruPenza OblastPNZ
state_ru_perruPerm KraiPER
state_ru_priruPrimorsky KraiPRI
state_ru_pskruPskov OblastPSK
state_ru_rosruRostov OblastROS
state_ru_ryaruRyazan OblastRYA
state_ru_saruSakha Republic (Yakutia)SA
state_ru_sakruSakhalin OblastSAK
state_ru_samruSamara OblastSAM
state_ru_speruSaint PetersburgSPE
state_ru_sarruSaratov OblastSAR
state_ru_seruRepublic of North Ossetia–AlaniaSE
state_ru_smoruSmolensk OblastSMO
state_ru_staruStavropol KraiSTA
state_ru_sveruSverdlovsk OblastSVE
state_ru_tamruTambov OblastTAM
state_ru_taruRepublic of TatarstanTA
state_ru_tomruTomsk OblastTOM
state_ru_tulruTula OblastTUL
state_ru_tveruTver OblastTVE
state_ru_tyuruTyumen OblastTYU
state_ru_tyruTyva RepublicTY
state_ru_udruUdmurtiaUD
state_ru_ulyruUlyanovsk OblastULY
state_ru_vlaruVladimir OblastVLA
state_ru_vggruVolgograd OblastVGG
state_ru_vlgruVologda OblastVLG
state_ru_vorruVoronezh OblastVOR
state_ru_yanruYamalo-Nenets Autonomous OkrugYAN
state_ru_yarruYaroslavl OblastYAR
state_ru_yevruJewish Autonomous OblastYEV
state_gt_avegtAlta VerapazAVE
state_gt_bvegtBaja VerapazBVE
state_gt_cmtgtChimaltenangoCMT
state_gt_cqmgtChiquimulaCQM
state_gt_eprgtEl ProgresoEPR
state_gt_escgtEscuintlaESC
state_gt_guagtGuatemalaGUA
state_gt_huegtHuehuetenangoHUE
state_gt_izagtIzabalIZA
state_gt_jalgtJalapaJAL
state_gt_jutgtJutiapaJUT
state_gt_petgtPeténPET
state_gt_quegtQuetzaltenangoQUE
state_gt_quigtQuichéQUI
state_gt_retgtRetalhuleuRET
state_gt_sacgtSacatepéquezSAC
state_gt_smagtSan MarcosSMA
state_gt_srogtSanta RosaSRO
state_gt_solgtSololáSOL
state_gt_sucgtSuchitepéquezSUC
state_gt_totgtTotonicapánTOT
state_gt_zacgtZacapaZAC
state_jp_jp-23jpAichi23
state_jp_jp-05jpAkita05
state_jp_jp-02jpAomori02
state_jp_jp-12jpChiba12
state_jp_jp-38jpEhime38
state_jp_jp-18jpFukui18
state_jp_jp-40jpFukuoka40
state_jp_jp-07jpFukushima07
state_jp_jp-21jpGifu21
state_jp_jp-10jpGunma10
state_jp_jp-34jpHiroshima34
state_jp_jp-01jpHokkaidō01
state_jp_jp-28jpHyōgo28
state_jp_jp-08jpIbaraki08
state_jp_jp-17jpIshikawa17
state_jp_jp-03jpIwate03
state_jp_jp-37jpKagawa37
state_jp_jp-46jpKagoshima46
state_jp_jp-14jpKanagawa14
state_jp_jp-39jpKōchi39
state_jp_jp-43jpKumamoto43
state_jp_jp-26jpKyōto26
state_jp_jp-24jpMie24
state_jp_jp-04jpMiyagi04
state_jp_jp-45jpMiyazaki45
state_jp_jp-20jpNagano20
state_jp_jp-42jpNagasaki42
state_jp_jp-29jpNara29
state_jp_jp-15jpNiigata15
state_jp_jp-44jpŌita44
state_jp_jp-33jpOkayama33
state_jp_jp-47jpOkinawa47
state_jp_jp-27jpŌsaka27
state_jp_jp-41jpSaga41
state_jp_jp-11jpSaitama11
state_jp_jp-25jpShiga25
state_jp_jp-32jpShimane32
state_jp_jp-22jpShizuoka22
state_jp_jp-09jpTochigi09
state_jp_jp-36jpTokushima36
state_jp_jp-31jpTottori31
state_jp_jp-16jpToyama16
state_jp_jp-13jpTōkyō13
state_jp_jp-30jpWakayama30
state_jp_jp-06jpYamagata06
state_jp_jp-35jpYamaguchi35
state_jp_jp-19jpYamanashi19
state_pt_pt-01ptAveiro01
state_pt_pt-02ptBeja02
state_pt_pt-03ptBraga03
state_pt_pt-04ptBragança04
state_pt_pt-05ptCastelo Branco05
state_pt_pt-06ptCoimbra06
state_pt_pt-07ptÉvora07
state_pt_pt-08ptFaro08
state_pt_pt-09ptGuarda09
state_pt_pt-10ptLeiria10
state_pt_pt-11ptLisboa11
state_pt_pt-12ptPortalegre12
state_pt_pt-13ptPorto13
state_pt_pt-14ptSantarém14
state_pt_pt-15ptSetúbal15
state_pt_pt-16ptViana do Castelo16
state_pt_pt-17ptVila Real17
state_pt_pt-18ptViseu18
state_pt_pt-20ptAçores20
state_pt_pt-30ptMadeira30
state_eg_dkegDakahliaDK
state_eg_baegRed SeaBA
state_eg_bhegBeheiraBH
state_eg_fymegFaiyumFYM
state_eg_ghegGharbiaGH
state_eg_alxegAlexandriaALX
state_eg_isegIsmailiaIS
state_eg_gzegGizaGZ
state_eg_mnfegMonufiaMNF
state_eg_mnegMinyaMN
state_eg_cegCairoC
state_eg_kbegQalyubiaKB
state_eg_lxegLuxorLX
state_eg_wadegNew ValleyWAD
state_eg_shregAl SharqiaSHR
state_eg_sueg6th of OctoberSU
state_eg_suzegSuezSUZ
state_eg_asnegAswanASN
state_eg_astegAsyutAST
state_eg_bnsegBeni SuefBNS
state_eg_ptsegPort SaidPTS
state_eg_dtegDamiettaDT
state_eg_huegHelwanHU
state_eg_jsegSouth SinaiJS
state_eg_kfsegKafr el-SheikhKFS
state_eg_mtegMatrouhMT
state_eg_knegQenaKN
state_eg_sinegNorth SinaiSIN
state_eg_shgegSohagSHG
state_za_eczaEastern CapeEC
state_za_fszaFree StateFS
state_za_gtzaGautengGT
state_za_nlzaKwaZulu-NatalNL
state_za_lpzaLimpopoLP
state_za_mpzaMpumalangaMP
state_za_nczaNorthern CapeNC
state_za_nwzaNorth WestNW
state_za_wczaWestern CapeWC
state_it_agitAgrigentoAG
state_it_alitAlessandriaAL
state_it_anitAnconaAN
state_it_aoitAostaAO
state_it_aritArezzoAR
state_it_apitAscoli PicenoAP
state_it_atitAstiAT
state_it_avitAvellinoAV
state_it_baitBariBA
state_it_btitBarletta-Andria-TraniBT
state_it_blitBellunoBL
state_it_bnitBeneventoBN
state_it_bgitBergamoBG
state_it_biitBiellaBI
state_it_boitBolognaBO
state_it_bzitBolzanoBZ
state_it_bsitBresciaBS
state_it_britBrindisiBR
state_it_caitCagliariCA
state_it_clitCaltanissettaCL
state_it_cbitCampobassoCB
state_it_ciitCarbonia-IglesiasCI
state_it_ceitCasertaCE
state_it_ctitCataniaCT
state_it_czitCatanzaroCZ
state_it_chitChietiCH
state_it_coitComoCO
state_it_csitCosenzaCS
state_it_critCremonaCR
state_it_kritCrotoneKR
state_it_cnitCuneoCN
state_it_enitEnnaEN
state_it_fmitFermoFM
state_it_feitFerraraFE
state_it_fiitFirenzeFI
state_it_fgitFoggiaFG
state_it_fcitForlì-CesenaFC
state_it_fritFrosinoneFR
state_it_geitGenovaGE
state_it_goitGoriziaGO
state_it_gritGrossetoGR
state_it_imitImperiaIM
state_it_isitIserniaIS
state_it_spitLa SpeziaSP
state_it_aqitL’AquilaAQ
state_it_ltitLatinaLT
state_it_leitLecceLE
state_it_lcitLeccoLC
state_it_liitLivornoLI
state_it_loitLodiLO
state_it_luitLuccaLU
state_it_mcitMacerataMC
state_it_mnitMantovaMN
state_it_msitMassa-CarraraMS
state_it_mtitMateraMT
state_it_vsitMedio CampidanoVS
state_it_meitMessinaME
state_it_miitMilanoMI
state_it_moitModenaMO
state_it_mbitMonza e BrianzaMB
state_it_naitNapoliNA
state_it_noitNovaraNO
state_it_nuitNuoroNU
state_it_ogitOgliastraOG
state_it_otitOlbia-TempioOT
state_it_oritOristanoOR
state_it_pditPadovaPD
state_it_paitPalermoPA
state_it_pritParmaPR
state_it_pvitPaviaPV
state_it_pgitPerugiaPG
state_it_puitPesaro e UrbinoPU
state_it_peitPescaraPE
state_it_pcitPiacenzaPC
state_it_piitPisaPI
state_it_ptitPistoiaPT
state_it_pnitPordenonePN
state_it_pzitPotenzaPZ
state_it_poitPratoPO
state_it_rgitRagusaRG
state_it_raitRavennaRA
state_it_rcitReggio CalabriaRC
state_it_reitReggio EmiliaRE
state_it_riitRietiRI
state_it_rnitRiminiRN
state_it_rmitRomaRM
state_it_roitRovigoRO
state_it_saitSalernoSA
state_it_ssitSassariSS
state_it_svitSavonaSV
state_it_siitSienaSI
state_it_sritSiracusaSR
state_it_soitSondrioSO
state_it_suitSud SardegnaSU
state_it_taitTarantoTA
state_it_teitTeramoTE
state_it_tritTerniTR
state_it_toitTorinoTO
state_it_tpitTrapaniTP
state_it_tnitTrentoTN
state_it_tvitTrevisoTV
state_it_tsitTriesteTS
state_it_uditUdineUD
state_it_vaitVareseVA
state_it_veitVeneziaVE
state_it_vbitVerbano-Cusio-OssolaVB
state_it_vcitVercelliVC
state_it_vritVeronaVR
state_it_vvitVibo ValentiaVV
state_it_viitVicenzaVI
state_it_vtitViterboVT
state_es_cesA Coruña (La Coruña)C
state_es_viesAraba/ÁlavaVI
state_es_abesAlbaceteAB
state_es_aesAlacant (Alicante)A
state_es_alesAlmeríaAL
state_es_oesAsturiasO
state_es_avesÁvilaAV
state_es_baesBadajozBA
state_es_pmesIlles Balears (Islas Baleares)PM
state_es_besBarcelonaB
state_es_buesBurgosBU
state_es_ccesCáceresCC
state_es_caesCádizCA
state_es_sesCantabriaS
state_es_csesCastelló (Castellón)CS
state_es_ceesCeutaCE
state_es_cresCiudad RealCR
state_es_coesCórdobaCO
state_es_cuesCuencaCU
state_es_giesGirona (Gerona)GI
state_es_gresGranadaGR
state_es_guesGuadalajaraGU
state_es_ssesGipuzkoa (Guipúzcoa)SS
state_es_hesHuelvaH
state_es_huesHuescaHU
state_es_jesJaénJ
state_es_loesLa RiojaLO
state_es_gcesLas PalmasGC
state_es_leesLeónLE
state_es_lesLleida (Lérida)L
state_es_luesLugoLU
state_es_mesMadridM
state_es_maesMálagaMA
state_es_mlesMelillaME
state_es_muesMurciaMU
state_es_naesNavarra (Nafarroa)NA
state_es_oresOurense (Orense)OR
state_es_pesPalenciaP
state_es_poesPontevedraPO
state_es_saesSalamancaSA
state_es_tfesSanta Cruz de TenerifeTF
state_es_sgesSegoviaSG
state_es_seesSevillaSE
state_es_soesSoriaSO
state_es_tesTarragonaT
state_es_teesTeruelTE
state_es_toesToledoTO
state_es_vesValència (Valencia)V
state_es_vaesValladolidVA
state_es_biesBizkaia (Vizcaya)BI
state_es_zaesZamoraZA
state_es_zesZaragozaZ
state_my_jhrmyJohorJHR
state_my_kdhmyKedahKDH
state_my_ktnmyKelantanKTN
state_my_kulmyKuala LumpurKUL
state_my_lbnmyLabuanLBN
state_my_mlkmyMelakaMLK
state_my_nsnmyNegeri SembilanNSN
state_my_phgmyPahangPHG
state_my_prkmyPerakPRK
state_my_plsmyPerlisPLS
state_my_pngmyPulau PinangPNG
state_my_pjymyPutrajayaPJY
state_my_sbhmySabahSBH
state_my_swkmySarawakSWK
state_my_sgrmySelangorSGR
state_my_trgmyTerengganuTRG
state_mx_agsmxAguascalientesAGU
state_mx_bcmxBaja CaliforniaBCN
state_mx_bcsmxBaja California SurBCS
state_mx_chihmxChihuahuaCHH
state_mx_colmxColimaCOL
state_mx_campmxCampecheCAM
state_mx_coahmxCoahuilaCOA
state_mx_chismxChiapasCHP
state_mx_dfmxCiudad de MéxicoDIF
state_mx_dgomxDurangoDUR
state_mx_gromxGuerreroGRO
state_mx_gtomxGuanajuatoGUA
state_mx_hgomxHidalgoHID
state_mx_jalmxJaliscoJAL
state_mx_michmxMichoacánMIC
state_mx_mormxMorelosMOR
state_mx_mexmxMéxicoMEX
state_mx_naymxNayaritNAY
state_mx_nlmxNuevo LeónNLE
state_mx_oaxmxOaxacaOAX
state_mx_puemxPueblaPUE
state_mx_q_roomxQuintana RooROO
state_mx_qromxQuerétaroQUE
state_mx_sinmxSinaloaSIN
state_mx_slpmxSan Luis PotosíSLP
state_mx_sonmxSonoraSON
state_mx_tabmxTabascoTAB
state_mx_tlaxmxTlaxcalaTLA
state_mx_tampsmxTamaulipasTAM
state_mx_vermxVeracruzVER
state_mx_yucmxYucatánYUC
state_mx_zacmxZacatecasZAC
state_nz_auknzAucklandAUK
state_nz_bopnzBay of PlentyBOP
state_nz_cannzCanterburyCAN
state_nz_gisnzGisborneGIS
state_nz_hkbnzHawke’s BayHKB
state_nz_mwtnzManawatu-WanganuiMWT
state_nz_mbhnzMarlboroughMBH
state_nz_nsnnzNelsonNSN
state_nz_ntlnzNorthlandNTL
state_nz_otanzOtagoOTA
state_nz_stlnzSouthlandSTL
state_nz_tkinzTaranakiTKI
state_nz_tasnzTasmanTAS
state_nz_wkonzWaikatoWKO
state_nz_wgnnzWellingtonWGN
state_nz_wtcnzWest CoastWTC
state_ca_abcaAlbertaAB
state_ca_bccaBritish ColumbiaBC
state_ca_mbcaManitobaMB
state_ca_nbcaNew BrunswickNB
state_ca_nlcaNewfoundland and LabradorNL
state_ca_ntcaNorthwest TerritoriesNT
state_ca_nscaNova ScotiaNS
state_ca_nucaNunavutNU
state_ca_oncaOntarioON
state_ca_pecaPrince Edward IslandPE
state_ca_qccaQuebecQC
state_ca_skcaSaskatchewanSK
state_ca_ytcaYukonYT
state_ae_azaeAbu DhabiAZ
state_ae_ajaeAjmanAJ
state_ae_duaeDubaiDU
state_ae_fuaeFujairahFU
state_ae_rkaeRas al-KhaimahRK
state_ae_shaeSharjahSH
state_ae_uqaeUmm al-QuwainUQ
state_ar_carCiudad Autónoma de Buenos AiresC
state_ar_barBuenos AiresB
state_ar_karCatamarcaK
state_ar_harChacoH
state_ar_uarChobutU
state_ar_xarCórdobaX
state_ar_warCorrientesW
state_ar_earEntre RíosE
state_ar_parFormosaP
state_ar_yarJujuyY
state_ar_larLa PampaL
state_ar_farLa RiojaF
state_ar_marMendozaM
state_ar_narMisionesN
state_ar_qarNeuquénQ
state_ar_rarRío NegroR
state_ar_aarSaltaA
state_ar_jarSan JuanJ
state_ar_darSan LuisD
state_ar_zarSanta CruzZ
state_ar_sarSanta FeS
state_ar_garSantiago Del EsteroG
state_ar_varTierra del FuegoV
state_ar_tarTucumánT
state_in_aninAndaman and NicobarAN
state_in_apinAndhra PradeshAP
state_in_arinArunachal PradeshAR
state_in_asinAssamAS
state_in_brinBiharBR
state_in_chinChandigarhCH
state_in_cginChattisgarhCG
state_in_dninDadra and Nagar HaveliDN
state_in_ddinDaman and DiuDD
state_in_dlinDelhiDL
state_in_gainGoaGA
state_in_gjinGujaratGJ
state_in_hrinHaryanaHR
state_in_hpinHimachal PradeshHP
state_in_jkinJammu and KashmirJK
state_in_jhinJharkhandJH
state_in_kainKarnatakaKA
state_in_klinKeralaKL
state_in_ldinLakshadweepLD
state_in_mpinMadhya PradeshMP
state_in_mhinMaharashtraMH
state_in_mninManipurMN
state_in_mlinMeghalayaML
state_in_mzinMizoramMZ
state_in_nlinNagalandNL
state_in_orinOrissaOR
state_in_pyinPuducherryPY
state_in_pbinPunjabPB
state_in_rjinRajasthanRJ
state_in_skinSikkimSK
state_in_tninTamil NaduTN
state_in_tsinTelanganaTS
state_in_trinTripuraTR
state_in_upinUttar PradeshUP
state_in_ukinUttarakhandUK
state_in_wbinWest BengalWB
state_id_acidAcehAC
state_id_baidBaliBA
state_id_bbidBangka BelitungBB
state_id_btidBantenBT
state_id_beidBengkuluBE
state_id_goidGorontaloGO
state_id_jkidJakartaJK
state_id_jaidJambiJA
state_id_jbidJawa BaratJB
state_id_jtidJawa TengahJT
state_id_jiidJawa TimurJI
state_id_kbidKalimantan BaratKB
state_id_ksidKalimantan SelatanKS
state_id_ktidKalimantan TengahKT
state_id_kiidKalimantan TimurKI
state_id_kuidKalimantan UtaraKU
state_id_kridKepulauan RiauKR
state_id_laidLampungLA
state_id_maidMalukuMA
state_id_muidMaluku UtaraMU
state_id_nbidNusa Tenggara BaratNB
state_id_ntidNusa Tenggara TimurNT
state_id_paidPapuaPA
state_id_pbidPapua BaratPB
state_id_riidRiauRI
state_id_sridSulawesi BaratSR
state_id_snidSulawesi SelatanSN
state_id_stidSulawesi TengahST
state_id_sgidSulawesi TenggaraSG
state_id_saidSulawesi UtaraSA
state_id_sbidSumatra BaratSB
state_id_ssidSumatra SelatanSS
state_id_suidSumatra UtaraSU
state_id_yoidYogyakartaYO
state_co_01coAntioquiaANT
state_co_02coAtlánticoATL
state_co_03coD.C.DC
state_co_04coBolívarBOL
state_co_05coBoyacáBOY
state_co_06coCaldasCAL
state_co_07coCaquetáCAQ
state_co_08coCaucaCAU
state_co_09coCesarCES
state_co_10coCórdobaCOR
state_co_11coCundinamarcaCUN
state_co_12coChocóCHO
state_co_13coHuilaHUI
state_co_14coLa GuajiraLAG
state_co_15coMagdalenaMAG
state_co_16coMetaMET
state_co_17coNariñoNAR
state_co_18coNorte de SantanderNSA
state_co_19coQuindioQUI
state_co_20coRisaraldaRIS
state_co_21coSantanderSAN
state_co_22coSucreSUC
state_co_23coTolimaTOL
state_co_24coValle del CaucaVAC
state_co_25coAraucaARA
state_co_26coCasanareCAS
state_co_27coPutumayoPUT
state_co_28coArchipiélago de San Andrés, Providencia y Santa CatalinaSAP
state_co_29coAmazonasAMA
state_co_30coGuainíaGUA
state_co_31coGuaviareGUV
state_co_32coVaupésVAU
state_co_33coVichadaVID
state_mn_01mnАрхангай01
state_mn_02mnБаян-Өлгий02
state_mn_03mnБаянхонгор03
state_mn_04mnБулган04
state_mn_05mnГовь-Алтай05
state_mn_06mnДорноговь06
state_mn_07mnДорнод07
state_mn_08mnДундговь08
state_mn_09mnЗавхан09
state_mn_10mnӨвөрхангай10
state_mn_11mnӨмнөговь11
state_mn_12mnСүхбаатар12
state_mn_13mnСэлэнгэ13
state_mn_14mnТөв14
state_mn_15mnУвс15
state_mn_16mnХовд16
state_mn_17mnХөвсгөл17
state_mn_18mnХэнтий18
state_mn_19mnДархан-Уул19
state_mn_20mnОрхон20
state_mn_23mnУБ - Хан Уул23
state_mn_24mnУБ - Баянзүрх24
state_mn_25mnУБ - Сүхбаатар25
state_mn_26mnУБ - Баянгол26
state_mn_27mnУБ - Багануур27
state_mn_28mnУБ - Багахангай28
state_mn_29mnУБ - Налайх29
state_mn_32mnГовьсүмбэр32
state_mn_34mnУБ - Сонгино Хайрхан34
state_mn_35mnУБ - Чингэлтэй35
state_uk1ukAberdeenshireA1
state_uk2ukAngusA5
state_uk3ukArgyllA7
state_uk4ukAvonA9
state_uk5ukAyrshireB1
state_uk6ukBanffshireB3
state_uk7ukBedfordshireB5
state_uk8ukBerkshireB7
state_uk9ukBerwickshireB9
state_uk10ukBuckinghamshireC1
state_uk11ukCaithnessC3
state_uk12ukCambridgeshireC5
state_uk13ukChannel IslandsC6
state_uk14ukCheshireC7
state_uk15ukClackmannanshireC9
state_uk16ukClevelandD1
state_uk17ukClwydD3
state_uk18ukCounty AntrimD5
state_uk19ukCounty ArmaghD7
state_uk20ukCounty DownD9
state_uk21ukCounty DurhamE1
state_uk22ukCounty FermanaghE3
state_uk23ukCounty LondonderryE5
state_uk24ukCounty TyroneE7
state_uk25ukCornwallE9
state_uk26ukCumbriaF1
state_uk27ukDerbyshireF3
state_uk28ukDevonF5
state_uk29ukDorsetF7
state_uk30ukDumfriesshireF9
state_uk31ukDunbartonshireG1
state_uk32ukDyfedG3
state_uk33ukEast LothianG5
state_uk34ukEast SussexG7
state_uk35ukEssexG9
state_uk36ukFifeH1
state_uk37ukGloucestershireH3
state_uk38ukGwentH7
state_uk39ukGwyneddH9
state_uk40ukHampshireI1
state_uk41ukHerefordshireI3
state_uk42ukHertfordshireI5
state_uk43ukInverness-ShireI7
state_uk44ukIsle of ArranI9
state_uk45ukIsle of BarraJ1
state_uk46ukIsle of BenbeculaJ3
state_uk47ukIsle of ButeJ5
state_uk48ukIsle of CannaJ7
state_uk49ukIsle of CollJ9
state_uk50ukIsle of ColonsayK1
state_uk51ukIsle of CumbraeK3
state_uk52ukIsle of EiggK5
state_uk53ukIsle of GighaK7
state_uk54ukIsle of HarrisK9
state_uk55ukIsle of IonaL1
state_uk56ukIsle of IslayL2
state_uk57ukIsle of JuraL5
state_uk58ukIsle of LewisL7
state_uk59ukIsle of ManL9
state_uk60ukIsle of MullM1
state_uk61ukIsle of North UistM3
state_uk62ukIsle of RhumM7
state_uk63ukIsle of ScalpayM9
state_uk64ukShetland IslandsN1
state_uk65ukIsle of SkyeN3
state_uk66ukIsle of South UistN5
state_uk67ukIsle of TireeN7
state_uk68ukIsle of WightN9
state_uk69ukKentO5
state_uk70ukKincardineshireO7
state_uk71ukKinross-ShireO9
state_uk72ukKirkcudbrightshireP1
state_uk73ukLancashireP5
state_uk74ukLeicestershireP7
state_uk75ukLincolnshireP9
state_uk76ukMerseysideQ3
state_uk77ukMid GlamorganQ5
state_uk78ukMiddlesexQ9
state_uk79ukMorayshireR1
state_uk80ukNairnshireR3
state_uk81ukNorth HumbersideR7
state_uk82ukNorth YorkshireR9
state_uk83ukNorthamptonshireS1
state_uk84ukNorthumberlandS3
state_uk85ukNottinghamshireS5
state_uk86ukOxfordshireS7
state_uk87ukPeeblesshireS9
state_uk88ukPerthshireT1
state_uk89ukPowysT3
state_uk90ukRenfrewshireT5
state_uk91ukRoss-ShireT7
state_uk92ukRoxburghshireT9
state_uk93ukSelkirkshireU3
state_uk94ukShropshireU5
state_uk95ukSomersetU7
state_uk96ukSouth GlamorganU9
state_uk97ukSouth HumbersideV1
state_uk98ukSouth YorkshireV3
state_uk99ukStaffordshireV5
state_uk100ukStirlingshireV7
state_uk101ukSuffolkV9
state_uk102ukSurreyW1
state_uk103ukSutherlandW3
state_uk104ukTyne and WearW5
state_uk105ukWarwickshireW7
state_uk106ukWest GlamorganW9
state_uk107ukWest LothianX1
state_uk108ukWest MidlandsX3
state_uk109ukWest SussexX5
state_uk110ukWest YorkshireX7
state_uk111ukWigtownshireX9
state_uk112ukWiltshireY1
state_uk113ukWorcestershireY3
state_uk114ukOrkneyM5
state_uk115ukIsles of ScillyO1
state_uk116ukLanarkshireP3
state_uk117ukLondonQ1
state_uk118ukMidlothianQ7
state_uk119ukNorfolkR5
RO_ABroAlbaAB
RO_AGroArgeșAG
RO_ARroAradAR
RO_BroBucureștiB
RO_BCroBacăuBC
RO_BHroBihorBH
RO_BNroBistrița-NăsăudBN
RO_BRroBrăilaBR
RO_BTroBotoșaniBT
RO_BVroBrașovBV
RO_BZroBuzăuBZ
RO_CJroClujCJ
RO_CLroCălărașiCL
RO_CSroCaraș SeverinCS
RO_CTroConstanțaCT
RO_CVroCovasnaCV
RO_DBroDâmbovițaDB
RO_DJroDoljDJ
RO_GJroGorjGJ
RO_GLroGalațiGL
RO_GRroGiurgiuGR
RO_HDroHunedoaraHD
RO_HRroHarghitaHR
RO_IFroIlfovIF
RO_ILroIalomițaIL
RO_ISroIașiIS
RO_MHroMehedințiMH
RO_MMroMaramureșMM
RO_MSroMureșMS
RO_NTroNeamțNT
RO_OTroOltOT
RO_PHroPrahovaPH
RO_SBroSibiuSB
RO_SJroSălajSJ
RO_SMroSatu MareSM
RO_SVroSuceavaSV
RO_TLroTulceaTL
RO_TMroTimișTM
RO_TRroTeleormanTR
RO_VLroVâlceaVL
RO_VNroVranceaVN
RO_VSroVasluiVS
state_cn_BJcn北京市
state_cn_SHcn上海市
state_cn_ZJcn浙江省
state_cn_TJcn天津市
state_cn_AHcn安徽省
state_cn_FJcn福建省
state_cn_CQcn重庆市
state_cn_JXcn江西省
state_cn_SDcn山东省
state_cn_HAcn河南省
state_cn_NMcn内蒙古自治区
state_cn_HBcn湖北省
state_cn_XJcn新疆维吾尔自治区
state_cn_HNcn湖南省
state_cn_NXcn宁夏回族自治区
state_cn_GDcn广东省
state_cn_XZcn西藏自治区
state_cn_HIcn海南省
state_cn_GXcn广西壮族自治区
state_cn_SCcn四川省
state_cn_HEcn河北省
state_cn_GZcn贵州省
state_cn_SXcn山西省
state_cn_YNcn云南省
state_cn_LNcn辽宁省
state_cn_SNcn陕西省
state_cn_JLcn吉林省
state_cn_GScn甘肃省
state_cn_HLcn黑龙江省
state_cn_QHcn青海省
state_cn_JScn江苏省
state_cn_TWcn台湾省
state_cn_HKcn香港特别行政区
state_cn_MOcn澳门特别行政区
state_et_1etAddis AbabaAA
state_et_2etAfarAF
state_et_3etAmharaAM
state_et_4etBenishangul-GumuzBN
state_et_5etDire DawaDR
state_et_6etGambella PeoplesGM
state_et_7etHarrari PeoplesHR
state_et_8etOromiaOR
state_et_9etSomaliaSM
state_et_10etSouthern Peoples, Nations, and NationalitiesSP
state_et_11etTigrayTG
state_ie_1ieCarlowCW
state_ie_2ieCavanCN
state_ie_3ieClareCE
state_ie_4ieCorkC
state_ie_5ieLimerickLK
state_ie_6ieWaterfordWD
state_ie_7ieDonegalDL
state_ie_8ieDublinD
state_ie_9ieGalwayG
state_ie_10ieKerryKY
state_ie_11ieKildareKE
state_ie_12ieKilkennyKK
state_ie_13ieLaoisLS
state_ie_14ieLeitrimLM
state_ie_15ieLongfordLD
state_ie_16ieLouthLH
state_ie_17ieMayoMO
state_ie_18ieMeathMH
state_ie_19ieMonaghanMN
state_ie_20ieOffalyOY
state_ie_21ieRoscommonRN
state_ie_22ieSligoSO
state_ie_23ieTipperaryTR
state_ie_24ieWestmeathWH
state_ie_25ieWexfordWX
state_ie_26ieWicklowWW
state_ie_27ieAntrimAM
state_ie_28ieArmaghAH
state_ie_29ieDownDN
state_ie_30ieFermanaghFH
state_ie_31ieLondonderryLY
state_ie_32ieTyroneTE
state_nl_drnlDrentheDR
state_nl_flnlFlevolandFL
state_nl_frnlFrieslandFR
state_nl_genlGelderlandGE
state_nl_grnlGroningenGR
state_nl_linlLimburgLI
state_nl_nbnlNoord-BrabantNB
state_nl_nhnlNoord-HollandNH
state_nl_ovnlOverijsselOV
state_nl_utnlUtrechtUT
state_nl_zenlZeelandZE
state_nl_zhnlZuid-HollandZH
state_nl_bq1nlBonaireBQ1
state_nl_bq2nlSabaBQ2
state_nl_bq3nlSint EustatiusBQ3
state_tr_01trAdana01
state_tr_02trAdıyaman02
state_tr_03trAfyon03
state_tr_04trAğrı04
state_tr_05trAmasya05
state_tr_06trAnkara06
state_tr_07trAntalya07
state_tr_08trArtvin08
state_tr_09trAydın09
state_tr_10trBalıkesir10
state_tr_11trBilecik11
state_tr_12trBingöl12
state_tr_13trBitlis13
state_tr_14trBolu14
state_tr_15trBurdur15
state_tr_16trBursa16
state_tr_17trÇanakkale17
state_tr_18trÇankırı18
state_tr_19trÇorum19
state_tr_20trDenizli20
state_tr_21trDiyarbakır21
state_tr_22trEdirne22
state_tr_23trElazığ23
state_tr_24trErzincan24
state_tr_25trErzurum25
state_tr_26trEskişehir26
state_tr_27trGaziantep27
state_tr_28trGiresun28
state_tr_29trGümüşhane29
state_tr_30trHakkari30
state_tr_31trHatay31
state_tr_32trIsparta32
state_tr_33trİçel33
state_tr_34trİstanbul34
state_tr_35trİzmir35
state_tr_36trKars36
state_tr_37trKastamonu37
state_tr_38trKayseri38
state_tr_39trKırklareli39
state_tr_40trKırşehir40
state_tr_41trKocaeli41
state_tr_42trKonya42
state_tr_43trKütahya43
state_tr_44trMalatya44
state_tr_45trManisa45
state_tr_46trK.maraş46
state_tr_47trMardin47
state_tr_48trMuğla48
state_tr_49trMuş49
state_tr_50trNevşehir50
state_tr_51trNiğde51
state_tr_52trOrdu52
state_tr_53trRize53
state_tr_54trSakarya54
state_tr_55trSamsun55
state_tr_56trSiirt56
state_tr_57trSinop57
state_tr_58trSivas58
state_tr_59trTekirdağ59
state_tr_60trTokat60
state_tr_61trTrabzon61
state_tr_62trTunceli62
state_tr_63trŞanlıurfa63
state_tr_64trUşak64
state_tr_65trVan65
state_tr_66trYozgat66
state_tr_67trZonguldak67
state_tr_68trAksaray68
state_tr_69trBayburt69
state_tr_70trKaraman70
state_tr_71trKırıkkale71
state_tr_72trBatman72
state_tr_73trŞırnak73
state_tr_74trBartın74
state_tr_75trArdahan75
state_tr_76trIğdır76
state_tr_77trYalova77
state_tr_78trKarabük78
state_tr_79trKilis79
state_tr_80trOsmaniye80
state_tr_81trDüzce81
state_vn_VN-44vnAn GiangVN-44
state_vn_VN-57vnBình DươngVN-57
state_vn_VN-31vnBình ĐịnhVN-31
state_vn_VN-54vnBắc GiangVN-54
state_vn_VN-53vnBắc KạnVN-53
state_vn_VN-55vnBạc LiêuVN-55
state_vn_VN-56vnBắc NinhVN-56
state_vn_VN-58vnBình PhướcVN-58
state_vn_VN-43vnBà Rịa - Vũng TàuVN-43
state_vn_VN-40vnBình ThuậnVN-40
state_vn_VN-50vnBến TreVN-50
state_vn_VN-04vnCao BằngVN-04
state_vn_VN-59vnCà MauVN-59
state_vn_VN-CTvnTP Cần ThơVN-CT
state_vn_VN-71vnĐiện BiênVN-71
state_vn_VN-33vnĐắk LắkVN-33
state_vn_VN-DNvnTP Đà NẵngVN-DN
state_vn_VN-39vnĐồng NaiVN-39
state_vn_VN-72vnĐắk NôngVN-72
state_vn_VN-45vnĐồng ThápVN-45
state_vn_VN-30vnGia LaiVN-30
state_vn_VN-14vnHòa BìnhVN-14
state_vn_VN-SGvnTP Hồ Chí MinhVN-SG
state_vn_VN-61vnHải DươngVN-61
state_vn_VN-73vnHậu GiangVN-73
state_vn_VN-03vnHà GiangVN-03
state_vn_VN-HNvnHà NộiVN-HN
state_vn_VN-63vnHà NamVN-63
state_vn_VN-HPvnTP Hải PhòngVN-HP
state_vn_VN-23vnHà TĩnhVN-23
state_vn_VN-66vnHưng YênVN-66
state_vn_VN-47vnKiên GiangVN-47
state_vn_VN-34vnKhánh HòaVN-34
state_vn_VN-28vnKon TumVN-28
state_vn_VN-41vnLong AnVN-41
state_vn_VN-02vnLào CaiVN-02
state_vn_VN-01vnLai ChâuVN-01
state_vn_VN-35vnLâm ĐồngVN-35
state_vn_VN-09vnLạng SơnVN-09
state_vn_VN-22vnNghệ AnVN-22
state_vn_VN-18vnNinh BìnhVN-18
state_vn_VN-67vnNam ĐịnhVN-67
state_vn_VN-36vnNinh ThuậnVN-36
state_vn_VN-68vnPhú ThọVN-68
state_vn_VN-32vnPhú YênVN-32
state_vn_VN-24vnQuảng BìnhVN-24
state_vn_VN-13vnQuảng NinhVN-13
state_vn_VN-27vnQuảng NamVN-27
state_vn_VN-29vnQuảng NgãiVN-29
state_vn_VN-25vnQuảng TrịVN-25
state_vn_VN-05vnSơn LaVN-05
state_vn_VN-52vnSóc TrăngVN-52
state_vn_VN-20vnThái BìnhVN-20
state_vn_VN-46vnTiền GiangVN-46
state_vn_VN-21vnThanh HóaVN-21
state_vn_VN-69vnThái NguyênVN-69
state_vn_VN-37vnTây NinhVN-37
state_vn_VN-07vnTuyên QuangVN-07
state_vn_VN-26vnThừa Thiên - HuếVN-26
state_vn_VN-51vnTrà VinhVN-51
state_vn_VN-49vnVĩnh LongVN-49
state_vn_VN-70vnVĩnh PhúcVN-70
state_vn_VN-06vnYên BáiVN-06
state_SJcrSan JoséCR-SJ
state_AcrAlajuelaCR-A
state_HcrHerediaCR-H
state_CcrCartagoCR-C
state_PcrPuntarenasCR-P
state_GcrGuanacasteCR-G
state_LcrLimónCR-L
state_DO_01doDistrito NacionalDN
state_DO_02doAzuaAZU
state_DO_03doBahorucoBAH
state_DO_04doBarahonaBAR
state_DO_05doDajabónDAJ
state_DO_06doDuarteDUA
state_DO_07doElías PiñaELP
state_DO_08doEl SeiboELS
state_DO_09doEspaillatESP
state_DO_10doIndependenciaIND
state_DO_11doLa AltagraciaLA
state_DO_12doLa RomanaLR
state_DO_13doLa VegaLV
state_DO_14doMaría Trinidad SánchezMTS
state_DO_15doMonte CristiMC
state_DO_16doPedernalesPED
state_DO_17doPeraviaPER
state_DO_18doPuerto PlataPP
state_DO_19doHermanas MirabalHEM
state_DO_20doSamanáSAM
state_DO_21doSan CristóbalSC
state_DO_22doSan JuanSJ
state_DO_23doSan Pedro de MacorísSPM
state_DO_24doSánchez RamírezSRA
state_DO_25doSantiagoSTGO
state_DO_26doSantiago RodríguezSRO
state_DO_27doValverdeVAL
state_DO_28doMonseñor NouelMON
state_DO_29doMonte PlataMP
state_DO_30doHato MayorHAM
state_DO_31doSan José de OcoaSJO
state_DO_32doSanto DomingoSD
state_pe_01peAmazonas01
state_pe_02peÁncash02
state_pe_03peApurímac03
state_pe_04peArequipa04
state_pe_05peAyacucho05
state_pe_06peCajamarca06
state_pe_07peCallao07
state_pe_08peCusco08
state_pe_09peHuancavelica09
state_pe_10peHuánuco10
state_pe_11peIca11
state_pe_12peJunin12
state_pe_13peLa Libertad13
state_pe_14peLambayeque14
state_pe_15peLima15
state_pe_16peLoreto16
state_pe_17peMadre de Dios17
state_pe_18peMoquegua18
state_pe_19pePasco19
state_pe_20pePiura20
state_pe_21pePuno21
state_pe_22peSan Martín22
state_pe_23peTacna23
state_pe_24peTumbes24
state_pe_25peUcayali25
state_cl_01clTarapacá01
state_cl_02clAntofagasta02
state_cl_03clAtacama03
state_cl_04clCoquimbo04
state_cl_05clValparaíso05
state_cl_06cldel Libertador Gral. Bernardo O’Higgins06
state_cl_07cldel Maule07
state_cl_08cldel BíoBio08
state_cl_09clde la Araucania09
state_cl_10clde los Lagos10
state_cl_11clAysén del Gral. Carlos Ibáñez del Campo11
state_cl_12clMagallanes12
state_cl_13clMetropolitana13
state_cl_14clLos Ríos14
state_cl_15clArica y Parinacota15
state_cl_16cldel Ñuble16

For each row (record):

  • the first column is the external id of the record to create or update
  • the second column is the external id of the country object to link to (country objects must have been defined beforehand)
  • the third column is the name field for res.country.state
  • the fourth column is the code field for res.country.state