Names of Registration Counties appearing in occ_1881.

Table ID:
OCC_1881_REGC_CODES     (6566413)
Contents:
Names of Registration Counties appearing in occ_1881.
Approx. number of rows:
60
Table type:
Gazetteer
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. This data set was constructed by Humphrey Southall in September 2002 by extracting all the unique values of 'regc_code' from 'occ_1881' and then manually appending the county name. In most cases the county was obvious, but in a few cases it was necessary to query other parts of the 'occ_1881' data.


Notes:

  1. As well as the 1881 Registration Counties of England and Wales, this table also includes: "IOM"="ISLE OF MAN", "ADY"="ALDERNEY", "GSY"="GUERNSEY", "JSY"="JERSEY" and "SAR"="SARK". Because there were a few rows in the data supplied by Essex with no values for 'regc_code', this table also includes: "UNK"="UNKNOWN"


Checking:

  1. The values of 'regc_code' were extracted directly from the 'occ_1881' table. No other checking is meaningful.


Indices:

IndexTypeColumn(s) indexed
occ_1881_regc_codes_pkey Primary key regc_code


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
occ_1881_regc_codes_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
regc_code Text string (max.len.=7). Three-letter abbreviation for the Registration County.
reg_cnty Text string (max.len.=30). Full name of the Registration County.
regc_unit Integer number. ID for unit as defined in the GBH Administrative Unit Ontology. NB this is correctly set for the Isle of Man and the Channel Islands, as well as for the actual Registration Counties.