home / nyc_ll84

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

80 rows where Borough = "STATEN IS" and Property Type = "Other" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

These facets timed out: Property Type

Calendar Year 15

  • 2017 12
  • 2013 10
  • 2014 10
  • 2015 10
  • 2016 7
  • 2018 6
  • 2023 5
  • 2012 4
  • 2021 4
  • 2022 4
  • 2010 2
  • 2011 2
  • 2024 2
  • 2019 1
  • 2020 1

Borough 1

  • STATEN IS · 80 ✖
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)
328840 328840 2024 21355527 DOT_5251_Port Ivory STATEN IS 3511 Richmond Ter Other 4,032 0.0 112.4 120.5 31.9 314.8 337.5 453340.2 453340.2 132866.4 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
330642 330642 2024 26656543 ACS_9375_Staten Island Residential Center STATEN IS 1133 Forest Hill Rd Other 10,000 0.0 229.7 243.7 53.2 385.4 400.1 2296840.5 823929.6 241479.9 1472910.9 14729.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
287468 287468 2023 30772134 EWC Property Management : 100 COLFAX AVENUE STATEN IS 100 COLFAX AVENUE, Staten Island, NY , 10306 Other 144,100 0.0 13.7 14.8 49.2 24.9 25.8 1980177.2 863577.2 253100.0 1116600.0 11166.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
291903 291903 2023 18031365 Ideal Paradise LLC STATEN IS 191 Edgewater Street Other 122,250 0.0 0.0 0.0 34.6 0.1 0.1 3171.4 3171.4 929.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
295457 295457 2023 21355527 DOT_5251_Port Ivory STATEN IS 3511 Richmond Ter Other 12,960 0.0 32.7 38.1 31.9 91.7 106.7 424282.3 424282.3 124350.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
297105 297105 2023 25963858 Lighthouse Point - Phase 2 STATEN IS 5 Bay St. Other 34,941 0.0 0.0 0.0 40.1 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
298274 298274 2023 30555256 ISLAND CONDO : 75 PUTNAM STREET STATEN IS 75 PUTNAM STREET Other 31,455 0.0 47.6 47.0 44.8 94.9 93.2 1496553.1 807603.1 236694.9 688950.0 6889.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
247198 247198 2022 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82,500 0.0 23.6 24.7 50.6 41.7 42.8 1946151.5 795951.4 233280.0 1150200.1   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
255142 255142 2022 25963858 Lighthouse Point - Phase 2 STATEN IS 5 Bay St. Other 34,941 0.0 0.0 0.0 40.1 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
271345 271345 2022 21355527 DOT_5251_Port Ivory STATEN IS 3511 Richmond Ter Other 12,960 0.0 37.8 39.1 31.9 105.8 109.4 489530.9 489530.9 143473.3 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
271588 271588 2022 25963858 Lighthouse Point - Phase 2 STATEN IS 5 Bay St. Other 34,941 0.0 0.0 0.0 40.1 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
213937 213937 2021 21968221 The Brielle - Cottage STATEN IS 105 Friendship Lane Other 5,000 0.0 224.6 240.6 51.1 392.1 408.9 1122867.9 446426.1 130840.0 676441.8 6764.418321 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
213938 213938 2021 21968227 The Commons at The Brielle STATEN IS 145 Friendship Lane Other 25,000 0.0 35.4 39.6 62.9 50.2 55.9 884418.6 186841.1 54760.0 697577.4 6975.774381 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223727 223727 2021 21355527 DOT_5251_Port Ivory STATEN IS 3511 Richmond Ter Other 12,960 0.0 40.0 43.1 31.9 112.1 120.6 518851.0 518851.0 152066.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
235331 235331 2021 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82,500 0.0 23.8 26.5 50.9 41.8 44.5 1967504.1 789982.6 231530.6 1177521.5 11775.21484 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
188552 188552 2020 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82500 0.0 14.1 16.8 43.2 29.1 31.9 1159220.0 674675.2 197736.0 484544.8 4845.448057 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
160159 160159 2019 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82,500 0.0 24.3 24.9 52.2 41.5 42.1 2004476.3 755007.4 221280.0 1249468.9 12494.68924 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
134833 134833 2018 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82,500 0.0 21.5 21.7 47.8 40.1 40.3 1774345.7 828092.5 242700.0 946253.3   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
137481 137481 2018 3555072 Carmel Richmond HC & RC STATEN IS 88 Old Town Rd Other 170,000 8.0 178.6 180.9 122.5 304.6 306.5 30362122.0 11375387.6 3333935.0 18986734.4   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
143526 143526 2018 6237908 2025 Richmond Ave STATEN IS 2025 Richmond Ave Other 30,840 5.0 87.1 87.1 40.4 224.6 224.2 2687001.2 2345911.8 687547.3 341089.4   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
143527 143527 2018 6237909 150 Greaves STATEN IS 150 Greaves Lane Other 25,800 0.0 143.5 144.1 90.7 362.0 362.0 3702490.6 3115431.6 913080.7 587059.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
151969 151969 2018 6784634 Shops at the Garden STATEN IS 1130 South Avenue Other 38,000 0.0 65.2 66.6 39.4 147.7 150.0 2478989.5 1720789.4 504334.5 758200.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
153788 153788 2018 6825859 181 edgewater llc STATEN IS 181 edgewater st Other 33,000 0.0 0.0 0.0 40.1 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
94846 94846 2017 2,811,156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82,500   20.0 21.0 52.2 47.1 48.2 1.0 1.0 302.0 618.0                   0.0
98602 98602 2017 2,816,955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 210,598   2.5 2.5 39.2 7.9 7.8 530.0 530.0 155.0                     0.0
99550 99550 2017 3,231,354 4343 Amboy Rd. STATEN IS 4343 Amboy Rd. Other 62,092 6.0 261.8 267.3 135.9 435.5 440.5 16.0 4.0 1.0 11.0                   0.0
99567 99567 2017 3,325,368 LA Fitness STATEN IS 145 East Service Rd. Other 51,609   98.6 101.1 44.3 215.6 217.4 5.0 2.0 810.0 2.0                   0.0
101215 101215 2017 3,555,072 Carmel Richmond HC & RC STATEN IS 88 Old Town Rd Other 170,000 7.0 172.9 178.3 119.1 320.2 324.5 29.0 11.0 3.0 18.0                   0.0
101216 101216 2017 3,555,072 Carmel Richmond HC & RC STATEN IS 88 Old Town Rd Other 170,000 7.0 172.9 178.3 119.1 320.2 324.5 29.0 11.0 3.0 18.0                   0.0
108516 108516 2017 6,237,908 2025 Richmond Ave STATEN IS 2025 Richmond Ave Other 30,840 12.0 87.0 87.9 54.9 252.8 252.5 2.0 2.0 698.0 302.0                   0.0
108517 108517 2017 6,237,909 150 Greaves STATEN IS 150 Greaves Lane Other 25,800   145.7 147.0 84.4 410.1 409.2 3.0 3.0 930.0 587.0                   0.0
111317 111317 2017 5,726,583 Dawning Real Estate: 501 Industry Rd STATEN IS 501 Industry Rd Other 39,217       40.1                                
112000 112000 2017 6,318,063 1000 South Avenue STATEN IS 1000 South Avenue Other 39,412   67.3 68.6 37.3 161.2 162.0 2.0 2.0 597.0 614.0                   0.0
112541 112541 2017 5,726,583 Dawning Real Estate: 501 Industry Rd STATEN IS 501 Industry Rd Other 39,217       40.1                                
117843 117843 2017 5,726,583 Dawning Real Estate: 501 Industry Rd STATEN IS 501 Industry Rd Other 39,217       40.1                                
79037 79037 2016 2,816,955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 210,598 0.0 2.4 2.4 39.2 7.5 7.5 504037.2 504037.2   0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
79840 79840 2016 3,555,072 Carmel Richmond HC & RC STATEN IS 88 Old Town Rd Other 170,000 6.0 181.4 185.1 122.5 331.0 332.1 30834113.0 11431733.1   19402379.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
83083 83083 2016 3,325,368 LA Fitness STATEN IS 145 East Service Rd. Other 51,609 0.0 111.6 114.3 42.7 252.9 253.8 5760542.6 3349715.6   2410827.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
89767 89767 2016 3,231,354 4343 Amboy Rd. STATEN IS 4343 Amboy Rd. Other 62,092 4.0 271.9 279.3 133.0 467.2 473.3 16882051.4 5397452.1   11484599.3   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
92406 92406 2016 5,848,361 LL84 Wagner College - Union STATEN IS 15 Campus Road Other 72,190 0.0 55.4 56.2 113.0 128.7 129.6 3996752.1 2436637.5   1560114.6   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
93319 93319 2016 2,811,156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82,500 0.0 21.5 22.4 47.0 56.4 57.3 1776066.2 1335101.9   440964.3   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
93612 93612 2016 4,955,241 Veterans Road West COMBINED STATEN IS 2945 Veterans Road West, Staten Island Other 93,264 0.0 70.0 69.1 40.9 210.8 206.8 6526255.3 6126940.8   399314.5   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
63208 63208 2015 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82500 0.0 22.6 22.8 54.7 50.9 51.1 1867191.9 1071709.2   795482.7   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
67297 67297 2015 3231354 4343 Amboy Rd. STATEN IS 4343 Amboy Rd. Other 62092 3.0 280.4 280.1 131.1 493.9 490.8 17410975.4 5926375.8   11484599.6   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
68026 68026 2015 3325368 LA Fitness STATEN IS 145 East Service Rd. Other 51609 0.0 110.9 112.9 44.2 242.9 245.0 5725025.8 3121882.2   2603143.6   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
68190 68190 2015 4410166 2935 Veterans Road West, Staten Island STATEN IS 2935 Veterans Road West, Staten Island Other 40733 0.0 96.6 94.6 40.1 296.9 290.7 3935474.5 3808342.2   127132.3   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
68191 68191 2015 4410167 2955 Veterans Road West, Staten Island STATEN IS 2955 Veterans Road West, Staten Island Other 38159 0.0 74.8 73.2 41.8 220.5 215.2 2852971.1 2592196.9   260774.2   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
68192 68192 2015 4410168 2945 Veterans Road West, Staten Island STATEN IS 2945 Veterans Road West, Staten Island Other 14372 0.0 232.3 231.3 56.8 503.7 498.6 3338578.6 1786378.6   1552200.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
68420 68420 2015 2701780 Pratt Paper NY, Pratt Industries USA STATEN IS 4435 Victory Boulevard Other 438530 0.0 200.2 200.6 50.3 489.6 490.1 87793470.0 58628394.0   29165076.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
69858 69858 2015 2816955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 210598 0.0 2.5 2.5 39.2 7.8 7.8 523888.8 523888.8   0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
70409 70409 2015 4955241 Veterans Road West COMBINED STATEN IS 2945 Veterans Road West, Staten Island Other 93264 0.0 108.7 107.5 45.0 297.6 293.2 10138663.6 8187547.5   1951116.1   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
76112 76112 2015 3555072 Carmel Richmond HC & RC STATEN IS 88 Old Town Rd Other 170000 6.0 185.2 186.7 125.5 331.9 330.8 31491568.9 11173989.8   20317579.1   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
52108 52108 2014 2701780 Visy Paper NY, Pratt Industries USA STATEN IS 4435 Victory Boulevard Other 438530 0.0 213.3 0.0 51.7 508.0 0.0 93517276.1 59611052.0   33906224.1   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
54688 54688 2014 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82500 0.0 16.8 15.9 52.5 39.4 38.5 1385017.6 859330.9   525686.7   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
55015 55015 2014 2816955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 210598 0.0 2.8 2.8 39.2 8.6 8.6 579247.5 579247.5   0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
55803 55803 2014 2921609 Shoprite STATEN IS 2424 Hylan Blvd Other Not Available 0.0 0.0 0.0 0.0 0.0 0.0 20306031.2 12877953.8   7428077.5   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
57418 57418 2014 3231354 4343 Amboy Rd. STATEN IS 4343 Amboy Rd. Other 62092 4.0 266.6 263.9 125.2 492.0 489.4 16553929.4 6300829.0   10253100.4   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
57422 57422 2014 3236222 Hilton Garden Inn STATEN IS 1100 South Avenue Other 184995 12.0 167.3 165.6 113.4 321.3 319.4 30958451.4 12884940.0   18073511.4   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
57431 57431 2014 3237565 Nicotra 1200 STATEN IS 1200 South Ave Other 77299 0.0 57.6 57.3 48.6 175.2 175.1 4448790.2 4245119.6   203670.6   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
57472 57472 2014 3258707 FORREST & RICHMOND STATEN IS 985 RICHMOND AVE Other Not Available 0.0 0.0 0.0 0.0 0.0 0.0 21325183.2 13964056.0   7361127.3   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
57507 57507 2014 3270621 Canterbury STATEN IS 1331 Bay Street Other 49942 0.0 86.9 0.0 102.9 104.1 0.0 4342123.9 0.0   4036955.9   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
58627 58627 2014 3555072 Carmel Richmond HC & RC STATEN IS 88 Old Town Rd Other 170000 5.0 189.9 187.3 124.1 340.2 336.0 32277762.2 11453153.4   20824608.8   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
39186 39186 2013 2701780 Visy Paper NY, Pratt Industries USA STATEN IS 4435 Victory Boulevard Other 438530 0.0 230.2 0.0 54.7 517.8 0.0 100969242.3 57928936.6   43040305.6   0.0 0.0 0.0 0.0       0.0 0.0
42279 42279 2013 2811156 staten island kitchen cabinets mfg, inc STATEN IS 1527 arthur kill road Other 82500 0.0 0.0 0.0 0.0 0.0 0.0 0.0 816891.6   0.0   0.0 0.0 0.0 0.0       0.0 0.0
42628 42628 2013 2816955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 210598 0.0 2.9 2.9 39.2 9.2 9.2 614116.3 614116.3   0.0   0.0 0.0 0.0 0.0       0.0 0.0
43568 43568 2013 2921609 Shoprite STATEN IS 2424 Hylan Blvd Other Not Available 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0   4770272.8   0.0 0.0 0.0 0.0       0.0 0.0
45614 45614 2013 3258707 FORREST & RICHMOND STATEN IS 985 RICHMOND AVE Other Not Available 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0   4890821.3   0.0 0.0 0.0 0.0       0.0 0.0
45657 45657 2013 3270621 Canterbury STATEN IS 1331 Bay Street Other 49942 0.0 104.6 105.5 81.4 158.2 159.3 5222914.3 1157373.2   4065541.2   0.0 0.0 0.0 0.0       0.0 0.0
46429 46429 2013 3526594 Mason Avenue Holdings Corp STATEN IS 1756 Forest Avenue Other Not Available 0.0 0.0 0.0 0.0 0.0 0.0 1763794.6 1741068.6   22726.0   0.0 0.0 0.0 0.0       0.0 0.0
46430 46430 2013 3526663 Building B STATEN IS 965 richmond ave Other Not Available 0.0 0.0 0.0 0.0 0.0 0.0 5674.0 0.0   5674.0   0.0 0.0 0.0 0.0       0.0 0.0
47679 47679 2013 4034820 1049_1428_2935 Veterans Road West, Staten Island STATEN IS 2935 Veterans Road West Other 40733 0.0 195.6 196.3 59.7 403.6 404.1 7967709.3 3863309.1   4104400.2   0.0 0.0 0.0 0.0       0.0 0.0
47680 47680 2013 4034824 1049_1429_2945 Veterans Road West, Staten Island STATEN IS 2945 Veterans Road West Other 14372 0.0 247.0 247.8 57.3 530.5 531.1 3549810.4 1864510.5   1685299.9   0.0 0.0 0.0 0.0       0.0 0.0
26366 26366 2012 2701780 Visy Paper NY, Pratt Industries USA STATEN IS 4435 Victory Boulevard Other 438530 0.0 194.4 204.5 70.0 494.8 505.4 85251722.0 55700900.0   29550822.0 295508.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0   0.0
28292 28292 2012 2781461 Our Lady of Good Counsel Church & School STATEN IS 10 Austin Place Other 36195 0.0 79.9 85.3 70.0 130.7 136.4 2893135.7 755280.32   1306600.0 13066.0 0.0 831255.38 0.0 0.0 0.0 0.0 0.0   0.0
30532 30532 2012 2816955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 210598 0.0 2.9 3.0 70.0 9.6 10.1 606994.8 606994.8   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0   0.0
34218 34218 2012 3270621 Canterbury STATEN IS 1331 Bay Street Other 47919 0.0 103.9 111.3 70.0 190.5 198.2 4980657.0 1706671.12   3273985.9 32739.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0   0.0
22553 22553 2011 2816955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 210,598 0.0 3.0 3.0 70.0 10.1   635.0 635.0 186.0                      
22669 22669 2011 2701780 Visy Paper NY, Pratt Industries USA STATEN IS 4435 Victory Boulevard Other 438,530 0.0 225.8 235.8 70.0 537.8   99.0 57.0 16.0 41.0 413.0                  
981 981 2010 2816955 Regal Estates LLC A STATEN IS 561 Richmond Terrace Other 353,303 0.0 1.6 1.6 104.0 5.3 5.3 561.0 561.0 164.0                      
8233 8233 2010 2701780 Visy Paper NY, Pratt Industries USA STATEN IS 4435 Victory Boulevard Other 438,530 0.0 225.5 234.5 104.0 536.1 545.6 98.0 57.0 16.0 41.0 415.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");
Powered by Datasette · Queries took 5566.631ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability