目的:覆盖整个人口的挪威卫生登记处用于管理,研究,和应急准备。我们将这些数据统一到观察医疗结果伙伴关系通用数据模型(OMOPCDM)上,并使用COVID-19相关数据丰富OMOP格式的现实数据。
方法:来自六个注册管理机构(2018-2021年)的数据,涵盖出生登记,选定的初级和二级保健事件,疫苗接种,传染病通知被映射到OMOPCDMv5.3。使用数据表征文档和扫描工具对模拟数据开发了提取-转换-加载(ETL)管道。我们进行了仪表板质量检查,队列世代,调查源数据和映射数据之间的差异,并相应地完善了ETL。
结果:我们绘制了5,673,845个人的15亿行数据。其中,有804,277次怀孕,483,585名母亲和792,477名儿童,和472,948个父亲。我们在380,794例患者中发现了382,516例COVID-19阳性检测。这些数字与源数据的结果一致。除了自动映射的1100万个源代码之外,我们将237个非标准代码映射到标准概念,并引入了38个自定义概念,以适应OMOPCDM词汇不支持的妊娠相关术语.共有3,700/3,705(99.8%)的检查通过。5个失败的检查可以通过数据的性质来解释,并且仅代表少量的记录。
结论:挪威注册管理机构数据已成功地统一到OMOPCDM上,具有高度的一致性,并为联合COVID-19相关研究提供了有价值的来源。我们的绘图经验对于北欧卫生注册中心的数据合作伙伴非常有价值。
OBJECTIVE: Norwegian health registries covering entire population are used for administration, research, and emergency preparedness. We harmonized these data onto the Observational Medical Outcomes Partnership common data model (OMOP CDM) and enrich real-world data in OMOP format with COVID-19 related data.
METHODS: Data from six registries (2018-2021) covering birth registrations, selected primary and secondary care events, vaccinations, and communicable disease notifications were mapped onto the OMOP CDM v5.3. An Extract-Transform-Load (ETL) pipeline was developed on simulated data using data characterization documents and scanning tools. We ran dashboard quality checks, cohort generations, investigated differences between source and mapped data, and refined the ETL accordingly.
RESULTS: We mapped 1.5 billion rows of data of 5,673,845 individuals. Among these, there were 804,277 pregnancies, 483,585 mothers together with 792,477 children, and 472,948 fathers. We identified 382,516 positive tests for COVID-19 in 380,794 patients. These figures are consistent with results from source data. In addition to 11 million source codes mapped automatically, we mapped 237 non-standard codes to standard concepts and introduced 38 custom concepts to accommodate pregnancy-related terminologies that were not supported by OMOP CDM vocabularies. A total of 3,700/3,705 (99.8%) checks passed. The 5 failed checks could be explained by the nature of the data and only represent a small number of records.
CONCLUSIONS: Norwegian registry data were successfully harmonized onto OMOP CDM with high level of concordance and provides valuable source for federated COVID-19 related research. Our mapping experience is highly valuable for data partners with Nordic health registries.