what works · what's broken · what's on the way
visualization gallery

Flow of Funds Accounts--Composition of Individuals' Savings: 1952 to 2006 (Statistical Abstract 2008 Table 0653)

Photo of a Baby Chacma Baboon

Size: 15.3 KB (approx) Downloaded: 0 times
Available in: csv, yaml, and xls Category: demographics/us

About

The Statistical Abstract of the United States is the standard summary of statistics on the social, political, and economic organization of the United States. It is also designed to serve as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statistics, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts.
This volume includes a selection of data from many statistical sources, both government and private. Publications cited as sources usually contain additional statistical detail and more comprehensive discussions of definitions and concepts. Data not available in publications issued by the contributing agency but obtained from the Internet or unpublished records are identified in the source notes. More information on the subjects covered in the tables so noted may generally be obtained from the source.

Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities. Appendix II, Metropolitan and Micropolitan Statistical Areas: Concepts, Components, and Population, presents explanatory text, a complete current listing and population data for metropolitan and micropolitan areas defined as of December 2005. Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract.

Fields

nametypeunitstags

Credits

US Census Bureau source http://www.census.gov/statab/www

U.S. Census Bureau,
Statistical Abstract of the United States: 2008 (127th Edition)
Washington, DC, 2007;
http://www.census.gov/statab/www/

Philip (flip) Kromer converted http://infochimp.org/flip
Board of Governors of the Federal Reserve System, http://www.federalreserve.gov/releases/z1/20070308/

Board of Governors of the Federal Reserve System,

Federal Reserve Statistical Release, Z.1, Flow of Funds Accounts of the United States;

published: 8 March 2007;

< http://www.federalreserve.gov/releases/z1/20070308/ >.

