Type IssuerProfile
Type category Entity
Description This table provides detailed information linked to unique proprietary ID assigned by the S&P Global Ratings to describe each issuer.
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
analystId RatingAnalyst[] Unique and proprietary S&P Global Ratings identifier for a Rating Analyst.
cins string(10)[200] CUSIP International Numbering System identifier assigned by the CUSIP Global Services.
ciqCompanyId long(10000000000) The value represents the unique identifier for a CIQ Compant ID
companyId long(1000000) Unique and proprietary S&P Global Ratings identifier for each organization (issuer).
countryCode string(3) The 3-digit ISO country code where the entity domicile of incorporation is located; links to the spRatingCountry table.
countryCurrencyCode string(3) Currency Code of the Issuer's country.
countryName string Name of the issuer's country.
currencyName string(60) Name of the currency represented by 3 letter currency code.
cusip string(6)[200] (CUSIP) Committee for Uniform Security Identification Procedures identifier assigned by CUSIP Global Services.
entityLegalName string(450) The most recent legal entity name.
entityName string(450) The most recent published entity name.
entityShortName string(300) The short entity name.
giFlag boolean Companies under Global Issuers
gics string(8)[200] Identifier based on GICS which is a four-tiered, hierarchical industry classification system. The four tiers are: Sectors, Industry Groups, Industries and Sub-Industries.
isActive boolean isActive
keyInstn long(1000000000) The value represents the unique identifier for a MI company Id.
lei string(20)[500] Legal Entity Identifier (LEI) code for the issuer.
naic string(10)[200] North American Industry Classification System. This links to the spRatingNaicsCode reference table.
parentEntityId long(1000000) The S&P Global Ratings Entity ID for the Parent Company of a Given Entity.
parentEntityLegalName string(450) The latest published legal name of parent company.
pfFlag boolean Companies under Public Finance
primarySectorSubSector SectorSubSector[] Sector code refers to Primary the division of the market by type of issuer, for example, Corporates, Structured Finance, and Public Finance. Subsector code refers to the subdivision of the Corporates and Structured Finance sectors. Subsectors categorize the sector. For example, included under the Structured Finance sector, are the following subsectors: Asset-Backed Securities (ABS), Residential Mortgage-Backed Securities (RMBS), and Commercial Mortgage-Backed Securities (CMBS).
region RegionMapping[] The region code where the entity domicile of incorporation is located; links to the spRatingRegion reference table.
secondarySectorSubSector SectorSubSector[] Sector code refers to secondary the division of the market by type of issuer
sfFlag boolean Companies under Structured Finance
sic string(4)[200] Standard Industrial Classification (SIC) codes are four digit numerical codes assigned by the U.S. government that categorize the industries to which companies belong, while also organizing industries by their business activities.
stateCode string(2) The state code for the entity primary headquarters; links to the spRatingState table. Note that the state is only available for entities in the U.S. and Canada.
stateName string Name of the state code.
ticker ExchangeTicker[] A ticker is a symbol, a unique combination of letters and numbers that represent a particular stock or security listed on an exchange. Stock exchange that the business is traded on.
ultimateParentEntityId long(1000000) The S&P Global Ratings Entity ID for the Ultimate Parent Company of a Given Entity.
ultimateParentEntityLegalName string(450) The latest published legal name of ultimate parent company.
32 rows of 32 total
API Open API Specification