The following tables hold the raw data from the Annual Reports:
Field Name | Contents | Usage |
report | Report | The report from which the record comes. |
branch | Branch | The branch from which the record comes. |
sys_no | Integer | The member's actual ranking within the list, generated automatically by system. |
list_no | Integer | The member's number as printed in the list; NB this is usually identical to sysgen_number', but not always. |
[name] | Name | The member's name, as it appears in the list. |
code | Text (1 char.): legal options are: A Abroad |
A code selected by the operator to summarise the footnote entry. |
place | Text (50 chars.): a place name | Usually the destination given in a footnote. |
notes | Text (512 chars.) | Other text from the original footnote; not needed where the footnote is of a very standard type. |
returned | Text (1 char.): either blank or 'R' | Flag indicating that the member was footnoted as having returned. |
r_number | 3-digit integer (should be <null> unless RETURNED set) | New membership number for the same member on returning to the branch. |
mem_seq | Integer | Unique accession number, generated by data entry system. |
These additional fields hold values added during the linkage process:
Field Name | Contents | Usage |
record_id | Record_ID | The ID of the record itself, constructed from BRANCH, REPORT and NUMBER. |
nsb_id | Record_ID | (NEXT_SAME_ID) The ID (if any) of the membership record of the same man in the following year's report of the SAME branch. |
lsb_id | Record_ID | (LAST_SAME_ID) The ID (if any) of the membership record of the same man in the previous year's report of the SAME branch. |
nob_id | Record_ID | (NEXT_OTHER_ID) The ID (if any) of the membership record of the same man in another branch which he moved to from the present one (which might be in same year or the following year's report). [At present, always null] |
lob_id | Record_ID | (LAST_OTHER_ID) The ID (if any) of the membership record of the same man in another branch which he moved from to the present one (which might be in same year or the previous year's report). [At present, always null] |
clust_id | Record_ID | The ID of the first membership record in a clear sequence of membership records relating to the same man. This would be initially set as identical to mem_rec. |
member | Record_ID | The ID of the first membership record in a set of clusters that are ultimately grouped together as referring to the same man. It would initially be set to be identical to mem_rec. [At present, this will always be identical to 'cluster'.] |
l_status | Integer (single digit code) | Linkage status: used in linking footnote data. [At present, always null] |
move | Text (1 char.): legal options are: A Abroad |
Indicates type of move; generated later in the linkage and used for analysis. 'I' covers moves where nothing is footnoted but a move is inferred from the linkage; 'N' cases where a move is footnoted but there is no evidence it actually happened; 'S' changes of branch due to openings or closures. [At present, always null] |
Field Name | Contents | Usage |
report | Report | The report from which the record comes. |
branch | Branch | The branch from which the record comes. |
sys_no | Integer, generated automatically by system. | The widow's number within the list; NB not present in original but lists seem to be in seniority order. |
cname | Text (60 chars.) | The widow's forename, usually not given. |
sname | Text (40 chars.) | The widow's surname, as listed. |
code | Text (1 char.): legal options are A, B, C, D, E, L, M, P, S, T and X (see definitions in 'members') | As for the 'members' table, but the only entries used are D, E, L and X. |
place | Text (50 chars.): place name | The destination given in a footnote, but currently always empty as no widows are listed as moving. |
notes | Text (512 chars.) | Other text from the original footnote; e.g. re-marriage. |
wid_seq | Integer | Unique accession number, generated by data entry system. |
record_id | Record_ID | The ID of the record itself, constructed from BRANCH, REPORT and NUMBER. |
nsb_id | Record_ID | (NEXT_SAME_ID) The ID (if any) of the membership record of the same widow in the following year's report of the branch. |
lsb_id | Record_ID | (LAST_SAME_ID) The ID (if any) of the membership record of the same widow in the previous year's report of the branch. |
clust_id | Record_ID | The ID of the first record in the sequence for this particular widow. This is currently set as identical to record_id but will be changed through linkage. |
member | Record_ID | The ID of the first record in the sequence for this particular widow. This is currently set as identical to record_id but will be changed through linkage. |
Field Name | Contents | Usage |
report | Report | The report from which the record comes. |
branch | Branch | The branch making the payment. |
type | Text (1 char.): legal options are: B Benevolent Fund (MR data) |
The type of payment; NB each type of payment appears in a separate list in the original reports, and these codes are inserted by the data entry system. No benevolent fund data has yet been entered. |
[date] | Date | The date of the payment. |
[name] | Name | The name of the member receiving the payment. |
weeks | Integer | The number of weeks covered by the payment. |
days | Integer | The number of days covered by the payment (additional to weeks). |
rate | Text (1 char.): legal options are: <null> Standard rate |
Code indicating the rate at which the benefit was paid (unemployment and sickness benefits dropped to a lower rate after a certain number of months; NB the codes provide for the variety of actual statements in the source and need to be translated to provide the actual weekly rate. Always null for post-1849 data but can be inferred from duration and value. |
notes | Text (512 chars.) | Other information which appears; mainly necessary for miscellaneous payments. |
[payment] | Money | The sum of money paid. |
pay_seq | Integer | Unique accession number, generated by data entry system. |
mem_rec | Record_ID | The RECORD_ID of the entry in 'members' to which the payment is linked. |
member | Record_ID | Unique ID for member, added by linkage. |
Function: | This table holds payments of travelling benefit, which differ markedly from the data in the 'payments' table firstly because this benefit usually involved an origin or destination, and secondly because most payments were to non-members of the paying branch, greatly complicating linkage. |
Coverage: | All payments of sickness benefit to named members listed in the SEM Annual Reports from 1835 until 1876; all payments of unemployment benefit starting in 1837; all payments of superannuation from 1842; and all payments of strike pay from 1875. Items of miscellaneous expenditure are also included wherever there is a named beneficiary. |
Size: | 36,039 records. |
Table 'travelling':
Field Name | Contents | Usage |
report | Report | The report from which the record comes. |
branch | Branch | The branch making the payment. |
[date] | Date | The date of the payment. |
sys_no | Integer | Number added by data entry system indicating record's position within a particular branch's list of payments. |
[name] | Name | The name of the member receiving the payment; NB this is normally not a member of the paying branch. |
code | Text (1 char.): legal options are: A Accommodation |
Type of payment; see notes. |
place | Text (80 chars.) | The previous town visited (e.g. 'Newton') |
stay | Text (1 char.): legal options = <null>, digits 1-9, S. | Length of stay in days ('S' indicates 'Sunday included') |
notes | Text (512 chars.) | Any other text from report. |
[payment] | Money | Amount of benefit paid. |
tra_seq | Integer | Unique code identifying the sequence that this record is linked into; to be added. |
record_id | Integer | Unique code identifying the record. |
next_rec | Integer | Value of RECORD_ID for next payment in sequence; to be added. |
prev_rec | Integer | Value of RECORD_ID for previous payment in sequence; to be added. |
seq | Integer | Value of RECORD_ID for final record in sequence; to be added. |
seq_no | Integer | Number of record within sequence; to be added. |
mem_rec | Record_ID | Pointer to entry in membership list in branch where journey began; to be added. |
member | Record_ID | Unique ID for member, to be added prior to analysis. |
l_status | Integer (single-digit code) | Linkage status: used later in linkage. |
Function: | Holds information on the deaths of members, their wives and widows taken mainly from the Annual Reports. |
Coverage: | All funeral benefit payments in the Annual Reports up to the end of 1876. Gaps in the Annual Reports were filled using data from the Monthly Reports. |
Size: | 1,423 records. |
Field Name | Contents | Usage |
report | Report | The report from which the record comes. |
branch | Branch | The branch making the payment. |
[date] | Date | The date of the payment. |
f_status | Text (1 char.): legal options are: M Member |
Category of person dying. |
wname | Text (70 chars.) | Wife's christian name. |
[name] | Name | The name of the member receiving the payment, or of the husband in case of wives and widows. |
age | Integer | The age of the dead person. |
cause | Text (70 chars.) | Cause of death. |
notes | Text (512 chars.) | Any other text from report; the operator will need to use their judgment to distinguish this from 'cause'. |
[payment] | Money | Sum paid to members |
fun_seq | Integer | Unique accession number, generated by data entry system. |
mem_rec | Record_ID | The RECORD_ID of the entry in 'members' or 'widows' to which the payment record is linked. |
member | Record_ID | Unique ID for member, added later in linkage; NB in the case of widows and wives identifies the husband. |
(c) Humphrey Southall, 1997