Medical Appointments No-Show

The data are used for the study of medical appointments no-show. The dataset consists of data obtained and extracted from the University of Vale do Itajaí Center of Specialization in Physical and Intellectual Rehabilitation (CER). The clinic serves the Unified Health System (SUS) in southern Brazil. The CER is an outpatient care service that performs diagnosis, assessment, guidance, early stimulation and specialized care. It has acted in functional rehabilitation and psychosocial qualification to encourage the autonomy and independence of people with disabilities.

Firstly, we collected the relevant information on the no-show problem in loco at the rehabilitation centre by transcribing 49,593 medical records from an electronic spreadsheet of 2016 to2022. In order to add more information to the collected data, some other databases were combined with the initial database, namely: ICD, weather conditions data and other related attributes. Finally, this dataset is composed of the following attributes:
1. "Specialty": specialty that patient received the treatment;
2. "Appointment Time": appointment time scheduled;
3. "Gender": male or female gender of the patient;
4. "Appointment Date": appointment date scheduled;
5. "No-show": given whether the patient attended the scheduled appointment or not;
6. "No-show Reason": description of the reason why the patient did not attend the scheduled appointment;
7. "Disability”: the patient’s motor or intellectual disability;
8. "Date of Birth": the patient’s date of birth;
9. "Date of Entry into the Service": date of the patient’s first appointment at the CER;
10. "City": city where the patient resides;
11. "ICD": identifier of the patient’s disease;
12. "Appointment Month";
13. "Appointment Year";
14. "Appointment Shift";
15. "Age": patient's age;
16. "Under 12 years old": patient's age under 12 years old;
17. "Over 60 years old": patient's age over 60 years old;
18. "Patient needs companion": patient's needs companion to go to the appointment;
19. "Patient needs companion": patient's needs companion to go to the appointment;
20. "Average Temperatura Day": Average temperatura in the day of the appointment;
21. "Average Rain Day": Average rain in the day of the appointment;
22. "Max Temperature Day": Maximum temperature in the day of the appointment;
23. "Max Rain Day": Maximum rainfall in the day of the appointment;
24. "Storm Day Before": Heavy rain in the day before the appointment;
25. "Rain Intensity": no rain, weak, moderate or heavy rain in the day of the appointment;
26. "Heat Intensity": cold, heavy cold, warm, heavy warm or mild in the day of the appointment;

本数据集用于医疗预约爽约（no-show）相关研究。数据采集自巴南部地区服务于统一卫生系统（SUS）的伊塔雅伊河谷大学物理与智力康复专业化中心（CER）。该中心作为门诊诊疗机构，可开展诊断、评估、指导、早期干预及专科护理服务，长期致力于功能康复与社会心理赋能，助力残障人士提升自主生活能力与独立性。

研究团队于该康复中心实地采集爽约问题相关数据，通过转录2016年至2022年间电子表格中的49593份医疗记录完成初始数据收集。为丰富数据集维度，研究团队将初始数据库与多个外部数据库进行融合，具体包括国际疾病分类（ICD）数据集、天气状况数据集及其他相关属性数据集。

本数据集包含以下属性：
1. "Specialty": 患者接受诊疗的专科科室；
2. "Appointment Time": 预约时段；
3. "Gender": 患者性别（男/女）；
4. "Appointment Date": 预约日期；
5. "No-show": 患者是否如约赴诊；
6. "No-show Reason": 患者未赴约的原因说明；
7. "Disability": 患者的运动或智力残障情况；
8. "Date of Birth": 患者出生日期；
9. "Date of Entry into the Service": 患者首次在CER就诊的日期；
10. "City": 患者常住城市；
11. "ICD": 患者疾病编码；
12. "Appointment Month": 预约月份；
13. "Appointment Year": 预约年份；
14. "Appointment Shift": 预约班次；
15. "Age": 患者年龄；
16. "Under 12 years old": 患者年龄是否低于12岁；
17. "Over 60 years old": 患者年龄是否高于60岁；
18. "Patient needs companion": 患者就诊是否需要陪护；
19. "Patient needs companion": 患者就诊是否需要陪护；
20. "Average Temperature Day": 预约当日平均气温；
21. "Average Rain Day": 预约当日平均降雨量；
22. "Max Temperature Day": 预约当日最高气温；
23. "Max Rain Day": 预约当日最大降雨量；
24. "Storm Day Before": 预约前一日是否出现强降雨；
25. "Rain Intensity": 预约当日降雨强度（无雨、小雨、中雨或大雨）；
26. "Heat Intensity": 预约当日气温体感等级（寒冷、严寒、温暖、酷热或温和）；

搜集汇总

背景与挑战

背景概述

该数据集专注于研究医疗预约未出现情况，包含2016年至2022年巴西一家康复中心的49,593条医疗记录，具有26个属性，涵盖患者特征、预约详情和天气条件等多元信息，适用于预测模型和医疗行为分析。