Comparing income inequality by FSA's between 2006 and 2011QAAA

Question

A researcher is having difficulties comparing income equality (for economic families or households) by FSA’s between 2006 and 2011. We would like to ask for help finding this information please.

1. Is it possible to get standard error measures for 2011, as there are for 2006 (as shown in purple below)? How would we go about getting this?

2. If that proves difficult, the researcher would like to calculate GINI coefficient, but she needs (by FSA) total income for all economic families &/or all households. The values highlighted in yellow seem too low to represent total income, what do they represent total numbers of economic families/households?

3. If so, how would we go about getting the sum total of all income (of all economic families/households) by FSA (used to calculate medians and averages)?

Illustrations:

In 2006, the Census profile 94-581-XCB2006003 by FSA shows these measures :

Profile of Forward Sortation Areas	E.g. Canada (01)   20000
Family income in 2005 of economic families - 20% sample data	8,782,350
Median family income $	66343
Average family income $	82325
Standard error of average family income $	83
Household income in 2005 of private households - 20% sample data	12,437,470
Median household income $	53634
Average household income $	69548
Standard error of average household income $	63

a. Personal income (not wanted)

In 2011, the NHS Profile by FSA shows these measures - EO1976_ID579862

2011 NHS	Canada ( 26.1%)
Household total income in 2010 of private households	13,319,250
Household income in 2010 of private households	13319255
Median household total income $	61072
Average household total income $	79102
Family income in 2010 of economic families	9,254,165
Median family income $	76511
Average family income $	94125

Answer

I consulted the responsible subject matter division and they have advised on your questions in red below:

1) The voluntary 2011 NHS replaced the mandatory census long form. As with most voluntary surveys, there are more risks associated with non-response in the NHS. In order to limit the effects of non-response, the systems and methodology normally used for the census long form were changed to introduce new methods at the collection, sampling and estimation stages.

The NHS is now a two-phase sample design, compared to the single-phase sample design in the census. This makes the estimation methodology more complex for the 2011 NHS. A two-phase sample design involves selecting a first-phase sample with data mostly collected via Internet and mail returns. The second phase consists in selecting and following up on a sub-sample of the non‑respondents from the first phase via more effective modes, i.e., telephone and in-person interviews.

Standard errors (SE) released in previous censuses were derived assuming a simple random sample without replacement. The same assumption cannot be made for the 2011 NHS, because of its more complex design.

2) It is the number of economic families or the number of households depending which total line you are looking at. For definitions of Economic Families and Households, they can refer to the Census Dictionaries for the respective years:

<http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/index-eng.cfm>
<http://www12.statcan.gc.ca/census-recensement/2011/ref/dict/index-eng.cfm>

3) We do not have this available via our standard products. Your best bet would be to contact the closest regional office for a possible custom data request.

Land Area for CDs and CSDs

Question

I've got a researcher looking for land area for CDs and CSDs in Ontario or the 1961 and 1966 census. I've been looking through our hardcopy holdings and archive.org, and am not finding anything yet.

Does anyone have suggestions for where to find these? Alternatively, are there boundary files available anywhere?

Answer

Here is the response from subject matter:

We have no boundary files for the 1961 nor the 1966 Censuses. As for land area, I did find some information in our old hardcopy publications, for 1961, at least. This publication (hard cover, red with gold lettering): Census of Canada — 1961 — 1.1 (Vol. 1) Population — Geographical Distributions has two tables that may be useful:

Table 2: Area and density of population for counties and census divisions, 1961

Table 3: Area and density of population for incorporated cities, towns and villages of 2,500 and over, 1961.

They contain a column measuring land area in square miles. If you don’t have that publication, we can scan the tables for you. Please note that the land area was calculated expressly for the purpose of calculating population density only. Also, at that time, the calculation was very complex. People should use these numbers with caution. The mindset we have today of quantifying and measuring everything did not exist then.

For 1966, all I could find were two publications similar to today’s interim lists:

Changes in Municipal Boundaries — Annual Report, December 1968, No. 6

Changes in Municipal Boundaries — Annual Report, December 1969, No. 7.

So, these documents give changes following the 1966 Census that occurred before the 1971 Census. I’m not sure that timeline is what you’re looking for. However, within each are these tables:

Table 1: Municipalities newly created, by province, November 1968 — October 1969

Which includes an Area in square miles value, although not for every municipality listed. There is also:

Table 3: Amalgamations and annexations of municipalities, by province, November 1968 — October 1969

Which includes an Area in square miles, but it measures only the annexed area, not the total area.

I went back and found similar interim lists between 1961 and 1966, but those had no land area information at all.

CCHS Question

Question

