home / nyc_ll84

Summary — Key Metrics (start here)

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Postal Code, Year Built, Water Use (kgal)

Property Type 1

  • Automobile Dealership · 6 ✖

Calendar Year 1

  • 2015 · 6 ✖

Borough 1

  • MANHATTAN 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
64099 64099 2015 3104030 711 11 AVENUE MANHATTAN 711 11 AVENUE 10019 Automobile Dealership 115500 1930 1 Not Available 40.3 40.3 117.6 371.3 34.6 26.4 344.9 4158145.2 497022.6 0.0 0.0 0.0 0.0 0.0 1010980036 1027135
66183 66183 2015 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE 10019 Automobile Dealership 65625 1930 1 Not Available 62.6 63.1 123.9 272.5 44.7 121.0 151.5 1827194.2 2277699.8 0.0 0.0 0.0 0.0 0.0 1010790003 1080967
66184 66184 2015 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE 10035 Automobile Dealership 91256 2004 1 Not Available 74.1 74.2 162.0 468.7 55.28 163.8 304.8 3675406.6 3084600.1 0.0 0.0 0.0 0.0 0.0 1017920005 1087849
66185 66185 2015 4124879 POTAMKIN HY HOLDINGS LLC MANHATTAN 2485 2nd ave 10035 Automobile Dealership 137456 2004 1 Not Available 53.2 53.2 154.4 581.6 45.54 44.3 537.3 6478705.1 834499.9 0.0 0.0 0.0 0.0 0.0 1-01792-0019 1054700
66189 66189 2015 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75000 1940 1 Not Available 57.8 56.4 129.3 303.5 43.56 99.3 204.2 2462446.1 1869594.8 0.0 0.0 0.0 0.0 906.6 1-01095-0029 1027121
70645 70645 2015 4957573 Girt Realty LLC MANHATTAN 646 11th Avenue 10036 Automobile Dealership 50207 1946 1 Not Available 112.1 110.1 242.5 388.3 83.25 139.8 248.5 2996378.8 2632522.4 0.0 0.0 0.0 0.0 749.5 1-01076-0001 1026982

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