Type FinancialInstanceDetails
Type category Entity
Description A company's financials are collected on a period by period basis. A Financial Period is a defined period in time. A company that reports financial statement data will most likely have multiple period. Also it contains metadata for a given instance
Timeseries key id, updDateavailable from 2026-06-19
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
timeline updDate dateTime* =< >= Last modification date and time of a physical row
accessionNumber string A unique SEC or SEDAR identifier that identifies a document
accountsReceivableTurnover decimal{34,6} Shows how efficiently a company collects payments from its customers. Calculated as net credit sales divided by average accounts receivable.
accountsReceivableTurnoverCurrencyISO string(3) Currency ISO code for Accounts Receivable Turnover
amendmentFlag long Indicates that this instance reflects an amendment filing
avgCashConversionCycle decimal{34,6} The time it takes for a company to convert its investments in inventory and other resources into cash from sales. Calculated as DIO + DSO - DPO.
avgCashConversionCycleCurrencyISO string(3) Currency ISO code for Avg Cash Conversion Cycle
avgDaysInventoryOutstanding decimal{34,6} The average number of days it takes a company to sell its inventory.
avgDaysInventoryOutstandingCurrencyISO string(3) Currency ISO code for Avg Days Inventory Outstanding
avgDaysPayableOutstanding decimal{34,6} The average number of days it takes a company to pay its suppliers after receiving goods or services.
avgDaysPayableOutstandingCurrencyISO string(3) Currency ISO code for Avg Days Payable Outstanding
avgDaysSalesOutstanding decimal{34,6} The average number of days it takes a company to collect payment from customers after making a sale.
avgDaysSalesOutstandingCurrencyISO string(3) Currency ISO code for Avg Days Sales Outstanding
link bsRestatementType FinancialRestatementType The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated)
bsRestatementTypeId long(-2147483648,2147483647) The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated)
calendarQuarter long The calendar quarter of the audit
calendarYear long The calendar year of the audit
capitalExpenditure decimal{34,6} Money spent by a company to buy, maintain, or improve its long-term assets like buildings or machinery.
capitalExpenditureCurrencyISO string(3) Currency ISO code for Capital Expenditure
cashFromFinancing decimal{34,6} Cash a company receives from raising capital (like issuing stock or debt) or pays out (like repaying debt).
cashFromFinancingCurrencyISO string(3) Currency ISO code for Cash from Financing
cashFromInvesting decimal{34,6} Cash used for or earned from investments in things like buying or selling assets, or acquiring businesses.
cashFromInvestingCurrencyISO string(3) Currency ISO code for Cash from Investing
cashFromOperations decimal{34,6} The cash a company generates from its normal business operations, like selling goods or services.
cashFromOperationsCurrencyISO string(3) Currency ISO code for Cash from Ops
cashFromOperationsToCurrentLiabilities decimal{34,6} Measures how well a company can cover its current liabilities with the cash it generates from operations.
cashFromOperationsToCurrentLiabilitiesCurrencyISO string(3) Currency ISO code for Cash from Operaions to Current Liabilities
link cfRestatementType FinancialRestatementType The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated)
cfRestatementTypeId long(-2147483648,2147483647) The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated)
changeInNetWorkingCapital decimal{34,6} The change in a company's current assets minus current liabilities, showing how much short-term liquidity changed.
changeInNetWorkingCapitalCurrencyISO string(3) Currency ISO code for Change in Net Working Capital
filter_list ciqCompanyId long = Unique identifier denoting a company
commonDividendsPaid decimal{34,6} The amount of money paid to common shareholders as dividends.
commonDividendsPaidCurrencyISO string(3) Currency ISO code for Common Dividends Paid
currencyConversionPeriodEndDate date The date of the currency exchange rate used for conversions
currentPortionOfLeases decimal{34,6} The portion of lease obligations that must be paid within the next year.
currentPortionOfLeasesCurrencyISO string(3) Currency ISO code for Current Portion of Leases
currentPortionOfLongTermDebt decimal{34,6} The portion of long-term debt that needs to be repaid within the next year.
currentPortionOfLongTermDebtCurrencyISO string(3) Currency ISO code for Current Portion of LT Debt
currentPortionOfLongTermDebtToCapitalLeases decimal{34,6} The portion of long-term debt or capital lease obligations that must be repaid within the next year.
currentPortionOfLongTermDebtToCapitalLeasesCurrencyISO string(3) Currency ISO code for Current Portion of LT Debt/Capital Leases
currentRatio decimal{34,6} Measures a company's ability to pay short-term obligations with its short-term assets. Calculated as current assets divided by current liabilities.
currentRatioCurrencyISO string(3) Currency ISO code for Current Ratio
depreciationAndAmortizationTotal decimal{34,6} The reduction in value of physical assets (depreciation) and intangible assets (amortization) over time.
depreciationAndAmortizationTotalCurrencyISO string(3) Currency ISO code for Depreciation & Amortization Total
dilutedEPSBeforeExtra1YearGrowthRate decimal{34,6} The percentage change in diluted earnings per share (EPS) before extraordinary items over one year, showing the change in per-share profit, excluding one-time events.
dilutedEPSBeforeExtra1YearGrowthRateCurrencyISO string(3) Currency ISO code for Diluted EPS before Extra 1 Yr GR
dilutedEPSBeforeExtra2YearCAGR decimal{34,6} The average annual growth rate of diluted earnings per share (EPS) before extraordinary items over two years, showing the change in per-share profit, excluding one-time events.
dilutedEPSBeforeExtra2YearCAGRCurrencyISO string(3) Currency ISO code for Diluted EPS before Extra 2 Yr CAGR
dilutedEPSBeforeExtra3YearCAGR decimal{34,6} The average annual growth rate of diluted earnings per share (EPS) before extraordinary items over three years, showing the change in per-share profit, excluding one-time events.
dilutedEPSBeforeExtra3YearCAGRCurrencyISO string(3) Currency ISO code for Diluted EPS before Extra 3 Yr CAGR
dilutedEPSBeforeExtra5YearCAGR decimal{34,6} The average annual growth rate of diluted earnings per share (EPS) before extraordinary items over five years, showing the change in per-share profit, excluding one-time events.
dilutedEPSBeforeExtra5YearCAGRCurrencyISO string(3) Currency ISO code for Diluted EPS before Extra 5 Yr CAGR
dilutedEPSExcludingExtraItems decimal{34,6} Earnings per share available to each share of common stock, excluding one-time or unusual items.
dilutedEPSExcludingExtraItemsCurrencyISO string(3) Currency ISO code for Diluted EPS
documentDetailsId long Unique identifier for a combination of documentID and PEO date
documentId string A unique CIQ identifier that identifies the source document used for this update
filter_list documentPeriod date = The period date of the financial report
documentType long documentType
earningsFromContinuingOperation decimal{34,6} Profit from regular, ongoing business activities, excluding sold or shut down parts of the business.
earningsFromContinuingOperationCurrencyISO string(3) Currency ISO code for Earnings from Cont Ops
earningsFromContinuingOperations1YearGrowthRate decimal{34,6} The percentage change in earnings from continuing operations over one year, showing how the company's ongoing operations have performed.
earningsFromContinuingOperations1YearGrowthRateCurrencyISO string(3) Currency ISO code for Earnings from Continuing Ops 1 Yr GR
earningsFromContinuingOperations2YearCAGR decimal{34,6} The average annual growth rate of earnings from continuing operations over two years, showing the performance of a company's ongoing operations.
earningsFromContinuingOperations2YearCAGRCurrencyISO string(3) Currency ISO code for Earnings from Continuing Ops 2 Yr CAGR
earningsFromContinuingOperations3YearCAGR decimal{34,6} The average annual growth rate of earnings from continuing operations over three years, showing the performance of a company's ongoing operations.
earningsFromContinuingOperations3YearCAGRCurrencyISO string(3) Currency ISO code for Earnings from Continuing Ops 3 Yr CAGR
earningsFromContinuingOperations5YearCAGR decimal{34,6} The average annual growth rate of earnings from continuing operations over five years, showing the performance of a company's ongoing operations.
earningsFromContinuingOperations5YearCAGRCurrencyISO string(3) Currency ISO code for Earnings from Continuing Ops 5 Yr CAGR
earningsFromContinuingOperationsMargin decimal{34,6} The percentage of revenue that comes from the company's ongoing, regular operations. Excludes income from discontinued operations or extraordinary items.
earningsFromContinuingOperationsMarginCurrencyISO string(3) Currency ISO code for Earnings from Continuing Ops Margin
ebit decimal{34,6} Profit before interest and taxes; used to assess operational efficiency.
ebit1YearGrowthRate decimal{34,6} The percentage change in EBIT (earnings before interest and taxes) over one year, indicating how operating income has grown or shrunk.
ebit1YearGrowthRateCurrencyISO string(3) Currency ISO code for EBIT 1 Yr GR
ebit2YearCAGR decimal{34,6} The average annual growth rate of EBIT (earnings before interest and taxes) over two years, reflecting growth in operating income.
ebit2YearCAGRCurrencyISO string(3) Currency ISO code for EBIT 2 Yr CAGR
ebit3YearCAGR decimal{34,6} The average annual growth rate of EBIT (earnings before interest and taxes) over three years, reflecting growth in operating income.
ebit3YearCAGRCurrencyISO string(3) Currency ISO code for EBIT 3 Yr CAGR
ebit5YearCAGR decimal{34,6} The average annual growth rate of EBIT (earnings before interest and taxes) over five years, reflecting growth in operating income.
ebit5YearCAGRCurrencyISO string(3) Currency ISO code for EBIT 5 Yr CAGR
ebitCurrencyISO string(3) Currency ISO code for EBIT
ebitMargin decimal{34,6} The percentage of revenue left after covering operating costs, excluding interest and taxes. It measures operating efficiency.
ebitMarginCurrencyISO string(3) Currency ISO code for EBIT Margin
ebita decimal{34,6} Profit before interest, taxes, and amortization; similar to EBITDA but without depreciation included.
ebita1YearGrowthRate decimal{34,6} The percentage change in EBITA (earnings before interest, taxes, and amortization) over one year, showing how core operating profits have changed.
ebita1YearGrowthRateCurrencyISO string(3) Currency ISO code for EBITA 1 Yr GR
ebita2YearCAGR decimal{34,6} The average annual growth rate of EBITA (earnings before interest, taxes, and amortization) over two years, indicating changes in core operating profitability.
ebita2YearCAGRCurrencyISO string(3) Currency ISO code for EBITA 2 Yr CAGR
ebita3YearCAGR decimal{34,6} The average annual growth rate of EBITA (earnings before interest, taxes, and amortization) over three years, indicating changes in core operating profitability.
ebita3YearCAGRCurrencyISO string(3) Currency ISO code for EBITA 3 Yr CAGR
ebita5YearCAGR decimal{34,6} The average annual growth rate of EBITA (earnings before interest, taxes, and amortization) over five years, indicating changes in core operating profitability.
ebita5YearCAGRCurrencyISO string(3) Currency ISO code for EBITA 5 Yr CAGR
ebitaCurrencyISO string(3) Currency ISO code for EBITA
ebitaMargin decimal{34,6} The percentage of revenue left after covering operating costs but excluding interest, taxes, and amortization. Similar to EBITDA but without depreciation.
ebitaMarginCurrencyISO string(3) Currency ISO code for EBITA Margin
ebitda decimal{34,6} Profit before interest, taxes, depreciation, and amortization; a measure of operating performance.
ebitda1YearGrowthRate decimal{34,6} The percentage change in EBITDA (earnings before interest, taxes, depreciation, and amortization) over one year, reflecting changes in operational profitability.
ebitda1YearGrowthRateCurrencyISO string(3) Currency ISO code for EBITDA 1 Yr GR
ebitda2YearCAGR decimal{34,6} The average annual growth rate of EBITDA (earnings before interest, taxes, depreciation, and amortization) over two years, showing operational profit growth.
ebitda2YearCAGRCurrencyISO string(3) Currency ISO code for EBITDA 2 Yr CAGR
ebitda3YearCAGR decimal{34,6} The average annual growth rate of EBITDA (earnings before interest, taxes, depreciation, and amortization) over three years, showing operational profit growth.
ebitda3YearCAGRCurrencyISO string(3) Currency ISO code for EBITDA 3 Yr CAGR
ebitda5YearCAGR decimal{34,6} The average annual growth rate of EBITDA (earnings before interest, taxes, depreciation, and amortization) over five years, showing operational profit growth.
ebitda5YearCAGRCurrencyISO string(3) Currency ISO code for EBITDA 5 Yr CAGR
ebitdaCurrencyISO string(3) Currency ISO code for EBITDA
ebitdaMargin decimal{34,6} The percentage of revenue left after covering operational costs, excluding interest, taxes, depreciation, and amortization. It shows a company's operating profitability.
ebitdaMarginCurrencyISO string(3) Currency ISO code for EBITDA Margin
ebitdar decimal{34,6} Profit before interest, taxes, depreciation, amortization, and rent expenses; used in industries with large rent costs.
ebitdarCurrencyISO string(3) Currency ISO code for EBITDAR
ebtExclUnusualItems decimal{34,6} Profit before taxes, excluding one-time or unusual events.
ebtExclUnusualItemsCurrencyISO string(3) Currency ISO code for EBT Excl Unusal Items
ebtInclUnusualItems decimal{34,6} Profit before taxes, including one-time or unusual events.
ebtInclUnusualItemsCurrencyISO string(3) Currency ISO code for EBT Incl Unusual Items
effectiveTaxRate decimal{34,6} The percentage of earnings that a company pays in taxes, calculated as tax expenses divided by pre-tax earnings.
effectiveTaxRateCurrencyISO string(3) Currency ISO code for Effective Tax Rate
filingDate dateTime Date the source document was filed
link financialDataSet FinancialDataSetType Source of Data representing inhouse collection, vendor data etc.,
financialDataSetId long(-2147483648,2147483647) Source of Data representing inhouse collection, vendor data etc.,
filter_list financialInstanceId long* = Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD
financialPeriodId long The unique identifier for a company-to-reporting period relationship
fiscalChainSeriesId long The fiscal chain series is used to flag fiscal year changes. The value increments each time a fiscal year change occurs.
filter_list fiscalQuarter long = The fiscal quarter for this financial period
filter_list fiscalYear long = The fiscal year for this financial period
fixedAssetTurnover decimal{34,6} Measures how efficiently a company uses its fixed assets (like buildings and equipment) to generate sales.
fixedAssetTurnoverCurrencyISO string(3) Currency ISO code for Fixed Asset Turnover
fixedRateDebt decimal{34,6} Debt with a fixed interest rate that does not change over the life of the loan.
fixedRateDebtCurrencyISO string(3) Currency ISO code for Fixed Rate Debt
formTypeId long The Type Id identifying the from type (1 = Annual; 2= Other than Annual)
formTypeText string The Type Id identifying the from type (1 = Annual; 2= Other than Annual)
fullTimeEmployees decimal{34,6} The number of people working for the company on a full-time basis.
fullTimeEmployeesCurrencyISO string(3) Currency ISO code for Full Time Employees
grossMargin decimal{34,6} The percentage of revenue that exceeds the cost of goods sold. It indicates how much profit is made after covering production costs.
grossMarginCurrencyISO string(3) Currency ISO code for Gross Margin
grossProfit decimal{34,6} The money left after subtracting the cost of making or buying the products sold by the company.
grossProfit1YearGrowthRate decimal{34,6} The percentage change in gross profit (revenue minus cost of goods sold) over one year, indicating how efficiently the company is managing its costs.
grossProfit1YearGrowthRateCurrencyISO string(3) Currency ISO code for Gross Profit 1 Yr GR
grossProfit2YearCAGR decimal{34,6} The average annual growth rate of gross profit (revenue minus cost of goods sold) over two years, indicating efficiency changes in managing costs.
grossProfit2YearCAGRCurrencyISO string(3) Currency ISO code for Gross Profit 2 Yr CAGR
grossProfit3YearCAGR decimal{34,6} The average annual growth rate of gross profit (revenue minus cost of goods sold) over three years, indicating efficiency changes in managing costs.
grossProfit3YearCAGRCurrencyISO string(3) Currency ISO code for Gross Profit 3 Yr CAGR
grossProfit5YearCAGR decimal{34,6} The average annual growth rate of gross profit (revenue minus cost of goods sold) over five years, indicating efficiency changes in managing costs.
grossProfit5YearCAGRCurrencyISO string(3) Currency ISO code for Gross Profit 5 Yr CAGR
grossProfitCurrencyISO string(3) Currency ISO code for Gross Profit
hasConsolidatedFinancialsFlag long hasConsolidatedFinancialsFlag
hasUnConsolidatedFinancialsFlag long hasUnConsolidatedFinancialsFlag
incomeTaxExpense decimal{34,6} The amount a company pays in taxes on its earnings.
incomeTaxExpenseCurrencyISO string(3) Currency ISO code for Income Tax Expense
link instanceType FinancialInstanceType The TypeId identifying the instance type (e.g. Press Release, Original Instance, Encore)
instanceTypeId long(-2147483648,2147483647) The TypeId identifying the instance type (e.g. Press Release, Original Instance, Encore)
inventoryTurnover decimal{34,6} Indicates how efficiently a company sells and replaces its inventory. Calculated as cost of goods sold divided by average inventory.
inventoryTurnoverCurrencyISO string(3) Currency ISO code for Inventory Turnover
link isRestatementType FinancialRestatementType The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated)
isRestatementTypeId long(-2147483648,2147483647) The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated)
issuanceOfCommonStock decimal{34,6} The money a company receives from selling new shares of common stock.
issuanceOfCommonStockCurrencyISO string(3) Currency ISO code for Issuance of Common Stock
latestFilingForInstanceFlag long The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the 'best' instance to use if you are trying to select between these two instances.
latestForFinancialPeriodFlag long A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. The instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release). To view the latest and best source for a company, always screen for latestForFinancialPeriodFlag=1.
latestUnConsolidatedInstanceForFilingDateFlag long The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the 'best' instance to use if you are trying to select between these two instances.
latestUnConsolidatedInstanceForPeriodFlag long A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. The instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release). To view the latest and best source for a company, always screen for latestForFinancialPeriodFlag=1.
leveredFreeCashFlowMargin decimal{34,6} The percentage of revenue left as free cash flow after interest payments have been made on the company's debt.
leveredFreeCashFlowMarginCurrencyISO string(3) Currency ISO code for Levered Free Cash Flow Margin
longTermDebt decimal{34,6} The amount of debt that the company owes that doesn't need to be repaid within one year.
longTermDebtCurrencyISO string(3) Currency ISO code for Long Term Debt
longTermDebtIncludingCapitalizedLeases decimal{34,6} The total value of debt and capital lease obligations that are due beyond one year.
longTermDebtIncludingCapitalizedLeasesCurrencyISO string(3) Currency ISO code for Long Term Debt (Incl. Cap. Leases)
longTermDebtIssued decimal{34,6} The amount of new long-term debt (due after one year) that a company has borrowed.
longTermDebtIssuedCurrencyISO string(3) Currency ISO code for Long Term Debt Issued
longTermDebtToCapital decimal{34,6} A ratio comparing long-term debt to total capital (debt + equity), showing how much of a company's capital comes from long-term debt.
longTermDebtToCapitalCurrencyISO string(3) Currency ISO code for LT Debt/Capital
longTermDebtToEquity decimal{34,6} A ratio that compares a company's long-term debt to its shareholders' equity, showing the balance of long-term debt financing.
longTermDebtToEquityCurrencyISO string(3) Currency ISO code for LT Debt/Equity
netChangeInCash decimal{34,6} The overall increase or decrease in the company's cash balance during a period.
netChangeInCashCurrencyISO string(3) Currency ISO code for Net Change in Cash
netDebt decimal{34,6} The total amount of a company's debt after subtracting its cash and short-term investments.
netDebtCurrencyISO string(3) Currency ISO code for Net Debt
netDebtIssued decimal{34,6} The total amount of new debt issued minus the amount of debt repaid during the period.
netDebtIssuedCurrencyISO string(3) Currency ISO code for Net Debt Issued
netDebtToEBITDALessCapex decimal{34,6} A measure of how many years it would take to pay off net debt using earnings before interest, taxes, depreciation, and amortization minus capital expenditures.
netDebtToEBITDALessCapexCurrencyISO string(3) Currency ISO code for Net Debt/(EBITDA-CAPEX)
netDebtToEbitda decimal{34,6} A ratio that shows how many years it would take to pay off all net debt using the company's earnings before interest, taxes, depreciation, and amortization.
netDebtToEbitdaCurrencyISO string(3) Currency ISO code for Net Debt/EBITDA
netIncome decimal{34,6} The total profit after all expenses are paid.
netIncome1YearGrowthRate decimal{34,6} The percentage change in net income over one year, reflecting the overall change in profitability after all expenses, interest, and taxes.
netIncome1YearGrowthRateCurrencyISO string(3) Currency ISO code for Net Income 1 Yr GR
netIncome2YearCAGR decimal{34,6} The average annual growth rate of net income over two years, reflecting changes in overall profitability after expenses, interest, and taxes.
netIncome2YearCAGRCurrencyISO string(3) Currency ISO code for Net Income 2 Yr CAGR
netIncome3YearCAGR decimal{34,6} The average annual growth rate of net income over three years, reflecting changes in overall profitability after expenses, interest, and taxes.
netIncome3YearCAGRCurrencyISO string(3) Currency ISO code for Net Income 3 Yr CAGR
netIncome5YearCAGR decimal{34,6} The average annual growth rate of net income over five years, reflecting changes in overall profitability after expenses, interest, and taxes.
netIncome5YearCAGRCurrencyISO string(3) Currency ISO code for Net Income 5 Yr CAGR
netIncomeAvailableForCommonMargin decimal{34,6} The percentage of revenue left as profit available specifically for common shareholders after all expenses, taxes, and interest.
netIncomeAvailableForCommonMarginCurrencyISO string(3) Currency ISO code for Net Income Available for Common Margin
netIncomeCurrencyISO string(3) Currency ISO code for Net Income
netIncomeMargin decimal{34,6} The percentage of revenue that remains as profit after all expenses, taxes, and interest have been deducted.
netIncomeMarginCurrencyISO string(3) Currency ISO code for Net Income Margin
netIncomeToCommonExcludingExtraItems decimal{34,6} Net income attributable to common shareholders, excluding one-time or unusual items.
netIncomeToCommonExcludingExtraItemsCurrencyISO string(3) Currency ISO code for NI to Common Excl
netIncomeToCommonIncludingExtraItems decimal{34,6} Net income attributable to common shareholders, including one-time or unusual items.
netIncomeToCommonIncludingExtraItemsCurrencyISO string(3) Currency ISO code for NI to Common Incl
netIncomeToCompany decimal{34,6} The total profit left after all expenses, interest, and taxes are subtracted; also known as the "bottom line."
netIncomeToCompanyCurrencyISO string(3) Currency ISO code for Net Income to Company
netInterestExpense decimal{34,6} The cost of borrowing money (interest paid minus interest earned).
netInterestExpenseCurrencyISO string(3) Currency ISO code for Net Interest Expense
netPropertyPlantAndEquipment decimal{34,6} The value of a company's long-term assets, such as buildings, machinery, and equipment, minus depreciation.
netPropertyPlantAndEquipmentCurrencyISO string(3) Currency ISO code for Net Property, Plant & Equipment
nonStandardLengthFlag long* Flag indicating that the period length for this collection is not a standard length. It can be used to filter out nonstandard periods around a Fiscal Year end change.
normalizedNetIncome1YearGrowthRate decimal{34,6} The percentage change in normalized net income (adjusted for unusual or one-time items) over one year, showing a clearer picture of core profitability changes.
normalizedNetIncome1YearGrowthRateCurrencyISO string(3) Currency ISO code for Normalized Net Income 1 Yr GR
normalizedNetIncome2YearCAGR decimal{34,6} The average annual growth rate of normalized net income (adjusted for unusual or one-time items) over two years, providing a clearer picture of core profit growth.
normalizedNetIncome2YearCAGRCurrencyISO string(3) Currency ISO code for Normalized Net Income 2 Yr CAGR
normalizedNetIncome3YearCAGR decimal{34,6} The average annual growth rate of normalized net income (adjusted for unusual or one-time items) over three years, providing a clearer picture of core profit growth.
normalizedNetIncome3YearCAGRCurrencyISO string(3) Currency ISO code for Normalized Net Income 3 Yr CAGR
normalizedNetIncome5YearCAGR decimal{34,6} The average annual growth rate of normalized net income (adjusted for unusual or one-time items) over five years, providing a clearer picture of core profit growth.
normalizedNetIncome5YearCAGRCurrencyISO string(3) Currency ISO code for Normalized Net Income 5 Yr CAGR
normalizedNetIncomeMargin decimal{34,6} The percentage of revenue left as profit after adjusting for one-time items, giving a clearer picture of a company's recurring profitability.
normalizedNetIncomeMarginCurrencyISO string(3) Currency ISO code for Normalized Net Income Margin
operatingIncome decimal{34,6} Profit from regular business activities after subtracting operating expenses but before interest and taxes.
operatingIncomeCurrencyISO string(3) Currency ISO code for Operating Income
otherOperatingExpenseTotal decimal{34,6} Total costs of running a business not directly tied to making products, like administrative salaries and rent.
otherOperatingExpenseTotalCurrencyISO string(3) Currency ISO code for Other Operating Expense Total
link periodType FinancialPeriodType Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD
periodTypeId long(-2147483648,2147483647) Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD
pressReleaseFlag long Indicates if the document is from Preliminary earnings release. This information is usually released by the company prior to the official filing or release of data.
quickRatio decimal{34,6} A stricter version of the current ratio that excludes inventory. It shows a company's ability to pay short-term obligations with its most liquid assets (cash, receivables).
quickRatioCurrencyISO string(3) Currency ISO code for Quick Ratio
reportedCurrencyISO string(3) ISO Code for reported currency
reportedCurrencyId long Code for reported currency
repurchaseOfCommonStock decimal{34,6} The money a company spends to buy back its own shares from the market.
repurchaseOfCommonStockCurrencyISO string(3) Currency ISO code for Repurchase of Common Stock
returnOnAssets decimal{34,6} Measures how efficiently a company uses its assets to generate profit. Calculated as net income divided by total assets.
returnOnAssetsCurrencyISO string(3) Currency ISO code for Return on Assets
returnOnCapital decimal{34,6} Indicates how well a company generates profit from its capital (debt + equity). Calculated as net income divided by total capital.
returnOnCapitalCurrencyISO string(3) Currency ISO code for Return on Capital
returnOnCommonEquity decimal{34,6} Measures the return on equity available specifically to common shareholders. Similar to Return on Equity but focuses on common stockholders.
returnOnCommonEquityCurrencyISO string(3) Currency ISO code for Return on Common Equity
returnOnEquity decimal{34,6} Shows how much profit a company generates from shareholders' equity. Calculated as net income divided by shareholders' equity.
returnOnEquityCurrencyISO string(3) Currency ISO code for Return on Equity
searchedForUnusualItemsTypeId long 0 for no, 1 for yes, 2 for not sure
seniorUnsecuredBondsAndNotes decimal{34,6} The total value of senior unsecured bonds and notes that a company has issued, which take priority over other unsecured debts in repayment.
seniorUnsecuredBondsAndNotesCurrencyISO string(3) Currency ISO code for Senior Unsecured Bonds and Notes
sgaMargin decimal{34,6} The percentage of sales that is spent on Selling, General & Administrative expenses (SG&A), such as marketing, salaries, and office expenses.
sgaMarginCurrencyISO string(3) Currency ISO code for SG&A Margin
shortTermDebtIssued decimal{34,6} The amount of new short-term debt (due within one year) that a company has borrowed.
shortTermDebtIssuedCurrencyISO string(3) Currency ISO code for Short Term Debt Issued
totalAssetTurnover decimal{34,6} Measures how efficiently a company uses its total assets to generate sales. Calculated as sales divided by total assets.
totalAssetTurnoverCurrencyISO string(3) Currency ISO code for Total Asset Turnover
totalAssets decimal{34,6} The total value of everything a company owns (both current and long-term assets).
totalAssetsCurrencyISO string(3) Currency ISO code for Total Assets
totalBankDebt decimal{34,6} The total amount of loans a company has borrowed from banks.
totalBankDebtCurrencyISO string(3) Currency ISO code for Total Bank Debt
totalCashAndShortTermInvestments decimal{34,6} The total value of cash and short-term investments that the company holds, which can be quickly converted into cash.
totalCashAndShortTermInvestmentsCurrencyISO string(3) Currency ISO code for Total Cash & ST Investments
totalCommercialPaper decimal{34,6} The total value of short-term, unsecured debt issued by a company, typically to cover immediate financial obligations like payroll or inventory.
totalCommercialPaperCurrencyISO string(3) Currency ISO code for Total Commercial Paper
totalCommonEquity decimal{34,6} The total value of assets that shareholders own after all liabilities are subtracted.
totalCommonEquityCurrencyISO string(3) Currency ISO code for Total Common Equity
totalCurrentAssets decimal{34,6} The total value of all assets that a company expects to convert into cash within one year (e.g., cash, inventory).
totalCurrentAssetsCurrencyISO string(3) Currency ISO code for Total Current Assets
totalCurrentLiabilities decimal{34,6} The total amount of money a company owes that must be paid within one year (e.g., short-term debt, bills).
totalCurrentLiabilitiesCurrencyISO string(3) Currency ISO code for Total Current Liabilities
totalDebt decimal{34,6} The sum of all short-term and long-term debt owed by the company.
totalDebtCurrencyISO string(3) Currency ISO code for Total Debt
totalDebtIssued decimal{34,6} The total amount of both short-term and long-term debt that a company has borrowed.
totalDebtIssuedCurrencyISO string(3) Currency ISO code for Total Debt Issued
totalDebtOutstanding decimal{34,6} The total amount of all types of debt that a company currently owes, including loans, bonds, and leases.
totalDebtOutstandingCurrencyISO string(3) Currency ISO code for Total Debt Outstanding
totalDebtRepaid decimal{34,6} The total amount of debt a company has paid back during the period.
totalDebtRepaidCurrencyISO string(3) Currency ISO code for Total Debt Repaid
totalDebtToCapital decimal{34,6} A ratio comparing a company's total debt to its total capital (debt + equity). It measures how leveraged the company is.
totalDebtToCapitalCurrencyISO string(3) Currency ISO code for Total Debt/Capital
totalDebtToEBITDALessCapex decimal{34,6} A measure of how leveraged a company is when comparing its total debt to its earnings minus capital expenditures.
totalDebtToEBITDALessCapexCurrencyISO string(3) Currency ISO code for Total Debt/(EBITDA-CAPEX)
totalDebtToEbitda decimal{34,6} A ratio comparing total debt to a company's EBITDA, indicating how leveraged the company is.
totalDebtToEbitdaCurrencyISO string(3) Currency ISO code for Total Debt/EBITDA
totalDebtToEquity decimal{34,6} A ratio that compares a company's total debt to its shareholders' equity. It shows how much of the company is financed by debt versus equity.
totalDebtToEquityCurrencyISO string(3) Currency ISO code for Total Debt/Equity
totalDividendsPaid decimal{34,6} The total amount of money a company paid out in dividends, including to common and preferred shareholders.
totalDividendsPaidCurrencyISO string(3) Currency ISO code for Total Dividends Paid
totalEquity decimal{34,6} The total value of ownership in the company, including common and preferred equity.
totalEquityCurrencyISO string(3) Currency ISO code for Total Equity
totalLeaseLiabilities decimal{34,6} The total amount a company owes under lease agreements for using property, equipment, or other assets.
totalLeaseLiabilitiesCurrencyISO string(3) Currency ISO code for Total Lease Liabilities
totalLiabilities decimal{34,6} The total amount of all debts and obligations a company owes, both short-term and long-term.
totalLiabilitiesAndEquity decimal{34,6} The total of a company's liabilities plus shareholders' equity; this equals total assets.
totalLiabilitiesAndEquityCurrencyISO string(3) Currency ISO code for Total Liabilities And Equity
totalLiabilitiesCurrencyISO string(3) Currency ISO code for Total Liabilities
totalLiabilitiesToTotalAssets decimal{34,6} A ratio that compares a company's total liabilities to its total assets, indicating how much of its assets are financed by liabilities.
totalLiabilitiesToTotalAssetsCurrencyISO string(3) Currency ISO code for Total Liabilities/Total Assets
totalPrincipalDue decimal{34,6} The total amount of money the company still owes on all its loans or debt obligations, excluding interest.
totalPrincipalDueCurrencyISO string(3) Currency ISO code for Total Principal Due
totalReceivables decimal{34,6} The total amount of money owed to the company by customers for goods or services sold on credit.
totalReceivablesCurrencyISO string(3) Currency ISO code for Total Receivables
totalRevenue decimal{34,6} The total money a company earns from selling its products or services before any costs are subtracted.
totalRevenue1YearGrowthRate decimal{34,6} The percentage change in a company's total revenue over one year, showing how much the company's sales have grown or shrunk during that period.
totalRevenue1YearGrowthRateCurrencyISO string(3) Currency ISO code for Total Revenue 1 Yr GR
totalRevenue2YearCAGR decimal{34,6} The average annual growth rate of a company's total revenue over two years, showing how much revenue has grown per year on average over that period.
totalRevenue2YearCAGRCurrencyISO string(3) Currency ISO code for Total Revenue 2 Yr CAGR
totalRevenue3YearCAGR decimal{34,6} The average annual growth rate of a company's total revenue over three years, showing how much revenue has grown per year on average over that period.
totalRevenue3YearCAGRCurrencyISO string(3) Currency ISO code for Total Revenue 3 Yr CAGR
totalRevenue5YearCAGR decimal{34,6} The average annual growth rate of a company's total revenue over five years, showing how much revenue has grown per year on average over that period.
totalRevenue5YearCAGRCurrencyISO string(3) Currency ISO code for Total Revenue 5 Yr CAGR
totalRevenueCurrencyISO string(3) Currency ISO code for Total Revenue
totalRevolvingCredit decimal{34,6} The total amount of money available to borrow through a revolving credit line, which allows a company to borrow, repay, and borrow again.
totalRevolvingCreditCurrencyISO string(3) Currency ISO code for Total Revolving Credit
totalSecuredDebt decimal{34,6} The total value of debt that is backed by collateral, such as property or equipment, which the lender can take if the company fails to repay.
totalSecuredDebtCurrencyISO string(3) Currency ISO code for Total Secured Debt
totalSeniorBondsAndNotes decimal{34,6} The total value of bonds and notes that a company has issued which are considered senior, meaning they must be paid off before other debts in bankruptcy.
totalSeniorBondsAndNotesCurrencyISO string(3) Currency ISO code for Total Senior Bonds and Notes
totalSeniorDebt decimal{34,6} The total amount of debt that takes priority for repayment over other debts in the event of liquidation or bankruptcy.
totalSeniorDebtCurrencyISO string(3) Currency ISO code for Total Senior Debt
totalSeniorDebtToEBITDALessCapex decimal{34,6} A measure of how leveraged a company is with its senior debt, relative to its earnings minus capital expenditures.
totalSeniorDebtToEBITDALessCapexCurrencyISO string(3) Currency ISO code for Total Senior Debt/(EBITDA-CAPEX)
totalSeniorDebtToEbitda decimal{34,6} A ratio comparing total senior debt to a company's EBITDA, showing how much priority debt the company has relative to earnings.
totalSeniorDebtToEbitdaCurrencyISO string(3) Currency ISO code for Total Senior Debt/EBITDA
totalSeniorSecuredDebt decimal{34,6} The total value of secured debt that has seniority for repayment over other secured debts in case of liquidation or bankruptcy.
totalSeniorSecuredDebtCurrencyISO string(3) Currency ISO code for Total Senior Secured Debt
totalSeniorSecuredToEBITDALessCapex decimal{34,6} A measure of how leveraged a company is with senior secured debt, relative to earnings minus capital expenditures.
totalSeniorSecuredToEBITDALessCapexCurrencyISO string(3) Currency ISO code for Total Senior Secured/(EBITDA-CAPEX)
totalSeniorSecuredToEbitda decimal{34,6} A ratio comparing total senior secured debt to EBITDA, showing how leveraged the company is with high-priority, collateral-backed debt.
totalSeniorSecuredToEbitdaCurrencyISO string(3) Currency ISO code for Total Senior Secured/EBITDA
totalShortTermBorrowings decimal{34,6} The total value of all debts that need to be repaid within one year.
totalShortTermBorrowingsCurrencyISO string(3) Currency ISO code for Total Short Term Borrowings
totalUndrawnCredit decimal{34,6} The total amount of all credit facilities that the company hasn't used yet but can still draw upon in the future.
totalUndrawnCreditCurrencyISO string(3) Currency ISO code for Total Undrawn Credit
totalUnsecuredDebt decimal{34,6} The total amount of debt that is not backed by any collateral.
totalUnsecuredDebtCurrencyISO string(3) Currency ISO code for Total Unsecured Debt
link unConsolidatedBSRestatementType FinancialRestatementType The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated)
unConsolidatedBSRestatementTypeId long(-2147483648,2147483647) The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated)
link unConsolidatedCFRestatementType FinancialRestatementType The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated)
unConsolidatedCFRestatementTypeId long(-2147483648,2147483647) The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated)
unConsolidatedFlag long* Flag to indicate if financials are unconsolidated
link unConsolidatedISRestatementType FinancialRestatementType The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated)
unConsolidatedISRestatementTypeId long(-2147483648,2147483647) The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated)
undrawnRevolvingCredit decimal{34,6} The amount of available credit in a revolving credit line that the company has not yet used or borrowed.
undrawnRevolvingCreditCurrencyISO string(3) Currency ISO code for Undrawn Revolving Credit
unleveredFreeCashFlowMargin decimal{34,6} The percentage of revenue left as free cash flow before any interest payments on debt. It shows how much cash is available to all capital providers.
unleveredFreeCashFlowMarginCurrencyISO string(3) Currency ISO code for Unlevered Free Cash Flow Margin
updOperation long Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted
useAsComponentFlag long Flag indicating if the instance can be used as a component in calculating missing period calculations
variableRateDebt decimal{34,6} Debt with an interest rate that fluctuates based on a benchmark, such as LIBOR or the prime rate.
variableRateDebtCurrencyISO string(3) Currency ISO code for Variable Rate Debt
342 rows of 342 total
API Open API Specification