Field Name |
Contents |
Usage |
rb_id |
Integer |
Unique identifier for each entry in the book. Indicates order of entries
and permits related information in the 'rb_event' table to be linked. |
book |
Integer (all current entries are '1') |
Volume from which entry was transcribed. All current data comes from MRC
Accession number MSS.259/SE/2/1/1. |
br_name |
Text (70 chars.) |
Name of branch where admitted. |
branch |
Branch |
Branch where admitted (standard code). |
[name] |
Name |
Member's name. |
age |
Integer |
Age at admission. |
trade |
Text (70 chars.) |
e.g. 'fitter', 'turner'. |
m_status |
Text (1 char.): legal entries are:
S Single
M Married
W Widowed |
Marital status, as given in Registration Book (NB 'W' code is unused). |
[date] |
Date |
Date of admission. |
notes |
Text (512 chars.) |
Comments relating to initial entry (NB for info. re. subsequent history
see 'rb_event'. |
rb_seq |
Integer |
Unique key value, added while bulk-loading the data; runs in sequence, unlike
rb_id, and used in checking data. |
mem_rec |
Record_ID |
The RECORD_ID of the entry in 'members' for the year/branch first joined. |
member |
Record_ID |
Unique ID for member, added later. |
Field Name |
Contents |
Usage |
rb_id |
Integer |
Unique identifier for each entry in the book. Links 'rb_event' to 'reg_book'. |
event |
Integer (1-5) |
Sequence number indicating placing of this event within those given for
this entry in the Registration Book; to be used to present data in the original
order. |
type |
Single character. Legal entries are:
D Died
E Excluded
L Left the trade
M Miscellaneous
P Payment
R Re-admitted
S Superannuated
W Wife died |
Nature of event. NB 'Miscellaneous' is rare, as the more specific codes
are comprehensive. |
[date] |
Date |
Date of event. NB in many cases only the year, or the month and year are
given. |
place |
Text (70 chars.) |
Place where event occurred; usu. indicates moves to another branch. |
detail |
Text (512 chars.) |
Other details given in register. NB many entries would be fully covered
by the code in the type field and the date. |
mem_rec |
Record_ID |
The RECORD_ID of the entry in 'members' to which the event can be connected;
to be added by linkage |
clust_id |
Record_ID |
Cluster ID, copied from the entry in 'members' pointed to by mem_rec. |
member |
Record_ID |
Unique ID for member, added later in linkage. |
Field Name |
Contents |
Usage |
br_name |
Text (40 chars.) |
Name of branch where admitted. |
branch |
Branch |
Branch where admitted (standard code). |
[name] |
Name |
Member's name. |
age_y |
Integer |
Age in years at time of admission |
age_m |
Integer |
Any months stated as part of age at time of admission |
age |
Float |
Age at time of admission; calculated from age_y and age_m. |
u_name |
Text (24 chars.) |
Name of union originally joined. (NB 'union' is an INGRES reserved word) |
trade |
Text (16 chars.) |
Branch of trade (skill) to which man belonged. NB where the record comes
from the original sample gathered in 1978, this was originally entered as
a single letter code and has been converted back to a full statement when
the data were loaded into INGRES, so may not be an exact transcription. |
m_status |
Text (1 char.): legal entries are:
M Married
S Single
W Widowed |
Marital status. |
[date] |
Date |
Date of event. NB in many cases only the year, or the month and year are
given. |
random_s |
Integer (Flag: 0 or 1) |
Value=1 if record was included as part of random sample (208 entries selected
by page and line number). |
letter_s |
Integer (Flag: 0 or 1) |
Value=1 if admission was before 1/1/1852 and surname begins with 'S' (all
such entries were transcribed). |
in_sem |
Integer (Flag: 0 or 1) |
Value=1 if record was included because man was apparently an SEM member
(all entries where union='ENGINEERS' or 'SEM'). |
pre_1841 |
Integer (Flag: 0 or 1) |
Value=1 if record was included because the man joined before the end of
1841; all such records are being transcribed. |
notes |
Text (128 chars.) |
Other information from the original register; usu. indicating subsequent
history, e.g. death or expulsion. |
ar_seq |
Integer |
Unique identifier, added when data loaded into SEM database. |
mem_rec |
Record_ID |
The RECORD_ID of the entry in 'members' to which the event can be connected;
to be added by linkage |
member |
Record_ID |
Unique ID for member, added later. |
Field Name |
Contents |
Usage |
[name] |
name |
The name of the person dying. |
[date] |
date |
Date of death (NB this may be different from the date of the funeral). |
reg_dist |
Text (40 chars.) |
Name of Registration District where death occurred. |
age |
Integer |
Usually a round number of years. |
occup |
Text (60 chars.) |
e.g. 'Fitter', 'Turner'. |
place |
Text (140 chars.) |
Place of death: may be precise street address. |
cause |
Text (140 chars.) |
Cause of death |
dc_seq |
Integer |
Unique identifier, added when data loaded into SEM database. |
mem_rec |
Record_ID |
A pointer to the entry in the members table for the relevant member in the
year and branch where he died; used to associate the data with the main
database. |
member |
Record_ID |
Unique ID for member, added in linkage. |