referenced on dataset section data (#1)

Board of Governors of the Federal Reserve System, http://www.federalreserve.gov/releases/z1/20070308/

Board of Governors of the Federal Reserve System,

Federal Reserve Statistical Release, Z.1, Flow of Funds Accounts of the United States;

published: 8 March 2007;

< http://www.federalreserve.gov/releases/z1/20070308/ >.

referenced on dataset section notes (#2)

Usage Notes

[none]

Rights Info

All US Census Bureau materials, regardless of the media, are entirely in the public domain. There are no user fees, site licenses, or any special agreements etc for the public or private use, and or reuse of any census title. As tax funded product, it’s all in the public record.
Some of our products, however, are special cases. […] The Statistical Abstract has some data covered by copyright law. Check the table’s footnotes to determine if the data are covered by copyright law.

File structure

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.
The tables that were changed: 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
  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.

Footnotes

notes (pg 2)

  1. Only directly held and those in closed-end and exchange-traded funds. Other equities are included in
    mutual funds and life insurance and pension reserves.
  2. Includes corporate farms.
  3. Line 18 less line 23.
  4. Line 42 and 43 are conceptually equivalent but measure saving using different data. Line 42 is net acquisition of financial assets (line 1) plus net investment in tangible assets net of consumer durables
    (line 27 less line 41) less net increase in liabilities (line 32). Line 43 is disposable personal income (line 45) less personal outlays (table F.100, line 4).

Headnotes

[In billions of dollars (29.8 represents $29,800,000,000). Combined statement for households, farm
business, and nonfarm noncorporate business. Minus sign (-) indicates decrease.
Personal saving on national income account basis measures personal
saving as income less taxes and consumption; flow-of-funds basis
measures the same concept from acquisition of assets less borrowing]

Shape

table: [74, 57]

Snippet

(billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars) (billion dollars)
Net acquisition of financial assets FA174090005.Q 29.802 24.716 20.831 28.251 31.608 29.191 31.632 34.0455 33.35025 35.239 39.327 44.65675 56.02925 55.52975 61.50925 69.48075 63.419 66.40225 76.8765 106.7285 133.191 146.49675 152.8015 179.1285 197.676 242.4565 283.33075 309.78325 314.0435 356.077 414.4245 474.06325 555.132 587.62975 578.18925 472.976 561.26175 445.91925 517.965 424.88425 435.006 423.334 486.15025 521.202 593.827 568.4525 789.5965 608.9025 366.4335 613.8695 632.01475 992.3155 1234.883 971.4725 743.249
Foreign deposits FA153091003.Q 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.316 -0.002 0.816 0.776 -0.131 0.912 0.765 1.41 1.028 1.173 -1.08 3.094 4.565 12.365 6.533 0.546 2.934 7.612 0.405 1.261 2.198 5.394 5.21 7.3325
Checkable deposits and currency FA173020005.Q 1.591 0.972 2.187 1.238 1.952 -0.277 3.93 1.08 1.037 -0.742 -1.075 4.471 6.288 6.726 2.36 10.469 9.547 -1.48 7.309 13.445 13.173 12.5 5.019 1.16 12.179 16.757 17.207 20.514 12.104 44.438 17.934 14.448 17.509 28.33 116.428 3.919 3.125 0.37925 -9.463 51.17825 114.809 49.534 -21.06 -43.273 -50.39 -28.917 17.4225 -43.45575 -78.63725 70.22075 0.4385 -54.04675 61.23575 5.03525 -4.46475
Time and savings deposits FA173030005.Q 7.4 8.17 9.133 8.511 9.282 11.809 13.77 10.468 11.964 18.121 25.849 25.932 25.908 27.505 18.758 34.914 30.348 9.141 42.896 66.559 73.299 63.148 55.801 78.006 102.638 106.106 103.752 76.925 121.318 70.14 119.666 202.721 229.258 132.64 96.73 127.24 169.769 81.79375 33.79675 -73.23 -97.447 -106.271 -21.916 143.381 148.33675 157.46925 134.284 168.848 352.559 276.832 338.51775 378.972 387.014 453.939 533.89875
Money market fund shares FA173034005.Q 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.379 1.317 -0.315 -0.184 5.731 30.531 24.907 90.279 33.494 -33.394 44.493 5.345 42.084 21.029 20.344 78.978 31.387 13.31 -39.064 -0.142 14.66525 101.99675 58.433 77.133 107.53225 117.44475 152.41575 162.97925 -40.892 -118.341 -47.928 63.047 159.4415
Securities FA174021705.Q 8.514 5.153 -0.501 8.006 7.185 5.985 -1.123 8.348 4.661 0.847 -1.683 -2.492 3.428 0.186 15.958 -2.505 -3.378 31.559 -3.045 -12.005 -15.717 18.62 35.823 10.4 6.631 17.532 29.34 44.674 -0.555 -26.835 56.469 72.322 78.901 56.295 69.92275 96.212 62.95625 15.15975 210.336 142.7065 185.38175 127.81625 164.77025 12.716 125.89175 -65.4855 -27.714 -58.685 -653.9005 -429.66925 23.26325 352.4255 198.1815 21.03125 -407.629
Open market paper FA163069103.Q 0.249 0.256 -0.224 0.282 0.066 0.295 0.102 -0.162 0.943 -0.362 0.805 1.203 0.977 0.871 2.25 1.841 2.033 6.366 -1.965 -2.801 -4.435 4.778 5.902 -14.682 -2.895 14.697 14.691 9.774 -3.594 -10.267 6.718 -4.938 21.86 -9.169 -0.339 -0.786 38.211 -5.676 5.777 -35.158 -5.824 12.364 4.676 2.015 4.09 1.294 3.048 4.696 12.446 -0.032 13.077 -4.49 30.24 28.14 23.4155
U.S. savings bonds FA313161400.Q 0.092 0.198 0.595 0.263 -0.094 -1.909 -0.523 -1.796 -0.265 0.803 0.523 1.181 0.911 0.635 0.554 0.97 0.647 -0.096 0.319 2.327 3.251 2.687 2.984 4.025 4.655 4.744 3.929 -0.815 -7.348 -4.338 0.156 3.139 3.03 5.262 13.555 7.771 8.453 8.16875 8.488 11.909 19.145 14.65825 7.99825 5.071 2.01325 -0.511 0.131 -0.17775 -1.696 5.576 4.543 8.929 0.59375 0.708 -2.727
57=. … snip
published: 8 March 2007;
<http://www.federalreserve.gov/releases/z1/20070308/>.

Tablenum

0653

Year

2008

History

Uploaded by (admin) Modified by (admin)