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

528 rows where Calendar Year = 2017 and Property Type = "Hotel" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Fuel Oil #2 Use (kBtu), Fuel Oil #4 Use (kBtu), Fuel Oil #5 & 6 Use (kBtu)

Borough 5

  • MANHATTAN 420
  • QUEENS 67
  • BROOKLYN 24
  • BRONX 4
  • STATEN IS 2

Property Type 1

  • Hotel · 528 ✖

Calendar Year 1

  • 2017 · 528 ✖
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)
94817 94817 2017 4,898,531 The Nomad Hotel   1170 Broadway Hotel 125,000 83.0 130.2 133.7 186.7 271.1 274.7 16.0 8.0 2.0 8.0                   0.0
94818 94818 2017 2,917,939 10 West 27 Street Corp MANHATTAN 1155 Broadway Hotel 50,000 27.0 76.5 80.8 62.1 163.0 167.9 3.0 1.0 579.0 1.0                   0.0
94819 94819 2017 3,878,205 Westbury Realty MANHATTAN 24 John Street Hotel 50,000 99.0 20.5 20.5 49.6 64.2 64.2 1.0 1.0 299.0                     0.0
94821 94821 2017 2,645,118 155 West 66th Street Condominium MANHATTAN 155 West 66th Street Hotel 142,088   117.7 120.1 78.3 243.4 244.6 16.0 7.0 2.0 1.0   7.0               0.0
94857 94857 2017 5,067,717 11 Howard Hotel MANHATTAN 11 Howard Street Hotel 112,900 3.0 126.3 127.9 66.7 296.6 298.2 14.0 8.0 2.0 5.0                   0.0
94862 94862 2017 2,959,868 JOLLY HOTEL USA MANHATTAN 241 Madison Avenue Hotel 137,200 70.0 119.2 126.4 144.4 191.9 199.2 16.0 4.0 1.0         11.0           0.0
94867 94867 2017 6,299,476 1301 Surf Ave BROOKLYN 1301 Surf Avenue Hotel 55,278       73.4                                
94868 94868 2017 3,296,567 university club of New York MANHATTAN 1 West 54th Street Hotel 200,000 59.0 72.7 73.1 79.0 207.0 207.9 14.0 12.0 3.0 2.0   18.0               0.0
94908 94908 2017 4,600,346 Wyndham Midtown 45 MANHATTAN 205 East 45th Street Hotel 140,105 7.0 103.8 103.2 63.1 191.1 189.6 14.0 5.0 1.0 9.0                   0.0
94922 94922 2017 3,568,901 Park Lane Hotel MANHATTAN 36 Central Park South Hotel 442,000 30.0 136.3 136.5 114.3 236.6 235.8 60.0 16.0 4.0 1.0   41.0               0.0
94940 94940 2017 4,943,395 Hotel Plaza Athenee MANHATTAN 37 East 64th Street Hotel 170,000 80.0 54.9 54.6 75.9 154.5 153.5 9.0 7.0 2.0 1.0                   0.0
94947 94947 2017 2,792,241 Affinia50   155 East Hotel 153,761 42.0 121.0 120.1 112.7 189.6 188.2 18.0 4.0 1.0 13.0                   0.0
95019 95019 2017 4,895,698 The Penn Club of New York MANHATTAN 30 W 44th Street Hotel 59,000 47.0 109.0 108.8 107.0 289.1 287.6 6.0 4.0 1.0 1.0                   0.0
95027 95027 2017 4,410,272 Standard Hotel MANHATTAN 848 Washington Street Hotel 206,000 1.0 275.3 285.0 109.1 550.2 561.5 56.0 25.0 7.0 30.0                   0.0
95055 95055 2017 5,985,966 WeCare Trading Company llc, d/b/a Cambria Hotel Suites New York - Chelsea MANHATTAN 123 West 28th St Hotel 55,411 65.0 92.8 95.8 107.4 222.9 228.3 5.0 3.0 975.0 1.0                   0.0
95095 95095 2017 3,136,671 Skyline Hotel MANHATTAN 725 10th Avenue Hotel 121,054 14.0 201.8   142.2 353.2   24.0 8.0 2.0 16.0                   0.0
95096 95096 2017 2,689,677 Hotel Wolcott MANHATTAN 4 West 31st St. Hotel 90,633 97.0 32.6 32.2 68.9 80.1 79.0 2.0 1.0 583.0 965.0                   0.0
95099 95099 2017 2,744,948 Affinia Gardens   215 East Hotel 98,495 58.0 76.6 80.6 82.5 134.9 138.0 7.0 2.0 778.0 66.0       4.0           0.0
95100 95100 2017 2,797,507 The Surrey Hotel MANHATTAN 20 East 76 Street Hotel 130,000 20.0 160.3 164.1 120.7 326.4 331.1 20.0 9.0 2.0 3.0       7.0           0.0
95101 95101 2017 2,808,077 Affi nia Shelburne MANHATTAN 303 Lexington Avenue Hotel 190,431 38.0 92.3   83.2 185.9   17.0 8.0 2.0 8.0                   0.0
95102 95102 2017 2,811,996 The Benjamin Hotel MANHATTAN 125 East 50th. Street Hotel 157,462 60.0 118.8 124.1 131.2 229.1 234.3 18.0 7.0 2.0 2.0   9.0               0.0
95126 95126 2017 2,689,677 Hotel Wolcott MANHATTAN 4 West 31st St. Hotel 90,633 97.0 32.6 32.2 68.9 80.1 79.0 2.0 1.0 583.0 965.0                   0.0
95133 95133 2017 1,946,606 Loews Regency Hotel MANHATTAN 540 Park Avenue Hotel 320,000 45.0 122.5 125.7 117.5 236.8 239.6 39.0 16.0 4.0 22.0                   0.0
95142 95142 2017 2,689,677 Hotel Wolcott MANHATTAN 4 West 31st St. Hotel 90,633 97.0 32.6 32.2 68.9 80.1 79.0 2.0 1.0 583.0 965.0                   0.0
95167 95167 2017 1,454,367 New York Palace MANHATTAN 455 Madison Avenue Hotel 893,750 14.0 178.0 179.9 123.3 282.0 283.2 159.0 37.0 11.0 80.0   41.0               0.0
95195 95195 2017 4,014,107 Gramercy Park Hotel MANHATTAN 2 Lexington Avenue Hotel 200,000 19.0 145.1 150.1 108.4 268.3 273.4 29.0 10.0 2.0 4.0   14.0               0.0
95196 95196 2017 2,678,205 Belvedere Hotel MANHATTAN 319 W 48th Street Hotel 187,000 57.0 110.7 111.5 118.2 201.2 201.1 20.0 7.0 2.0 3.0         9.0         0.0
95199 95199 2017 2,678,205 Belvedere Hotel MANHATTAN 319 W 48th Street Hotel 187,000 57.0 110.7 111.5 118.2 201.2 201.1 20.0 7.0 2.0 3.0         9.0         0.0
95221 95221 2017 2,720,165 Cornell Club of NY MANHATTAN 6 East 44th St. Hotel 65,000 21.0 99.1 97.9 75.5 280.7 277.0 6.0 5.0 1.0 944.0                   0.0
95224 95224 2017 2,720,165 Cornell Club of NY MANHATTAN 6 East 44th St. Hotel 65,000 15.0 106.6 105.3 74.9 304.4 300.4 6.0 5.0 1.0 944.0                   0.0
95254 95254 2017 4,399,380 Residence Inn by Marriott MANHATTAN 144 E 48th Street Hotel 114,500 49.0 86.4 87.3 85.7 209.6 210.5 9.0 6.0 1.0 3.0                   0.0
95295 95295 2017 4,436,800 Garden Inn & Suites QUEENS 151-20 Baisley Blvd. Hotel 85,900 28.0 103.1 106.2 84.6 216.2 222.8 8.0 4.0 1.0 4.0                   0.0
95296 95296 2017 4,436,800 Garden Inn & Suites QUEENS 151-20 Baisley Blvd. Hotel 85,900 28.0 103.1 106.2 84.6 216.2 222.8 8.0 4.0 1.0 4.0                   0.0
95314 95314 2017 3,108,824 Hotel Wales MANHATTAN 1295 Madison Avenue Hotel 53,542 41.0 207.0 213.5 191.1 367.7 372.5 11.0 3.0 1.0 2.0     4.0             0.0
95337 95337 2017 6,194,372 Becker Paramount Hotel MANHATTAN 235 West 46 Street Hotel 215,879       73.4                                
95364 95364 2017 3,128,822 The Sherry Netherland Hotel MANHATTAN 781 Fifth Avenue Hotel 335,897       73.4                                
95367 95367 2017 2,805,722 Cooper/Sheraton - 135-20 39th Street   135-20 39th Street Hotel 233,230       73.4                                
95463 95463 2017 5,851,027 9 Crosby LLC dba NOMO SOHO HOTEL MANHATTAN 9 Crosby Street Hotel 126,529 42.0 140.0 143.6 130.5 305.4 308.5 17.0 9.0 2.0 8.0                   0.0
95486 95486 2017 6,272,044 Redbury Hotel MANHATTAN 29 E 29 St Hotel 142,851 2.0 138.3 139.7 67.3 311.3 315.5 19.0 11.0 3.0 8.0                   0.0
95583 95583 2017 6,278,694 The New Yorker Hotel MANHATTAN 481 8th Avenue Hotel 1,300,000       73.4                                
95585 95585 2017 2,661,711 Iroquois Hotel MANHATTAN 49 West 44 Street Hotel 52,575 56.0 127.4 130.9 134.6 250.7 255.3 6.0 2.0 861.0 3.0                   0.0
95586 95586 2017 3,543,311 The Gershwin Hotel MANHATTAN 7 East 27th Street Hotel 54,000 19.0 129.5   96.7 318.2   6.0 4.0 1.0 2.0                   0.0
95587 95587 2017 2,662,349 Belleclaire Hotel MANHATTAN 250 West 77th Street Hotel 121,147 66.0 131.7 140.1 151.9 170.3 179.1 15.0 1.0 543.0 14.0                   0.0
95588 95588 2017 2,662,264 Washington Jefferson Hotel MANHATTAN 318 West 51st Street Hotel 54,568 51.0 116.1 123.8 117.9 188.0 197.6 6.0 1.0 505.0 4.0                   0.0
95589 95589 2017 2,664,580 Chandler Hotel MANHATTAN 12 East 31st Street Hotel 63,967 28.0 135.9 138.2 111.7 273.5 274.9 8.0 4.0 1.0 4.0                   0.0
95601 95601 2017 3,264,952 Sofitel New York-44th Street MANHATTAN 45 West 44th Street Hotel 293,966 13.0 148.2 150.9 102.1 285.9 288.3 43.0 16.0 4.0 3.0   23.0               0.0
95602 95602 2017 3,264,953 M&C New York Times Square - 52nd Street MANHATTAN 226 West 52nd Street Hotel 262,051 41.0 114.2 118.0 105.9 244.5 249.0 29.0 14.0 4.0 1.0   13.0               0.0
95613 95613 2017 2,732,758 Ace Hotel New York MANHATTAN 1186 Broadway Hotel 187,893 19.0 145.4 147.1 108.3 306.9 306.3 27.0 13.0 4.0 13.0                   0.0
95618 95618 2017 4,266,080 Andaz Hotel - 5th Avenue MANHATTAN 485 Fifth Avenue Hotel 190,357 30.0 129.3 132.3 107.3 298.5 301.5 24.0 14.0 4.0 832.0   9.0               0.0
95642 95642 2017 2,674,172 Kitano Arms Corp. MANHATTAN 66 Park Avenue Hotel 105,231 30.0 157.8 156.3 131.9 276.0 275.6 16.0 4.0 1.0 1.0   10.0               0.0
95785 95785 2017 5,985,966 WeCare Trading Company llc, d/b/a Cambria Hotel Suites New York - Chelsea MANHATTAN 123 West 28th St Hotel 55,411 65.0 92.8 95.8 107.4 222.9 228.3 5.0 3.0 975.0 1.0                   0.0
95868 95868 2017 4,226,798 42SCM-W New York - Union Square MANHATTAN 201 Park Avenue South Hotel 205,473 55.0 110.2 113.9 116.4 197.0 201.5 22.0 7.0 2.0 3.0   12.0               0.0
95895 95895 2017 2,811,143 270 West 45th St MANHATTAN 270 West 45th St Hotel 542,940 24.0 121.1 129.0 95.1 212.2 220.3 65.0 22.0 6.0 43.0                   0.0
95897 95897 2017 4,449,411 130 East 39th St MANHATTAN 130 East 39th St Hotel 141,567 71.0 76.6 79.6 94.2 162.9 167.2 10.0 5.0 1.0 58.0     5.0             0.0
95908 95908 2017 1,483,326 42SB9-W New York MANHATTAN 541 Lexington Avenue Hotel 350,000 59.0 75.2 74.8 82.0 222.1 220.9 26.0 23.0 7.0 2.0                   0.0
95909 95909 2017 1,483,343 5678-Sheraton New York Hotel & Towers MANHATTAN 811 7th Ave. Hotel 1,165,000 40.0 117.2 121.1 107.4 218.7 222.0 136.0 53.0 15.0 83.0                   0.0
95910 95910 2017 3,351,449 33789-New York Marriott Marquis Hotel MANHATTAN 1535 Broadway Hotel 1,825,000 26.0 133.5 138.1 107.3 278.8 285.4 243.0 120.0 35.0 122.0                   0.0
95911 95911 2017 3,351,756 337c7-New York Marriott Downtown MANHATTAN 85 West Street Hotel 329,999 3.0 293.6 293.4 159.2 375.5 374.7 96.0 8.0 2.0 62.0   25.0               0.0
95921 95921 2017 6,101,223 Aloft New York LaGuardia Airport QUEENS 100-15 Ditmars Blvd Hotel 124,483       73.4       3.0 884.0                     0.0
95931 95931 2017 6,219,497 Howard Johnson AirTrain JFK Airport QUEENS 139-09 Archer Ave Hotel 27,340 8.0 110.0 111.2 68.8 223.1 224.3 3.0 1.0 412.0 1.0                   0.0
96016 96016 2017 6,194,936 Row NYC MANHATTAN 700 8 Avenue Hotel 487,156 42.0 140.9 149.3 132.2 252.1 259.3 68.0 24.0 7.0 44.0                   0.0
96124 96124 2017 2,811,418 Courtyard LaGuardia QUEENS 90-10 Grand Central PKWY Hotel 185,000 41.0 119.3 122.3 110.9 226.1 227.5 22.0 9.0 2.0 2.0         9.0         0.0
96144 96144 2017 6,288,253 Wingate JFK Airport QUEENS 139-01 Archer Avenue Hotel 38,500       73.4                                
96218 96218 2017 3,533,351 Excelsior Hotel MANHATTAN 45 West 81st Street Hotel 129,575 24.0 165.8 173.0 131.2 257.2 262.9 21.0 5.0 1.0 3.0     12.0             0.0
96219 96219 2017 3,261,559 Hotel Edison MANHATTAN 228 West 47th Street Hotel 480,000 73.0 97.8 97.8 123.8 159.9 159.7 46.0 13.0 3.0 33.0                   0.0
96286 96286 2017 6,101,223 Aloft New York LaGuardia Airport QUEENS 100-15 Ditmars Blvd Hotel 124,483       73.4       3.0 884.0                     0.0
96508 96508 2017 6,244,283 WYNDHAM GARDEN BROOKLYN SUNSET PARK BROOKLYN 457 39 STREET Hotel 3,500   786.5 815.9 68.5 1.0 1.0 2.0 1.0 507.0 1.0                   0.0
96770 96770 2017 5,027,377 Courtyard By Marriott MANHATTAN 307 West 37th Street Hotel 102,824 99.0 48.2 49.5 120.2 90.8 92.9 4.0 1.0 578.0 2.0                   0.0
96846 96846 2017 6,219,497 Howard Johnson AirTrain JFK Airport QUEENS 139-09 Archer Ave Hotel 27,340 8.0 110.0 111.2 68.8 223.1 224.3 3.0 1.0 412.0 1.0                   0.0
96847 96847 2017 6,288,253 Wingate JFK Airport QUEENS 139-01 Archer Avenue Hotel 38,500       73.4                                
96869 96869 2017 4,361,071 The Dominick MANHATTAN 246 Spring Street Hotel 391,124 21.0 114.3 116.9 86.8 258.2 261.6 44.0 24.0 7.0 3.0   16.0               0.0
96950 96950 2017 6,272,377 William Vale Hotel BROOKLYN 111 N. 12th Street Hotel 185,141 3.0 140.2 144.3 75.3 291.5 301.6 25.0 12.0 3.0 13.0                   0.0
96992 96992 2017 4,408,595 Grand Hyatt - 109 E 42nd Street MANHATTAN 109 E 42nd St Hotel 1,100,000   100.1 102.5 75.8 214.2 215.9 110.0 53.0 15.0 3.0   53.0               0.0
97063 97063 2017 4,558,658 THE PIERRE HOTEL MANHATTAN 2 EAST 61ST STREET Hotel 515,755 1.0 237.0 236.1 113.9 407.3 404.6 122.0 32.0 9.0 3.0   85.0               0.0
97380 97380 2017 4,042,763 33 ninth avenue condominium MANHATTAN 29 9th avenue Hotel 69,160 2.0 125.2 125.2 57.4 353.6 353.6 8.0 7.0 2.0 1.0                   0.0
97421 97421 2017 2,617,091 Hostelling International - NY MANHATTAN 891 Amsterdam Avenue Hotel 93,500 39.0 99.9 103.5 91.3 203.4 208.1 9.0 4.0 1.0 4.0                   0.0
97445 97445 2017 2,612,035 UNION CLUB OF THE CITY NEW YORK, INC MANHATTAN 101 EAST 69TH STREET Hotel 93,000 3.0 188.0 199.4 102.5 361.5 378.1 17.0 6.0 1.0 1.0   9.0               0.0
97459 97459 2017 4,042,763 33 ninth avenue condominium MANHATTAN 29 9th avenue Hotel 69,160 2.0 125.2 125.2 57.4 353.6 353.6 8.0 7.0 2.0 1.0                   0.0
97572 97572 2017 4,598,321 Mercer Hotel MANHATTAN 147 Mercer Street Hotel 76,000 6.0 177.7 180.6 98.7 373.9 375.2 13.0 6.0 1.0 6.0                   0.0
97645 97645 2017 6,231,698 Crosby Street Hotel MANHATTAN 79 Crosby Street Hotel 60,000 94.0 104.8 110.0 189.7 110.1 115.5 6.0     6.0                    
97686 97686 2017 4,992,815 New York NY REN MANHATTAN 130 East 57th St Hotel 111,084 10.0 109.8 113.9 71.2 232.5 237.7 12.0 6.0 1.0 5.0                   0.0
97815 97815 2017 2,787,757 Jolly Tinker Inc. DBA Fitzpatrick Hotel MANHATTAN 687 Lexington Avenue Hotel 68,308 39.0 109.2 113.4 99.3 217.2 222.2 7.0 3.0 905.0 819.0   3.0               0.0
97816 97816 2017 2,792,746 Fitzpatrick Grand Central Hotel MANHATTAN 141 East 44th Street Hotel 72,307 23.0 150.0 152.8 117.1 286.0 289.4 10.0 4.0 1.0 1.0   4.0               0.0
97817 97817 2017 6,277,470 Hilton Garden Inn MANHATTAN 45 East 33 Street Hotel 118,700   130.8 135.3 78.1 271.3 278.3 15.0 7.0 2.0 7.0                   0.0
97829 97829 2017 3,762,081 040-Hampton Inn NY MSG/Herald Square MANHATTAN 116 W. 31th Street Hotel 49,287 70.0 101.8 107.4 124.3 214.3 226.6 5.0 2.0 742.0 2.0                   0.0
97830 97830 2017 3,762,090 066-Hilton Garden Inn - JFK QUEENS 148-18 134th Street Hotel 84,280 80.0 84.9 86.1 117.4 170.7 172.5 7.0 3.0 964.0 3.0                   0.0
97831 97831 2017 3,762,097 081-Hampton Inn - Chelsea MANHATTAN 108 W. 24th Street Hotel 55,000 68.0 99.6 102.4 118.2 201.7 209.3 5.0 2.0 756.0 2.0                   0.0
97832 97832 2017 3,762,100 092-Hampton Inn - Seaport MANHATTAN 320 Pearl Street Hotel 27,450 58.0 86.9 87.7 94.0 226.9 229.6 2.0 1.0 523.0 604.0                   0.0
97833 97833 2017 3,762,102 096-Sheraton - JFK   132-26 S. Conduit Drive Hotel 57,706 72.0 77.5 78.5 96.7 167.0 168.9 6.0 3.0 978.0 2.0                   0.0
97834 97834 2017 3,762,108 118-Hilton Garden Inn - Tribeca MANHATTAN 39 Avenue of the Americas Hotel 59,150 60.0 113.5 116.8 125.5 207.5 212.5 7.0 2.0 840.0 4.0                   0.0
97835 97835 2017 3,762,110 125-Hampton Inn - Times Square South MANHATTAN 337 West 39th Street Hotel 70,477 67.0 78.8 81.3 92.7 203.4 209.3 5.0 4.0 1.0 1.0                   0.0
97836 97836 2017 3,762,111 126-Holiday Inn Express - Times Square MANHATTAN 343 West 39th Street Hotel 71,500 68.0 83.7 86.4 99.7 193.9 200.4 7.0 4.0 1.0 2.0                   0.0
97837 97837 2017 3,762,112 127-Candlewood Suites - Times Square MANHATTAN 339 West 39th Street Hotel 82,000 54.0 80.2 83.1 83.4 195.2 201.1 6.0 4.0 1.0 2.0                   0.0
97838 97838 2017 3,762,114 130-Holiday Inn - Wall Street MANHATTAN 51 Nassau St Hotel 44,643 41.0 138.3 145.5 128.4 273.4 286.8 5.0 2.0 666.0 2.0                   0.0
97839 97839 2017 3,762,121 145-Holiday Inn Express - Wall Street MANHATTAN 126 Water St Hotel 42,568 54.0 108.9 115.4 113.5 232.0 244.6 4.0 2.0 702.0 2.0                   0.0
97840 97840 2017 3,762,128 168-Hyatt Union Square MANHATTAN 132 Fourth Avenue Hotel 68,935 65.0 111.8 115.5 129.4 256.3 260.2 7.0 4.0 1.0 3.0                   0.0
97841 97841 2017 3,762,131 Holiday Inn Express New York City Chelsea MANHATTAN 232 W 29th Street Hotel 71,541 76.0 104.6 107.1 136.1 203.1 208.5 7.0 3.0 935.0 4.0                   0.0
97842 97842 2017 4,209,296 112-Hampton Inn Pearl Street MANHATTAN 32 Pearl Street Hotel 38,264 40.0 80.8 83.4 74.1 174.5 178.7 3.0 1.0 481.0 1.0                   0.0
97843 97843 2017 4,209,297 199 Hilton Garden Inn 52nd Street MANHATTAN 206 East 52nd Street Hotel 85,420 24.0 96.6 100.1 76.4 217.5 223.4 8.0 4.0 1.0 3.0                   0.0
97844 97844 2017 6,292,631 204-Hilton Garden Inn Central Park South MANHATTAN 237 West 54th Street Hotel 150,000 26.0 96.7 98.7 77.6 227.1 228.5 14.0 9.0 2.0 5.0                   0.0

Next page

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 2514.931ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability