Wednesday, November 23, 2016

Financial Data

Question
I have a user who found industry Canada’s, financial performance data resource http://www.ic.gc.ca/app/sme-pme/bnchmrkngtl/rprt-flw.pub?execution=e1s1

They loved the data they found there, but it only cover recent years (2014)
They are now looking for similar historical data. More precisely, they are seeking information such as gross margins, net margins from 1997 to 2009 in respect of companies with revenues between $5M and $20M for the following NAICS codes:

Codes SCIAN :
2213
23
236
2362
2373
23621
23622
23711

Where might I go to find this?

Answer
I believe the Financial Performance Indicator files are on the EFT site: /MAD_DLI_IDD_DAM/Root/other_autres/2510_FPICB_IPFEC. 

 Also on the WDS under "Business and Financial". I haven't used these for a while. They were (are?) CDs, and I think you will have to install them on your machine.

Tuesday, November 22, 2016

CDUMS PUMP Access

Question
The Canadian Alcohol and Drug Usage Monitoring Survey (CADUMS) has an metadata entry in NESSTAR but not data to download. I can not find the survey on the EFTP site either.

I have a users looking for the 2011 CADUMS pump and possibly other years as well. So is it possible to get this PUMP (and a SAS file for it)?

Answer
Thank you for bringing this to our attention. I see that previously only the metadata was published. We will work on updating these files so that users can also download the data.

We have already republished 2011. We will add 2012 CADUMS to our priority list.

Upon further investigation, I see that the survey was conducted by Health Canada, which is why it would not be located on the DLI EFT site.

The original files are found on the mirror site hosted at the University of Alberta here:
/other/Canadian-Alcohol-and-Drug-Use-Monitoring-Survey-2008-2012/2012

Monday, November 21, 2016

Updated Products: EICS 2014 and 2015 V2

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

Employment Insurance Coverage Survey (EICS) 2014 and 2015

EICS data for 2014 and 2015 is now available on the EFT site.

The Employment Insurance Coverage Survey provides a meaningful picture of who does or does not have access to EI benefits among the jobless and those in a situation of underemployment. The survey also covers access to maternity and parental benefits.

Eft: /MAD_PUMF_FMGD_DAM/Root/4428_EICS_ECAE/2014
Eft: /MAD_PUMF_FMGD_DAM/Root/4428_EICS_ECAE/2015

Saturday, November 19, 2016

RDC analyst access to documentation

Question
The RDC analyst here asked me for the documentation for the NLSCY synthetic files from cycles 5-8. She has a researcher who would like the documentation to prepare code outside the RDC and take it in. I was surprised that an RDC analyst would be asking for this on behalf of a researcher rather than directing the researcher to me and I suggested that if the researcher is affiliated, that he/she should get in touch with me. The response I got back made it seem like the analyst might be preparing the code for the researcher. In re-reading her two e-mails, perhaps she was just using the first person to refer to her own experience before she was an RDC analyst as an example, but assuming she does want to get the documentation for herself I wanted to double check.

As you might imagine I'm not concerned about the level of service she provides to her researchers in general, but I am wondering  whether there have been any changes in how we deliver DLI services on a campus that also has an RDC. In the olden days there seemed to be a pretty tall wall between DLI and RDC data (I'm not talking about documentation here - just data files). Is it still okay to give the documentation to the analyst or because these are synthetic files do I have to confirm that the researcher is affiliated even for the codebooks, etc?

It's very likely that the researcher will be affiliated and that the analyst is simply being really nice in providing assistance to the researcher, but it's also possible that he or she might be from outside the institution because the RDC does allow non-institution researchers. As such, I'm reluctant simply to point to SDA without having determined a little more about the situation. If she ends up wanting the data as well I can remind her of the DLI conditions of use with the synthetic data (authorized user/authorized use), although I expect she's aware of this.

