Data resource profile: JMDC claims database sourced from health insurance societies

1Japan has health insurance provided by the social insurance system, and this health insurance is provided by multiple bodies, on the basis of occupation, geography, and age (eg, elderly, geriatric), including health insurance associations which cover medical costs except for employment‐related injury of people less than 75 years old, primarily those who are employees of large businesses, and their dependents. 1

2JMDC, Inc. (JMDC) has created a database, detailed below, using data collected from health insurance societies, as well as the databases sourced from medical institutions. 1 We describe the detailed information below although it is partly redundant with the information of the medical institutions' databases 1: The collected data consist of ledgers of insured persons, claims (for hospitalization, out‐patient treatment, drug preparation, and dental treatment), and health checkup results. Ledgers of insured persons include information about all persons insured by health insurance societies. Claims include information about medical expenses for which health insurance societies have been invoiced by medical institutions and about the insured persons who incurred the medical expenses. Health checkups are carried out so that health insurance societies can ascertain the health statuses of insured persons, and special health checkups are required to be conducted with the aim of preventing lifestyle‐related diseases in insured persons aged 40‐74.JMDC provides services of data analysis of actual conditions such as medical cost analysis by comparison with other insurers and extraction of high‐risk persons to health insurance societies distributed throughout Japan. Some of these health insurance societies agree to provide anonymously processed data of employees working at all branches and offices in Japan of the companies covered by the societies and their families, which do not include area information to third parties. Data are collected from these health insurance societies. The specific names and geographical information of included societies are not disclosed from JMDC because of their policy.Data are collected monthly, and collected data are added to the database approximately five months after the treatment date. Data are currently still being added to the database.In order to protect personal information, the collected data are added to the database as information that has been anonymized in accordance with Clause 2:9 of the Law for Protection of Personal Information, on the basis of personal IDs with which individuals cannot be identified. The personal ID is set by health insurance societies as an individual unit for managing insured person ledgers and claims, making it possible to recognize the same individual, if insured by the same health insurance society, even if treated by different medical institutions.The earliest data in the database that can be accessed are from the claims in January 2005. However, dental claims are included only from December 2009, and health checkup results only from April 2008.Currently (the end of June 2020), the number of insured persons included in the database, including those withdrawn at some stage, is approximately 9.8 million. As persons aged 75 or more cannot have health insurance administered by health insurance societies, all persons included in the database are aged 0 to 74.The monthly numbers of insured persons whose data can be accessed are shown in Figure 1. The number of insured persons tends to increase with increasing number of health insurance societies collecting data. Currently (the end of June 2020), the number of health insurance societies collecting data is 216, and the number of insured persons is approximately 6.1 million.Currently (the end of June 2020), the number of hospital department and drug preparation claims included in the database is approximately 370 million, and the number of actual patients, that is, the number of insured persons for whom at least one hospital department and/or drug preparation claim is released, is approximately 8.9 million.In the last 5 calendar years, the annual withdrawal rates by month from this database were about 8%–10%. It should be noted that those who moved to other included societies were also counted as withdrawals in this calculation, because it is difficult to determine the same person who has moved to another society.

3The collected data consist of ledgers of insured persons, claims (for hospitalization, out‐patient treatment, drug preparation, and dental treatment), and health checkup results. Ledgers of insured persons include information about all persons insured by health insurance societies. Claims include information about medical expenses for which health insurance societies have been invoiced by medical institutions and about the insured persons who incurred the medical expenses. Health checkups are carried out so that health insurance societies can ascertain the health statuses of insured persons, and special health checkups are required to be conducted with the aim of preventing lifestyle‐related diseases in insured persons aged 40‐74.

4JMDC provides services of data analysis of actual conditions such as medical cost analysis by comparison with other insurers and extraction of high‐risk persons to health insurance societies distributed throughout Japan. Some of these health insurance societies agree to provide anonymously processed data of employees working at all branches and offices in Japan of the companies covered by the societies and their families, which do not include area information to third parties. Data are collected from these health insurance societies. The specific names and geographical information of included societies are not disclosed from JMDC because of their policy.

5Data are collected monthly, and collected data are added to the database approximately five months after the treatment date. Data are currently still being added to the database.

6In order to protect personal information, the collected data are added to the database as information that has been anonymized in accordance with Clause 2:9 of the Law for Protection of Personal Information, on the basis of personal IDs with which individuals cannot be identified. The personal ID is set by health insurance societies as an individual unit for managing insured person ledgers and claims, making it possible to recognize the same individual, if insured by the same health insurance society, even if treated by different medical institutions.

