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;

本数据集用于医疗预约爽约相关研究。数据集源自巴西伊塔雅伊河谷大学物理与智力康复专业化中心（CER, Center of Specialization in Physical and Intellectual Rehabilitation）的提取数据。该诊所服务于巴西南部的统一健康系统（SUS, Unified Health System）。CER作为门诊服务机构，可提供诊断、评估、指导、早期干预及专业康复服务，长期致力于功能康复与社会心理赋能，以助力残障人士提升自主生活能力与独立性。
研究团队于2016年至2022年间，从电子表格中转录49593份医疗记录，实地收集该康复中心的爽约问题相关信息。为丰富数据集维度，研究团队将初始数据库与三类其他数据库进行融合，分别为：国际疾病分类（ICD, International Classification of Diseases）数据、天气状况数据及其他相关属性数据。
本数据集包含以下26项属性：
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 Temperatura Day"：预约当日的平均气温；
21. "Average Rain Day"：预约当日的平均降雨量；
22. "Max Temperature Day"：预约当日的最高气温；
23. "Max Rain Day"：预约当日的最大降雨量；
24. "Storm Day Before"：标记预约前一日是否出现强降雨；
25. "Rain Intensity"：预约当日的降雨强度，分为无雨、小雨、中雨或大雨；
26. "Heat Intensity"：预约当日的体感温度等级，分为寒冷、极寒、温暖、酷热或温和。