Industry data from the 1951 Census reclassified to the 2007 Standard Industrial Classification

Table ID:

IND_1951_SIC2007     (1251039)

Contents:

Industry data from the 1951 Census reclassified to the 2007 Standard Industrial Classification

Approx. number of rows:

82,375

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

Sources:

1. This table holds data derived from both Table 2 and Table 3 in Census 1951: England and Wales: Industry Tables (London: HMSO, 1957), for all the local government districts listed in those tables, but reclassified to the 2007 Standard Industrial Classification. It also contains national totals for England and Wales.

---

Notes:

1. Each of the detailed industrial categories ('Units') listed in Table 2 has been assigned to one of the 'Divisions' in the 2007 Classification, using the ind_1951_codebook table. This table also includes the simpler SIC 'Sections'. so it can easily be grouped into those.
2. This table holds exact counts of persons for districts included in Table 2, i.e. towns of over 50,000 population. Figures for districts in the simplified Table 3 were calculated by first calculating the total numbers for each of the detailed categories listed in Table 2 for the aggregate of all districts in a county listed in Table, 3, by subtracting the total for large towns from the overall county total. This was then used to assign persons in the simplified Table 3 categories to each Table 2 category. This method inevitably creates fractional persons!

---

Checking:

1. This table was derived programmatically from ind_1951_lg_t and ind_1951_small, both of which have been carefully checked.

---

Indices:

Index	Type	Column(s) indexed
ind_1951_sic2007_pk	Primary key	g_unit, sic_division
ind_1951_sic2007_idx_div	Unique	g_unit, sic_section, sic_division

---

Constraints:

The table has the following associated constraints:

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

---

Columns within table:

Column	Type	Contents
adm_cnty	Text string (max.len.=46).	Standardised name of the Administrative County.
lg_dist	Text string (max.len.=72).	Cleaned version of the unit name.
lg_type	Text string (max.len.=8).	Type of local government unit. These include 'CB' = 'County Borough', 'MB' = 'Municipal Borough', 'RD' = 'Rural District', 'UD' = 'Rural District'.
g_unit	Integer number.	ID number of the local government district, as defined in the GBHGIS AUO.
sic_section	Text string (max.len.=10).	Letter code, running from A to U, assigning the 1951 group to a 'Section' in the 2007 SIC.
sic_section_name	Text string (max.len.=130).	Name of the 2007 SIC 'Section'. For example, 'A' is 'AGRICULTURE, FORESTRY AND FISHING' and 'U' is 'ACTIVITIES OF EXTRATERRITORIAL ORGANISATIONS AND BODIES'. The only significance of the letters is to provide an ordering.
sic_division	Integer number.	Integer number identifying the 2007 SIC 'Division' to which we have assigned the 1951 Unit. These form a single sequence running from 1 to 99.
sic_division_name	Text string (max.len.=138).	Name of the 2007 SIC 'Division'. For example, 'AGRICULTURE, FORESTRY AND FISHING' is divided into (01) 'Crop and animal production, hunting and related service activities', (02) 'Forestry and logging', and (03) 'Fishing and aquaculture'. Some Sections contain only one division.
males	Floating point number.	Number of males employed.
females	Floating point number.	Number of females employed.