US Bank & Bank Holding Company | Intrinio

US Bank & Bank Holding Company

Provided by Intrinio
Info
Pricing
Documentation
Resources
Data Explorer

Unprecedented Access to Bank Financials 

If it's an FDIC call or UBPR report, you can now access it in Excel or API format through Intrinio’s FDIC Data Feed. Analysts, bankers, and developers looking for a more affordable, flexible source of FDIC data can dive into hundreds of data points for thousands of United States banks to gain true industry insight. The unparalleled flexibility and affordability of Intrinio’s API and Excel add-in make accessing the data and displaying it, without redistribution fees, a game changing opportunity for consumers accustomed to uncompetitive pricing.

 

Reasonable Pricing & Redistribution

Access through an API and industry leading flexibility in pricing and redistribution restrictions means developers, analysts, and bankers can build models, integrations, and applications that are not possible with other firms. Instant chat support and a customizable Excel add-in give users control over how they visualize the data. Generate reports and views for end users and customers to share your firm's insight and analysis. 

Demonstrations

Flexible Access

This data is available via Excel and Web API.

Have Questions?
Choose a plan:
Professional
terms
Choose a billing cycle:
Monthly
Yearly (Save 15%)
Your Price
Questions?
Chat with Us
$
Subscribe
Need to take a test drive?
3 days, 250 API calls Free Trial
Looking for an enterprise solution?
High limits, custom terms, flexible licensing Contact Us

We are Here to Help

At Intrinio, we understand how difficult it can be to get the financial data you need, where you need it, and when you need it. Our US-based, dedicated support team is standing by to help make your project a success. Feel free to chat with us.

- or -
Data Categories

Intrinio offers a variety of ways to access this data feed. Choose your preferred access method below:

API
Excel
Sheets
CSV

API Documentation

There are two versions of our API. We recommend "v2". To learn which one may be right for you, click here.
API v1
API v2

{{ docSectionTitle }} Documentation

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio API uses HTTPS verbs and a RESTful endpoint structure, which makes it easy to request data from Intrinio. Basic Authentication is administered over HTTPS. Responses are delivered in JSON format.

If you need additional help in using the API, chat with us.

Getting Started

For a quick guide to getting started with our API, please see the Tutorial.

Authentication

Private

For private/trusted environments, use Basic Authentication over HTTPS.

You can find your API Username and API Password on your Account page. You must include these credentials with every request in order to receive access to the API.

To include the credentials in your HTTPS request, specify an Authorization header, with the value Basic (key) , replacing (key) with the Base-64 encoded string API_USERNAME:API_PASSWORD .

If your credentials are not authorized, a status code of 401 will be returned.

Public

For public/untrusted environments (such as client-side JavaScript), use our public key authentication over HTTPS.

You can create a Public Access Key on your Account page. Make sure to specify all domains from which this key may be used. Any domain not listed will be rejected by the API. For development purposes, localhost is listed as a domain by default. Make sure to delete this domain before going to production.

To include a public key in your HTTPS request, specify it as the value of an X-Authorization-Public-Key header.

If your public key is not authorized, a status code of 401 will be returned.

Response Codes

Intrinio uses normal HTTP response codes to indicate the success or failure of an API request. A response code of 200 indicates success and codes in the 4xx range indicate an error that failed given the information provided, and codes in the 5xx range indicate an error with Intrinio’s servers (these are rare).

The Intrinio API uses the following error codes:

Code Meaning
200 OK – Everything worked as expected
401 Unauthorized – Your User/Password API Keys are incorrect
403 Forbidden – You are not subscribed to the data feed requested
404 Not Found – The endpoint requested does not exist
429 Too Many Requests – You have hit a limit. See limits
500 Internal Server Error – We had a problem with our server. Try again later.
503 Service Unavailable – You have hit your throttle limit or Intrinio may be experiencing high system load.

Paging

Often there is too much information in our system to serve in a single request of reasonable size. Therefore we limit results to a certain number per request and provide you with paging information which can be used to retrieve the remaining pages of data.

In the Web API, you will notice that most requests contain paging information.

File Downloads may have paging information as well, listed in the first row.

In order to request the next page of data, append a page_number parameter to your request:

https://api.intrinio.com/companies
https://api.intrinio.com/companies?page_number=2
https://api.intrinio.com/companies?page_number=3

Limits

The Intrinio API employs several reasonable limits to ensure that stable, reliable service is provided to all users. These limits can vary based on which data feeds you are subscribed to, as well as which API call you are making. The limits are grouped as: daily calls, 10-minute calls, paging, throttling, and timeouts. If you hit an API limit, the response will contain a 429 code and an explanation of the limit.

