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

12 rows where Calendar Year = 2011 and Property Type = "Warehouse (Refrigerated)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property Name, Postal Code, Year Built, ENERGY STAR Score, Total GHG (MtCO2e), Electricity (kBtu), Natural Gas Use (kBtu)

Borough 3

  • BROOKLYN 5
  • QUEENS 4
  • BRONX 2

Property Type 1

  • Warehouse (Refrigerated) · 12 ✖

Calendar Year 1

  • 2011 · 12 ✖
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
16299 16299 2011 3106384 WAREHOUSE 1 BRONX 511 BARRY STREET 10,474 Warehouse (Refrigerated) 133,000 1962   100 22.4 22.4 27.1 167.04 13518.81 147.15 19.89 211.0 2.0           2026060041 2004159
16418 16418 2011 3221445 Hunts Poin BRONX 355 Food Center Drive 10,474 Warehouse (Refrigerated) 952,000 1972   22 176.9 176.9 479.6 13.0 146.99 2.0 11.0 122.0 45.0     721.0     2027810500 2109482;2109485;2109486;2109487;2109483;2109484;2112980;2822205;2109482;2115239;2831246;2831577;2831981;2115237;2101319;2115238
17604 17604 2011 2686394 Frank Brun BROOKLYN 38 Bogart St ENT 11,206 Warehouse (Refrigerated) 45,000 1920   44 123.8 124.7 375.1 492.38 117776.2 40.06 452.33 4.0 752.0           3031110028 3071551
18138 18138 2011 2592259 Hamilton BROOKLYN 568 Hamilton Avenue 11,232 Warehouse (Refrigerated) 135,000 1980   43 86.1 86.4 270.4 1.0 79.73 53.68 996.56 10.0 1.0           3006250080  
18637 18637 2011 2974996 Wing Hon Holding, Inc. BROOKLYN 1101 Metropolitan Avenue 112,111,708 Warehouse (Refrigerated) 70,000 1959   52 101.8 102.3 213.3 511.75 78691.8 205.89 305.86 3.0 3.0           3029270001 BIN# 3070489
18720 18720 2011 2784952 211 LOMBARDY ST LLC BROOKLYN 211 LOMBARDY ST 11,222 Warehouse (Refrigerated) 80,000 1981   85 49.9 50.0 112.0 297.26 39995.96 101.85 195.41 2.0 1.0         219.9 3028220001  
18779 18779 2011 2651918 Frank Brun   1011 Flushing 11,201 Warehouse (Refrigerated) 166,000 1920   44 108.0 108.0 274.1 1.0 64.84 334.13 1.0 11.0 6.0           3031250007 3071648
19017 19017 2011 2981646 Bogopa Ser BROOKLYN 650 Fountain Avenue 11,208 Warehouse (Refrigerated) 89,914 1967   0                             3045260001 3098937
20330 20330 2011 3113637 Wendi Realty LLC QUEENS 51-01 Grand Ave 11,378 Warehouse (Refrigerated) 120,200 1940   88 29.9 29.9 100.0 337.83 30303.07   337.83 3.0             4026100118 4058991
20398 20398 2011 3111975 Fresh Direct Borden Ave Hdqtrs QUEENS 23-30 Borden Avenue 11,101 Warehouse (Refrigerated) 300,000 1955   21 215.0 215.0 601.0 5.0 179.4 814.34 4.0 49.0 15.0         14.0 4000680038  
21225 21225 2011 3112728 Urbach 574 QUEENS 5748 49TH ST. 11,378 Warehouse (Refrigerated) 58,323 1940   33 90.6 90.6 302.6 496.18 92083.31   496.18 5.0             4026020220 4058974
21304 21304 2011 2810999 Warehouse Building QUEENS 58-71 56 Drive 11,378 Warehouse (Refrigerated) 63,518 1964   0 132.4 134.7 392.4 733.29 125286.67 73.24 660.05 7.0 1.0           4026660006 4805324

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