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

10 rows where Borough = "STATEN IS" and Property Type = "College/University (Campus-Level)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Year Built, 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), Fuel Oil #5 & 6 Use (kBtu), BBL, BIN

Calendar Year 3

  • 2011 5
  • 2012 3
  • 2010 2

Property Type 1

  • College/University (Campus-Level) · 10 ✖

Borough 1

  • STATEN IS · 10 ✖
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
27937 27937 2012 2750759 Wagner College STATEN IS 631 Howard Avenue 10,301 College/University (Campus-Level) 834490 1921   0 82.3 82.3 162.4         28269122.87 6729100.0 0.0 0.0 0.0 33686499.81   5006200001 5147163
30366 30366 2012 2815016 Da Silva Academic Center STATEN IS 300 Howard Avenue 10,301 College/University (Campus-Level) 38000 2004   0 104.1 109.6 264.2         2571283.2 1385300.0 0.0 0.0 0.0 0.0   5005930500 5106892
30370 30370 2012 2815047 Mahoney Hall STATEN IS 300 Howard Avenue 10,301 College/University (Campus-Level) 12982 1945   0 92.2 101.0 146.9         284970.24 912100.0 0.0 0.0 0.0 0.0   5005930500 5106892
22599 22599 2011 2815047 Mahoney Hall STATEN IS 300 Howard Avenue 10,301 College/University (Campus-Level) 12,982 1945   0 81.0 85.2 141.0 68.87 61775.82 38.96 29.91 318.0 732.0           5005930500  
22602 22602 2011 2815016 Da Silva Academic Center STATEN IS 300 Howard Avenue 10,301 College/University (Campus-Level) 38,000 2004   0 118.9 121.0 293.0 354.04 100285.56 91.87 262.17 2.0 1.0           5005930500 5106890
22621 22621 2011 2750759 Wagner Col STATEN IS 631 Howard Avenue 10,301 College/University (Campus-Level) 834,490 1921   0 157.3 155.5 242.7 9.0 116.16 6.0 2.0 29.0 63.0       38.0   5006130016 5147163;5113153;5113454;5015801;5016177;5138008
22622 22622 2011 2750759 Wagner Col STATEN IS 631 Howard Avenue 10,301 College/University (Campus-Level) 834,490 1921   0 157.3 155.5 242.7 9.0 116.16 6.0 2.0 29.0 63.0       38.0   5006200001 5147163;5113153;5113454;5015801;5016177;5138008
22623 22623 2011 2750759 Wagner Col STATEN IS 631 Howard Avenue 10,301 College/University (Campus-Level) 834,490 1921   0 157.3 155.5 242.7 9.0 116.16 6.0 2.0 29.0 63.0       38.0   5006300163 5147163;5113153;5113454;5015801;5016177;5138008
7774 7774 2010 2815016 Da Silva Academic Center STATEN IS 300 Howard Avenue 10,301 College/University (Campus-Level) 38,000     0 98.6 99.5 250.5 298.61 84584.43 69.43 229.17 2.0 1.0           5005930500 5106892
7780 7780 2010 2815047 Mahoney Hall STATEN IS 300 Howard Avenue 10,301 College/University (Campus-Level) 12,982     0 75.8 79.8 137.8 65.82 59039.99 34.8 31.02 330.0 654.0           5005930500 5106892

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");
Powered by Datasette · Queries took 412.153ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability