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

56 rows where Calendar Year = 2019 and Property Type = "Fire Station" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: District Steam Use (kBtu)

Borough 5

Property Type 1

  • Fire Station · 56 ✖

Calendar Year 1

  • 2019 · 56 ✖
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)
170503 170503 2019 6294459 FDNY - 1075504 - Engine Co. 80 and Ladder Co. 23 (LL84) MANHATTAN 503 West 139th St Fire Station 10,667 0.0 154.4 153.3 81.3 237.2 234.8 1647055.9 457753.9 134160.0 1189302.0 11893.02001 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170504 170504 2019 6294460 FDNY - 1062872 - Engine Co. 84 and Ladder Co. 34 (LL84) MANHATTAN 513 West 161st St Fire Station 11,792 0.0 88.0 87.7 68.6 160.1 159.3 1037849.3 456215.3 133709.0 581634.0 5816.340014 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170505 170505 2019 6294462 FDNY - 1052473 - Engine Co. 91 (LL84) MANHATTAN 242 East 111th St Fire Station 12,298 0.0 141.6 137.5 85.2 207.6 203.3 1740822.8 414135.8 121376.2 1326687.0 13266.86988 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170506 170506 2019 6294463 FDNY - 1075518 - Engine Co. 93, Ladder Co. 45 and Batt. 13 (LL84) MANHATTAN 515 West 181st St Fire Station 21,883 0.0 90.9 90.0 74.2 152.9 150.7 1989543.9 718754.9 210655.0 1270789.0 12707.89037 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170508 170508 2019 6294466 FDNY - 1007523 - Ladder Co. 20 and Medical and BFI Division (LL84) MANHATTAN 251 Lafayette St Fire Station 28,866 0.0 120.7 117.9 63.5 237.5 230.0 3483510.9 1826656.9 535362.5 1656854.0 16568.54015 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170509 170509 2019 6294467 FDNY - 1030885 - Ladder Co. 25 and Division 3 (LL84) MANHATTAN 205 West 77th St Fire Station 13,300 0.0 151.8 150.4 74.7 253.9 251.9 2018795.3 718004.3 210435.0 1300791.0 13007.90993 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170701 170701 2019 6296806 FDNY - 1015173 - Engine Co. 1 and Ladder Co. 24 (LL84) MANHATTAN 142 West 31st St Fire Station 11,326 0.0 158.2 157.8 75.2 262.7 262.0 1792032.6 625257.5 183252.5 1166775.0 11667.75039 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170702 170702 2019 6296816 FDNY - 1014723 - Engine Co. 3 at Ladder Co. 12, Batt. 7 (LL84) MANHATTAN 146 West 19th St Fire Station 17,586 0.0 75.6 75.4 75.1 125.7 125.5 1329263.3 465533.4 136440.0 863730.0 8637.299879 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170703 170703 2019 6296817 FDNY - 1008526 - Engine Co. 33 and Ladder Co. 9 (LL84) MANHATTAN 42 Great Jones St Fire Station 12,649 0.0 142.6 140.7 78.8 226.0 223.7 1803495.3 551460.3 161623.7 1252035.0 12520.34956 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170704 170704 2019 6296819 FDNY - 1054465 - Engine Co. 35 and Ladder Co. 14, Batt. 12 (LL84) MANHATTAN 2282 3rd Ave Fire Station 10,900 0.0 157.6 156.4 73.0 269.5 267.4 1718206.6 647597.6 189800.0 1070609.0 10706.08988 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170705 170705 2019 6296820 FDNY - 1059547 - Engine Co. 37 and Ladder Co. 40 (LL84) MANHATTAN 415 West 125th St Fire Station 11,778 0.0 148.1 146.0 75.4 245.2 241.0 1744008.5 604060.5 177040.0 1139948.0 11399.48017 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170706 170706 2019 6296821 FDNY - c000001 - Eng.39, Lad.16, Pct.19 Campus (LL84) MANHATTAN 153 East 67th St Fire Station 37,286 0.0 208.1 210.0 56.6 328.4 330.7 7758729.0 1831986.0 536924.3 109217.0 1092.170033 5817526.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170707 170707 2019 6296828 FDNY - 1080501 - Engine Co. 58 and Ladder Co. 26 (LL84) MANHATTAN 1367 5th Ave Fire Station 12,000 0.0 97.9 96.8 72.5 168.6 166.0 1174619.8 451475.8 132320.0 723144.0 7231.440221 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170708 170708 2019 6296833 FDNY - 1075491 - Engine Co. 69 and Ladder Co. 28, Batt. 16 (LL84) MANHATTAN 248 West 143rd St Fire Station 11,250 0.0 100.6 100.3 56.7 221.5 220.5 1132130.9 744361.9 218160.0 387769.0 3877.690134 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170709 170709 2019 6296834 FDNY - 1001647 - Engine Co. 7 at Ladder Co. 1, Batt. 1 (LL84) MANHATTAN 100 Duane St Fire Station 19,381 0.0 108.9 107.7 74.2 183.4 181.7 2111435.5 764377.5 224026.2 1347058.0 13470.58032 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170711 170711 2019 6296845 FDNY - 2013192 - Engine Co. 45 and Ladder Co. 58, Batt. 18 (LL84) BRONX 925 East Tremont Ave Fire Station 15,225 0.0 103.2 101.4 71.4 180.5 177.0 1571032.6 627897.5 184026.2 943135.0 9431.350429 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170712 170712 2019 6296847 FDNY - 2011061 - Engine Co. 48 and Ladder Co. 56, Division 7 (LL84) BRONX 2417 Webster Ave Fire Station 17,242 0.0 72.9 72.1 65.7 138.6 136.5 1256123.6 611562.6 179238.7 644561.0 6445.609687 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170713 170713 2019 6296848 FDNY - 2001584 - Engine Co. 50 and Ladder Co. 19, Batt. 26 (LL84) BRONX 1155 Washington Ave Fire Station 13,500 0.0 114.7 112.4 69.2 206.8 201.8 1547811.4 666295.3 195280.0 881516.0 8815.160413 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170714 170714 2019 6296850 FDNY - 2000656 - Engine Co. 60 and Ladder Co. 17, Batt. 14 (LL84) BRONX 341 East 143rd St Fire Station 11,250 0.0 141.3 140.7 73.0 241.5 240.5 1589193.7 599051.7 175572.0 990142.0 9901.419851 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170715 170715 2019 6296854 FDNY - 2003268 - Engine Co. 68 and Ladder 49 (LL84) BRONX 1160 Ogden Ave Fire Station 10,220 0.0 53.1 52.4 44.6 148.6 146.8 542243.5 542243.5 158922.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170716 170716 2019 6296856 FDNY - 2001400 - Engine Co. 71 and Ladder Co. 55, Division 6 (LL84) BRONX 720 Melrose Ave Fire Station 14,416 0.0 139.0 137.8 78.0 222.6 219.9 2003611.1 631527.1 185090.0 1372084.0 13720.84017 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170717 170717 2019 6296858 FDNY - 2117539 - Engine Co. 73 and Ladder Co. 42 (LL84) BRONX 665 Prospect Ave Fire Station 15,170 0.0 125.5 124.2 69.5 225.4 222.2 1903460.4 811531.4 237846.2 1091929.0 10919.28976 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170718 170718 2019 6296859 FDNY - 2118039 - Engine Co. 75 and Ladder Co. 33, Batt. 19 (LL84) BRONX 2175 Walton Ave Fire Station 12,541 0.0 99.3 98.7 73.0 169.9 168.9 1245812.1 470037.2 137760.0 775775.0 7757.749874 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170719 170719 2019 6296864 FDNY - 2086781 - Engine Co. 88 and Ladder Co. 38 (LL84) BRONX 2225 Belmont Ave Fire Station 12,600 0.0 121.0 119.4 82.6 182.9 181.0 1524514.3 402476.3 117959.1 1122038.0 11220.37994 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170720 170720 2019 6296866 FDNY - 2043470 - Engine Co. 90 and Ladder Co. 41 (LL84) BRONX 1843 White Plains Rd Fire Station 12,520 0.0 120.4 119.0 75.2 199.8 197.9 1507342.5 525183.5 153922.5 982159.0 9821.589805 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170721 170721 2019 6296867 FDNY - 2096490 - Engine Co. 92 and Ladder Co. 44, Batt. 17 (LL84) BRONX 1259 Morris Ave Fire Station 10,623 0.0 182.9 180.6 70.8 322.4 318.0 1943151.4 791285.4 231912.5 1151866.0 11518.65972 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170725 170725 2019 6296877 FDNY - 3414000 - Engine Co. 201 and Ladder 114, Batt. 40 (LL84) BROOKLYN 5113 4th Ave Fire Station 17,772 0.0 94.4 93.4 73.5 160.4 157.5 1677902.9 621802.9 182240.0 1056100.0 10560.99993 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170726 170726 2019 6296880 FDNY - 3070506 - Engine Co. 206 (LL84) BROOKLYN 1201 Grand St Fire Station 10,180 0.0 120.2 117.4 75.1 199.9 193.9 1223617.2 428931.1 125712.5 794686.0 7946.86023 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170727 170727 2019 6296882 FDNY - 3060298 - Engine Co. 211 and Ladder Co. 119 (LL84) BROOKLYN 26 Hooper St Fire Station 28,285 0.0 151.4 150.9 90.8 208.1 207.2 4282917.2 794509.2 232857.3 3488408.0 34884.08026 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170728 170728 2019 6296885 FDNY - 3027813 - Engine Co. 219 and Ladder Co. 105 (LL84) BROOKLYN 492 Dean St Fire Station 10,300 0.0 139.9 138.4 72.9 239.4 237.3 1440627.1 544811.1 159675.0 895816.0 8958.159958 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170729 170729 2019 6296892 FDNY - 3067898 - Engine Co. 229 and Ladder Co. 146 (LL84) BROOKLYN 75 Richardson St Fire Station 13,500 0.0 87.2 85.6 69.0 157.9 154.7 1177352.2 511858.2 150017.0 665494.0 6654.940024 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170730 170730 2019 6296894 FDNY - 3040990 - Engine Co. 233 and Ladder Co. 176 (LL84) BROOKLYN 25 Rockaway Ave Fire Station 13,519 0.0 111.2 109.1 68.1 204.0 199.6 1503186.2 674211.2 197600.0 828975.0 8289.750257 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170731 170731 2019 6296895 FDNY - 3037055 - Engine Co. 234 and Ladder Co. 123, Batt. 38 (LL84) BROOKLYN 1352 St. John's Pl Fire Station 10,355 0.0 143.7 141.1 73.1 245.2 239.4 1487645.4 558591.4 163713.7 929054.0 9290.539934 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170732 170732 2019 6296898 FDNY - 3064786 - Engine Co. 238 and Ladder Co. 106 (LL84) BROOKLYN 205 Greenpoint Ave Fire Station 10,262 0.0 134.4 132.7 72.3 232.1 229.8 1379245.9 533363.9 156320.0 845882.0 8458.820037 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170733 170733 2019 6296911 FDNY - 3074885 - Engine Co. 271 and Ladder Co. 124, Batt. 28 (LL84) BROOKLYN 392 Himrod St Fire Station 13,108 0.0 177.2 178.1 88.9 249.0 249.6 2322858.6 471158.8 138088.7 1851699.8 18516.99824 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170734 170734 2019 6296912 FDNY - 3182420 - Engine Co. 276 and Ladder Co. 156, Batt. 33 (LL84) BROOKLYN 1635 East 14th St Fire Station 10,227 0.0 126.1 124.6 72.9 215.9 214.3 1289743.8 488154.8 143070.0 801589.0 8015.890062 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170735 170735 2019 6296913 FDNY - 3076461 - Engine Co. 277 and Ladder Co. 112 (LL84) BROOKLYN 582 Knickerbocker Ave Fire Station 15,000 0.0 157.3 157.0 69.8 281.3 280.9 2360238.7 995237.7 291687.5 1365001.0 13650.00974 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170736 170736 2019 6296914 FDNY - 3008207 - Engine Co. 279 and Ladder Co. 131 (LL84) BROOKLYN 252 Lorraine St Fire Station 10,548 0.0 167.5 170.9 73.8 283.5 285.6 1766957.9 648825.9 190160.0 1118132.0 11181.31997 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170737 170737 2019 6296916 FDNY - 3118638 - Engine Co. 281 and Ladder Co. 147 (LL84) BROOKLYN 1210 Cortelyou Rd Fire Station 10,106 0.0 113.4 114.0 74.5 190.1 189.7 1145516.9 410290.9 120249.4 735226.0 7352.260096 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170738 170738 2019 6296917 FDNY - 3135859 - Engine Co. 282 and Ladder Co. 148 (LL84) BROOKLYN 4210 12th Ave Fire Station 13,756 0.0 93.1 93.6 70.4 165.2 164.0 1280887.9 529678.9 155240.0 751209.0 7512.090102 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170739 170739 2019 6296918 FDNY - 3081953 - Engine Co. 283 and Division 15 (LL84) BROOKLYN 885 Howard Ave Fire Station 11,898 0.0 121.9 120.3 72.0 211.5 209.7 1450524.3 567620.3 166360.0 882904.0 8829.040436 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170740 170740 2019 6296919 FDNY - 3161800 - Engine Co. 284 and Ladder Co. 149 (LL84) BROOKLYN 1157 79th St Fire Station 10,350 0.0 146.5 149.4 85.0 215.3 217.4 1515940.1 363557.1 106552.5 1152383.0 11523.83024 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170741 170741 2019 6296926 FDNY - 3083579 - Engine Co. 332 and Ladder Co. 175 (LL84) BROOKLYN 165 Bradford St Fire Station 11,300 0.0 166.5 164.4 76.3 272.7 270.3 1881769.0 631800.0 185170.0 1249969.0 12499.69014 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170754 170754 2019 6296949 FDNY - 4000333 - Engine Co 258 and Ladder Co. 115 (LL84) QUEENS 10-40 47th Ave Fire Station 13,500 0.0 113.4 112.9 85.4 165.7 165.1 1530365.5 360392.5 105625.0 1169973.0 11699.73008 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170755 170755 2019 6296951 FDNY - 4003673 - Engine Co. 259 and Ladder Co. 128, Batt. 45 (LL84) QUEENS 33-51 Greenpoint Ave Fire Station 15,790 0.0 147.3 146.9 75.6 243.2 242.8 2325405.7 798885.7 234140.0 1526520.0 15265.19964 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170756 170756 2019 6296954 FDNY - 4529057 - Engine Co. 264 and Ladder Co. 134, Engine Co. 328 (LL84) QUEENS 16-17 Central Ave Fire Station 16,550 0.0 122.6 120.1 73.3 208.9 206.2 2028971.9 758245.9 222229.1 1270726.0 12707.25997 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170757 170757 2019 6296955 FDNY - 4302052 - Engine Co. 265 and Ladder 121, Batt. 47, EMS 47 (LL84) QUEENS 303 Beach 49th St Fire Station 19,958 0.0 161.4 158.2 77.8 259.1 255.0 3220453.8 1022828.9 299774.0 2197625.0 21976.24968 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170758 170758 2019 6296956 FDNY - 4439014 - 100th Precinct Campus: Engine Co. 266 (LL84) QUEENS 92-20 Rockaway Beach Blvd Fire Station 11,960 0.0 110.4 109.4 104.9 131.4 130.1 1320178.0 106208.0 31127.8 1213970.0 12139.70031 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170759 170759 2019 6296957 FDNY - 4304442 - Engine Co. 268 and Ladder Co. 137 (LL84) QUEENS 257 Beach 116th St Fire Station 10,089 0.0 131.7 131.1 82.4 199.5 198.9 1328743.6 352862.6 103418.1 975881.0 9758.810164 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170760 170760 2019 6296961 FDNY - 4189682 - Engine Co. 285 and Ladder Co. 142 (LL84) QUEENS 103-19 98th St Fire Station 10,112 0.0 139.2 135.2 77.9 223.0 218.1 1407333.6 444293.6 130215.0 963040.0 9630.400236 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170761 170761 2019 6296973 FDNY - 4222434 - Engine Co. 301 and Ladder Co. 150 (LL84) QUEENS 91-02 197th St Fire Station 10,000 0.0 111.5 109.6 68.9 202.2 198.6 1115281.0 486242.1 142509.4 629038.9 6290.38946 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170765 170765 2019 6297000 FDNY - 5041882 - Engine Co. 154 Communications Garage (LL84) STATEN IS 3730 Victory Blvd Fire Station 10,738 0.0 115.8 118.0 71.5 202.4 204.7 1243766.3 495678.3 145275.0 748088.0 7480.880263 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170766 170766 2019 6297010 FDNY - 5046179 - Engine Co. 160 and Rescue 5, Division 8 (LL84) STATEN IS 1850 Clove Rd Fire Station 13,200 0.0 101.1 101.9 69.4 182.1 182.1 1334802.4 572432.5 167770.3 762370.0 7623.699786 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170767 170767 2019 6297020 FDNY - 5154879 - Engine Co. 168 (LL84) STATEN IS 1100 Rossville Ave Fire Station 19,610 0.0 73.1 74.0 66.9 136.5 136.3 1434367.5 668453.5 195912.5 765914.0 7659.140209 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
183052 183052 2019 12344421 BBL 3-00819-0001: FDNY, EDC (LL84) BROOKLYN 5600 1st Ave Fire Station 321,478 0.0 3.9 4.0 65.0 7.5 7.5 1262665.0 628777.1 184284.0 633888.0 6338.879715 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
183240 183240 2019 12344696 BBL 5-07067-0252: FDNY (LL84) STATEN IS 1100 Rossville Ave Fire Station 39,220 0.0 36.6 36.9 66.9 68.2 67.8 1434367.5 668453.5 195912.5 765914.0 7659.140209 0.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

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