Skip to main content
Diabetology international logoLink to Diabetology international
. 2026 Apr 22;17(3):40. doi: 10.1007/s13340-026-00899-1

Trends in sodium–glucose transport protein 2 inhibitor prescriptions: application of the ATC/DDD system to NDB open data

Takefumi Miyake 1,2,3,✉, Mai Hashimoto 4, Daisuke Kadowaki 4
PMCID: PMC13103113  PMID: 42040052

Abstract

Background

Understanding regional patterns of pharmaceutical use is essential for effective resource allocation and promoting rational drug use. The NDB Open Data of the Ministry of Health, Labor and Welfare offers a high-quality national database that comprehensively captures usage patterns. However, direct comparisons based on prescription volume are challenging owing to differences in drug formulations and dosages, and increasing generic drug use.

Objective

This study examined sodium–glucose transport protein 2 inhibitor (SGLT2i) usage patterns across Japanese prefectures by comparing prescription quantities and drug costs using the NDB Open Data.

Methods

Using the NDB Open Data, we extracted single-component SGLT2i formulations (pharmacological classification 396) and calculated the Defined Daily Dose (DDD) per 1000 inhabitants per day (DID) using WHO Anatomical Therapeutic Chemical (ATC) codes.

Results

During the fiscal year 2022, urban prefectures, including Tokyo, Kanagawa, Osaka, Aichi, and Saitama, recorded the highest SGLT2i prescription quantities. Conversely, DID values were notably higher in rural areas such as Fukushima, Tochigi, Kagawa, Oita, and Iwate, indicating notable regional differences that could not be explained solely by population size. Annual prescriptions consistently increased across all drugs, reflecting the impact of expanded indications and product discontinuation. Canagliflozin demonstrated relatively low domestic usage in DID despite a similar number of tablets prescribed compared to other drugs, suggesting distinct regional prescription patterns.

Conclusion

Combining the NDB Open Data with the ATC/DDD system identified regional SGLT2i usage. This approach could enable standardized comparisons within drug classes, providing invaluable evidence to support appropriate drug use guidelines and informed policy formulations.

Keywords: Sodium–glucose co-transporter-2 inhibitors, NDB open data Japan, ATC/DDD system, Prescription trend, DDD per 1000 inhabitants per day

Introduction

Based on the “Act on Assurance of Medical Care for Elderly People,” the Ministry of Health, Labour and Welfare (MHLW) began building the “National Database of Health Insurance Claims and Specific Health Checkups of Japan (NDB)” in 2009. There are two types of NDB: NDB data that warrants payment and strict management, and open data that is available to the general public (NDB Open Data) [1]. Since October 2016, NDB Open Data has been provided annually with basic tabulations, and includes information regarding health insurance claim data (receipts) since fiscal year (FY) 2014 and information related to specific health checkups since FY2013 [2]. In this database, drug data are broadly classified by three dosage forms: oral, topical, and injection, and divided into prescription categories: outpatient (out-of-hospital and in-hospital) and inpatient (Fig. 1). The ranking of drugs with the highest prescription volume (e.g., tablet count) is published based on the standard unit of National Health Insurance (NHI) drug price standard listing for each drug category. In the first session, information on the top 30 drugs by annual drug prescription volume was released, and in the second through the eighth sessions, this was expanded to the top 100 drugs. The 9th edition published the top 100, 300, and 500 drugs by prescription volume for each drug category. The NDB Open Data provide information such as product name, unit (e.g., mg, mL, and tablet), drug price, and total (prescription volume), compiled by prefecture, sex, and age (every 5 years) according to the drug category. NDB and NDB Open Data have been extensively utilized [3–5]. Accordingly, these databases serve as invaluable sources of high-quality evidence on actual drug use on a national scale, with applications in medical information and pharmaceutical sciences. On the other hand, conventional methods for evaluating drug use predominantly rely on drug costs and the number of tablets prescribed, referred to as “prescription volume.” However, multiple product names for a single ingredient—including different specifications, formulations, and generics—complicate direct comparisons between drugs and across regions, especially when accounting for population and other factors. Therefore, as an indicator to evaluate drug use, the World Health Organization (WHO) recommends a drug code (the Anatomical Therapeutic Chemical [ATC]) comprising five levels assigned to each drug and the average daily maintenance dose (Defined Daily Dose [DDD]), published on the WHO Collaborating Centre (WHOCC) for Drug Statistics Methodology website [6]. The ATC/DDD system is widely used internationally as a standardized method for evaluating drug use [7–9]. In Japan, few studies have applied the ATC/DDD system as an evaluation criterion for statistical surveys on the use of drugs, including antidiabetic medications. We focused on sodium–glucose co-transporter-2 inhibitors (SGLT2is), which rapidly became the first-line treatment for diabetes after launch and have multiple indications, including chronic kidney disease and heart failure.

Fig. 1.

Fig. 1

Published drug data and the number of aggregated items from the NDB Open Data. This figure presents drug-related data obtained from the NDB Open Data for the fiscal year (FY) 2022. NDB, National Database of Health Insurance Claims and Specific Health Checkups of Japan

In the present study, we extracted the SGLT2i prescriptions by prefecture from the NDB Open Data for FY2015 to FY2022 and compared them in terms of the number of tablets and drug costs to identify regional differences. In addition, the ATC/DDD system was applied to analyze regional differences in SGLT2i usage across Japan, assessing the prescription volume and DDD per 1000 inhabitants per day (DID) by prefecture. This study was conducted to verify the further utilization of the data obtained by applying the ATC/DDD system.

Methods

For pharmaceutical data, we used data from the 2nd (FY2015) to the 9th (FY2022) editions of the NDB Open Data, which are published on the MHLW website and list the top 100 prescription quantities for each three-digit drug classification [2]. The minimum aggregation unit was prescription volume: items with a total of fewer than 1000 were indicated with a “-” (hyphen). If only one item with a total of fewer than 1000 was hyphenated, the item other than the total was counted as “0” (zero) to identify the facility. Excel data were obtained from the quantities of outpatient (out-of-hospital and in-hospital) and inpatient drugs by prefecture, listed in “Prescription Drugs—Internal Drugs” in this dataset. Antidiabetic drugs (drug category number 396) were extracted, and SGLT2i in this category were included in the analysis (Table 1). However, only single-drug formulations were analyzed, excluding fixed-dose combinations. Although the 9th edition listed the top 300 antidiabetic drugs (Drug Classification Number 396), the top 100 drugs were counted to match the number of drugs in the 2nd and subsequent editions. Using the ATC/DDD system figures from the WHOCC website [6], each drug was counted by specification and ingredient by year. However, because some drugs were not listed in the ATC/DDD Index 2024, the ATC code for tofogliflozin was set to A10BK10, and the DDDs for ipragliflozin, luseogliflozin, and tofogliflozin were based on the daily dosages listed in the Japanese electronic package insert. We evaluated (1) the prescription volume of each drug by standard; (2) the drug cost, calculated by multiplying the number of prescriptions by the drug price; (3) the number of SGLT2i prescriptions per day per prefecture, (g)/DDD (g) divided by the population of the prefecture; and (4) DDDs/1,000 000 persons/day, multiplied by 1000 to correct for differences between the population and number of prescriptions by the SGLT2i standard (DID) [10]. The estimated population (as of October 1, 2022) from the Statistics Bureau of the Ministry of Internal Affairs and Communications website was used [11].

Table 1.

A10BK sodium–glucose co-transporter 2 (SGLT2) inhibitors

ATC code Name DDD Units Adm.R
A10BK01 Dapagliflozin 10 mg O
A10BK02 Canagliflozin 0.2 mg O
A10BK03 Empagliflozin 17.5 mg O
A10BK04 Ertugliflozin* 10 mg O
A10BK05 Ipragliflozin 50** mg O
A10BK06 Sotagliflozin*
A10BK07 Luseogliflozin 2.5** mg O
A10BK08 Bexagliflozin*
A10BK09 Enavogliflozin*
A10BK10** Tofogliflozin** 20** mg O

