Type BranchDepositsCounty
Type category Entity
Description Aggregate branch data for a county, over time. The data in this object is entirely derived.
Fields
Name Type Filters Description
key id string(100)* = Unique identifier for Branch Deposits County
assetsInMarket decimal{22,8}* Aggregate assets for regulated depository institutions for the designated market. 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.
branchDepositCountyId string(36)* Unique identifier for Branch Deposits County
branchesInMarketBank long(-2147483648,2147483647) Aggregate number of bank branches for the designated market. Magnitude: (actual)
branchesInMarketFiltBTNonZero long(-2147483648,2147483647) Aggregate number of active retail bank and thrift branches for the designated market excluding zero deposit branches. Magnitude: (actual)
branchesInMarketFiltered long(-2147483648,2147483647) Aggregate number of retail branches for the designated market. Magnitude: (actual)
branchesInMarketFilteredBT long(-2147483648,2147483647) Aggregate number of retail bank and thrift branches for the designated market. Magnitude: (actual)
branchesInMarketFilteredBTTot long(-2147483648,2147483647) Aggregate number of retail bank and thrift branches for the designated market including open and closed branches. Magnitude: (actual)
branchesInMarketFilteredBank long(-2147483648,2147483647) Aggregate number of retail bank branches for the designated market. Magnitude: (actual)
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.
depositsInMarketBank decimal{22,8}* Aggregate bank deposits for the designated market. Magnitude: ($000)
depositsInMarketBankAndThrift decimal{22,8}* Aggregate bank and thrift deposits for the designated market. Magnitude: ($000)
depositsInMarketFiltered decimal{22,8} Aggregate retail federally-insured bank, thrift, and credit union deposits in the market. Magnitude: ($000)
depositsInMarketFilteredBT decimal{22,8} Aggregate retail federally-insured bank and thrift deposits in the market. Magnitude: ($000)
depositsInMarketFilteredWeight decimal{22,8} Aggregate weighted retail deposits for the designated market; banks at 100%, savings banks and thrifts at 50% and credit unions at 0%. Magnitude: ($000)
loansCommercialInMarket decimal{22,8}* Aggregate commercial loans for regulated depository institutions for the designated market. 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.
21 rows of 21 total
API Open API Specification