Name: SWPAO Contracts
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

SWPAO Contracts

This dataset shows the obligations for active agreements between State Water Project Contractors.
Organization: State of California
Last updated: 2025-07-24T02:01:04.329177
Tags: california-department-of-water-resources, dwr, exchanges, state-water-project, state-water-project-analysis-office

Tables

Contract Obligations

@usgov.ca_gov_swpao_contracts_d19b6.contract_obligations

12.72 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
);