数据库辅助研究：区域医疗中心的结直肠癌地理散发特征——结合Tableau地图分析技术的真实世界数据报道

Database-assisted study: geographical distribution of colorectal cancer in regional medical center——a report under real world data combined with Tableau map

目的分析目前版本的华西肠癌数据库(Database from Colorectal Cancer,DACCA)中四川大学华西医院作为区域性医疗中心服务的结直肠癌患者的地理分布特征。方法选择2019年9月5日更新版华西DACCA中"手术日期"与"地址"两项数据作为主要研究项目,先分别对各选取的数据项目作特征分析,再对选取数据做联合特征分析。结果按照条件从DACCA中筛选共获得7 096行有效数据。按"地址"进行分级选取,全国各省、直辖市或特别行政区(以下简称"省级")有效数据7 096行,四川省有效数据6 551行,成都市有效数据2 954行。从DACCA中提供的地理信息显示,随着年份变化,结直肠癌就诊患者的各省级分布主要是以四川省的中东部为中心的西南地区,主要包括重庆市、云南省及贵州省的部分区域;四川省内市级分布区域主要是以"绵阳市-成都市-雅安市"为轴线的东部区域,成都市为核心;成都市内区(县)级分布区域主要以武侯区、金牛区、青羊区等为核心的三环路以内。结论华西DACCA提供的地理信息显示了近20年来结直肠癌就诊患者的地理分布特征,反映了四川大学华西医院服务地区患者的基本特征及其变化,可为医疗政策制定者提供结直肠癌筛查、诊治与随访重点管理区域的依据。

Objective To analyze the geographical distribution of patients with colorectal cancer by screening the current Database from Colorectal Cancer(DACCA) version in West China Hospital. Methods The selected DACCA database version of this data analysis was updated on September 5, 2019, and the two data of the "date of operation"and "address" were selected as the main research items. The characteristics of each selected data item were analyzed,and then the selected data were used as a joint feature analysis. Results According to the condition of selection by"address", 7 096 valid data rows from the whole nation were obtained, 6 551 valid data rows from Sichuan province were obtained, and 2 954 valid data rows from Chengdu city were obtained. The geographic information provided by the DACCA database showed that, with the year changing, the provincial distribution area of patients was mainly the southwest region with middle-east of Sichuan province as center, mainly including the parts of Chongqing, Yunnan,and Guizhou;The distribution area of the municipal level in Sichuan province was mainly the east region with axis of the "Mianyang-Chengdu-Ya’an", and Chengdu was the core;The regional distribution of patients in the Chengdu was mainly within the third ring load with Wuhou District, the Jinniu District, and the Qingyang District as the core area. Conclusion The geographical information provided by DACCA database shows the geographical distribution characteristics of patients in the past 20 years, reflecting the basic characteristics and changes of the service area of West China Hospital, and can provide a basis for medical policy makers in screening, diagnosing and treating of colorectal cancer, and key management areas of following-up.