Department of Health Contracts Started or Amended during State Fiscal Year 2016

A partial list of contracts the State Department of Health started or amended between July 1, 2015 and June 30, 2016. Includes grants, loans, and contracts for goods and professional services tracked in the department's primary contract database, the Enterprise Contract Management System (ECMS). It does not include contracts with Washington's local health jurisdictions, contracts for expert witnesses, or purchase orders. Acronyms are used for doing business as (DBA), statement of work (SOW), and period of performance (POP). Amendments are represented as the contract number with a hyphen extension. For example, N12345-1 would be the first amendment to contract N12345.

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/department-of-health-contracts-started-or-amended-mx83-wxi5\".\"department_of_health_contracts_started_or_amended\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.