Census source workbook
1871_PE_V1T1_CD_202306
Preserved source table from the Canadian Peoples / TCP census collection. Row totals, survey units, missing values and unresolved interpretations remain visible.
- Workbook
- 1871_PE_V1T1_CD_202306.xlsx
- Worksheet
- Sheet1
- Census vintage
- 1871
- Reporting rows
- 15
- Preserved statistical cells
- 1800
- Numeric observations
- 1583
- Workbook SHA-256
- e2995903fe54bba1d08e5f2cad0c8e48ba169806e2c7af64906cd3d8b9e0bc30
Download the current RDF (N-Triples, gzip) · Download citable cells (JSONL, gzip) · RDF validation
Column definitions
| Position | Source column | Definition | Unit / status | Reference period |
|---|---|---|---|---|
| G | POP_XF_N | Number of families | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of families |
| H | AGE_0to05M_N | Number of males aged under 5 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of males aged under 5 |
| I | AGE_05to16M_N | Number of males aged 5 to 16 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of males aged 5 to 16 |
| J | AGE_16to21M_N | Number of males aged 16 to 21 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of males aged 16 to 21 |
| K | AGE_21to45M_N | Number of males aged 21 to 45 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of males aged 21 to 45 |
| L | AGE_45to60M_N | Number of males aged 45 to 60 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of males aged 45 to 60 |
| M | AGE_ov60M_N | Number of males over 60 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of males over 60 |
| N | AGE_0to05F_N | Number of females aged 0 to 5 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of females aged 0 to 5 |
| O | AGE_05to16F_N | Number of females aged 5 to 16 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of females aged 5 to 16 |
| P | AGE_16to21F_N | Number of females aged 16 to 21 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of females aged 16 to 21 |
| Q | AGE_21to45F_N | Number of females aged 21-45 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of females aged 21-45 |
| R | AGE_45to60F_N | Number of females aged 45-60 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of females aged 45-60 |
| S | AGE_ov60F_N | Number of females over 60 | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of females over 60 |
| T | POP_XDD_N | Number of deaf and dumb persons | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of deaf and dumb persons |
| U | POP_BX_N | Number of blind persons | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of blind persons |
| V | VAX_SN_N | Number of persons neither infected with smallpox nor vaccinated | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons neither infected with smallpox nor vaccinated |
| W | POP_XX_N | Total population | countsource_definition | Reference year unresolvedreference_period_not_resolved: Total population |
| X | POP_XM_N | Number of married persons | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of married persons |
| Y | POP_XS_N | Number of single persons | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of single persons |
| Z | POP_XI_N | Number of insane persons | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of insane persons |
| AA | POP_RM_N | Number of persons married in the past year | countsource_definition | Reference year unresolvedpreceding_year_as_described: Number of persons married in the past year |
| AB | DTH_XX_N | Total number of deaths in the past year | countsource_definition | Reference year unresolvedpreceding_year_as_described: Total number of deaths in the past year |
| AC | BIRTH_LY_N | Number of births in the past year | countsource_definition | Reference year unresolvedpreceding_year_as_described: Number of births in the past year |
| AD | ETH_MI_N | Number of Indigenous males | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Indigenous males |
| AE | ETH_FI_N | Number of Indigenous females | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Indigenous females |
| AF | REL_CE_N | Number of members of the Church of England | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of members of the Church of England |
| AG | REL_PP_N | Number of members of the Presbyterian Church of the Lower Provinces | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of members of the Presbyterian Church of the Lower Provinces |
| AH | REL_KS_N | Number of members of the Kirk of Scotland | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of members of the Kirk of Scotland |
| AI | REL_RC_N | Number of Roman Catholics | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Roman Catholics |
| AJ | REL_ME_N | Number of Methodists | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Methodists |
| AK | REL_BX_N | Number of Baptists | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Baptists |
| AL | REL_BC_N | Number of Bible Christians | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Bible Christians |
| AM | REL_QU_N | Number of Quakers | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Quakers |
| AN | REL_UN_N | Number of Universalists | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of Universalists |
| AO | REL_OTH_N | Number of members of other denominations | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of members of other denominations |
| AP | FRMTN_OX_A | Acres of farmland owned | acressource_definition | Reference year unresolvedreference_period_not_resolved: Acres of farmland owned |
| AQ | FRMTN_RX_A | Acres of farmland rented | acressource_definition | Reference year unresolvedreference_period_not_resolved: Acres of farmland rented |
| AR | FRMTN_VX_A | Acres of farmland held by verbal agreement | acressource_definition | Reference year unresolvedreference_period_not_resolved: Acres of farmland held by verbal agreement |
| AS | FRMTN_SX_A | Acres of farmland neither owned nor rented | acressource_definition | Reference year unresolvedreference_period_not_resolved: Acres of farmland neither owned nor rented |
| AT | FRM_Q1_N | Number of persons holding farmland of first quality | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons holding farmland of first quality |
| AU | FRM_Q2_N | Number of persons holding farmland of second quality | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons holding farmland of second quality |
| AV | FRM_Q3_N | Number of persons holding farmland of third quality | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons holding farmland of third quality |
| AW | FRMLU_ARA_A | Acres of farmland in arable land | acressource_definition | Reference year unresolvedreference_period_not_resolved: Acres of farmland in arable land |
| AX | WHT_XX_B | Bushels of wheat produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of wheat produced in the past year |
| AY | WHT_WX_B | Bushels of winter wheat produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of winter wheat produced in the past year |
| AZ | BAR_XX_B | Bushels of barley produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of barley produced in the past year |
| BA | OAT_XX_B | Bushels of oats produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of oats produced in the past year |
| BB | BWT_XX_B | Bushels of buckwheat produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of buckwheat produced in the past year |
| BC | CRN_XX_B | Bushels of corn produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of corn produced in the past year |
| BD | LEG_CS_B | Bushels of clover seed produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of clover seed produced in the past year |
| BE | GRA_TX_B | Bushels of timothy grass seed produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of timothy grass seed produced in the past year |
| BF | POT_XX_B | Bushels of potatoes produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of potatoes produced in the past year |
| BG | ROOT_TX_B | Bushels of turnips produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of turnips produced in the past year |
| BH | ROOT_OTH_B | Bushels of other root crops produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of other root crops produced in the past year |
| BI | FRU_AO_V | Value of apples and other fruits produced in the past year | Unresolvedrequires_source_interpretation | Reference year unresolvedpreceding_year_as_described: Value of apples and other fruits produced in the past year |
| BJ | HAY_XX_T | Tons of hay produced in the past year | tons as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Tons of hay produced in the past year |
| BK | BEAN_XX_B | Bushels of beans produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of beans produced in the past year |
| BL | PEA_XX_B | Bushels of peas produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of peas produced in the past year |
| BM | LEG_VX_B | Bushels of vetches produced in the past year | bushels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Bushels of vetches produced in the past year |
| BN | FLX_XX_LB | Pounds of flax produced in the past year | pounds of mass as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Pounds of flax produced in the past year |
| BO | FLX_MX_N | Number of flax manufactories | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of flax manufactories |
| BP | FRT_SX_A | Acres of farmland fertilized with shell manure | acressource_definition | Reference year unresolvedreference_period_not_resolved: Acres of farmland fertilized with shell manure |
| BQ | FRT_LX_A | Acres of farmland fertilized with lime | acressource_definition | Reference year unresolvedreference_period_not_resolved: Acres of farmland fertilized with lime |
| BR | CTL_PC_LB | Pounds of cheese produced on farms in the past year | pounds of mass as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Pounds of cheese produced on farms in the past year |
| BS | BUT_XX_LB | Pounds of homemade butter | pounds of mass as reportedsource_definition | Reference year unresolvedreference_period_not_resolved: Pounds of homemade butter |
| BT | MACH_FX_N | Number of farming mills | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of farming mills |
| BU | MACH_HM_N | Number of hay mowing machines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of hay mowing machines |
| BV | MACH_SM_N | Number of stamping machines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of stamping machines |
| BW | MACH_HB_N | Number of hay-making machines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of hay-making machines |
| BX | MACH_HE_N | Number of hay elevators | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of hay elevators |
| BY | MACH_MD_N | Number of mud-digging machines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of mud-digging machines |
| BZ | MACH_OTH_N | Number of other machines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of other machines |
| CA | WAG_CT_N | Number of carts, trucks, and truck-wagons | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of carts, trucks, and truck-wagons |
| CB | CAR_MISC_N | Number of riding wagons, carriages, wood sleds, and jaunting sleds | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of riding wagons, carriages, wood sleds, and jaunting sleds |
| CC | CFM_PCF_YD | Yards of fulled cloth produced in the past year | yardssource_definition | Reference year unresolvedpreceding_year_as_described: Yards of fulled cloth produced in the past year |
| CD | CFM_PCNF_YD | Yards of not-fulled cloth produced in the past year | yardssource_definition | Reference year unresolvedpreceding_year_as_described: Yards of not-fulled cloth produced in the past year |
| CE | MACH_TX_N | Number of threshing machines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of threshing machines |
| CF | HRS_XX_N | Number of horses | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of horses |
| CG | CTL_XX_N | Number of cattle | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of cattle |
| CH | SHP_XX_N | Number of sheep | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of sheep |
| CI | SWN_XX_N | Number of swine | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of swine |
| CJ | ORIG_EN_N | Number of persons originating in England | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons originating in England |
| CK | ORIG_SC_N | Number of persons originating in Scotland | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons originating in Scotland |
| CL | ORIG_IR_N | Number of persons originating in Ireland | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons originating in Ireland |
| CM | ORIG_BP_N | Number of persons originating in the British Provinces | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons originating in the British Provinces |
| CN | ORIG_PE_N | Number of persons originating in Prince Edward Island | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons originating in Prince Edward Island |
| CO | ORIG_OTH_N | Number of persons originating in all other places | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of persons originating in all other places |
| CP | BLD_CX_N | Number of churches | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of churches |
| CQ | BLD_SX_N | Number or schoolhouses | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number or schoolhouses |
| CR | BRDI_XX_N | Number of breweries and distilleries | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of breweries and distilleries |
| CS | TAN_XX_N | Number of tanneries | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of tanneries |
| CT | TAN_PX_LB | Pounds of leather produced in tanneries in the past year | pounds of mass as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Pounds of leather produced in tanneries in the past year |
| CU | TOB_XX_LB | Pounds of tobacco produced in the past year | pounds of mass as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Pounds of tobacco produced in the past year |
| CV | FISH_XE_N | Number of fishing establishments | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of fishing establishments |
| CW | FISH_MX_BL | Barrels of mackerel produced in the past year | barrels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Barrels of mackerel produced in the past year |
| CX | FISH_HA_BL | Barrels of herring or alewives produced in the past year | barrels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Barrels of herring or alewives produced in the past year |
| CY | FISH_CH_Q | Quintals of codfish or hake produced in the past year | quintals as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Quintals of codfish or hake produced in the past year |
| CZ | FISH_BX_N | Number of fishing boats | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of fishing boats |
| DA | FISH_OX_G | Gallons of fish oil produced in the past year | gallons as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Gallons of fish oil produced in the past year |
| DB | FISH_EX_N | Number of men employed in fishing | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of men employed in fishing |
| DC | FISH_BL_N | Number of fishing barrels produced in the past year | countsource_definition | Reference year unresolvedpreceding_year_as_described: Number of fishing barrels produced in the past year |
| DD | FISH_BLM_N | Number of cooper's shops | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of cooper's shops |
| DE | FISH_HS_LB | Pounds of hake sounds cured in the past year | pounds of mass as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Pounds of hake sounds cured in the past year |
| DF | FISH_SL_LB | Pounds of preserved shell and other fish produced during the past year | pounds of mass as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Pounds of preserved shell and other fish produced during the past year |
| DG | FISH_SX_V | Value of salmon produced in the past year | Unresolvedrequires_source_interpretation | Reference year unresolvedpreceding_year_as_described: Value of salmon produced in the past year |
| DH | GRIST_XX_N | Number of grist mills | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of grist mills |
| DI | CFM_XX_N | Number of carding and fulling mills | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of carding and fulling mills |
| DJ | WOOD_XX_N | Number of saw mills | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of saw mills |
| DK | CFM_XY_N | Number of fulling and dressing mills | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of fulling and dressing mills |
| DL | WOOD_SL_N | Number of shingle and lath mills | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of shingle and lath mills |
| DM | MACH_ST_N | Number of steam engines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of steam engines |
| DN | FRT_LK_N | Number of lime kilns | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of lime kilns |
| DO | FRT_LP_BL | Barrels of lime produced in the past year | barrels as reportedsource_definition | Reference year unresolvedpreceding_year_as_described: Barrels of lime produced in the past year |
| DP | BRCK_XX_N | Number of brick kilns | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of brick kilns |
| DQ | BRCK_PX_N | Number of bricks produced in the past year | countsource_definition | Reference year unresolvedpreceding_year_as_described: Number of bricks produced in the past year |
| DR | CAR_SM_N | Number of carriages and sleighs produced in the past year | countsource_definition | Reference year unresolvedpreceding_year_as_described: Number of carriages and sleighs produced in the past year |
| DS | CLOTH_PC_YD | Yards of cloth produced in the past year | yardssource_definition | Reference year unresolvedpreceding_year_as_described: Yards of cloth produced in the past year |
| DT | CLOTH_XX_N | Number of cloth factories | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of cloth factories |
| DU | MACH_SX_N | Number of sewing machines | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of sewing machines |
| DV | MACH_PX_N | Number of pianos, melodeons, and organs | countsource_definition | Reference year unresolvedreference_period_not_resolved: Number of pianos, melodeons, and organs |
Reporting rows
- PE · First Electoral District · row 2
- PE · Second Electoral District · row 3
- PE · Third Electoral District · row 4
- PE · Fourth Electoral District · row 5
- PE · Fifth Electoral District · row 6
- PE · First Electoral District · row 7
- PE · Second Electoral District · row 8
- PE · Third Electoral District · row 9
- PE · Fourth Electoral District · row 10
- PE · City of Charlottetown and Royalty · row 11
- PE · First Electoral District · row 12
- PE · Second Electoral Distrct · row 13
- PE · Third Electoral District · row 14
- PE · Fourth Electoral District · row 15
- PE · Georgetown · row 16