- id
- Stable public key for one subject and quarter.
- subject_case_number
- The report's own case number; a shared lead case does not make reports duplicates.
- quarter_start
- Quarter start: the first of the quarter, or the plan effective date in the first partial quarter.
- is_partial_period
- Whether the quarter starts at the plan effective date.
- plan_confirmed_date
- Reported plan confirmation date.
- plan_effective_date
- Reported plan effective date.
- final_report_answer
- Whether the filer marks this the final report.
- ust_quarterly_fees_current_answer
- Current with U.S. Trustee quarterly fees.
- total_transferred_current_quarter_usd
- Part 1 total transferred in the quarter, including operating and noncash transfers; not creditor recovery. In USD.
- total_transferred_since_effective_usd
- Part 1 total transferred since the plan effective date. Not summable across periods. In USD.
- professional_fees_and_expenses_approved_current_quarter_usd
- Part 2 line c pre-confirmation fees and expenses of all professionals, debtor's and committees', approved in the quarter; not post-confirmation payments. In USD.
- professional_fees_and_expenses_approved_cumulative_usd
- Part 2 line c pre-confirmation fees and expenses of all professionals, debtor's and committees', approved since the petition. Not summable across periods. In USD.
- professional_fees_and_expenses_paid_current_quarter_usd
- Part 2 line c pre-confirmation fees and expenses of all professionals, debtor's and committees', paid in the quarter; not post-confirmation payments. In USD.
- professional_fees_and_expenses_paid_cumulative_usd
- Part 2 line c pre-confirmation fees and expenses of all professionals, debtor's and committees', paid since the petition. Not summable across periods. In USD.
- bankruptcy_professional_fees_approved_current_quarter_usd
- Part 2 line a pre-confirmation fees and expenses of the debtor's bankruptcy professionals, approved in the quarter, as printed. In USD.
- bankruptcy_professional_fees_approved_cumulative_usd
- Part 2 line a pre-confirmation fees and expenses of the debtor's bankruptcy professionals, approved since the petition, as printed. Not summable across periods. In USD.
- bankruptcy_professional_fees_paid_current_quarter_usd
- Part 2 line a pre-confirmation fees and expenses of the debtor's bankruptcy professionals, paid in the quarter, as printed. In USD.
- bankruptcy_professional_fees_paid_cumulative_usd
- Part 2 line a pre-confirmation fees and expenses of the debtor's bankruptcy professionals, paid since the petition, as printed. Not summable across periods. In USD.
- nonbankruptcy_professional_fees_approved_current_quarter_usd
- Part 2 line b pre-confirmation fees and expenses of the debtor's nonbankruptcy professionals, approved in the quarter, as printed. In USD.
- nonbankruptcy_professional_fees_approved_cumulative_usd
- Part 2 line b pre-confirmation fees and expenses of the debtor's nonbankruptcy professionals, approved since the petition, as printed. Not summable across periods. In USD.
- nonbankruptcy_professional_fees_paid_current_quarter_usd
- Part 2 line b pre-confirmation fees and expenses of the debtor's nonbankruptcy professionals, paid in the quarter, as printed. In USD.
- nonbankruptcy_professional_fees_paid_cumulative_usd
- Part 2 line b pre-confirmation fees and expenses of the debtor's nonbankruptcy professionals, paid since the petition, as printed. Not summable across periods. In USD.
- total_cash_disbursements_current_quarter_usd
- Part 1 line a total cash disbursements in the quarter, as printed; historical forms print only this line, not line d. In USD.
- total_cash_disbursements_since_effective_usd
- Part 1 line a total cash disbursements since the plan effective date, as printed. Not summable across periods. In USD.
- administrative_allowed_usd
- Part 3 allowed administrative claims. Not summable across periods. In USD.
- administrative_paid_current_quarter_usd
- Part 3 payments on administrative claims in the quarter; may include noncash property. In USD.
- administrative_paid_cumulative_usd
- Part 3 payments on administrative claims to date. Not summable across periods. In USD.
- administrative_anticipated_usd
- Part 3 total anticipated payments on administrative claims under the plan. Not summable across periods. In USD.
- secured_allowed_usd
- Part 3 allowed secured claims. Not summable across periods. In USD.
- secured_paid_current_quarter_usd
- Part 3 payments on secured claims in the quarter; may include noncash property. In USD.
- secured_paid_cumulative_usd
- Part 3 payments on secured claims to date. Not summable across periods. In USD.
- secured_anticipated_usd
- Part 3 total anticipated payments on secured claims under the plan. Not summable across periods. In USD.
- priority_allowed_usd
- Part 3 allowed priority claims. Not summable across periods. In USD.
- priority_paid_current_quarter_usd
- Part 3 payments on priority claims in the quarter; may include noncash property. In USD.
- priority_paid_cumulative_usd
- Part 3 payments on priority claims to date. Not summable across periods. In USD.
- priority_anticipated_usd
- Part 3 total anticipated payments on priority claims under the plan. Not summable across periods. In USD.
- general_unsecured_allowed_usd
- Part 3 allowed general unsecured claims. Not summable across periods. In USD.
- general_unsecured_paid_current_quarter_usd
- Part 3 payments on general unsecured claims in the quarter; may include noncash property. In USD.
- general_unsecured_paid_cumulative_usd
- Part 3 payments on general unsecured claims to date. Not summable across periods. In USD.
- general_unsecured_anticipated_usd
- Part 3 total anticipated payments on general unsecured claims under the plan. Not summable across periods. In USD.
- equity_paid_current_quarter_usd
- Part 3 payments on equity interests in the quarter; may include noncash property. In USD.
- equity_paid_cumulative_usd
- Part 3 payments on equity interests to date. Not summable across periods. In USD.
- equity_anticipated_usd
- Part 3 total anticipated payments on equity interests under the plan. Not summable across periods. In USD.
- administrative_percent_paid
- Part 3 percent of allowed administrative claims paid, as the form reports it. Not summable across periods.
- secured_percent_paid
- Part 3 percent of allowed secured claims paid, as the form reports it. Not summable across periods.
- priority_percent_paid
- Part 3 percent of allowed priority claims paid, as the form reports it. Not summable across periods.
- general_unsecured_percent_paid
- Part 3 percent of allowed general unsecured claims paid, as the form reports it. Not summable across periods.
- administrative_recovery_percent
- Paid to date over allowed administrative claims, in percent; null unless allowed is above zero. A positive allowed amount with nothing paid is 0. Not summable across periods.
- secured_recovery_percent
- Paid to date over allowed secured claims, in percent; null unless allowed is above zero. A positive allowed amount with nothing paid is 0. Not summable across periods.
- priority_recovery_percent
- Paid to date over allowed priority claims, in percent; null unless allowed is above zero. A positive allowed amount with nothing paid is 0. Not summable across periods.
- administrative_paid_of_anticipated_percent
- Paid to date over anticipated payments on administrative claims, in percent; distribution progress, not recovery. Not summable across periods.
- secured_paid_of_anticipated_percent
- Paid to date over anticipated payments on secured claims, in percent; distribution progress, not recovery. Not summable across periods.
- priority_paid_of_anticipated_percent
- Paid to date over anticipated payments on priority claims, in percent; distribution progress, not recovery. Not summable across periods.
- general_unsecured_paid_of_anticipated_percent
- Paid to date over anticipated payments on general unsecured claims, in percent; distribution progress, not recovery. Not summable across periods.
- equity_paid_of_anticipated_percent
- Paid to date over anticipated payments on equity interests, in percent; distribution progress, not recovery. Not summable across periods.
- docket_number
- Docket-entry number of the filing this row reads.
- filing_lag_days
- Days from the period end to the filing date.
- filing_count
- Filings for this subject and period, including amendments and supplements.
- filing_document_public_ids
- Every filing for this subject and period, oldest first.
- 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.