SWPAO Contracts by US Government | Environmental and Climate Sciences

About this Dataset

SWPAO Contracts

This dataset shows the obligations for active agreements between State Water Project Contractors.
Organization: State of California
Last updated: 2023-09-15T13:44:20.978911
Tags: california-department-of-water-resources, dwr, exchanges, state-water-project, state-water-project-analysis-office

Tables

Contract Obligations

@usgov.ca_gov_swpao_contracts_c8213.contract_obligations

12.42 KB
74 rows
13 columns


CREATE TABLE contract_obligations (
  "swpaonumber" VARCHAR,
  "obligation" BIGINT,
  "fromagency" VARCHAR,
  "toagency" VARCHAR,
  "ratio" VARCHAR,
  "transactiontype" VARCHAR,
  "maxtransfer" BIGINT,
  "effectivedate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "cpou" VARCHAR,
  "losses" DOUBLE,
  "watersource" VARCHAR,
  "landowner" VARCHAR
);