7The earliest data in the database that can be accessed are from the claims in January 2005. However, dental claims are included only from December 2009, and health checkup results only from April 2008.

8Currently (the end of June 2020), the number of insured persons included in the database, including those withdrawn at some stage, is approximately 9.8 million. As persons aged 75 or more cannot have health insurance administered by health insurance societies, all persons included in the database are aged 0 to 74.

9The monthly numbers of insured persons whose data can be accessed are shown in Figure 1. The number of insured persons tends to increase with increasing number of health insurance societies collecting data. Currently (the end of June 2020), the number of health insurance societies collecting data is 216, and the number of insured persons is approximately 6.1 million.

10Currently (the end of June 2020), the number of hospital department and drug preparation claims included in the database is approximately 370 million, and the number of actual patients, that is, the number of insured persons for whom at least one hospital department and/or drug preparation claim is released, is approximately 8.9 million.

11In the last 5 calendar years, the annual withdrawal rates by month from this database were about 8%–10%. It should be noted that those who moved to other included societies were also counted as withdrawals in this calculation, because it is difficult to determine the same person who has moved to another society.

12Research carried out using this database includes the following: Drug utilization surveys (longitudinal and transverse) 2, 3, 4, 5, 6, 7 Drug risk assessment 8, 9, 10 Evidence‐practice gap 11, 12, 13, 14, 15 Effectiveness of intervention 16, 17, 18 Cost and economic analysis 19, 20, 21, 22 Health checkup 23, 24, 25, 26 Validation 27, 28

13Drug utilization surveys (longitudinal and transverse) 2, 3, 4, 5, 6, 7

14Drug risk assessment 8, 9, 10

15Evidence‐practice gap 11, 12, 13, 14, 15

16Effectiveness of intervention 16, 17, 18

17Cost and economic analysis 19, 20, 21, 22

18Health checkup 23, 24, 25, 26

19Validation 27, 28

20All data collected from health insurance societies are anonymized on the basis of personal ID so that individuals cannot be identified.

21Nonstandardized data are standardized using a dictionary like the databases sourced from medical institutions JMDC created. 1

22Abnormal values, time‐series consistency, etc., are verified independently by the JMDC. Missing values are left as they are but are relatively small in claims because the claim data submitted to the claims processing and payment organization are error checked in the external examination processes. However, it should be noted that the health checkup results have many missing values because JMDC does not collect health checkup results from all the health insurance societies JMDC collects data.

23The database consist of (a) tables for the population; medical institution; claims; claims: injury/disease; claims: drugs; claims: medical care activities; claims: treatment materials; and health checkup results; and (b) master data for injuries/diseases, drugs, medical care activities, etc., including standardized medical terms. Explanations of all the tables, and examples of fields are shown in Table 1.

24The following analyses can be carried out using this database: The data are from a complete‐enumeration survey of the population, including healthy people. Therefore, for certain diseases, chosen on a discretionary basis, the prevalence, incidence rate, specific treatment rate, medical expenses per patient, and number of days with hospital visits or admissions can be calculated.The data were from a survey that followed the patient longitudinally. Therefore, it is possible to analyze sequential data (hospital visit and admission histories, and numbers of health checkups).It is possible to conduct epidemiological studies with the health checkup results as exposure, and information obtained from the claims as the endpoints. In this case, it will be preferable to validate some sort for the disease name in the claims.Deaths recorded in the ledger of insured persons can be used as an endpoint for epidemiological studies. In the case of deaths in the outcome information in claims, validation studies have shown the sensitivity, specificity, and positive predictive value in relation to hospitalized deaths in patients of aged over 65‐74 be approximately 95%. 28

25The data are from a complete‐enumeration survey of the population, including healthy people. Therefore, for certain diseases, chosen on a discretionary basis, the prevalence, incidence rate, specific treatment rate, medical expenses per patient, and number of days with hospital visits or admissions can be calculated.

26The data were from a survey that followed the patient longitudinally. Therefore, it is possible to analyze sequential data (hospital visit and admission histories, and numbers of health checkups).

27It is possible to conduct epidemiological studies with the health checkup results as exposure, and information obtained from the claims as the endpoints. In this case, it will be preferable to validate some sort for the disease name in the claims.

28Deaths recorded in the ledger of insured persons can be used as an endpoint for epidemiological studies. In the case of deaths in the outcome information in claims, validation studies have shown the sensitivity, specificity, and positive predictive value in relation to hospitalized deaths in patients of aged over 65‐74 be approximately 95%. 28