Daily Call Limits

Most data feed subscriptions have limited daily usage. This means that you can make up to a certain number of API calls in a 24-hour period (resetting at midnight Eastern). To view the limits for a data feed subscription, go to your Account page, click on Subscriptions, click on the subscription in question, and click on Limits.

10-Minute Call Limits

Some data feed subscriptions have limited 10-minute usage. This means that you can make up to a certain number of API calls in a 10-minute period.

1-Minute Call Limits

As an alternative to Daily Call Limits, some data feeds employ a 1-minute call limit. This means that you can make up to a certain number of API calls in a 1-minute period.

Paging Limits

API endpoints that employ paging are limited by the maximum page size that you may request. This varies by endpoint:

Endpoint Maximum Page Size
/historical_data 1,000
All others 100

Throttle Limits

Users enjoying free data feed subscriptions only are limited to 100 requests-per-second.

Timeout Limits

Each request must be fulfilled within 25 seconds, otherwise it will be dropped with a 503 error. Given the flexibility of our endpoints and the complexity of potential API calls, we leave it to the users to fashion requests which can be satisfied in a reasonable time.

Usage & Limits

The following endpoints will help you to check your API access, limits, and usage:

Note: this is limited to data feeds with daily API call limits.

Endpoints

Below are all of the API endpoints available for this data feed:

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio Excel Add-In allows you to access a variety of datasets right in Excel, using simple, intuitive functions.

The Excel Add-in works on both Mac OS X and Microsoft Windows versions of Excel.

If you need additional help, chat with us.

Getting Started

For a quick guide to getting started with our Excel Add-In, please see the Tutorial.

Functions

Below are all the functions available for this data feed:

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio Google Sheets Add-On allows you to access a variety of datasets right in Google Sheets, using simple, intuitive functions.

If you need additional help, chat with us.

Getting Started

For a quick guide to getting started with our Google Sheets Add-On, please see the Tutorial.

Functions

Below are all the functions available for this data feed:

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. All of our data is available for download in the CSV (comma-separated values) format.

If you need additional help, chat with us.

Getting Started

For a quick guide to getting started with our CSV Download functionality, please see the Tutorial.

Authentication

When using the download links, your browser will prompt you for a username and password. These credentials correspond to your access keys, which can be found in your Account page.

Paging

Sometimes there is too much information in our system to put into a single file of reasonable size. Therefore we limit file downloads to 10,000 rows. In order to retrieve the rest of the rows, you will have to request the second "page" of results. The first row of each file will contain paging information: RESULT_COUNT: 6342 , PAGE_SIZE: 10000 , CURRENT_PAGE: 1, TOTAL_PAGES: 1 , API_CALL_CREDITS: 1

  • RESULT_COUNT tells you how many total rows there are in our system
  • PAGE_SIZE tells you how many records you are fetching per page
  • CURRENT_PAGE tells you which page you are currently viewing
  • TOTAL_PAGES tells you how many total pages there are
  • API_CALL_CREDITS tells you how many API calls credits your request consumed

If the TOTAL_PAGES field in your file is greater than 1 and you want to see the other pages, append a page_number parameter to the URL:

https://api.intrinio.com/indices.csv?type=economic&page_number=1
https://api.intrinio.com/indices.csv?type=economic&page_number=2
https://api.intrinio.com/indices.csv?type=economic&page_number=3

To exclude the paging information from your file, include a hide_paging parameter in the URL:

https://api.intrinio.com/indices.csv?type=economic&page_number=1&hide_paging=true

URL Formatting

URLs must be formatted correctly in order for file downloads to be processed successfully. Here are examples of correct URLs:

https://api.intrinio.com/indices.csv
https://api.intrinio.com/indices.csv?type=economic
https://api.intrinio.com/indices.csv?type=economic&query=GDP
https://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap,beta

Here are examples of incorrect URLs:

https://api.intrinio.com/indices.csv&type=economic
https://api.intrinio.com/indices.csv?type=economic?query=GDP
https://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap/beta

Here is a key to the different parts of a URL:

https://api.intrinio.com /data_point.csv ? identifier = AAPL & item = marketcap,beta
1 2 3 4 5 6 7 8 9 10

  1. Intrinio's API web address.
  2. The location of the data you are trying to access.
  3. The separator between the URL address and the URL parameters.
  4. The name of the URL parameter.
  5. The separator between the name of the URL parameter and the value of the URL parameter.
  6. The value of the URL parameter.
  7. The separator between URL parameters.
  8. The name of the URL parameter.
  9. The separator between the name of the URL parameter and the value of the URL parameter.
  10. The value of the URL parameter. Note some parameters allow multiple values - separate them with a comma.

