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

FDIC-Insured Financial Institutions--Number, Assets and Liabilities: 1990 to 2006 (Statistical Abstract 2008 Table 1147)

Photo of a Monkey

Size: 7.4 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
U.S. Federal Deposit Insurance Corporation,

U.S. Federal Deposit Insurance Corporation,

The FDIC Quarterly Banking Profile, Annual Report, and

Statistics on Banking, annual; and FDIC Quarterly Banking Profile Graph Book.

referenced on dataset section Data (#1)

U.S. Federal Deposit Insurance Corporation, http://www.fdic.gov/bank/index.html

U.S. Federal Deposit Insurance Corporation,

The FDIC Quarterly Banking Profile, Annual Report, and

Statistics on Banking, annual; and FDIC Quarterly Banking Profile Graph Book.

For more information:

http://www.fdic.gov/bank/index.html

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. Includes insured branches of foreign banks that file a Call Report.
  2. For one – to four-family residential properties.
  3. Excludes foreign office deposits which are uninsured.

Headnotes

[In billions of dollars, except as indicated (4,649 represents $4,649,000,000,000).
As of December 31. Includes island areas.
Except as noted, includes foreign branches of U.S. banks.
Information is obtained primarily from the Federal Financial Institutions Examination
Council (FFIEC) Call Reports and the Office of Thrift Supervisions Thrift Financial Reports]

Shape

table: [55, 19]

Snippet

All banking offices Number 84240 83229 80698 80185 80865 81179 82433 83718 84705 86202 86165 86749 87594 88687 91024 92877 94669
Number of main offices Number 15191 14516 13891 13261 12641 12002 11480 10946 10484 10240 9920 9630 9369 9194 8988 8845 8683
Number of branches Number 69049 68713 66807 66924 68224 69177 70953 72772 74221 75962 76245 77119 78225 79493 82036 84032 85986
Commercial bank offices, total 1 Number 62630 63645 62885 63247 64776 65717 66645 68886 70154 71655 72045 72587 73648 74799 77264 79657 82067
Number of main offices Number 12376 11955 11501 10999 10489 9972 9554 9166 8794 8598 8331 8096 7903 7783 7643 7538 7404
Number of branches Number 50254 51690 51384 52248 54287 55745 57091 59720 61360 63057 63714 64491 65745 67016 69621 72119 74663
Savings institutions offices, total Number 21610 19584 17813 16938 16089 15462 15788 14832 14551 14547 14120 14162 13946 13888 13760 13220 12602
Number of main offices Number 2815 2561 2390 2262 2152 2030 1926 1780 1690 1642 1589 1534 1466 1411 1345 1307 1279
Number of branches Number 18795 17023 15423 14676 13937 13432 13862 13052 12861 12905 12531 12628 12480 12477 12415 11913 11323
19=. … snip
The FDIC Quarterly Banking Profile, Annual Report, and
Statistics on Banking, annual; and FDIC Quarterly Banking Profile Graph Book.

Tablenum

1147

Year

2008

History

Uploaded by (admin) Modified by (admin)