Historical Administrative Code Table (HACT) - Table Definition
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.