home / nyc_ll84

Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHG intensity (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 Calendar Year = 2013 and Property Type = "Library" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Postal Code, Site EUI (kBtu/ft2), Weather Norm Site EUI (kBtu/ft2), Source EUI (kBtu/ft2), Total GHG (MtCO2e), GHGI (kgCO2e/m2), Indirect GHG (MtCO2e), Electricity (kBtu), Natural Gas Use (kBtu), Fuel Oil #2 Use (kBtu), Fuel Oil #5 & 6 Use (kBtu), Water Use (kgal)

Borough 4

  • MANHATTAN 3
  • BRONX 1
  • QUEENS 1
  • STATEN IS 1

Property Type 1

  • Library · 6 ✖

Calendar Year 1

  • 2013 · 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
37053 37053 2013 2638690 Walsh Library BRONX 439 E Fordham Rd 10458 Library 245000 1,997 1 Not Available 124.4 124.6 237.1 1970.9 86.59 955.2 1015.7 12483697.5 17998654.1 0.0 0.0 0.0 0.0 0.0 2032730001 2102052
39178 39178 2013 2699141 2520 Amsterdam Avenue (Gottesman Library) MANHATTAN 2520 Amsterdam Avenue 10033 Library 140260 1,967 1 Not Available 118.1 115.6 190.6 1276.7 97.98 894.7 382.0 4694911.6 0.0 0.0 0.0 0.0 11874343.7 1380.9 1-02156-0048 1063737
39263 39263 2013 2704422 Vanderbilt Hall MANHATTAN 40 Washington Square South 10012 Library 257259 1,951 1 Not Available 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1005410001 1008716
39472 39472 2013 2710354 Bobst Library MANHATTAN 70 Washington Square South, 10012 Library 505205 1,972 1 Not Available 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.0 21045.0 0.0 0.0 0.0 1005350008 1008626
40937 40937 2013 2785921 Marillac Hall QUEENS 8000 Utopia Parkway 11439 Library 137050 1,970 1 Not Available 155.3 154.2 303.0 1389.3 109.12 642.9 746.4 9174038.4 12114606.7 0.0 0.0 0.0 0.0 6445.3 4070210001 4439412
42498 42498 2013 2815089 Loreto Memorial Library STATEN IS 300 Howard Avenue 10301 Library 18739 1,973 1 Not Available 109.2 108.9 276.1 149.6 85.93 31.9 117.7 1446925.7 600209.7 0.0 0.0 0.0 0.0 0.0 5005930500 5106890

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