Individual income by province for 1925 and 1930

Question:
A researcher is looking for average  individual income by province for 1925 and 1930.

I have consulted Historical Statistics of Canada but the only table that seemed to give that information (table E49: Average weekly wages and salaries, industrial composite, by province, 1939 to 1975) only goes back to 1939.  

The main source of income data, according to Historical Statistics, seems to be  the Survey of employment, payrolls and man-hours but that survey only started in 1941.

 I found other tables (still in Historical Statistics of Canada) that show the aggregate amount of salary and related income by province (E1: Wages, salaries and supplementary labour income, by province, 1926 to 1975) but that does not help with average individual income.

So other than census data (that would only cover 1921 and 1931) , is there any source of annual salary data for those years?

Answer from DLI:
This is an interesting question. The monthly microfiche series 72-002a Employment, Earnings and Hours = Emploi, gains et durée du travail (Dec. 1922- ) may be useful.   We have these in microfiches here and I have a weird feeling that I used these a long time ago.  I can’t find the digitized version at publications.gc.ca for some reason.

While I found tables in the Canada Year Book of total amount of individual income assessed by occupations (including number of individual taxpayers), e.g., page 877, Canada Year Book 1933 …there was nothing comparable by provinces (only a total of corporate and individual income by province).

Answer from Subject Matter:
Subject matter has let us know that they do not have any other data sources for individual income for 1925 and 1930.  The only other possible source might be the Canada Year Book.

If you’re interested in the Canada Year Book, the collection from 1867 to 1967 is available on the Alberta Mirror EFT site. Files exist in PDF in both English and French. 

Missing Values in NHS Individuals PUMF

Question:
For the WAGES variable in the NHS individuals PUMF, why are "not available" and "not applicable" not declared as missing values? The codebook states that:

"The value 8,888,888 stands for not available. The value 9,999,999 stands for not applicable and is applied to all persons aged less than 15 years"

Leaving those values (which constitute over 17% of the cases) subject to calculation would seem to skew the results rather significantly, would they not?


Answer:

B Estimation
Note: Users must refrain from publishing unweighted estimates and from conducting analyses based on unweighted data from the file because the unweighted results do not represent the population but
only describe the sample. They must also make sure to exclude values of study variables that are not applicable or not available from their calculations because those values might be considered as valid observed values by the statistical software when they are not. For example, values such as 9,999,999 or 8,888,888 for a numeric (or quantitative) variable would be interpreted as valid observed values but should be considered as nominal values indicating these values are not usable in estimation.

Example 4:
We want to estimate the average total income of women aged 15 years and over living in Ontario who
have an income. In the calculation of the numerator, WEIGHT is multiplied by the value of the 'total income' variable for individuals with an income (where TOTINC ^= 8,888,888, TOTINC ^= 9,999,999, TOTINC ^= 0) whose gender is female (SEX = 1) and who are aged 15 or over (AGEGRP ≥ 6, AGEGRP ^= 88) in the province of Ontario (PR = 35); the results are then totalled. To estimate the average, the numerator (or estimated total income) is divided by the sum of WEIGHT for individuals satisfying the same conditions on TOTINC, SEX, AGEGRP and PR.
The result obtained is: $179,154,359,345 / 5,072,260 = $35,320, which means the average total income of women aged 15 and over living in Ontario who have an income is around $35,320.
B.2.b.3 Estimator of a ratio
A ratio can be defined as the division of two amounts, which could be two totals or two averages

Example these counts are included
8888 Not available (unweighted) 13,676 - (Weighted) 483,013
9999 Not applicable Canadian citizens by birth and non-permanent residents (unweighted) 697,600 – (Weighted) 26,060,226

Microdata on Income and Educational Attainment

Question

Is it possible to obtain microdata on Income and Educational Attainment at a more granular level than CMAs, without going via the RDCs? I realize that Income is a really sensitive variable in geographic terms, and I’ve looked at the NHS files in Nesstar and some other CANSIM tables, but haven’t found anything below CMAs in either place.

Would the NHS pumf (or a different survey file) enable drilling down to smaller geographic units for either of these variables?

Also, can you confirm whether this *would* be possible via the RDC, for either variable?

Answer

If the client would only like Income data then CT level data would be available for download through the 2011 NHS Profile in either CSV or IVT format. If, however, the client would like both Income and Education data crossed together then this data would only be available on a custom data basis through the nearest regional office.

The RDC does have data available down to the CT and CSD geographic level. There is also DA level data available but in order to disseminate this data you would need to aggregate the DAs to a 5,000 plus population area.