SQL table listing
SQL table nameDescription
CORE1Core information for each LS member
ME711971 Census - LS members
ME811981 Census - LS members
ME911991 Census - LS members
ME012001 Census - LS members
NM711971 Census - non-LS members
NM811981 Census - non-LS members
NM911991 Census - non-LS members
NM012001 Census - non-LS members
NBIRNew births of LS members
DETHDeaths of LS members
IMMGImmigrations (registration with NHS)
EMBREmbarkations
CANCCancer registrations
LBSMLive births to sample mothers
SBSMStill births to sample mothers
IDMIInfant mortality - Infant death of a birth to sample mother
WDOWWidow(er)hoods
PSYCLong-stay psychiatric (1971-1983)
ENLSEnlistments into the armed forces
REENRe-entries
MOTH711971 Census - mother of LS member
FATH711971 Census - father of LS member
WIFE711971 Census - wife of LS member
HUSB711971 Census - husband of LS member
HOH711971 Census - head of household of LS member
GEOG711971 Census - small-area statistics
OCC8l1981 Census - LS members occupation scores
NMOCC8l1981 Census - non-LS members occupation scores
AM811981 Census - absent usually-resident LS members
NA811981 Census - non-LS members in households with an absent usually-resident LS member
ADDME91Experimental variables - 1991 Census - LS members
ADDNM91Experimental variables - 1991 Census - non-LS members
OCC9l1991 Census - LS members occupation scores
NMOCC9l1991 Census - non-LS members occupation scores
GE911991 Census - area identifiers
LA911991 Census look-up - Local Authority statistics
DHA911991 Census look-up - District Health Authority statistics
CLLA911991 Census look-up - ONS classification of Local Authority clusters
AM911991 Census - absent usually-resident LS members
NA911991 Census - non-LS members in households with an absent usually-resident LS member
ADDME01Experimental variables - 2001 Census - LS members
ADDNM01Experimental variables - 2001 Census - non-LS members
MM012001 Census secondary multiple records - LS members
MN012001 Census secondary multiple records - non-LS members
LBSFLive births to sample fathers (1971-1978, 1981)
SBSFStill births to sample fathers (1971-1978, 1981)
IDFIInfant mortality - infant death of a birth to sample father (birth years 1976-1978)
IFPCInternal migration (1971-1974)
CORE1xCore information for each LS member
ME71xAccess restricted - 1971 Census - LS members
ME81xAccess restricted - 1981 Census - LS members
ME91xAccess restricted - 1991 Census - LS members
ME01xAccess restricted - 2001 Census - LS members
NM71xAccess restricted - 1971 Census - non-LS members
NM81xAccess restricted - 1981 Census - non-LS members
NM91xAccess restricted - 1991 Census - non-LS members
NM01xAccess restricted - 2001 Census - non-LS members
NBIRxAccess restricted - New births of LS members
DETHxAccess restricted - Deaths of LS members
IMMGxAccess restricted - Immigrations (registration with NHS)
EMBRxAccess restricted - Embarkations
CANCxAccess restricted - Cancer registrations
LBSMxAccess restricted - Live births to sample mothers
SBSMxAccess restricted - Still births to sample mothers
IDMIxAccess restricted - Infant mortality - Infant death of a birth to sample mother
WDOWxAccess restricted - Widow(er)hoods
PSYCxAccess restricted - Long-stay psychiatric (1971-1983)
ENLSxAccess restricted - Enlistments into the armed forces
REENxAccess restricted - Re-entries
MOTH71xAccess restricted - 1971 Census - mother of LS member
FATH71xAccess restricted - 1971 Census - father of LS member
WIFE71xAccess restricted - 1971 Census - wife of LS member
HUSB71xAccess restricted - 1971 Census - husband of LS member
HOH71xAccess restricted - 1971 Census - head of household of LS member
AM81xAccess restricted - 1981 Census - absent usually-resident LS members
NA81xAccess restricted - 1981 Census - non-LS members in households with an absent usually-resident LS member
GE81xAccess restricted - 1981 Census - ward identifiers
WD81xAccess restricted - 1981 Census look-up - ward statistics
PW81xAccess restricted - 1981 Census look-up - ward-level variables derived by Paul Wilkinson
AM91xAccess restricted - 1991 Census - absent usually-resident LS members
NA91xAccess restricted - 1991 Census - non-LS members in households with an absent usually-resident LS member
GE91xAccess restricted - 1991 Census - area identifiers
WD91xAccess restricted - 1991 Census look-up - ward statistics
CL91xAccess restricted - 1991 Census look-up - ward cluster codes
PW91xAccess restricted - 1991 Census look-up - ward-level variables derived by Paul Wilkinson
MM01xAccess restricted - 2001 Census secondary multiple records - LS members
MN01xAccess restricted - 2001 Census secondary multiple records - non-LS members
GE01xAccess restricted - 2001 Census - ward identifier
USERWD01xAccess restricted - 2001 Census - variables derived by Kevin Lynch
LBSFxAccess restricted - Live births to sample fathers (1971-1978, 1981)
SBSFxAccess restricted - Still births to sample fathers (1971-1978, 1981)
IDFIxAccess restricted - Infant mortality - infant death of a birth to sample father (birth years 1976-1978)
IFPCxAccess restricted - Internal migration (1971-1974)
DISC_DOBSxAccess Restricted - Dates of Birth from all Events and Censuses for LS Members with discrepancy(s)
DISC_SEXESValues of Sex from all Events and Censuses for LS Members with discrepancy(s)