1881 occupational statistics for the counties of England and Wales.

Table ID:

OCC_1881_EW_CNTY     (1251842)

Contents:

1881 occupational statistics for the counties of England and Wales.

Approx. number of rows:

24,399

Table type:

Raw Data

Documentation Author:

Humphrey Southall

Geography:

Reporting units are identified by:
   Registration County
   Registration District Number

Chronology:

The data are for the single year 1881.

Sources:

1. The data are a partial transcription of 'Table 10 - Occupations of Males and Females aged 10 years and upwards in the [Registration Division Name] and its Registration Counties, and in each Urban Sanitary District of which the Population exceeds 50,000', taken from Census of England and Wales (43 and 44 Vict. C. 37 - 1881 - Volume III - Ages, Condition as to Marriage, Occupations and Birth-Places of the people. A separate Table 10 was produced for each of the 11 Census Divisions but they have been combined here. Data for the Isle of Man and the Channel Isles are also included, but not Scotland.
2. This is an incomplete transcription of the full table, as the original table also includes data for the larger urban sanitary districts but only the data for counties, and for the 'islands in the British Seas' are included here. It is partial also because the totals for the various classes and orders are excluded, but they can easily be calculated from the data for individual occupations held here.
3. The original table does not include footnotes apart from a note attached to each of the 11 tables describing how those recorded under certain occupations have been categorised.

---

Notes:

1. These data were transcribed by Matthew Woollard.
2. The data were standardised by CDDA to follow more closely the structure of other occupational datasets read into Oracle. Specifically, in the original spreadsheet supplied by Matthew Woollard all occupational data was placed into one field. We have divided this information up into separate Class, Order and sub-Order fields. Further, the locational data was organised in column format so that the spreadsheet had many columns but few rows. We have significantly reorganised this. Locational data is recorded in two fields which means that our tables has many rows but few columns.
3. The database table name was changed from occ_1881 to be occ_1881_ew_cnty to more accurately reflect the contents.

---

Checking:

1. Data were checked by Matthew Woollard at the University of Essex. CDDA have access to the original printed table and have conducted limited additional checks. They compared total males and total females from the printed table with summed male and summed female data calculated from the electronic data. In both cases the electronic table undercounts males and females by 2017 and 1087 respectively. As these error rates are low, we have not attempted to correct the data.

---

Acknowledgments:

We are extremely grateful to the following:

1. Matthew Woollard: These data were computerised by Matthew Woollard. The data are freely available but Matthew should be acknowledged.

---

Indices:

Index	Type	Column(s) indexed
occ_1881_ew_cnty_idx	Unique	reg_cnty, class, occ_order, sub_order, occupation, mw_code

---

Columns within table:

Column	Type	Contents
reg_cnty	Text string (max.len.=36).	The name of the Registration County to which the data relate. London is not included as a unit, but as three separate 'intra-metro.' parts of Kent, Middlesex and Surrey, with the remainders of those counties listed as 'extra-metro'.
reg_num	Integer number.	The number of the Registration County to which the data relate. This field was added during transcription at Essex. These numbers are NOT the county numbers assigned in the printed table).
mw_code	Integer number.	Occupation reference code. Added during transcription by Matthew Woollard at the University of Essex. The code is six numeric characters long and has been generated by taking the Order, sub-Order and Occupation two number codes and combining them. The original printed table does not include an occupational code number. This has been generated during transcription and is simply based on a two-number count of each occupation within each sub-Order. These codes are defined in the table 'occ_1881_occ_codes'.
class_num	Text string (max.len.=8).	Occupational class reference number. These appear as roman numerals in the paper table but have been converted to Arabic style during transcription.
class	Text string (max.len.=28).	Occupational Class name. These are the major occupational divisions. Each occupation falls into one of 6 (VI) groups.
order_num	Integer number.	Occupational Order reference number. These are recorded in the original report.
occ_order	Text string (max.len.=64).	Occupational Order name.
sub_order	Text string (max.len.=54).	Occupational sub_Order name. In the printed report the sub-Order also has a reference number. This has not been transcribed.
occupation	Text string (max.len.=124).	The specific occupation.
males	Integer number.	Total males in the specified occupation.
females	Integer number.	Total females in the specified occupation.
notes	Long text.	Notes added during post processing of the data from Essex or later.
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. The intra-metropolitan parts of Middlesex, Surrey and Kent are all treated as 'London'.
nat_unit	Integer number.	ID for containing nation, as defined in the GBH Administrative Unit Ontology. This is null for the Isle of Man and the Channel Islands.
occ_code	Integer number.	Sequence number identifying occupation, as defined and looked up from the occ_1881_occ_codes table. This forms the basis for the cell references used for these data in the main data table.