Energy — EUI and Fuel Use by Type

Site EUI, source EUI, electricity, natural gas, steam, oil, and renewables.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

8 rows where Borough = "QUEENS" and Property Type = "Education" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Site EUI (kBtu/ft2), Weather Norm Site EUI (kBtu/ft2), National Median Site EUI (kBtu/ft2), Source EUI (kBtu/ft2), Weather Norm Source EUI (kBtu/ft2), Total Site Energy (kBtu), Electricity (kBtu), Natural Gas Use (kBtu), Natural Gas Use (therms)

Calendar Year 3

Property Type 1

  • Education · 8 ✖

Borough 1

  • QUEENS · 8 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) ENERGY STAR Score Site EUI (kBtu/ft2) Weather Norm Site EUI (kBtu/ft2) National Median Site EUI (kBtu/ft2) Source EUI (kBtu/ft2) Weather Norm Source EUI (kBtu/ft2) Total Site Energy (kBtu) Electricity (kBtu) Electricity (kWh) Natural Gas Use (kBtu) Natural Gas Use (therms) District Steam Use (kBtu) Fuel Oil #2 Use (kBtu) Fuel Oil #4 Use (kBtu) Fuel Oil #5 & 6 Use (kBtu) Diesel #2 Use (kBtu) District Hot Water Use (kBtu) District Chilled Water Use (kBtu) Green Power - Onsite (kWh) Green Power - Offsite (kWh)
22989 22989 2012 1819837 Center for Automotive Education and Training QUEENS 15-30 Petracca Place Education 92705 0.0 0.0 0.0 58.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0   0.0
28977 28977 2012 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609247 0.0 79.3 81.5 58.0 238.6 242.1 48315169.6 41329833.0   6985336.61 69853.4 0.0 0.0 0.0 0.0 0.0 0.0 0.0   0.0
34335 34335 2012 3321105 NY School of Urban Ministry QUEENS 31-10 47th Street Education 70000 0.0 0.0 0.0 58.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0   0.0
34411 34411 2012 3332502 Congregation YGS QUEENS 74-10 88th Street Education 66713 0.0 91.7 99.6 58.0 185.5 193.8 6117545.3 2604929.92   3512615.38 35126.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0   0.0
20516 20516 2011 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609,247 0.0 80.5 81.6 58.0 240.2   49.0 41.0 12.0 7.0 76.0                  
21534 21534 2011 1819837 Center for QUEENS 15-30 Petracca Place Education 92,705 0.0 84.9 83.5 58.0 210.4   7.0 4.0 1.0 2.0 29.0                  
722 722 2010 1819837 Center for Automotive Education and Training QUEENS 15-30 Petracca Place Education                                          
9155 9155 2010 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609,247 0.0 54.4 55.6 76.0 154.9 156.2 33.0 26.0 7.0 7.0 71.0                  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE energy(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "ENERGY STAR Score" REAL,
  "Site EUI (kBtu/ft2)" REAL,
  "Weather Norm Site EUI (kBtu/ft2)" REAL,
  "National Median Site EUI (kBtu/ft2)" REAL,
  "Source EUI (kBtu/ft2)" REAL,
  "Weather Norm Source EUI (kBtu/ft2)" REAL,
  "Total Site Energy (kBtu)" REAL,
  "Electricity (kBtu)" REAL,
  "Electricity (kWh)" REAL,
  "Natural Gas Use (kBtu)" REAL,
  "Natural Gas Use (therms)" REAL,
  "District Steam Use (kBtu)" REAL,
  "Fuel Oil #2 Use (kBtu)" REAL,
  "Fuel Oil #4 Use (kBtu)" REAL,
  "Fuel Oil #5 & 6 Use (kBtu)" REAL,
  "Diesel #2 Use (kBtu)" REAL,
  "District Hot Water Use (kBtu)" REAL,
  "District Chilled Water Use (kBtu)" REAL,
  "Green Power - Onsite (kWh)" REAL,
  "Green Power - Offsite (kWh)" REAL
);
CREATE INDEX "idx_energy_Calendar Year" ON [energy] ("Calendar Year");
CREATE INDEX "idx_energy_Property ID" ON [energy] ("Property ID");
CREATE INDEX "idx_energy_Borough" ON [energy] ("Borough");
CREATE INDEX "idx_energy_Property Type" ON [energy] ("Property Type");