Type InstnBranches
Type category Entity
Description Aggregate bank branch information for a company over time. Contains only bank- and high-holder-level companies. High-holder is defined as the ultimate parent unless a traded company appears in the tree in which case it is the first traded company.
Fields
Name Type Filters Description
key id string(100)* = Unique identifier for institution Branches
assets decimal{22,8} All assets owned by the company as of the date indicated, as carried on the balance sheet and defined under the indicated accounting principles. Magnitude: ($000)
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the entity is sent.
link branchAsOfId BranchAsOf Date as of which the branch data is current. Data from the regulatory branch statement of deposits is always as of June 30 of any year.
companyId long(-2147483648,2147483647)* Unique identifier assigned to a company
companyIdParent string(13) Unique identifier for the highest-holder parent company
deposits decimal{22,8}* Total deposits from customers. For US banks, this is the total deposits from customers and banks. Magnitude: ($000)
institutionBranchesId string(36)* Unique identifier for institution Branches
institutionId long(-2147483648,2147483647)* S&P's unique key to identify institutions.
instnDepositsFiltered long(-9223372036854775807,9223372036854775806) Amounts in customers' banking deposits; any accounts subject to federal banking deposit insurance, including any portions in jumbo deposits that are not insured but subject to the FDIC deposit regulations, and excluding deposits in any excluded branches. Magnitude: ($000)
loansCommIndAssets decimal{22,8} Commercial and industrial loans as a percent of assets. Magnitude: (%)
loansCommercialIndustrial long(-2147483648,2147483647) Includes loans for commercial and industrial purposes to sole proprietorships, partnerships, corporations, and other business enterprises, whether secured (other than by real estate) or unsecured, single-payment or installment, in the form of either direct or purchased loans, for the fully consolidated bank. This also covers loans to individuals for commercial, industrial, and professional purposes, and those for financing capital expenditures and current operations. Specific inclusions are loans guaranteed by the Small Business Administration (SBA), loans made to finance construction not secured by real estate, and commercial and industrial loans guaranteed by foreign governmental institutions. (Magnitude: $000)
loansConst long(-2147483648,2147483647) Total construction and development loans: Includes loans secured by real estate with original maturities of 60 months or less made to finance land development preparatory to erecting new structures or the on-site construction of industrial, commercial, residential, or farm buildings, for domestic offices only, including not only construction of new structures, but also additions or alterations to existing structures and the demolition of existing structures to make way for new structures. Includes loans secured by real estate the proceeds of which are to be used to acquire and improve developed and undeveloped property and loans made under Title I or Title X of the National Housing Act that conform to the definition of construction stated above and that are secured by real estate. Magnitude: ($000)
loansConsumerAssets decimal{22,8} Consumer loans as a percent of assets. Magnitude: (%)
loansConsumerBanking long(-2147483648,2147483647) Total consumer loans: Includes all loans to individuals for household, family, and other personal expenditures that are not secured by real estate, whether direct loans or purchased paper, for the fully consolidated bank. Magnitude: ($000)
loansMultiFam long(-2147483648,2147483647) Total multifamily loans: Includes all other permanent nonfarm residential loans secured by real estate as evidenced by mortgages (FHA and conventional) or other liens, for domestic offices only. Includes, specifically, loans on: nonfarm properties with 5 or more dwelling units in structures used primarily to accommodate households on a more or less permanent basis, 5 or more unit housekeeping dwellings with commercial units combined where use is primarily residential, cooperative-type apartment buildings containing 5 or more dwelling units, vacant lots in established multifamily residential properties. Magnitude: ($000)
loansSBBig long(-2147483648,2147483647) Small business loans between $250,000 and $1 million: Includes the total carrying value of all currently outstanding commercial and industrial loans with original amounts greater than $250,000 and less than $1,000,000. Magnitude: ($000)
loansSBMid long(-2147483648,2147483647) Small business loans between $100,000 and $250,000: Includes the total carrying value of all currently outstanding commercial and industrial loans with original amounts greater than $100,000 and less than $250,000. Magnitude: ($000)
loansSBREBig long(-2147483648,2147483647) Small business and commercial real estate loans between $250,000 and $1 million: Includes the total carrying value of all currently outstanding loans secured by nonfarm, nonresidential properties with original amounts greater than $250,000 and less than $1,000,000. Magnitude: ($000)
loansSBREMid long(-2147483648,2147483647) Small business and commercial real estate loans between $100,000 and $250,000: Includes the total carrying value of all currently outstanding loans secured by nonfarm, nonresidential properties with original amounts greater than $100,000 and less than $250,000. Magnitude: ($000)
loansSBRESmall long(-2147483648,2147483647) Small business and commercial real estate loans less than $100,000: Includes the total carrying value of all currently outstanding loans secured by nonfarm, nonresidential properties with original amounts of $100,000 or less. Magnitude: ($000)
loansSBSmall long(-2147483648,2147483647) Small business loans less than $100,000: Includes the total carrying value of all currently outstanding commercial and industrial loans with original amounts less than $100,000. Magnitude: ($000)
loansSingleFam long(-2147483648,2147483647) Includes revolving and permanent loans secured by real estate, such as mortgages (Federal Housing Administration (FHA), Farmers Home Administration (FmHA), Department of Veterans Affairs (VA), or conventional) or other liens on 1-4 family residential property, for domestic offices only. This covers nonfarm property with 1-4 dwelling units (or more if separated by ground-to-roof walls), mobile homes legally defined as real property and secured by mortgage, individual condominium units, cooperative housing units (even in larger buildings), vacant lots in single-family residential areas, and housekeeping dwellings with combined commercial units where use is primarily residential and involves 1-4 family units. (Magnitude: $000)
mostRecentCurrentOwner boolean* Indicates that this row represents 'current' ownership, that is, it is updated for any completed deals but does not reflect any deals announced but that have not closed
mostRecentSequence long(-32768,32767)* Indicates the most recent data available within a time series. Rows with this value = 1 indicate that the row is the most recent. Some entities, but not all entities, require the calculation of varying numbers of data prior to the most recent. These rows are indicated with increasing values moving back through time. For example, the most recent row has a value of 1, the next most recent, or immediately prior, has a value of 2. The next prior record has a value of 3, and so on. The number of rows flagged with these values varies from entity to entity, but there will always be at least one row marked with a 1.
offices long(-2147483648,2147483647)* Number of locations as reported by the company. Magnitude: (actual)
officesBankInStore long(-2147483648,2147483647)* Number of supermarket or other in-retail-store banking branches operated. Magnitude: (actual)
officesBankTraditional long(-2147483648,2147483647)* Number of traditional (not in-store) banking branches operated. Magnitude: (actual)
parentInstitutionId long(-2147483648,2147483647) S&P's unique key for the highest-holder parent institutions
link regDomainClassId RegDomainClass The primary division of companies for which regulatory information is available.
31 rows of 31 total
API Open API Specification