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

4 rows where Calendar Year = 2020 and Property Type = "Prison/Incarceration" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 3

  • BROOKLYN 2
  • MANHATTAN 1
  • QUEENS 1

Property Type 1

  • Prison/Incarceration · 4 ✖

Calendar Year 1

  • 2020 · 4 ✖
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)
197947 197947 2020 6294369 DOC - 3000605 - Brooklyn CC Campus: Brooklyn House of Detention #129 (LL84) BROOKLYN 275 Atlantic Ave Prison/Incarceration 161765 2375.5 158.07 1500.4 875.1 2375.5 79.5 0.0 0.0   0.0 242.7
198448 198448 2020 6297409 DOC - 1002364 - Manhattan CC Campus: Manhattan Detention House North (LL84) MANHATTAN 84 Baxter St Prison/Incarceration 236142 1503.3 68.52 811.6 691.7 1503.3 79.5 0.0 0.0   0.0 95.8
208764 208764 2020 12344381 BBL 2-02605-0040: Rikers Island, DOC (LL84) QUEENS Rikers Island Prison/Incarceration 5978573 92410.2 166.38 88627.8 3782.3 92410.2 79.5 0.0 0.0   0.0 286.8
208888 208888 2020 12344554 BBL 3-03498-0008: ACS, DOE (LL84) BROOKLYN 17 Bristol St Prison/Incarceration 315667 1139.6 38.86 451.4 688.2 1139.6 79.5 0.0 0.0   0.0 54.4

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