Quoted from ATC/DDD Index 2024

*Not yet available in Japan,** Not listed in ATC/DDD Index 2024

ATC Anatomical Therapeutic Chemical, DDD Defined Daily Dose, Adm.R Route of administration

Results

The SGLT2i prescription volume by prefecture for FY2022 is illustrated in Fig. 2a. The average prescription volume was 17,751,046.5, with Tokyo (1st), Kanagawa (2nd), Osaka (3rd), Aichi (4th), and Saitama (5th) ranking highest, and Tottori (47th), Shimane (46th), Tokushima (45th), Kochi (44th), and Fukui (43rd) ranking lowest. Twelve prefectures exceeded this average. Drug costs, calculated using FY2022 drug prices, are shown in Fig. 2b. The average drug cost was ¥3,460,536,849.1, with 12 prefectures exceeding the average cost. The top five prefectures were Tokyo (1st), Kanagawa (2nd), Osaka (3rd), Aichi (4th), and Saitama (5th), while the bottom five were Tottori (47th), Shimane (46th), Tokushima (45th), Kochi (44th), and Fukui (43rd). Furthermore, the DID was used to adjust for differences in prescription volume due to factors such as population and drug specifications (Fig. 2c). According to the DID rankings, Fukushima ranked first, followed by Tochigi, Kagawa, Oita, and Iwate, while Okinawa (47th), Kyoto (46th), Nagasaki (45th), Tottori (44th), and Shiga (43rd) ranked the lowest. Although comparing prescription volumes across prefectures revealed differences influenced by population, this effect was offset by adjusting for DID. Next, we analyzed the prescription volume according to drug specifications and year. Excluding Apleway®, which was withdrawn from the market, prescription volumes increased annually for all drugs. However, some drugs showed significant increases in prescription volumes, allowing the identification of prescription trends related to expanded indications or market withdrawals (Fig. 3a). Next, we calculated annual trends using DID (Fig. 3b). A comparison of prescription quantities by the number of tablets showed that canagliflozin had similar prescription quantities to ipragliflozin, tofogliflozin, and luseogliflozin. However, when compared using DID, canagliflozin tended to be prescribed less than other SGLT2i in Japan.

Fig. 2.

Fig. 2

Prefecture-specific prescription volume of SGLT2 inhibitors in FY2022. The prescription volume of SGLT2 inhibitors in each prefecture for FY2022 was analyzed using a the number of tablets, b the number of tablets multiplied by drug price, and c DID. FY, fiscal year; SGLT2, sodium–glucose transport protein 2

Fig. 3.

Fig. 3

Annual trends in the prescription volume of SGLT2 inhibitors. The prescription volume of SGLT2 inhibitors from fiscal year (FY) 2015 to FY2022 was analyzed based on a the number of tablets per product specification and b the DID for each active ingredient. DID, Defined Daily Dose per 1000 inhabitants per day; SGLT2i, sodium glucose co-transporter 2 inhibitor

Discussion

In the present study, we identified regional differences in the use of SGLT2i across Japan. High prescription volumes were observed in urban areas, such as Tokyo, Kanagawa, and Osaka, suggesting that population size and the availability of medical resources may be contributing factors. However, when evaluated using DID, notable prescription levels were also seen in regional cities such as Fukushima, Kagawa, and Tochigi, suggesting that medical care may be tailored to regional characteristics and patient needs. Standard measures are required to evaluate the appropriate and rational use of pharmaceuticals [12]. Traditionally, these measures have been based on the quantity of drugs prescribed (e.g., number of tablets and grams) or drug costs, depending on the drug price. General names of pharmaceuticals (Japanese Accepted Names) may have multiple brand names or specifications, owing to generic or co-marketed drugs. Additionally, when comparing drugs with the same therapeutic effect, the daily dosage and administration vary by drug, making it difficult to evaluate them appropriately by simply summing the prescribed quantities (e.g., number of tablets or grams).

