About this Dataset

Building Energy Benchmarking Data, 2015-Present

Seattle’s Building Energy Benchmarking Program (SMC 22.920) requires owners of non-residential and multifamily buildings (Greater than 20,000 square feet) to track energy performance and annually report to the City of Seattle. Annual benchmarking, reporting, and disclosing of building performance are foundational elements of creating more market value for energy efficiency.

Per Ordinance (125000), starting with 2015 energy use performance reporting, the City of Seattle is making the data for all buildings greater than 20,000 SF available annually. This dataset contains benchmarking records for all buildings required to report for years 2015-2023.

If you have questions or comments on the data, email us at energybenchmarking@seattle.gov and include Open Data in the subject line.
Organization: City of Seattle
Last updated: 2024-12-16T22:33:32.397103
Tags: benchmarking, building-energy, buildings, climate-change, commercial-buildings, electricity, energy, energy-star, eui, fossil-fuel, fossil-gas, gas, greenhouse-gas, multifamily, multifamily-buildings, office-of-sustainability-and-environment, ose, steam

Tables

Table 1

@usgov.city_of_seattle_building_energy_benchmarking_data_2015_present.table_1

2.36 MB
30,657 rows
46 columns

CREATE TABLE table_1 (
  "osebuildingid" BIGINT,
  "datayear" BIGINT,
  "buildingname" VARCHAR,
  "buildingtype" VARCHAR,
  "taxparcelidentificationnumber" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "neighborhood" VARCHAR,
  "councildistrictcode" BIGINT,
  "yearbuilt" BIGINT,
  "numberoffloors" DOUBLE,
  "numberofbuildings" DOUBLE,
  "propertygfatotal" BIGINT,
  "propertygfabuildings" BIGINT,
  "propertygfaparking" BIGINT,
  "selfreportgfatotal" BIGINT,
  "selfreportgfabuildings" BIGINT,
  "selfreportparking" BIGINT,
  "energystarscore" DOUBLE,
  "siteeuiwn_kbtu_sf" DOUBLE  -- SiteEUIWN(kBtu/sf),
  "siteeui_kbtu_sf" DOUBLE  -- SiteEUI(kBtu/sf),
  "siteenergyuse_kbtu" DOUBLE  -- SiteEnergyUse(kBtu),
  "siteenergyusewn_kbtu" DOUBLE  -- SiteEnergyUseWN(kBtu),
  "sourceeuiwn_kbtu_sf" DOUBLE  -- SourceEUIWN(kBtu/sf),
  "sourceeui_kbtu_sf" DOUBLE  -- SourceEUI(kBtu/sf),
  "epapropertytype" VARCHAR,
  "largestpropertyusetype" VARCHAR,
  "largestpropertyusetypegfa" DOUBLE,
  "secondlargestpropertyusetype" VARCHAR,
  "secondlargestpropertyusetypegfa" DOUBLE,
  "thirdlargestpropertyusetype" VARCHAR,
  "thirdlargestpropertyusetypegfa" DOUBLE,
  "electricity_kwh" DOUBLE  -- Electricity(kWh),
  "steamuse_kbtu" DOUBLE  -- SteamUse(kBtu),
  "naturalgas_therms" DOUBLE  -- NaturalGas(therms),
  "compliancestatus" VARCHAR,
  "complianceissue" VARCHAR,
  "electricity_kbtu" DOUBLE  -- Electricity(kBtu),
  "naturalgas_kbtu" DOUBLE  -- NaturalGas(kBtu),
  "totalghgemissions" DOUBLE,
  "ghgemissionsintensity" DOUBLE,
  "demolished" BOOLEAN
);