WA-APCD - Washington All-Payer Claims Database The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018. Download the attachment for the data dictionary and more information about WA-APCD and the data.
This dataset has the following 16 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| SUMMARIZATION_LEVEL | summarization_level | text | Hospital view top 100 |
| NAME | name | text | Evergreenhealth Medical Center Peacehealth Southwest Medical Center Virginia Mason - Yakima Valley Memorial Hospital Providence St. Peter Hospital Providence Regional Medical Center Everett view top 100 |
| ORGANIZATION_CITY | organization_city | text | Seattle Spokane Tacoma Vancouver Olympia view top 100 |
| ORGANIZATION_ZIP | organization_zip | text | 98405 99204 98122 98902 98664 view top 100 |
| PRODUCT_TYPE | product_type | text | ALL view top 100 |
| MEASURE_CODE | measure_code | text | CAUTI-OUT READM-30-HOSP-WIDE FALLS-I H-HSP-RATING H-COMP-D view top 100 |
| MEASURE_DESCRIPTION | measure_description | text | 30-Day Hospital-Wide All-Cause Unplanned Readmission (HWR) Catheter-Associated Urinary Tract Infections outside ICU Falls with Injury Overall Rating of Hospital Patient Experience with Hospital Care: Discharge Information view top 100 |
| MEASURE_COMPONENT | measure_component | text | Visit Count Score Readmission Compliance view top 100 |
| MEASURE_SUMMARY_UNITS | measure_summary_units | text | Rate per 1,000 Member-Years Score Observed to Expected Ratio Percent Compliance view top 100 |
| AGE_STRATIFICATION | age_stratification | text | Overall view top 100 |
| MEASURE_RESULT | measure_result | number | 0.15 0.00 0.14 3.00 0.16 view top 100 |
| LOWER_95_CI | lower_95_ci | number | 0.14 0.13 0.11 0.12 0.15 view top 100 |
| UPPER_95_CI | upper_95_ci | number | 0.17 0.16 0.18 0.19 0.15 view top 100 |
| REPORTING_PERIOD_BEGIN_DT | reporting_period_begin_dt | calendar_date | 2016-01-01T00:00:00.000 view top 100 |
| REPORTING_PERIOD_END_DT | reporting_period_end_dt | calendar_date | 2016-12-31T00:00:00.000 view top 100 |
| PERFORMANCE_CATEGORY | performance_category | text | view top 100 |