29The most recent reference lists for this database of data from health insurance societies are summarized on the publication lists page on the JMDC website (https://info.jmdc.co.jp/jrda/). Please note that these lists correspond to two databases of JMDC, this database of data from health insurance societies and the other database of data from medical institutions, 1 and currently most are from this database of data from health insurance societies.

30From a clinical point of view, this database covers all claims for all members of the health insurance societies JMDC collects data and enables patient‐based tracking of visits and treatment flows even if the patient was transferred to another hospital during treatment or was completely cured, unlike the databases sourced from medical institutions. In addition, it is possible to grasp health conditions of patients to some extent, using health checkup results in this database. Examples of research using this database are described in the “Data resource use” section. Currently (the end of June 2020), there are about 250 published papers out of studies using this database, as far as we know.

31This database offers the following advantages: As the master data are accorded after standardization of all data, researchers need almost no data pretreatment for analysis.Data are available about the populations insured by health insurance societies; therefore, it is possible to ascertain the prevalence and incidence rates for different genders and age‐groups.In the case of people insured by the same health insurance society (but not in other cases), all claims are handled in a centralized manner. Therefore, when the same individual is treated by more than one medical institution, the information about him/her can be determined comprehensively.In addition to information about claims, health checkup data are available.

32As the master data are accorded after standardization of all data, researchers need almost no data pretreatment for analysis.

33Data are available about the populations insured by health insurance societies; therefore, it is possible to ascertain the prevalence and incidence rates for different genders and age‐groups.

34In the case of people insured by the same health insurance society (but not in other cases), all claims are handled in a centralized manner. Therefore, when the same individual is treated by more than one medical institution, the information about him/her can be determined comprehensively.

35In addition to information about claims, health checkup data are available.

36However, it has the following disadvantages: As the data source is health insurance societies, there are few data from people aged over 65 and none from people aged over 75.If a member of health insurance society withdraws, the data are discontinued.As the claim data are for the purpose of medical expense invoicing, the disease names used are those used for insurance purposes; so, if the disease has to be defined, a contrivance of some sort is required.No clinical laboratory test values are included, so the ability to determine the disease severity and clinical presentation is limited.No data are available for treatment outcome, such as the status at discharge.

37As the data source is health insurance societies, there are few data from people aged over 65 and none from people aged over 75.

38If a member of health insurance society withdraws, the data are discontinued.

39As the claim data are for the purpose of medical expense invoicing, the disease names used are those used for insurance purposes; so, if the disease has to be defined, a contrivance of some sort is required.

40No clinical laboratory test values are included, so the ability to determine the disease severity and clinical presentation is limited.

41No data are available for treatment outcome, such as the status at discharge.

42In order to quantify the above characteristics, comparisons were made with publicly available data. The data used for the comparison were the numbers of claims in the June 2017 and June 2018 reviews in the MHLW's Statistics of Medical Care Activities in Public Health Insurance, which were aggregates of the National Database of Health Insurance Claims and Specific Health Checkups (NDB). The JMDC numbers of claims to be compared with them were obtained by scaling up the numbers of claims for treatment during May 2017 and May 2018 in this database of the data from health insurance societies by the relative numbers of persons of each gender and age‐group in the total population of Japan and in the insured person population of this database at the beginning of October 2017 and October 2018. In this context, the publicly available data for the total population of Japan were taken to be the total populations of each gender and age‐group, as of October 1 each year, shown in Table 1 (Population classified by age [each year] and gender, and population gender ratios, in total population and population of Japanese people) in the Population Estimates of the Ministry of Internal Affairs and Communications. The results for each gender and age‐group are shown in Figures 2, 3, 4, in which the disposition of males in the JMDC numbers is also shown. The ratios used for scaling up are shown in Figure 5.

43Comparisons were also made for chapters of ICD‐10 representing large categories of injuries/diseases in a similar manner. If two or more injuries/diseases are included in a single claim, the handling mode in the Statistics of Medical Care Activities in Public Health Insurance is unknown, and the following counting method is therefore used, as it is expected that this will limit the bias to the JMDC numbers. In this method, in the case of claims that have one or more principal injuries/diseases, the value counted is obtained by sharing 1 equally between all the principal injuries/diseases, whereas in the case of claims with no principal injuries/diseases, the value counted is obtained by sharing 1 equally between all the injuries/diseases. The comparison results for each chapter of ICD‐10 are shown in Figures 6, 7, 8.

44In addition, taking the health insurance societies as the data source, JMDC data and publicly available data of health insurance societies were compared. Figure 9 shows the results of comparison between the age‐group composition ratios of this database and the numbers in the column of health‐insurance‐society insurance in Table 1 (Age‐group composition of total population and persons with health insurance) of the MHLW's Fact‐Finding Study of Persons with Health Insurance and Seamen's Insurance at the beginning of October 2017 and October 2018. Figure 10 shows the results of comparison between (a) the number of health‐insurance‐society insurance claims in the June 2017 and June 2018 assessment in the Statistics of Medical Care Activities in Public Health Insurance and (b) the number of medical treatment claims for May 2017 and May 2018 in this database, with both these numbers scaled up by the relative numbers of people of each gender and age‐group in the population insured by health insurance societies and the insured person population of this database as of the beginning of October 2017 and October 2018. The publicly available data for persons insured by health insurance societies were calculated by multiplying the total of insured persons and dependents (at October 1, 2017 and October 1, 2018) in Table 1 of Health‐insurance‐society Insurance Section (Insured by age and gender, number of insured persons, dependent gender, number of dependents, dependent rate, average standard monthly remuneration, average standard bonus and average total remuneration) in the MHLW's Fact‐Finding Study of Persons with Health Insurance and Seamen's Insurance, by health‐insurance‐society insurance (at October 1, 2017 and October 1, 2018), shown in Table 1 of Summary of Survey Results Section (Age‐group composition of total population and persons with health insurance) of the MHLW's Fact‐Finding Study of Persons with Health Insurance and Seamen's Insurance. The ratios used for scaling up are shown in Figure 11.

45JMDC makes its database of data from health insurance societies widely available, on a fee‐paying basis, for use of surveys, research, and commercial purposes like the databases sourced from medical institutions JMDC created. 1 Inquiries about this database can be made via JMDC's website (https://www.jmdc.co.jp/en/bigdata), and it can be accessed after completing the contract for use of specific data.

46JMDC has created a database from data on medical expenses, etc., collected from health insurance societies.The earliest data that can be accessed are for January 2005. The number of persons whose data can be accessed for each month tends to increase from the initiation. Currently (the end of June 2020), the number of persons included in the database of data from health insurance societies, including those withdrawn at some point, is approximately 9.8 million.In principle, all data collected from health insurance societies are included in the databases. Non‐standardized data are standardized using a dictionary, and the database permits data to be followed in a time‐series on the basis of anonymized personal IDs.The database of data from health insurance societies includes information about insured persons, medical institutions, claims, and health checkup results.JMDC makes this database widely available, on a fee‐paying basis, for use for surveys, research, and commercial purposes. Inquiries about this database can be made via JMDC's website (https://www.jmdc.co.jp/en/bigdata), and they can be accessed after completing the contract for use of specific data.

47JMDC has created a database from data on medical expenses, etc., collected from health insurance societies.

48The earliest data that can be accessed are for January 2005. The number of persons whose data can be accessed for each month tends to increase from the initiation. Currently (the end of June 2020), the number of persons included in the database of data from health insurance societies, including those withdrawn at some point, is approximately 9.8 million.

49In principle, all data collected from health insurance societies are included in the databases. Non‐standardized data are standardized using a dictionary, and the database permits data to be followed in a time‐series on the basis of anonymized personal IDs.

50The database of data from health insurance societies includes information about insured persons, medical institutions, claims, and health checkup results.

51JMDC makes this database widely available, on a fee‐paying basis, for use for surveys, research, and commercial purposes. Inquiries about this database can be made via JMDC's website (https://www.jmdc.co.jp/en/bigdata), and they can be accessed after completing the contract for use of specific data.

52The database of data from health insurance societies is unique for Japan and has the following characteristics: (a) the basic population can be ascertained; (b) standardization is carried out using a dictionary; and (c) anonymized individual IDs can be followed on the basis of a time‐series over various periods, with the earliest starting date being January 2005. However, the database of data from health insurance societies, owing to the properties of the data source, has certain limitations, in that the disease status and test results cannot be ascertained, and there is insufficient access to data for elderly people. Use of this database is on a fee‐paying basis. The characteristics mean that it is provided for a wide range of purposes.

53This article was co‐authored by academic researchers and JMDC Inc. (JMDC). First four authors are affiliated with JMDC. The other authors have no connection with JMDC.

54The study about objective descriptions of the database was approved by the Ethics Committee of the Research Institute of Healthcare Data Science (RIHDS) (Date of approval, September 11, 2020; Approval number, RI2020011). Informed consent is not applied for this study because personal information is not handled in it.