2001 Census Topic-based tabulations

Archived Content

Information identified as archived is provided for reference, research or recordkeeping purposes. It is not subject to the Government of Canada Web Standards and has not been altered or updated since it was archived. Please contact us to request a format other than those available.

Detailed Mother Tongue (80), Knowledge of Official Languages (5) and Sex (3) for Population, for Canada, Provinces, Territories and Federal Electoral Districts (2003 Representation Order), 2001 Census - 20% Sample Data

About this variable: Sex (3)

Definition

Sex
Part A - Plain Language Definition
Not applicable
Part B - Detailed Definition
Refers to the gender of the respondent.

Values

Total - Sex
Male
Female

SQL Queries

getVariableInfo (Datasource=ESHELF, Time=16ms, Records=1) in T:\ColdFusion2023\cfusion\CustomTags\ISHELF3\IS3AboutVariable.cfm @ 23:33:57.057

select * 
from TableDimensions
	INNER JOIN Variables
	ON
		TableDimensions.ProductId=77960 AND
		TableDimensions.VariableId=Variables.VariableId AND
		TableDimensions.VariableId=9809 and
		TableDimensions.Dimension=1
    LEFT OUTER JOIN TableNotes
    ON
		TableDimensions.IndexId=TableNotes.IndexId and
		TableNotes.Language='E' and
		TableNotes.NoteType='D'

getRowFootnotes (Datasource=ESHELF, Time=54ms, Records=0) in T:\ColdFusion2023\cfusion\CustomTags\ISHELF3\IS3AboutVariable.cfm @ 23:33:57.057

select * from TableDimensions, TableStubSets, Stubs, TableNotes
	where TableDimensions.ProductId=77960 and
          TableDimensions.ProductId=TableStubSets.ProductId and
		  TableDimensions.Dimension=TableStubSets.Dimension and
          TableStubSets.Dimension=1 and		  
          TableStubSets.StubId=Stubs.StubId and
          TableStubSets.IndexId=TableNotes.IndexId and
          TableNotes.Language = 'E' and
		  
          TableNotes.NoteType='F'		  	  	
	order by TableDimensions.Dimension, StubSequenceNo

setDimension (Datasource=ESHELF, Time=1ms, Records=1) in T:\ColdFusion2023\cfusion\CustomTags\ISHELF3\IS3AboutVariable.cfm @ 23:33:57.057

select Dimension from TableDimensions
where ProductId=77960 and VariableId=9809

getVariableStubs (Datasource=ESHELF, Time=59ms, Records=3) in T:\ColdFusion2023\cfusion\CustomTags\ISHELF3\IS3AboutVariable.cfm @ 23:33:57.057

SELECT Dimension, StubSequenceNo, StubDescEn AS STUBDESC, NoteIndicator, StubSequenceNo
FROM 
	TableStubSets
        INNER JOIN Stubs
        ON
            TableStubSets.ProductId = 77960 AND
            TableStubSets.StubId = Stubs.StubId AND
            TableStubSets.Dimension = 1
        LEFT OUTER JOIN TableNotes
        ON
            TableStubSets.IndexId = TableNotes.IndexId AND
            TableNotes.Language = 'E' AND
            TableNotes.NoteIndicator = 1 AND
            TableNotes.NoteType = 'F'
    ORDER BY TableStubSets.Dimension,  TableStubSets.StubSequenceNo

qProductStatusCode (Datasource=ESHELF, Time=1ms, Records=1) in T:\ColdFusion2023\cfusion\CustomTags\ISHELF3\IS3AboutVariable.cfm @ 23:33:57.057

select StatusCode from Products where ProductId=77960

Debug Rendering Time: 2 ms