There are about a thousand other nuances to this, but my main question is whether I am allowed to grab the documentation for the analyst just like I might for any pumf and any other researcher (not whether there might be a better way, although I'm also interested in this).

I feel like the way I've posed my questions/comments makes it seem like I'm being territorial, but this is not the case. I really just don't know what the protocol is in this case. I kind of have it in my head that the RDC analysts have everything at their fingertips and therefore it comes as a surprise when I find out that this mightn't be the case.


Answer
In regards to “whether I am allowed to grab the documentation for the analyst just like I might for any PUMF…” it’s suggested that you ask the analyst to have the researcher contact you directly. That way you can determine if the researcher is eligible for the services of the DLI. The synthetic files are not available in the RDC so the researcher should seek them out on her own, or through your library as a DLI member. She can produce code and bring it in the RDC provided her research proposal has been approved.

To further add, a DLI librarian should not be asked by the analyst for RDC materials. An analyst is to direct the researcher to the DLI if DLI services are required for their analysis. Also, DLI material is not placed on RDC servers, therefore, there should be no need to even ask DLI to grab documentation.

Wednesday, November 16, 2016

EICS 2015

Employment Insurance Coverage Survey (EICS) 2015

EICS data for 2015 is now available on the EFT site.

The Employment Insurance Coverage Survey provides a meaningful picture of who does or does not have access to EI benefits among the jobless and those in a situation of underemployment. The survey also covers access to maternity and parental benefits.

Eft: /MAD_PUMF_FMGD_DAM/Root/4428_EICS_ECAE/2015

Monday, November 14, 2016

Machinery and equipment price indexes

Question
An Economics researcher is looking for the background sampling framework and the underlying detailed data for the Machinery and equipment price indexes, see IMDB page: http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&lang=en&db=imdb&adm=8&dis=2&SDDS=2312#a2

The commodity (commodity 30) in question is Non-electric furnaces and heating equipment.

His first question is whether the price indexes for this commodity include the residential sector at all (in full or in part)?

If residential furnace prices are covered, then his second question is availability of the most detailed data, that is:

1) prices over time for natural gas furnaces by
2) energy efficiency rating (AFUE) of the furnace, and this may be dreaming in technicolour, but is not necessary
3) why the customer replaced their furnace?

Answer

“No, the residential sector is not part of MEPI. The index provides quarterly estimates of price changes for machinery and equipment purchased by industries in Canada.”


Thursday, November 10, 2016

Prison Farms

Question
Are there any statistics available on what/who makes up the prison farm population in Canada, both recent and historically? I have found some publications on the Correctional Services website but not statistics.

Followup Response
I had an extremely similar question two years ago!  I'll dig around for what I found, and share with you that info.

Depending on the province -and the actual stats you are after, - the Annual Reports from each ministry or department of Corrections or Prisons or Attornies General, can give you some neat info, too!

Answer
Interesting question! I admit I had to look up what a prison farm was. After some searching, I came across the following reference on the statcan website:

Statistics On Penal Institutions, Pardons, and Parole (Series Z173-226)
General note
There have been several distinct types of penal and detentive institutions in Canada: penitentiaries; provincial prisons; other provincial institutions such as reformatories, industrial farms, and training schools for juveniles; and municipal jails. With the evolution of penal and correctional philosophy, nearly all reformatories and industrial farms and training schools have gradually been phased out in recent years. Since municipal jails serve mainly as temporary detention centres rather than as places where convicted persons serve their sentences, the principal penal institutions are penitentiaries and prisons.

Under the BNA Act, the federal Government of Canada has exclusive responsibility for establishing, maintaining, and managing penitentiaries. Penitentiaries are the penal institutions where convicted persons sentenced to two years' imprisonment or more serve their terms. Provincial prisons are under the jurisdiction of their provincial governments; persons sentenced to less than two years' imprisonment serve their terms in these institutions. (Since 1972, however, there have been federal-provincial transfer agreements under which persons with sentences of less than two years may in certain circumstances serve their term in a penitentiary and some persons with sentences of two years or more may serve their terms in provincial prisons.)

Statistics on provincial prisons (or jails) and other penal institutions have been published since 1918 by Statistics Canada in the annual reports, Statistics of Criminal and Other Offences until 1955, and in Correctional Statistics thereafter. A program for uniform reporting of statistical data specifically on training schools was inaugurated in 1963, with 1964 being the first complete year for which data were available. Publication of statistics continued until 1974; data were accumulated for several years following without being published, and the program was ultimately terminated.

That being said, it would seem that perhaps the ministries collect this information.