home / nyc_ll84

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

6 rows where Borough = "BRONX" and Property Type = "Entertainment/Culture" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Postal Code, Floor Area (ft2), Year Built, Electricity (kBtu), BBL, BIN

These facets timed out: Property Type

Calendar Year 3

  • 2010 2
  • 2011 2
  • 2012 2

Borough 1

  • BRONX · 6 ✖
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 Parent Property ID
27186 27186 2012 2730626 Whitestone Multiplex BRONX 2505 Bruckner Boulevard 10,465 Entertainment/Culture 64760 1983   0 102.5 104.7 281.9         4929202.67 1710630.3 0.0 0.0 0.0 0.0   2052930001 2072579  
27442 27442 2012 2734903 Concourse Plaza BRONX 214 East 161st Street 10,451 Entertainment/Culture 55000 1991   0 146.2 151.5 360.9         4986393.92 3054055.79 0.0 0.0 0.0 0.0   2024430090 2002456  
16081 16081 2011 2734903 Concourse BRONX 214 East 161st Street 10,451 Entertainment/Culture 55,000 1991   0 166.6 170.7 377.7 685.85 134225.83 227.98 457.87 4.0 4.0           2024430090 2002456  
17744 17744 2011 2730626 Whitestone BRONX 2505 Bruckner Boulevard 10,465 Entertainment/Culture 64,760 1983   0 109.7 113.4 295.4 585.31 98440.91 106.61 478.7 5.0 2.0           2052930001 2072579  
3524 3524 2010 2734903 Concourse Plaza BRONX 214 East 161st Street 10,451 Entertainment/Culture 55,000     0 167.1 170.5 393.3 702.03 137392.38 210.28 491.75 5.0 3.0           2024430090 2002456  
3526 3526 2010 2730626 Whitestone Multiplex BRONX 2505 Bruckner Boulevard 10,465 Entertainment/Culture 64,760     0 113.8 113.3 314.8 616.91 103755.59 98.27 518.64 5.0 1.0           2052930001 2072579  

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,
  "Parent Property ID"
);
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");
CREATE INDEX "idx_summary_Parent Property ID" ON [summary] ("Parent Property ID");
Powered by Datasette · Queries took 1199.157ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability