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

74 rows where Borough = "QUEENS" and Property Type = "Other - Mall" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property Name, Address 1, Floor Area (ft2), Natural Gas Use (therms), Fuel Oil #2 Use (kBtu), Green Power - Offsite (kWh)

Calendar Year 12

Property Type 1

  • Other - Mall · 74 ✖

Borough 1

  • QUEENS · 74 ✖
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)
313111 313111 2024 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 60.8 60.8 80.5 170.2 170.2 3283091.6 3283091.6 962219.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
299110 299110 2023 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 62.3 62.4 80.5 174.5 174.6 3366043.3 3366043.3 986530.7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
305296 305296 2023 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 25,631 0.0 77.8 78.6 91.4 191.7 192.6 1993569.3 1619837.7 474747.2 0.0 0.0 0.0 373731.6 0.0 0.0 0.0 0.0 0.0 0.0 0.0
253996 253996 2022 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 56.0 55.2 80.5 156.9 154.5 3026205.2 3026205.2 886929.9 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
258270 258270 2022 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 25,631 0.0 100.7 100.7 89.0 254.8 254.8 2580310.0 2192599.0 642613.9 0.0   0.0 387711.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
218805 218805 2021 6602844 Lewis & Murphy Realty Inc - 6816 Main St QUEENS 6816 Main St Other - Mall 25,518 0.0 352.1 0.0 118.3 670.5 0.0 8985221.0 4385637.6 1285356.7 4599583.5 45995.83451 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
227594 227594 2021 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 25,631 0.0 89.0 88.1 91.7 218.6 215.1 2280894.6 1842689.4 540061.3 0.0 0.0 0.0 438205.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0
239806 239806 2021 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 57.6 56.1 80.5 161.2 157.1 3109070.3 3109070.3 911216.3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
192604 192604 2020 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54000 0.0 55.2 54.0 80.5 154.5 151.2 2979192.5 2979192.5 873151.3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
200527 200527 2020 6602844 Lewis & Murphy Realty Inc - 6816 Main St QUEENS 6816 Main St Other - Mall 25518 0.0 358.5 367.9 118.0 684.6 692.2 9147418.4 4494066.4 1317135.4 4653351.9 46533.51941 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
200528 200528 2020 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 25631 0.0 128.3 0.0 115.7 249.9 0.0 3287918.7 1687918.6 494700.6 1600000.1 16000.0011 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
164573 164573 2019 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 70.0 69.7 80.5 196.0 195.1 3780872.2 3780872.2 1108110.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
164805 164805 2019 4413933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Other - Mall 154,000 0.0 69.7 69.1 132.7 118.4 117.0 10732949.6 3978139.3 1165925.8 6754810.3 67548.10342 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
173315 173315 2019 6602844 Lewis & Murphy Realty Inc - 6816 Main St QUEENS 6816 Main St Other - Mall 25,518 0.0 386.1 384.5 119.8 726.2 722.4 9851985.0 4678739.9 1371260.1 5173245.1 51732.4514 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
173316 173316 2019 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 25,631 0.0 135.9 0.0 114.6 267.1 0.0 3482762.1 1822762.2 534221.0 1659999.9 16599.99925 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
181117 181117 2019 10512257 PANTZA REALTY CORP QUEENS 23-18 31ST STREET Other - Mall 37,589 0.0 10.8 10.8 80.5 30.3 30.3 406154.2 406154.2 119037.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
132641 132641 2018 2678650 Queens Place Mall QUEENS 88-01 Queens Blvd Other - Mall 462,414 0.0 94.3 94.3 101.5 209.4 209.4 43610703.5 29166203.6 8548124.3 14444499.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
134944 134944 2018 2814700 140-01 20th Avenue QUEENS 140-01 20th Avenue Other - Mall 79,800 0.0 99.0 98.7 101.4 219.9 219.6 7897004.4 5288230.8 1549891.6 2608773.6   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
137652 137652 2018 3927350 96-05 Queens Blvd QUEENS 96-05 Queens Blvd Other - Mall 386,000 0.0 53.8 53.7 96.5 125.5 125.5 20753956.9 15237157.0 4465754.7 5516799.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
139490 139490 2018 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 72.5 71.7 80.5 202.9 200.7 3913491.8 3913491.8 1146978.7 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
139742 139742 2018 4413933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Other - Mall 154,000 0.0 73.2 72.2 133.0 124.0 121.5 11268451.8 4148644.6 1215898.0 7119807.2   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
142759 142759 2018 6167848 The Plaza at Little Neck Hills, LLC QUEENS 252-20 Northern Boulevard Other - Mall 35,000 0.0 109.5 108.4 133.7 184.6 181.7 3833417.6 1391411.3 407799.3 2442006.2   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
142954 142954 2018 6187119 166-02 Jamaica Ave (728) QUEENS 166-02 Jamaica Avenue Other - Mall 43,302 0.0 24.0 23.5 80.5 67.2 65.8 1039367.4 1039367.4 304621.1 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
142955 142955 2018 6187120 220-10 Hillside Ave (W25) QUEENS 220-10 Hillside Avenue Other - Mall 48,708 0.0 315.8 315.6 132.2 538.4 538.6 15382195.5 5756625.5 1687170.2 9625570.1   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
142956 142956 2018 6187123 31-01 Ditmars Blvd (011) QUEENS 21-81 31 Street Other - Mall 47,500 0.0 146.2 143.4 107.8 305.7 298.6 6943991.2 4130038.7 1210444.9 2813952.5   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
142957 142957 2018 6187130 163-02 Jamaica Ave (W21) QUEENS 163-02 Jamaica Avenue Other - Mall 44,950 0.0 59.2 58.5 80.5 165.6 163.7 2658999.0 2658999.0 779307.9 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
148531 148531 2018 6602844 Lewis & Murphy Realty Inc - 6816 Main St QUEENS 6816 Main St Other - Mall 35,000 0.0 287.9 286.3 117.0 554.5 549.6 10077845.4 5042396.0 1477841.6 5035449.4   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
148532 148532 2018 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 35,000 0.0 104.8 0.0 112.2 210.4 0.0 3667280.6 2006980.7 588212.3 1660300.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
149908 149908 2018 6682287 132-40 METROPOLITAN AVE QUEENS 132-40 METROPOLITAN AVE Other - Mall 40,595 0.0 74.0 73.6 100.9 165.1 164.7 3002414.4 2029514.4 594816.6 972900.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
153046 153046 2018 6808744 96-18 Queens Boulevard QUEENS 96-18 Queens Boulevard Other - Mall 27,900 0.0 119.5 120.4 131.8 204.2 204.8 3334105.8 1255705.8 368026.3 2078400.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
153870 153870 2018 6865211 3502 Partners LLC QUEENS 35-02 Northern Boulevard Other - Mall 41,500 0.0 57.0 57.7 140.7 91.3 91.1 2365957.3 745747.2 218566.0 1620210.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
96957 96957 2017 4,409,881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000   69.9 68.7 75.7 219.5 215.9 3.0 3.0 1.0                     0.0
97847 97847 2017 4,413,933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Other - Mall 154,000   69.4 70.3 128.9 127.9 128.0 10.0 4.0 1.0 6.0                   0.0
100491 100491 2017 6,187,130 163-02 Jamaica Ave (W21) QUEENS 163-02 Jamaica Avenue Other - Mall 44,950   54.7   80.5 153.1   2.0 2.0 720.0                     0.0
108957 108957 2017 3,927,395 61-35 Junction Blvd QUEENS 61-35 Junction Blvd Other - Mall 705,201   106.0 105.2 78.1 322.5 320.0 74.0 71.0 20.0 3.0                   0.0
109126 109126 2017 3,927,395 61-35 Junction Blvd QUEENS 61-35 Junction Blvd Other - Mall 705,201   106.0 105.2 78.1 322.5 320.0 74.0 71.0 20.0 3.0                   0.0
109821 109821 2017 6,187,119 166-02 Jamaica Ave (728) QUEENS 166-02 Jamaica Avenue Other - Mall 43,302   24.8 25.0 75.7 77.8 78.5 1.0 1.0 314.0                     0.0
109822 109822 2017 6,187,120 220-10 Hillside Ave (W25) QUEENS 220-10 Hillside Avenue Other - Mall 48,708       94.1                                
109823 109823 2017 6,187,123 31-01 Ditmars Blvd (011) QUEENS 21-81 31 Street Other - Mall 47,500   49.1   101.0 115.5   2.0 1.0 425.0 880.0                   0.0
109824 109824 2017 6,187,130 163-02 Jamaica Ave (W21) QUEENS 163-02 Jamaica Avenue Other - Mall 44,950       94.1                                
110375 110375 2017 6,187,120 220-10 Hillside Ave (W25) QUEENS 220-10 Hillside Avenue Other - Mall 48,708   343.9   125.0 619.9   16.0 7.0 2.0 9.0                   0.0
110376 110376 2017 6,187,123 31-01 Ditmars Blvd (011) QUEENS 21-81 31 Street Other - Mall 47,500   49.1   105.3 105.1   2.0 1.0 425.0 880.0                   0.0
111075 111075 2017 2,678,650 Queens Place Mall QUEENS 88-01 Queens Blvd Other - Mall 462,414   95.0 94.8 97.0 220.5 220.2 43.0 31.0 9.0 11.0                   0.0
112653 112653 2017 3,927,350 96-05 Queens Blvd QUEENS 96-05 Queens Blvd Other - Mall 386,000   49.6 49.6 87.3 127.9 127.9 19.0 16.0 4.0 2.0                   0.0
112671 112671 2017 2,814,700 140-01 20th Avenue QUEENS 140-01 20th Avenue Other - Mall 79,800   99.4 103.3 100.0 224.0 226.8 7.0 5.0 1.0 2.0                   0.0
117007 117007 2017 3,927,350 96-05 Queens Blvd QUEENS 96-05 Queens Blvd Other - Mall 386,000   52.8 54.0 90.6 131.3 132.5 20.0 16.0 4.0 3.0                   0.0
121527 121527 2017 6,602,844 6816 Main St - Lewis & Murphy Realty Inc QUEENS 6816 Main St Other - Mall 35,000   281.6 289.5 116.2 546.3 555.2 9.0 5.0 1.0 4.0                   0.0
121639 121639 2017 6,602,848 11313 Queens blvd - Lewis & Murphy Realty Inc QUEENS 11313 Queens blvd Other - Mall 35,000   60.6 59.8 80.5 169.6 167.4 2.0 2.0 621.0                     0.0
125734 125734 2017 6,602,848 11313 Queens blvd - Lewis & Murphy Realty Inc QUEENS 11313 Queens blvd Other - Mall 35,000   107.8   110.8 219.2   3.0 2.0 621.0 1.0                   0.0
125849 125849 2017 6,602,844 6816 Main St - Lewis & Murphy Realty Inc QUEENS 6816 Main St Other - Mall 35,000   281.6 289.5 116.2 546.3 555.2 9.0 5.0 1.0 4.0                   0.0
126586 126586 2017 6,602,844 6816 Main St - Lewis & Murphy Realty Inc QUEENS 6816 Main St Other - Mall 35,000   281.6 289.5 116.2 546.3 555.2 9.0 5.0 1.0 4.0                   0.0
126772 126772 2017 6,602,848 11313 Queens blvd - Lewis & Murphy Realty Inc QUEENS 11313 Queens blvd Other - Mall 35,000   107.8   110.8 219.2   3.0 2.0 621.0 1.0                   0.0
128017 128017 2017 6,602,844 6816 Main St - Lewis & Murphy Realty Inc QUEENS 6816 Main St Other - Mall 35,000   281.6 289.5 116.2 546.3 555.2 9.0 5.0 1.0 4.0                   0.0
128205 128205 2017 6,602,848 11313 Queens blvd - Lewis & Murphy Realty Inc QUEENS 11313 Queens blvd Other - Mall 35,000   107.8   110.8 219.2   3.0 2.0 621.0 1.0                   0.0
78991 78991 2016 3,927,395 Rego Park II (DSC) QUEENS 61-35 Junction Blvd Other - Mall 705,201 0.0 95.2 95.8 78.4 288.5 289.2 67101287.0 63624987.0   3476300.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
91716 91716 2016 4,409,881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 75.7 73.6 75.7 237.6 231.0 4085305.0 4085305.0   0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
91717 91717 2016 4,413,933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Other - Mall 154,000 0.0 71.1 71.5 124.4 135.9 134.8 10957065.2 4508233.4   6448831.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
92845 92845 2016 2,814,700 Triangle Plaza LLC QUEENS 140-01 20th Avenue Other - Mall 79,800 0.0 101.9 105.4 94.7 255.7 256.3 8133423.4 5675834.4   2457589.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
93481 93481 2016 3,927,350 Rego Park I (DSC) QUEENS 96-31 Queens Blvd Other - Mall 386,000 0.0 60.5 61.7 81.2 176.9 178.3 23348568.9 20947569.0   2400999.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
94057 94057 2016 2,678,650 Queens Place Mall QUEENS 88-01 Queens Blvd Other - Mall 462,414 0.0 93.6 93.6 92.1 241.6 241.6 43282488.8 31702925.1   11579563.7   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
65425 65425 2015 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54000 0.0 76.7 75.1 75.7 240.9 235.8 4142235.6 4142235.6   0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
65426 65426 2015 4413933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Other - Mall 154000 0.0 73.8 73.9 127.2 137.8 138.0 11365697.4 4445596.6   6920100.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
67327 67327 2015 3927350 Rego Park I (DSC) QUEENS 96-31 Queens Blvd Other - Mall 386000 0.0 63.6 63.5 78.7 192.0 191.9 24544010.4 23125510.2   1418500.2   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
67412 67412 2015 2814700 Triangle Plaza LLC QUEENS 140-01 20th Avenue Other - Mall 79800 0.0 106.2 104.7 97.4 259.0 255.1 8472156.8 5634506.9   2837649.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
69657 69657 2015 2678650 Queens Place Mall QUEENS 88-01 Queens Blvd Other - Mall 462414 0.0 84.0 84.0 87.2 228.8 228.8 38829377.8 31112954.2   7716423.6   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
76160 76160 2015 3927395 Rego Park II (DSC) QUEENS 61-35 Junction Blvd Other - Mall 705201 0.0 86.3 85.6 88.6 231.5 229.7 60888077.7 47522676.9   13365400.7   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
51674 51674 2014 2678649 Northern QUEENS 48-18 Northern Blvd. Other - Mall 218059 0.0 137.0 135.1 50.7 332.7 331.5 29864843.2 19707739.3   10157103.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
51675 51675 2014 2678650 Queens Place Mall QUEENS 88-01 Queens Blvd Other - Mall 462414 0.0 88.8 88.4 92.1 229.2 228.8 41058753.2 30074241.1   10984512.1   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 380773.5
54872 54872 2014 2814700 Triangle Plaza LLC QUEENS 140-01 20th Avenue Other - Mall 79800 0.0 114.2 108.7 99.4 273.1 266.9 9116841.0 5846158.2   3270682.8   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
61640 61640 2014 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54000 0.0 86.1 86.6 75.7 270.3 272.0 4648338.0 4648338.0   0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
61993 61993 2014 4413933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Other - Mall 154000 0.0 92.9 92.9 75.7 291.8 291.8 14313202.9 14313202.9   0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
38714 38714 2013 2678649 Northern QUEENS 48-18 Northern Blvd. Other - Mall 218059 0.0 139.2 138.4 49.2 348.4 347.8 30346806.9 21104822.2   9241984.7   0.0 0.0 0.0 0.0       0.0 0.0
38715 38715 2013 2678650 Queens Place Mall QUEENS 88-01 Queens Blvd Other - Mall 462414 0.0 91.7 91.7 92.8 234.9 234.9 42426277.6 30660794.0   11765483.6   0.0 0.0 0.0 0.0       0.0 0.0
45964 45964 2013 3446624 Utopia Center QUEENS 176-60 Union Turnpike Other - Mall 173462 0.0 50.1 49.6 86.8 137.0 136.4 8686352.4 7006790.0   1679562.4   0.0 0.0 0.0 0.0       0.0 0.0

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