Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHG intensity (kgCO2e/m²), and fuel use by type. Filter using the column boxes or left-side facets. Export to CSV or JSON.

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

5 rows where Calendar Year = 2011 and Property Type = "Lodging" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Year Built, Electricity (kBtu), Natural Gas Use (kBtu)

Borough 3

Property Type 1

  • Lodging · 5 ✖

Calendar Year 1

  • 2011 · 5 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Postal Code Property Type Floor Area (ft2) Year Built Number of Buildings ENERGY STAR Score Site EUI (kBtu/ft2) Weather Norm Site EUI (kBtu/ft2) Source EUI (kBtu/ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Electricity (kBtu) Natural Gas Use (kBtu) District Steam Use (kBtu) Fuel Oil #2 Use (kBtu) Fuel Oil #4 Use (kBtu) Fuel Oil #5 & 6 Use (kBtu) Water Use (kgal) BBL BIN
12398 12398 2011 2714174 New York Athletic Club MANHATTAN 180 Central Park South 10,019 Lodging 400,000 1927   0 139.0 138.0 169.0 4.0 107.64 178.66 4.0 18.0 3.0 55.0         1010110001  
18410 18410 2011 3187683 599 Ralph BROOKLYN 599 Ralph Ave 11,233 Lodging 65,125 1921   0 70.1 67.6 153.8 335.72 55594.72 121.34 214.38 2.0 2.0           3014750004 3330725
18607 18607 2011 2664412 Tillary Street Shelter BROOKLYN 200 Tillary Street 11,201 Lodging 60,460 1927   0 110.8 110.1 266.4 517.76 92885.28 145.35 372.41 3.0 2.0           3020500104 3058216
22449 22449 2011 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue 11,434 Lodging 69,345 1964   0                             4133800011 4286131
22450 22450 2011 2961856 175-15 Rockaway Blvd.   175-15 149 road 11,215 Lodging 71,482 1963   0 153.8 158.8 276.4 731.22 110856.04 393.53 337.7 3.0 7.0           4133810001 4286135

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE summary(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Postal Code" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Year Built" TEXT,
  "Number of Buildings" TEXT,
  "ENERGY STAR Score" TEXT,
  "Site EUI (kBtu/ft2)" REAL,
  "Weather Norm Site EUI (kBtu/ft2)" REAL,
  "Source EUI (kBtu/ft2)" REAL,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Electricity (kBtu)" REAL,
  "Natural Gas Use (kBtu)" 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,
  "Water Use (kgal)" REAL,
  BBL TEXT,
  BIN TEXT
);
CREATE INDEX "idx_summary_Calendar Year" ON [summary] ("Calendar Year");
CREATE INDEX "idx_summary_Property ID" ON [summary] ("Property ID");
CREATE INDEX "idx_summary_Borough" ON [summary] ("Borough");
CREATE INDEX "idx_summary_Property Type" ON [summary] ("Property Type");
CREATE INDEX "idx_summary_Postal Code" ON [summary] ("Postal Code");