I have a student who’d like to know if it’s possible to separate the data from the two-year PUMFs (e.g., 2007-2008) into individual years. My hunch is no, but I told her I’d get a more definitive answer.

Answer

I confirmed with subject matter, and you are correct, it is not possible to separate the years from the two year PUMF file for CCHS 2007-2008. However, individual years are available in the research data centres, see datasets available in the RDCs.

GSGVP 2010 Variables

Question

We are working with the 2010 CSGVP data at the moment, and I understand there is a corresponding data file in which the missing variables have been imputed for the same data. This is not a public released file. Is there a way to gain access to it because the variables we are interested have many missing values.

Answer

When the researcher says they are working on the 2010 CSGVP data, are they working with the PUMF or the Masterfile (in the RDCs)? The files staged for the RDCs do not include declared missing values.

The missing values for the 2010 CSGVP for the PUMF are declared in the syntax files.

1991 and 1996 CSD Income for the 65 and Over

Question

One of our students is looking for the income for age 65+ at the CSD level. He needs stats from 1991 – 2006. I found the Topic Based Tabulations for the 2006 & 2001 Census including income, age and geography he is looking for. Unfortunately, I’m not able to find anything similar for the 1991 & 1996. Do you have any ideas where to look for it?

Answer

The following are available on the DLI Beyond 20/20 Web Data Server (WDS) <https://dli-idd.statcan.gc.ca/wds/>

For 1996
Public reports > Demographics and Population > Census of Population - cp > 1996 > Basic Summary Tabulations-B2020 > Census Subdivisions
[cid:image001.gif@01D0C61D.DA38A140]<javascript:OnReportClick(25075,1,25075);>Total Population 15 Years and Over by Presence of Income (5) and Sex (3), Showing Age Groups (5A), for Canada, Provinces, Territories, Census Divisions and Census Subdivisions, 1996 Census (20% Sample Data)<javascript:OnReportClick(25075,1,25075);> [cid:image004.gif@01D0C61D.DA38A140] <javascript:OnReportFolderTableSummary(25075,%2025075,%201,%2013733)>
And others...

For 1991
Public reports > Demographics and Population > Census of Population - cp > 1991 > Basic Summary Tabulations - Census Subdivisions

Number, aggregate and average 1990 total income and employment income (7) of population 15 years and over by sex (3) (20%)Number, aggregate and average 1990 total income and employment income (7) of population 15 years and over by sex (3) (20%)

Population 15 years and over by sex (3) and 1990 income groups (9) (20%)

1971 CSD Boundary Files

Question

Does anyone know where I might find CSD boundaries for the 1971 census? There’s an attribute table on the EFT, but the researcher who’s asking doesn’t think he can convert it to a shapefile. If CSD boundary files aren’t available, the researcher says CD boundaries will suffice, if anyone has those.

Answer

I consulted subject matter and they don’t have any other files available for this.

There is a SPSS program that converts files from ASCII to SPSS – if you run it, you’ll have an SPSS file that you can save as a dBase file which includes UTM and Lambert Coordinates, which should be able to be mapped within GIS. However, it’s not a boundary file. I surmised that since there is only one record per Enumeration Area, the file records the centroid of the enumeration area (rather than the boundaries). Looking at geog-attrib-file-71-guide.pdf confirmed that (page 13). So I’m not sure it will do what the researcher wants.

Unfortunately there’s not enough information in the attributes file to produce polygons, which is what the research really wants. Still, I’ll let him know that this is available. It may be as close as he’s going to get.

A few months ago I converted the 1971 gtf71.txt file and the embedded UTM coordinates to a .shp file with lat/long. While it is not a boundary file, each point represents the population weighted centre of each EA along with a population count in the attribute table.

Or as stated in the related PDF guide: for each EA the geocoding programme has chosen a point (centroid) situated at approximately the centre of gravity of the enumeration areas population (page 13). 

We can send these over if they interest the researcher

Updated Products - ICO Q2 2015

Please note the products listed below and the path to access them via the DLI EFT.

Inter-corporate ownership (ICO) – Q2 2015

This product is a directory of corporate ownership in Canada that provides information on every individual corporation that is part of a group of commonly controlled corporations with combined assets exceeding $600 million or combined revenue exceeding $200 million. Individual corporations with debt obligations or equity owing to non-residents exceeding a net book value of $1 million are covered as well.

Ultimate corporate control is determined through a careful study of holdings by corporations, the effects of options, insider holdings, convertible shares and interlocking directorships.

The information presented is based on non-confidential returns filed by Canadian corporations under the Corporations Returns Act and on research using public sources such as Internet sites. Entries for each corporation provide both the country of control and the country of residence.

/MAD_DLI/Root/other-products/Inter-corporate ownership – ico