Type SnlStatStockPeriod
Type category Entity
Description Description of the financial records for each entity for each period for each Line of Business
Fields
Name Type Filters Description
key id string(36)* = Unique identifier for each Stock period
link batch Batch* = Definition of a batch, representing a set of updates linked to a particular condition.
link batchRun BatchRun* = Defines an instance of a Batch. Where a Batch has a fixed definition over time, a BatchRun represents a specific Version of the Batch on a specific asOf.
ciqCompanyId long(-2147483648,2147483647) Unique identifier assigned to a company
dateEndedStandard dateTime* Ending date of the fiscal period, standardized to be the last day of the month in which the period ends. For example, if a fiscal period ends on June 29, this date will be June 30, so that there is a consistency among different companies.
finlStatStockId string(36)* Unique identifier for each Stock period
finlStatStockPriorId string(36) Unique identifier for each Stock period of Prior period
finlStatStockPriorYearId string(36) Unique identifier for each Stock period of Prior Year
finlStatStockTotalLOBId string(36) Unique identifier for each of Total LOB
institutionId long(-2147483648,2147483647) S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization.
insuranceStatLOBId long(-32768,32767)* Unique identifier for each Line of Business
insuranceStatLOBShortName string(40) A short name for the insurance statutory line of business
insuranceStatLineOfBusiness string(80) Insurance statutory line of business
insuranceStatReportedDate dateTime* Date as of which the statutory insurance data is reported
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 objects, but not all objects, 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 object to object, but there will always be at least the one row marked with a 1.
mostRecentSequenceFiscalYears long(0,255) Indicates that the row is the most recent year end
spStatEntityId string(20) S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC
statEntityId string(36)* Unique identifier for each Statutory entity
18 rows of 18 total
API Open API Specification