A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
Index | Type | Column(s) indexed |
---|---|---|
wages_pk | Primary key | town, occup, year |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
wages_pk | Primary Key | See details above for primary key index |
Column | Type | Contents | year | Integer number. | Year to which rate refers. | town | Text string (max.len.=44). | Town to which rate refers. | occup | Text string (max.len.=24). | Occupation to which rate refers (see note). | weekly_w | Floating point number. | Weekly wage rate, expressed in pence; null if rate is hourly. | hourly_w | Floating point number. | Hourly wage rate, expressed in pence; null if rate is weekly. | text_w | Text string (max.len.=20). | Original text. NB this may contain two or more separate rates, separated by commas. | g_unit | Integer number. | ID number of Urban Labour Market, as defined in the GBHGIS AUO, corresponding to the town. |
---|
The following occupations appear in the table (Those marked * all come from United Society of Boliermakers reports):
aisboil | Angle-Iron Smiths* | ifound | Ironfounders |
book | Bookbinders | lith | Lithographers |
brfin | Brass Finishers | malab | Masons' labourers |
brick | Bricklayers | paint | Painters |
brlab | Bricklayers' Labourers | pattern | Patternmakers |
brmould | Brass Moulders | planers | Planers |
cabin | Cabinetmakers | pllab | Plasterers' labourers |
carp | Carpenters | plumb | Plumbers |
comp | Compositors | rivboil | Riveter* |
fitters | Fitters | smiths | Smiths |
frpol | French polishers | turners | Turners |
holboil | Holder-Up* | uphol | Upholsterers |