- id
- Stable public key for one case month.
- has_partial_period
- Whether any subject's period starts at its petition date within the month.
- months_since_petition
- Whole months from the petition month to the period month. Uses the earliest petition among the subjects.
- document_public_ids
- Filings whose subject rows make up this row.
- latest_date_filed
- Latest filing date among those filings.
- cash_beginning_of_month_usd
- Part 1 cash at the start of the period. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- receipts_usd
- Part 1 receipts net of transfers for the period. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- disbursements_usd
- Part 1 disbursements net of transfers for the period. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- sales_usd
- Gross sales or income for the period. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- profit_loss_month_usd
- Profit or loss for the period. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- professional_fees_paid_month_usd
- Professional fees and expenses paid in the period (Part 5, all firms). Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- professional_fees_paid_cumulative_usd
- Professional fees and expenses paid since the petition (Part 5, all firms). Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- total_assets_usd
- Total assets at period end. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- total_liabilities_usd
- Total liabilities at period end. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- postpetition_payables_past_due_usd
- Postpetition payables past due, excluding taxes, at period end. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- postpetition_taxes_past_due_usd
- Postpetition taxes past due at period end. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- total_postpetition_debt_usd
- Total postpetition debt at period end. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- ust_fee_disbursements_usd
- Disbursements reported for the U.S. Trustee quarterly fee calculation. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- full_time_employees
- Full-time employees at period end. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods.
- net_cash_change_3m_usd
- Net cash flow over this and the two previous months; null unless all three are reported, contiguous and full (for a case: complete and on one basis). Not summable across periods. In USD.
- runway_months
- Month-end cash over the trailing three months' average net outflow: a reported-cash screening proxy, not available liquidity (financing, asset sales and restricted cash sit outside it). Null unless cash fell over three contiguous full months and month-end cash is not negative. Not summable across periods.
- professional_fees_percent_of_disbursements
- Professional fees paid in the month as a percent of the month's disbursements (disbursements_usd); null when disbursements are missing or not positive. Not summable across periods.
- petition_date
- Lead-case petition date.
- judge
- Current case judge.
- court_id
- PACER court identifier (deb, txsb, nysb); unknown when unmapped.
- court_state
- Court venue state.
- chapter
- Bankruptcy chapter.
- subchapter_v
- Subchapter V election: elected, not_elected or unknown.
- industry_tags
- Canonical case industry labels; cases may have multiple labels.
- case_type_tags
- Case-type tags (Sale Process, Prepackaged, Prenegotiated); not the chapter.
- claims_agent
- Court-designated case notice administrator; null if unavailable.
- outcome_type
- Observed case outcome; absence does not establish an active case.
- stage
- Case stage: filed, recognized, plan_filed, confirmed, effective, closed, dismissed or converted; null without a petition date.
- assets_range
- Petition asset bracket; read basis and subject debtor.
- assets_basis
- Basis for the asset bracket.
- assets_basis_quality
- Evidence quality for the asset bracket.
- assets_subject_debtor
- Debtor to which the asset bracket applies.
- liabilities_range
- Liability bracket; read basis and subject debtor.
- liabilities_basis
- Basis for the liability bracket.
- liabilities_basis_quality
- Evidence quality for the liability bracket.
- liabilities_subject_debtor
- Debtor to which the liability bracket applies.