class Census1926

Up: class CensusLine

Source Code

This table is used to contain transcriptions of the population census of the 1926 census of the Prairie Provinces of Canada.

CREATE TABLE Census1926 (
  District      decimal(4,1) NOT NULL,              -- from header
  SubDistrict   decimal(4) NOT NULL,                -- 
  Division      VARCHAR(4) DEFAULT '',              -- 
  Page          INT(11) NOT NULL,                   -- 
  Line          INT(11) NOT NULL,                   -- col 0
  Family        CHAR(6) NOT NULL,                   -- col 2
  Surname       VARCHAR(32) DEFAULT NULL,           -- col 3
  SurnameSoundex CHAR(4) DEFAULT NULL,              -- col 3
  GivenNames    VARCHAR(48) DEFAULT NULL,           -- col 3
  AddrSec       INT(2) DEFAULT NULL,                -- col 4
  AddrTwp       INT(3) DEFAULT NULL,                -- col 5
  AddrRng       INT(2) DEFAULT NULL,                -- col 6
  AddrMdn       INT(1) DEFAULT NULL,                -- col 7
  AddrMuni      VARCHAR(48) DEFAULT NULL,           -- col 8
  Relation      VARCHAR(32) DEFAULT NULL,           -- col 9
  Sex           CHAR(1) DEFAULT NULL,               -- col 10
  MStat         CHAR(1) DEFAULT NULL,               -- col 11
  Age           VARCHAR(8) DEFAULT NULL,            -- col 12
  BYear         INT(11) DEFAULT NULL,               -- 1915 - col 12
  BPlace        VARCHAR(32) DEFAULT NULL,           -- col 13
  BPlFather     VARCHAR(32) DEFAULT NULL,           -- col 14
  BPlMother     VARCHAR(32) DEFAULT NULL,           -- col 15
  Origin        VARCHAR(16) DEFAULT NULL,           -- col 16
  ImmYear       VARCHAR(4) DEFAULT NULL,            -- col 17
  NatYear       VARCHAR(4) DEFAULT NULL,            -- col 18
  Nationality   VARCHAR(16) DEFAULT 'Canadian',     -- col 19
  SpkEnglish    CHAR(1) DEFAULT NULL,               -- col 20
  SpkFrench     CHAR(1) DEFAULT NULL,               -- col 21
  MotherTongue  VARCHAR(32) DEFAULT NULL,           -- col 22
  CanRead       CHAR(1) DEFAULT NULL,               -- col 23
  CanWrite      CHAR(1) DEFAULT NULL,               -- col 24
  SchoolMons	INTEGER(2) DEFAULT NULL,		    -- col 25
  Remarks       VARCHAR(128) DEFAULT NULL,          -- 
  PRIMARY KEY  (District,SubDistrict,Division,Page,Line),
  KEY Surname (Surname),
  KEY SurnameSoundex (SurnameSoundex),
  KEY GivenNames (GivenNames),
  KEY Relation (Relation),
  KEY BYear (BYear),
  KEY BPlace (BPlace),
  KEY Origin (Origin),
  KEY Nationality (Nationality),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Next: class Census1931