About this Dataset

Allegheny County Municipal Building Energy And Water Use

This dataset contains energy and water use information from 2010 to the previous full month for County-operated buildings. Metrics include: kBtu (thousand British thermal units), site and source EUI (energy use intensity), annual electricity, natural gas and steam consumption and cost, and water and sewer use and cost. Weather-normalized data enable building performance comparisons over time, despite unusual weather events.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:04:54.701299
Tags: _etl, buildings, energy, energy-efficiency, eui, sewer, water

Tables

Municipal Building Energy And Water Use (old Format)

@usgov.allegheny_county_city_of_pitts_allegheny_county_munici_7455dac5.municipal_building_energy_and_water_use_old_format

48.33 kB
720 rows
24 columns

CREATE TABLE municipal_building_energy_and_water_use_old_format (
  "site" VARCHAR,
  "site_id" VARCHAR,
  "year" BIGINT,
  "electricity_kbtu" BIGINT  -- Electricity (kBtu),
  "natural_gas_kbtu" BIGINT  -- Natural Gas (kBtu),
  "steam_kbtu" BIGINT  -- Steam (kBtu),
  "total_energy_kbtu" BIGINT  -- Total Energy (kBtu),
  "total_energy_cost" BIGINT  -- Total Energy Cost ($),
  "area_sqft" BIGINT  -- Area (SqFt),
  "site_eui_kbtu_ft" DOUBLE  -- Site EUI (kBtu/ft˛),
  "source_eui_kbtu_ft" DOUBLE  -- Source EUI (kBtu/ft˛),
  "weather_normalized_site_eui_kbtu_ft" DOUBLE  -- Weather Normalized Site EUI (kBtu/ft˛),
  "weather_normalized_source_eui_kbtu_ft" DOUBLE  -- Weather Normalized Source EUI (kBtu/ft˛),
  "water_kgal" BIGINT  -- Water (kGal),
  "sewer_kgal" BIGINT  -- Sewer (kGal),
  "water_cost" BIGINT  -- Water Cost ($),
  "sewer_cost" BIGINT  -- Sewer Cost ($),
  "address_line_1" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "zip_code_4" DOUBLE  -- Zip Code +4,
  "department" VARCHAR,
  "division_department_detail" VARCHAR
);