Functions

Below are all of the CSV file downloads available for this data feed:

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag. Income statement, cash flow statement, and ratios are returned as trailing twelve months values. All other data points are returned as their most recent value, either as of the last release financial statement or the most recent reported value.

Function: =IntrinioDataPoint(identifier, item)
Function: =IntrinioDataPoint(identifier, item)

Parameters

expand collapse
Name Description Example
identifier An identifier, which can be a security ticker, SEC CIK ID, FRED Series ID, etc. AAPL
item An item, which can be a data tag or a special code. marketcap
hide_paging
Hide first row of paging information.
Options:
true
-

Output Fields

expand collapse
Name Description Example
identifier the ticker or identifier for the data point AAPL
item the requested standardized tag or series ID name

Sample Data

expand collapse

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
URL: https://api.intrinio.com/data_point?identifier=AAPL&item=marketcap

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
URL: https://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
Function: =IntrinioDataPoint("AAPL", "marketcap")

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
Function: =IntrinioDataPoint("AAPL", "marketcap")

Data Point Lookup

Not available for this access method

Data Point Multiple

Returns multiple data points matching the given parameters
URL: https://api.intrinio.com/data_point?identifier=GOOGL,AAPL&item=price_date,close_price,percent_change

Data Point Multiple

Returns multiple data points matching the given parameters
URL: https://api.intrinio.com/data_point.csv?identifier=GOOGL,AAPL&item=price_date,close_price,percent_change

Data Point Multiple

Not available for this access method

Historical Data

Returns the historical data for for a selected identifier (ticker symbol or index symbol) for a selected tag. Income statement, cash flow statement, and ratios are returned as trailing twelve months values by default, but can be changed with the type parameter. All other historical data points are returned as their value on a certain day based on filings reported as of that date.

Function: =IntrinioHistoricalData(identifier, item, sequence)

Parameters

expand collapse
Name Description Example
identifier An identifier, which can be a security ticker, SEC CIK ID, FRED Series ID, etc. AAPL
item An item, which can be a data tag or a special code. marketcap
start_date The earliest date for which to return data. 2018-04-02
end_date The latest date for which to return data. 2018-5-03
frequency
The frequency of the historical prices & valuation data.
Options:
daily
weekly
monthly
quarterly
yearly
yearly
type The type of historical data to fetch. For financial statements, the type reflects the type of financial statement. For Sector data, the type reflect the aggretation (mean, median, max, min) type of the data. FY
sequence An integer 0 or greater for calling a single historical data point from the first entry, based on sort order. 0
show_date
If true, the function will return the date value, and if false the function will return the data point value for a given query.
Options:
Yes
Yes
page_number An integer greater than or equal to 1 for specifying the page number for the return values. 4
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
identifier the ticker or identifier for the data point @MUSK_51244-TSLA:US
item the requested standardized tag or series ID comp_total_summary
date the date associated with the value of the data tag 2016-12-31
value the value of the Intrinio tag of the financial data point 45936

Sample Data

expand collapse

Historical Data Lookup

Returns the historical data for for a selected identifier for a selected tag.
URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=marketcap

Historical Data Lookup

Returns the historical data for for a selected identifier for a selected tag.
URL: https://api.intrinio.com/historical_data.csv?identifier=AAPL&item=marketcap

Historical Data Lookup

Returns the historical data for for a selected identifier for a selected tag.
Function: =IntrinioHistoricalData("AAPL", "marketcap", 0)

Historical Data Lookup

Not available for this access method

Returns a list of banks covered by Intrinio.

Parameters

