Last updated July 2021 This tutorial was produced for Canadian Cancer Statistics 2021 Online data tools Selected data tables cancer incidence mortality and survival This tutorial was produced for Canadian Cancer Statistics 2019 ID: 1037364
Download Presentation The PPT/PDF document "Using Statistics Canada online data tool..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1. Using Statistics Canada online data tools to generate cancer statisticsLast updated – July 2021This tutorial was produced for Canadian Cancer Statistics 2021
2. Online data tools:Selected data tables – cancer incidence, mortality and survivalThis tutorial was produced for Canadian Cancer Statistics 2019Table numberDescription13-10-0111-01Number and rates of new cases of primary cancer, by cancer type, age group and sex13-10-0747-01Number of new cases and age-standardized rates of primary cancer, by cancer type and sex 13-10-0109-01Cancer incidence, by selected sites of cancer and sex, three-year average, Canada, provinces, territories and health regions (2015 boundaries)13-10-0112-01Cancer incidence, by selected sites of cancer and sex, three-year average, census metropolitan areas13-10-0142-01Deaths, by cause, Chapter II: Neoplasms (C00 to D48)13-10-0392-01Deaths and age-specific mortality rates, by selected grouped causes13-10-0800-01Deaths and mortality rate (age standardization using 2011 population), by selected grouped causes17-10-0005-01Population estimates on July 1st, by age and sex13-10-0158-01Age-specific five-year net survival estimates for primary sites of cancer, by sex, three years combined13-10-0159-01Age-specific five-year net survival estimates for selected cancers with age distributions of cases skewed to older ages, by sex, three years combined13-10-0160-01Age-standardized five-year net survival estimates for primary sites of cancer, by sex, three years combined13-10-0161-01Age-standardized and all-ages five-year net survival estimates for selected primary sites of cancer, by sex, three years combined, by province
3. Finding cancer data tables:Option 1: Search by specific table number or keyword From the Keyword(s) search bar on the main Data webpage, enter a data table number into the search bar: For example, to find Table 13-10-0111-01 for cancer incidence data, we can enter this table number as the search stringThis tutorial was produced for Canadian Cancer Statistics 2021
4. Finding cancer data tables:Option 1: Search by specific table number or keyword Note that searches for former CANSIM table numbers can still be used to find relevant data: For example, to find former CANSIM table 103-0550 for cancer incidence data, we can enter this table number as the search stringThis tutorial was produced for Canadian Cancer Statistics 2021
5. Finding cancer data tables:Option 2: Browse tables by survey or database Directly below the Keyword(s) search tool are options for browsing available tables by “Subject”, “Geography”, “Frequency” or “Survey or statistical program”. Expanding the choices for the “Survey or statistical program” section yields a long list of Statistics Canada surveys and databases. From this list, users can select “Canadian Cancer Registry” and “Vital Statistics – Death Database” for information on tables related to new cases of cancer and cancer deaths respectively. This tutorial was produced for Canadian Cancer Statistics 2021
6. Generating Custom Cancer Statistics Summaries in online data tools:As an example of how statistics Canada’s online data tools can be used to generate cancer statistics of interest, we have shown how a user could generate the following custom table of cancer statistics:Annual counts of new cancers for colorectal, prostate, and lung cancers for British Columbian men between 2008 and 2012. The following steps can be taken to generate this summary…This tutorial was produced for Canadian Cancer Statistics 2021
7. Generating Custom Cancer Statistics Summaries in online toolsStep 1: Enter table number 13-10-0111-01 into the search bar and hit search. This will land on the default data table below. This tutorial was produced for Canadian Cancer Statistics 2021
8. Generating Custom Cancer Statistics Summaries in online toolsStep 2: To customize this summary, click on the “Add/Remove data” tab where additional selections can be made.This tutorial was produced for Canadian Cancer Statistics 2021
9. Generating Custom Cancer Statistics Summaries in online toolsStep 3: From “Geography”, select the region of interest (here, British Columbia).This tutorial was produced for Canadian Cancer Statistics 2021
10. Generating Custom Cancer Statistics Summaries in online toolsStep 4: From “Sex”, select the sex of interest (here, males).This tutorial was produced for Canadian Cancer Statistics 2021
11. Generating Custom Cancer Statistics Summaries in online toolsThis tutorial was produced for Canadian Cancer Statistics 2021Step 5: From the “Primary types of cancer” menu, select the cancers of interest (here, lung, colorectal and prostate).
12. Generating Custom Cancer Statistics Summaries in online toolsStep 6: Select statistics of interest from the “Characteristics” menu. Here we select “Number of new cancer cases”.This tutorial was produced for Canadian Cancer Statistics 2021
13. Generating Custom Cancer Statistics Summaries in online toolsStep 7: From “Reference period”, select the range of years of interest (here, 2008 to 2012). This tutorial was produced for Canadian Cancer Statistics 2021Step 8: When all selections have been made, click “apply” to generate the custom table. You will be automatically directed to the “Data Table”, where your custom summary table will be displayed.
14. Generating Custom Cancer Statistics Summaries in online toolsThe following table should now appear on screen. The final “Customize Layout” tab can be used to further adjust the output format of the table. Clicking on the “Download options” tab will offer several choices for exporting custom tables. This tutorial was produced for Canadian Cancer Statistics 2021
15. Generating Custom Cancer Statistics Summaries in online toolsStep 9: The download options pop-up menu provides the following choices fordownloading the custom table: This tutorial was produced for Canadian Cancer Statistics 2021Users can download only the custom table generatedOr download the entire table of cancer statistics from this product
16. Differences between data for online data tables and Canadian Cancer StatisticsCAUTION: Users of Statistics Canada’s online data tables should be aware that there are some differences between data compiled for the Canadian Cancer Statistics publication and those used in the online tables. For details on the online tables, users should review the footnotes provided under each table. The information found in those footnotes can be compared to the details provided in Appendix II of Canadian Cancer Statistics. The following describes some notable differences between the methodology used in compiling the statistics in the online tables and Canadian Cancer Statistics. It is not an exhaustive list.The number of age groups used to age standardize the rates was 19 in the online tables and 18 in Canadian Cancer Statistics. The difference is that the ‘85–89’ and ‘90+’ age groups used by Statistics Canada were collapsed into ‘85+’ age group for Canadian Cancer Statistics.In the data used for Canadian Cancer Statistics, cases identified through ‘death certificate only’ (DCO) were imputed for the provinces of Ontario (2014-2015) and Manitoba (2013-2015). This approach was not done for the online data. This could lead to differences in statistics for these provinces and for Canada as a whole. This tutorial was produced for Canadian Cancer Statistics 2021
17. Differences between data for online data tables and Canadian Cancer Statistics (continued)Cancer groupings sometimes differ between the online tables and Canadian Cancer Statistics. For example, the ‘leukemia’ group from Canadian Cancer Statistics is split into several leukemia subtypes in some online tables (e.g. acute lymphocytic leukemia, chronic lymphocytic leukemia, etc.). Users should carefully compare cancer group definitions across data sources. Data on new cancer cases for the province of Quebec are not available in the Canadian Cancer Registry for diagnosis years beyond 2010. A different approach to imputing the Quebec data is sometimes between the two sources.This tutorial was produced for Canadian Cancer Statistics 2021