Summary — Key Metrics (start here)

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

26 rows where Borough = "QUEENS" and Property Type = "College/University (Campus-Level)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Postal Code, Floor Area (ft2), Year Built, Total GHG (MtCO2e), GHGI (kgCO2e/m2), Direct GHG (MtCO2e), Indirect GHG (MtCO2e), Electricity (kBtu), Natural Gas Use (kBtu), Fuel Oil #2 Use (kBtu), BBL, BIN

Calendar Year 3

Property Type 1

  • College/University (Campus-Level) · 26 ✖

Borough 1

  • QUEENS · 26 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Postal Code Property Type Floor Area (ft2) Year Built Number of Buildings 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
28524 28524 2012 2788606 RSA 76-01 147 Street QUEENS 76-01 147th St 11,367 College/University (Campus-Level) 83794 1999   0 69.3 72.9 160.8         3225594.74 2582170.97 0.0 0.0 0.0 0.0   4066850001 4144493
29919 29919 2012 2810269 St. John Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 142700 1954   0 137.7 151.6 187.7         2711983.84 16931700.0 0.0 0.0 0.0 0.0   4070210001 4462481
29922 29922 2012 2810276 St. Albert Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 175800 1957   0 217.8 226.8 392.6         12689954.76 20859000.0 0.0 4742105.58 0.0 0.0   4070210001 4462481
29923 29923 2012 2810281 Belson Hall/Finley Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 215389 1971   0 184.1 194.0 342.7         14086646.72 25556500.0 0.0 0.0 0.0 0.0   4070210001 4462481
29925 29925 2012 2810284 College of Pharmacy QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 4416 1985   0 190.8 199.9 365.3         318762.69 524000.0 0.0 0.0 0.0 0.0   4070210001 4462481
29939 29939 2012 2810307 St. Augustine Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 168600 1964   0 182.9 194.7 338.8         10831472.48 20004900.0 0.0 0.0 0.0 0.0   4070210001 4462481
29940 29940 2012 2810313 Sullivan Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 72438 1989   0 145.0 150.4 289.0         4332608.78 6171100.0 0.0 0.0 0.0 0.0   4070210001 4462481
29947 29947 2012 2810335 Belson Stadium QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 4435 2002   0 128.7 140.9 158.0         44854.15 526100.0 0.0 0.0 0.0 0.0   4070210001 4462481
29952 29952 2012 2810354 D'Angelo Center QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 120000 2009   0 175.0 185.1 312.6         6767091.25 14238300.0 0.0 0.0 0.0 0.0   4070210001 4462481
21923 21923 2011 2788606 RSA QUEENS 76-01 147th St 11,367 College/University (Campus-Level) 83,794 2008   0 76.5 78.8 170.2 474.99 61599.34 165.88 309.11 3.0 3.0           4066850001 4144493
21959 21959 2011 2810281 Belson Hal QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 215,389 1971   0 190.0 190.3 348.5 2.0 100.13 1.0 1.0 14.0 26.0           4070210001 4439412
21960 21960 2011 2810269 St. John H QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 142,700 1954   0 143.9 144.6 194.3 1.0 75.8 948.17 254.75 2.0 17.0           4070210001  
21963 21963 2011 2810354 D'Angelo C QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 120,000 2009   0 183.1 182.9 325.4 1.0 89.7 796.9 656.69 6.0 14.0           4070210001 4439412
21965 21965 2011 2810307 St. August QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 168,600 1964   0 189.2 189.9 345.6 2.0 128.14 1.0 1.0 10.0 21.0           4070210001  
21973 21973 2011 2810276 St. Albert QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 175,800 1957   0 232.6 233.3 423.2 2.0 123.02 1.0 1.0 13.0 21.0   5.0       4070210001  
21974 21974 2011 2810335 Belson Sta QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 4,435 2002   0 135.4 136.1 166.0 33.85 91089.5 29.45 4.41 46.0 553.0           4070210001 4439412
21976 21976 2011 2810313 Sullivan H QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 72,438 1989   0 150.5 150.5 295.0 756.62 113113.64 349.13 407.49 4.0 6.0           4070210001  
21980 21980 2011 2810284 College of QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 4,416 1985   0 206.7 206.6 404.2 63.28 170284.9 29.33 33.95 361.0 551.0           4070210001 4439412
8314 8314 2010 2810281 Belson Hall/Finley Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 215,389     0 199.4 193.7 367.2 2.0 100.13 1.0 1.0 14.0 28.0           4070210001 4462481
8316 8316 2010 2810335 Belson Stadium QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 4,435     0 141.8 136.3 175.4 35.58 95744.89 30.7 4.88 51.0 577.0           4070210001 4462481
8321 8321 2010 2810284 College of Pharmacy QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 4,416     0 217.6 209.0 428.3 66.83 179837.86 30.58 36.25 386.0 574.0           4070210001 4462481
8324 8324 2010 2810354 D'Angelo Center QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 120,000     0 189.3 182.3 333.5 1.0 89.7 831.61 664.95 7.0 15.0           4070210001 4462481
8336 8336 2010 2810276 St. Albert Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 175,800     0 270.9 262.2 482.1 3.0 184.52 1.0 1.0 15.0 22.0   9.0       4070210001 4462481
8338 8338 2010 2810307 St. Augustine Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 168,600     0 199.3 191.8 366.9 2.0 128.14 1.0 1.0 11.0 21.0           4070210001 4462481
8339 8339 2010 2810269 St. John Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 142,700     0 149.6 143.3 201.0 1.0 75.8 988.94 259.13 2.0 18.0           4070210001 4462481
8342 8342 2010 2810313 Sullivan Hall QUEENS 8000 Utopia Parkway 11,439 College/University (Campus-Level) 72,438     0 154.3 149.4 303.5 777.01 116161.92 355.87 421.14 4.0 6.0           4070210001 4462481

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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