Wednesday, November 8, 2006

Expenditures on antidepressants

Question

Is there any data available on how much Canadians spend on antidepressants in a year?

Answers

Answer 1:

I am not sure Statistics Canada is the best source for this sort of data... I did perform a few searches, but the results are far from
impressive.

Result # 1)

CANSIM Table 203-0008 -- Survey of household spending (SHS), household spending on health care, by province and territory, annual

One section is called: Medicinal and pharmaceutical products (Prescription medicines _and_ Other non-prescription medicines and pharmaceutical products).

As you can see, this is a very broad category and may be a poor indication of antidepressant expenditure.

Result # 2)

CANSIM Table 301-0006 - Principal statistics for manufacturing industries, by North American Industry Classification System (NAICS), annual (dollars unless otherwise noted)

Pharmaceutical and medicine manufacturing [3254]
Pharmaceutical and medicine manufacturing [32541]
Pharmaceutical and medicine manufacturing [325410]

Although you can get revenues from this table, extreme caution should be used.

1) This is for a broad category of pharmeceuticals and medicine - antidepressants is only one part
2) The manufacture's price may not be the retail price and could under estimate the revenues/sales.
3) Some of the product could be exported and would not be reflective of the Canadian consumption model.
4) There may be additional issues with this proposed option....

Answer 2:

CIHI has a Drug Spending Database:
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=spend_e#drug
Who is authorized to access?

Drug Expenditure in Canada: including very aggregate data.
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=AR_80_E
Drug expenditure data in this report are obtained from the National Health Expenditure Database (NHEX) maintained by the Canadian Institute for Health Information (CIHI). Drug expenditure data in NHEX are macro-level data and do not allow for decomposition of prescription costs or drug classes.

For a general overview:
http://secure.cihi.ca/cihiweb/products/Drug_Expenditure_in_Canada_2006_final_web.pdf

Answer 3:

STC does not have that detailed information on antidepressant. CIHI collects the information on prescription but I don't think that you will get from them the details on antidepressant (unless they would do this request as a custom request).

CCHS 2.2 nutrition

Question

When will the nutrition portion of the Canadian Community Health Survey 2.2 be released? The last information we had said August 2006.

Does a pumf for that portion of the survey need to be so different from the pumfs produced for the Nutrition Canada Survey?

Answer

We are not sure when the PUMF on Nutrition, 2.2, will be released. The Health Division was sent back to the drawing table and they are now working with Health Canada in finding what would be the appropriate roll-up for not divulgating third party information. As I mentionned before, we have to be very careful not to release information on third party that will breach confidentiality as well as it could be perceived as releasing market information (brand, consumption of one product versus another, market share, etc.). This is why they need to find the appropriate roll-up of information that will provide appropriate information and at the same time protect sensive information.

The content is quite different from other surveys and confidentiality is not only concerning identifying individuals but also related to sensitive market information related to what people eat or drink.

It's a brand new perspective and Statistics Canada has to be very careful on the information released.

Monday, November 6, 2006

CCHS 2004 cycle 2.2

Question

Is the Approximate Sampling Variablility Tables (ARROX_SAMP_TAB_E.PDF) for CCHS cycle 2.2 only available as a pdf file? I have a researcher who is looking for the file in excel format.

Answer

The Approximate Sampling Variability Tables are not available in an Excel spreadsheet unfortunately.

Wednesday, November 1, 2006

Aboriginal Peoples Survey 2001 Adults off-reserve

Question

The User's Guide for the APS (2001) Adults Off Reserve (pg. 27) "Appendix A, Rules for calculating approximate variance" refers to
"using the Excel file FindCV APS(PUMF).xls". Is the file aps2001vt.xls the file they are referring to?

Answer

You are correct. Because of our naming convention we had to change the file name from "FindCV APS(PUMF).xls" to "aps2001vt.xls".

2001 census files - can't unzip/open

Question

I've downloaded the following files from the ftp site and have received the same error for all of them when trying to unzip: "Cannot open file. It does not appear to be a valide archive. If you downloaded this file, try downloading the file again." Then when I click OK I get "Errors occured while extracting. Do you want to view the last output?" When I say Yes I get the following message: "End-of-central-directory signature not found. Either this file is not a Zip file, or it constitutes one disk of a multi-part Zip file."

I did try downloading again but I get the same messages I downloaded about 40 other files that worked fine. Any ideas as to whether I'm doing something wrong or whether the files are corrupted?

List of files that I can't unzip (ftp/dli/census/2001/ascii/topic-based tabulations/):

Families and Household Living Arrangements
95F0313XCB2001001
95F0314XCB2001001
95F0315XCB2001001
95F0316XCB2001001

Language Composition of Canada
95F0333XCB2001001
95F0336XCB2001001
95F0339XCB2001001

Canada's Workforce: Paid Work
95F0380XCB2001001

Answer

Thank you for bringing this to our attention. There may have been a slight problem when the files were loaded onto the FTP.

We noted one small point - Canada's Workforce: Paid Work 95F0380XCB2001001 - this file seems to download, but the others
(95F0380XCB2001001east.zip/ont.zip/que.zp/west.zip)
were problematic.

I am working at getting another copy of the files. I will advise you once we have reloaded them on the FTP.

Thanks again for keeping us informed about the situation and we'll try to get this done asap.

2006 Census release dates (Official re-announcement)

Please be advised that the detailed analysis, review and consultation regarding the 2006 Census release schedule and associated release dates has been completed. The originally published dates have been revised based on the impacts associated with the extension of 2006 Census field and collection activities.

The 2006 Census homepage has been modified. The link to information regarding the major 2006 Census release dates has been reinstated on the home page and the following is now presented:

2006 Census release dates
For the 2006 Census, due to the introduction of a number of automated processes, Statistics Canada envisaged releasing the population and dwelling counts earlier than in 2001 by a few weeks. However, given the tight labour market due to the strong economy in certain areas of the country (i.e. western Canada) and the difficulties that this has meant in hiring and retaining field staff, the completion of collection activities was extended by about five weeks. The impact of the extension of Field/Collection activities has resulted in adjustments to the originally published release dates. The revised release dates (as of October 31, 2006) are as follows:

Release no. 1: Tuesday March 13, 2007

  • Population and dwelling counts



Release no. 2: Tuesday July 17, 2007

  • Age and sex



Release no. 3: Wednesday September 12, 2007

  • Marital status

  • Common-law status

  • Families

  • Households

  • Housing and dwelling characteristics



Release no. 4: Tuesday December 4, 2007

  • Language

  • Immigration

  • Citizenship

  • Mobility and migration



Release no. 5: Tuesday January 15, 2008

  • Aboriginal peoples



Release no. 6: Tuesday March 4, 2008

  • Labour market activity

  • Industry

  • Occupation

  • Education

  • Language of work

  • Place of work

  • Mode of transportation



Release no. 7: Wednesday April 2, 2008

  • Ethnic origin

  • Visible minorities



Release no. 8: Thursday May 1, 2008

  • Income

  • Earnings

  • Shelter costs



We are advising that users, key stakeholders etc. who are enquiring as to the status of the 2006 Census release dates be directed to the 2006 Census home page and the link to information on release dates.

Updated Products - Geography

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

1) Geography Boundary Files - Census 2006

The 2006 boundary files portray the official geographic limits used for census dissemination and are available for Provinces and Territories, Census Divisions, Economic Regions, Census Metropolitan Areas and Census Agglomerations, Census Consolidated Subdivisions, and Census Subdivisions. The boundary files are available in two formats: Digital Boundary Files and Cartographic Boundary Files. Digital Boundary Files depict the official boundaries of standard census geographic areas. The boundaries sometimes extend beyond shorelines into water, rather than follow the shoreline, to ensure that official limits are followed and that all land and islands are included. Cartographic Boundary Files contain boundaries of standard geographic areas that have been modified to follow shorelines. The files provide a framework for mapping and spatial analysis using commercially available geographic information systems (GISs) or other mapping software. A reference guide is included.

FTP: /dli/geography/arcinfo/
- cbf
- dbf

FTP: /dli/geography/mapinfo/
- cbf
- dbf

2) Standard Geographical Classification (SCG). Volume II. Reference Maps

The Standard Geographical Classification (SGC) is a system of names and codes representing areas of Canada. It consists of a three-tiered hierarchy - province or territory, census division, and census subdivision. This relationship is reflected in the seven-digit code. The SGC is used to identify information for particular geographical areas and to tabulate statistics. This volume provides a series of reference maps that show the boundaries, names, and SGC codes of all census divisions and census subdivisions in Canada, in effect on January 1, 2006. It also provides the names, codes and areal extent of census metropolitan areas, census agglomerations, and economic regions. A thematic map of the Statistical Area Classification (SAC) by census subdivision is included.

FTP: /dli/geography/reference-maps
- cd-csd-dr-sdr
- national-maps
- sgc-cgt