MASUNARI Naomi

In this article, we describe an attempt to prepare teaching materials to efficiently process NDB open data. The teaching materials consist of explanations of NDB open data and instructions of data processing using Visual Basic for Applications (VBA), a programming language that can be used with the spreadsheet software Excel. In addition, the teaching materials allow students to understand the advantages of using VBA by comparing it to working with Excel worksheets. Finally, we asked them to solve VBA-related problems and confirmed their understanding of the teaching materials.

The Personal Data Protection Act is a law to balance "protection of individual rights and interests" and "utilization of personal data." It has been revised since its enactment in 2003 in accordance with social conditions and technological progress. The revision in 2020, which was reviewed every three years, was aimed at "protecting the rights and interests of individuals," "strengthening the utilization of data," and "corresponding to AI and big data." The revision in 2021 integrates the three laws of the Personal Data Protection Act, the Personal Data Protection Act of Administrative Agencies, and the Personal Data Protection Act of Incorporated Administrative Agencies into one law. Regarding the protection system, the post-integration law stipulates common rules nationwide, and the entire jurisdiction will be unified by the Personal Information Protection Commission. Under such circumstances, I studied the utilization of medical data.

-

The purpose of this study was to clarify the relationship between healthy life expectancy and lifestyle and other factors by utilizing real-world data such as open data from the National Database on Receipt Information and Specified Health Examination (NDB), which contains data on specified health examinations for approximately 20 million people nationwide. In men, fasting blood glucose of 126 mg/dL or more and financial capability index showed a negative correlation with healthy life expectancy, while sports activity rate and hobby activity rate showed a positive correlation with healthy life expectancy. In women, fasting blood glucose of 126 mg/dL or more and smoking habit showed a negative correlation with healthy life expectancy.

For the purpose of clarifying the relationship between mortality rate of all causes of death and Mortality rate from malignant neoplasms and lifestyle-related factors and other factors by utilizing the open data of the receipt information / specific medical examination information database (NDB), We examined the health issues of Japan and Yamaguchi Prefecture from the perspective of a registered dietitian. In men, "fasting blood glucose level 110 mg / dL or more", "systolic blood pressure 140 mmHg or more", "drinking more than 2 times on drinking days" and the mortality rate of all causes of death showed an association, and "the frequency of drinking alcohol every day", "drinking more than 2 times on drinking days" and mortality rate from malignant neoplasms showed an association. In women, the mortality rate of all causes of death was associated with "diastolic blood pressure of 90 mmHg or more", "smoking habit", and "weight gain / loss in one year is ± 3 kg or more", and "smoking habit" was mortality rate from malignant neoplasms to malignant neoplasms. Mortality was associated.