home / nyc_ll84

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

5 rows where Calendar Year = 2010 and Property Type = "Library" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 4

  • MANHATTAN 2
  • BRONX 1
  • QUEENS 1
  • STATEN IS 1

Property Type 1

  • Library · 5 ✖

Calendar Year 1

  • 2010 · 5 ✖
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)
3205 3205 2010 2711594 New York Academy of Medicine MANHATTAN 1216 5th Avenue Library 106,000 0.0 108.1 106.7 104.0 216.2 211.4 11.0 4.0 1.0 953.0 9.0       5.0          
3256 3256 2010 2638690 Walsh Library BRONX 439 E Fordham Rd Library 245,000 0.0 104.9 104.9 104.0 218.8 218.8 25.0 11.0 3.0 14.0 140.0                  
7779 7779 2010 2815089 Loreto Memorial Library STATEN IS 300 Howard Avenue Library 18,739 0.0 108.0 109.8 104.0 311.5 313.3 2.0 1.0 475.0 402.0 4.0                  
7991 7991 2010 2699141 2520 Amsterdam Avenue (Gottesman Library) MANHATTAN 2520 Amsterdam Avenue Library                                          
8332 8332 2010 2785921 Marillac Hall QUEENS 8000 Utopia Parkway Library 137,050 0.0 161.4 155.4 104.0 327.2 316.7 22.0 9.0 2.0 12.0 126.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");
Powered by Datasette · Queries took 1659.953ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability