- id
- Stable public key for one case quarter.
- document_public_ids
- Filings whose subject rows make up this row.
- latest_date_filed
- Latest filing date among those filings.
- subjects_final_report
- Subjects whose report for this quarter is marked final.
- total_transferred_current_quarter_usd
- Part 1 total transferred in the quarter, including operating and noncash transfers; not creditor recovery. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- total_transferred_since_effective_usd
- Part 1 total transferred since the plan effective date. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- total_cash_disbursements_since_effective_usd
- Part 1 line a total cash disbursements since the plan effective date, as printed. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- administrative_allowed_usd
- Part 3 allowed administrative claims. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- administrative_paid_current_quarter_usd
- Part 3 payments on administrative claims in the quarter; may include noncash property. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- administrative_paid_cumulative_usd
- Part 3 payments on administrative claims to date. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- administrative_anticipated_usd
- Part 3 total anticipated payments on administrative claims under the plan. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- secured_allowed_usd
- Part 3 allowed secured claims. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- secured_paid_current_quarter_usd
- Part 3 payments on secured claims in the quarter; may include noncash property. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- secured_paid_cumulative_usd
- Part 3 payments on secured claims to date. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- secured_anticipated_usd
- Part 3 total anticipated payments on secured claims under the plan. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- priority_allowed_usd
- Part 3 allowed priority claims. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- priority_paid_current_quarter_usd
- Part 3 payments on priority claims in the quarter; may include noncash property. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- priority_paid_cumulative_usd
- Part 3 payments on priority claims to date. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- priority_anticipated_usd
- Part 3 total anticipated payments on priority claims under the plan. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- general_unsecured_allowed_usd
- Part 3 allowed general unsecured claims. Sums the subjects' reported figures only when every one states it; otherwise null. 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. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- general_unsecured_paid_cumulative_usd
- Part 3 payments on general unsecured claims to date. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- general_unsecured_anticipated_usd
- Part 3 total anticipated payments on general unsecured claims under the plan. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- equity_paid_current_quarter_usd
- Part 3 payments on equity interests in the quarter; may include noncash property. Sums the subjects' reported figures only when every one states it; otherwise null. In USD.
- equity_paid_cumulative_usd
- Part 3 payments on equity interests to date. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- equity_anticipated_usd
- Part 3 total anticipated payments on equity interests under the plan. Sums the subjects' reported figures only when every one states it; otherwise null. Not summable across periods. In USD.
- administrative_recovery_percent
- Ratio of summed paid to date over summed allowed across the case's subjects, in percent; never a mean of subject percentages. Null unless every subject states both and the summed allowed is above zero. Not summable across periods.
- secured_recovery_percent
- Ratio of summed paid to date over summed allowed across the case's subjects, in percent; never a mean of subject percentages. Null unless every subject states both and the summed allowed is above zero. Not summable across periods.
- priority_recovery_percent
- Ratio of summed paid to date over summed allowed across the case's subjects, in percent; never a mean of subject percentages. Null unless every subject states both and the summed allowed is above zero. 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.