Energy — EUI and Fuel Use by Type
Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability
98 rows where Calendar Year = 2021 and Property Type = "Police Station" sorted by Calendar Year descending
This data as json, CSV (advanced)
Suggested facets: District Steam Use (kBtu), Fuel Oil #2 Use (kBtu)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 221892 | 221892 | 2021 | 21353688 | NYPD_4173_Classified NYPD Location | Classified NYPD Location | Police Station | 7,900 | 0.0 | 446.9 | 490.8 | 82.9 | 673.0 | 712.2 | 3530130.6 | 971423.7 | 284708.0 | 309928.0 | 3099.27994 | 0.0 | 2248778.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 222026 | 222026 | 2021 | 21353822 | Benchmarking Group - 137 | Classified NYPD Location | Police Station | 15,160 | 0.0 | 175.8 | 190.4 | 68.5 | 320.4 | 335.8 | 2664382.6 | 1177353.6 | 345062.5 | 1487029.1 | 14870.29091 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 222028 | 222028 | 2021 | 21353824 | NYPD_4526_Classified NYPD Location | Classified NYPD Location | Police Station | 14,300 | 0.0 | 183.2 | 198.7 | 69.1 | 331.0 | 347.3 | 2619960.5 | 1132931.4 | 332043.2 | 1487029.1 | 14870.29091 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 222062 | 222062 | 2021 | 21353858 | Benchmarking Group - 148 | BROOKLYN | 2900 Flatbush Ave | Police Station | 49,935 | 0.0 | 111.0 | 118.1 | 63.0 | 157.2 | 164.2 | 5541027.6 | 1161503.5 | 340417.2 | 4379524.1 | 43795.24073 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 222067 | 222067 | 2021 | 21353863 | NYPD_4536_Highway District Unit 2 | BROOKLYN | 2900 Flatbush Ave | Police Station | 23,700 | 0.0 | 168.8 | 179.7 | 84.7 | 248.9 | 260.4 | 3999487.0 | 970833.9 | 284535.1 | 3028653.1 | 30286.53123 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 222392 | 222392 | 2021 | 21354188 | Benchmarking Group - 188 | QUEENS | 244-04 North Conduit Avenue | Police Station | 65,024 | 0.0 | 35.0 | 35.0 | 56.7 | 77.0 | 77.0 | 2274319.7 | 1496759.7 | 438675.1 | 777560.0 | 7775.599972 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 222393 | 222393 | 2021 | 21354189 | NYPD_14562_116th Precinct | QUEENS | 244-04 North Conduit Avenue | Police Station | 46,000 | 0.0 | 0.0 | 0.0 | 63.5 | 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 |
| 222394 | 222394 | 2021 | 21354190 | NYPD_4581_Classified NYPD Location | Classified NYPD Location | Police Station | 19,024 | 0.0 | 119.6 | 119.6 | 56.7 | 263.2 | 263.2 | 2274319.7 | 1496759.7 | 438675.1 | 777560.0 | 7775.599972 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 222639 | 222639 | 2021 | 21354437 | NYPD_4491_49th Precinct | BRONX | 2121 Eastchester Rd | Police Station | 31,070 | 0.0 | 122.9 | 127.8 | 65.3 | 234.9 | 237.4 | 3817229.4 | 1880598.5 | 551171.8 | 1936630.9 | 19366.30866 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 222755 | 222755 | 2021 | 21354553 | Benchmarking Group - 40 | BROOKLYN | 2951 West 8th St | Police Station | 35,620 | 0.0 | 160.4 | 176.8 | 77.6 | 258.2 | 274.6 | 5715142.3 | 1908745.6 | 559421.3 | 170566.0 | 1705.659945 | 0.0 | 3635830.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 222757 | 222757 | 2021 | 21354555 | NYPD_4498_60th Precinct and Engine Company 245 | BROOKLYN | 2951 West 8th St | Police Station | 32,400 | 0.0 | 176.4 | 194.3 | 77.6 | 283.8 | 301.9 | 5715142.3 | 1908745.6 | 559421.3 | 170566.0 | 1705.659945 | 0.0 | 3635830.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 222963 | 222963 | 2021 | 21354761 | NYPD_10920_Fort Totten: Building 610 Coast Guard Facility | QUEENS | 610 Little Bay Rd | Police Station | 10,500 | 0.0 | 0.0 | 0.0 | 63.5 | 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 |
| 222964 | 222964 | 2021 | 21354762 | NYPD_10921_Fort Totten: Building 611 Coast Guard Facility | QUEENS | 611 Little Bay Rd | Police Station | 4,360 | 0.0 | 0.0 | 0.0 | 63.5 | 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 |
| 223056 | 223056 | 2021 | 21354854 | Benchmarking Group - 6 | MANHATTAN | 153 East 67th St | Police Station | 37,286 | 0.0 | 212.5 | 224.5 | 71.5 | 371.2 | 384.0 | 7924963.0 | 2695780.2 | 790087.9 | 0.0 | 0.0 | 5229182.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223058 | 223058 | 2021 | 21354856 | NYPD_4437_Eng39, Lad16, Pct19: 19th Precinct | MANHATTAN | 153 East 67th St | Police Station | 24,326 | 0.0 | 325.8 | 344.1 | 71.5 | 568.9 | 588.6 | 7924963.0 | 2695780.2 | 790087.9 | 0.0 | 0.0 | 5229182.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223059 | 223059 | 2021 | 21354857 | Benchmarking Group - 60 | QUEENS | 92-24 Rockaway Beach Blvd | Police Station | 35,870 | 0.0 | 84.2 | 91.3 | 99.5 | 105.7 | 113.1 | 3020876.4 | 353861.4 | 103710.8 | 2667015.0 | 26670.15014 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223060 | 223060 | 2021 | 21354858 | NYPD_10034_100th Precinct: 100th Precinct Annex | QUEENS | 92-20 De Sota Rd | Police Station | 3,200 | 0.0 | 0.0 | 0.0 | 63.5 | 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 |
| 223061 | 223061 | 2021 | 21354859 | NYPD_4546_100th Precinct: 100th Precinct | QUEENS | 92-24 Rockaway Beach Blvd | Police Station | 20,710 | 0.0 | 94.1 | 103.7 | 118.9 | 98.8 | 108.9 | 1948515.0 | 0.0 | 0.0 | 1948515.0 | 19485.1504 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223143 | 223143 | 2021 | 21354941 | NYPD_4458_Classified NYPD Location | Classified NYPD Location | Police Station | 100,000 | 0.0 | 19.7 | 22.0 | 118.9 | 20.7 | 23.2 | 1970559.9 | 0.0 | 0.0 | 1970559.9 | 19705.59907 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223259 | 223259 | 2021 | 21355057 | Benchmarking Group - 95 | BRONX | 3016 Webster Ave | Police Station | 25,407 | 0.0 | 140.4 | 140.0 | 71.2 | 246.2 | 244.4 | 3567898.8 | 1477800.6 | 433118.5 | 138806.0 | 1388.060004 | 0.0 | 1951292.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223261 | 223261 | 2021 | 21355059 | NYPD_4172_52nd Precinct | BRONX | 3016 Webster Ave | Police Station | 18,746 | 0.0 | 186.0 | 185.1 | 71.3 | 325.8 | 323.1 | 3486575.8 | 1442855.6 | 422876.7 | 92428.0 | 924.279996 | 0.0 | 1951292.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223592 | 223592 | 2021 | 21355392 | NYPD_4434_10th Precinct | MANHATTAN | 230 West 20th St | Police Station | 20,110 | 0.0 | 85.1 | 89.5 | 69.5 | 152.9 | 154.4 | 1711149.1 | 750397.1 | 219928.8 | 66305.0 | 663.050001 | 0.0 | 894447.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223593 | 223593 | 2021 | 21355393 | NYPD_4435_14th Precinct (Midtown South) | MANHATTAN | 357 West 35th St | Police Station | 40,107 | 0.0 | 165.1 | 173.1 | 74.4 | 277.0 | 282.3 | 6622788.6 | 2375652.8 | 696263.9 | 4247135.8 | 42471.35833 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223594 | 223594 | 2021 | 21355394 | NYPD_4436_18th Precinct (Midtown North) | MANHATTAN | 306 West 54th St | Police Station | 30,000 | 0.0 | 130.4 | 141.6 | 71.4 | 228.2 | 239.9 | 3912565.2 | 1564082.7 | 458406.3 | 2348482.6 | 23484.82572 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223595 | 223595 | 2021 | 21355395 | NYPD_4438_1st Precinct | MANHATTAN | 16 Ericsson Pl | Police Station | 23,300 | 0.0 | 122.7 | 135.0 | 69.3 | 221.1 | 230.3 | 2860043.2 | 1227808.3 | 359850.0 | 1632235.0 | 16322.34958 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223596 | 223596 | 2021 | 21355396 | NYPD_4439_20th Precinct | MANHATTAN | 120 West 82nd St | Police Station | 28,000 | 0.0 | 111.7 | 116.7 | 66.9 | 208.6 | 213.0 | 3128348.2 | 1486212.7 | 435584.0 | 542868.9 | 5428.688777 | 0.0 | 1099266.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223597 | 223597 | 2021 | 21355397 | NYPD_4441_23rd Precinct and Engine Company 53 | MANHATTAN | 164 East 102nd St | Police Station | 36,055 | 0.0 | 159.8 | 175.9 | 60.4 | 330.2 | 341.2 | 5762455.6 | 3344671.6 | 980267.1 | 2417784.0 | 24177.83988 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223598 | 223598 | 2021 | 21355398 | NYPD_4442_24th Precinct | MANHATTAN | 151 West 100th St | Police Station | 44,485 | 0.0 | 98.5 | 96.7 | 65.7 | 187.3 | 182.3 | 4381389.5 | 2169491.5 | 635841.5 | 554587.0 | 5545.870247 | 0.0 | 1657311.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223599 | 223599 | 2021 | 21355399 | NYPD_4443_25th Precinct | MANHATTAN | 120 East 119th St | Police Station | 62,500 | 0.0 | 88.4 | 95.7 | 72.6 | 152.0 | 157.2 | 5525243.9 | 2112007.1 | 618993.8 | 3413236.9 | 34132.36866 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223600 | 223600 | 2021 | 21355400 | NYPD_4444_26th Precinct | MANHATTAN | 520 West 126th St | Police Station | 36,856 | 0.0 | 145.0 | 156.8 | 75.9 | 238.6 | 244.9 | 5343736.5 | 1891481.8 | 554361.5 | 280394.0 | 2803.939984 | 0.0 | 3171860.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223601 | 223601 | 2021 | 21355401 | NYPD_4445_28th Precinct | MANHATTAN | 2271-89 8th Ave | Police Station | 37,160 | 0.0 | 110.5 | 118.8 | 71.0 | 194.4 | 202.8 | 4107121.8 | 1716569.0 | 503097.5 | 113539.0 | 1135.389979 | 0.0 | 2277013.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223602 | 223602 | 2021 | 21355402 | NYPD_4446_30th Precinct | MANHATTAN | 451 West 151st St | Police Station | 32,764 | 0.0 | 102.6 | 108.3 | 65.6 | 195.4 | 197.8 | 3361860.2 | 1640533.3 | 480812.7 | 1721326.9 | 17213.2686 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223603 | 223603 | 2021 | 21355403 | NYPD_4447_32nd Precinct | MANHATTAN | 250 West 135th St | Police Station | 26,255 | 0.0 | 129.2 | 137.8 | 69.2 | 233.3 | 239.0 | 3392239.8 | 1505309.0 | 441180.8 | 112361.0 | 1123.610043 | 0.0 | 1774569.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223604 | 223604 | 2021 | 21355404 | NYPD_4448_33rd Precinct | MANHATTAN | 2207 Amsterdam Ave | Police Station | 52,207 | 0.0 | 171.3 | 183.3 | 63.8 | 335.2 | 347.8 | 8943361.8 | 4635024.8 | 1358447.9 | 4308337.0 | 43083.37025 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223605 | 223605 | 2021 | 21355405 | NYPD_4449_34th Precinct | MANHATTAN | 4295 Broadway | Police Station | 26,697 | 0.0 | 117.7 | 119.7 | 59.7 | 245.9 | 242.1 | 3141257.5 | 1867005.5 | 547187.9 | 1274252.0 | 12742.52023 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223606 | 223606 | 2021 | 21355406 | NYPD_4450_5th Precinct | MANHATTAN | 19 Elizabeth St | Police Station | 17,800 | 0.0 | 133.7 | 143.7 | 76.9 | 217.1 | 226.4 | 2379899.1 | 780589.1 | 228777.6 | 1599310.0 | 15993.09991 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223607 | 223607 | 2021 | 21355407 | NYPD_4451_6th Precinct | MANHATTAN | 233 West 10th St | Police Station | 30,489 | 0.0 | 144.3 | 166.9 | 72.2 | 249.5 | 270.3 | 4398559.1 | 1708402.1 | 500704.0 | 2690157.0 | 26901.57009 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223608 | 223608 | 2021 | 21355408 | NYPD_4453_9th Precinct | MANHATTAN | 321 East 5th St | Police Station | 42,235 | 0.0 | 104.9 | 108.6 | 54.7 | 239.6 | 240.5 | 4431857.5 | 3124641.4 | 915779.9 | 1307216.0 | 13072.16048 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223609 | 223609 | 2021 | 21355409 | NYPD_4459_Classified NYPD Location | Classified NYPD Location | Police Station | 22,162 | 0.0 | 114.7 | 124.7 | 71.6 | 200.0 | 208.2 | 2541329.3 | 1007790.2 | 295366.4 | 1533539.1 | 15335.39093 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223611 | 223611 | 2021 | 21355411 | NYPD_4475_Classified NYPD Location | Classified NYPD Location | Police Station | 36,702 | 0.0 | 85.5 | 92.9 | 78.7 | 135.5 | 139.9 | 3136503.7 | 1004468.2 | 294392.8 | 219107.0 | 2191.069964 | 0.0 | 1912928.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223613 | 223613 | 2021 | 21355413 | NYPD_4480_40th Precinct | BRONX | 257 Alexander Ave | Police Station | 10,296 | 0.0 | 262.7 | 284.3 | 74.0 | 443.5 | 458.6 | 2705021.3 | 986425.5 | 289104.8 | 1718595.7 | 17185.95744 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223614 | 223614 | 2021 | 21355414 | NYPD_4481_Detective Borough Command | BRONX | 1086 Simpson St | Police Station | 22,962 | 0.0 | 229.0 | 240.5 | 68.4 | 418.1 | 424.6 | 5257974.5 | 2331276.3 | 683257.9 | 2926698.2 | 29266.98193 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223615 | 223615 | 2021 | 21355415 | NYPD_4482_41st Precinct | BRONX | 1035 Longwood Ave | Police Station | 42,567 | 0.0 | 95.2 | 101.1 | 61.4 | 193.7 | 195.9 | 4054324.4 | 2279864.3 | 668189.9 | 1774460.1 | 17744.60101 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223616 | 223616 | 2021 | 21355416 | NYPD_4483_42nd Precinct | BRONX | 830 Washington Ave | Police Station | 25,465 | 0.0 | 101.8 | 108.6 | 71.6 | 177.6 | 184.5 | 2593147.9 | 1058432.4 | 310208.8 | 238937.0 | 2389.369959 | 0.0 | 1295778.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223617 | 223617 | 2021 | 21355417 | NYPD_4484_43rd Precinct | BRONX | 900 Fteley Ave | Police Station | 35,300 | 0.0 | 131.7 | 141.4 | 64.1 | 256.6 | 266.7 | 4648047.4 | 2386538.4 | 699454.3 | 2261508.9 | 22615.08949 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223618 | 223618 | 2021 | 21355418 | NYPD_4485_Classified NYPD Location | Classified NYPD Location | Police Station | 18,265 | 0.0 | 140.4 | 158.9 | 76.6 | 228.9 | 247.6 | 2564940.3 | 883391.4 | 258907.2 | 213712.0 | 2137.120007 | 0.0 | 1467836.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223619 | 223619 | 2021 | 21355419 | NYPD_4486_44th Precinct | BRONX | 2 East 169th St | Police Station | 48,200 | 0.0 | 161.1 | 177.1 | 69.3 | 290.5 | 304.8 | 7766025.5 | 3340567.4 | 979064.2 | 4425458.0 | 44254.58023 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223620 | 223620 | 2021 | 21355420 | NYPD_4487_45th Precinct | BRONX | 2877 Barkley Ave | Police Station | 26,300 | 0.0 | 39.6 | 38.1 | 44.6 | 110.8 | 106.7 | 1040894.7 | 1040894.7 | 305068.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223621 | 223621 | 2021 | 21355421 | NYPD_4488_46th Precinct | BRONX | 2120 Ryer Ave | Police Station | 25,434 | 0.0 | 95.6 | 101.8 | 66.6 | 179.3 | 182.8 | 2432374.4 | 1145857.4 | 335831.5 | 1286517.0 | 12865.16981 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223622 | 223622 | 2021 | 21355422 | NYPD_4489_47th Precinct | BRONX | 4111 Laconia Ave | Police Station | 34,700 | 0.0 | 114.5 | 122.2 | 66.6 | 214.6 | 220.1 | 3971714.5 | 1872953.3 | 548931.1 | 2098761.3 | 20987.61265 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223623 | 223623 | 2021 | 21355423 | NYPD_4490_48th Precinct | BRONX | 450 Cross Bronx Expwy | Police Station | 59,328 | 0.0 | 138.4 | 137.1 | 67.7 | 255.4 | 251.7 | 8209467.3 | 3732291.4 | 1093871.9 | 4477176.0 | 44771.75974 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223624 | 223624 | 2021 | 21355424 | NYPD_4492_50th Precinct | BRONX | 3450 Kingsbridge Ave | Police Station | 47,097 | 0.0 | 95.5 | 97.6 | 60.0 | 198.8 | 195.8 | 4499552.6 | 2649879.3 | 776635.1 | 1849673.3 | 18496.73262 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223626 | 223626 | 2021 | 21355426 | NYPD_4496_Transit District 12 | BRONX | 460 Morris Park Ave | Police Station | 24,700 | 0.0 | 194.5 | 203.7 | 50.8 | 478.4 | 488.0 | 4804282.9 | 3869016.9 | 1133943.9 | 935266.0 | 9352.660291 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223628 | 223628 | 2021 | 21355428 | NYPD_4499_61st Precinct | BROOKLYN | 2575 Coney Island Ave | Police Station | 31,429 | 0.0 | 126.2 | 131.8 | 66.4 | 237.3 | 241.7 | 3966616.5 | 1881305.4 | 551379.0 | 2085311.1 | 20853.11123 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223629 | 223629 | 2021 | 21355429 | NYPD_4500_62nd Precinct | BROOKLYN | 1925 Bath Ave | Police Station | 21,300 | 0.0 | 97.4 | 102.0 | 66.0 | 184.3 | 183.8 | 2074586.8 | 998192.9 | 292553.6 | 1076394.0 | 10763.93979 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223630 | 223630 | 2021 | 21355430 | NYPD_4501_63rd Precinct | BROOKLYN | 1844 Brooklyn Ave | Police Station | 11,904 | 0.0 | 120.1 | 124.5 | 67.2 | 223.1 | 225.2 | 1429591.5 | 659909.5 | 193408.4 | 769682.0 | 7696.820126 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223631 | 223631 | 2021 | 21355431 | NYPD_4503_67th Precinct and Engine Company 248 | BROOKLYN | 2820 Snyder Ave | Police Station | 46,570 | 0.0 | 152.6 | 161.2 | 65.5 | 290.9 | 296.3 | 7107423.3 | 3475804.3 | 1018699.8 | 3631619.0 | 36316.18988 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223632 | 223632 | 2021 | 21355432 | NYPD_4504_68th Precinct | BROOKLYN | 333 65th St | Police Station | 39,050 | 0.0 | 88.6 | 95.7 | 64.4 | 171.6 | 176.3 | 3458131.7 | 1754963.6 | 514350.3 | 1703168.1 | 17031.68098 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223633 | 223633 | 2021 | 21355433 | NYPD_4505_69th Precinct | BROOKLYN | 9720 Foster Ave | Police Station | 15,792 | 0.0 | 180.0 | 187.2 | 64.5 | 348.6 | 354.4 | 2843045.4 | 1439809.3 | 421983.9 | 1403236.0 | 14032.36018 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223634 | 223634 | 2021 | 21355434 | NYPD_4506_70th Precinct | BROOKLYN | 154 Lawrence Ave | Police Station | 18,000 | 0.0 | 141.5 | 149.0 | 69.3 | 255.0 | 261.6 | 2546128.5 | 1094999.5 | 320926.0 | 1451129.0 | 14511.29029 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223635 | 223635 | 2021 | 21355435 | NYPD_4507_71st Precinct | BROOKLYN | 421 Empire Blvd | Police Station | 24,300 | 0.0 | 136.3 | 143.7 | 63.4 | 268.5 | 272.5 | 3313276.7 | 1740440.7 | 510093.9 | 1572835.9 | 15728.35918 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223636 | 223636 | 2021 | 21355436 | NYPD_4508_72nd Precinct | BROOKLYN | 830 4th Ave | Police Station | 53,600 | 0.0 | 123.3 | 134.1 | 78.3 | 196.6 | 205.3 | 6607304.3 | 2057404.1 | 602990.6 | 4549900.2 | 45499.00195 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223637 | 223637 | 2021 | 21355437 | NYPD_4509_73rd Precinct | BROOKLYN | 1470 East New York Ave | Police Station | 50,020 | 0.0 | 146.0 | 155.2 | 76.8 | 237.2 | 247.0 | 7302294.1 | 2399894.8 | 703368.9 | 4902399.2 | 49023.99239 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223638 | 223638 | 2021 | 21355438 | NYPD_4510_75th Precinct | BROOKLYN | 1000 Sutter Ave | Police Station | 30,160 | 0.0 | 190.4 | 198.7 | 68.2 | 348.6 | 354.6 | 5743197.6 | 2562756.4 | 751100.8 | 3180441.2 | 31804.41247 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223639 | 223639 | 2021 | 21355439 | NYPD_4511_76th Precinct | BROOKLYN | 191 Union St | Police Station | 14,984 | 0.0 | 192.1 | 205.8 | 71.8 | 334.1 | 342.2 | 2878831.5 | 1133631.6 | 332248.4 | 1745200.0 | 17451.99997 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223640 | 223640 | 2021 | 21355440 | NYPD_4512_77th Precinct | BROOKLYN | 127 Utica Ave | Police Station | 45,102 | 0.0 | 121.6 | 126.7 | 69.2 | 219.6 | 221.9 | 5486219.5 | 2366679.2 | 693633.9 | 3119540.3 | 31195.40285 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223641 | 223641 | 2021 | 21355441 | NYPD_4513_Classified NYPD Location | Classified NYPD Location | Police Station | 12,623 | 0.0 | 183.8 | 194.1 | 63.8 | 359.9 | 370.7 | 2320638.0 | 1203830.1 | 352822.4 | 1116807.9 | 11168.07941 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223642 | 223642 | 2021 | 21355442 | NYPD_4514_78th Precinct | BROOKLYN | 65 6th Ave | Police Station | 34,500 | 0.0 | 230.7 | 251.7 | 94.3 | 305.4 | 325.0 | 7958857.3 | 1259126.3 | 369028.8 | 6119427.2 | 61194.27186 | 0.0 | 580303.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223643 | 223643 | 2021 | 21355443 | NYPD_4515_79th Precinct | BROOKLYN | 263 Tompkins Ave | Police Station | 33,540 | 0.0 | 128.1 | 135.8 | 69.9 | 228.9 | 232.4 | 4297025.1 | 1808854.1 | 530144.8 | 2488171.0 | 24881.70968 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223644 | 223644 | 2021 | 21355444 | NYPD_4516_81st Precinct | BROOKLYN | 30 Ralph Ave | Police Station | 39,700 | 0.0 | 162.8 | 171.9 | 69.9 | 291.0 | 297.1 | 6461791.4 | 2723649.4 | 798255.9 | 3738142.0 | 37381.41966 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223645 | 223645 | 2021 | 21355445 | NYPD_4517_83rd Precinct | BROOKLYN | 480 Knickerbocker Ave | Police Station | 31,729 | 0.0 | 152.5 | 162.4 | 68.1 | 279.8 | 288.0 | 4839464.6 | 2169797.3 | 635931.1 | 2669667.3 | 26696.67336 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223646 | 223646 | 2021 | 21355446 | NYPD_4518_84th Precinct | BROOKLYN | 301 Gold St | Police Station | 28,100 | 0.0 | 210.7 | 222.9 | 59.6 | 441.5 | 454.3 | 5920588.1 | 3536790.9 | 1036574.0 | 2383797.1 | 23837.97132 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223647 | 223647 | 2021 | 21355447 | NYPD_4519_88th Precinct | BROOKLYN | 298 Classon Ave | Police Station | 18,600 | 0.0 | 87.4 | 97.9 | 66.0 | 165.5 | 174.7 | 1625993.0 | 783084.0 | 229508.8 | 842909.0 | 8429.08981 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223648 | 223648 | 2021 | 21355448 | NYPD_4520_90th Precinct and Engine Company 216 | BROOKLYN | 211 Union Ave | Police Station | 39,345 | 0.0 | 179.3 | 193.5 | 64.8 | 345.3 | 360.2 | 7054814.1 | 3531125.2 | 1034913.5 | 3523688.9 | 35236.88857 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223650 | 223650 | 2021 | 21355450 | NYPD_4523_Classified NYPD Location | Classified NYPD Location | Police Station | 15,205 | 0.0 | 202.5 | 213.2 | 61.3 | 412.3 | 418.4 | 3079643.2 | 1734546.2 | 508366.3 | 1345097.1 | 13450.97087 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223651 | 223651 | 2021 | 21355451 | NYPD_4524_Classified NYPD Location | Classified NYPD Location | Police Station | 60,000 | 0.0 | 104.8 | 107.7 | 60.8 | 215.3 | 216.7 | 6286055.9 | 3609905.8 | 1058002.7 | 2676150.1 | 26761.501 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223654 | 223654 | 2021 | 21355454 | NYPD_4539_Classified NYPD Location | Classified NYPD Location | Police Station | 10,580 | 0.0 | 108.8 | 116.2 | 100.1 | 135.7 | 142.8 | 1151383.6 | 129608.6 | 37986.1 | 1021775.0 | 10217.74964 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 223655 | 223655 | 2021 | 21355455 | NYPD_4547_101st Precinct | QUEENS | 16-12 Mott Ave | Police Station | 18,680 | 0.0 | 117.6 | 125.0 | 72.2 | 203.3 | 211.1 | 2196040.0 | 852819.9 | 249947.2 | 1343220.1 | 13432.20134 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223656 | 223656 | 2021 | 21355456 | NYPD_4548_102nd Precinct | QUEENS | 87-30 118th St | Police Station | 18,225 | 0.0 | 204.1 | 213.3 | 75.8 | 336.4 | 345.0 | 3719426.1 | 1271606.0 | 372686.4 | 2447820.0 | 24478.2003 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223657 | 223657 | 2021 | 21355457 | NYPD_4549_103rd Precinct | QUEENS | 168-02 91st Ave | Police Station | 27,250 | 0.0 | 136.2 | 145.4 | 75.9 | 223.9 | 233.6 | 3710376.2 | 1260652.1 | 369476.0 | 2449724.0 | 24497.24042 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223658 | 223658 | 2021 | 21355458 | NYPD_4550_104th Precinct | QUEENS | 64-2 Catalpa Ave | Police Station | 19,075 | 0.0 | 104.6 | 113.6 | 69.2 | 188.6 | 198.1 | 1994630.6 | 858778.6 | 251693.6 | 1135852.0 | 11358.51998 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223659 | 223659 | 2021 | 21355459 | NYPD_4551_105th Precinct | QUEENS | 92-08 222nd St | Police Station | 31,500 | 0.0 | 118.6 | 123.2 | 63.2 | 234.4 | 239.3 | 3735080.9 | 1978493.9 | 579863.3 | 1756587.0 | 17565.86966 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223660 | 223660 | 2021 | 21355460 | NYPD_4552_106th Precinct | QUEENS | 103-53 101st St | Police Station | 19,044 | 0.0 | 154.0 | 161.4 | 70.0 | 274.6 | 280.8 | 2932986.4 | 1228276.3 | 359987.2 | 1704710.1 | 17047.10115 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223661 | 223661 | 2021 | 21355461 | NYPD_4554_108th Precinct | QUEENS | 5-47 50th Ave | Police Station | 15,000 | 0.0 | 264.6 | 284.2 | 77.4 | 426.7 | 441.1 | 3968325.6 | 1333966.5 | 390963.2 | 100224.0 | 1002.239971 | 0.0 | 2534135.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223662 | 223662 | 2021 | 21355462 | NYPD_4555_109th Precinct | QUEENS | 37-05 Union St | Police Station | 48,700 | 0.0 | 88.4 | 93.5 | 64.4 | 171.5 | 175.4 | 4307208.1 | 2189462.2 | 641694.6 | 2117745.9 | 21177.45886 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223663 | 223663 | 2021 | 21355463 | NYPD_4557_110th Precinct | QUEENS | 94-41 43rd Ave | Police Station | 15,300 | 0.0 | 113.5 | 120.7 | 60.8 | 233.0 | 240.6 | 1736582.6 | 995490.6 | 291761.6 | 741092.0 | 7410.91982 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223664 | 223664 | 2021 | 21355464 | NYPD_4558_111th Precinct | QUEENS | 45-06 215th St | Police Station | 23,793 | 0.0 | 115.6 | 121.8 | 64.0 | 225.7 | 232.2 | 2751259.1 | 1417945.0 | 415575.9 | 1333314.0 | 13333.14031 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223665 | 223665 | 2021 | 21355465 | NYPD_4559_112th Precinct | QUEENS | 68-40 Austin St | Police Station | 36,111 | 0.0 | 157.7 | 166.5 | 62.5 | 314.8 | 323.1 | 5693933.3 | 3079316.3 | 902495.9 | 2614617.0 | 26146.17041 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223666 | 223666 | 2021 | 21355466 | NYPD_4560_113th Precinct | QUEENS | 167-02 Baisley Blvd | Police Station | 22,250 | 0.0 | 198.1 | 207.0 | 71.8 | 344.5 | 351.9 | 4406745.5 | 1736500.5 | 508939.1 | 2670244.9 | 26702.44916 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223667 | 223667 | 2021 | 21355467 | NYPD_4561_114th Precinct | QUEENS | 34-16 Astoria Blvd | Police Station | 36,000 | 0.0 | 96.8 | 99.6 | 60.2 | 200.9 | 200.4 | 3485114.2 | 2040927.4 | 598161.5 | 1444186.8 | 14441.86769 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223668 | 223668 | 2021 | 21355468 | NYPD_4562_115th Precinct | QUEENS | 92-15 Northern Blvd | Police Station | 32,400 | 0.0 | 91.7 | 95.1 | 62.1 | 184.2 | 185.0 | 2969966.9 | 1628615.9 | 477320.0 | 1341351.0 | 13413.51008 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223672 | 223672 | 2021 | 21355472 | NYPD_4583_120th Precinct | STATEN IS | 78 Richmond Ter | Police Station | 15,540 | 0.0 | 309.3 | 339.8 | 76.1 | 507.4 | 532.9 | 4805853.8 | 1633602.8 | 478781.5 | 2688657.4 | 26886.57415 | 0.0 | 483593.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223673 | 223673 | 2021 | 21355473 | NYPD_4584_122nd Precinct | STATEN IS | 2320 Hylan Blvd | Police Station | 53,200 | 0.0 | 131.1 | 140.8 | 72.0 | 227.3 | 233.5 | 6974318.8 | 2724850.8 | 798608.0 | 4249468.0 | 42494.68045 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223726 | 223726 | 2021 | 21355526 | NYPD_5200_Flushing Armory | QUEENS | 137-58 Northern Blvd | Police Station | 35,734 | 0.0 | 82.2 | 92.2 | 76.4 | 134.4 | 143.9 | 2937406.7 | 1023812.9 | 300062.4 | 112597.0 | 1125.970037 | 0.0 | 1800996.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223759 | 223759 | 2021 | 21355559 | NYPD_9029_121st Precinct | STATEN IS | 970 Richmond Ave | Police Station | 48,797 | 0.0 | 153.4 | 156.2 | 53.1 | 360.7 | 359.4 | 7487436.2 | 5564617.2 | 1630895.8 | 1922819.0 | 19228.19019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223783 | 223783 | 2021 | 21355583 | NYPD_12046_7th Precinct (LL84) | MANHATTAN | 19-25 Pitt St | Police Station | 58,685 | 0.0 | 176.8 | 191.4 | 77.0 | 286.8 | 299.6 | 10374986.1 | 3391361.2 | 993951.0 | 6983624.9 | 69836.24856 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223830 | 223830 | 2021 | 21355630 | NYPD_4460_13th Precinct | MANHATTAN | 230 East 21st St | Police Station | 313,625 | 0.0 | 111.1 | 119.1 | 68.9 | 201.3 | 208.8 | 34829981.8 | 13286723.4 | 3894115.4 | 0.0 | 0.0 | 21543258.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 223883 | 223883 | 2021 | 21355683 | DSNY_3948_Sanitation Police Enforcement | QUEENS | 51-15 Flushing Ave | Police Station | 17,700 | 0.0 | 123.5 | 132.1 | 72.1 | 214.0 | 220.4 | 2186463.3 | 882128.7 | 258537.1 | 0.0 | 0.0 | 0.0 | 1304334.6 | 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");