Energy — EUI and Fuel Use by Type

Site EUI, source EUI, electricity, natural gas, steam, oil, and renewables.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

1,548 rows where Calendar Year = 2017 and Property Type = "K-12 School" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: District Steam Use (kBtu), Fuel Oil #4 Use (kBtu), Fuel Oil #5 & 6 Use (kBtu), District Hot Water Use (kBtu), Green Power - Onsite (kWh)

Borough 5

Property Type 1

  • K-12 School · 1,548 ✖

Calendar Year 1

  • 2017 · 1,548 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) ENERGY STAR Score Site EUI (kBtu/ft2) Weather Norm Site EUI (kBtu/ft2) National Median Site EUI (kBtu/ft2) Source EUI (kBtu/ft2) Weather Norm Source EUI (kBtu/ft2) Total Site Energy (kBtu) Electricity (kBtu) Electricity (kWh) Natural Gas Use (kBtu) Natural Gas Use (therms) District Steam Use (kBtu) Fuel Oil #2 Use (kBtu) Fuel Oil #4 Use (kBtu) Fuel Oil #5 & 6 Use (kBtu) Diesel #2 Use (kBtu) District Hot Water Use (kBtu) District Chilled Water Use (kBtu) Green Power - Onsite (kWh) Green Power - Offsite (kWh)
