nyc_ll84: summary: 8 rows where Borough = "QUEENS" and Property Type = "Education" 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

8 rows where Borough = "QUEENS" and Property Type = "Education" 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	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
22989	22989	2012	1819837	Center for Automotive Education and Training	QUEENS	15-30 Petracca Place	11,357	Education	92705	2005	0	0.0	0.0	0.0					0.0	0.0	0.0	0.0	0.0	0.0		4041250001	4564828
28977	28977	2012	2797746	30-20 Thompson Avenue	QUEENS	30-20 Thompson Avenue	11,101	Education	609247	1920	0	79.3	81.5	238.6					41329833.0	6985336.61	0.0	0.0	0.0	0.0		4002740001	4003517
34335	34335	2012	3321105	NY School of Urban Ministry	QUEENS	31-10 47th Street	11,103	Education	70000	1924	0	0.0	0.0	0.0					0.0	0.0	0.0	0.0	0.0	0.0		4007250022	4013196
34411	34411	2012	3332502	Congregation YGS	QUEENS	74-10 88th Street	11,385	Education	66713	2006	0	91.7	99.6	185.5					2604929.92	3512615.38	0.0	0.0	0.0	0.0		4038100093	4437920
20516	20516	2011	2797746	30-20 Thompson Avenue	QUEENS	30-20 Thompson Avenue	11,101	Education	609,247	1920	0	80.5	81.6	240.2	4.0	70.7	406.36	3.0	41.0	7.0						4002740001	4003517
21534	21534	2011	1819837	Center for	QUEENS	15-30 Petracca Place	11,357	Education	92,705	2005	0	84.9	83.5	210.4	618.78	72396.59	157.59	461.19	4.0	2.0					10.0	4041250001	4854710
722	722	2010	1819837	Center for Automotive Education and Training	QUEENS	15-30 Petracca Place	11,357	Education																		4041250001	4564828
9155	9155	2010	2797746	30-20 Thompson Avenue	QUEENS	30-20 Thompson Avenue	11,101	Education	609,247		0	54.4	55.6	154.9	2.0	35.35	378.46	2.0	26.0	7.0						4002740001	4003517

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)

8 rows where Borough = "QUEENS" and Property Type = "Education" sorted by Calendar Year descending

Advanced export