1911 Occupation Statistics reorganised to 2007 Standard Industrial Classification

Table ID:

OCC_1911_SIC2007     (1251924)

Contents:

1911 Occupation Statistics reorganised to 2007 Standard Industrial Classification

Approx. number of rows:

91,444

Table type:

Derived

Documentation Author:

Humphrey Southall

Geography:

Reporting units are identified by:
   Administrative County
   Local Government District
   Local Government District Type

Chronology:

The data are for the single year 1911.

Sources:

1. The contents of this table are entirely derived from:
   • Table 13, in the 1911 Occupation Tables, which provides data for towns over 50,000 population, plus county aggregates for all Rural Districts and all remaining towns.
   • Tables 15A and 15B in the same report, which contain simplified occupational data for towns between 5,000 and 50,000 population.
   • 1911 Occupation Codebook, used to re-allocate the data to the 2007 Standardised Industrial Classification.
   • 1911 age- and gender-structure table, listing all local government districts and providing the numbers of males and of females aged 10 or over, who are the subject of the Occupation Tables. The names of districts held here are all in fact taken from that table.

---

Notes:

1. The data held here are estimates of varying precision depending on the type of unit:
   • The data for all County Boroughs, all Metropolitan Boroughs and those Municipal Boroughs and Urban Districts with total populations over 50,000 are exact counts, based on re-classifying 1911 occupation data to SIC 2007.
   • Calculations for urban units with populations between 5,000 and 50,000 are particularly complex. In essence, numbers in each detailed occupational category across all towns under 50,000 in a county were computed by deducting numbers in the large towns and in Rural District from the county totals. Next, the 1911 occupation codebook was used to assign each of these detailed categories to a simplified category based on those used in the "small towns" tables; and different simplified categories had to be defined for men and for women. Then the data for small towns was used to compute, for each of these simplified categories, the fraction of all workers across all small towns who were in each particular town, and these fractions were applied to the detailed categories for all small towns to estimate numbers in each detailed category in each small town over 5,000, and also for the county total for towns under 5,000. Finally, these figures were re-classified to SIC 2007.
   • For urban units with populations under 5,000, the 1911 age-structure data held in age_lgd_ew was used to compute the fractions of all males and all females aged 10 and above living in all such towns in a county who were living in each particular town, and these fractions were applied to each SIC 2007 category as computed for all such towns as part of the calculations for all towns under 50,000.
   • For Rural Districts, data from the age structure data were used in the same way, applying the fractions to the re-classified data for all Rural Districts in each county taken from the "large towns" table.
2. As noted above, some of the categories in the small towns table have a complex relationship with those in the large towns table, and the following mergers were made for male workers:
   • Category VI_DOCK, "Dock labourers, wharf labourers, coal heavers; Coal-Porters and labourers", was merged into VI_OTHER, "Others in Conveyance of Men, Goods and Messages".
   • IX1_COAL, "Coal and shale mine-workers (including Mine Service)", and IX1_OTH, "Others working in and about, and in the products of Mines and Quarries", were combined into IX1.
   • XIV1_BRK, "Brick, Plain Tile, Terra-Cotta Makers", and XIV1_EARTH, "Earthenware, China, Porcelain, Glass Manufacture", were combined into XIV1.
   • XVIII7, "Drapers, Linen Drapers", was combined into OTHERS.
   • Two other categories showed discrepancies and could arguably have also been merged into OTHERS, but the discrepancies were small relative to their overall size so they were retained: XIV1 ("Brick, Cement, Pottery and Glass") and XXII5 ("General Labourers; Factory Labourers (undefined)").
3. Similarly, the following mergers were made for female workers:
   • XIX1STAY, "Staymakers, Shirtmakers, Seamstresses", was merged into XIX1OTHER, "Other Workers in Dress".
   • The following categories were all combined into OTHERS: I1VI5 ("Civil Service. Telegraph, Telephone Service"), I2IV3 ("Municipal, Parish, etc Officers. Hospital and Institution Service"), III57 ("Literary, Scientific and Political. Art, Music, Drama"), V234III2 ("Commercial, Bank, and Insurance Clerks. Law Clerks"), XVIII7XIX1 ("Drapers, Linen Drapers, Mercers. Dealers in Dress") and XX1XXII4 ("Food - Dealers. General Shopkeepers, Dealers").
4. There are inevitably some problems due to the data being for Occupations while the classification applied here is Industry, i.e. employer's business, but the vast majority of occupations in 1911 were industry-specific. A larger problem of classification is the inclusion of people who sold things with the people who made them.
5. The table includes persons classified as "Retired or Unoccupied", who are given the SIC Division number of 999.
6. There is scope for improving the handling of smaller towns, but there are also unavoidable problems with large Rural Districts which were clearly not farming areas: Rural Districts over 50,000 population included Chesterfield (Derbyshire) with 72,277, Chester le Street (Durham) with 63,878, Croydon (Surrey) with 65,133, and Yardley (Worcestershire) with 59,165. Many of the RDs with large populations were mining districts.

---

Checking:

1. The total numbers of males and females aged 10 and over in the age structure table were compared with the overall totals in the Occupations table for all the towns for which the latter provided data, and the only discrepancy was for Wakefield MB, West Riding, where the Occupation table gave a larger figure for women by 2.

---

Indices:

Index	Type	Column(s) indexed
occ_1911_sic2007_pkey	Primary key	g_unit, sic_division

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
occ_1911_sic2007_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
adm_cnty	Text string (max.len.=48).	Name of the Administrative County to which the data relate.
lg_dist	Text string (max.len.=68).	Name of the local government district to which the data relate.
lg_type	Text string (max.len.=20).	Type of local government district.
admc_unit	Integer number.	ID number for Administrative County containing the unit, as defined in the AUO. Set for all reporting areas except the England and Wales totals.
g_unit	Integer number.	ID number for the reporting area, as defined in the AUO. Set for the England and Wales totals, for counties NOT containing County Boroughs, and for all urban units.
sic_division	Integer number.	Number identifying the Division within the 2007 Standard Industrial Classification.
sic_division_name	Text string (max.len.=154).	Name of the SIC 2007 Division.
males	Floating point number.	Number of males in this area and SIC Division.
females	Floating point number.	Number of females in this area and SIC Division.
rec_num	Integer number.	Sequence number keeping rows in order they were loaded in.