If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings

Sort columns ordinally   Sort columns alphabetically Columns in table "county_parish" Column Data Type Null Description Values county_parish_id integer NO Integer primary key. Uniquely identifies each record in this table. country text YES Standard country name from geonames database (GNRS) country_iso text YES Standard country ISO code country_id bigint YES Foreign key to table country state_province_id bigint YES Foreign key to table state_province state_province text YES Standard state/province name state_province_ascii text YES Ascii version of state/province name state_province_code text YES Standard state/province code county_parish text YES Standard geonames name for this county/parish county_parish_ascii text YES Ascii version of standard county/parish name county_parish_code text YES Short county/parish code county_parish_code_full text YES Unique county/parish code, including parent codes hasc_2 text YES HASC code hasc_2_full text YES Unique HASC code, including parent codes county_parish_std character varying YES Standard county/parish name used in BIEN database state_province_code2 text YES Alternate state/province code state_province_code2_full text YES Unique alternate state/province code, including parent codes county_parish_code2 text YES Alternate county/parish code county_parish_code2_full text YES Unique alternate county/parish code, including parent codes