# Presentation: 085264

## APOLLO* W2 Core Project Burden of injuries in Europe

- *APOLLO is a multi-study package partially funded under the EC DG Sanco 2004 call for proposals

## Agenda

- Overview of WP2
- Objectives and Process for WP2 core tasks
- Relationship with umbrella project
- Deliverables
- Logistics of the project
- What it actually means
- Developments to date
- Web site
- Analyses of HDD
- Statistics Portal
- Time Frame

## WP2 Overview: Objectives and Process

**Title:**  “The Burden of Injuries in EU: Indicators and Recommendations for Prevention and Control”
**Aim:** To produce evidence relevant to European policy makers on the burden of injuries together with information on the efficiency of relevant injury prevention interventions.

## WP2 Core Overview: Objectives and Process

**Specific Objectives:**
- To map the urgency for taking action for prevention of injuries due to the magnitude of the problem by calculating an array of indicators, which are in accordance with the work proposed by the Working Party on Indicators of the EC
- To build capacity among new member states to adequately measure their burden of injuries with a view of monitoring the impact of their injury prevention efforts
- To develop the theoretical framework for essential indicators, which are currently missing with integration of injury severity measures and exposure to risk denominators
- To produce tools for linking injury severity with health outputs and costs by member states
- To recommend appropriate future data collection efforts

## APOLLO Structure & Funding (100%)60%

- They get their € directly

**Notes:**
Stephanie, again the sum of C. Frangakis and Y. Skalkidis does not add upt o 147611.68 which is what it should

## WP2 Core Deliverables

**Report on the Burden of Injuries in Europe**
- ...
**A web-based query system to produce additional tables and figures with injury data per country and for Europe at large**
**Final report summarizing all the above**

## Logistics of WP2 Core activities

- WP2 core involves participation of a total of 24 countries.
- Managed by Universidad de Navarra (UN) Team
- Deals, primarily with explotation of
**Hospital discharge data**
- And some work on either
- Emergency discharge data
- Health Interview Data
- Which is population-based, that is, we know of denominators. Whether national, regional, or local (e.g., city-wide), we will take what there is, in the above listed order (national>regional>local)

## What it actually means

- Define datasets available --telephone interview conducted, summary presented as poster in Vienna and being prepared as manuscript
- Good news, all have HDD, most 2004, most ICD-10 (4 ICD-9-CM)
- Develop a listing of indicators to be calculated
- So far, 300 reviewed, 20 selected with further breakdowns by age and gender
- Create/Update/customize software algorithms to derive numerators and denominators for indicator development.
- For example, maps from ICD into AIS, ICD into Barrel matrix...

## Cont ́d)

- Develop a website that will become the “working space” for  project partners
- Development of sofware to analyze data
- Analyze those data that participating countries cannot analyze by themselves
- Development of the web-query system
- Development of Report on Burden

## Developments to date

- Summary on data sources completed –poster available, manuscript under preparation
- Summary on indicators completed, manuscript under preparation for APHA
- Web site as working tool completed

## https://www.unav.es/preventiva/apollo/asistente/

-  3 Levels of Users: **- Administrators – Participants – Public**

## Analysis of HDD undergoing –in 14 steps

- Gather Census Data
- Gather (additional) information on Hospital Discharge Data
- Gather Hospital Discharge Data and temporarily upload it to UN
- Check for quality of injury codes
- Apply ICDMAP algorithm
- Apply Barell Matrix algorithm
- Apply AIS to FCI algorithm
- Apply external causes of injuries
- Apply nature of injury categories algorithm
- Upload augmented hospital discharge data to UN temporarily
- Calculate frequency distributions
- Upload log file of frequency distributions
- Upload results from log file onto web-query system
- Calculate indicators

*partners*

*UN*

## Programming for HDD

|  | Stata | SPSS |
| --- | --- | --- |
| ICD-9-CM | Quality of ICD codes check
Barell matrix
(ICDMAP ICD9CM-AIS98)
Other nature and mechanism categories
Frequency distributions | Quality of ICD codes check
Barell matrix
(ICDMAP ICD9CM-AIS98)
Other nature and mechanism categories
Frequency distributions |
| ICD-10 | Quality of ICD codes check
Barell matrix
ICDMAP ICD10-AIS98
Other nature and mechanism categories
Frequency distributions | Quality of ICD codes check
Barell matrix
ICDMAP ICD-10-AIS98
Other nature and mechanism categories
Frequency distributions |

- In sum: 18 programs developed + 2

- The software is open to the public. You can use it for other projects.
- You can give it to other people. Just cite it appropriately. A suggested reference
- is available in each program.

## STATISTICS PORTAL

- Using the Statistics Menu you can specify the parameters for your Query.

## Project Timeline Start date Dec 1, 2005

|  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | ... | 33 | .. | 36 |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| APOLLO | S | ... |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C |
| WP2 | S | ... |  |  |  |  |  |  |  |  |  |  |  |  |  | C |  |  |
| WP2 “core” | S | ... |  |  |  |  |  |  |  |  |  |  |  | C |  |  |  |  |
| Close country enrollment | S | ... | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Selection of indicators | S | ... | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Develop web as tool for project management | S | ... |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Develop dummy burden report |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Develop analyses routines | S | ... |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Data analyses |  | S | ... |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  |
| Web based query system |  |  |  | S | ... |  |  |  |  |  |  |  |  | C |  |  |  |  |
| Burden report review |  |  |  |  |  |  |  |  |  | S | ... |  |  | C |  |  |  |  |
| Meetings | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  |  |
| Telephone/e-mail contacts with subcontractors | S | ... |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C |
| Telephone/e-mails with subprojects  | S | ... |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C |
| Final report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | .. | C |

- S= Start, C= Completed

- 

- 

- 

- 

- 

- 

## For questions or comments

- apollowp2core@unav.es

## APOLLO WP2 core participanting countries

- Austria
- Belgium
- Bulgaria
- Czech Republic
- Denmark
- Estonia
- Finland
- Germany
- Greece
- Hungary
- Ireland
- Italy

- Latvia
- Malta
- Norway
- Poland
- Portugal
- Slovakia
- Slovenia
- Spain
- Sweden
- The Netherlands
- Turkey
- United Kingdom

## Acknowledgments

- The UN team is comprised of Uwe Ewert, Jan Krafka, Rafael Heredero, Montserrat Ruiz, Maria del Carmen Lezáun, Cristina Patsouris, and María Seguí-Gómez.
- We appreciate the assistance of Lois Fingerhut, Maureen  Brenan, Cristina Rodriguez and Isabel Ricart in the development of some of the programms.
- We are thankful to Ellen MacKenzie for providing access to the ICDMAP from ICD-9-CM to AIS98