Japan recorded a Government Debt to GDP of 236.70 percent of the country's Gross Domestic Product in 2024. This dataset provides the latest reported value for - Japan Government Debt to GDP - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

I downloaded this dataset from Wikipedia. I was startled when I came across a video to realise that the United States has the highest external debt among world countries. India and Brazil lie at around 20th positions. United Kingdom's external debt is a staggering 273% of their GDP while India's is 19.20 %. Brazil's external debt is 38% of their GDP. The United States' external debt is 96.40 % of their GDP while Japan has 101 % of its GDP as its external debt.

The dataset contains the country names, their external debt, their per capita external debt, the date of entering the data and the external debt as a percentage of their GDP.

The data can be cleaned and can form an excellent use case for LLM based data analytics. The data must be cleaned. The data can be combined with other financial data of the respective countries to form a complete database of financial metrics.

U.S. Public Debt vs. GDP

Trends and Comparisons

By Charlie Hutcheson [source]

About this dataset

This dataset contains quarterly data on the US Gross Domestic Product (GDP) and Total Public Debt from 1947 through 2020. It provides a comprehensive view into the development of debt versus GDP over the years, offering insights into how our economy has grown and changed since The Great Depression. Explore this valuable information to answer questions such as: How do debt and GDP relate to one another? Has US government spending been outpacing wealth throughout history? From what sources does our national debt originate? This dataset can be utilized by economists, governments, researchers, investors, financial institutions, journalists — anyone looking to gain a better understanding of where our economy stands today compared to past decades

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset, U.S. GDP vs Debt Over Time, contains quarterly data on the Gross Domestic Product (GDP) and Total Public Debt of the United States between 1947 to 2020. This can be useful for conducting research into how the total public debt relates to economic growth in the US.

The dataset includes 4 columns: Quarter , Gross Domestic Product ($mil), Total Public Debt ($mil). The Quarter column consists of strings that represent each quarter from 1947-2020 with a corresponding number (e.g., “Q1-1947”). The Gross Domestic Product ($mil) and Total Public Debt ($mil) columns consist of numbers that indicate the respective amounts in millions for each quarter during this same time period.

By analyzing this dataset you can explore various trends over different periods as it relates to public debt versus economic growth in America and make informed decisions about how certain policies may affect future outcomes. Additionally, you could also compare these two values with other variables such as unemployment rate or inflation rate to gain deeper insights into America’s economy over time

Research Ideas

• Comparing the quarterly growth in GDP with public debt to show the correlation between economic growth and government spending.
• Creating a bar or line visualization that compares the US’s total public debt to comparable economic powers like China, Japan, and Europe over time.
• Examining how changes in government deficit have contributed towards an increase in public debt by analyzing which quarters saw significant leaps of growth from one year to the next

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

License: Dataset copyright by authors - You are free to: - Share - copy and redistribute the material in any medium or format for any purpose, even commercially. - Adapt - remix, transform, and build upon the material for any purpose, even commercially. - You must: - Give appropriate credit - Provide a link to the license, and indicate if changes were made. - ShareAlike - You must distribute your contributions under the same license as the original. - Keep intact - all notices that refer to this license, including copyright notices.

Columns

File: US GDP vs Debt.csv | Column name | Description | |:----------------------------------|:-------------------------------------------------------------------------------------------| | Quarter | The quarter of the year in which the data was collected. (String) | | Gross Domestic Product ($mil) | The total value of all goods and services produced by the US in a given quarter. (Integer) | | Total Public Debt ($mil) | The total amount owed by the federal government. (Integer) |

Acknowledgements

If you use this dataset in your research, please credit the original authors. If you use this dataset in your research, please credit Charlie Hutcheson.

International Debt Statistics (IDS), successor to Global Development Finance and World Debt Tables, is designed to respond to user demand for timely, comprehensive data on trends in external debt in low- and middle-income countries. The World Bank’s Debtor Reporting System (DRS), from which the aggregate and country tables presented in this report are drawn, was established in 1951. World Debt Tables, the first publication that included DRS external debt data, appeared in 1973 and gained increased attention during the debt crisis of the 1980s. Since then, the publication and data have undergone numerous revisions and iterations to address the challenges and demands posed by the global economic conditions.

External Debt in Japan decreased to 677007 JPY Billion in the second quarter of 2025 from 679417 JPY Billion in the first quarter of 2025. This dataset provides - Japan External Debt - actual values, historical data, forecast, chart, statistics, economic calendar and news.

Content

More details about each file are in the individual file descriptions.

Context

This is a dataset hosted by the World Bank. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore the World Bank using Kaggle and all of the data sources available through the World Bank organization page!

• Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using the World Bank's APIs and Kaggle's API.

Cover photo by NA on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Context

The World Bank is an international financial institution that provides loans to countries of the world for capital projects. The World Bank's stated goal is the reduction of poverty. Source: https://en.wikipedia.org/wiki/World_Bank

Content

This dataset contains both national and regional debt statistics captured by over 200 economic indicators. Time series data is available for those indicators from 1970 to 2015 for reporting countries.

For more information, see the World Bank website.

Fork this kernel to get started with this dataset.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:world_bank_intl_debt

https://cloud.google.com/bigquery/public-data/world-bank-international-debt

Citation: The World Bank: International Debt Statistics

Dataset Source: World Bank. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @till_indeman from Unplash.

Inspiration

What countries have the largest outstanding debt?

https://cloud.google.com/bigquery/images/outstanding-debt.png" alt="enter image description here"> https://cloud.google.com/bigquery/images/outstanding-debt.png

Japan JP: Central Government Debt: Total data was reported at 1,052,768,100.000 JPY mn in 2017. This records an increase from the previous number of 1,048,211,200.000 JPY mn for 2016. Japan JP: Central Government Debt: Total data is updated yearly, averaging 639,264,300.000 JPY mn from Mar 1991 (Median) to 2017, with 27 observations. The data reached an all-time high of 1,052,768,100.000 JPY mn in 2017 and a record low of 187,605,000.000 JPY mn in 1992. Japan JP: Central Government Debt: Total data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Japan – Table JP.World Bank: Government Revenue, Expenditure and Finance. Debt is the entire stock of direct government fixed-term contractual obligations to others outstanding on a particular date. It includes domestic and foreign liabilities such as currency and money deposits, securities other than shares, and loans. It is the gross amount of government liabilities reduced by the amount of equity and financial derivatives held by the government. Because debt is a stock rather than a flow, it is measured as of a given date, usually the last day of the fiscal year.; ; International Monetary Fund, Government Finance Statistics Yearbook and data files.; ;

The benchmark interest rate in Japan was last recorded at 0.50 percent. This dataset provides - Japan Interest Rate - actual values, historical data, forecast, chart, statistics, economic calendar and news.

Total-Long-Term-Debt Time Series for Sony Corp. Sony Group Corporation designs, develops, produces, and sells electronic equipment, instruments, and devices for the consumer, professional, and industrial markets in Japan, the United States, Europe, China, the Asia-Pacific, and internationally. The company distributes software titles and add-on content through digital networks; network services related to game, video, and music content; hardware and home gaming consoles, packaged and game software, and peripheral devices. It also develops, produces, markets, and distributes recorded music; publishes music; and produces and distributes animation titles, game applications, and various services for music and visual products. In addition, the company produces, acquires, and distributes live-action and animated motion pictures for theatrical release, as well as scripted and animated series, unscripted reality or light entertainment, daytime serials, game shows, television movies, and miniseries and other television programs; operation of television networks and direct-to-consumer streaming services; operates a visual effects and animation unit; and manages a studio facility. Further, the company researches, develops, designs, produces, markets, distributes, sells, and services televisions, and video and sound products; interchangeable lens, as well as compact digital, and consumer and professional video cameras; projectors and medical equipment; mobile phones, accessories, and applications; and metal oxide semiconductor image sensors, integration systems, and other semiconductors. Additionally, it offers internet broadband network services; recording media, and storage media products; and life and non-life insurance, banking, and other services, as well as creates and distributes content for PCs and mobile phones. The company was formerly known as Sony Corporation and changed its name to Sony Group Corporation in April 2021. Sony Group Corporation was incorporated in 1946 and is headquartered in Tokyo, Japan.

Short-Term-Debt Time Series for Hirose Electric Co Ltd. Hirose Electric Co.,Ltd. manufactures and sells connectors in Japan and internationally. The company offers multi-pin connectors, including circular and rectangular connectors; connectors for ribbon cables; connectors used for printed circuit boards comprising flexible printed circuit boards; and nylon connectors for use in a range of fields, such as smartphones, communications equipment, and automotive electronics, as well as in industrial fields, such as measuring and control equipment, FA equipment, and medical electronics equipment. It also provides coaxial connectors for microwave and other high-frequency signals; and optical fiber connectors and coaxial switches used in various applications, which include antenna connections for wireless LAN and Bluetooth communication used in smartphones and PCs, and as GPS antenna connections for automobiles, as well as for connecting high-frequency signals in wireless communication devices and electronic measuring equipment. In addition, Hirose Electric Co.,Ltd. provides micro switches and instruments for connectors. The company was formerly known as Hirose Manufacturing Co., Ltd. and changed its name to Hirose Electric Co.,Ltd. in August 1963. Hirose Electric Co.,Ltd. was founded in 1937 and is headquartered in Yokohama, Japan.

Total-Debt-To-Ebitda Time Series for World Co Ltd. World Co., Ltd., through its subsidiaries, plans, manufactures, retails, sells, and imports/exports apparel and fashion products in Japan and internationally. It offers women's, men's, and children's clothing and fashion accessories; interior products; jewelry and fashion goods; and men's and women's golf apparel products under the adabat brand. The company also offers tops, skirts, pants, one piece, jackets/outwear, suits, shoes, bags, wallets, and small items; and fashion accessories, as well as leather accessories under the HIROKO HAYASHI and HIROFU brand; engages in franchise business and business development of the TAKEO KIKUCHI men's brand in Thailand; operates PINK-latte selected brand shops targeting teenagers; and plans, manufactures, imports, and sells business and home use furniture, and life style goods. In addition, it operates lifestyle shops; and off-price stores and EC stores for clothing, household goods, etc. Further, the company engages in business investment activities; mail order business; provision of solution development and consulting services for companies in fashion-related industries; and provision of consulting services for accounting and purchasing, and visual merchandising and graphic design services; sewing and processing of women's clothing; administrative, manufacturing, sale, and import/export of apparel, fashion goods, and control and trading services. Additionally, it provides babies', and children's clothing and related products; women's intimates and shoes; bags and accessories; and shoe molds. World Co., Ltd. was founded in 1959 and is headquartered in Kobe, Japan.

Debt-To-Assets-Ratio Time Series for JCU Corp. JCU Corporation engages in the produces and sells chemicals, machines, and equipment in Japan. The company offers surface treatment chemicals for the decoration and rustproofing of automobile parts, faucet parts, construction materials, etc.; and for use in the manufacturing processes of printed circuit boards (PCBs), electronic components and semiconductors, etc. It provides full automatic plating and processing machines; etching and washing devices for PCBs; and surface treatment equipment, as well as offers photovoltaic power generation equipment. The company was formerly known as Ebara-Udylite Co., Ltd. and changed its name to JCU Corporation in October 2012. JCU Corporation was founded in 1957 and is headquartered in Tokyo, Japan.

Short-Term-Debt Time Series for Tokyu Reit Inc. TOKYU REIT, Inc. was incorporated to invest in real estate on June 20, 2003 under the Law Concerning Investment Trusts and Investment Corporations of Japan (Law No. 198 of 1952, as amended), or the Investment Trust Law. Such corporations are commonly referred to as Japanese Real Estate Investment Trusts, or J-REITs..

Total-Long-Term-Debt Time Series for Koshidaka Holdings Co Ltd. Koshidaka Holdings Co., Ltd. operates a karaoke business and a bath house business in Japan and internationally. The company has Karaoke Manekineko, a karaoke network; and One Kara, a karaoke box for people who sing alone. It has Maneki no Yu bath houses to enjoy a natural hot spring bath, as well as enjoy outstanding food, relax, or even hold a banquet or other event. In addition, the company owns, operates, and manages real estate rental buildings in Gunma and Kanagawa prefectures. Koshidaka Holdings Co., Ltd. was incorporated in 1967 and is headquartered in Tokyo, Japan.

Short-Term-Debt Time Series for Transaction Co Ltd. TRANSACTION CO.,Ltd. plans, designs, manufactures, and sells miscellaneous goods to companies and individuals in Japan and internationally. The company offers eco products that include reusable products made from organic cotton, recycled materials, biomass plastics, and natural materials, as well as upcycled finished goods; lifestyle products, including picture-style towels, acrylic products, suitcases, suitcase belts, and pet wear and related finished goods; and wellness products comprising sanitary products, such as masks. It also provides silk screen printing; on demand printing; graphic design; and web design services. The company sells its products through e-commerce and website to the end users, wholesalers, and others. TRANSACTION CO.,Ltd. was incorporated in 1987 and is headquartered in Tokyo, Japan.

