Municipal Building Energy Usage by US Government | Finance and Economics

About this Dataset

Municipal Building Energy Usage

This data set contains energy use data from 2009-2014 for 139 municipally operated buildings. Metrics include: Site & Source EUI, annual electricity, natural gas and district steam consumption, greenhouse gas emissions and energy 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:12:51.547607
Tags: address, building, building-energy-use, conservation, district-steam, electricity, energy, energy-cost, energy-cost-intensity, energy-use-intensity, eui, government, greenhouse-gas-emissions, gross-floor-area, natural-gas, sustainability, usage, weather-normalized

Tables

Municipal Building Energy Use 2009-2014

@usgov.allegheny_county_city_of_pitts_municipal_building_energy_usage.municipal_building_energy_use_2009_2014

92 KB
834 rows
20 columns


CREATE TABLE municipal_building_energy_use_2009_2014 (
  "property_id" BIGINT,
  "property_name" VARCHAR,
  "address_1" VARCHAR,
  "property_gfa_self_reported_ft" BIGINT,
  "year_ending" TIMESTAMP,
  "site_eui_kbtu_ft" VARCHAR,
  "weather_normalized_site_eui_kbtu_ft" VARCHAR,
  "source_eui_kbtu_ft" VARCHAR,
  "weather_normalized_source_eui_kbtu_ft" VARCHAR,
  "electricity_use_grid_purchase_kbtu" VARCHAR,
  "electricity_use_grid_purchase_kwh" VARCHAR,
  "weather_normalized_site_electricity_kwh" VARCHAR,
  "natural_gas_use_kbtu" VARCHAR,
  "natural_gas_use_therms" VARCHAR,
  "weather_normalized_site_natural_gas_use_therms" VARCHAR,
  "district_steam_use_kbtu" VARCHAR,
  "total_ghg_emissions_metric_tons_co2e" VARCHAR,
  "total_ghg_emissions_intensity_kgco2e_ft" VARCHAR,
  "energy_cost" VARCHAR,
  "energy_cost_intensity_ft" VARCHAR
);

Municipal Building Energy Use Data Dictionary

@usgov.allegheny_county_city_of_pitts_municipal_building_energy_usage.municipal_building_energy_use_data_dictionary

6.29 KB
20 rows
6 columns


CREATE TABLE municipal_building_energy_use_data_dictionary (
  "column_name" VARCHAR,
  "definition" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);