subdivisions
Data source: ISO
43 rows where country_code = "HU"
This data as json, CSV (advanced)
Link | country_code | code_31662 | name | local_variant | language_code | romanization_system | parent_subdivision |
---|---|---|---|---|---|---|---|
HU,HU-BA | HU | HU-BA | Baranya | hu | |||
HU,HU-BC | HU | HU-BC | Békéscsaba | hu | |||
HU,HU-BE | HU | HU-BE | Békés | hu | |||
HU,HU-BK | HU | HU-BK | Bács-Kiskun | hu | |||
HU,HU-BU | HU | HU-BU | Budapest | hu | |||
HU,HU-BZ | HU | HU-BZ | Borsod-Abaúj-Zemplén | hu | |||
HU,HU-CS | HU | HU-CS | Csongrád | hu | |||
HU,HU-DE | HU | HU-DE | Debrecen | hu | |||
HU,HU-DU | HU | HU-DU | Dunaújváros | hu | |||
HU,HU-EG | HU | HU-EG | Eger | hu | |||
HU,HU-ER* | HU | HU-ER* | Érd | hu | |||
HU,HU-FE | HU | HU-FE | Fejér | hu | |||
HU,HU-GS | HU | HU-GS | Győr-Moson-Sopron | hu | |||
HU,HU-GY | HU | HU-GY | Győr | hu | |||
HU,HU-HB | HU | HU-HB | Hajdú-Bihar | hu | |||
HU,HU-HE | HU | HU-HE | Heves | hu | |||
HU,HU-HV | HU | HU-HV | Hódmezővásárhely | hu | |||
HU,HU-JN | HU | HU-JN | Jász-Nagykun-Szolnok | hu | |||
HU,HU-KE | HU | HU-KE | Komárom-Esztergom | hu | |||
HU,HU-KM | HU | HU-KM | Kecskemét | hu | |||
HU,HU-KV | HU | HU-KV | Kaposvár | hu | |||
HU,HU-MI | HU | HU-MI | Miskolc | hu | |||
HU,HU-NK | HU | HU-NK | Nagykanizsa | hu | |||
HU,HU-NO | HU | HU-NO | Nógrád | hu | |||
HU,HU-NY | HU | HU-NY | Nyíregyháza | hu | |||
HU,HU-PE | HU | HU-PE | Pest | hu | |||
HU,HU-PS | HU | HU-PS | Pécs | hu | |||
HU,HU-SD | HU | HU-SD | Szeged | hu | |||
HU,HU-SF | HU | HU-SF | Székesfehérvár | hu | |||
HU,HU-SH | HU | HU-SH | Szombathely | hu | |||
HU,HU-SK | HU | HU-SK | Szolnok | hu | |||
HU,HU-SN | HU | HU-SN | Sopron | hu | |||
HU,HU-SO | HU | HU-SO | Somogy | hu | |||
HU,HU-SS | HU | HU-SS | Szekszárd | hu | |||
HU,HU-ST | HU | HU-ST | Salgótarján | hu | |||
HU,HU-SZ | HU | HU-SZ | Szabolcs-Szatmár-Bereg | hu | |||
HU,HU-TB | HU | HU-TB | Tatabánya | hu | |||
HU,HU-TO | HU | HU-TO | Tolna | hu | |||
HU,HU-VA | HU | HU-VA | Vas | hu | |||
HU,HU-VE | HU | HU-VE | Veszprém | hu | |||
HU,HU-VM | HU | HU-VM | Veszprém | hu | |||
HU,HU-ZA | HU | HU-ZA | Zala | hu | |||
HU,HU-ZE | HU | HU-ZE | Zalaegerszeg | hu |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE subdivisions ( country_code text NOT NULL , code_31662 text NOT NULL , name text , local_variant text , language_code text , romanization_system text , parent_subdivision text , PRIMARY KEY (country_code , code_31662) , FOREIGN KEY (country_code) REFERENCES countries (alpha_2_code) ON DELETE CASCADE , FOREIGN KEY (language_code) REFERENCES languages (alpha_2_code) ON DELETE CASCADE );