expand collapse
Name Description Example
query Used to search for a ticker or bank name to return relevant banks. Morgan
ticker The stock market ticker symbol associated with the companies common stock securities. TSLA
rssd_id The bank/bank holding company RSSD ID issued by the Federal Reserve. -
page_number An integer greater than or equal to 1 for specifying the page number for the return values. -
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
rssd_id Federal Reserve ID Number, A unique number assigned by the Federal Reserve board as the entity’s unique identifier 480228
name Institution name, The legal name of the institution C1 Bank
fdic_certificate_number FDIC Certificate Number, A unique NUMBER assigned by the FDIC used to identify institutions and for the issuance of insurance certificates 34092
form31_filer FFIEC Call Report 31 Filer, A flag (true,false) that indicates whether and institution filed an FFIEC 031 Call Report. Commercial banks with domestic and foreign offices are required to file such a report. true
address Physical Street Address, Street address at which the institution or one of its branches is physically located 1111 Polaris Parkway
city City, City in which an institution’s headquarters or one of its branches is physically located. Either the entire name or part of the name of a specific city may be entered to produce an Institution List Columbus
state State Name, State in which the the institution is physically located. The FDIC Act defines state as any State of the United States, the District of Columbia, and any territory of the United States, Puerto Rico, Guam, American Samoa, the Trust Territory of the Pacific Islands, the Virgin Island, and the Northern Mariana Islands Ohio
zip_code Zip Code,The first three, four, or five digits of the full postal zip code representing physical location of the institution or its branch office 43240
county County, County where the institution is physically located (abbreviated if the county name exceeds 16 characters) Delaware
state_and_county_no State and county number, A five digit number representing the state and county in which the institution is physically located. The first two digits represent the FIPS state numeric code and the last three digits represent the FIPS county numeric code 39041
state_no State Alpha code, State in which the the headquarters are physically located. 39
url Primary Internet Web Address, The primary internet web address is the public internet site obtained from the most recent FFIEC Call Report http://www.jpmorganchase.com
total_branches Offices, A branch/office is any location, or facility, of a financial institution, including its main office, where deposit accounts are opened, deposits are accepted, checks paid, and loans granted 5446
domestic_branches Number of Domestic Offices, The number of domestic offices (including headquarters) operated by active institutions in the 50 states of the U.S.A. 5344
foreign_branches Number of Foreign Offices, The number of foreign offices (outside the U.S.) operated by the institution. 197
asset_concentration Name associated with the numeric indicator (SPECGRP) of an institution’s primary specialization in terms of asset concentration International Specialization
asset_concentration_no Asset Concentration Hierarchy, An indicator of an institution’s primary specialization in terms of asset concentration 3
occ_charter_number OCC Charter Number, A unique number assigned by the Office of the Comptroller of the Currency (OCC) used to identify institutions that it has chartered and regulates (i.e. national banks). 8
fdic_geo_region_no FDIC Geographic Region, The FDIC Office assigned to the geographic area. 9
fdic_supervisory_region FDIC Supervisory Region, The supervisory FDIC office assigned to the institution. Chicago
fdic_supervisory_region_no A numeric value associated with the name of an FDIC supervisory region 16
frb_district FDICSUPV, Federal Reserve District, “The supervisory FDIC office assigned to the institution. There are twelve Federal Reserve Districts, with two Districts serving one state in some instances. 4
frb_district_no Federal Reserve ID Number, A number used to identify the Federal Reserve district in which the institution is located. 3
ots_district_no OTS District, Office of Thrift Supervision (OTS) District 3
ots_district Office of Thrift Supervision Region, Prior to 7/21/11, the Office of Thrift Supervision (OTS) Region in which the institution is physically located. Washington
occ_district_no Office of the Comptroller, The Office of the Comptroller of the Currency (OCC) District in which the institution is physically located. 3
regulator Regulator, There are three Federal regulators of banks and savings and loan institutions- FDI, FRB, OCC OCC
state_charter State Charter, A flag (true;false) that indicates if an institution is state chartered. -
federal_charter Federal charter flag, A flag used to indicate whether the institution is chartered by an agent of the federal government. true
fdic_field_office FDIC Field Office, The FDIC Field Office where an institution is physically located. Columbus
bank_class Bank Charter Class, A classification code assigned by the FDIC based on the institution’s charter type (commercial bank or savings institution), charter agent (state or federal), Federal Reserve membership status (Fed member, Fed nonmember) and its primary federal regulator (state chartered institutions are subject to both federal and state supervision) N
chartering_agency Chartering Agency, All Chartering Agencies - State and Federal Comptroller of the Currency. OCC
conservatorship CONSERVE, Conservatorship, A flag (1=yes;0=no) that indicates if an institution is being operated in government conservatorship. -
interstate_branches Interstate Branches, A “yes” indicates that an institution has branches that can accept FDIC-insured deposits in more than one state. The FDIC Act defines state as any State of the United States, the District of Columbia, and any territory of the United States, Puerto Rico, Guam, American Samoa, the Trust Territory of the Pacific Islands, the Virgin Island, and the Northern Mariana Islands. true
s_corp Subchapter S Corporations, Banks are required to indicate on the Call Report whether there is currently in effect an election to file under Subchapter S. -
trust_fiduciary_services Trust Powers, A flag used to indicate an institution’s Trust Powers Granted status. False = No Trust Power Granted True = Trust Power Granted true
community_bank FDIC community banks are identified based on criteria defined in the FDIC Community Banking Study -
cmsa_no Consolidated Metropolitan Statistical Division Number, The numeric code given by the US Census Bureau office of Management and Budget -
cmsa Consolidated Metropolitan Statistical Area, The Federal Information Processing Standards (FIPS) Consolidated Metropolitan Statistical Area (CMSA) code is a number representing the institution location -
msa_no Metropolitan Statistical Area Number, The Metropolitan Statistical Area Number (MSA_NO) in which the institution is physically located 1840
msa Metropolitan Statistical Area (MSA), The Metropolitan Statistical Areas based on Census Bureau data, as defined by the US Office of Management (OMB) prior to the year 2000 Columbus, OH
csa_no Numeric Code for the Combined Statistical Area, The numeric code that the U.S. Census Bureau Office of Management and Budget assigns for the combined statistical area (CSA) per the 2000 standards 198
csa Name of the Combined Statistical Area, The name associated with the numeric code that the U.S. Census Bureau Office of Management and Budget assigns for the combined statistical area (CSA) per the 2000 standards Columbus-Marion-Zanesville, OH
cbsa_no Numeric Code for the Core Based Statistical Area, The numeric code that the U.S. Census Bureaus Office of Management and Budget assigns for the CBSA 18140
cbsa Name of the Core Based Statistical Area, The name associated with the numeric code that the U.S. Census Bureau Office of Management and Budget assigns for the CBSA Columbus, OH
cbsa_metro_no Numeric code assigned by the U.S. Census Bureau’s Office of Management and Budget for a metropolitan area within a CBSA 18140
cbsa_metro Name associated with the numeric code that the U.S. Census Bureau’s Office of Management and Budget assigns for the metropolitan areas within a CBSA; are now also the basis for Metropolitan Statistical Areas (MSAs) Columbus, OH
cbsa_division_no Core Based Statistical Division Number, The numeric code given by the US Census Bureau office of Management and Budget -
cbsa_division Name of the Core Based Statistical Division, The name associated with the numeric code given by the US Census Bureau office of Management and Budget (2000 standards) that represents the core based statistical division (CBSADIV) -
last_update Last update, The date of the last data update 2015-09-24
last_structural_change Last Structure Change Process Date, A date field indicating the date that a change to this record was processed 2015-08-31
established_on Established Date, The date on which the institution began operations 1824-01-01
deposit_insurance_date Date of Deposit Insurance, The date that an institution obtained federal deposit insurance 1934-01-01
active Active, True=Institutions who remain open currently, False=Institutions that are currently closed but were once insured by the FDIC true

