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 = 2010 and Property Type = "Health Care: Inpatient (Specialty Hospitals, Excluding Children's)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2)

Borough 2

  • QUEENS 2
  • BRONX 1

Property Type 1

  • Health Care: Inpatient (Specialty Hospitals, Excluding Children's) · 3 ✖

Calendar Year 1

  • 2010 · 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)
4756 4756 2010 2641471 NSLIJ Zucker Hillside QUEENS 75-59 263rd Street Health Care: Inpatient (Specialty Hospitals, Excluding Children's) 260,866 2.0 82.8 1.0 982.38           0.0 118.6
5691 5691 2010 2641471 NSLIJ Zucker Hillside QUEENS 75-59 263rd Street Health Care: Inpatient (Specialty Hospitals, Excluding Children's) 260,866 2.0 82.8 1.0 982.38           0.0 118.6
7056 7056 2010 2796878 Starhill BRONX 1600 Macombs Road Health Care: Inpatient (Specialty Hospitals, Excluding Children's) 80,370                   0.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 642.676ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability