home / nyc_ll84

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

19 rows where Calendar Year = 2012 and Property Type = "Education" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Postal Code, Year Built, Site EUI (kBtu/ft2), Weather Norm Site EUI (kBtu/ft2), Source EUI (kBtu/ft2), Electricity (kBtu), Natural Gas Use (kBtu), Fuel Oil #2 Use (kBtu), Fuel Oil #5 & 6 Use (kBtu)

Borough 4

  • MANHATTAN 7
  • BROOKLYN 4
  • QUEENS 4
  • BRONX 3

Property Type 1

  • Education · 19 ✖

Calendar Year 1

  • 2012 · 19 ✖
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
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
23564 23564 2012 2601646 79 Fifth Avenue LLC MANHATTAN 79 Fifth Avenue 10,003 Education 271596 1906   0 104.9 110.2 268.1         18746790.44 9736200.0 0.0 0.0 0.0 0.0   1008430045 1016079
23639 23639 2012 2609513 Leo Engineering Building BRONX 3825 Corlear Avenue 10,463 Education 161880 1947   0 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   0 52.4 52.6 156.8         2535009.38 452257.16 0.0 0.0 0.0 0.0   2057730328 2084004
23836 23836 2012 2636742 Gramercy Medical Arts Building MANHATTAN 380 Second Avenue 10,010 Education 191492 1909   0 73.6 72.3 216.9         11722789.4 0.0 0.0 2364700.07 0.0 0.0   1009270055 1020567
25908 25908 2012 2680727 117 Adams Complex-Building 5 BROOKLYN 175 Pearl Street 11,201 Education 190121 1918   0 45.9 50.6 76.1         2324254.4 6396200.0 0.0 0.0 0.0 0.0   3000870005 3000178
28219 28219 2012 2777318 Barnard Millbank   West 120th St 10,027 Education 221000 1989   0 74.1 75.3 191.7         10999331.87 5339865.93 0.0 39513.37 0.0 0.0      
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
29900 29900 2012 2809987 McVickar MANHATTAN 622 West 113th Street 10,027 Education 52544 1900   0 255.2 247.6 419.2         3482745.47 9927100.0 0.0 0.0 0.0 0.0   1018950032 1057343
31395 31395 2012 2835865 Bobover Yeshivah Bnei Zion BROOKLYN 1521 48th Street 11,219 Education 62000 1926   0 82.1 88.2 164.0         2109980.8 2980100.0 0.0 0.0 0.0 0.0   3054420069 3128817
31743 31743 2012 2943912 Cong Machne Chaim BROOKLYN 6101 16th Ave 11,204 Education 61148 1948   0 40.1 45.4 79.0         988115.2 1462700.0 0.0 0.0 0.0 0.0   3055240001 3132384
31917 31917 2012 2961640 Jewish Theological Seminary MANHATTAN 3080 Broadway 10,027 Education 262638 1929   0 76.3 74.9 154.9         8777248.93 380554.84 0.0 10870561.39 0.0 0.0   1019770001 1059669
32083 32083 2012 2973635 Yeshivah Novominsk BROOKLYN 1690 60th Street 11,204 Education 72000 2003   0 79.7 85.0 184.0         3158147.2 2578370.97 0.0 0.0 0.0 0.0   3055170039 3328510
32712 32712 2012 3106292 Armstrong MANHATTAN 545 West 112th street 10,027 Education 59072 1950   0 86.2 90.1 169.4         2042167.3 2926400.0 0.0 121076.81 0.0 0.0   1018840001 1056989
32894 32894 2012 3111556 Knox Hall MANHATTAN 606 west 122nd Street 10,027 Education 52009 1950   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   1019920013 1086560
33262 33262 2012 3117534 Studebaker MANHATTAN 615 West 131st Street 10,027 Education 175578 1950   0 105.0 109.2 286.8         13536291.12 4905800.0 0.0 0.0 0.0 0.0   1019980017 1059927
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
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.0   2042220005 2047109

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");
Powered by Datasette · Queries took 309.955ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability