Type IssuerRatings
Type category Entity
Description This table serves as the primary source for an overview of an issuer's ratings based on debt type and rating type as assigned by the S&P Global Ratings. It is designed to include the essential characteristics needed to understand a complete rating record, including outlook and credit watch status.
Timeseries key id, ratingDate
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
timeline ratingDate dateTime =< >= Date the rating was assigned; time zone is in Eastern Time (ET) along with the timestamp.
companyId long Unique and proprietary S&P Global Ratings identifier for each organization (issuer).
creditRatingAgencyLEIId string(200) Legal Entity Identifier (LEI) code for the Rating Action Analyst office location.
creditRatingAgencyName string(200) Legal Entity Name of the Rating Action Analyst office location.
creditWatch string(100) CreditWatch highlights S&P Global Ratings' opinion regarding the potential direction of a short-term or long-term rating. This field provides the current CreditWatch value.
creditWatchDate dateTime This field provides the date for when the Current CreditWatch value was assigned; time zone is in Eastern Time (ET) along with the timestamp.
currentRatingIndicator long Indicator to denote current rating record.
currentRatingSymbolValue string(50) This field provides the current rating for an entity, program, or security.
cwChangeFlag boolean This field flags when there is an update which reflects a change in the CreditWatch as it relates to the current rating.
lastReviewDate dateTime Last Review Date(Eastern Time (ET) timezone) indicates the date an Issue or Issuer Credit Rating was last formally reviewed within a twelve-month period or when a credit rating action was last published. For certain dependent instruments, the Last Review Date will only be updated in the event of a Credit Rating change of the linked organization along with the timestamp.
olChangeFlag boolean This field flags when there is an update which reflects a change in the Outlook as it relates to the current rating.
outlook string(100) An S&P Global Ratings Outlook assesses the potential direction of a long-term credit rating over the intermediate term (typically six months to two years). In determining a rating Outlook, consideration is given to any changes in the economic and/or fundamental business conditions. An Outlook is not necessarily a precursor of a rating change or future CreditWatch action. This field provides the current Outlook value.
outlookDate dateTime This field provides the date for when the Current Outlook value was assigned; time zone is in Eastern Time (ET) along with the timestamp.
priorCreditWatch string(100) CreditWatch highlights S&P Global Ratings' opinion regarding the potential direction of a short-term or long-term rating. This field provides the prior CreditWatch value.
priorCreditWatchDate dateTime Date corresponding with the prior CreditWatch value in spRatingData table or spAssessmentData table along with the timestamp; time zone is in Eastern Time (ET).
priorOutlook string(100) An S&P Global Ratings Outlook assesses the potential direction of a long-term credit rating over the intermediate term (typically six months to two years). In determining a rating Outlook, consideration is given to any changes in the economic and/or fundamental business conditions. An Outlook is not necessarily a precursor of a rating change or future CreditWatch action. This field provides the prior Outlook value.
priorOutlookDate dateTime Date corresponding with the prior Outlook value in spRatingData table or spAssessmentData table along with the timestamp; time zone is in Eastern Time (ET).
priorRatingDate dateTime Date corresponding with the prior rating symbol value in spRatingData table or date corresponding with the prior assessment symbol value in spAssessmentData table along with the timestamp; time zone is in Eastern Time (ET).
priorRatingSymbolValue string(50) An S&P Global Ratings credit rating is a forward-looking opinion about the creditworthiness of an obligor. This field provides the most prior rating for an entity, program, or security.
ratingActionWord string(50) Indicates if the rating action was disseminated through the feed due to a New Rating, Upgrade, or Downgrade rating.
ratingDebtTypeCode string(10) Unique identifier of the rating organization debt type. Note that this only applies to entity ratings, and is Null for instrument and security ratings.
ratingDebtTypeName string(60) Descriptive name for ratings debt type code.
ratingDetailId long S&P unique identifier for a rating record. Uniqueness is determined using a combination of symbol value, org debt type, rating type, and rating/CreditWatch/Outlook date.
ratingQualifier string(30) The qualifier subscript for the rating, such as L, pi, etc. A rating may or may not have a qualifier. For a list of qualifiers and their meaning, see S&P Global Ratings' ratings definitions on www.standardandpoors.com.
ratingSortOrder long This field helps in sorting the ratings in the highest order of creditworthiness.
ratingSymbolValue string(20) Combines the rating symbol, rating qualifier, regulatory qualifier, and rating suffixes together in one field.
ratingTypeCode string(10) Code identifying the type of ratings.
ratingTypeName string(60) Descriptive name for ratings type.
regulatoryIndicator string(300) This field provides identifiers used for regulatory related purposes. For a list of regulatory identifiers, see section VII. OTHER IDENTIFIERS in S&P Global Ratings' ratings definitions on www.standardandpoors.com
regulatoryQualifier string(300) This field provides identifiers used for regulatory related purposes. For a list of regulatory qualifier, see section VII. OTHER IDENTIFIERS in S&P Global Ratings' ratings definitions on www.standardandpoors.com
responsibleCreditRatingAgencyLEIId string(200) Legal Entity Identifier (LEI) code for the EU credit rating agency responsible for the rating.
responsibleCreditRatingAgencyName string(200) Legal Entity Name of the EU credit rating agency responsible for the rating.
33 rows of 33 total
API Open API Specification