nyc_ll84: summary: 9 rows where Borough = "BRONX" 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

9 rows where Borough = "BRONX" 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	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
23639	23639	2012	2609513	Leo Engineering Building	BRONX	3825 Corlear Avenue	10,463	Education	161880	1947	53.4	51.0	111.7					3996376.54	1340558.37	0.0	0.0	0.0	3301423.98		2057740240	2084006
23644	23644	2012	2610158	Research and Learning Center	BRONX	3840 Corlear Avenue	10,463	Education	57000	1986	52.4	52.6	156.8					2535009.38	452257.16	0.0	0.0	0.0	0.0		2057730328	2084004
35430	35430	2012	3532549	Icahn Charter Schools	BRONX	1500 Pelham Parkway South	10,461	Education	107019	1955	0.0	0.0	0.0					0.0	0.0	0.0	0.0	0.0	0.0		2042220005	2047109
17828	17828	2011	2610158	Research a	BRONX	3840 Corlear Avenue	10,463	Education	57,000	1986	59.3	60.3	169.0	287.97	54380.36	38.46	249.51	2.0	722.0						2057730328	2084004
17829	17829	2011	2609513	Leo Engine	BRONX	3825 Corlear Avenue	10,463	Education	161,880	1947	60.6	60.8	116.8	793.34	53039.95	432.96	360.39	3.0	1.0				4.0	2.0	2057740240	2084006
3257	3257	2010	2636736	Rose Hill	BRONX	441 E Fordham Road	10,458	Education	1,800,000		110.0	113.5	199.4	13.0	139930.7	7.0	6.0	66.0	130.0			521.0	951.0		2032730001	2102025
9566	9566	2010	2814906	T.E 755 Coop City Associates LLC	BRONX	755 Coop City Boulevard	10,456	Education	37,911		105.0	103.6	259.9	312.67	90960.77	79.8	232.87	2.0	1.0						2051410390	2072365
10031	10031	2010	2814508	Cardinal Hayes High School	BRONX	650 Grand Concourse	10,451	Education	208,292		66.5	66.7	104.6	1.0	51.75	742.89	312.3	3.0	1.0		9.0				2024430053	2002452
10039	10039	2010	2815031	Saint Philip Neri School	BRONX	3025 Grand Concourse	10,468	Education	55,650		75.4	75.6	91.5	306.5	59984.28	272.64	33.85	360.0	462.0			3.0			2033100064	2086848

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 = "BRONX" and Property Type = "Education" sorted by Calendar Year descending

Advanced export