Department of Health Contracts Started or Amended During State Fiscal Year 2019

A partial list of contracts the State Department of Health started or amended between July 1, 2018 and June 30, 2019. Includes grants 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 grants and/or contracts with Washington's local health jurisdictions, contracts for expert witnesses, purchase orders, data sharing agreements, contracts issued by the department but not tracked in ECMS, or contracts exempt from disclosure under state or federal regulation.

Acronyms commonly found in this data set are:

CBO=Community Based Organizations/Non-Profits

CLH=Local Health Jurisdictions

EMS= EMS/Trauma Centers

GVF=Government Federal

GVL=Government Local (EXCEPT Con-Con/LHJ)

GVS=Government State (EXCEPT Higher Ed)

HED=Higher Education

HSP=Hospitals

POP = Period of Performance

PRV=Private/For-Profits

SCH=Schools, School Districts & Education Institutions (excluding Higher Ed)

SOW = Statement of Work

TRB=Tribal Entity

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-un75-jhzj\".\"department_of_health_contracts_started_or_amended\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.