class Census1921

class Census1921

Up: class CensusLine

Source Code

This table is used to contain transcriptions of the population census of the 1921 census of Canada.

CREATE TABLE `Census1921` (
`Province` CHAR(2) DEFAULT NULL,
`District` DECIMAL(4,
1) NOT NULL,
`SubDistrict` DECIMAL(4,
0) NOT NULL,
`Division` VARCHAR(4) DEFAULT '',
`Page` INT(11) NOT NULL,
`Line` INT(11) NOT NULL,
`Family` CHAR(6) NOT NULL,
`Surname` VARCHAR(32) DEFAULT NULL,
`SurnameSoundex` CHAR(4) DEFAULT NULL,
`GivenNames` VARCHAR(48) DEFAULT '',
`Township` VARCHAR(48) DEFAULT '',
`Address` VARCHAR(48) DEFAULT '',
`OwnerTenant` CHAR(1) DEFAULT '',
`HouseRent` INT(5) DEFAULT '0',
`HouseClass` CHAR(1) DEFAULT '',
`HouseMaterial` VARCHAR(24) DEFAULT NULL,
`HouseRooms` INT(2) DEFAULT '0',
`Relation` VARCHAR(32) DEFAULT '',
`Sex` CHAR(1) DEFAULT '',
`MStat` CHAR(1) DEFAULT '',
`Age` VARCHAR(8) DEFAULT NULL,
`BYear` INT(11) DEFAULT '1920',
`BPlace` VARCHAR(32) DEFAULT '',
`FathersBPlace` VARCHAR(32) DEFAULT '',
`MothersBPlace` VARCHAR(32) DEFAULT '',
`ImmYear` VARCHAR(6) DEFAULT '',
`NatYear` VARCHAR(6) DEFAULT '',
`Nationality` VARCHAR(16) DEFAULT '',
`Origin` VARCHAR(16) DEFAULT '',
`SpkEnglish` CHAR(1) DEFAULT '',
`SpkFrench` CHAR(1) DEFAULT '',
`SpkOther` VARCHAR(16) DEFAULT '',
`Religion` VARCHAR(32) DEFAULT '',
`CanRead` CHAR(1) DEFAULT '',
`CanWrite` CHAR(1) DEFAULT '',
`SchoolMons` INT(2) DEFAULT '0',
`Occupation` VARCHAR(48) DEFAULT '',
`EmpType` CHAR(1) DEFAULT '',
`EmpWhere` VARCHAR(16) DEFAULT '',
`IncomeEmp` INT(8) DEFAULT '0',
`Unemployed` CHAR(1) DEFAULT '',
`WeeksUnemp` INT(2) DEFAULT '0',
`WeeksIll` INT(2) DEFAULT '0',
`Remarks` VARCHAR(50) DEFAULT NULL,
`IDIR` INT(10) DEFAULT NULL,
PRIMARY KEY (`District`,
`SubDistrict`,
`Page`,
`Line`),
KEY `Surname` (`Surname`),
KEY `SurnameSoundex` (`SurnameSoundex`),
KEY `GivenNames` (`GivenNames`),
KEY `Relation` (`Relation`),
KEY `BYear` (`BYear`),
KEY `BPlace` (`BPlace`),
KEY `FathersBPlace` (`FathersBPlace`),
KEY `MothersBPlace` (`MothersBPlace`),
KEY `Origin` (`Origin`),
KEY `Nationality` (`Nationality`),
KEY `Religion` (`Religion`),
KEY `Occupation` (`Occupation`),
KEY `IDIR` (`IDIR`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8 

Next: class Census1926