Type InstnBranchByCounty
Type category Entity
Description High-holder aggregate branches grouped by county.
Fields
Name Type Filters Description
key id string(100)* = Unique identifier for institution Branch By County
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
link countyId County Government code used to identify U.S. counties and other first-order subdivisions of states. Codes are pursuant to U.S. FIPS 6-4.
depositRankInMarket long(-2147483648,2147483647) Marketshare rank of the company within the indicated market, based on deposits
depositRankInMarketFiltered long(-2147483648,2147483647) Marketshare rank of the company within the indicated market, based on deposits, and excluding any excluded branches
deposits decimal{22,8} Total deposits from customers. For US banks, this is the total deposits from customers and banks. Magnitude: ($000)
institutionId long(-2147483648,2147483647)* S&P's unique key to identify institutions.
instnBranchByCountyId long(-2147483648,2147483647)* Unique identifier for institution Branch By County
instnDepositsInMarketFiltered long(-9223372036854775807,9223372036854775806) Deposits in market for the company, excluding any excluded branches. 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)
officesInMarketFilterNonZero long(-2147483648,2147483647) Bank branches in market for the company, retail only, exluding zero deposit branches. Magnitude: (actual)
officesInMarketFiltered long(-2147483648,2147483647) Bank branches in market for the company, excluding any excluded branches. Magnitude: (actual)
officesInMarketFilteredTot long(-2147483648,2147483647) Bank Branches in market for the company, retail only including open and closed branches. Magnitude: (actual)
link regDomainClassId RegDomainClass The primary division of companies for which regulatory information is available.
19 rows of 19 total
API Open API Specification