Purchases and Sales by U.S. Investors of Foreign Bonds and Stocks by Selected Country: 1980 to 2006 (Statistical Abstract 2008 Table 1172)

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns.
The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

1. 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.

1. The first four files have been restructured to allow full
   comprehension of the table. If you’d like to help clean up the data
   follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

Notes (pg 2)

1. Total purchases plus total sales.
2. Includes other countries, not shown separately.
3. 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.

[In billions of dollars (3.1 represents $3,100,000,000).
Covers transactions in all types of
long-term foreign securities by foreigners as reported by
banks, brokers, and other entities in the United States
(except nonmarketable U.S. Treasury notes, foreign series; and
nonmarketable U.S. Treasury bonds and notes, foreign currency
series). Data cover new issues of securities, transactions in
outstanding issues, and redemptions of securities.
Includes transactions executed in the United States for the account
of foreigners, and transactions executed abroad for the account of
reporting institutions and their domestic customers. Data by
country show the country of location of the foreign buyers and
sellers who deal directly with reporting institutions in the United States.
The data do not necessarily indicate the country of beneficial owner or issuer.
The term “foreigner” covers all institutions and individuals domiciled
outside the United States, including U.S. citizens domiciled
abroad, and the foreign branches, subsidiaries, and other affiliates
abroad of U.S. banks and businesses; the central governments,
central banks, and other official institutions of foreign
countries; and international and regional organizations.
“Foreigner” also includes persons in the United States to the
extent that they are known by reporting institutions to be acting
on behalf of foreigners.
Minus sign (-) indicates net sales by U.S. investors or
a net inflow of capital into the United States]

table: [51, 12]

1172

2008