Question
Is it possible to get rates of morbid obesity (BMI > 35) for each LHIN for an age greater than 18 years and for the period of 2007/2008 and 2009/2010?
Answer
Consult the CANSIM Table 105-0502. There is a health indicator profile, two year period estimates, by age group and sex, Canada, provinces, territories, health regions (2012 boundaries) and peer groups. Under "Add/Remove Data" you can select Ontario by Local Health Integration Network and under Select Indicators you have the option to select: Body Mass index, self-reported adults obese. The reference periods from 2007/2008 to 2011/2012 available.
Tuesday, January 7, 2014
Monday, January 6, 2014
Canadian Survey on Disability
Question
Will there be a PUMF for the Canadian Survey on Disability? And if so what would be an approximate time?
Answer
There will not be a PUMF for the survey due to a shortage of funding, but it will be available through the RDCs.
Will there be a PUMF for the Canadian Survey on Disability? And if so what would be an approximate time?
Answer
There will not be a PUMF for the survey due to a shortage of funding, but it will be available through the RDCs.
Friday, December 20, 2013
Income Data
Question
I have a graduate student who has her own survey data with postal codes, and would like to match income data to it. Since we've been advised that the 2011 NHS income data is not to be relied on, is there another source from which we can get household income data at the FSA level?
Answer
I can provide data by FSA for Census Families, lone-parent families and Persons not in a Census family--household usually refers to an economic family. I copied the definition of an economic family from the internet and a separate definition of census family from the user's guide enclosed above.
I'm going to suggest two different tables:
Family, table 1, Summary, which provides median income data Family, table 4, distribution of Total Income by all Family types.
The most current year is 2011 and the source of this data is from the T1 Tax File (TIFF), Administrative Data. I can only provide a cost quote once you choose one or more of the tables attached. For example, one table for all FSAs in Canada will cost $145.36 + taxes. If you choose more than two tables and more years then the cost will rise accordingly. I have data going back from 1990 to 2011--not all tables are available historically. If cost is an issue,you can download data from CANSIM for free from 2000 to 2011 by CMA and CA.
CANSIM numbers that may be helpful:
1110009 FAM 1 Family characteristics, summary
1110010 FAM 2 Family characteristics, by family type and age group
1110011 FAM 3 Families by type, composition, and parent characteristics
1110012 FAM 4 Family characteristics, by age of older adult, family type and family income
1110013 FAM 5 Families by family type, composition and total income
1110014 FAM 6 Sources of income by family type
1110015 FAM 17-18 Low Income Measures, by family type and family type composition
1110016 Fam 7 - 8 Economic dependency profile, by family type and source of income
1110017 Fam 9 - 10 Family characteristics, labour income profile, by family type
1110018 Fam 11 Labour characteristics, by sex and age group
1110019 Fam 12 Persons receiving Employment Insurance, by sex and age group
1110020 Fam 13 Single-earner and dual-earner families, by number of children
1110021 Fam 14 Husband-wife families, by wife's contrubution to husband-wife employment income
1110022 Fam 15 Family characteristics, families with children, by age of children
Definition of Economic Family:
Family structure refers to the combination of relatives that comprise a family. Classification on this variable considers the presence or absence of: legally married spouses or common law partners; children; and, in the case of economic families, other relatives.
Economic family refers to a group of two or more persons who live in the same dwelling and are related to each other by blood, marriage, common-law or adoption. A couple may be of opposite or same sex. Foster children are included.
By definition, all persons who are members of a census family are also members of an economic family. Examples of the broader concept of economic family include the following: two co-resident census families who are related to one another are considered one economic family; co-resident siblings who are not members of a census family are considered as one economic family; and, nieces or nephews living with aunts or uncles are considered one economic family.
Definition of Census Family:
Census family classifies people in the following manner: 1) couples(married or common-law) living in the same dwelling, with or without children; and 2) lone-parents (male or female) with one or more children. The residual population is called "persons not in census families" and is made up of persons living alone and of persons living in a household but who are not part of a couple family or lone-parent family.
I have a graduate student who has her own survey data with postal codes, and would like to match income data to it. Since we've been advised that the 2011 NHS income data is not to be relied on, is there another source from which we can get household income data at the FSA level?
Answer
I can provide data by FSA for Census Families, lone-parent families and Persons not in a Census family--household usually refers to an economic family. I copied the definition of an economic family from the internet and a separate definition of census family from the user's guide enclosed above.
I'm going to suggest two different tables:
Family, table 1, Summary, which provides median income data Family, table 4, distribution of Total Income by all Family types.
The most current year is 2011 and the source of this data is from the T1 Tax File (TIFF), Administrative Data. I can only provide a cost quote once you choose one or more of the tables attached. For example, one table for all FSAs in Canada will cost $145.36 + taxes. If you choose more than two tables and more years then the cost will rise accordingly. I have data going back from 1990 to 2011--not all tables are available historically. If cost is an issue,you can download data from CANSIM for free from 2000 to 2011 by CMA and CA.
CANSIM numbers that may be helpful:
1110009 FAM 1 Family characteristics, summary
1110010 FAM 2 Family characteristics, by family type and age group
1110011 FAM 3 Families by type, composition, and parent characteristics
1110012 FAM 4 Family characteristics, by age of older adult, family type and family income
1110013 FAM 5 Families by family type, composition and total income
1110014 FAM 6 Sources of income by family type
1110015 FAM 17-18 Low Income Measures, by family type and family type composition
1110016 Fam 7 - 8 Economic dependency profile, by family type and source of income
1110017 Fam 9 - 10 Family characteristics, labour income profile, by family type
1110018 Fam 11 Labour characteristics, by sex and age group
1110019 Fam 12 Persons receiving Employment Insurance, by sex and age group
1110020 Fam 13 Single-earner and dual-earner families, by number of children
1110021 Fam 14 Husband-wife families, by wife's contrubution to husband-wife employment income
1110022 Fam 15 Family characteristics, families with children, by age of children
Definition of Economic Family:
Family structure refers to the combination of relatives that comprise a family. Classification on this variable considers the presence or absence of: legally married spouses or common law partners; children; and, in the case of economic families, other relatives.
Economic family refers to a group of two or more persons who live in the same dwelling and are related to each other by blood, marriage, common-law or adoption. A couple may be of opposite or same sex. Foster children are included.
By definition, all persons who are members of a census family are also members of an economic family. Examples of the broader concept of economic family include the following: two co-resident census families who are related to one another are considered one economic family; co-resident siblings who are not members of a census family are considered as one economic family; and, nieces or nephews living with aunts or uncles are considered one economic family.
Definition of Census Family:
Census family classifies people in the following manner: 1) couples(married or common-law) living in the same dwelling, with or without children; and 2) lone-parents (male or female) with one or more children. The residual population is called "persons not in census families" and is made up of persons living alone and of persons living in a household but who are not part of a couple family or lone-parent family.
Wednesday, December 18, 2013
Households and Environment Survey Release
Question
When will the Households and Environment Survey be released?
Answer
The full 2013 microdata will be available in about 15 months time (i.e. March or April of 2015). There may be a few select variables available as early as August 2014, but that is dependent on resources, and in any event would be aggregate results rather than microdata.
When will the Households and Environment Survey be released?
Answer
The full 2013 microdata will be available in about 15 months time (i.e. March or April of 2015). There may be a few select variables available as early as August 2014, but that is dependent on resources, and in any event would be aggregate results rather than microdata.
Monday, December 16, 2013
HIV/AIDS in PEI
Question
Where can I find information on how many people are living with HIV/AIDS in PEI?
Answer
A lot of information on HIV/AIDS is on PHAC. You can also use STC, for mortality and cause of death (Table 102-4310).
Where can I find information on how many people are living with HIV/AIDS in PEI?
Answer
A lot of information on HIV/AIDS is on PHAC. You can also use STC, for mortality and cause of death (Table 102-4310).
Pregnant Women in PEI
Question
Where can I find information on how many pregnant women there are in PEI per year?
Answer
In 1995, the collection of the data for this survey was transferred from Statistics Canada to the Canadian Institute for Health Information (CIHI). Once the data was collected, it was transferred to Statistics Canada to be released in The Daily. This process has caused some confusion with the users of the data. Statistics Canada has decided, in consultation with CIHI that the responsibility for disseminating these data should reside with CIHI. I would recommend viewing CIHI’s website for more information.
For Pregnancy and birth related tables, see:
<http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/ind01/l3_2966_2961-eng.htm?hili_none>I did find some tables from Statistics Canada, however, they were terminated in 2005.Pregnancy outcomes by province or territory of residence (Total Pregnancies)
<http://www5.statcan.gc.ca/cansim/a26lang=eng&retrLang=eng&id=1069002&paSer=&pattern=&stByVal=1&p1=1&p2=37&tabMode=dataTable&csid=>
Where can I find information on how many pregnant women there are in PEI per year?
Answer
In 1995, the collection of the data for this survey was transferred from Statistics Canada to the Canadian Institute for Health Information (CIHI). Once the data was collected, it was transferred to Statistics Canada to be released in The Daily. This process has caused some confusion with the users of the data. Statistics Canada has decided, in consultation with CIHI that the responsibility for disseminating these data should reside with CIHI. I would recommend viewing CIHI’s website for more information.
For Pregnancy and birth related tables, see:
<http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/ind01/l3_2966_2961-eng.htm?hili_none>I did find some tables from Statistics Canada, however, they were terminated in 2005.Pregnancy outcomes by province or territory of residence (Total Pregnancies)
<http://www5.statcan.gc.ca/cansim/a26lang=eng&retrLang=eng&id=1069002&paSer=&pattern=&stByVal=1&p1=1&p2=37&tabMode=dataTable&csid=>
Monday, December 9, 2013
Farm Financial Statistics
Question
A researcher is looking for Farm Financial Statistics from the Census of Agriculture at the sub-watershed level around Lake Simcoe.We have found information at the Consolidated Census Subdivision (CCS) level via the Census of Agriculture website, which provides some granularity in the area but it's not a great match for the researcher's needs.
What are the options for getting Farm Financial Statistics that more closely matches the desired geography? If we sent a boundary file to StatCan, could we have a custom tab made? Or would we have to use the PCCF? Or something else entirely?
Answer
I confirmed with the author division that unfortunately this request would not be feasible because we do not release financial statistics at the watershed level. The database we use for these types of projects is not designed for these type of variables -- it is developed for "production" variables only.
A researcher is looking for Farm Financial Statistics from the Census of Agriculture at the sub-watershed level around Lake Simcoe.We have found information at the Consolidated Census Subdivision (CCS) level via the Census of Agriculture website, which provides some granularity in the area but it's not a great match for the researcher's needs.
What are the options for getting Farm Financial Statistics that more closely matches the desired geography? If we sent a boundary file to StatCan, could we have a custom tab made? Or would we have to use the PCCF? Or something else entirely?
Answer
I confirmed with the author division that unfortunately this request would not be feasible because we do not release financial statistics at the watershed level. The database we use for these types of projects is not designed for these type of variables -- it is developed for "production" variables only.
Subscribe to:
Posts (Atom)