wa-gov/department-of-health-contracts-started-or-amended-qhn8-3a9e
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 5 years ago
Indexed 1 month 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

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-qhn8-3a9e\".\"department_of_health_contracts_started_or_amended\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • department_of_health_contracts_started_or_amended
     
     
     
     
     
Upstream Metadata