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

9 rows where Borough = "MANHATTAN" and Property Type = "House of Worship" 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, Year Built, ENERGY STAR Score, District Steam Use (kBtu), Fuel Oil #5 & 6 Use (kBtu), BBL, BIN

Calendar Year 3

  • 2011 4
  • 2012 3
  • 2010 2

Property Type 1

  • House of Worship · 9 ✖

Borough 1

  • MANHATTAN · 9 ✖
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
24602 24602 2012 2657294 Chinatown Corps MANHATTAN 225 Bowery 100,021,218 House of Worship 64760 1910   0 43.8 44.3 60.4         445699.89 320944.18 0.0 2067038.79 0.0 0.0   1004260005 1089461
33898 33898 2012 3136028 Saint Thomas Church MANHATTAN 1 West 53rd Street 10,019 House of Worship 51047 1913   31 64.4 69.4 143.1         1573062.78 139192.98 1574628.28 0.0 0.0 0.0   1012690030 1034531
34147 34147 2012 3250660 1047 Amsterdam Avenue MANHATTAN 1047 Amsterdam Avenue 10,025 House of Worship 241550 1900   17 88.9 89.7 130.9         4253299.69 1040660.61 0.0 7766945.38 0.0 8403025.91   1018650001 1082706
12704 12704 2011 2812870 Church of MANHATTAN 415 West 59th St 10,019 House of Worship 77,098 1874   0 65.5 68.1 132.6 356.23 49797.72 154.11 202.13 2.0 2.0           1011310016 1076229
13164 13164 2011 3121252 Holy Spirit Association for the Unification of World Christianity / HSA-UWC MANHATTAN 4 W 43rd Street 100,367,408 House of Worship   1895                                 1012580042 BIN # 1034201
13247 13247 2011 3136028 Saint Thomas Church MANHATTAN 1 West 53rd Street 10,019 House of Worship 51,047 1913   22 77.8 77.8 164.8 335.59 70828.57 7.08 328.51 1.0 133.0 2.0         1012690030 1034531
13739 13739 2011 3121128 Christ Chu MANHATTAN 520 Park Avenue 10,065 House of Worship 47,354 1931   78 20.5 20.5 68.4 91.02 20845.32   91.02 969.0             1013750036 1040805
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          
9989 9989 2010 2793010 Bethel Gospel Assembly, Inc. MANHATTAN 1832 Madison Avenue 10,035 House of Worship 139,404     0                             1017460002 1087193

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