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

7 rows where Calendar Year = 2010 and Property Type = "House of Worship" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ENERGY STAR Score, Electricity (kBtu)

Borough 4

  • BRONX 2
  • MANHATTAN 2
  • QUEENS 1
  • STATEN IS 1

Property Type 1

  • House of Worship · 7 ✖

Calendar Year 1

  • 2010 · 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
3795 3795 2010 2810237 Passionist Spiritual Center BRONX 5801 Palisade Avenue 10,471 House of Worship 54,500     16 115.6 115.6 162.2 479.41 95561.51 380.0 99.41 1.0 273.0   4.0       2059330055 2086132
4241 4241 2010 2657294 Chinatown Corps MANHATTAN 223-225 Bowery 100,021,218 House of Worship 64,760     0 42.1 41.5 61.8 202.15 33998.79 152.33 49.82 530.0 442.0   1.0          
7778 7778 2010 2815019 Lavelle Hall STATEN IS 300 Howard Avenue 10,301 House of Worship 25,700     7 152.9 153.7 228.5 298.11 128353.05 222.01 76.1 810.0 366.0   2.0       5005930500 5106892
8340 8340 2010 2810323 St. Thomas More Church QUEENS 8000 Utopia Parkway 11,439 House of Worship 13,486     1 160.4 158.1 372.7 164.04 135823.86 50.98 113.07 1.0 958.0           4070210001 4462481
9989 9989 2010 2793010 Bethel Gospel Assembly, Inc. MANHATTAN 1832 Madison Avenue 10,035 House of Worship 139,404     0                             1017460002 1087193
10032 10032 2010 2812756 Church of St. Nicholas BRONX 2345 University Ave 10,468 House of Worship 100,000     72 28.0 28.0 71.7 224.06 24117.59 50.35 173.71 1.0 946.0           2032180035 2118380
10033 10033 2010 2812870 Church of St. Paul the Apostle   Columbus Ave at 60th Street 10,019 House of Worship 62,098     7 77.3 77.3 136.1 316.21 54897.63 175.92 140.29 1.0 3.0              

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 198.534ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability