Question
I'm looking for detailed information on aircraft movement in Canada, Specifically: Domestic air-traffic between different cities (airports) in Canada, by carrier (Air Canada, WestJet etc) for all domestic carriers, including private flights.” There are CANSIM tables with aircraft data, but nothing with the level of detail (departure and arrival city, carrier) that I would like. Is there any way of getting microdata from the Aircraft Movement Statistics Survey? <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=2715>
Answer
Unfortunately that level of information is not available. This level of detail would not be available through a custom tabulations either. The program does not measure traffic between cities.
Thursday, May 8, 2014
Wednesday, May 7, 2014
National and Provincial Multipliers
Question
Will the National and Provincial Multipliers for 2010 (released 10-Feb-2014) become available through the DLI?
Answer
We will be adding these to the EFT site and notifying the community once available.
Will the National and Provincial Multipliers for 2010 (released 10-Feb-2014) become available through the DLI?
Answer
We will be adding these to the EFT site and notifying the community once available.
Unionization Rates
Question
Is it possible to obtain the unionization rate (presumably the percentage of the active labour force which is unionized) within each federal electoral district. Do such statistics currently exist? If not, could a table providing this level of geographic detail produced from the Labour Force Survey? Could it be created for various years of the LFS (to show historic changes over time), assuming a common set of FEDs? What would be the cost of producing each such table (assuming that it could be produced)?
Answer
Unfortunately this data is not available. The Labour Force Survey does not produce data at the Federal District level.
Is it possible to obtain the unionization rate (presumably the percentage of the active labour force which is unionized) within each federal electoral district. Do such statistics currently exist? If not, could a table providing this level of geographic detail produced from the Labour Force Survey? Could it be created for various years of the LFS (to show historic changes over time), assuming a common set of FEDs? What would be the cost of producing each such table (assuming that it could be produced)?
Answer
Unfortunately this data is not available. The Labour Force Survey does not produce data at the Federal District level.
DAD 2009 ICD- 10 Exclusions
Question
I have prepared flag variables for the DAD 2009 ICD-10 classification (which I will send to the DLI for distribution once finished; I’m still working on the CCI codes). As I was looking at the frequencies of these flag variables to see if they made sense (i.e., that the chapter headings were picked up along with the more specific heading), I encountered something peculiar: there are no ICD-10 listings for any classification of V01 through Y98 (external causes of morbidity and mortality) – no one requiring treatment for any form of accident, fall, drowning, assault, etc. Were these records suppressed on the file distributed to us, or was it random chance (through sampling) that none of these records were selected for our file, or (even less likely, there were no such discharges through the years)? I checked the specifications file for the cycle (specifications-dad-raf.pdf), and couldn’t see any note to that effect in the exclusions.
Exclusions:
- Stillbirths (ENT_CODE = S)
- Cadaveric donations (ADM_CAT = R)
- All therapeutic abortion (TA) records, defined as follows:
1) ICD-10-CA diagnosis code = O04 at the three-digit level, in any diagnosis code field; or
2) CCI intervention code = 5CA20, 5CA24, 5CA88, 5CA89 or 5CA90 at the five-digit level, in any intervention code file
Answer
ICD-10 codes for ‘external causes of morbidity and mortality’ (V01 - Y98) are recorded as a diagnosis type ‘9’. All diagnoses with a diagnosis type of ‘3', '4', '5' or '9' were removed from the records for privacy reasons. As per the file layout there are only type ‘M’, ‘1’, ‘2’, ‘W’, ‘X’ and ‘Y’ included in the file.
This is not included in the exclusion criteria of the specifications because it was not the criteria used to remove an entire record. Any record with one of the exclusions listed (Ex. stillbirths) was completely removed from the dataset. In the case of diagnoses type ‘3', '4', '5' or '9' these ICD-10 codes were only removed from the record and the record itself was retained in the dataset. This way you can still search ICD-10 codes for ‘Injury, poisoning and certain other consequences of external causes’ (S00-T98) to obtain records with a diagnosis due to an external injury – but the cause is removed.
All this information can be found in the DAD Abstracting Manuals which we provided as part of the DLI. The Group 10 – Diagnosis section contains a description of “Diagnosis Type” and how it is coded.
For example:
-“9” External Cause of Injury Code - A Diagnosis Type 9 is assigned to an external cause of injury code (Chapter XX: External Causes of Morbidity and Mortality in the Canadian Coding Standards for ICD-10-CA and CCI), place of occurrence code (U98.–Place of occurrence) or activity code (U99.–Activity). Chapter XX codes are mandatory for use with codes in the range S00 to T98Injury, poisoning and certain other consequences of external causes. Category U98.–Place of occurrence is mandatory with codes in the range W00 to Y34, with the exception of Y06 and Y07. Recording with Category U99.–(Activity) is optional.
I’ve included short description of 3, 4 and 5 below but further information on all the types and when they are coded can be found in the manual:
-“3” Secondary Diagnosis - A Diagnosis Type (3) is a secondary diagnosis or condition for which a patient may or may not have received treatment, has been assigned an ICD-10-CA code and does not satisfy the requirements for determining co-morbidity. Diagnoses that are listed only on the front sheet, discharge summary, death certificate, history and physical or pre-operative anaesthetic consults qualify as Diagnosis Type (3). A Diagnosis Type (3) is also used for ICD-10-CA codes that are assigned to provide detail that in themselves do not represent a co-morbidity.
-“4” Morphology Code - Diagnosis Type (4) morphology codes are derived from ICD-O (International Classification of Diseases—Oncology) codes describing the type and behaviour of neoplasm. These codes are found in Chapter XXII: Morphology of Neoplasms.
-“5” Admitting Diagnosis - Diagnosis Type (5) can be used to code the admitting diagnosis when it differs from the most responsible Diagnosis Code. Its use is determined at the provincial/territorial or facility level. Refer to the DAD provincial/territorial sections and facility policies to determine the use of this Diagnosis Type.
I have prepared flag variables for the DAD 2009 ICD-10 classification (which I will send to the DLI for distribution once finished; I’m still working on the CCI codes). As I was looking at the frequencies of these flag variables to see if they made sense (i.e., that the chapter headings were picked up along with the more specific heading), I encountered something peculiar: there are no ICD-10 listings for any classification of V01 through Y98 (external causes of morbidity and mortality) – no one requiring treatment for any form of accident, fall, drowning, assault, etc. Were these records suppressed on the file distributed to us, or was it random chance (through sampling) that none of these records were selected for our file, or (even less likely, there were no such discharges through the years)? I checked the specifications file for the cycle (specifications-dad-raf.pdf), and couldn’t see any note to that effect in the exclusions.
Exclusions:
- Stillbirths (ENT_CODE = S)
- Cadaveric donations (ADM_CAT = R)
- All therapeutic abortion (TA) records, defined as follows:
1) ICD-10-CA diagnosis code = O04 at the three-digit level, in any diagnosis code field; or
2) CCI intervention code = 5CA20, 5CA24, 5CA88, 5CA89 or 5CA90 at the five-digit level, in any intervention code file
Answer
ICD-10 codes for ‘external causes of morbidity and mortality’ (V01 - Y98) are recorded as a diagnosis type ‘9’. All diagnoses with a diagnosis type of ‘3', '4', '5' or '9' were removed from the records for privacy reasons. As per the file layout there are only type ‘M’, ‘1’, ‘2’, ‘W’, ‘X’ and ‘Y’ included in the file.
This is not included in the exclusion criteria of the specifications because it was not the criteria used to remove an entire record. Any record with one of the exclusions listed (Ex. stillbirths) was completely removed from the dataset. In the case of diagnoses type ‘3', '4', '5' or '9' these ICD-10 codes were only removed from the record and the record itself was retained in the dataset. This way you can still search ICD-10 codes for ‘Injury, poisoning and certain other consequences of external causes’ (S00-T98) to obtain records with a diagnosis due to an external injury – but the cause is removed.
All this information can be found in the DAD Abstracting Manuals which we provided as part of the DLI. The Group 10 – Diagnosis section contains a description of “Diagnosis Type” and how it is coded.
For example:
-“9” External Cause of Injury Code - A Diagnosis Type 9 is assigned to an external cause of injury code (Chapter XX: External Causes of Morbidity and Mortality in the Canadian Coding Standards for ICD-10-CA and CCI), place of occurrence code (U98.–Place of occurrence) or activity code (U99.–Activity). Chapter XX codes are mandatory for use with codes in the range S00 to T98Injury, poisoning and certain other consequences of external causes. Category U98.–Place of occurrence is mandatory with codes in the range W00 to Y34, with the exception of Y06 and Y07. Recording with Category U99.–(Activity) is optional.
I’ve included short description of 3, 4 and 5 below but further information on all the types and when they are coded can be found in the manual:
-“3” Secondary Diagnosis - A Diagnosis Type (3) is a secondary diagnosis or condition for which a patient may or may not have received treatment, has been assigned an ICD-10-CA code and does not satisfy the requirements for determining co-morbidity. Diagnoses that are listed only on the front sheet, discharge summary, death certificate, history and physical or pre-operative anaesthetic consults qualify as Diagnosis Type (3). A Diagnosis Type (3) is also used for ICD-10-CA codes that are assigned to provide detail that in themselves do not represent a co-morbidity.
-“4” Morphology Code - Diagnosis Type (4) morphology codes are derived from ICD-O (International Classification of Diseases—Oncology) codes describing the type and behaviour of neoplasm. These codes are found in Chapter XXII: Morphology of Neoplasms.
-“5” Admitting Diagnosis - Diagnosis Type (5) can be used to code the admitting diagnosis when it differs from the most responsible Diagnosis Code. Its use is determined at the provincial/territorial or facility level. Refer to the DAD provincial/territorial sections and facility policies to determine the use of this Diagnosis Type.
Tuesday, May 6, 2014
Long Term Care Facilities Survey
Question
Will tables be released from the Long Term Care Facilities Survey: <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5203>? The Daily of April 10th<http://www.statcan.gc.ca/daily-quotidien/140410/dq140410d-eng.htm> indicates that the data has been released. Does this specifically refer to the master file or other products as well?
We have a researcher who is requesting summary findings by province (and territories if available) for:
1. Number of hours of care per resident
- This was reported as Number of hours of nursing care per resident/day for the superseded survey, Residential Care Facilities
- She would be interested in any consistent measurement of numbers of hours of professional health care per resident, as long as it is consistent, would be acceptable
2. Dollars per year per resident
3. Ratio of profit versus non-profit long-term care facilities.
Answer
This is available as a custom. The cost would be $256.00 plus applicable taxes. It will only include home for the Aged. The Mental Health and the Other facilities have confidentiality issues. For some provinces, we do not have enough facilities to disclose without identifying the facilities. We would have to collapse the data and that would imply a few more hours of work.
Will tables be released from the Long Term Care Facilities Survey: <http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5203>? The Daily of April 10th<http://www.statcan.gc.ca/daily-quotidien/140410/dq140410d-eng.htm> indicates that the data has been released. Does this specifically refer to the master file or other products as well?
We have a researcher who is requesting summary findings by province (and territories if available) for:
1. Number of hours of care per resident
- This was reported as Number of hours of nursing care per resident/day for the superseded survey, Residential Care Facilities
- She would be interested in any consistent measurement of numbers of hours of professional health care per resident, as long as it is consistent, would be acceptable
2. Dollars per year per resident
3. Ratio of profit versus non-profit long-term care facilities.
Answer
This is available as a custom. The cost would be $256.00 plus applicable taxes. It will only include home for the Aged. The Mental Health and the Other facilities have confidentiality issues. For some provinces, we do not have enough facilities to disclose without identifying the facilities. We would have to collapse the data and that would imply a few more hours of work.
Export Data
Question
I have a researcher looking for export data that seems to be available from the Exporter Register. He is looking for export value by destination and by firm size (either in terms of number of employees or, even better, in terms of revenue). An example of what the data would look like is table 1.2 in this publication:<https://www.ic.gc.ca/eic/site/061.nsf/vwapj/KSBS-PSRPE_June-Juin2011_eng.pdf/$FILE/KSBS-PSRPE_June-Juin2011_eng.pdf>
Is it is possible to get this data for more countries and as a time series. Is there any chance he can have access to the Exporter Register directly?
Answer
Unfortunately, we are not disseminating any data from the Importer/Exporter registries at this time as they are currently under review. Which means that the database’s methodologies are being re-examined. The database is hence temporarily not available for dissemination to the general public. At this point we do not have a time estimate as of when the databases will be available for access again.
It is important to note that this database’s micro-level records can only be accessible for research purposes via the Canadian Centre for Data Development and Economic Research. The researcher will have to have a formalized proposal of research topic approved by Statcan before they can gain access.
There is no way for students to access these directories free of charge, so if and when they do become available again, it would be on a cost recovery basis.
I have a researcher looking for export data that seems to be available from the Exporter Register. He is looking for export value by destination and by firm size (either in terms of number of employees or, even better, in terms of revenue). An example of what the data would look like is table 1.2 in this publication:<https://www.ic.gc.ca/eic/site/061.nsf/vwapj/KSBS-PSRPE_June-Juin2011_eng.pdf/$FILE/KSBS-PSRPE_June-Juin2011_eng.pdf>
Is it is possible to get this data for more countries and as a time series. Is there any chance he can have access to the Exporter Register directly?
Answer
Unfortunately, we are not disseminating any data from the Importer/Exporter registries at this time as they are currently under review. Which means that the database’s methodologies are being re-examined. The database is hence temporarily not available for dissemination to the general public. At this point we do not have a time estimate as of when the databases will be available for access again.
It is important to note that this database’s micro-level records can only be accessible for research purposes via the Canadian Centre for Data Development and Economic Research. The researcher will have to have a formalized proposal of research topic approved by Statcan before they can gain access.
There is no way for students to access these directories free of charge, so if and when they do become available again, it would be on a cost recovery basis.
Friday, May 2, 2014
PCCD Best Match Alogrhythm
Question
Is it possible to get any more detail on the actual algorithm that is run on the main PCCF file to produce the best match in addition to the wording below?From the codebook we have:
" The single link indicator (SLI) was created to assist users in dealing with postal codesOM with multiple records. The method used to establish the single link indicator identifies the geographic area with the majority of dwellings assigned to a particular postal codeOM"
Answer
It looks like you are looking for Postal CodeOM Conversion File (PCCF), Reference Guide, June 2013 <http://www.statcan.gc.ca/pub/92-154-g/92-154-g2013001-eng.pdf>. This is only part of the explanation for Single Link Indicator (SLI) available in the guide. Further on in the guide, there is an explanatory note regarding using the SLI for retrieving distinct records, in section 4 (Technical specifications, Record layouts and data descriptions: <http://www.statcan.gc.ca/pub/92-154-g/2013001/tech-eng.htm>
Single link indicator (SLI)
The single link indicator (SLI) provides a geographic record for mapping a postal codeOM representative point. It can be used to establish a one-to-one relationship between postal codesOM and dissemination areas, dissemination blocks, or block-faces. The SLI has the value of '1' to flag one record of an active postal codeOM. Every set of retired records for a postal codeOM, for a given retirement date, has one SLI equal to '1.' The SLI value '0' indicates additional records.
For more information as to how the link was established, refer to section 5. (Data Quality, Lineage, Linking to 2011 Census geographic areas: <http://www.statcan.gc.ca/pub/92-154-g/2013001/qual-eng.htm>
Many postal codesOM are represented by multiple records on the PCCF.The single link indicator (SLI) is created to assist users dealing with postal codesOM having multiple records. The SLI provides a geographic record for mapping a postal codeOM representative point. The SLI has a value of '1' to flag the best (or only) link for a given postal codeOM. The value '0' indicates an additional record. Please note that the SLI is identified on both active and retired postal codesOM. Users will find when working with both active and retired postal codesOM that multiple SLIs will appear for a postal codeOM that was retired and reintroduced. However, there will only be one SLI for a set of active records for a postal codeOM. When assigning the SLI, priority is given to postal codesOM associated with civic addresses or dwellings (based on the PCtype). The confidence of coding to the geographic area (the quality indicator) and the precision of the geocoding (the block-face, dissemination area or dissemination block), as well as the population, are considered. When the postal codeOM was linked to a DA associated with multiple federal electoral district (FED), population centre (POPCTR), or designated place (DPL), the SLI is linked to the record represented by the greatest proportion of the FED, POPCTR, or DPL population.
Users are cautioned that the SLI provides only a partial correspondence between the postal codeOM and other geographic areas.
Is it possible to get any more detail on the actual algorithm that is run on the main PCCF file to produce the best match in addition to the wording below?From the codebook we have:
" The single link indicator (SLI) was created to assist users in dealing with postal codesOM with multiple records. The method used to establish the single link indicator identifies the geographic area with the majority of dwellings assigned to a particular postal codeOM"
Answer
It looks like you are looking for Postal CodeOM Conversion File (PCCF), Reference Guide, June 2013 <http://www.statcan.gc.ca/pub/92-154-g/92-154-g2013001-eng.pdf>. This is only part of the explanation for Single Link Indicator (SLI) available in the guide. Further on in the guide, there is an explanatory note regarding using the SLI for retrieving distinct records, in section 4 (Technical specifications, Record layouts and data descriptions: <http://www.statcan.gc.ca/pub/92-154-g/2013001/tech-eng.htm>
Single link indicator (SLI)
The single link indicator (SLI) provides a geographic record for mapping a postal codeOM representative point. It can be used to establish a one-to-one relationship between postal codesOM and dissemination areas, dissemination blocks, or block-faces. The SLI has the value of '1' to flag one record of an active postal codeOM. Every set of retired records for a postal codeOM, for a given retirement date, has one SLI equal to '1.' The SLI value '0' indicates additional records.
For more information as to how the link was established, refer to section 5. (Data Quality, Lineage, Linking to 2011 Census geographic areas: <http://www.statcan.gc.ca/pub/92-154-g/2013001/qual-eng.htm>
Many postal codesOM are represented by multiple records on the PCCF.The single link indicator (SLI) is created to assist users dealing with postal codesOM having multiple records. The SLI provides a geographic record for mapping a postal codeOM representative point. The SLI has a value of '1' to flag the best (or only) link for a given postal codeOM. The value '0' indicates an additional record. Please note that the SLI is identified on both active and retired postal codesOM. Users will find when working with both active and retired postal codesOM that multiple SLIs will appear for a postal codeOM that was retired and reintroduced. However, there will only be one SLI for a set of active records for a postal codeOM. When assigning the SLI, priority is given to postal codesOM associated with civic addresses or dwellings (based on the PCtype). The confidence of coding to the geographic area (the quality indicator) and the precision of the geocoding (the block-face, dissemination area or dissemination block), as well as the population, are considered. When the postal codeOM was linked to a DA associated with multiple federal electoral district (FED), population centre (POPCTR), or designated place (DPL), the SLI is linked to the record represented by the greatest proportion of the FED, POPCTR, or DPL population.
Users are cautioned that the SLI provides only a partial correspondence between the postal codeOM and other geographic areas.
Subscribe to:
Posts (Atom)