Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHGI (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

7 rows where Calendar Year = 2012 and Property Type = "Lodging" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Postal Code, Year Built, District Steam Use (kBtu)

Borough 3

Property Type 1

  • Lodging · 7 ✖

Calendar Year 1

  • 2012 · 7 ✖
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
24387 24387 2012 2651692 thestanton MANHATTAN 196 stanton street 10,002 Lodging 66371 2010   0 34.2 34.3 74.3         1113905.4 1154900.0 0.0 0.0 0.0 0.0   1003457502 1088333
24937 24937 2012 2664412 Tillary Street Shelter BROOKLYN 200 Tillary Street 11,201 Lodging 60460 1927   0 102.1 106.6 256.2         3936565.02 2236002.94 0.0 0.0 0.0 0.0   3020500104 3058216
26787 26787 2012 2714174 New York Athletic Club MANHATTAN 180 Central Park South 10,019 Lodging 400000 1927   0 137405.4 137405.4 166366.8         20204499.2 3366270.6 54938602620.0 0.0 0.0 0.0   1010110001 1023750
28829 28829 2012 2795018 Belt Park Associates   153-90 Rockaway Boulavard 11,434 Lodging 70690 1963   0 118.4 127.1 203.6         2452818.56 5920100.0 0.0 0.0 0.0 0.0      
31921 31921 2012 2961856 175-15 Rockaway Blvd.   175-15 149 road 11,215 Lodging 71482 1963   0 152.3 161.5 273.1         3544733.0 7338700.0 0.0 0.0 0.0 0.0      
33493 33493 2012 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue 11,434 Lodging 69345 1964   0 102.5 110.6 189.5         2484599.79 4624300.0 0.0 0.0 0.0 0.0   4133800011 4286131
33981 33981 2012 3187683 599 Ralph Ave BROOKLYN 599 Ralph Ave 11,233 Lodging 65125 1921   0 75.7 74.4 151.0         2038770.35 2888300.0 0.0 0.0 0.0 0.0   3014750004 3330725

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");