Icon for Socrata external plugin
Open repository in Console
Updated over 5 years ago
Indexed 2 hours ago

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

A partial list of contracts the State Department of Health started or amended between July 1, 2017 and June 30, 2018. 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 contracts many of the department's contracts with Washington's local health jurisdictions, or 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.

In 2017, the department added a data element to categorize entities. This is not found in prior years' data sets.

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


POP = Period of Performance


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" \
{"sql": "
    SELECT *
    FROM \"wa-gov/department-of-health-contracts-started-or-amended-qhn8-3a9e\".\"department_of_health_contracts_started_or_amended\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • department_of_health_contracts_started_or_amended
Upstream Metadata