A vision of Britain through time
A vision of Britain between 1801 and 2001.
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. |
|---|
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 |