nyc_ll84: summary: 9 rows where Calendar Year = 2011 and Property Type = "Mall (Strip Mall and Enclosed)" sorted by Calendar Year descending

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHG intensity (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 = 2011 and Property Type = "Mall (Strip Mall and Enclosed)" 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)	Year Built	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
17252	17252	2011	2678637	Bruckner	BRONX	845 White Plains Rd.	10,473	Mall (Strip Mall and Enclosed)	114,425	1996	95.2	95.2	311.9	1.0	94.42	16.34	994.07	10.0	307.0		2036450001	2022552
18586	18586	2011	2678643	Atlantic Center	BROOKLYN	197 Fort Greene Place	11,217	Mall (Strip Mall and Enclosed)	392,000	1996	117.9	117.9	393.8	4.0	109.84		4.0	46.0			3020020001	3057470
20172	20172	2011	2814714	Triangle Equities Junction	BROOKLYN	2201 Nostrand Avenue	11,210	Mall (Strip Mall and Enclosed)	64,434	2000	486.2	493.6	1.0	2.0	336.37	455.35	2.0	22.0	8.0		3075760000	3396696
20410	20410	2011	2678649	Northern	QUEENS	48-18 Northern Blvd.	11,101	Mall (Strip Mall and Enclosed)	217,599	1994	139.0	139.3	457.3	2.0	99.21	34.74	2.0	29.0	653.0		4001200012	4000822
20987	20987	2011	2678650	Queens Place Mall	QUEENS	88-01 Queens Blvd	11,373	Mall (Strip Mall and Enclosed)	398,993	1964	119.4	119.4	322.0	3.0	81.13	711.05	3.0	34.0	13.0	12.0	4018430006	4437281
21540	21540	2011	2814700	Triangle P	QUEENS	140-01 20th Avenue	11,357	Mall (Strip Mall and Enclosed)	76,727	2000	121.0	121.6	328.9	769.16	108936.33	133.85	635.31	6.0	2.0		4041450001	4462126
21549	21549	2011	2814707	Triangle Plaza II LLC		28-55 Ulmer Ave.	11,354	Mall (Strip Mall and Enclosed)	137,984	2000	99.8	102.9	278.8	1.0	78.57	174.9	984.79	10.0	3.0		4043310001	4848167
22633	22633	2011	2770620	Forest Mal		1351 & 1377 Forest Ave	10,302	Mall (Strip Mall and Enclosed)	108,283	1981	214.3	215.3	565.6	1.0	99.67	377.41	1.0	16.0	7.0		5010520001
22654	22654	2011	2678669	Richmond Avenue	STATEN IS	2505-2535 Richmond Ave.	10,311	Mall (Strip Mall and Enclosed)	76,000	1998	108.0	108.0	360.7	770.53	109130.37		770.53	8.0			5024000015	5132232; 5843862

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 = 2011 and Property Type = "Mall (Strip Mall and Enclosed)" sorted by Calendar Year descending

Advanced export