Sample Data

expand collapse

Banks Master

Returns bank list and information for all banks covered by Intrinio.
URL: https://api.intrinio.com/banks

Banks Master

Returns bank list and information for all banks covered by Intrinio.
URL: https://api.intrinio.com/banks.csv

Banks Master

Not available for this access method

Banks Lookup

Returns bank information for a single bank with the given parameters.
URL: https://api.intrinio.com/banks?rssd_id=2362074

Banks Lookup

Returns bank information for a single bank with the given parameters.
URL: https://api.intrinio.com/banks.csv?rssd_id=2362074

Banks Lookup

Not available for this access method

Bank Holding Companies

Returns a list of bank holding companies covered by Intrinio.

Parameters

expand collapse
Name Description Example
query Used to search for a ticker or bank name to return relevant banks. Morgan
ticker The stock market ticker symbol associated with the companies common stocksecurities. TSLA
rssd_id The bank/bank holding company RSSD ID issued by the Federal Reserve. -
page_number An integer greater than or equal to 1 for specifying the page number for the return values. -
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
rssd_id High Regulatory Holder, The unique number assigned by the Federal Reserve Board to the regulatory high holding company of the institution. 1139523
name Bank Holding Company (Regulatory Top Holder), Regulatory top holder is assigned by the Federal Reserve Board based on ownership and control percentages. Jpmorgan Chase & Co.
city City of High Holder, City in which the headquarters of the institution’s regulatory high holder are physically located. New York
state Regulatory holding company state location, State location of the regulatory high holding company (either direct or indirect owner). NY
banks
List of banks under this holding company. -

Sample Data

expand collapse

Bank Holding Companies Master

Returns information for all bank holding companies covered by Intrinio.
URL: https://api.intrinio.com/banks/holding_companies

Bank Holding Companies Master

Returns information for all bank holding companies covered by Intrinio.
URL: https://api.intrinio.com/banks/holding_companies.csv

Bank Holding Companies Master

Not available for this access method

Bank Holding Companies Lookup

Returns information for a single bank holding company.
URL: https://api.intrinio.com/banks/holding_companies?rssd_id=1039502

Bank Holding Companies Lookup

