WA-APCD Quality and Cost Summary Report: ACH Quality
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.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"wa-gov/waapcd-quality-and-cost-summary-report-ach-quality-j78i-gfy5\".\"waapcd_quality_and_cost_summary_report_ach_quality\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
