Data sourcesStep 11 of 18

Filings

Units extracted from the earnings-report PDF, such as risk_factors, in ku_cell.

What it is

A Filing is the company's earnings-report PDF. Its file row is only a pointer, with source_type Filing, published_at, and time_period_id, and the PDF text itself is not queryable.

What you read are the knowledge units Distilla extracts from the filing, stored as ku_cell rows. risk_factors is one of them: a JSON list of risks, each with a category, a description, and the pages it came from. The Knowledge units page lists the other unit names.

Filing units cite the Filing under source.file_id, singular, with the id as a string. Composite filing and transcript units use sources.file_id with an integer.

ku_cellJoin ku as kuJoin cellTimePeriod as periodJoin groupCompany as groupCompanyku.name

How Entity ku_cell · Filter ku.name = risk_factors · Join ku as ku, cellTimePeriod as period, groupCompany as groupCompany

Example

Try this call

{
  "entity": "ku_cell",
  "select": [
    "id",
    "content",
    "published_at",
    "ku.name",
    "period.fiscal_year",
    "period.duration",
    "period.end_date",
    "groupCompany.symbol"
  ],
  "filters": [
    {
      "field": "ku.name",
      "op": "=",
      "value": "risk_factors"
    },
    {
      "field": "groupCompany.symbol",
      "op": "=",
      "value": "NVDA"
    }
  ],
  "joins": [
    {
      "relation": "ku",
      "alias": "ku"
    },
    {
      "relation": "cellTimePeriod",
      "alias": "period"
    },
    {
      "relation": "groupCompany",
      "alias": "groupCompany"
    }
  ],
  "sort": [
    {
      "field": "period.end_date",
      "direction": "desc"
    }
  ],
  "limit": 3
}