Hospital Financial Quarterly Aggregate Report

Quarterly financial and operational data for hospitals, as reported to the state of Washington. The dataset includes detailed metrics on revenue, patient days, discharges, and contractual allowances segmented by payer type. Columns suggest a focus on Skilled Nursing Facility (SNF), Swing Bed, and Acute Care services.

Use Cases

• Analyzing payer mix and revenue distribution using Total_Medicare_Revenue, Total_Self_Pay_Revenue, and Total_Other_Revenue (inferred from domain, verify after download).
• Comparing operational efficiency across service lines using SNF_Total_Patient_Days, Acute_Care_Medicare_Patient_Days, and Swing_Bed_Total_Discharges (inferred from domain, verify after download).
• Calculating contractual adjustments and net revenue using Acute_Contractuals_Total, Other_Contractuals_Total, and Gross_Accounts_Receivable_Medicare (inferred from domain, verify after download).
• Benchmarking hospital profitability metrics like Gross_Total_Margin against staffing costs from Employee_Benefit_Expenses and Physician_Payroll (inferred from domain, verify after download).

Strengths

• Cross-platform presence on Socrata and Data.gov signals importance and potential for wider use.
• Dataset structure is detailed, with over 30 specific columns providing granular breakdowns of revenue, expenses, and patient activity.
• Data is updated quarterly, with the most recent platform update recorded on 2026-03-22.

Limitations

• Metadata is minimal; actual content requires verification after download.
• Key metadata like row count, file size, license, and author are consistently missing or listed as 'None' across all sources.
• The Data.gov source provides no column information, limiting pre-download understanding of its specific contents.

Provenance

Source

data.wa.gov (Washington State)

Collection Method

Likely collected via mandatory quarterly financial reporting from hospitals.

Freshness

Last updated 2026-03-22 03:13:01.891637

Geography

Washington State, USA (inferred from publisher domain)