Data collection, analysis and recommendations - LIVE project (Deliverable 1)
Autor(a) principal: | |
---|---|
Data de Publicação: | 2014 |
Tipo de documento: | Relatório |
Idioma: | eng |
Título da fonte: | Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
Texto Completo: | https://hdl.handle.net/10216/70981 |
Resumo: | The Deliverable describes the development within the LIVE project of a methodology for the record linkage between police data and hospital data, using the case study of the Porto region, Portugal. The importance of this process is well recognized by institutions such as IRTAD (OECD/ITF) that are promoting the combination of various data sources to fully assess the consequences of road accidents and monitoring progress. The complexity of this process is mainly concerned with several issues found in the data sets; mistakes and missing values are frequently detected and there are only a few common data fields that can be matched by the linkage process. The deliverable report explores the data issues usually present in this kind of data set that may influence the results of the linkage process. It is common in several countries/regions that each entity (e.g. hospital) presents a different data system, which imply several and distinct data treatments depending on data characteristics. There is already some international work done in this field, which is briefly described in this deliverable report. As it was concluded in those studies, developments and/or improvements are still needed. In Portugal, thus far, there is no database connecting the accident police data set and the injuries medical hospital information in which linked records may support several studies of the relationship between the accident sites characteristics and the injury severities. Under the LIVE project, for the first time, an approach was developed to link police and hospitals data sets covering the Porto region. In this work, a fixed deterministic and weight-based probabilistic method to link the police and hospital records was used. The results obtained lie within the range of rates found in other studies. Additionally, to improve the record linkage results, a validation process based on the emergency ambulance data was performed. Despite the missing values, it was possible to check 98% of the matched records as true matches. Finally, a preliminary investigation of bias after data linkage is described, showing that the variables selected for comparison indicate similar statistical values. In addition, a brief statistical analysis is presented using the linked records. Considering that one of the main objectives of the LIVE project is to assess the application to the Portuguese context of the common definition already established by the European Union - the maximum abbreviated injury scale (MAIS), a description of the actual Portuguese background is presented. Ongoing efforts are being carried out to reach this final objective. The road accident linkage process is clearly and deeply described in this report in order to be adapted, developed and applied in different contexts, aiming to promote future developments on police, hospital and emergency ambulance data either in Portugal or in other countries. |
id |
RCAP_63d1c8dd573f91686b375c9a92feee4c |
---|---|
oai_identifier_str |
oai:repositorio-aberto.up.pt:10216/70981 |
network_acronym_str |
RCAP |
network_name_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository_id_str |
7160 |
spelling |
Data collection, analysis and recommendations - LIVE project (Deliverable 1)Engenharia civil, Engenharia civilCivil engineering, Civil engineeringThe Deliverable describes the development within the LIVE project of a methodology for the record linkage between police data and hospital data, using the case study of the Porto region, Portugal. The importance of this process is well recognized by institutions such as IRTAD (OECD/ITF) that are promoting the combination of various data sources to fully assess the consequences of road accidents and monitoring progress. The complexity of this process is mainly concerned with several issues found in the data sets; mistakes and missing values are frequently detected and there are only a few common data fields that can be matched by the linkage process. The deliverable report explores the data issues usually present in this kind of data set that may influence the results of the linkage process. It is common in several countries/regions that each entity (e.g. hospital) presents a different data system, which imply several and distinct data treatments depending on data characteristics. There is already some international work done in this field, which is briefly described in this deliverable report. As it was concluded in those studies, developments and/or improvements are still needed. In Portugal, thus far, there is no database connecting the accident police data set and the injuries medical hospital information in which linked records may support several studies of the relationship between the accident sites characteristics and the injury severities. Under the LIVE project, for the first time, an approach was developed to link police and hospitals data sets covering the Porto region. In this work, a fixed deterministic and weight-based probabilistic method to link the police and hospital records was used. The results obtained lie within the range of rates found in other studies. Additionally, to improve the record linkage results, a validation process based on the emergency ambulance data was performed. Despite the missing values, it was possible to check 98% of the matched records as true matches. Finally, a preliminary investigation of bias after data linkage is described, showing that the variables selected for comparison indicate similar statistical values. In addition, a brief statistical analysis is presented using the linked records. Considering that one of the main objectives of the LIVE project is to assess the application to the Portuguese context of the common definition already established by the European Union - the maximum abbreviated injury scale (MAIS), a description of the actual Portuguese background is presented. Ongoing efforts are being carried out to reach this final objective. The road accident linkage process is clearly and deeply described in this report in order to be adapted, developed and applied in different contexts, aiming to promote future developments on police, hospital and emergency ambulance data either in Portugal or in other countries.20142014-01-01T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/reportapplication/pdfhttps://hdl.handle.net/10216/70981engMarco Raul Soares Amoriminfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2023-11-29T13:38:04Zoai:repositorio-aberto.up.pt:10216/70981Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-19T23:44:23.309385Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse |
dc.title.none.fl_str_mv |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) |
title |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) |
spellingShingle |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) Marco Raul Soares Amorim Engenharia civil, Engenharia civil Civil engineering, Civil engineering |
title_short |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) |
title_full |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) |
title_fullStr |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) |
title_full_unstemmed |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) |
title_sort |
Data collection, analysis and recommendations - LIVE project (Deliverable 1) |
author |
Marco Raul Soares Amorim |
author_facet |
Marco Raul Soares Amorim |
author_role |
author |
dc.contributor.author.fl_str_mv |
Marco Raul Soares Amorim |
dc.subject.por.fl_str_mv |
Engenharia civil, Engenharia civil Civil engineering, Civil engineering |
topic |
Engenharia civil, Engenharia civil Civil engineering, Civil engineering |
description |
The Deliverable describes the development within the LIVE project of a methodology for the record linkage between police data and hospital data, using the case study of the Porto region, Portugal. The importance of this process is well recognized by institutions such as IRTAD (OECD/ITF) that are promoting the combination of various data sources to fully assess the consequences of road accidents and monitoring progress. The complexity of this process is mainly concerned with several issues found in the data sets; mistakes and missing values are frequently detected and there are only a few common data fields that can be matched by the linkage process. The deliverable report explores the data issues usually present in this kind of data set that may influence the results of the linkage process. It is common in several countries/regions that each entity (e.g. hospital) presents a different data system, which imply several and distinct data treatments depending on data characteristics. There is already some international work done in this field, which is briefly described in this deliverable report. As it was concluded in those studies, developments and/or improvements are still needed. In Portugal, thus far, there is no database connecting the accident police data set and the injuries medical hospital information in which linked records may support several studies of the relationship between the accident sites characteristics and the injury severities. Under the LIVE project, for the first time, an approach was developed to link police and hospitals data sets covering the Porto region. In this work, a fixed deterministic and weight-based probabilistic method to link the police and hospital records was used. The results obtained lie within the range of rates found in other studies. Additionally, to improve the record linkage results, a validation process based on the emergency ambulance data was performed. Despite the missing values, it was possible to check 98% of the matched records as true matches. Finally, a preliminary investigation of bias after data linkage is described, showing that the variables selected for comparison indicate similar statistical values. In addition, a brief statistical analysis is presented using the linked records. Considering that one of the main objectives of the LIVE project is to assess the application to the Portuguese context of the common definition already established by the European Union - the maximum abbreviated injury scale (MAIS), a description of the actual Portuguese background is presented. Ongoing efforts are being carried out to reach this final objective. The road accident linkage process is clearly and deeply described in this report in order to be adapted, developed and applied in different contexts, aiming to promote future developments on police, hospital and emergency ambulance data either in Portugal or in other countries. |
publishDate |
2014 |
dc.date.none.fl_str_mv |
2014 2014-01-01T00:00:00Z |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/report |
format |
report |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
https://hdl.handle.net/10216/70981 |
url |
https://hdl.handle.net/10216/70981 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.source.none.fl_str_mv |
reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação instacron:RCAAP |
instname_str |
Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
instacron_str |
RCAAP |
institution |
RCAAP |
reponame_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
collection |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository.name.fl_str_mv |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
repository.mail.fl_str_mv |
|
_version_ |
1799135759952773120 |