nyc_ll84: summary: 9 rows where Borough = "MANHATTAN" and Property Type = "Public Assembly" 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 Borough = "MANHATTAN" and Property Type = "Public Assembly" 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)	District Steam Use (kBtu)	Fuel Oil #2 Use (kBtu)	Fuel Oil #4 Use (kBtu)	Fuel Oil #5 & 6 Use (kBtu)	BBL	BIN
23771	23771	2012	2630425	Apollo Theater	MANHATTAN	253 W. 125th St.	10,027	Public Assembly	64400	1914	72.1	75.3	192.3					3278832.65	1367529.03	0.0	0.0	0.0	0.0	1019310010	1058654
35866	35866	2012	3544252	125 West 14th Street	MANHATTAN	125 West 14th Street	10,011	Public Assembly	67000	2001	260.2	266.8	608.8					9828511.66	7603800.0	0.0	0.0	0.0	0.0	1007907502	1086581
35869	35869	2012	3544255	224 East 47th Street	MANHATTAN	224 East 47th Street	10,017	Public Assembly	152476	1931	121.6	127.6	233.1					6169701.23	289500.0	12086721.53	0.0	0.0	0.0	1013200034	1037605
11342	11342	2011	2440593	333 W 23	MANHATTAN	333 West 23rd Street	10,011	Public Assembly	17,130	1985	50.8	51.8	138.1	72.11	45657.93	12.52	59.59	634.0	235.0					1007470001	1078542
11535	11535	2011	2710415	McBurney YMCA	MANHATTAN	125 West 14th Street	10,011	Public Assembly	67,000	2001	288.9	287.0	648.4	1.0	160.66	492.03	949.03	10.0	9.0					1007900019
13519	13519	2011	2748180	Vanderbilt YMCA	MANHATTAN	224 East 47th Street	10,017	Public Assembly	156,832	1931	158.3	159.2	335.2	2.0	138.0	84.11	1.0	10.0	1.0	12.0				1013200034	1037605
14441	14441	2011	2660125	92nd Street Y	MANHATTAN	1395 Lexington Ave	10,128	Public Assembly	121,391	1917	197.7	197.7	362.8	1.0	88.96	1.0	793.25	8.0	3.0		0.0		12.0	1015200020	1048310
2888	2888	2010	2816844	270 Park Ave So.	MANHATTAN	268-276 park ave so	10,010	Public Assembly	52,000		95.0	95.0	101.3	264.57	54765.48	260.68	3.89	41.0	4.0					1008500039	1016252
6295	6295	2010	2748180	Vanderbilt YMCA	MANHATTAN	224 East 47th Street	10,017	Public Assembly	156,832		165.1	164.5	343.8	2.0	138.0	84.91	2.0	10.0	1.0	13.0				1013200034	1037605

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 Borough = "MANHATTAN" and Property Type = "Public Assembly" sorted by Calendar Year descending

Advanced export