|Skip to ContentRelease Date: September 17, 2007Release dates | 
Announcements | 
Coded tables | Historical dataCurrent release | Screen reader | 
PDF (632 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 (391 KB PDF)


1955 to 1964 (401 KB PDF)


1965 to 1974 (425 KB PDF)


1975 to 1984 (452 KB PDF)


1985 to 1994 (472 KB PDF)


1995 to 2006 (413 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:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Category
Compressed file (PRN)Flows--seasonally adjusted annual rates


        (in millions of dollars)
atabs.zip (1.0 MB ZIP)Flows--unadjusted quarterly rates
        (in millions of dollars)   
utabs.zip (929 KB ZIP)Outstandings--unadjusted
        (in millions of dollars)   
ltabs.zip (927 KB ZIP)Balance sheet
        (in billions of dollars)   
btabs.zip (114 KB ZIP)Debt growth -- adjusted annual rates
        (in billions of dollars)   
gtabs.zip (21 KB ZIP)Supplementary tables
	(in billions of dollars)   
stabs.zip (528 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 billions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
|Debt growth -- adjusted annual rates
        (in billions of dollars)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
|Supplementary tables
	(in billions 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 dataCurrent release | Screen reader | 
PDF (632 KB) | 
Data Download Program (DDP)


Statistical releasesHome |
Economic research and dataAccessibility | 
Contact Us
Last update: September 17, 2007