In 2016, Japan formulated an “Action Plan for Antimicrobial Resistance (AMR) Countermeasures” to promote appropriate antimicrobial use by comparing trends in drug-resistant bacteria and the use of antimicrobial agents with those in other countries that have different background factors, such as medical expenditures and the number of hospital beds [11]. The dosage and administration of antimicrobial agents vary depending on the drug, and there are multiple standards. Therefore, it is not possible to compare the use of different types of antimicrobial agents by simply adding the total number of units or potencies [12]. To resolve these issues, DID—a drug use index—was calculated using the WHO ATC/DDD system [6]. For example, the amount of antimicrobial drugs used in Japan in 2013 (15.8 DID) was higher than in 2009 (14.7 DID), and the amount of both oral and injectable drugs used increased progressively. However, no significant differences were observed compared with the European Union (21.6 DID, 2014), South Korea (21.7 DID, 2012), or the United States (24.9 DID, 2014) [12]. As the ATC/DDD system is used globally to monitor the use of pharmaceuticals [7–9], the results of the present study suggest that DID—used in several countries other than Japan—should be adopted as the standard to evaluate the appropriate use of pharmaceuticals in the future, rather than relying on the number of prescriptions.

Because trends in drug costs resemble those in the number of prescriptions, either monetary values or prescription counts can be used as standards, depending on the objective (Fig. 2a, b). Drug costs are often used as standards because they provide valuable information to those involved in the development, production, distribution, and sales of pharmaceuticals. However, in Japan, drug prices are reduced every two years. This makes simple international comparisons difficult, as drug prices differ depending on the country or region [12–14].

Trends, such as the introduction of new specifications and discontinuation of drugs, can be identified from the prescription quantities for each drug specification and year (Fig. 3a). Furthermore, when considering the annual trends by DID, we found that canagliflozin tended to be prescribed less than other SGLT2is (Fig. 3b). Inoue et al. revealed that the increase in the annual prescription volume of all SGLT2is, excluding luseogliflozin, was greater in areas with a high number of cardiologists. The authors also found that the number of areas with cardiologists was positively associated with an increase in the prescription volume of SGLT2is [13–15]. Accordingly, in addition to drug characteristics, regional characteristics—such as the number of specialists for specific diseases—may also affect the choice of prescribing canagliflozin. Additionally, the lower DID of Canagliflozin compared to other SGLT2 inhibitors in this study may be influenced by its combination products with DPP-4 inhibitors (Canalia®). In Japan, combination therapy with DPP-4 inhibitors is common, and the use of fixed-dose combinations is known to be high. Indeed, analysis of NDB open data (FY2022) showed that the prescription volume ratio of Empagliflozin (Jardiance®) to TradianceAP® was approximately 3: 1, and Ipragliflozin (Suglat®) and Sujanu® was approximately 1.5:1. In contrast, the ratio of Canagliflozin (Canaglu®) and Canalia® was approximately 1.1:1, indicating a relatively higher proportion of combination products (data not shown). Therefore, the low DID for Canagliflozin monotherapy likely reflects a clinical trend toward increased switching to combination drugs rather than necessarily indicating low actual usage frequency.

As mentioned above, although there are no regional differences in Japan, the NHI drug price is revised every two years; therefore, the level of drug costs and the NHI drug price itself may change annually, potentially impacting the results of long-term studies. The term “prescription volume” refers to the amount of medicine, such as the number of tablets or grams, or the number of times the medicine is used. However, this measure is not always appropriate because results can vary depending on the potency (in the case of drug weight) or the amount of ingredients per tablet (in the case of tablet number). Given that DID is applied on a regional and national basis, it is useful for comparisons within a region or country. Unlike the number of drugs, DID does not account for differences in drug form; therefore, it is less susceptible to factors such as changes in the Japanese population and is valuable for observing trends over time [6].

The analysis combining the NDB open data used in this study with the ATC/DDD method demonstrates one approach for understanding drug usage trends on a national scale. However, with the increasing prevalence of generic drugs and combination drugs, careful interpretation considering DDD settings and drug classification will be required in the future.

