home / nyc_ll84

GHG — Emissions and Intensity

Total, direct, indirect, and net GHG emissions. Includes GHGI (kgCO2e/m²) calculated for all years.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

3 rows where Calendar Year = 2014 and Property Type = "Courthouse" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 2

  • QUEENS 2
  • BRONX 1

Property Type 1

  • Courthouse · 3 ✖

Calendar Year 1

  • 2014 · 3 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Net GHG (MtCO2e) Grid Emissions Rate (kgCO2e/MBtu) Avoided GHG Onsite (MtCO2e) Avoided GHG Offsite (MtCO2e) National Median GHG (MtCO2e) ENERGY STAR Score Site EUI (kBtu/ft2)
57564 57564 2014 3317551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65874 949.3 155.12 392.3 557.0 949.3 82.9 0.0 0.0   0.0 214.1
61246 61246 2014 4405711 131 Walnut Avenue, Bronx BRONX 131 Walnut Avenue, Bronx Courthouse 110000 264.4 25.87 77.1 187.3 264.4 82.9 0.0 0.0   96.0 33.7
61703 61703 2014 4410169 57-13 49th Street, Queens QUEENS 57-13 49th Street, Queens Courthouse 74000 279.0 40.58 235.6 43.4 279.0 82.9 0.0 0.0   92.0 67.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE ghg(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Net GHG (MtCO2e)" REAL,
  "Grid Emissions Rate (kgCO2e/MBtu)" REAL,
  "Avoided GHG Onsite (MtCO2e)" REAL,
  "Avoided GHG Offsite (MtCO2e)" REAL,
  "National Median GHG (MtCO2e)" REAL,
  "ENERGY STAR Score" REAL,
  "Site EUI (kBtu/ft2)" REAL
);
CREATE INDEX "idx_ghg_Calendar Year" ON [ghg] ("Calendar Year");
CREATE INDEX "idx_ghg_Property ID" ON [ghg] ("Property ID");
CREATE INDEX "idx_ghg_Borough" ON [ghg] ("Borough");
CREATE INDEX "idx_ghg_Property Type" ON [ghg] ("Property Type");
Powered by Datasette · Queries took 1134.536ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability