| Column Name | Data Type | Description |
|---|---|---|
| key_id | integer |
Unique ID number, primary key. (Each number can only occur once in this table) |
| pinyin_name | character (80) | Name of entry in pinyin romanization. |
| char_name | character (80) | Name of entry in Chinese characters. |
| hac_code | character(40) | Complete Historical Administrative Code. |
| stv_code | character(80) | Complete Spatio-Temporal Variant Code. |
| hac_period | character(4) |
Three letter code for Dynastic Period. (Example: Qeq = Qing, Early Qing) |
| hac_circ | character(3) | Two (or more) Capital letter code, beginning AB, for Circuit level unit or alternate Regime (null if not applicable). |
| hac_prov | integer | Two (or more) digit code for Province level unit (null if not applicable). |
| hac_superpf | character(3) | Two (or more) Capital letter code, beginning AB, for Super-prefecture level unit (null if not applicable). |
| hac_pref | integer | Two (or more) digit code for Prefecture level unit (null if not applicable). |
| hac_subpref | character(3) | Two (or more) lower-case letter code, beginning ab, for Sub-prefecture level unit (null if not applicable). |
| hac_dist | character(4) | Two (or more) lower-case letter code, beginning zy, for Sub-prefecture level unit (null if not applicable). |
| hac_cnty | integer | Two (or more) digit code for County level unit (null if not applicable). |
| hac_twns | integer | Two (or more) digit code for Township level unit (null if not applicable). |
| hac_vill | integer | Two (or more) digit code for Village level unit (null if not applicable). |
| hac_notes | character (long) | Detailed description of any special cases, rare administrative unit types used, or other relevant information about the administrative levels being listed. |