Dictionary

Equity

The data dictionary and definitions for Equity


Fields

ParameterDescription
equity_idThe Aiera-unique identifier for the associated equity
nameThe official name of the equity/company
common_nameThe common name of the equity (i.e. Google vs Alphabet)
local_tickerThe ticker on the local exchange for the associated equity
micThe current status of this event [active or deleted]
bloomberg_tickerThe Bloomberg identifier for the associated equity
isinThe ISIN for the associated equity
permidThe PermID for the associated equity
ricThe RIC for the associated equity
gics_sectorThe GICS sector name for the equity
gics_sub_sectorThe GICS sub-sector name for the equity
primary_equityWhether the equity is primary for the Aiera-unique company
statusInternal status of the equity (one of "active", "inactive", "delisted", "merger", or "suspended")
company_metadata *JSON object composed of company metadata, like names, urls, etc.

Possibles

company url_type

OptionDescription
filingsURL for company filings
homeURL for company's homepage
ir_eventsURL for company's investor relation events
ir_homeURL for company's investor relations homepage
ir_newsURL for company's investor relation news
logo_iconURL for company's logo image
youtubeURL for company's official YouTube page

company_metadata

{
  "company_metadata": {
    "company_id": 1,
    "common_name": "Amazon",
    "legal_name": "Amazon.com Inc",
    "incorporated_country_code": "US",
    "domiciled_country_code": "US",
    "urls": [
      {
        "url": "https://s3.amazonaws.com/assets.aiera.com/assets/manual-override-1-1723048553.9238625.png",
        "url_type": "logo_icon"
      },
      {
        "url": "https://ir.aboutamazon.com/overview/default.aspx",
        "url_type": "ir_home"
      },
      {
        "url": "https://ir.aboutamazon.com/events/default.aspx",
        "url_type": "ir_events"
      },
      {
        "url": "https://press.aboutamazon.com/press-release-archive",
        "url_type": "ir_news"
      },
      {
        "url": "https://www.amazon.com/",
        "url_type": "home"
      },
      {
        "url": "https://ir.aboutamazon.com/sec-filings/default.aspx",
        "url_type": "filings"
      },
      {
        "url": "https://www.youtube.com/user/amazon",
        "url_type": "youtube"
      }
    ]
  }
}
Previous
Transcript