Department Of Health Contracts Started Or Amended During State Fiscal Year 2017

A partial list of contracts the State Department of Health started or amended between July 1, 2016 and June 30, 2017. 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, purchase orders, contracts issued by the department but not tracked in ECMS, or contracts exempt from disclosure under state or federal regulation. Acronyms are used for doing business as (DBA), statement of work (SOW), and period of performance (POP).

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-5s66-2kbs\".\"department_of_health_contracts_started_or_amended\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.