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

66 rows where Calendar Year = 2019 and Property Type = "Other - Lodging/Residential" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ENERGY STAR Score, Fuel Oil #2 Use (kBtu)

Borough 4

Property Type 1

  • Other - Lodging/Residential · 66 ✖

Calendar Year 1

  • 2019 · 66 ✖
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)
159247 159247 2019 2787516 93 Jamaica Realty, LLC QUEENS 170-02 93rd Ave Other - Lodging/Residential 54,615 0.0 83.6 83.7 96.6 124.2 123.9 4563441.9 1139241.7 333892.6 3424200.1 34242.00126 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
159248 159248 2019 2787543 Willow, LLC BRONX 190 Willow Ave. Other - Lodging/Residential 54,684 0.0 128.0 128.6 80.9 227.1 226.9 7000585.5 2896105.6 848799.9 4104479.9 41044.79934 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
159249 159249 2019 2787550 Hillside Avenue Development, LLC QUEENS 160-11 89th Avenue Other - Lodging/Residential 58,625 0.0 173.1 172.0 108.4 229.2 227.7 10147298.7 1590898.9 466265.7 8556399.8 85563.99809 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
159250 159250 2019 2787552 Junius (23-25 Junius St.) Development, LLC BROOKLYN 23-25 Junius St. Other - Lodging/Residential 65,500 0.0 130.5 129.2 71.3 262.8 259.0 8545850.1 4709849.9 1380377.9 3836000.2 38360.00236 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
159251 159251 2019 2787554 Junius (1 Junius St.) Development, LLC BROOKLYN 1 JUNIUS ST Other - Lodging/Residential 65,500 0.0 131.0 129.5 71.1 264.7 260.7 8579670.7 4758270.9 1394569.3 3821399.9 38213.99861 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
159252 159252 2019 2787559 Junius Liberty Development, LLC BROOKLYN 73 Junius St. Other - Lodging/Residential 141,500 0.0 113.6 113.8 88.5 184.3 184.0 16073744.1 5260644.2 1541806.4 10813099.9 108130.9992 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
159369 159369 2019 2793060 104th Street Realty, LLC MANHATTAN 325 East 104th St. Other - Lodging/Residential 101,375 0.0 111.6 111.9 94.1 170.2 169.0 11311750.7 3070588.7 899938.0 8241162.0 82411.62034 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
160707 160707 2019 2954490 3339 Park LLC BRONX 3339 Park Avenue Other - Lodging/Residential 65,700 0.0 71.5 71.2 62.4 164.6 163.9 4697822.2 3360328.7 984855.9 1337493.5 13374.93512 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
160765 160765 2019 2961856 175-15 Rockaway Blvd. QUEENS 175-15 149 road Other - Lodging/Residential 74,477 0.0 133.9 133.4 84.9 226.4 225.1 9973649.4 3663009.0 1073566.4 5788200.0 57882.00003 0.0 522440.4 0.0 0.0 0.0 0.0 0.0 0.0 0.0
161582 161582 2019 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Other - Lodging/Residential 75,225 0.0 88.3 86.3 90.8 139.7 136.7 6645611.6 2028985.6 594661.6 4116500.2 41165.00177 0.0 500125.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0
161813 161813 2019 3187683 Jacob Shafran - 599 Ralph Ave BROOKLYN 599 Ralph Ave Other - Lodging/Residential 52,100 0.0 130.0 0.0 77.9 239.6 0.0 6770801.5 3070800.1 899999.9 3700001.4 37000.0135 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
163321 163321 2019 4039694 14 west 17tenants corp   14 west 17 th street Other - Lodging/Residential 52,000 0.0 54.4 53.8 98.6 79.2 77.9 2827953.8 656352.3 192365.8 2171601.5 21716.01517 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
163597 163597 2019 4046570 DWN MANAGEMENT INC BROOKLYN 1226 FLUSHING AVE Other - Lodging/Residential 65,402 0.0 130.8 130.1 72.3 259.8 257.5 8556100.0 4573899.7 1340533.2 3982200.3 39822.00338 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
164550 164550 2019 4409117 Beach 65, LLC QUEENS 316 BEACH 65th ST Other - Lodging/Residential 65,000 0.0 189.3 189.3 97.0 280.1 280.1 12303334.7 3020029.4 885119.9 9283305.3 92833.05311 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
165846 165846 2019 4938599 Booth Manor Condo QUEENS 63-47 Booth Street Other - Lodging/Residential 33,984 0.0 10.3 10.3 76.8 19.2 19.3 350023.6 163691.3 47975.2 186332.3 1863.322756 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
166219 166219 2019 4988475 7900 Development, LLC QUEENS 7900 Queens Boulevard Other - Lodging/Residential 92,400 0.0 126.0 125.2 93.5 193.5 190.5 11642184.8 3417163.9 1001513.3 0.0 0.0 0.0 8225020.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0
167947 167947 2019 6187161 URI / 1011 Ocean Ave   1011 Other - Lodging/Residential 36,000 0.0 29.3 29.2 57.7 72.8 72.5 1053014.9 865314.9 253609.3 187700.0 1876.999987 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
168259 168259 2019 6224653 946 East 211 St BRONX 946 East 211 St Other - Lodging/Residential 43,500 0.0 95.6 95.2 64.7 212.3 211.0 4159830.3 2780907.7 815037.3 1378922.6 13789.22608 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
168600 168600 2019 6249896 Concourse House BRONX 2751 Grand Concourse Other - Lodging/Residential 42,288 0.0 126.0 125.4 84.9 172.8 171.5 5329488.3 977569.3 286509.1 4351919.0 43519.18953 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
168745 168745 2019 6261005 54 Orchard LLC. MANHATTAN 54 Orchard Street Other - Lodging/Residential 33,860 0.0 58.1 57.5 87.2 95.7 94.1 1967636.3 670150.0 196409.7 1297486.3 12974.86252 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
168972 168972 2019 6271302 1564 Development, LLC BRONX 1564 St Peters Avenue Other - Lodging/Residential 34,595 0.0 126.8 125.2 94.5 192.7 188.5 4387806.6 1176046.7 344679.5 3211759.9 32117.59869 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170074 170074 2019 6291814 Krinos Properties MANHATTAN 143 Franklin Street Other - Lodging/Residential 33,800 0.0 41.9 0.0 33.9 110.5 0.0 1416975.8 1283892.4 376287.3 133083.3 1330.833364 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170339 170339 2019 6294272 DHS - 3045367 - Pamoja House Shelter (LL84)   Classified Other - Lodging/Residential 235,200 91.0 62.6 63.1 91.0 76.1 76.6 14724730.5 1673381.3 490439.9 598671.0 5986.709844 0.0 12452678.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170387 170387 2019 6294336 DHS - 1076737 - Harlem 1 Mens Shelter (LL84)   Classified Other - Lodging/Residential 41,446 0.0 237.4 240.0 102.5 332.3 334.7 9837455.7 2143486.6 628219.9 6279.0 62.79000107 0.0 7687690.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170394 170394 2019 6294343 DHS - 1008425 - SCCW Central Shelter (LL84) (Out of service)   Classified Other - Lodging/Residential 14,925 0.0 0.0 0.0 63.6 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
170409 170409 2019 6294358 DHS - 3073772 - Stockholm Street Family Residence (LL84)   Classified Other - Lodging/Residential 34,800 0.0 152.5 153.4 111.0 197.2 198.2 5306041.8 738381.8 216407.3 4567660.1 45676.60061 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
171062 171062 2019 6297442 DHS - c071001 - Jennie A. Clarke Residence Campus (LL84)   Classified Other - Lodging/Residential 31,035 0.0 270.3 268.1 99.7 389.4 382.6 8389449.1 1871407.4 548478.1 6518041.7 65180.41734 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
171063 171063 2019 6297443 DHS - c071003 - Rose McCarthy Family Residence Campus (LL84)   Classified Other - Lodging/Residential 39,600 0.0 113.2 113.0 106.3 152.8 152.4 4481635.2 769183.2 225434.7 3712452.1 37124.52065 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
171111 171111 2019 6297497 DHS - c071004 - Barbara Kleinman Residence Campus (LL84)   Classified Other - Lodging/Residential 134,508 0.0 31.7 31.6 71.9 63.3 62.8 4264917.6 2308388.6 676549.9 1956529.0 19565.29048 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
171793 171793 2019 6319733 Haven Apartments BRONX 2145 Southern Blvd. Other - Lodging/Residential 37,100 0.0 88.8 89.6 85.9 148.4 149.1 3294340.1 1169915.1 342882.5 2124425.0 21244.2502 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
171794 171794 2019 6319929 Hunter Apartments BRONX 806 Fairmont Place Other - Lodging/Residential 40,710 0.0 80.3 80.2 87.8 131.4 131.3 3270319.0 1094562.2 320797.8 2175756.8 21757.56775 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
172454 172454 2019 6429656 3600 Jerome LLC BRONX 3600 Jerome Avenue Other - Lodging/Residential 79,275 0.0 60.7 60.5 68.8 126.6 126.1 4810218.7 2892377.5 847707.3 0.0 0.0 0.0 1917841.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0
173422 173422 2019 6618686 4747 Bronx Boulevard Realty, LLC BRONX 4747 Bronx Boulevard Other - Lodging/Residential 43,700 0.0 0.0 0.0 63.6 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
174406 174406 2019 6675610 500 East 134th Owners, LLC BRONX 500 East 134th Street Other - Lodging/Residential 41,080 0.0 90.3 90.3 76.3 169.9 169.9 3708779.7 1762659.7 516606.0 1946120.0 19461.19974 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
174407 174407 2019 6675611 CAPRI WHITESTONE LLC   555 Hutchinson Riiver Parkway Other - Lodging/Residential 33,320 0.0 158.1 157.5 75.2 301.8 300.1 5267465.2 2645465.4 775341.5 0.0 0.0 0.0 2621999.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0
174408 174408 2019 6675619 Westway Associates, LLC QUEENS 71-11 Astoria Boulevard N Other - Lodging/Residential 38,160 0.0 203.4 203.9 103.4 282.6 281.2 7763120.6 1644311.0 481919.9 0.0 0.0 0.0 6118809.6 0.0 0.0 0.0 0.0 0.0 0.0 0.0
174487 174487 2019 6679816 Broadway Bronx Motel Company BRONX 2244 Tillotson Avenue Other - Lodging/Residential 41,952 0.0 137.4 137.9 99.2 198.7 199.3 5762804.2 1305956.6 382754.0 4456847.6 44568.47584 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
175237 175237 2019 6693138 141 West 144th Street Realty Corp. MANHATTAN 141 West 144th Street Other - Lodging/Residential 26,574 0.0 308.3 307.3 121.7 363.6 362.1 8191773.6 775115.4 227173.3 7093.3 70.93333308 0.0 7409564.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0
175238 175238 2019 6693144 Emmons Development, LLC BROOKLYN 3154 Emmons Avenue Other - Lodging/Residential 32,009 0.0 165.3 164.8 69.9 339.6 338.6 5291297.4 3035997.5 889799.9 2255299.9 22552.9989 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
175239 175239 2019 6693147 745 East 178 LLC BRONX 745 East 178th Street Other - Lodging/Residential 26,200 0.0 200.6 202.4 121.4 237.2 239.1 5255910.1 506915.7 148568.5 0.0 0.0 0.0 4748994.4 0.0 0.0 0.0 0.0 0.0 0.0 0.0
175240 175240 2019 6693153 Putnam Equities, LLC BROOKLYN 1149 Putnam Avenue Other - Lodging/Residential 36,000 0.0 138.9 138.4 114.7 173.9 173.0 5001727.4 575727.2 168736.0 4426000.2 44260.00182 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
175241 175241 2019 6693159 321 East Tremont, LLC BRONX 321 East Tremont Avenue Other - Lodging/Residential 25,440 0.0 109.8 108.0 75.8 207.9 203.4 2792392.0 1347492.0 394927.3 1444900.0 14449.00025 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
175852 175852 2019 6701567 1387 Realty, LLC BRONX 1387 Grand Concourse Other - Lodging/Residential 33,420 0.0 173.8 174.8 116.8 213.7 214.7 5808197.0 595618.2 174565.7 5212578.8 52125.78752 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
175971 175971 2019 6703687 111 west 24th street associates MANHATTAN 109 west 24th Street Other - Lodging/Residential 38,000 0.0 33.3 32.5 111.4 42.9 42.1 1265005.9 196665.1 57639.2 0.0 0.0 0.0 1068340.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0
176119 176119 2019 6722905 The Salvation Army BROOKLYN 62 Hanson Place Other - Lodging/Residential 23,700 0.0 233.5 233.4 84.3 397.5 398.4 5533731.9 2063685.1 604831.4 3470046.8 34700.46815 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
176776 176776 2019 6788817 Ryer Avenue Housing Development Fund Corporation BRONX 2386 Ryer Avenue Other - Lodging/Residential 34,910 0.0 121.1 120.7 104.4 166.5 165.3 4228143.1 785226.7 230136.8 3442916.4 34429.16384 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
177103 177103 2019 6795412 New Syndicate LLC MANHATTAN 316 West 97th Street Other - Lodging/Residential 32,046 0.0 159.9 158.9 103.5 221.8 219.6 5124203.8 987540.3 289431.5 4136663.5 41366.63505 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
177143 177143 2019 6797457 249 Varet LLC BROOKLYN 249 Varet Street Other - Lodging/Residential 26,400 0.0 78.2 78.9 82.2 136.7 137.3 2065258.5 822358.5 241019.5 1242900.0 12428.99996 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
178085 178085 2019 6818188 Baychester Building 12 BRONX 1220 East 229th Street Other - Lodging/Residential 20,700 0.0 42.1 42.3 63.9 94.6 94.8 872027.2 595669.1 174580.6 276358.0 2763.580449 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
178580 178580 2019 6897863 286 Audubon Holdings, LLC MANHATTAN 286 Audubon Avenue Other - Lodging/Residential 29,460 0.0 7.8 7.8 51.3 21.9 21.9 230089.9 230089.9 67435.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
178608 178608 2019 6932877 West Canyon, LLC QUEENS 132-10 South Conduit Ave., Queens Other - Lodging/Residential 29,000 0.0 171.3 171.2 95.1 258.8 258.7 4968312.6 1307212.5 383122.0 3661100.1 36611.00104 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
178821 178821 2019 7084774 2170 Prospect Avenue LLC BRONX 2170 Prospect Avenue Other - Lodging/Residential 36,699 0.0 115.5 116.1 100.9 164.2 164.9 4237857.8 901441.8 264197.5 3336416.0 33364.1597 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
179353 179353 2019 7538585 Teams Housing Development Fund Company Inc. MANHATTAN 175 WEST 137 STREET Other - Lodging/Residential 26,250 0.0 78.5 78.4 70.2 160.6 160.4 2061278.0 1171678.0 343399.1 889600.0 8895.999946 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
179380 179380 2019 7557199 Vuksan Realty, LLC BRONX 65 East 190th Street Other - Lodging/Residential 47,373 0.0 91.8 91.5 108.6 121.3 120.4 4348774.8 750589.1 219985.0 312681.8 3126.818239 0.0 3285503.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0
179552 179552 2019 8000007 1171 WASHINGTON AVENUE BRONX 1171 WASHINGTON AVENUE Other - Lodging/Residential 31,140 0.0 109.2 108.9 111.7 140.3 140.0 3399083.6 456770.8 133871.9 2942312.8 29423.12805 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
179591 179591 2019 8151625 163-03 89 Avenue QUEENS 163-03 89 Avenue Other - Lodging/Residential 39,000 0.0 106.3 106.2 111.7 136.6 136.4 4144808.8 632773.4 185455.3 246500.0 2465.000201 0.0 3265535.4 0.0 0.0 0.0 0.0 0.0 0.0 0.0
179728 179728 2019 8468900 Sammon Build Inc BRONX 2294-96 Grand Avenue Other - Lodging/Residential 37,800 0.0 94.4 94.7 110.1 123.1 123.1 3567876.1 518109.2 151849.1 3049766.9 30497.66856 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
179975 179975 2019 8720174 S and Z Associates, LLC QUEENS 87-02 23rd Avenue Other - Lodging/Residential 38,260 0.0 150.0 150.5 96.1 224.1 222.4 5740118.1 1455518.3 426588.0 4284599.8 42845.99786 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
180048 180048 2019 9005616 Our Lady of Mt Carmel - Rectory BRONX 627 East 187th Street Other - Lodging/Residential 5,612 0.0 0.0 0.0 63.6 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
181715 181715 2019 10829269 127-03 20th Avenue LLC QUEENS 127-03 20th Avenue Other - Lodging/Residential 42,208 0.0 47.4 47.7 73.5 92.5 92.8 1998857.1 1031030.4 302177.7 967826.7 9678.266799 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
181830 181830 2019 10860159 The 531 52nd St condo HAO Ass BROOKLYN 531 52nd St Other - Lodging/Residential 33,779 0.0 4.0 0.0 53.0 10.9 0.0 100684.6 95386.7 27956.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
182379 182379 2019 11646402 DOE Fund - 223 E 117th Street MANHATTAN 223 East 117th Street Other - Lodging/Residential 34,050 0.0 98.0 99.0 95.9 146.7 147.6 3338444.9 851504.9 249561.8 2486940.0 24869.39996 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
182404 182404 2019 11662745 691 East 140 LLC BRONX 691 East 140 Street Other - Lodging/Residential 25,247 0.0 82.4 83.2 99.4 119.1 119.9 2080568.2 469228.1 137522.9 1611340.0 16113.40046 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
182447 182447 2019 11705741 Audubon MANHATTAN 286 Audubon Ave Other - Lodging/Residential 29,460 0.0 6.3 6.3 51.3 17.7 17.7 186143.8 185943.8 54497.0 200.0 2.00000003 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
183319 183319 2019 12425849 King Levkov Condo Association Corp BROOKLYN 1661 E 19TH ST Other - Lodging/Residential 28,540 0.0 35.7 35.4 88.4 58.1 57.3 1019756.7 334956.7 98170.2 684800.0 6848.000231 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
183573 183573 2019 12881549 NAICA / 1527 SOUTHERN FEE OWNER LLC BRONX 1521 Southern BLVD. Other - Lodging/Residential 35,000 0.0 50.5 53.0 78.2 92.8 95.4 1769024.0 794883.4 232967.0 974140.6 9741.40622 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");