Name: LA Department Of Water & Power Performance Metrics
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

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

46.2 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  -- Call Wait Time (minutes) (Monthly),
  "target_call_wait_time_minutes_under_monthly" DOUBLE  -- TARGET: Call Wait Time (minutes) - Under (Monthly),
  "no_of_estimated_bills_monthly" DOUBLE  -- No. Of Estimated Bills (Monthly),
  "total_bills_including_est_bills_monthly" DOUBLE  -- Total Bills (including Est. Bills) (Monthly),
  "estimated_bill_percentage_monthly" DOUBLE  -- Estimated Bill Percentage (Monthly),
  "water_main_breaks_annual_fy" DOUBLE  -- Water Main Breaks (Annual FY),
  "cumulative_miles_of_water_main_replaced_annual" DOUBLE  -- Cumulative Miles Of Water Main Replaced (Annual),
  "target_cumulative_miles_of_water_main_replaced_annual" VARCHAR  -- TARGET: Cumulative Miles Of Water Main Replaced (Annual),
  "per_capita_water_use_gallons_per_day_annually" DOUBLE  -- Per Capita Water Use (gallons Per Day) (Annually),
  "target_per_capita_water_use_gallons_per_day_annually" VARCHAR  -- TARGET: Per Capita Water Use (gallons Per Day) (Annually),
  "water_purchased_from_mwd_annually" DOUBLE  -- Water Purchased From MWD (Annually),
  "target_water_purchased_from_mwd_monthly" VARCHAR  -- TARGET: Water Purchased From MWD (Monthly),
  "n__of_dwp_water_sourced_from_local_groundwater_annually" DOUBLE  -- % Of DWP Water Sourced From Local Groundwater (Annually),
  "target_of_dwp_water_sourced_from_local_groundwater_annually" VARCHAR  -- TARGET: % Of DWP Water Sourced From Local Groundwater (Annually),
  "co2_emissions_from_all_owned_and_purchased_power_gener_b8725899" DOUBLE  -- CO2 Emissions From All Owned And Purchased Power Generation ( In Million Metric Tons) (Annually CY),
  "target_co2_emissions_from_all_owned_and_purchased_powe_a74034a1" VARCHAR  -- TARGET: CO2 Emissions From All Owned And Purchased Power Generation ( In Million Metric Tons) (Annually CY),
  "renewables_percentage_annually" DOUBLE  -- Renewables Percentage (Annually),
  "target_renewables_percentage_annually" DOUBLE  -- TARGET: Renewables Percentage (Annually),
  "kwh_of_power_from_energy_efficiency_monthly_fy" DOUBLE  -- KWh Of Power From Energy Efficiency (Monthly FY),
  "target_kwh_of_power_from_energy_efficiency_monthly_fy" DOUBLE  -- TARGET: KWh Of Power From Energy Efficiency (Monthly FY),
  "n__of_dwp_power_sourced_from_coal_annually_cy" DOUBLE  -- % Of DWP Power Sourced From Coal (Annually CY),
  "target_of_dwp_power_sourced_from_coal_annually" VARCHAR  -- TARGET: % Of DWP Power Sourced From Coal (Annually),
  "cumulative_fit_installations_in_kw_quarterly" DOUBLE  -- Cumulative FiT Installations (in KW) (Quarterly),
  "target_cumulative_fit_installations_in_mw_quarterly_ta_9579af09" DOUBLE  -- TARGET: Cumulative FiT Installations (in MW) (Quarterly) - TARGET DATE 2016,
  "sip_installed_capacity_kw_quarterly_fy" DOUBLE  -- SIP Installed Capacity (kW) (Quarterly FY),
  "sip_cumulative_capacity_kw_quarterly_fy" DOUBLE  -- SIP Cumulative Capacity (kW) (Quarterly FY),
  "avg_interconnect_time_days_quarterly_fy" DOUBLE  -- Avg Interconnect Time (days) (Quarterly FY),
  "target_avg_interconnect_time_days_quarterly_fy" VARCHAR  -- TARGET: Avg Interconnect Time (days) (Quarterly FY),
  "once_through_cooling_otc_flow_mgd_annually_cy" DOUBLE  -- Once Through Cooling (OTC) Flow, (MGD) (Annually CY),
  "target_once_through_cooling_otc_flow_mgd_annually" VARCHAR  -- TARGET: Once Through Cooling (OTC) Flow, (MGD) (Annually),
  "recycled_water_use_in_acre_feet_monthly" DOUBLE  -- Recycled Water Use In Acre Feet (Monthly),
  "recycled_water_use_in_acre_feet_annual" DOUBLE  -- Recycled Water Use In Acre Feet (Annual),
  "target_recycled_water_use_in_acre_feet_annual" DOUBLE  -- TARGET: Recycled Water Use In Acre Feet (Annual),
  "system_average_interruption_frequency_index_saifi_annual" DOUBLE  -- System Average Interruption Frequency Index - SAIFI (Annual),
  "target_system_average_interruption_frequency_index_sai_93084404" DOUBLE  -- TARGET: System Average Interruption Frequency Index - SAIFI (Annual),
  "system_average_interruption_duration_index_saidi_annual" DOUBLE  -- System Average Interruption Duration Index: SAIDI (Annual),
  "target_system_average_interruption_duration_index_saidi_annual" DOUBLE  -- TARGET: System Average Interruption Duration Index: SAIDI (Annual),
  "power_poles_replaced_installed_and_reinforced_annual_fy" DOUBLE  -- Power Poles Replaced, Installed And Reinforced (Annual FY),
  "target_power_poles_replaced_installed_and_reinforced_annual_fy" DOUBLE  -- TARGET: Power Poles Replaced, Installed, And Reinforced (Annual FY)
);