Limitations

Several factors should be considered when interpreting prescribing volumes and regional differences for SGLT2 inhibitors. The NDB Open Data is not linked to patient information; therefore, it is not possible to conduct individualized or segmented analysis. Drug utilization is influenced by multifactorial elements, including not only differences in therapeutic classes but also time to market, accumulation of evidence, expanded indications, drug pricing, prescribers' experience, and the pharmacological properties of each drug [16]. These factors may have contributed to differences in prescribing volumes and DID.

Furthermore, when evaluating DID differences by prefecture, the impact of regional population composition (gender and age groups) must be considered. SGLT2 inhibitors have been reported to be prescribed more frequently in males and relatively younger age groups [17], suggesting that differences in regional gender and age distributions may contribute to regional DID variations. Indeed, analysis of the 2022 NDB data showed that prescription volume peaked for both men and women in the 70–74 age group. However, while prescriptions exceeded 85 million for men, they remained at 50 million for women. Overall, prescriptions for those under 65 accounted for 43% of the total, while prescriptions for those aged 65 and over accounted for 57%, indicating a higher prescription rate among the elderly (data not shown). Because the NDB open data used in this study aggregates prescription volume by drug separately for age/gender and prefecture, it was difficult to conduct an analysis adjusting prefecture-level DID for age and gender. The results of this study should be interpreted as descriptive epidemiological analysis without age and gender adjustment. Future analyses should combine detailed NDB open data with other epidemiological datasets to perform adjustments for diabetes prevalence and population composition.

Although an NDB database containing more detailed information is available, strict data management requirements and the associated charge are limiting factors that will be considered in future investigations. However, as demonstrated in this study, valuable insights into the situation in each prefecture can be obtained from the NDB public data. In addition, to resolve regional disparities in medical care, information must be shared between prefectures and between facilities. Therefore, the model used in the previous survey on antimicrobial use could be applied to the treatment of various diseases, including diabetes.

Conclusion

The findings of this study suggest that the ATC/DDD system is useful for evaluating SGLT2i in Japan, including regional differences and annual trends. In future studies, we plan to comprehensively analyze the factors impacting regional differences and drug selection, evaluate diabetes drugs using the ATC/DDD system, and verify how to provide optimal medical care in each region.

Author contributions

All authors contributed to the study conception and design. Material preparation and data collection were performed by Takefumi Miyake. Data analysis was performed by Takefumi Miyake and Mai Hashimoto. The first draft of the manuscript was written by Daisuke Kadowaki, and all authors commented on previous versions of the manuscript. All the authors have read and approved the final manuscript.

Data availability

The data generated and analyzed during the current study are available from the corresponding author upon reasonable request.

Declarations

Conflict of interest

The authors declare that they have no conflict of interest.

Human and animal rights

This article does not contain any studies with human or animal subjects performed by any of the authors.

Footnotes

Publisher's Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

