2006 Census of Population – Unpaid work (20)

Cat no.

Date

Topic

Title

97-559-XCB2006015 Archived

March 4, 2008

Labour

Unpaid Work (20), Age Groups (9) and Sex (3) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Divisions and Census Subdivisions, 2006 Census - 20% Sample Data
Formats:HTMLBeyond 20/20SDMX (XML)

97-559-XCB2006007 Archived

July 29, 2008

Labour

Unpaid Work (20), Sex (3), Age Groups (9), Labour Force Activity (5), Census Family Status (6) and Presence and Age of Youngest Child (6) for the Population 15 Years and Over Living in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2001 to 2006 Censuses - 20% Sample Data
Formats:HTMLBeyond 20/20SDMX (XML)

About this site

select ProductId, LongTitleEn,IPSNumber,ProdReleaseDate,ProductType,ReleaseType
from Products
where AccessLevel < 3 and
ProductId in (
select distinct P.ProductId
from Products P,
TableDimensions TD,
Variables V
where P.ProductId=TD.ProductId and
TD.VariableId=V.VariableId and
P.CensusYear=2006 and
StatusCode = 'R' and Products.ProdReleaseDate < getdate() and
P.ProductType not in (-1) and
P.ReleaseType not in (83,84) and
P.ProductId not in (109227) and
P.IPSNumber not like '97C%'
and LTrim(V.VariableDescEn)='Unpaid work (20)'
)
order by LTrim(TitleEn)