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
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 |
|
|