nyc_ll84: summary: 9 rows where Calendar Year = 2010 and Property Type = "Warehouse (Refrigerated)" sorted by Calendar Year descending

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

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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	Calendar Year ▲	Property ID	Property Name	Borough	Address 1	Postal Code	Property Type	Floor Area (ft2)	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)	Water Use (kgal)	BBL	BIN
3532	3532	2010	2783927	Hall Street Real Estate-40 Hall St	BROOKLYN	40 Hall Street	11,205	Warehouse (Refrigerated)	40,500	89	28.2	27.8	94.2	107.27	28866.09		107.27	1.0			3018750046	3255877
4564	4564	2010	2651918	Frank Brunckhorst (1011 Flushing)		1011 Flushing	11,201	Warehouse (Refrigerated)	450,000	92	40.5	39.9	101.8	1.0	23.92	348.65	1.0	11.0	6.0
4651	4651	2010	2708775	Liberty Equities	QUEENS	182-20 Liberty Avenue	11,412	Warehouse (Refrigerated)	165,000	0										298.2	4103430047	4448879
4662	4662	2010	2686394	Frank Brunckhorst (38 Bogart St ENT)	BROOKLYN	38 Bogart St ENT	11,206	Warehouse (Refrigerated)	45,000	49	121.8	122.2	368.3	483.79	115721.49	40.2	443.59	4.0	755.0		3031110028	3071551
4957	4957	2010	2747242	Madelaine Chocolate	QUEENS	316 Beach 96th Street	11,693	Warehouse (Refrigerated)	54,000	0											4161510018	4448994
5635	5635	2010	2784952	211 LOMBARDY ST LLC	BROOKLYN	211 LOMBARDY ST	11,222	Warehouse (Refrigerated)	80,000	74	106.6	106.6	158.6	520.44	70024.55	366.42	154.02	1.0	6.0	186.3	3028220001	3338236
6648	6648	2010	2810999	Warehouse Building	QUEENS	58-71 56 Drive	11,378	Warehouse (Refrigerated)	63,518	1	503.3	500.9	769.8	1.0	170.86	1.0	631.52	6.0	25.0		4026660006	4441140
6852	6852	2010	2715290	Daiei Trading Co Inc	QUEENS	1450 128th Street	11,356	Warehouse (Refrigerated)	51,000	0	132.5	136.2	300.6	505.93	106780.0	167.75	338.18	3.0	3.0		4040940006	4098466
8034	8034	2010	2792731	Fresh Direct	QUEENS	23-30 Borden Avenue	11,101	Warehouse (Refrigerated)	165,534	0											4000680038	4436621

Advanced export

JSON shape: default, array, newline-delimited

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");

Summary — Key Metrics (start here)

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

Advanced export