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 Borough = "QUEENS" and Property Type = "Lodging" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1

Calendar Year 3

  • 2010 1
  • 2011 1
  • 2012 1

Property Type 1

  • Lodging · 3 ✖

Borough 1

  • QUEENS · 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)
33493 33493 2012 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Lodging 69345           0.0   0.0   0.0 102.5
22449 22449 2011 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Lodging 69,345                   0.0  
8858 8858 2010 2685937 144 Company QUEENS 144-30 35th Ave Lodging 80,312 941.41 126665.54 845.51 95.9           0.0 145.6

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