Data Model

​

Overview

​

Core Objects

​

Company

{
  "ticker": "CHTR",
  "name": "Charter Communications, Inc.",
  "cik": "1091667",
  "sector": "Communication Services",
  "industry": "Cable & Satellite",
  "total_debt": 9500000000000,
  "net_leverage_ratio": 4.5
}

​

Entity

{
  "id": "uuid-123",
  "name": "CCO Holdings, LLC",
  "entity_type": "opco",
  "jurisdiction": "Delaware",
  "parent_id": "uuid-000",
  "is_guarantor": true,
  "is_restricted_subsidiary": true
}

• holdco - Holding company (typically top-level)
• opco - Operating company
• finco - Financing subsidiary
• subsidiary - General subsidiary
• jv - Joint venture
• vie - Variable interest entity

​

Debt Instrument

{
  "id": "uuid-456",
  "name": "5.75% Senior Notes due 2028",
  "issuer_id": "uuid-123",
  "instrument_type": "senior_notes",
  "seniority": "senior_unsecured",
  "principal": 150000000000,
  "outstanding": 150000000000,
  "coupon_rate": 5.75,
  "rate_type": "fixed",
  "maturity_date": "2028-01-15",
  "currency": "USD"
}

• senior_secured - First priority claim
• senior_unsecured - Unsecured senior debt
• subordinated - Junior to senior debt

• senior_notes - Fixed-rate bonds
• term_loan_a - Amortizing term loan
• term_loan_b - Bullet term loan
• revolver - Revolving credit facility
• first_lien - First lien secured loan
• second_lien - Second lien secured loan

​

Guarantee

{
  "debt_instrument_id": "uuid-456",
  "guarantor_id": "uuid-789",
  "guarantee_type": "full_and_unconditional"
}

​

Collateral

{
  "debt_instrument_id": "uuid-456",
  "collateral_type": "real_estate",
  "description": "First mortgage on headquarters building",
  "priority": 1
}

• real_estate - Property and buildings
• equipment - Machinery, vehicles
• receivables - Accounts receivable
• inventory - Stock and goods
• ip - Intellectual property, patents
• securities - Stock pledges
• general_lien - Blanket lien on assets
• vehicles - Aircraft, ships, cars
• energy_assets - Oil/gas reserves

​

Data Conventions

​

Monetary Values

​

Interest Rates

​

Dates

{
  "issue_date": "2023-01-15",
  "maturity_date": "2028-01-15"
}

​

Relationships

• A Company has many Entities
• An Entity can issue Debt Instruments
• An Entity can guarantee other entities’ Debt Instruments
• A Debt Instrument can have multiple Guarantors
• A Debt Instrument can have Collateral

​

Document Sections

• Keyword search — PostgreSQL full-text search with relevance ranking
• Semantic search — Each section is split into overlapping chunks and embedded with Gemini (gemini-embedding-001, 768 dimensions). Queries are embedded and matched via cosine similarity, enabling natural language questions like “can they pay dividends” to find covenant language about restricted payments.
• Hybrid search — Combines both via Reciprocal Rank Fusion for comprehensive results

​

Coverage