U.S. Bank Financial Condition and Performance Data Service

Data

Published by: MacroTrenz Corp.
Categories: Capital Markets, Banking, Reference, Business and Finance
Date added: 5/11/2012
Get support for this offering

The U.S. Bank Financial Condition and Performance Data Service returns, in a concise and readily usable data format, the regulatory reports, financial data, and structural information for FDIC-insured bank and thrift institutions published by the Federal Financial Institutions Examinations Council (FFIEC). Easy search and data retrieval across the full set of over 350,000 quarterly Bank Call and Uniform Bank Performance reports representing over one billion data points. In addition, individual MDR element data can be retrieved across banks and reporting periods.

Service root URL

https://api.datamarket.azure.com/macrotrenz/FFIECDataService/v1/

This service supports fixed query. Some queries may include required input parameters. (learn more about query types)

GET_REPORTING_PERIODS

No input parameters

Results:

Name Type
PERIOD_ID Int32

GET_BANK_LOOKUP

Input parameters:

Name Sample values Type Required
PERIOD_ID Int32 Required
SEARCH_SNIPPET String Required

Results:

Name Type
ID_RSSD Int32
PERIOD_ID Int32
FDICCertNumber Int32
OCCChartNumber Int32
OTSDockNumber Int32
PrimaryABARoutNumber Int64
Name String
Address String
City String
State String
ZIP Int32

GET_RAW_DATA

Input parameters:

Name Sample values Type Required
ELEMENT_NAME String
ID_RSSD Int32
PERIOD_ID Int32

Results:

Name Type
ID_RSSD Int32
PERIOD_ID Int32
ELEMENT_NAME String
ENTRY_STARTDATE String
ENTRY_ENDDATE String
UNIT_TYPE String
DECIMALS Byte
VALUE String

GET_REPORT_CALL

Input parameters:

Name Sample values Type Required
ID_RSSD Int32 Required
PERIOD_ID Int32 Required

Results:

Name Type
ID_RSSD Int32
PERIOD_ID Int32
ENTRY String
ENTRY_TYPE String
ENTRY_PERIOD String
ENTRY_STARTDATE String
ENTRY_ENDDATE String
UNIT_TYPE String
DECIMALS Byte
VALUE String
HEADER_LINE String
HEADER_COLUMN String
SCHEDULE String
SCHEDULE_LINE String
SCHEDULE_COL String
USE String
LEVEL Int16
SORT Int64

GET_REPORT_UBPR

Input parameters:

Name Sample values Type Required
ID_RSSD Int32 Required
PERIOD_ID Int32 Required

Results:

Name Type
ID_RSSD Int32
REPORT_DATE Int32
REPORT_PAGE String
REPORT_LINE String
ENTRY String
ENTRY_TYPE String
ENTRY_PERIOD String
ENTRY_STARTDATE String
ENTRY_ENDDATE String
UNIT_TYPE String
DECIMALS Byte
VALUE String
USE String
LEVEL Int16
SORT Int32
These database webservices and the schema therein created by and wholly & privately owned by MACROTRENZ CORP. is licensed under the "FRB_SR", "Federal Reserve Bank Financial Data Service" and "U.S Bank Financial Condition and Performance Data Service" brands and are subject to the terms of the following licensing agreement: END-USER LICENSE AGREEMENT FOR "FRB_SR", "Federal Reserve Bank Financial Data Service" and "U.S Bank Financial Condition and Performance Data Service" ONLINE SERVICES IMPORTANT PLEASE READ THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT CAREFULLY BEFORE CONTINUING WITH SUBSCRIBING AND USING THIS SERVICE: MACROTRENZ CORP.'s End-User License Agreement ("EULA") is a legal agreement between you (either an individual or a single entity) and MACROTRENZ CORP. for the MACROTRENZ CORP. software service(s) and product(s) identified above which may include associated services, software components, media, printed materials, and "online" or electronic documentation ("SOFTWARE SERVICE & PRODUCT"). By installing, copying, or otherwise using the SOFTWARE SERVICE & PRODUCT, you agree to be bound by the terms of this EULA. This license agreement represents the entire agreement concerning the SOFTWARE SERVICE & PRODUCT between you and MACROTRENZ CORP., (referred to as "licenser"), and it supersedes any prior proposal, representation, or understanding between the parties. If you do not agree to the terms of this EULA, do not subscribe, purchase, install or use the SOFTWARE SERVICE & PRODUCT. The SOFTWARE SERVICE & PRODUCT is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. The SOFTWARE SERVICE & PRODUCT is licensed, not sold. 1. GRANT OF LICENSE. The SOFTWARE SERVICE & PRODUCT is licensed as follows: (a) Subscription, Access, Installation, and Use. MACROTRENZ CORP. grants you the right to subscribe, access, install, and use a copy of the SOFTWARE SERVICE & PRODUCT on your computer. (b) Backup Copies. You may also make copies of the SOFTWARE SERVICE & PRODUCT as may be necessary for backup and archival purposes. 2. DESCRIPTION OF OTHER RIGHTS AND LIMITATIONS. (a) Maintenance of Copyright Notices. You must not remove or alter any copyright notices on any and all copies of the SOFTWARE SERVICE & PRODUCT. (b) Distribution. You may not distribute copies of the SOFTWARE SERVICE & PRODUCT to third parties. (c) Prohibition on Reverse Engineering, Decompilation, and Disassembly. You may not reverse engineer, decompile, or disassemble the SOFTWARE SERVICE & PRODUCT, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation. (d) Rental. You may not rent, lease, or lend the SOFTWARE SERVICE & PRODUCT. (e) Support Services. MACROTRENZ CORP. may provide you with support services related to the SOFTWARE SERVICE & PRODUCT ("Support Services"). Any supplemental software code provided to you as part of the Support Services shall be considered part of the SOFTWARE SERVICE & PRODUCT and subject to the terms and conditions of this EULA. (f) Compliance with Applicable Laws. You must comply with all applicable laws regarding use of the SOFTWARE SERVICE & PRODUCT. 3. TERMINATION Without prejudice to any other rights, MACROTRENZ CORP. may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must discontinue your subscription, access and use; and uninstall and destroy all copies of the SOFTWARE SERVICE & PRODUCT in your possession. 4. COPYRIGHT All title, including but not limited to copyrights, in and to the SOFTWARE SERVICE & PRODUCT and any copies thereof are owned by MACROTRENZ CORP. or its suppliers. All title and intellectual property rights in and to the content which may be accessed through use of the SOFTWARE SERVICE & PRODUCT is the property of the respective content owner and may be protected by applicable copyright or other intellectual property laws and treaties. This EULA grants you no rights to use such content. All rights not expressly granted are reserved by MACROTRENZ CORP.. 5. NO WARRANTIES MACROTRENZ CORP. expressly disclaims any warranty for the SOFTWARE SERVICE & PRODUCT. The SOFTWARE SERVICE & PRODUCT is provided 'As Is' without any express or implied warranty of any kind, including but not limited to any warranties of merchantability, noninfringement, or fitness of a particular purpose. MACROTRENZ CORP. does not warrant or assume responsibility for the accuracy or completeness of any information, text, graphics, links or other items contained within the SOFTWARE SERVICE & PRODUCT. MACROTRENZ CORP. make no warranties respecting any harm that may be caused by the transmission of a computer virus, worm, time bomb, logic bomb, or other such computer program. MACROTRENZ CORP. further expressly disclaims any warranty or representation to Authorized Users or to any third party. 6. LIMITATION OF LIABILITY In no event shall MACROTRENZ CORP. be liable for any damages (including, without limitation, lost profits, business interruption, or lost information) rising out of 'Authorized Users' use of or inability to use the SOFTWARE SERVICE & PRODUCT, even if MACROTRENZ CORP. have been advised of the possibility of such damages. In no event will MACROTRENZ CORP. liable for loss of data or for indirect, special, incidental, consequential (including lost profit), or other damages based in contract, tort or otherwise. MACROTRENZ CORP. shall have no liability with respect to the content of the SOFTWARE SERVICE & PRODUCT or any part thereof, including but not limited to errors or omissions contained therein, libel, infringements of rights of publicity, privacy, trademark rights, business interruption, personal injury, loss of privacy, moral rights or the disclosure of confidential information.
250

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$10.00

per month

Buy
1,000

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$29.00

per month

Try Free

Trial Details
This selection includes a 1 month free trial. After the trial period expires, your credit card will be charged on a monthly basis for the subscription price (plus applicable tax) until your subscription is cancelled or terminated. If you cancel within the trial period, your credit card will not be charged.

10,000

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$99.00

per month

Buy
250,000

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$459.00

per month

Buy
1,000,000

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$999.00

per month

Buy

Resources

  • Microsoft PowerPivot For Excel 2010

    Learn how to use Microsoft PowerPivot for Excel 2010, with this and other DataMarket data, to create compelling self-service BI solutions.

  • Tableau Software

    Learn how to visualize this and other DataMarket datasets in Tableau. Tableau’s rapid fire business intelligence solution provides best-in-class data visualization and web dashboards anyone can use.

  • Learn How To Use This Data In Visual Studio

    Learn how to seamlessly consume DataMarket data in Visual Studio with strongly-typed data access and full IntelliSense support to ease development.