Returns information for a single bank holding company.
URL: https://api.intrinio.com/banks/holding_companies.csv?rssd_id=1039502

Bank Holding Companies Lookup

Not available for this access method

Bank Branches

Returns a list of bank branches covered by Intrinio.

Parameters

expand collapse
Name Description Example
ticker The stock market ticker symbol associated with the companies common stock securities. AAPL
rssd_id The bank/bank holding company RSSD ID issued by the Federal Reserve. 480228
uninumber The uninumber is the unique identifier for each bank branch office assigned by the Federal Reserve & the FDIC. 3
page_number An integer greater than or equal to 1 for specifying the page number for the return values. 2
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 100
hide_paging
Hide first row of paging information.
Options:
true
-

Output Fields

expand collapse
Name Description Example
rssd_id The unique number assigned by the Federal Reserve Board (FRB) to the institution. 480228
bank_name Institution name Bank of America, National Association
uninumber The unique number associated with a specific physical location of a branch. This number remains with this location over time, regardless of ownership. 3
branch_number Numerical reference to identify a branch office within one institution 7636
branch_name Branch name Southington Main Branch
address Physical location of the branch 100 5th Street South
city Reported city in which the branch is located Saint Petersburg"
state The state abbreviation of the location in which the branch is physically located. FL
zip_code The ZIP code associated with the physical address of the branch. 33701
county County name in which the branch is located. United States
state_no The FIPS number of the state in which the branch is physically located. 12
state_and_county_no The state and county FIPS code associated with the specific branch location. 103
central_city Central city based on the reported ZIP code of the branch Saint Petersburg
latitude The lattitude of the branch’s physical location. 27.770275932
longitude The longitude of the branch’s physical location -82.64009368
location_quality The quality of the match of the branch’s physical location to a latitude and longitude with a given projection. M
location_method The method used to arrive at the latitude and longitude of the branch’s physical location. US_Streets
place_num The FIPS MCD (Minor Civil Division) code refers to a subsection of the U.S. Census county subdivision statistics. The county subdivision FIPS includes census data for county divisions, census subareas, minor civil divisions, unorganized territories, and incorporated areas 93042
branch_service_type Code that defines the type of service the branch office provides 11
main_office Main office / branch identifier; true=Main office, false=branch true
msa_no The Metropolitan Statistical Areas (MSABR) are based on the 2010 Census - these areas correspond to the state/county/CBSA relationships as defined by the Census Bureau 45300
msa The Metropolitan Statistical Area name in which the branch is physically located Tampa-St. Petersburg-Clearwater, FL
csa_no The identifying code of a geographic entity consisting of two or more adjacent Core Based Statistical Areas (CBSAs) with employment interchange measures of at least 15 198
csa The name of a geographic entity consisting of two or more adjacent Core Based Statistical Areas (CBSAs) with employment interchange measures of at least 15 -
cbsa_division_no A county or group of counties within a Core Based Statistical Area that contains a core with a population of at least 2.5 million -
cbsa_division The name that corresponds to a code for a county or group of counties within a Core Based Statistical Area that contains a core with a population of at least 2.5 million -
established_on The date that the branch location was established. 1995-11-17
acquired_on The date that a branch was last acquired by another institution -
reported_date The date the bank reported deposits for this branch 2015-06-30
year The year the bank reported deposits for this branch 2015
total_deposits Branch office deposits for the reported date 390047000.0
deposits
All recorded deposits for this bank branch -

Sample Data

expand collapse

Bank Branches Master

Returns a list of all bank branches
URL: https://api.intrinio.com/banks/branches

Bank Branches Master

Returns a list of all bank branches
URL: https://api.intrinio.com/banks/branches.csv

Bank Branches Master

Not available for this access method

Bank Branches Lookup by RSSD ID

Return detailed information about a single bank branch
URL: https://api.intrinio.com/banks/branches?uninumber=384

Bank Branches Lookup by RSSD ID

Return detailed information about a single bank branch
URL: https://api.intrinio.com/banks/branches.csv?uninumber=384

Bank Branches Lookup by RSSD ID

Not available for this access method

Failed Banks

Returns a list of failed banks covered by Intrinio.

Parameters