References

  • 1.Ministry of Health, Labor and Welfare, Insurance Bureau. Guidelines for the Use of the National Database of Health Insurance Claims and Specific Health Checkups of Japan (NDB). 2nd ed. [Internet]. Accessed 12 Jul 2025. https://www.mhlw.go.jp/content/12400000/001158704.pdf
  • 2.Ministry of Health, Labor and Welfare, Open Data NDB [Internet]. Accessed 12 Jul 2025. https://www.mhlw.go.jp/stf/seisakunitsuite/bunya/0000177182.html
  • 3.Kurosaki H, Yoshimura K. Medical expenses for diabetes care in Japan: analysis of inter-prefecture differences. Nihon Koshu Eisei Zasshi. 2020;67:501–8. 10.11236/jph.67.8_501. [DOI] [PubMed] [Google Scholar]
  • 4.Kato G. History of the secondary use of national database of health insurance claims and specific health checkups of Japan NDB. Trans Jpn Soc Med Biol Eng. 2017;55:143–215. [Google Scholar]
  • 5.Imai S. An introduction to real-world data and tips for analysing it. Yakugaku Zasshi. 2021;141:169–74. 10.1248/yakushi.20-00196-2. [DOI] [PubMed] [Google Scholar]
  • 6.WHO Collaborating Centre for Drug Statistics Methodology. Guidelines for ATC classification and DDD assignment; 2024 [Internet]. 2023. Accessed 12 Jul 2025. https://atcddd.fhi.no/filearchive/publications/2024_guidelines__final_web.pdf
  • 7.Bang C, Mortensen MB, Lauridsen KG, Bruun JM. Trends in antidiabetic drug utilization and expenditure in Denmark: a 22-year nationwide study. Diabetes Obes Metab. 2020;22:167–72. 10.1111/dom.13877. [DOI] [PubMed] [Google Scholar]
  • 8.Yousefi N, Hemmati F, Jaddi ZS, Salamzadeh J. A ten-year study of anti-diabetic drugs utilization in Iran. J Diabetes Metab Disord. 2022;21:361–7. 10.1007/s40200-022-00983-8. [DOI] [PMC free article] [PubMed] [Google Scholar]
  • 9.Cao W, Feng H, Yang Y, Wang L, Wang X, Ma Y, et al. Trends in antidiabetic drug use and expenditure in public hospitals in Northwest China, 2012–21: a case study of Gansu Province. BMC Health Serv Res. 2024;24:415. 10.1186/s12913-024-10917-0. [DOI] [PMC free article] [PubMed] [Google Scholar]
  • 10.Implementation and maintenance of the ATC/DDD methodology [Internet]. Accessed 12 Jul 2025. https://atcddd.fhi.no/use_of_atc_ddd/
  • 11.Statistics Bureau of Japan. Current population estimates as of October 1, 2021; 2021. Accessed 12 Jul 2025; https://www.stat.go.jp/english/data/jinsui/2021np/index.html
  • 12.Ohmagari N. National action plan on antimicrobial resistance (AMR) 2016–2020 and relevant activities in Japan. Glob Health Med. 2019;1:71–7. 10.35772/ghm.2019.01017. [DOI] [PMC free article] [PubMed] [Google Scholar]
  • 13.AMR Clinical Reference Center, National Center for Global Health and Medicine Hospital. Manual for tabulation of antimicrobial drug usage. ver. 1.1 [Internet]; 2018. Accessed 2025 Jul 12. https://amr.jihs.go.jp/pdf/koukin_manual.pdf
  • 14.Tsutani K, Igarashi A, Morikawa K. What is ATC/DDD? Jpn J Pharmacoepidemiol/Yakuzai ekigaku. 2004;9:53–8. 10.3820/jjpe1996.9.53. [Google Scholar]
  • 15.Inoue D, Nishi H, Inoue R, Nangaku M. Regional distribution of cardiologists and prescription patterns of sodium-glucose transporter-2 inhibitors in Japan. Int Heart J. 2021;62:592–600. 10.1536/ihj.20-716. [DOI] [PubMed] [Google Scholar]
  • 16.Medlinskiene K, Tomlinson J, Marques I, Richardson S, Stirling K, Petty D. Barriers and facilitators to the uptake of new medicines into clinical practice: a systematic review. BMC Health Serv Res. 2021;21:1198. 10.1186/s12913-021-07196-4. [DOI] [PMC free article] [PubMed] [Google Scholar]
  • 17.McCoy RG, Dykhoff HJ, Sangaralingham L, et al. Adoption of new glucose-lowering medications in the U.S.—the case of SGLT2 inhibitors: nationwide cohort study. Diabetes Technol Ther. 2019;21(12):702–12. 10.1089/dia.2019.0213. [DOI] [PMC free article] [PubMed] [Google Scholar]

Associated Data

This section collects any data citations, data availability statements, or supplementary materials included in this article.

Data Availability Statement

The data generated and analyzed during the current study are available from the corresponding author upon reasonable request.


Articles from Diabetology international are provided here courtesy of Springer

RESOURCES