Get detail on historical bank failures from 1934 to present.

GET {{baseUrl}}/failures?filters=FAILYR:["2014" TO "2015"]&fields=NAME,CERT,FIN,CITYST,FAILDATE,SAVR,RESTYPE,RESTYPE1,QBFDEP,QBFASSET,COST&sort_by=FAILDATE&sort_order=DESC&limit=10&offset=0&total_fields=QBFDEP,QBFASSET,COST&subtotal_by=RESTYPE&agg_by=FAILYR&agg_term_fields=RESTYPE&agg_sum_fields=QBFASSET,QBFDEP,COST&agg_limit=10&format=json&download=true&filename=data_file

Returns details on failed financial institutions.

Request Params

• Filter by Location
  CITYST:"MEMPHIS, TN"
• Filter all but a specified value
  !(CITY:"PITTSBURGH")
• Filter by institution fail year range
  FAILYR:["2015" TO "2016"] | | fields | string | | Comma delimited list of fields of failed financial institutions to return. | | sort_by | string | | Field name by which to sort returned data | | sort_order | string | | Indicator if ascending (ASC) or descending (DESC) | | limit | number | | The number of records to return. Default is 10 and maximum is 10,000. | | offset | number | | The offset of page to return. | | total_fields | string | | Fields to sum up (in a totals response object). Only numeric columns are valid. | | subtotal_by | string | | The field by which data will be subtotaled (in totals response object). Only categorical values should be used. | | agg_by | string | | The field(s) by which data will be aggregated. Valid values are 'FAILYR' or 'FAILYR,PSTALP'. | | agg_term_fields | string | | The field(s) for which aggregations will be counted for each unique term. | | agg_sum_fields | string | | The field(s) for which aggregations will be summed or aggregated. | | agg_limit | number | | The limit on how many aggregated results will be displayed | | format | string | | The format of the data to return. | | download | boolean | | Whether the data should be downloaded as a file. | | filename | string | | The filename to use when downloading data. |

RESPONSES

status: OK

{"meta":{"total":54019330,"parameters":{},"index":{"name":"ipsum eiusmod tempo","createTimestamp":"1997-05-29T15:19:02.652Z"}},"data":[{"value":"reference failure_properties.yaml not found in the OpenAPI spec"},{"value":"reference failure_properties.yaml not found in the OpenAPI spec"}],"totals":{"count":33503805}}