expand collapse
Name Description Example
query Used to search for a bank name to return relevant failed banks. Morgan
page_number An integer greater than or equal to 1 for specifying the page number for the return values. -
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
fin_id Financial Institution Number is a unique number assigned to the institution as an Assistance Agreement, Conservatorship, Bridge Bank or Receivership. 10377
name This is the legal name of the institution High Trust Bank
city The city and state (or territory) of the headquarters of the institution. Stockbridge
state The state in which the headquarters of the institution are physically located. Georgia
effective_date The date that the failed / assisted institution ceased to exist as a privately held going concern. For institutions that entered into government ownership, such as FDIC Bridge Banks and RTC conservatorships, this is the date that they entered into such ownership. 2011-07-15
insurance_fund Before 1989, there were two federal deposit insurance funds, one administered by the FDIC, which insured deposits in commercial banks and state-chartered savings banks, and another administered by the Federal Savings and Loan Insurance Corporation (FSLIC), which insured deposits in state- and federally-chartered savings associations. In 1989, the Financial Institutions Reform, Recovery and Enforcement Act (FIRREA) specified that thereafter the FDIC would be the federal deposit insurer of all banks and savings associations and would administer both the FDIC fund, which was renamed the Bank Insurance Fund (BIF) and the replacement for the insolvent FSLIC fund, which was called the Savings Association Insurance Fund (SAIF). Although it was created in 1989, the SAIF was not responsible for savings association failures until 1996. From 1989 through 1995, savings association failures were the responsibility of the Resolution Trust Corporation (RTC). In February 2006, The Federal Deposit Insurance Reform Act of 2005 provided for the merger of the BIF and the SAIF into a single Deposit Insurance Fund (DIF). Necessary technical and conforming changes to the law were made under The Federal Deposit Insurance Reform Conforming Amendments Act of 2005. The merger of the funds was effective on March 31, 2006. DIF
transaction_type Institutions have been resolved through several different types of transactions. The transaction types outlined below can be grouped into three general categories, based upon the method employed to protect insured depositors and how each transaction affects a failed / assisted institution’s charter. PA
charter_class The FDIC assigns classification codes indicating an institution’s charter type (commercial bank, savings bank, or savings association), its chartering agent (state or federal government), its Federal Reserve membership status (member or nonmember), and its primary federal regulator. These codes are... NM
failed_or_assistance The given institution has failure stature or it can be assistance has been provided by FDIC in merging with other institution. FAILURE
total_deposits Total including demand deposits, money market deposits, other savings deposits, time deposits and deposits in foreign offices as of the last Call Report or Thrift Financial Report filed by the institution prior to the effective date 177221000.0
total_assets The Total assets owned by the institution including cash, loans, securities, bank premises and other assets as of the last Call Report or Thrift Financial Report filed by the institution prior to the effective date 180340000.0
estimated_fdic_loss The estimated loss is the difference between the amount disbursed from the Deposit Insurance Fund (DIF) to cover obligations to insured depositors and the amount estimated to be ultimately recovered from the liquidation of the receivership estate 73127000.0

Sample Data

expand collapse

Failed Banks Master

Returns failed bank list and information for all failed banks covered by Intrinio.
URL: https://api.intrinio.com/banks/failed

Failed Banks Master

Returns failed bank list and information for all failed banks covered by Intrinio.
URL: https://api.intrinio.com/banks/failed.csv

Failed Banks Master

Not available for this access method

Bank Fundamentals

Returns a list of available bank fundamentals (fiscal year, fiscal period, start date, and end date) for a given ticker/rssd_id and statement. Statements are from the bank call reports, UBPR reports, and Y-9C reports filed with the FDIC & Federal Reserve.

Function: =IntrinioBankFundamentals(identifier, statement, type, sequence, item)

Parameters

expand collapse
Name Description Example
identifier The stock market ticker symbol associated with the companies common stock securities, or the bank/bank holding company RSSD ID issued by the Federal Reserve. 2362074
statement The call report/UBPR/Y-9C financial statement requested. RI
type
The type of periods requested - includes fiscal years for annual data, quarters for quarterly data.
Options:
FY
QTR
YTD
FY
report
Select report for all fundamentals.
Options:
call_report
ubpr
Y9C
Y9C
date The first fundamental will be the latest as of this specified date. 2014-12-31
item
The return value for the fundamental.
Options:
statement_code
end_date
start_date
months
fiscal_year
fiscal_period
report
fiscal_year
sequence An integer 0 or greater for calling a single fundamental from the first entry. 0
page_number An integer greater than or equal to 1 for specifying the page number for the return values. -
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
statement_code the statement code for the financial statement from the report RI
fiscal_year the fiscal year of the fundamental 2015
fiscal_period the fiscal period of the fundamental FY
end_date the last date of the fundamental 2015-12-1
start_date (not available on the balance sheet) the first date of the fundamental 2015-12-31
report the report the financial statement is sourced from, corresponding with the statement_code call_report

Sample Data

expand collapse

Bank Fundamentals Lookup

Returns a list of bank fundamentals information matching the given filters
URL: https://api.intrinio.com/fundamentals/banks?identifier=2362074&statement=RI&type=FY

