Dataset: LA Department Of Water & Power Performance Metrics

About this Dataset

LA Department Of Water & Power Performance Metrics

Content

This dataset contains metrics that measure the operational performance of the Department of Water and Power. These metrics are used on a regular basis by the department and the Mayor to evaluate progress and inform decision making. Performance management forms the foundation of a data-driven culture of innovation and excellence in the City of Los Angeles.

Context

This is a dataset hosted by the city of Los Angeles. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore Los Angeles's Data using Kaggle and all of the data sources available through the city of Los Angeles organization page!

Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Steven Pahel on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Tables

Department Of Water And Power Dwp Performance Metrics

@kaggle.cityofla_la_department_of_water_power_performance_metrics.department_of_water_and_power_dwp_performance_metrics

45.12 KB
72 rows
44 columns


CREATE TABLE department_of_water_and_power_dwp_performance_metrics (
  "date_value" TIMESTAMP,
  "month_year" VARCHAR,
  "quarter_fy" VARCHAR,
  "annual_fy" VARCHAR,
  "annual_cy" VARCHAR,
  "call_wait_time_minutes_monthly" DOUBLE,
  "target_call_wait_time_minutes_under_monthly" DOUBLE,
  "no_of_estimated_bills_monthly" DOUBLE,
  "total_bills_including_est_bills_monthly" DOUBLE,
  "estimated_bill_percentage_monthly" DOUBLE,
  "water_main_breaks_annual_fy" DOUBLE,
  "cumulative_miles_of_water_main_replaced_annual" DOUBLE,
  "target_cumulative_miles_of_water_main_replaced_annual" VARCHAR,
  "per_capita_water_use_gallons_per_day_annually" DOUBLE,
  "target_per_capita_water_use_gallons_per_day_annually" VARCHAR,
  "water_purchased_from_mwd_annually" DOUBLE,
  "target_water_purchased_from_mwd_monthly" VARCHAR,
  "n__of_dwp_water_sourced_from_local_groundwater_annually" DOUBLE,
  "target_of_dwp_water_sourced_from_local_groundwater_annually" VARCHAR,
  "co2_emissions_from_all_owned_and_purchased_power_gener_b8725899" DOUBLE,
  "target_co2_emissions_from_all_owned_and_purchased_powe_a74034a1" VARCHAR,
  "renewables_percentage_annually" DOUBLE,
  "target_renewables_percentage_annually" DOUBLE,
  "kwh_of_power_from_energy_efficiency_monthly_fy" DOUBLE,
  "target_kwh_of_power_from_energy_efficiency_monthly_fy" DOUBLE,
  "n__of_dwp_power_sourced_from_coal_annually_cy" DOUBLE,
  "target_of_dwp_power_sourced_from_coal_annually" VARCHAR,
  "cumulative_fit_installations_in_kw_quarterly" DOUBLE,
  "target_cumulative_fit_installations_in_mw_quarterly_ta_9579af09" DOUBLE,
  "sip_installed_capacity_kw_quarterly_fy" DOUBLE,
  "sip_cumulative_capacity_kw_quarterly_fy" DOUBLE,
  "avg_interconnect_time_days_quarterly_fy" DOUBLE,
  "target_avg_interconnect_time_days_quarterly_fy" VARCHAR,
  "once_through_cooling_otc_flow_mgd_annually_cy" DOUBLE,
  "target_once_through_cooling_otc_flow_mgd_annually" VARCHAR,
  "recycled_water_use_in_acre_feet_monthly" DOUBLE,
  "recycled_water_use_in_acre_feet_annual" DOUBLE,
  "target_recycled_water_use_in_acre_feet_annual" DOUBLE,
  "system_average_interruption_frequency_index_saifi_annual" DOUBLE,
  "target_system_average_interruption_frequency_index_sai_93084404" DOUBLE,
  "system_average_interruption_duration_index_saidi_annual" DOUBLE,
  "target_system_average_interruption_duration_index_saidi_annual" DOUBLE,
  "power_poles_replaced_installed_and_reinforced_annual_fy" DOUBLE,
  "target_power_poles_replaced_installed_and_reinforced_annual_fy" DOUBLE
);