This easy-to-use online data tool is to facilitate and simplify access to Canadian Hospitals Injury Reporting and Prevention Program (CHIRPP) data for injury prevention stakeholders in British Columbia. The dataset reflects all visits to the emergency department of BC Children’s Hospital (BCCH), including visits by BC residents and non-residents.
How to Use the Tool
The main data selection page displays the data in 6 main sections. Each section is further divided into topic areas which allow the user to select the information needed. The tool has been developed to allow easy navigation and minimal screen consumption. Therefore, all the parameters are stored under collapsible categories that expand when selected.
By selecting specific parameters in the search selection, outputs in the form of tables and charts will be generated. As a default, we have ensured that all the boxes are checked in all the sections. This allows iDOT to look up data from the entire dataset. When you submit your query, the output tables will only display the data for those boxes that you have selected by checking/un-checking. A summary of your selected parameters as well as the date and time of your search will appear before each outputted table and chart to allow you to cross reference your selections.
There are two main levels to the data presented and a further two sub-levels for some categories. The first level is an aggregated version where data are presented as a group. The second level is more detailed and further breaks down the first level. All further levels can be accessed by clicking on the arrow (triangle) button beside the text.
There are two different types of output options: numbers and proportions per 100,000 CHIRPP cases. Proportions are only available by year, age group and sex and a selection needs to be made in order for proportions to be calculated. For example, a proportion can be calculated if you are interested in hockey injuries by year or falls by age group and sex. If a proportion cannot be calculated, you will receive a message in the proportion column of the output table.
Please note that the output can be broken down for up to two different categories. Below is an example that may assist you with using the tool.
Example: From 2007/08-2009/10, how many children and youth presented to BC Children’s Hospital emergency room with skateboard-related injuries?
- Leave injury date as per default as all 3 years are already checked
- Leave demographics as per default
- Leave cause of injury as per default
- Leave type of injury and body part as per default
- Under ‘location and activity’, leave place of occurrence checked as per default to obtain skateboarding injuries that took place anywhere
- Under ‘location and activity/sport activity when injured’, un-check all so that you can then check only ‘skateboarding’
- Under ‘broken down by’, select ‘sport activity’ and ‘none’
Output: A summary of your selection will be presented at the top. Your results will be displayed as a table. You can export your results either in excel, word or as a text document. If you would like to see the information in a chart, select the chart tab at the top.
Interpretation and meaning of the data charts and tables is the responsibility of the user. If you require assistance in interpreting the charts and tables, or if you have further questions, please contact BCIRPU at 604-875-3776. Definitions for some terms can be viewed in the glossary (enter the data tool to view the glossary).
A limitation of CHIRPP is that the injuries described do not represent all injuries in Canada, but only those seen at the CHIRPP hospitals therefore rates per 100,000 population cannot be calculated. Since most of the data come from the paediatric hospitals, which are located in major cities, injuries to the following people are under-represented in the CHIRPP database: older teenagers and adults who are seen at general hospitals; and people who live in rural and Northern areas including First Nations, Métis and Inuit people. Fatal injuries are also under-represented in the CHIRPP database because many victims die at the scene and are not transported to hospital. CHIRPP only records fatalities for victims who are dead on arrival, or die during treatment in the emergency department. The CHIRPP database only provides information that is recorded on the CHIRPP form or patient chart. Any information that is not recorded is coded as missing, unknown, or unspecified. This online injury data tool presents statistics only from BC Children’s Hospital, and is not representative of the entire BC population.
Funding for this tool was provided by the Public Health Agency of Canada. The opinions expressed on this web site are those of the authors/researchers and do not necessarily reflect the official views of the Public Health Agency of Canada.
Canadian Hospitals Injury Research and Prevention Program, British Columbia Children’s Hospital. Public Health Agency of Canada, Ottawa, ON. Retrieved from Injury Data Online Tool (iDOT), BC Injury Research and Prevention Unit. [Insert date accessed]
Last update for BC Children’s Hospital Emergency Room Data: January 2018