Bank Fundamentals Lookup

Returns a list of bank fundamentals information matching the given filters
URL: https://api.intrinio.com/fundamentals/banks.csv?identifier=2362074&statement=RI&type=FY

Bank Fundamentals Lookup

Returns a list of bank fundamentals information matching the given filters
Function: =IntrinioBankFundamentals("2362074", "RI", "FY", 0, "fiscal_year")

Bank Fundamentals Lookup

Not available for this access method

Bank XBRL Tags

Returns the Bank XBRL tags and labels for a given ticker/RSSD ID, statement, and date or fiscal year/fiscal quarter.

Function: =IntrinioBankTags(idenfifier, statement, sequence, item)

Parameters

expand collapse
Name Description Example
identifier The stock market ticker symbol associated with the companies common stock securities, or the bank/bank holding company RSSD ID issued by the Federal Reserve. 2362074
statement The financial statement requested from the call report, the UBPR report or Y-9C report, which can be found from the bank fundamentals end point. RI
fiscal_year The fiscal year associated with the fundamental. 2015
fiscal_period
The fiscal period associated with the fundamental.
Options:
FY
Q1
Q2
Q3
Q4
Q1TTM
Q2TTM
Q3TTM
Q2YTD
Q3YTD
FY
item
The return value for the tag.
Options:
name
tag
unit
sequence
depth
abstract
name
sequence An integer 0 or greater for calling a single tag from the first entry. 0
page_number An integer greater than or equal to 1 for specifying the page number or the return values. -
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
name the label of the XBRL tag as reported of the financial statement Schedule RI - Income Statement
tag the XBRL tag of the associated financial data point RI
unit the unit type of the XBRL tag String
abstract the type of value - true indicates that the value is a header label and has no associated data value, whereas false indicates that the XBRL tag has an associated value. true
sequence an integer 0 or greater indicating the presentation order of the XBRL tag and label in the financial statement 1
depth an integer 0 or greater indicating the presentation indentation depth of the XBRL tag and label in the financial statement 1

Sample Data

expand collapse

Bank XBRL Tags

Returns the Bank XBRL tags and labels matching the given paramters.
URL: https://api.intrinio.com/tags/banks?identifier=2362074&statement=RI&fiscal_year=2015&fiscal_period=FY

Bank XBRL Tags

Returns the Bank XBRL tags and labels matching the given paramters.
URL: https://api.intrinio.com/tags/banks.csv?identifier=2362074&statement=RI&fiscal_year=2015&fiscal_period=FY

Bank XBRL Tags

Returns the Bank XBRL tags and labels matching the given paramters.
Function: =IntrinioBankTags("2362074", "RI", 0, "name")

Bank XBRL Tags

Not available for this access method

Bank Financials

Returns the Bank Financials directly from the financial statements of the call report, UBPR report, and Y-9C XBRL filings from the bank issued with the FDIC.

Function: =IntrinioBankFinancials(identifier, statement, sequence, type, tag, rounding)

Parameters

expand collapse
Name Description Example
identifier The stock market ticker symbol associated with the companies common stock securities, or the bank/bank holding company RSSD ID issued by the Federal Reserve. 2362074
statement The financial statement requested from the call report, the UBPR report, or the Y-9C report, which can be found from the bank fundamentals end point. RI
date The first fundamental will be the latest as of this specified date. 2018-01-01
sequence The sequence of the requested fundamental (i.e. 0 is the first available fundamental associated with the fiscal period type. 0
type
The type of periods requested - includes fiscal years for annual data, quarters for quarterly data and trailing twelve months for annual data on a quarterly basis.
Options:
FY
QTR
TTM
YTD
FY
tag The specified bank call report, UBPR report, or Y-9C report XBRL tag. RIADA518
fiscal_year The fiscal year associated with the fundamental. 2018
fiscal_period
The fiscal period associated with the fundamental.
Options:
FY
Q1
Q2
Q3
Q4
Q1TTM
Q2TTM
Q3TTM
Q2YTD
Q3YTD
Q4
rounding
Round the returned value (actuals, thousands, millions, billions).
Options:
A
K
M
B
A
page_number An integer greater than or equal to 1 for specifying the page number for the return values. 22
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 58
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
tag the bank call report, UBPR report, or Y-9C report XBRL tag of the financial data point RIAD4056
value the value of the XBRL tag of the financial data point 1503000.0

Sample Data

expand collapse

Bank Financials Lookup

Function: =IntrinioBankFinancials("2362074", "RI", 0, "FY", "RIADA518", "A")

Bank Financials Lookup

Not available for this access method