Table Columns

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
state_province_id bigint YES Foreign key to table state_province
state_province_code2_full text YES Unique alternate state/province code, including parent codes
state_province_code2 text YES Alternate state/province code
state_province_code text YES Standard state/province code
state_province_ascii text YES Ascii version of state/province name
hasc_2_full text YES Unique HASC code, including parent codes
hasc_2 text YES HASC code
county_parish_std character varying YES Standard county/parish name used in BIEN database
county_parish_id integer NO Integer primary key. Uniquely identifies each record in this table.
county_parish_code2_full text YES Unique alternate county/parish code, including parent codes
county_parish_code2 text YES Alternate county/parish code
county_parish_code_full text YES Unique county/parish code, including parent codes
county_parish_ascii text YES Ascii version of standard county/parish name
county_parish text YES Standard geonames name for this county/parish
country_iso text YES Standard country ISO code
country_id bigint YES Foreign key to table country
country text YES Standard country name
state_province text YES Standard state/province name
county_parish_code text YES Short county/parish code