The Statistical Abstract files are distributed by the US Census Department as Microsoft Excel files. These files have data mixed with notes and references, multiple tables per sheet, and, worst of all, the table headers are not easily matched to their rows and columns.

A few files had extraneous characters in the title. These were corrected to be consistent. A few files have a sheet of crufty gibberish in the first slot. The sheet order was shuffled but no data were changed.

The tables that were changed (this is table 1365):

0166 0257 0362 0429 0445 0446 0459 0461 0462 0464 0465 0466 0467
0469 0479 0480 0481 0482 0483 0484 0485 0486 0487 0559 0628 0629
1144 1227 1231

This dataset consists of a table of 213 rows and 39 columns.

In millions of dollars (349 represents 349,000,000). Total external debt is debt owed to nonresidents repayable in foreign currency, goods, or services. Total external debt is the sum of public, publicly guaranteed, and private nonguaranteed long-term debt, use of IMF credit, and short-term debt. Short-term debt includes all debt having an original maturity of one year or less and interest in arrears on long-term debt

Footnotes

1. With the establishment of diplomatic relations with China on January 1,
   1979, the U.S. government recognized the People’s Republic of China as the
   sole legal government of China and acknowledged the Chinese position that
   there is only one China and that Taiwan is part of China.
2. “Congo” is the official short-form name for both the Republic of Congo
   and the Democratic Republic of the Congo. To distinguish one from the other
   the U.S. Dept. of State adds the capital in parenthese. This practice is
   unofficial and provisional.
3. External debt data presented for the Russian Federation prior to 1992 are for the
   former Soviet Union. The debt of the former Soviet Union is included in the
   Russian Federation data after 1992 on the assumption that 100 percent of all
   outstanding external debt as of December 1991 has become a liability of the
   Russian Federation. Beginning in 1993, the data for the Russian Federation has
   been revised to include obligations to members of the former Council for Mutual
   Economic Assistance and other countries in the form of trade-related credits
   amounting to $15.4 billion as of the end of 1996.
4. External debt obligations, excluding IBRD, IMF, and short-term, of Bosnia and
   Herzegovina before 1999 are included under Serbia and Montenegro.
   Data prior to 1993 refer to the former Socialist Federal Republic of Yugoslavia.
   Data from 1993 onwards are estimates and also reflect borrowing by the former
   Yugoslavia that are not yet allocated to the successor republics.
5. As of June 2006, Serbia and Montenegro are separate countries (formerly Yugoslavia).

Application Gallery