Short-Term-Debt Time Series for En-Japan Inc. en Inc. provides human resources service in Japan and internationally. The company operates job information sites, including en TENSHOKU for various recruitment and career change support services; en TENSHOKU WOMAN, a career-change support services for women; AMBI, a career change site designed for young people; MIDDLE NO TENSHOKU, an online recruitment website; en HAKEN, a job-search site for temporary employment; en BAITO, a recruitment website for part-time and casual job information; and en WOMEN WORK, a recruitment site for women professionals. It also provides recruiting services, such as en AGENTS that offers professional and specialized support services; Lighthouse, a word-of-mouth site; CAREER HACK, a career information site for professionals in web and IT industries; job information sites; and Video Interview, and on demand video interview platform to easily screen candidates. In addition, the company operates en JINJI NO MIKATA, a recruitment support services for HR professionals; en COLLEGE for employee education services; engage, a website for recruitment support tool; HR OnBoard, an employee retention risk identification tool; and 3E TEST for assessing the talent pool, as well as provides evaluation and education consulting services. The company was formerly known as en-japan inc. and change its name to en Inc. in October 2025. en Inc. was incorporated in 2000 and is based in Tokyo, Japan.

Short-Term-Debt Time Series for GMO Payment Gateway Inc. GMO Payment Gateway, Inc., together with its subsidiaries, provides payment related and financial services in Japan and internationally. The company offers online payment system, such as PG multi-payment service, a payment system that allows to select payment methods, such as credit card, carrier, bank transfer, payment after delivery, and CVS payment services; Ginko Pay Base System, a smartphone app that enables payments to be made by an immediate debit from the bank account; and GMO-PG processing platform, which helps financial institutions and financial service providers in the business of payment-related services by enabling payment infrastructure building. It also provides face to face use services, including cashless platform, infrastructure of payment, and cooperation; pay payer system, such as paypay, d payment, Rakuten pay online payment, amazon pay, merpay, and AEON pay services; and business to business and buy now pay later services. In addition, the company offers payment agency services in the online and recurring billing, and face-to-face field; banking as a service; lending; remittance; and instant salary receipt services. Further, it provides marketing support services for listing ads that use Yahoo! Promotional advertising, and Google AdWords; and administrative services for Facebook Ads, Google Analytics, etc. Additionally, the company offers website analysis support, consulting, and other support services. The company was incorporated in 1995 and is headquartered in Tokyo, Japan.

Long-Term-Debt Time Series for TPR Co Ltd. TPR Co., Ltd. engages in the development and sale of engine components in Japan, Asia, North America, and internationally. The company offers powertrain parts, such as piston rings, cylinder liners, carbon scraper rings, valve seat, valve guide, sintered/steel seal ring, and shock absorber parts. It also provides industrial rubber parts, resin seal rings, home equipment, temperature control valves, infrared heater/related equipment, aluminum products; EV related products, such as driver and battery related products, as well as surface treatment products. In addition, the company offers carbon nano tube and nano porous material; exterior resin parts comprising radiator grille and millimeter wave radar covers; metal/molding parts, such as window molding/SUS molding and roof rails; electrical and electronic parts, including radiator grilles with illumination and telematics communication units; automotive related equipment and power system products; and CoRoMoCo, a communication support robot for use in nursing care facilities, that can measure heart rate and feelings when held. The company was formerly known as Teikoku Piston Ring Co., Ltd. and changed its name to TPR Co., Ltd. in October 2011. TPR Co., Ltd. was founded in 1908 and is headquartered in Tokyo, Japan.

Short-Term-Debt Time Series for Toyota Industries Corp. Toyota Industries Corporation manufactures and sells textile machinery, materials handling equipment, automobiles, and automobile parts in Japan, the United States, and internationally. It operates through the Automobile, Materials Handling, and Textile Machinery segments. The company provides internal combustion telematics, lift truck training, and end-to-end warehouse solutions, as well as electric lift trucks comprising reach trucks, pallet jacks, pallet stackers, sit-down and stand-up counterbalanced lift trucks, order pickers, and turret trucks under the TOYOTA, RAYMOND, and CESAB brands. It also offers vehicles; engines, including engines for automobiles, industrial engines, foundry parts, and turbochargers; car air-conditioning compressors comprising electric compressors, continuous variable-displacement type and fixed-displacement type compressors, aluminum die-cast products, and products for fuel cell electric vehicles; car electronics, such as DC-DC converters, DC-AC inverters, and on-board chargers; batteries; and stamping dies. In addition, the company develops, manufactures, and markets textile machinery, including weaving and spinning machineries. Toyota Industries Corporation was incorporated in 1926 and is headquartered in Kariya-shi, Japan.