About this Dataset

Electric Load Serving Entities (IOU & POU)

Data compiled from California Energy Commission staff from georeferenced electric territory maps and the United States Department of Homeland Security, Homeland Infrastructure Foundation-Level Data (HIFILD), https://hifld-geoplatform.opendata.arcgis.com/datasets/geoplatform::electric-retail-service-territories-2/about

Boundaries are approximate, for absolute territory information, contact the appropriate load serving entity.

For more information on California Load Serving Entities visit this website: https://www.energy.ca.gov/data-reports/energy-almanac/california-electricity-data/electric-load-serving-entities-lses
Organization: State of California
Last updated: 2024-11-27T01:20:46.829557
Tags: california-energy-commission, california-natural-resources-agency, caopendata, iou, pdf, pou, service-areas

Tables

Table 1

@usgov.ca_gov_electric_load_serving_entities_iou_pou_d4c3b.table_1

40.58 kB
53 rows
35 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "acronym" VARCHAR,
  "utility" VARCHAR,
  "type" VARCHAR,
  "url" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "hifld_id" DOUBLE,
  "retail_sales_gwh_2000" DOUBLE  -- Retail Sales GWh - 2000,
  "retail_sales_gwh_2001" DOUBLE  -- Retail Sales GWh - 2001,
  "retail_sales_gwh_2002" DOUBLE  -- Retail Sales GWh - 2002,
  "retail_sales_gwh_2003" DOUBLE  -- Retail Sales GWh - 2003,
  "retail_sales_gwh_2004" DOUBLE  -- Retail Sales GWh - 2004,
  "retail_sales_gwh_2005" DOUBLE  -- Retail Sales GWh - 2005,
  "retail_sales_gwh_2006" DOUBLE  -- Retail Sales GWh - 2006,
  "retail_sales_gwh_2007" DOUBLE  -- Retail Sales GWh - 2007,
  "retail_sales_gwh_2008" DOUBLE  -- Retail Sales GWh - 2008,
  "retail_sales_gwh_2009" DOUBLE  -- Retail Sales GWh - 2009,
  "retail_sales_gwh_2010" DOUBLE  -- Retail Sales GWh - 2010,
  "retail_sales_gwh_2011" DOUBLE  -- Retail Sales GWh - 2011,
  "retail_sales_gwh_2012" DOUBLE  -- Retail Sales GWh - 2012,
  "retail_sales_gwh_2013" DOUBLE  -- Retail Sales GWh - 2013,
  "retail_sales_gwh_2014" DOUBLE  -- Retail Sales GWh - 2014,
  "retail_sales_gwh_2015" DOUBLE  -- Retail Sales GWh - 2015,
  "retail_sales_gwh_2016" DOUBLE  -- Retail Sales GWh - 2016,
  "retail_sales_gwh_2017" DOUBLE  -- Retail Sales GWh - 2017,
  "retail_sales_gwh_2018" DOUBLE  -- Retail Sales GWh - 2018,
  "retail_sales_gwh_2019" DOUBLE  -- Retail Sales GWh - 2019,
  "retail_sales_gwh_2020" VARCHAR  -- Retail Sales GWh - 2020,
  "retail_sales_gwh_2021" VARCHAR  -- Retail Sales GWh - 2021,
  "peak_load_mw_2019" VARCHAR,
  "onlinename" VARCHAR,
  "audit" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);