94816 94816 2017 2,967,701 Cathedral Preparatory Seminary QUEENS 56-25 92nd Street K-12 School 94,380 100.0 28.4 31.3 94.9 43.5 46.8 2.0 616.0 180.0 2.0                   0.0
94888 94888 2017 6,187,698 Central High School QUEENS 86-84 palo alto st K-12 School 28,581 96.0 26.0 26.0 51.0 81.7 81.7 743.0 743.0 217.0                     0.0
94919 94919 2017 2,617,131 Gospel Tabernacle P/INC QUEENS 39-21 Crescent Street K-12 School 93,300 89.0 47.1   74.8 90.4   4.0 1.0 542.0 1.0     978.0             0.0
94977 94977 2017 4,392,811 Lycee Francais LL84 MANHATTAN 505 E. 75th St K-12 School 181,120 75.0 58.0 61.1 74.6 136.4 139.6 10.0 6.0 1.0 3.0                 81.0 0.0
94988 94988 2017 6,168,561 South Bronx Charter School BRONX 164 Bruckner Blvd K-12 School 39,614 12.0 234.9 258.9 159.2 374.4 402.3 9.0 2.0 710.0 6.0                   0.0
95038 95038 2017 2,674,246 Churchill - 301 E 29th St MANHATTAN 301 East 29th Street K-12 School 71,000 36.0 90.4 95.8 79.8 202.4 207.6 6.0 3.0 1.0 2.0                   0.0
95048 95048 2017 2,809,442 Our Lady of the Snows Church, School and Convent QUEENS 79-33 258th Street K-12 School 93,000   52.8 57.1 83.0 78.4 82.7 4.0 1.0 298.0 3.0                   0.0
95068 95068 2017 6,168,561 South Bronx Charter School BRONX 164 Bruckner Blvd K-12 School 39,614 12.0 234.9 258.9 159.2 374.4 402.3 9.0 2.0 710.0 6.0                   0.0
95091 95091 2017 2,970,037 school BRONX 1770 stillwell avenue K-12 School 27,000 93.0 85.6 95.2 150.6 116.3 126.9 2.0 340.0 99.0 1.0                   0.0
95092 95092 2017 2,970,270 160 Lawrence Avenue BROOKLYN 160 lawrence avenue K-12 School 41,000 1.0 131.9 131.8 62.6 239.4 238.9 5.0 1.0 580.0 3.0                   0.0
95122 95122 2017 6,196,211 St Pancras School QUEENS 68-20 Myrtle Ave K-12 School 61,900 90.0 54.2   87.7 74.3   3.0 517.0 151.0 2.0     207.0             0.0
95180 95180 2017 4,039,463 Heschel School - 30 West End Avenue MANHATTAN 30 West End Avenue K-12 School 160,532 4.0 112.2 112.2 63.8 222.9 222.9 18.0 8.0 2.0 9.0                   0.0
95181 95181 2017 5,052,689 Heschel School - 20 West End Avenue MANHATTAN 20 West End Avenue K-12 School 58,272 18.0 80.6 83.5 59.4 204.1 207.2 4.0 3.0 976.0 1.0                   0.0
95478 95478 2017 2,947,079 Brooklyn Scholars Charter School BROOKLYN 2635 Linden Blvd. K-12 School 58,700 14.0 89.2 92.6 62.2 199.5 202.3 5.0 2.0 871.0 2.0                   0.0
95479 95479 2017 2,947,162 Brooklyn Excelsior Charter School BROOKLYN 856 Quincy Street K-12 School 55,627 56.0 73.7   78.4 156.1   4.0 2.0 613.0 2.0                   0.0
95578 95578 2017 6,276,753 Ramaz School - 114 E 85 St MANHATTAN 114 East 85th Street K-12 School 61,917       58.2                                
95579 95579 2017 6,276,754 Ramaz School - 60 E 78 St MANHATTAN 60 East 78 Street K-12 School 77,798       58.2                                
95645 95645 2017 6,229,532 540 West 26th MANHATTAN 540 West 26th Street K-12 School 150,286   3.1 3.1 39.2 9.8 9.8 467.0 467.0 136.0                     0.0
95820 95820 2017 6,257,831 Sisters of St. John the Baptist Inc. 61 Cleveland STATEN IS 61 Cleveland Place K-12 School 27,830 29.0 111.6 111.6 92.6 256.5 256.5 3.0 1.0 550.0       1.0             0.0
95822 95822 2017 6,273,201 St Johns Villa Academy 25 Landis STATEN IS 25 Landis Avenue K-12 School 40,066 47.0 115.8 118.5 112.8 201.8 204.7 4.0 1.0 462.0 1.0     1.0             0.0
95823 95823 2017 2,660,703 Bosworth Building BROOKLYN 129 Pierrepont Street K-12 School 108,243 90.0 52.1 56.6 85.0 95.5 100.1 5.0 2.0 618.0 3.0                   0.0
96019 96019 2017 2,970,037 school BRONX 1770 stillwell avenue K-12 School 27,000 93.0 85.6 95.2 150.6 116.3 126.9 2.0 340.0 99.0 1.0                   0.0
96020 96020 2017 2,970,270 160 Lawrence Avenue BROOKLYN 160 lawrence avenue K-12 School 41,000 1.0 131.9 131.8 62.6 239.4 238.9 5.0 1.0 580.0 3.0                   0.0
96149 96149 2017 4,950,168 Cardinal Hayes High School BRONX 650 Grand Concourse K-12 School 388,500 99.0 46.1 50.7 113.6 64.5 69.3 17.0 2.0 877.0 14.0                   0.0
96257 96257 2017 2,705,043 Marymount Manhattan College MANHATTAN 221 E. 71st St. K-12 School 186,000 2.0 105.3 108.4 53.0 239.4 241.6 19.0 10.0 3.0 320.0   8.0               0.0
96973 96973 2017 4,408,611 205 Rockaway Parkway BROOKLYN 205 Rockaway Parkway K-12 School 82,000 38.0 60.7 62.8 54.4 165.4 169.4 4.0 3.0 1.0 986.0                   0.0
97227 97227 2017 2,788,403 St. Hilda's & St. Hugh's School MANHATTAN 619 West 114th Street K-12 School 100,000 38.0 42.1 42.2 38.1 121.9 122.0 4.0 3.0 1.0 497.0     0.0             0.0
97260 97260 2017 6,246,318 147 St Nicholas Ave - 44318 MANHATTAN 147 St Nicholas Ave K-12 School 49,700 93.0 36.4 38.4 64.6 114.3 120.4 1.0 1.0 530.0                     0.0
97312 97312 2017 6,246,318 147 St Nicholas Ave - 44318 MANHATTAN 147 St Nicholas Ave K-12 School 49,700 93.0 36.4 38.4 64.6 114.3 120.4 1.0 1.0 530.0                     0.0
97318 97318 2017 2,942,316 St. Joseph Hill Academy STATEN IS 850 Hylan Boulevard K-12 School 174,130 86.0 50.4 54.0 76.0 86.1 89.8 8.0 2.0 809.0 6.0                   0.0
97330 97330 2017 3,532,549 Icahn Charter Schools Pelham BRONX 1500 Pelham Parkway South K-12 School 107,019   61.5 64.4 58.9 147.6 150.0 6.0 4.0 1.0 2.0                   0.0
97337 97337 2017 6,236,976 Trevor Day School Upper School MANHATTAN 312 E 95th Street K-12 School 105,000 23.0 68.4 70.3 53.7 173.6 175.5 7.0 5.0 1.0 2.0                   0.0
97827 97827 2017 6,295,700 The Marist Bros - ARCHBISHOP MOLLOY HS QUEENS 83-53 Manton Street K-12 School 179,024 60.0 74.7 80.3 81.8 115.9 121.8 13.0 3.0 941.0 10.0                   0.0
98152 98152 2017 2,947,295 The New York Institute for Special Education BRONX 999 Pelham Parkway North K-12 School 242,473 3.0 122.7 132.8 65.4 156.9 167.4 29.0 3.0 952.0 26.0                   0.0
98167 98167 2017 2,947,295 The New York Institute for Special Education BRONX 999 Pelham Parkway North K-12 School 242,473 3.0 122.7 132.8 65.4 156.9 167.4 29.0 3.0 952.0 26.0                   0.0
98168 98168 2017 2,947,630 Readiness The New York Institute for Special Education BRONX 985 Astor Ave K-12 School 55,840 49.0 87.5 94.0 87.2 130.3 136.5 4.0 1.0 300.0 3.0                   0.0
98176 98176 2017 2,947,630 Readiness The New York Institute for Special Education BRONX 985 Astor Ave K-12 School 55,840 49.0 87.5 94.0 87.2 130.3 136.5 4.0 1.0 300.0 3.0                   0.0
98339 98339 2017 3,788,659 St. John's Preparatory School QUEENS 21-21 Crescent Street K-12 School 273,124 97.0 51.9 57.9 105.7 71.5 77.7 14.0 2.0 650.0 11.0                   0.0
98518 98518 2017 2,683,794 Brooklyn Excelsior Charter School BROOKLYN 848 Quincy Street K-12 School 55,627 44.0 74.9 80.8 71.7 157.3 163.5 4.0 2.0 613.0 2.0                   0.0
98567 98567 2017 6,118,341 Riverdale Country School Hill Campus BRONX 5260 Fieldston Road Bronx K-12 School 169,660 47.0 56.6 58.7 55.4 136.9 139.0 9.0 6.0 1.0 2.0     731.0             0.0
98811 98811 2017 2,917,926 St. Catharine Academy BRONX 2250 Williamsbridge Road K-12 School 60,000 90.0 61.8 61.9 101.2 91.4 91.5 3.0 814.0 238.0 133.0       2.0           0.0
98979 98979 2017 4,277,322 HVA High-HarlemVillage MANHATTAN 35 West124th Street K-12 School 50,000 20.0 109.9 116.9 82.7 229.0 236.3 5.0 2.0 796.0 2.0                   0.0
98980 98980 2017 4,277,332 HVA Elem-HarlemVillage MANHATTAN 74 West124th Street K-12 School 60,000 38.0 68.6 71.5 61.8 178.1 181.2 4.0 3.0 892.0 1.0                   0.0
99017 99017 2017 2,794,820 Fordham Prepatory School BRONX 441 East Fordham Road K-12 School 163,812 61.0 65.6 70.5 72.8 132.6 138.0 10.0 4.0 1.0 5.0                   0.0
99019 99019 2017 2,794,820 Fordham Prepatory School BRONX 441 East Fordham Road K-12 School 163,812 61.0 65.6 70.5 72.8 132.6 138.0 10.0 4.0 1.0 5.0                   0.0
99079 99079 2017 6,237,738 RC Church St. Gregory the Great MANHATTAN 138 West 90th Street K-12 School 33,756   8.4 8.4 49.7 20.9 20.9 284.0 194.0 56.0 90.0                   0.0
99306 99306 2017 6,237,738 RC Church St. Gregory the Great MANHATTAN 138 West 90th Street K-12 School 33,756   8.4 8.4 49.7 20.9 20.9 284.0 194.0 56.0 90.0                   0.0
99308 99308 2017 2,809,442 Our Lady of the Snows Church, School and Convent QUEENS 79-33 258th Street K-12 School 93,000   52.8 57.1 83.0 78.4 82.7 4.0 1.0 298.0 3.0                   0.0
99312 99312 2017 6,196,211 St Pancras School QUEENS 68-20 Myrtle Ave K-12 School 61,900 90.0 54.2   87.7 74.3   3.0 517.0 151.0 2.0     207.0             0.0
99502 99502 2017 4,947,855 Trey Whitfield School BROOKLYN 17 Hinsdale Street K-12 School 58,420 69.0 49.6 52.1 59.9 88.4 91.1 2.0 1.0 297.0 1.0                   0.0
99889 99889 2017 2,818,354 Moore Catholic High School STATEN IS 100 Merrill Avenue K-12 School 70,232 93.0 60.6 60.6 108.2 88.3 88.3 4.0 889.0 260.0 218.0     3.0             0.0
99890 99890 2017 2,749,476 Church of the Holy Rosary BRONX 2760 Eastchester Road K-12 School 58,462   34.5 34.7 101.0 48.3 48.8 2.0 363.0 106.0 293.0       1.0           0.0
99979 99979 2017 2,972,000 Saint Thomas Choir School MANHATTAN 202 West 58th Street K-12 School 76,883 74.0 61.7 65.0 80.0 123.7 126.6 4.0 2.0 635.0 2.0                   0.0
100173 100173 2017 5,839,384 7100 Shore Road (Xaverian High School) BROOKLYN 7100 Shore Road K-12 School 241,100 100.0 21.4   65.3 51.2   5.0 3.0 973.0                     0.0
100530 100530 2017 6,296,278 890 Broadway MANHATTAN 890 Broadway K-12 School 167,403   55.9 60.3 67.9 116.5 120.6 9.0 4.0 1.0 1.0       3.0           0.0
101213 101213 2017 2,665,280 Ethical Culture Fieldston School - 33 Central Park West MANHATTAN 33 Central Park West K-12 School 82,767 37.0 82.2 90.0 73.3 147.6 155.7 6.0 2.0 710.0 4.0                   0.0
101214 101214 2017 6,308,730 3901 Fieldston School Building -Fieldston Road   3859 Fieldston Road K-12 School 322,505 38.0 79.9 83.9 72.8 149.5 153.6 25.0 10.0 3.0 3.0     12.0             0.0
101223 101223 2017 6,208,793 Monsignor Farrell High School STATEN IS 2900 Amboy Road K-12 School 294,320 100.0 24.9 27.1 96.2 37.8 40.2 7.0 1.0 512.0 474.0     5.0             0.0
101238 101238 2017 4,405,892 590 6th Avenue MANHATTAN 590 6th Avenue K-12 School 151,000 39.0 79.8 84.0 71.6 178.8 182.1 12.0 6.0 2.0 5.0                   0.0
101359 101359 2017 3,284,560 Saint David's School MANHATTAN 12 East 89th Street K-12 School 65,000 24.0 91.3   72.4 173.6   5.0 2.0 708.0 3.0                   0.0
101718 101718 2017 2,818,354 Moore Catholic High School STATEN IS 100 Merrill Avenue K-12 School 70,232 93.0 60.6 60.6 108.2 88.3 88.3 4.0 889.0 260.0 218.0     3.0             0.0
101890 101890 2017 3,129,216 St. Ignatius Loyola MANHATTAN 46 East 84th Street K-12 School 100,000 21.0 67.0   49.9 175.1   6.0 5.0 1.0 1.0                   0.0
101924 101924 2017 3,087,385 The Brearley School MANHATTAN 610 East 83rd Street K-12 School 117,180 46.0 84.2   81.9 167.8   9.0 4.0 1.0 4.0     688.0             0.0
101941 101941 2017 2,546,474 The Nightingale Bamford School MANHATTAN 30 East 92 Street K-12 School 128,858 43.0 69.4 73.0 65.7 155.1 158.9 8.0 5.0 1.0 3.0                   0.0
102463 102463 2017 2,495,822 lyceum kennedy MANHATTAN 225 East 43rd Street K-12 School 8,000 1.0 144.4 144.6 39.5 453.4 454.0 1.0 1.0 338.0                     0.0
102567 102567 2017 6,257,831 Sisters of St. John the Baptist Inc. 61 Cleveland STATEN IS 61 Cleveland Place K-12 School 23,690 33.0 119.8 119.8 103.2 265.8 265.8 2.0 1.0 472.0       1.0             0.0
102571 102571 2017 6,273,201 St Johns Villa Academy 25 Landis STATEN IS 25 Landis Avenue K-12 School 40,066 47.0 115.8 118.5 112.8 201.8 204.7 4.0 1.0 462.0 1.0     1.0             0.0
102720 102720 2017 2,814,426 Good Shepherd School   608/620 Isham Street K-12 School 102,600   69.0 73.7 107.4 90.9 95.6 7.0 1.0 295.0 630.0     5.0             0.0
102786 102786 2017 6,314,610 The Town School MANHATTAN 540 EAST 76 STREET K-12 School 68,000 38.0 79.4 83.8 71.4 157.6 161.7 5.0 2.0 686.0 2.0   993.0               0.0
102852 102852 2017 2,712,911 The Dalton School MANHATTAN 108 East 89th Street K-12 School 630,838 100.0 10.1 10.2 67.1 29.3 29.4 6.0 5.0 1.0 715.0                   0.0
102936 102936 2017 4,800,477 Avenues New York   259 Tenth Avenue K-12 School 19,954 62.0 73.5 77.9 82.7 166.4 170.3 15.0 9.0 2.0 6.0                   0.0
103146 103146 2017 2,647,073 671 Louisiana Ave. BROOKLYN 671 Louisiana Ave. K-12 School 63,600 85.0 46.9 49.1 69.8 89.0 91.2 2.0 1.0 354.0 1.0                   0.0
103172 103172 2017 2,957,372 8 East 66th Street MANHATTAN 8 East 66th Street K-12 School 78,257 51.0 53.9 53.9 54.7 83.9 83.9 4.0 1.0 317.0 24.0         3.0         0.0
103213 103213 2017 4,037,163 St. Peter's Boys High School   196 HendersonAvenue K-12 School 63,000 69.0 62.1 67.7 74.5 102.9 108.7 3.0 1.0 332.0 2.0                   0.0
103401 103401 2017 2,801,664 40 East 62nd Street Condominiums MANHATTAN 40 East 62nd Street K-12 School 40,224   193.7 201.2 85.7 319.8 327.5 7.0 1.0 531.0 164.0   5.0               0.0
103447 103447 2017 2,800,487 Christ the King Regional High School QUEENS 6802 Metropolitan Ave K-12 School 227,500 97.0 49.5   102.1 73.3   11.0 2.0 724.0 749.0       8.0           0.0
103483 103483 2017 4,462,356 310 West 75th Street MANHATTAN 310 West 75th Street K-12 School 63,010 38.0 72.7 75.2 65.6 175.1 177.2 4.0 2.0 872.0 1.0                   0.0
103517 103517 2017 6,296,278 890 Broadway MANHATTAN 890 Broadway K-12 School 110,538   84.7 91.3 59.1 176.5 182.7 9.0 4.0 1.0 1.0       3.0           0.0
104099 104099 2017 2,495,822 lyceum kennedy MANHATTAN 225 East 43rd Street K-12 School 8,000 1.0 144.4 144.6 39.5 453.4 454.0 1.0 1.0 338.0                     0.0
104645 104645 2017 2,495,822 lyceum kennedy MANHATTAN 225 East 43rd Street K-12 School 26,337 16.0 43.9 43.9 31.5 137.7 137.9 1.0 1.0 338.0                     0.0
105024 105024 2017 6,257,831 Sisters of St. John the Baptist Inc. 61 Cleveland STATEN IS 61 Cleveland Place K-12 School 25,562 37.0 111.0 111.0 99.6 246.3 246.3 2.0 1.0 472.0       1.0             0.0
105026 105026 2017 6,273,201 St Johns Villa Academy 25 Landis STATEN IS 25 Landis Avenue K-12 School 40,066 47.0 115.8 118.5 112.8 201.8 204.7 4.0 1.0 462.0 1.0     1.0             0.0
105109 105109 2017 6,236,976 Trevor Day School Upper School MANHATTAN 312 E 95th Street K-12 School 105,000 56.0 68.4 70.3 72.9 173.6 175.5 7.0 5.0 1.0 2.0                   0.0
105198 105198 2017 1,633,018 X140-0200184 BRONX 916 Eagle Avenue K-12 School 111,600 91.0 45.5 50.1 75.4 73.5 78.3 5.0 1.0 402.0 3.0                   0.0
105206 105206 2017 1,633,028 M022-0100044 MANHATTAN 111 Columbia Street K-12 School 181,200 94.0 43.8 48.2 78.4 79.9 85.1 7.0 2.0 747.0 65.0   5.0               0.0
105207 105207 2017 1,633,030 M050-0100064 MANHATTAN 433 East 100th Street K-12 School 141,600 91.0 39.8 41.8 66.0 80.7 82.1 5.0 2.0 771.0 3.0                   0.0
105208 105208 2017 4,898,671 Q892-0401789 QUEENS 199-10 112 Avenue K-12 School 41,381 10.0 151.0 158.2 98.1 233.9 241.5 6.0 1.0 437.0 4.0                   0.0
105214 105214 2017 1,633,048 M192-0100161 MANHATTAN 500 West 138th Street K-12 School 130,560 96.0 54.1 61.4 105.8 75.6 83.2 7.0 1.0 343.0 5.0     0.0             0.0
105215 105215 2017 5,836,439 K884-0301508 BROOKLYN 15 Snyder Avenue K-12 School 52,500 90.0 44.6 47.1 71.9 92.1 94.7 2.0 1.0 333.0 1.0                   0.0
105216 105216 2017 6,293,176 M342- 0101784 MANHATTAN 300 West 61st Street K-12 School 122,432       58.2                                
105222 105222 2017 1,633,058 M898-0101303 MANHATTAN 4124 9th Avenue K-12 School 23,080 96.0 63.4 68.7 126.3 128.9 134.5 1.0 688.0 201.0 773.0                   0.0
105223 105223 2017 6,293,400 Q298-0401828 QUEENS 50-51 98th Street K-12 School 109,759       58.2                                
105232 105232 2017 1,633,070 X052-0200088 BRONX 681 Kelly Street K-12 School 164,500 84.0 67.4 74.5 97.7 99.0 106.2 11.0 2.0 697.0 470.0     8.0             0.0
105233 105233 2017 1,633,086 K016-0300043 BROOKLYN 157 Wilson Street K-12 School 121,200 87.0 56.6 63.6 87.4 82.8 90.2 6.0 1.0 398.0 5.0     223.0             0.0
105241 105241 2017 1,633,092 K056-0300076 BROOKLYN 170 Gates Avenue K-12 School 100,800 83.0 59.1 63.2 84.7 101.8 106.1 5.0 1.0 561.0 4.0                   0.0
105250 105250 2017 1,633,108 Q097-0400089 QUEENS 85-52 85th Street K-12 School 90,665 91.0 54.6 57.1 91.9 94.4 97.6 4.0 1.0 473.0 2.0     344.0             0.0
105279 105279 2017 6,296,339 X779-0201505 BRONX 2865 Claflin Avenue K-12 School 35,000       58.2                                
105330 105330 2017 1,633,155 K282-0300282 BROOKLYN 180 6th Avenue K-12 School 104,400 73.0 44.9 44.9 56.2 65.2 65.2 4.0 972.0 285.0 85.0       3.0           0.0
105342 105342 2017 1,633,118 Q140-0400126   116-01 116 Avenue K-12 School 90,480 86.0 66.4 71.2 99.5 96.5 101.9 6.0 1.0 342.0 4.0     524.0             0.0
105343 105343 2017 1,633,606 K458-0300338 BROOKLYN 832 Marcy Avenue K-12 School 213,600 85.0 61.1 65.7 90.5 110.9 115.8 13.0 4.0 1.0 7.0     483.0             0.0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE energy(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "ENERGY STAR Score" REAL,
  "Site EUI (kBtu/ft2)" REAL,
  "Weather Norm Site EUI (kBtu/ft2)" REAL,
  "National Median Site EUI (kBtu/ft2)" REAL,
  "Source EUI (kBtu/ft2)" REAL,
  "Weather Norm Source EUI (kBtu/ft2)" REAL,
  "Total Site Energy (kBtu)" REAL,
  "Electricity (kBtu)" REAL,
  "Electricity (kWh)" REAL,
  "Natural Gas Use (kBtu)" REAL,
  "Natural Gas Use (therms)" 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,
  "Diesel #2 Use (kBtu)" REAL,
  "District Hot Water Use (kBtu)" REAL,
  "District Chilled Water Use (kBtu)" REAL,
  "Green Power - Onsite (kWh)" REAL,
  "Green Power - Offsite (kWh)" REAL
);
CREATE INDEX "idx_energy_Calendar Year" ON [energy] ("Calendar Year");
CREATE INDEX "idx_energy_Property ID" ON [energy] ("Property ID");
CREATE INDEX "idx_energy_Borough" ON [energy] ("Borough");
CREATE INDEX "idx_energy_Property Type" ON [energy] ("Property Type");