Institution Download

 

It is recommended that you print this page before downloading!

Download current FDIC-Insured Institutions

Variable Names and Definitions

Download Procedures

You are about to download a self extracting executable (EXE) file - - do not be confused by the .zip file extension. If your system/browser is set up correctly you will be prompted to save the file on your hard drive. The default file name will be "Institutions2.zip". If your computer does not have an extracting program such as Winzip, you will need to add the .EXE extension. After the .exe file is saved, go to the folder where it was saved and select Institutions2.exe and the extract procedure will begin. (If your computer does have an extracting program such as Winzip, you do not need to change the extention.)

The extract will generate two (2) files:
1.   Institutions2.csv - complete Institution file, excluding variable definitions
2.   Institutions2_definitions.csv - definitions for all of the variables in the above file

To use this download function, please follow the following steps.

  1. Select the download link.
  2. When prompted to save the file, change the file extension from .ZIP to .EXE
  3. Select the folder where you would like the file to be saved (write it down, e.g. c:\downloads\)
  4. After the resultant executable file is saved, run the file to unzip two(2) "comma separated variable, CSV" files in the directory of your choice. The file named Institutions2.csv contains the data on all institutions. The file Institutions2_definitions.csv contains definitions for the field names in the Institution file.
 
Variable Names and Definitions
This information should be used to port the downloaded information into a database.
            
     FIELD Type Size # of Decimal Place
     ACTIVE Number 8 0
     ADDRESS Text 120 0
     ASSET Number 8 0
     BKCLASS Text 2 0
     CERT Number 19 0
     DOCKET Number 19 0
     CHRTAGNT Text 5 0
     CITY Text 30 0
     CITYHCR Text 25 0
     CLCODE Number 19 0
     COUNTY Text 30 0
     DENOVO Number 8 0
     DEP Number 8 0
     ENDEFYMD Date/Time 16 0
     EQ Number 8 0
     ESTYMD Date/Time 16 0
     FDICDBS Number 4 0
     FED Number 4 0
     FEDCHRTR Number 8 0
     FED_RSSD Number 19 0
     FLDOFF Text 30 0
     IBA Number 8 0
     INACTIVE Number 8 0
     INSAGNT1 Text 5 0
     INSAGNT2 Text 5 0
     INSCOML Number 8 0
     INSFDIC Number 8 0
     INSSAVE Number 8 0
     INSTCRCD Number 8 0
     CBSA_METRO_NAME Text 120 0
     NAME Text 120 0
     NAMEHCR Text 95 0
     NETINC Number 8 0
     NETINCQ Number 8 0
     NEWCERT Number 19 0
     OCCDIST Number 4 0
     OFFDOM Number 8 0
     OFFFOR Number 8 0
     QBPRCOML Number 8 0
     REGAGNT Text 5 0
     REPDTE Date/Time 16 0
     RISDATE Date/Time 16 0
     ROA Number 8 0
     ROAQ Number 8 0
     ROE Number 8 0
     ROEQ Number 8 0
     RSSDHCR Number 8 0
     STALP Text 2 0
     STALPHCR Text 2 0
     STCNTY Number 8 0
     ZIP Number 8 0
     WEBADDR Text 72 0
     ACTIVE Number 8 0
    Questions, Suggestions & Requests

Home    Contact Us    Search    Help    SiteMap    Forms
Freedom of Information Act (FOIA) Service Center    Website Policies    USA.gov
FDIC Office of Inspector General