|Skip to ContentRelease Date: September 20, 2012Release dates | 
Announcements | 
Coded tables | Historical data | AboutCurrent release |  Screen reader  | 
PDF (560 KB) | 
Data Download Program (DDP)
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

|Historical data | 
|--------------- | 

|The Flow of Funds Z.1 files provide the full set of historical data that correspond to the statistics in the Z.1 release. Two data frequencies are available--annual and quarterly.

(1)  Annual: For amounts outstanding, from 1945 forward; for flows, from 1946 forward.  Data can be viewed and printed for the following periods:

1945 to 1954 (312 KB PDF)

1955 to 1964 (323 KB PDF)

1965 to 1974 (347 KB PDF)

1975 to 1984 (377 KB PDF)

1985 to 1994 (397 KB PDF)

1995 to 2004 (414 KB PDF)

2005 to 2011 (370 KB PDF)

(2) Quarterly: Compressed files of data from 1952:Q1 to the most recently published quarter can be downloaded.


    The data series in the compressed ASCII files of quarterly data are organized in the same way as in the releases and in the Flow of Funds coded tables.  You can separately retrieve each of the table files, which have been grouped for convenience into five categories:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|All Flow of Funds data are available via the Board's  Data Download Program (DDP).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
|Category
Compressed file (PRN)Flows--seasonally adjusted annual rates

        (in millions of dollars)
atabs.zip (1.4 MB ZIP)Flows--unadjusted quarterly rates
        (in millions of dollars)   
utabs.zip (1.3 MB ZIP)Outstandings--unadjusted
        (in millions of dollars)   
ltabs.zip (1.4 MB ZIP)Balance sheet
        (in millions of dollars)   
btabs.zip (185 KB ZIP)Debt growth -- adjusted annual rates
        (in millions of dollars)   
gtabs.zip (30 KB ZIP)Supplementary tables
	(in millions of dollars)   
stabs.zip (865 KB ZIP)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
|
|Flows--seasonally adjusted annual rates

        (in millions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
|Flows--unadjusted quarterly rates
        (in millions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
|Outstandings--unadjusted
        (in millions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
|Balance sheet
        (in millions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
|Debt growth -- adjusted annual rates
        (in millions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
|Supplementary tables
	(in millions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
|To download any of these files via Netscape, hold down the left shift key and click on the file name.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
|-----------------------------------------------------------------------------------



                      * * * N O T E * * *



Because of their large size, many of the .prn table files contain two parts.  For 

these tables, the last row of data corresponds to the second set of series names, 

which appears part way down the spreadsheet array, not to the set on row 1. 



-----------------------------------------------------------------------------------



Each of the files in atabs.zip, utabs.zip, and ltabs.zip begins with 1952:Q1 and ends with the most recently published quarter.  The series in the supplemental tables (F.100.a and L.100.a)
are in stabs.zip and contain annual data for 1988 through 1993.  The debt growth file (gtabs.zip) contains data from 1953 forward; the data corresponds to tables D.1, D.2, and D.3 in the release.  The balance sheet file (btabs.zip) contains quarterly data for 1952 through the last complete year published.The data files were compressed with PKZIP, version 2.04; the software to expand the files is available from PKWARE's Web site.Each file name contains the number of the table in that file. For example, the data for table F.117 (seasonally adjusted flows for life insurance companies) is in the file named atab117d.prn (the "d" identifies a DOS file).Retrieving Tables from Downloaded Zip FilesTo retrieve a table, enter the command pkunzip followed by (1) the name of the ".zip" file containing the compressed table and (2) the name of the table or tables desired.For example:To retrieve the seasonally adjusted annual flows of table F.117, enter the following command (assuming the .zip file is on your C drive): `C:>pkunzip atabs.zip atab117d.prn`To retrieve the unadjusted quarterly flows of tables F.100 and F.105, enter the following command: `C:>pkunzip utabs.zip utab100d.prn utab105d.prn`To retrieve all the levels tables, enter the following command: `C:>pkunzip ltabs.zip`



Expanded files contain a column of dates to identify a time period (in quotes).  The series code (in quotes) is at the top of each column of data. In some of the longer tables, a second set of data columns is continued under the first set.

Flow of Funds codes have the following elements:a two-letter code (FA, FU, or FL), which identifies whether the series is a seasonally adjusted flow, an unadjusted flow, or a levela nine-digit code, which represents sector; type of
transaction; and type of adjustment, data source, or calculationa one-letter code, which indicates the frequency (.q or .a).

For example, the code FA313161105.q identifies the quarterly seasonally adjusted flow (at an annual rate) for federal government Treasury issues, which is calculated from other series in the flow of funds accounts. The unadjusted flow for the same series is FU313161105.q, and the corresponding levels series--Treasury debt, in this case--is FL313161105.q.

Instructions for Reading Data into Microsoft Excel or LotusMicrosoft ExcelClick on the "File" pulldown menu

        Select "Open"Use the resulting dialog box to find drive and file name (use "All Files" option in the window for "List of File Types")Click "OK"In the resulting dialog box "Text Import Wizard: Step 1 of 3"

        Original data type: Select "Delimited"Click "Next"In the resulting dialog box "Text Import Wizard: Step 2 of 3"

        Delimiter: Select "Space" (and de-select any other delimiter previously selected)Treat conservative delimiters as one: De-selectText qualifier: Select " (the double-quote character)Click "NEXT"In the resulting dialog box "Text Import Wizard: Step 3 of 3," click "FINISH"

Lotus 1-2-3With a new spreadsheet displayed, type/ (the slash character)the letter f (for File menu)the letter i (for Import menu)the letter n (for Numbers)At "Enter name of file to import," press the "escape" key to erase the existing entryType the drive and file name desired.Release dates | 
Announcements | 
Coded tables | 
Historical data | AboutCurrent release | Screen reader | 
PDF (560 KB) | 
Data Download Program (DDP)

Statistical releasesHome |
Economic research and dataAccessibility  | 
Contact Us
Last update: September 20, 2012