Energy — EUI and Fuel Use by Type
Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability
48 rows where Borough = "STATEN IS" and Property Type = "Medical Office" sorted by Calendar Year descending
This data as json, CSV (advanced)
Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), ENERGY STAR Score, Electricity (kWh), Natural Gas Use (therms)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 312143 | 312143 | 2024 | 4038773 | Emblem - Clove Lake | STATEN IS | 1050 Clove Road | Medical Office | 54,325 | 48.0 | 103.0 | 104.2 | 101.9 | 250.4 | 251.7 | 5592919.1 | 4418128.0 | 1294879.3 | 1174791.0 | 11747.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 312463 | 312463 | 2024 | 4045810 | SI SIHN 242 Mason Ave 5104756 | STATEN IS | 242 Mason Avenue | Medical Office | 29,714 | 0.0 | 0.0 | 0.0 | 97.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 321654 | 321654 | 2024 | 7424314 | SI 501 Seaview Ave 5146762 | STATEN IS | 501 Seaview Avenue | Medical Office | 34,446 | 47.0 | 115.7 | 121.0 | 113.5 | 231.3 | 238.9 | 3983968.0 | 2162015.9 | 633650.6 | 1821952.0 | 18219.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 328863 | 328863 | 2024 | 21355562 | H+H_9067_Gotham Health Vanderbilt | STATEN IS | 165 Vanderbilt Ave | Medical Office | 18,000 | 1.0 | 125.9 | 125.9 | 64.3 | 343.5 | 343.5 | 2265504.7 | 2174135.6 | 637202.7 | 91369.0 | 913.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 333072 | 333072 | 2024 | 33964615 | Richmond University Medical Center | STATEN IS | 1130 South Avenue | Medical Office | 37,759 | 1.0 | 429.4 | 439.1 | 138.9 | 1169.0 | 1194.2 | 16213262.9 | 15494095.9 | 4541059.8 | 719167.0 | 7191.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 333857 | 333857 | 2024 | 36469034 | 11 Ralph Place | STATEN IS | 11 Ralph Place | Medical Office | 35,280 | 98.0 | 48.1 | 50.8 | 95.0 | 93.2 | 97.2 | 1697469.8 | 860612.7 | 252231.2 | 836857.0 | 8368.6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 335643 | 335643 | 2024 | 52261193 | SI SIHN 242 Rear Mason Ave 5155715 | STATEN IS | 242 Rear Mason Avenue | Medical Office | 29,713 | 0.0 | 0.0 | 0.0 | 97.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 335846 | 335846 | 2024 | 52559292 | SI 2175 Richmond Rd 5175055 | STATEN IS | 2175 Richmond Road | Medical Office | 35,383 | 0.0 | 50.7 | 53.2 | 105.1 | 112.3 | 116.1 | 1794956.4 | 1194603.4 | 350118.2 | 600353.0 | 6003.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 286128 | 286128 | 2023 | 3268580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76,866 | 0.0 | 83.6 | 88.3 | 217.5 | 164.2 | 169.0 | 6428161.5 | 3353661.7 | 982901.9 | 3074499.7 | 30745.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 287423 | 287423 | 2023 | 4038773 | Emblem - Clove Lake | STATEN IS | 1050 Clove Road | Medical Office | 54,325 | 51.0 | 104.4 | 104.4 | 105.6 | 248.9 | 248.9 | 5672147.4 | 4322747.4 | 1266924.6 | 1349400.0 | 13494.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 289968 | 289968 | 2023 | 33964615 | Richmond University Medical Center | STATEN IS | 1130 South Avenue | Medical Office | 37,759 | 1.0 | 398.4 | 404.1 | 63.0 | 1115.5 | 1131.6 | 15043153.6 | 15043153.6 | 4408895.6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 295482 | 295482 | 2023 | 21355562 | H+H_9067_Gotham Health Vanderbilt | STATEN IS | 165 Vanderbilt Ave | Medical Office | 18,000 | 5.0 | 107.0 | 107.0 | 65.9 | 291.2 | 291.2 | 1926406.6 | 1839064.6 | 538998.9 | 87342.0 | 873.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 298486 | 298486 | 2023 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58,893 | 0.0 | 0.0 | 0.0 | 97.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 245682 | 245682 | 2022 | 4038773 | Emblem - Clove Lake | STATEN IS | 1050 Clove Road | Medical Office | 54,325 | 47.0 | 111.9 | 113.3 | 109.8 | 264.1 | 265.6 | 6078164.3 | 4551464.2 | 1333957.7 | 1526700.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 245688 | 245688 | 2022 | 5882591 | Emblem - Annadale Medical Center | STATEN IS | 4771 Hylan Boulevard | Medical Office | 44,910 | 43.0 | 136.0 | 138.6 | 129.4 | 280.8 | 282.2 | 6106536.9 | 3543337.0 | 1038492.5 | 2563199.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 256006 | 256006 | 2022 | 6784634 | Richmond University Medical Center | STATEN IS | 1130 South Avenue | Medical Office | 38,000 | 100.0 | 24.3 | 26.0 | 327.8 | 25.5 | 27.3 | 923000.0 | 0.0 | 0.0 | 923000.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 259263 | 259263 | 2022 | 3268580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76,866 | 0.0 | 88.7 | 90.3 | 221.4 | 171.1 | 172.8 | 6821290.9 | 3423191.0 | 1003279.8 | 3398099.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 259264 | 259264 | 2022 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58,893 | 0.0 | 0.0 | 0.0 | 97.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 271369 | 271369 | 2022 | 21355562 | H+H_9067_Gotham Health Vanderbilt | STATEN IS | 165 Vanderbilt Ave | Medical Office | 18,000 | 11.0 | 99.7 | 99.7 | 68.8 | 270.7 | 270.7 | 1794277.4 | 1708197.4 | 500643.9 | 86080.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 218274 | 218274 | 2021 | 6784634 | Richmond University Medical Center | STATEN IS | 1130 South Avenue | Medical Office | 38,000 | 100.0 | 22.6 | 26.1 | 326.4 | 23.8 | 27.4 | 860300.0 | 0.0 | 0.0 | 860300.0 | 8603.000291 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223762 | 223762 | 2021 | 21355562 | H+H_9067_Gotham Health Vanderbilt | STATEN IS | 165 Vanderbilt Ave | Medical Office | 18,000 | 3.0 | 117.9 | 119.4 | 68.0 | 321.1 | 325.1 | 2122646.9 | 2029484.8 | 594807.9 | 93162.0 | 931.6200205 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 233259 | 233259 | 2021 | 3268580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76,866 | 0.0 | 83.1 | 86.4 | 214.4 | 165.6 | 169.0 | 6391138.8 | 3437922.4 | 1007597.3 | 2953216.4 | 29532.16362 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 233260 | 233260 | 2021 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58,893 | 0.0 | 0.0 | 0.0 | 97.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 190153 | 190153 | 2020 | 3268580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76866 | 0.0 | 86.6 | 89.3 | 208.6 | 177.3 | 180.2 | 6658605.0 | 3790824.7 | 1111027.0 | 2867780.4 | 28677.80373 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 191311 | 191311 | 2020 | 4038773 | 1050 Clove Road | STATEN IS | 1050 Clove Road | Medical Office | 54000 | 0.0 | 122.1 | 124.9 | 61.3 | 290.2 | 293.2 | 6594880.1 | 4998580.1 | 1464999.9 | 1596300.0 | 15963.00022 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 191685 | 191685 | 2020 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58893 | 0.0 | 0.0 | 0.0 | 51.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 195126 | 195126 | 2020 | 5882591 | 4771 Hylan Boulevard | STATEN IS | 4771 Hylan Boulevard | Medical Office | 43788 | 0.0 | 99.4 | 102.0 | 64.6 | 224.5 | 226.3 | 4353589.5 | 3005289.5 | 880799.9 | 1348300.0 | 13482.99973 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 203380 | 203380 | 2020 | 6784634 | Richmond University Medical Center | STATEN IS | 1130 South Avenue | Medical Office | 38000 | 100.0 | 24.7 | 27.9 | 275.8 | 26.0 | 29.3 | 939400.0 | 0.0 | 0.0 | 939400.0 | 9393.9998 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 204372 | 204372 | 2020 | 6811572 | HHC - 5169148 - Gotham Health Vanderbilt (LL84) | STATEN IS | 165 Vanderbilt Ave | Medical Office | 18000 | 0.0 | 126.8 | 126.8 | 44.4 | 347.1 | 347.1 | 2281670.0 | 2200883.0 | 645041.8 | 80787.0 | 807.869962 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 161912 | 161912 | 2019 | 3268580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76,866 | 0.0 | 76.7 | 77.4 | 198.6 | 164.9 | 165.6 | 5898046.9 | 3706224.3 | 1086232.1 | 2191822.6 | 21918.22595 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 163156 | 163156 | 2019 | 4038773 | 1050 Clove Road | STATEN IS | 1050 Clove Road | Medical Office | 54,000 | 0.0 | 138.7 | 140.0 | 62.9 | 321.8 | 323.1 | 7491551.6 | 5433951.7 | 1592600.0 | 2057599.9 | 20575.99866 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 163554 | 163554 | 2019 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58,893 | 0.0 | 0.0 | 0.0 | 51.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 167339 | 167339 | 2019 | 5882591 | 4771 Hylan Boulevard | STATEN IS | 4771 Hylan Boulevard | Medical Office | 43,788 | 0.0 | 135.4 | 136.9 | 71.6 | 275.6 | 276.7 | 5927700.5 | 3338300.5 | 978399.8 | 2589399.9 | 25893.99947 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 176669 | 176669 | 2019 | 6784634 | Richmond University Medical Center | STATEN IS | 1130 South Avenue | Medical Office | 38,000 | 85.0 | 68.7 | 69.6 | 134.6 | 151.0 | 151.9 | 2609448.8 | 1712848.8 | 502007.2 | 896600.0 | 8965.999988 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 177820 | 177820 | 2019 | 6811572 | HHC - 5169148 - Gotham Health Vanderbilt (LL84) | STATEN IS | 165 Vanderbilt Ave | Medical Office | 18,000 | 7.0 | 117.4 | 117.4 | 70.6 | 321.0 | 321.0 | 2113141.4 | 2034234.4 | 596199.9 | 78907.0 | 789.070009 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 136644 | 136644 | 2018 | 3268580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76,866 | 0.0 | 97.8 | 98.6 | 212.8 | 196.1 | 197.1 | 7513984.4 | 4106174.6 | 1203450.8 | 3407809.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 138401 | 138401 | 2018 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58,893 | 0.0 | 0.0 | 0.0 | 51.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 153226 | 153226 | 2018 | 6811572 | HHC - 5169148 - Gotham Health Vanderbilt (LL84) | STATEN IS | 165 Vanderbilt Ave | Medical Office | 18,000 | 6.0 | 122.7 | 122.7 | 72.5 | 336.1 | 336.1 | 2208217.6 | 2131817.6 | 624799.9 | 76400.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 104525 | 104525 | 2017 | 6,212,863 | 501 Seaview MOB | STATEN IS | 501 Seaview Avenue | Medical Office | 48,954 | 111.3 | 114.4 | 57.0 | 228.1 | 230.2 | 5.0 | 2.0 | 763.0 | 2.0 | 0.0 | ||||||||||
| 107546 | 107546 | 2017 | 6,212,863 | 501 Seaview MOB | STATEN IS | 501 Seaview Avenue | Medical Office | 48,954 | 111.3 | 114.4 | 57.0 | 228.1 | 230.2 | 5.0 | 2.0 | 763.0 | 2.0 | 0.0 | ||||||||||
| 111407 | 111407 | 2017 | 3,268,580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76,866 | 91.8 | 93.0 | 209.3 | 187.2 | 188.4 | 7.0 | 3.0 | 1.0 | 3.0 | 0.0 | ||||||||||
| 111408 | 111408 | 2017 | 4,045,810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58,893 | 51.2 | |||||||||||||||||||
| 91027 | 91027 | 2016 | 3,268,580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76,866 | 0.0 | 95.6 | 97.2 | 177.5 | 210.0 | 211.7 | 7349265.9 | 4029972.7 | 3319293.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
| 91028 | 91028 | 2016 | 4,045,810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58,893 | 0.0 | 0.0 | 0.0 | 44.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
| 70652 | 70652 | 2015 | 3268580 | STATEN ISLAND UNIVERSITY HOSPITAL Radiology | STATEN IS | 256 Mason Ave | Medical Office | 76866 | 0.0 | 92.6 | 93.9 | 185.1 | 195.1 | 196.4 | 7120808.7 | 3597328.1 | 3523480.6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
| 70653 | 70653 | 2015 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58893 | 0.0 | 0.0 | 0.0 | 44.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
| 48649 | 48649 | 2013 | 4045810 | 242 Mason Ave | STATEN IS | 475 Seaview Av | Medical Office | 58893 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||
| 27744 | 27744 | 2012 | 2748076 | Clove Lake Medical Office | STATEN IS | 1050 Clove Road | Medical Office | 53000 | 19.0 | 134.4 | 138.4 | 101.1 | 388.7 | 392.8 | 7124853.1 | 5730553.06 | 1394300.0 | 13943.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
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");