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 = 2016 and Property Type = "Automobile Dealership" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 2

  • MANHATTAN 3
  • QUEENS 1

Property Type 1

  • Automobile Dealership · 5 ✖

Calendar Year 1

  • 2016 · 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)
88577 88577 2016 2,820,270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE Automobile Dealership 65,625 0.0 98.9 107.9 78.4 164.1 173.6 6488913.0 1891612.8   4597300.1   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
88578 88578 2016 2,820,273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE Automobile Dealership 91,256 0.0 76.5 81.7 61.8 161.0 164.6 6981849.1 3522548.9   3459300.2   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
88579 88579 2016 4,124,879 POTAMKIN HY HOLDINGS LLC MANHATTAN 2485 2nd ave Automobile Dealership 137,456 0.0 35.0 35.8 45.2 101.0 101.8 4816361.2 4219961.2   596400.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
91943 91943 2016 5,224,698 50-30 Northern Blvd QUEENS 50-30 Northern Blvd Automobile Dealership 60,485 0.0 81.7 88.8 89.2 119.2 124.4 4943606.8 966100.0   3977506.8   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
94650 94650 2016 5,236,998 open road manhattan llc   802 11 ave Automobile Dealership 228,000 0.0 60.1 64.5 56.5 138.2 141.9 13695407.1 8195139.5   5500267.6   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.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 2172.283ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability