Municipal Building Energy Use by US Government | Environmental and Climate Sciences

About this Dataset

Municipal Building Energy Use

Monthly energy use metrics for City-owned properties generated by Energy STAR Portfolio Manager (ESPM). Metrics include energy use (electric and gas) and those generated by ESPM: Site EUI (Energy Use Intensity) measured in energy use per square foot, Greenhouse Gas Emissions (Metric Tons CO2e), and Energy STAR Score where available.

Available at https://nola.gov/next/resilience-sustainability/energy/municipal-building-energy-use-dashboard.

Data updates monthly.
Organization: City of New Orleans
Last updated: 2025-06-14T17:30:43.816225
Tags: resilience, sustainability

Tables

Table 1

@usgov.city_of_new_orleans_municipal_building_energy_use.table_1

2.03 MB
16343 rows
59 columns


CREATE TABLE table_1 (
  "month" VARCHAR,
  "property_name" VARCHAR,
  "parent_property_name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "country" VARCHAR,
  "property_gfa_self_reported_sq_ft" BIGINT,
  "year_built" BIGINT,
  "portfolio_manager_property_id" BIGINT,
  "electricity_use_grid_purchase_kwh" DOUBLE,
  "electricity_use_grid_purchase_kbtu" DOUBLE,
  "electricity_use_generated_from_onsite_renewable_system_436fa1a2" VARCHAR,
  "electricity_use_generated_from_onsite_renewable_system_a82eeb5b" VARCHAR,
  "electricity_use_grid_purchase_and_generated_from_onsit_e4713417" DOUBLE,
  "electricity_use_grid_purchase_and_generated_from_onsit_564ca541" DOUBLE,
  "electricity_weather_normalized_site_electricity_use_gr_7f7dcbfe" DOUBLE,
  "electricity_weather_normalized_site_electricity_use_gr_4146dc2c" DOUBLE,
  "electricity_weather_normalized_site_electricity_intens_8e9b1e26" DOUBLE,
  "electricity_use_grid_monthly_kbtu" DOUBLE,
  "electricity_use_onsite_renewables_monthly_kbtu" VARCHAR,
  "percent_electricity" DOUBLE,
  "natural_gas_use_therms" DOUBLE,
  "natural_gas_use_kbtu" DOUBLE,
  "natural_gas_weather_normalized_site_natural_gas_use_kbtu" DOUBLE,
  "natural_gas_weather_normalized_site_natural_gas_use_therms" DOUBLE,
  "natural_gas_weather_normalized_site_natural_gas_intens_348e62f9" DOUBLE,
  "natural_gas_use_monthly_kbtu" DOUBLE,
  "energy_star_score" DOUBLE,
  "site_energy_use_kbtu" DOUBLE,
  "source_energy_use_kbtu" DOUBLE,
  "site_eui_kbtu_sq_ft" DOUBLE,
  "source_eui_kbtu_sq_ft" DOUBLE,
  "weather_normalized_site_energy_use_kbtu" DOUBLE,
  "weather_normalized_source_energy_use_kbtu" DOUBLE,
  "weather_normalized_site_eui_kbtu_sq_ft" DOUBLE,
  "weather_normalized_source_eui_kbtu_sq_ft" DOUBLE,
  "national_median_site_energy_use_kbtu" DOUBLE,
  "national_median_source_energy_use_kbtu" DOUBLE,
  "national_median_site_eui_kbtu_sq_ft" DOUBLE,
  "national_median_source_eui_kbtu_sq_ft" DOUBLE,
  "n__difference_from_national_median_site_eui" DOUBLE,
  "n__difference_from_national_median_source_eui" DOUBLE,
  "site_energy_use_adjusted_to_current_year_kbtu" DOUBLE,
  "site_eui_adjusted_to_current_year_kbtu_sq_ft" DOUBLE,
  "source_energy_use_adjusted_to_current_year_kbtu" DOUBLE,
  "source_eui_adjusted_to_current_year_kbtu_sq_ft" DOUBLE,
  "total_location_based_ghg_emissions_metric_tons_co2e" DOUBLE,
  "total_location_based_ghg_emissions_intensity_kgco2e_sq_ft" DOUBLE,
  "direct_ghg_emissions_metric_tons_co2e" DOUBLE,
  "direct_ghg_emissions_intensity_kgco2e_sq_ft" DOUBLE,
  "indirect_location_based_ghg_emissions_metric_tons_co2e" DOUBLE,
  "indirect_location_based_ghg_emissions_intensity_kgco2e_sq_ft" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "row_identifier" VARCHAR
);