This repository contains lists of world countries, administrative subdivision with postal Code in CSV, you can freely download and import to your database.
###Database Structure###
geo_continent
- id
- name
- fips
geo_country
- id
- id_continent
- name
- name_official
- name_native
- fips
- iso_alpha_2
- iso_alpha_3
geo_subdivision
- id
- id_country
- id_subdivision
- id_subdivision_type
- administrative_order
- name
- name_official
- name_native
- fips
- iso_alpha_2
- iso_alpha_3
- timezone_offset
- postal_code_start
- postal_code_end
- postal_code
geo_subdivision_type
- id
- name
###Version Log###
V.01
- Initial version
- 7 continents
- 247 countries
- 144,445 subdivision
- 5 subdivision type
Detail :
-
Indonesia
- Administrative Order 1 : 34
- Administrative Order 2 : 514
- Administrative Order 3 : 6998
- Administrative Order 4 : 136118
Order 1 : Province Order 2 : Regency / City Order 3 : District Order 4 : Village
-
Thailand
- Administrative Order 1 : 77
- Administrative Order 2 : 704
Order 1 : Province / Municipality Order 2 : Distrct