Energy — EUI and Fuel Use by Type
Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability
274 rows where Calendar Year = 2017 and Property Type = "Retail Store" sorted by Calendar Year descending
This data as json, CSV (advanced)
Suggested facets: District Steam Use (kBtu), Fuel Oil #2 Use (kBtu), Green Power - Offsite (kWh)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94865 | 94865 | 2017 | 6,182,209 | Staples | QUEENS | 24-41 31st St | Retail Store | 14,700 | 30.0 | 81.4 | 82.1 | 63.3 | 235.0 | 234.4 | 1.0 | 1.0 | 308.0 | 145.0 | 0.0 | |||||||||
| 94869 | 94869 | 2017 | 2,804,420 | Jamaica Ave Property | QUEENS | 163-19 Jamaica Ave | Retail Store | 54,978 | 90.0 | 38.9 | 39.7 | 78.0 | 104.6 | 105.5 | 2.0 | 1.0 | 493.0 | 79.0 | 376.0 | 0.0 | ||||||||
| 95072 | 95072 | 2017 | 6,227,760 | C21 Bay Ridge Blue LLC | BROOKLYN | 441 87th St | Retail Store | 30,000 | 99.9 | 99.3 | 75.7 | 313.6 | 311.7 | 2.0 | 2.0 | 878.0 | 0.0 | |||||||||||
| 95159 | 95159 | 2017 | 6,227,961 | C21 BK Home LLC Campus | BROOKLYN | 423 88th St | Retail Store | 78,379 | 117.8 | 120.3 | 40.5 | 333.1 | 335.8 | 9.0 | 7.0 | 2.0 | 1.0 | 0.0 | ||||||||||
| 95160 | 95160 | 2017 | 6,227,962 | 415 88th st | BROOKLYN | 423 88th St | Retail Store | 15,290 | 47.1 | |||||||||||||||||||
| 95161 | 95161 | 2017 | 6,227,966 | 436 87th st | BROOKLYN | 423 88th St | Retail Store | 20,125 | 47.1 | |||||||||||||||||||
| 95162 | 95162 | 2017 | 6,227,968 | 416 87th St | BROOKLYN | 423 88th St | Retail Store | 27,464 | 47.1 | |||||||||||||||||||
| 95307 | 95307 | 2017 | 6,231,315 | 2241 WESTCHESTER AVENUE - 33697 | BRONX | 2241 WESTCHESTER AVENUE | Retail Store | 26,827 | 132.6 | 133.9 | 49.5 | 306.7 | 305.2 | 3.0 | 2.0 | 629.0 | 1.0 | 0.0 | ||||||||||
| 95877 | 95877 | 2017 | 6,289,129 | Cameo Holding | QUEENS | 45-01 Greenpoint Avenue | Retail Store | 30,500 | 100.0 | 0.1 | 0.1 | 60.8 | 0.4 | 0.4 | 4.0 | 4.0 | 1.0 | 0.0 | ||||||||||
| 96122 | 96122 | 2017 | 4,742,798 | 6001-New York | MANHATTAN | 424 Fifth Ave | Retail Store | 796,488 | 78.0 | 55.7 | 58.9 | 84.6 | 135.8 | 141.6 | 44.0 | 28.0 | 8.0 | 961.0 | 15.0 | 0.0 | ||||||||
| 96123 | 96123 | 2017 | 4,742,807 | 06601-New York, NY | MANHATTAN | 611 Fifth Avenue | Retail Store | 661,000 | 26.0 | 120.5 | 123.2 | 89.4 | 296.3 | 298.5 | 79.0 | 51.0 | 15.0 | 2.0 | 24.0 | 0.0 | ||||||||
| 96139 | 96139 | 2017 | 5,866,066 | Not A Pratt Building | BROOKLYN | 524 Myrtle Ave | Retail Store | 125,000 | 84.3 | 114.0 | ||||||||||||||||||
| 96423 | 96423 | 2017 | 2,788,856 | Jackson Heights Shopping Center | 75-01 - 75-81 31st Avenue | Retail Store | 120,900 | 80.0 | 86.6 | 85.7 | 123.1 | 271.8 | 269.2 | 10.0 | 10.0 | 3.0 | 0.0 | 0.0 | ||||||||||
| 96491 | 96491 | 2017 | 2,788,856 | Jackson Heights Shopping Center | 75-01 - 75-81 31st Avenue | Retail Store | 120,900 | 80.0 | 86.6 | 85.7 | 123.1 | 271.8 | 269.2 | 10.0 | 10.0 | 3.0 | 0.0 | 0.0 | ||||||||||
| 96816 | 96816 | 2017 | 2,721,867 | WIN DEPOT | QUEENS | 42 52 NORTHERN BLVD | Retail Store | 55,176 | 60.0 | 62.6 | 68.4 | 71.5 | 114.3 | 120.4 | 3.0 | 1.0 | 376.0 | 2.0 | 0.0 | |||||||||
| 96863 | 96863 | 2017 | 6,281,283 | 2231-2239 Broadway | MANHATTAN | 2231-2239 Broadway | Retail Store | 57,292 | 114.0 | 118.3 | 49.5 | 263.4 | 266.0 | 6.0 | 3.0 | 1.0 | 2.0 | 0.0 | ||||||||||
| 96864 | 96864 | 2017 | 6,281,286 | 3781-3799 Broadway | MANHATTAN | 3781-3799 Broadway | Retail Store | 50,560 | 140.8 | 142.7 | 49.1 | 328.5 | 327.2 | 7.0 | 4.0 | 1.0 | 2.0 | 0.0 | ||||||||||
| 97212 | 97212 | 2017 | 2,788,856 | Jackson Heights Shopping Center | 75-01 - 75-81 31st Avenue | Retail Store | 120,900 | 80.0 | 87.0 | 86.2 | 123.1 | 273.2 | 270.8 | 10.0 | 10.0 | 3.0 | 0.0 | 0.0 | ||||||||||
| 97422 | 97422 | 2017 | 6,227,961 | C21 BK Home LLC Campus | BROOKLYN | 423 88th St | Retail Store | 78,379 | 117.8 | 120.3 | 40.5 | 333.1 | 335.8 | 9.0 | 7.0 | 2.0 | 1.0 | 0.0 | ||||||||||
| 97540 | 97540 | 2017 | 2,856,349 | Queensboro Toyota | QUEENS | 62-10 Northern Boulevard | Retail Store | 40,500 | 36.0 | 133.2 | 144.7 | 112.3 | 222.1 | 232.8 | 5.0 | 1.0 | 467.0 | 3.0 | 0.0 | |||||||||
| 97657 | 97657 | 2017 | 2,640,532 | 585 Dekalb | BROOKLYN | 585 Dekalb Avenue | Retail Store | 162,999 | 56.0 | 83.4 | 86.1 | 89.9 | 210.1 | 211.4 | 13.0 | 9.0 | 2.0 | 4.0 | 0.0 | |||||||||
| 97679 | 97679 | 2017 | 1,296,056 | 10782-Staten Island | 2239 Forrest Avenue | Retail Store | 91,047 | 78.0 | 42.1 | 42.6 | 64.3 | 127.3 | 125.1 | 3.0 | 3.0 | 1.0 | 207.0 | 0.0 | 0.0 | |||||||||
| 97893 | 97893 | 2017 | 2,788,856 | Jackson Heights Shopping Center | 75-01 - 75-81 31st Avenue | Retail Store | 120,900 | 80.0 | 87.0 | 86.2 | 123.1 | 273.2 | 270.8 | 10.0 | 10.0 | 3.0 | 0.0 | 0.0 | ||||||||||
| 98205 | 98205 | 2017 | 5,245,875 | 1363-1377 Jerome Ave | BRONX | 1363-1377 Jerome Ave | Retail Store | 52,250 | 52.0 | 81.4 | 84.3 | 84.2 | 198.9 | 200.1 | 4.0 | 2.0 | 830.0 | 1.0 | 0.0 | |||||||||
| 98252 | 98252 | 2017 | 4,939,723 | 380 Lafayette Street | MANHATTAN | 380 Lafayette Street | Retail Store | 50,000 | 1.0 | 283.9 | 287.0 | 95.0 | 571.4 | 571.9 | 14.0 | 6.0 | 1.0 | 5.0 | 1.0 | 0.0 | ||||||||
| 98274 | 98274 | 2017 | 4,959,515 | 9 Bond St | BROOKLYN | 9 Bond St | Retail Store | 180,350 | 102.3 | 105.2 | 46.6 | 251.4 | 254.0 | 18.0 | 12.0 | 3.0 | 6.0 | 0.0 | ||||||||||
| 98387 | 98387 | 2017 | 6,266,163 | 42-01 Main Street - 39886 | QUEENS | 42-01 Main Street | Retail Store | 25,500 | 92.9 | 92.9 | 36.4 | 291.8 | 291.8 | 2.0 | 2.0 | 694.0 | 0.0 | |||||||||||
| 98517 | 98517 | 2017 | 2,816,270 | Paragon Sports | MANHATTAN | 867 Broadway | Retail Store | 52,810 | 87.0 | 98.5 | 181.5 | 285.4 | 5.0 | 4.0 | 1.0 | 183.0 | 414.0 | 0.0 | ||||||||||
| 98554 | 98554 | 2017 | 6,289,129 | Cameo Holding | QUEENS | 45-01 Greenpoint Avenue | Retail Store | 30,500 | 100.0 | 0.1 | 0.1 | 60.8 | 0.4 | 0.4 | 4.0 | 4.0 | 1.0 | 0.0 | ||||||||||
| 98676 | 98676 | 2017 | 5,724,440 | Tiffany & Co. | MANHATTAN | 727 5th Ave | Retail Store | 117,232 | 53.0 | 199.7 | 209.3 | 481.2 | 23.0 | 14.0 | 4.0 | 160.0 | 8.0 | 0.0 | ||||||||||
| 98723 | 98723 | 2017 | 3,346,714 | 11962-NEW YORK, NY | MANHATTAN | 1471 Broadway | Retail Store | 34,618 | 1.0 | 358.9 | 374.3 | 117.3 | 891.2 | 909.7 | 12.0 | 8.0 | 2.0 | 4.0 | 0.0 | |||||||||
| 99114 | 99114 | 2017 | 5,236,465 | 477 Broadway | MANHATTAN | 477 Broadway | Retail Store | 63,150 | 21.4 | 43.2 | 56.7 | 1.0 | 1.0 | 304.0 | 24.0 | 287.0 | 0.0 | |||||||||||
| 99433 | 99433 | 2017 | 2,598,113 | 478-482 Broadway | MANHATTAN | 478-482 Broadway | Retail Store | 55,015 | 128.8 | 39.7 | 371.1 | 7.0 | 6.0 | 1.0 | 23.0 | 837.0 | 0.0 | |||||||||||
| 99434 | 99434 | 2017 | 2,598,358 | Flushing | QUEENS | 13620 Roosevelt Ave | Retail Store | 166,738 | 2.0 | 227.2 | 228.0 | 93.4 | 551.9 | 554.3 | 37.0 | 24.0 | 7.0 | 12.0 | 0.0 | |||||||||
| 99444 | 99444 | 2017 | 5,008,681 | 155 Spring Street | MANHATTAN | 155 Spring Street | Retail Store | 49,820 | 73.0 | 57.0 | 59.1 | 79.7 | 144.2 | 145.3 | 2.0 | 2.0 | 594.0 | 809.0 | 0.0 | |||||||||
| 99445 | 99445 | 2017 | 5,010,097 | 150 West 34th Street | MANHATTAN | 150 West 34th Street | Retail Store | 77,760 | 21.0 | 102.2 | 102.2 | 69.9 | 311.4 | 310.4 | 7.0 | 7.0 | 2.0 | 353.0 | 0.0 | |||||||||
| 99449 | 99449 | 2017 | 5,287,312 | 435 Seventh Avenue | MANHATTAN | 435 Seventh Avenue | Retail Store | 42,769 | 9.0 | 186.9 | 188.4 | 102.5 | 544.4 | 542.2 | 7.0 | 7.0 | 2.0 | 865.0 | 0.0 | |||||||||
| 99459 | 99459 | 2017 | 2,785,927 | 40 East 14th Street | MANHATTAN | 40 E 14th Street | Retail Store | 206,442 | 18.0 | 171.6 | 171.6 | 112.0 | 429.4 | 429.4 | 35.0 | 24.0 | 7.0 | 10.0 | 0.0 | |||||||||
| 99464 | 99464 | 2017 | 5,306,558 | 692 Broadway | MANHATTAN | 692 Broadway | Retail Store | 182,605 | 81.3 | 86.3 | 63.1 | 164.9 | 169.4 | 14.0 | 6.0 | 2.0 | 7.0 | 0.0 | ||||||||||
| 99510 | 99510 | 2017 | 3,976,452 | Jamestown Premier One Times Square | MANHATTAN | 1 Times Square | Retail Store | 132,920 | 17.0 | 172.5 | 178.0 | 111.6 | 479.8 | 488.3 | 22.0 | 18.0 | 5.0 | 4.0 | 0.0 | |||||||||
| 99594 | 99594 | 2017 | 6,227,961 | C21 BK Home LLC Campus | BROOKLYN | 423 88th St | Retail Store | 78,379 | 117.8 | 120.3 | 40.5 | 333.1 | 335.8 | 9.0 | 7.0 | 2.0 | 1.0 | 0.0 | ||||||||||
| 99608 | 99608 | 2017 | 1,444,034 | Bloomingdale's - 59th Street | MANHATTAN | 1000 Third Avenue | Retail Store | 858,374 | 76.0 | 83.3 | 85.7 | 121.6 | 230.2 | 234.3 | 71.0 | 57.0 | 16.0 | 723.0 | 13.0 | 0.0 | ||||||||
| 99609 | 99609 | 2017 | 2,646,585 | (71003A) Herald Square Macy's | MANHATTAN | 441 7th Ave | Retail Store | 2,169,496 | 85.0 | 60.0 | 59.8 | 105.6 | 182.7 | 182.1 | 130.0 | 124.0 | 36.0 | 5.0 | 65.0 | 0.0 | ||||||||
| 99610 | 99610 | 2017 | 2,646,588 | (71007A) Staten Island Macy's - CB | STATEN IS | 112 Richmond Hill Road | Retail Store | 271,643 | 74.0 | 118.7 | 167.0 | 198.4 | 32.0 | 9.0 | 2.0 | 22.0 | 441.0 | |||||||||||
| 99611 | 99611 | 2017 | 2,646,593 | (71022A) Parkchester Macy's | BRONX | 1409 Metropolitan Ave | Retail Store | 200,779 | 93.0 | 26.2 | 26.3 | 61.2 | 82.2 | 82.6 | 5.0 | 5.0 | 1.0 | 0.0 | ||||||||||
| 99612 | 99612 | 2017 | 2,646,602 | (71001A) Queens-Rego Park Macy's | QUEENS | 90-15 Queens Blvd 3 North West | Retail Store | 375,888 | 94.0 | 34.8 | 35.2 | 81.7 | 109.2 | 110.4 | 13.0 | 13.0 | 3.0 | 7.0 | 0.0 | |||||||||
| 99613 | 99613 | 2017 | 6,283,100 | (71185A) Flushing Macy's | QUEENS | 136-50 Roosevelt Ave | Retail Store | 276,732 | 88.0 | 35.8 | 35.9 | 68.7 | 111.6 | 112.0 | 9.0 | 9.0 | 2.0 | 88.0 | 0.0 | |||||||||
| 99614 | 99614 | 2017 | 6,283,151 | (72053A) Bloomingdale's - SoHo | MANHATTAN | 504 Broadway | Retail Store | 121,976 | 70.0 | 70.3 | 72.3 | 93.1 | 214.6 | 220.5 | 8.0 | 8.0 | 2.0 | 350.0 | 0.0 | |||||||||
| 99812 | 99812 | 2017 | 5,806,599 | 150-24 Northern Blvd | QUEENS | 150-24 Northern Blvd | Retail Store | 50,000 | 5.0 | 153.0 | 154.6 | 75.7 | 421.3 | 417.0 | 7.0 | 6.0 | 1.0 | 1.0 | 0.0 | |||||||||
| 99857 | 99857 | 2017 | 3,413,981 | New York Design Center | MANHATTAN | 200 Lexington Ave | Retail Store | 470,000 | 90.0 | 44.2 | 45.8 | 90.7 | 104.7 | 105.5 | 20.0 | 13.0 | 3.0 | 6.0 | 1.0 | 0.0 | ||||||||
| 99970 | 99970 | 2017 | 1,632,816 | Raymour and Flanigan Elmhurst | QUEENS | 86-08 Queens Blvd. | Retail Store | 52,862 | 98.0 | 32.9 | 36.6 | 102.5 | 59.8 | 64.6 | 1.0 | 638.0 | 187.0 | 1.0 | 0.0 | |||||||||
| 100009 | 100009 | 2017 | 6,113,826 | 5660 Broadway (W08) | BRONX | 5660 Broadway | Retail Store | 36,778 | 47.1 | 1.0 | ||||||||||||||||||
| 101363 | 101363 | 2017 | 2,038,302 | 1114 | BROOKLYN | 2307 BEVERLEY RD | Retail Store | 187,823 | 77.0 | 48.7 | 52.1 | 72.3 | 105.5 | 108.4 | 9.0 | 4.0 | 1.0 | 4.0 | 0.0 | |||||||||
| 101371 | 101371 | 2017 | 2,343,724 | 7777 | MANHATTAN | 770 Broadway | Retail Store | 154,099 | 69.0 | 49.8 | 49.7 | 64.9 | 153.6 | 153.5 | 7.0 | 7.0 | 2.0 | 189799.9 | 0.0 | |||||||||
| 101396 | 101396 | 2017 | 2,343,744 | 9419 | QUEENS | 66-26 Metropolitan Avenue | Retail Store | 139,755 | 82.0 | 37.9 | 37.9 | 62.3 | 119.0 | 119.0 | 5.0 | 5.0 | 1.0 | 0.0 | ||||||||||
| 101444 | 101444 | 2017 | 3,119,119 | 3500 48 Street Owners LLC | QUEENS | 34-54 48 Street | Retail Store | 129,790 | 66.0 | 91.5 | 95.3 | 114.3 | 227.8 | 232.3 | 11.0 | 8.0 | 2.0 | 3.0 | 0.0 | |||||||||
| 101466 | 101466 | 2017 | 2,037,421 | 1624 | STATEN IS | 283 PLATINUM AVE | Retail Store | 182,834 | 47.1 | |||||||||||||||||||
| 101467 | 101467 | 2017 | 2,344,695 | 7654 | BRONX | 300 Baychester Avenue | Retail Store | 134,028 | 95.0 | 38.9 | 38.8 | 99.3 | 117.9 | 116.9 | 5.0 | 4.0 | 1.0 | 274.0 | 0.0 | |||||||||
| 101468 | 101468 | 2017 | 2,344,723 | 9420 | BRONX | 1998 Bruckner Boulevard | Retail Store | 171,476 | 76.0 | 51.9 | 53.9 | 76.0 | 150.4 | 155.1 | 8.0 | 7.0 | 2.0 | 1.0 | 0.0 | |||||||||
| 101469 | 101469 | 2017 | 2,712,742 | 7749 | MANHATTAN | 250 West 34th Street | Retail Store | 143,471 | 100.0 | 0.0 | 0.0 | 47.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||||||||||
| 101596 | 101596 | 2017 | 6,272,328 | 40 Gansevoort St | MANHATTAN | 40 Gansevoort St | Retail Store | 47,800 | 20.0 | 116.3 | 119.6 | 78.7 | 301.8 | 304.1 | 5.0 | 4.0 | 1.0 | 1.0 | 0.0 | |||||||||
| 101611 | 101611 | 2017 | 2,981,291 | The Colosseum | QUEENS | 89-02 165th Street | Retail Store | 122,000 | 76.0 | 86.3 | 86.7 | 125.5 | 161.4 | 161.4 | 10.0 | 4.0 | 1.0 | 2.0 | 3.0 | 0.0 | ||||||||
| 101680 | 101680 | 2017 | 5,806,599 | 150-24 Northern Blvd | QUEENS | 150-24 Northern Blvd | Retail Store | 50,000 | 4.0 | 173.6 | 174.1 | 81.7 | 442.9 | 437.4 | 8.0 | 6.0 | 1.0 | 2.0 | 0.0 | |||||||||
| 101843 | 101843 | 2017 | 6,289,129 | Cameo Holding | QUEENS | 45-01 Greenpoint Avenue | Retail Store | 30,500 | 100.0 | 0.1 | 0.1 | 60.8 | 0.4 | 0.4 | 4.0 | 4.0 | 1.0 | 0.0 | ||||||||||
| 102098 | 102098 | 2017 | 2,981,291 | The Colosseum | QUEENS | 89-02 165th Street | Retail Store | 122,000 | 76.0 | 86.3 | 86.7 | 125.5 | 161.4 | 161.4 | 10.0 | 4.0 | 1.0 | 2.0 | 3.0 | 0.0 | ||||||||
| 102138 | 102138 | 2017 | 4,222,831 | Forest Avenue S.C. | STATEN IS | 1489 Forest Avenue | Retail Store | 198,430 | 72.0 | 65.0 | 65.0 | 89.4 | 174.0 | 173.1 | 12.0 | 10.0 | 2.0 | 2.0 | 0.0 | |||||||||
| 102139 | 102139 | 2017 | 4,223,265 | Mill Basin Plaza | BROOKLYN | 5702-5716 AVENUE U | Retail Store | 80,708 | 90.6 | 92.4 | 43.8 | 236.8 | 238.3 | 7.0 | 5.0 | 1.0 | 1.0 | 0.0 | ||||||||||
| 102140 | 102140 | 2017 | 4,224,270 | Richmond S.C. | STATEN IS | 2845-2895 RICHMOND AVE AND INDEPENDENCE AVENUE | Retail Store | 261,148 | 53.1 | 53.5 | 50.5 | 120.3 | 120.8 | 13.0 | 8.0 | 2.0 | 5.0 | 0.0 | ||||||||||
| 102141 | 102141 | 2017 | 4,224,272 | Greenridge Plaza | STATEN IS | 3231-3247 RICHMOND AVE. | Retail Store | 100,977 | 104.6 | 109.1 | 70.6 | 169.7 | 174.0 | 10.0 | 2.0 | 847.0 | 7.0 | 0.0 | ||||||||||
| 102142 | 102142 | 2017 | 4,224,276 | The Boulevard, formerly known as Hylan Plaza | STATEN IS | 2626-2696 HYLAN BLVD. AND 107 MILL ROAD | Retail Store | 367,318 | 15.6 | 15.6 | 36.4 | 49.0 | 49.0 | 5.0 | 5.0 | 1.0 | 0.0 | |||||||||||
| 102143 | 102143 | 2017 | 6,272,320 | Forest Ave Plaza | STATEN IS | 1520 Forest Avenue | Retail Store | 66,576 | 34.0 | 36.6 | 47.7 | 81.5 | 86.0 | 2.0 | 1.0 | 427.0 | 803.0 | 0.0 | ||||||||||
| 102181 | 102181 | 2017 | 3,114,416 | Bruckner | BRONX | 2550 Bruckner Boulevard | Retail Store | 135,743 | 67.0 | 62.3 | 64.3 | 78.4 | 165.3 | 166.7 | 8.0 | 6.0 | 1.0 | 1.0 | 0.0 | |||||||||
| 102182 | 102182 | 2017 | 3,114,433 | Zerega | BRONX | 635 Zerega Avenue | Retail Store | 137,699 | 87.0 | 50.1 | 52.9 | 93.7 | 120.8 | 123.8 | 6.0 | 4.0 | 1.0 | 2.0 | 0.0 | |||||||||
| 102183 | 102183 | 2017 | 4,954,132 | College Point Retail Center - BJ's Wholesale Club | QUEENS | 137-05 20 Ave | Retail Store | 119,500 | 162.7 | 170.2 | 49.8 | 374.2 | 380.1 | 19.0 | 11.0 | 3.0 | 7.0 | 0.0 | ||||||||||
| 102476 | 102476 | 2017 | 1,547,924 | GATEWAY (1401) | BROOKLYN | 519 GATEWAY DR | Retail Store | 148,939 | 77.0 | 103.1 | 108.1 | 154.0 | 221.7 | 226.3 | 15.0 | 8.0 | 2.0 | 7.0 | 0.0 | |||||||||
| 102477 | 102477 | 2017 | 1,548,095 | RIVERDALE (1798) | BRONX | 40 W 225TH ST #50 | Retail Store | 157,011 | 68.0 | 97.9 | 100.5 | 124.7 | 262.7 | 263.5 | 15.0 | 12.0 | 3.0 | 3.0 | 0.0 | |||||||||
| 102507 | 102507 | 2017 | 4,409,914 | 187-02 Horace Harding Expressway | 187 Horace Harding Expressway | Retail Store | 89,343 | 1.0 | 1.0 | 83.3 | 1.0 | 1.0 | 92.0 | 14.0 | 4.0 | 65.0 | 5.0 | 8078059.5 | 0.0 | |||||||||
| 102508 | 102508 | 2017 | 4,409,927 | 61-11 192 Street | 61 192 Street | Retail Store | 156,875 | 99.0 | 93.8 | 76.0 | 149.0 | 143.9 | 15.0 | 3.0 | 1.0 | 926.0 | 537.0 | 10470877.8 | 0.0 | |||||||||
| 102509 | 102509 | 2017 | 4,409,936 | 61-45 188 Street | 61 188 Street | Retail Store | 84,060 | 51.5 | 50.9 | 77.9 | 75.6 | 75.1 | 4.0 | 874.0 | 256.0 | 2.0 | 134.0 | 738000.0 | 0.0 | |||||||||
| 102693 | 102693 | 2017 | 2,872,715 | 360 Amsterdam | MANHATTAN | 360 Amsterdam Avenue | Retail Store | 1,650 | 535.8 | 547.5 | 36.4 | 1.0 | 1.0 | 884.0 | 884.0 | 259.0 | 0.0 | |||||||||||
| 103426 | 103426 | 2017 | 2,976,779 | #6150 Staten Island East | STATEN IS | 545 Targee St. | Retail Store | 78,894 | 52.0 | 103.9 | 109.8 | 107.8 | 219.0 | 223.7 | 8.0 | 4.0 | 1.0 | 4.0 | 0.0 | |||||||||
| 103427 | 103427 | 2017 | 2,976,816 | #1220 Woodhaven Blvd/Queens | QUEENS | 75-11 Woodhaven Blvd | Retail Store | 121,731 | 49.0 | 94.7 | 99.5 | 94.5 | 222.1 | 226.0 | 11.0 | 7.0 | 2.0 | 4.0 | 0.0 | |||||||||
| 103428 | 103428 | 2017 | 2,976,834 | #1214 Flushing | QUEENS | 131-35 Avery Ave. | Retail Store | 122,750 | 57.0 | 87.5 | 95.9 | 201.2 | 10.0 | 6.0 | 1.0 | 4.0 | 0.0 | |||||||||||
| 103429 | 103429 | 2017 | 3,065,257 | #6152 Starrett City | BROOKLYN | 579 Gateway Drive | Retail Store | 125,942 | 66.0 | 69.1 | 86.2 | 172.1 | 8.0 | 6.0 | 1.0 | 2.0 | 0.0 | |||||||||||
| 103430 | 103430 | 2017 | 3,065,498 | #1215 Ozone Park | QUEENS | 11220 Rockaway Blvd | Retail Store | 122,384 | 51.0 | 86.9 | 88.3 | 210.1 | 10.0 | 6.0 | 2.0 | 3.0 | 0.0 | |||||||||||
| 103431 | 103431 | 2017 | 3,066,772 | #1255 Long Island City | QUEENS | 50-10 Northern Boulevard | Retail Store | 136,026 | 45.0 | 100.6 | 105.7 | 95.7 | 230.4 | 235.8 | 13.0 | 8.0 | 2.0 | 5.0 | 0.0 | |||||||||
| 103432 | 103432 | 2017 | 3,066,775 | #1225 Brooklyn | BROOKLYN | 550 Hamilton Avenue | Retail Store | 138,741 | 38.0 | 137.1 | 146.4 | 119.3 | 259.9 | 269.7 | 19.0 | 7.0 | 2.0 | 11.0 | 0.0 | |||||||||
| 103433 | 103433 | 2017 | 3,066,791 | #1238 Springfield Gardens | QUEENS | 13220 Merrick Blvd | Retail Store | 125,460 | 63.0 | 74.4 | 77.0 | 89.1 | 175.2 | 177.5 | 9.0 | 5.0 | 1.0 | 3.0 | 0.0 | |||||||||
| 103434 | 103434 | 2017 | 3,068,204 | #1256 Cropsey | BROOKLYN | 2970 Cropsey Avenue | Retail Store | 133,137 | 52.0 | 79.2 | 82.1 | 82.2 | 202.2 | 204.4 | 10.0 | 7.0 | 2.0 | 2.0 | 0.0 | |||||||||
| 103435 | 103435 | 2017 | 3,068,497 | #1249 Staten Island | STATEN IS | 2501 Forest Avenue | Retail Store | 122,661 | 55.0 | 81.9 | 87.9 | 200.7 | 10.0 | 6.0 | 1.0 | 3.0 | 0.0 | |||||||||||
| 103436 | 103436 | 2017 | 3,068,525 | #1277 College Point | QUEENS | 31-44 125 Street | Retail Store | 116,592 | 57.0 | 93.8 | 98.4 | 103.1 | 200.5 | 203.5 | 10.0 | 5.0 | 1.0 | 5.0 | 0.0 | |||||||||
| 103437 | 103437 | 2017 | 3,497,772 | #6877 Bruckner Blvd and Brush | BRONX | 2550 Bruckner Boulevard | Retail Store | 135,743 | 69.0 | 62.3 | 64.6 | 80.8 | 165.3 | 167.7 | 8.0 | 6.0 | 1.0 | 1.0 | 0.0 | |||||||||
| 103438 | 103438 | 2017 | 3,528,195 | #1221 Bronx | BRONX | 1806 East Gun Hill Road | Retail Store | 115,459 | 65.0 | 68.7 | 68.1 | 84.1 | 179.5 | 177.7 | 7.0 | 5.0 | 1.0 | 1.0 | 0.0 | |||||||||
| 103439 | 103439 | 2017 | 4,950,125 | #1281 STATEN ISLAND | STATEN IS | 2750 Veterans Road West | Retail Store | 146,485 | 100.0 | 30.1 | 130.7 | 52.1 | 4.0 | 1.0 | 421.0 | 2.0 | 0.0 | |||||||||||
| 103440 | 103440 | 2017 | 4,950,206 | #6844 BULOVA/QUEENS | QUEENS | 73-01 25th Avenue | Retail Store | 100,944 | 54.0 | 85.7 | 89.9 | 90.8 | 205.3 | 208.4 | 8.0 | 5.0 | 1.0 | 3.0 | 0.0 | |||||||||
| 103584 | 103584 | 2017 | 4,733,225 | 616-620 West 46th Street | MANHATTAN | 616-620 West 46th Street | Retail Store | 52,500 | 68.8 | 78.5 | 100.8 | 78.1 | 88.0 | 3.0 | 212.0 | 62.0 | 3.0 | 0.0 | ||||||||||
| 103884 | 103884 | 2017 | 4,954,133 | Gateway Center - Home Depot | BROOKLYN | 579 Gateway Drive | Retail Store | 135,403 | 105.8 | 105.8 | 101.2 | 119.7 | 119.7 | 14.0 | 557.0 | 163.0 | 13.0 | 0.0 | ||||||||||
| 103891 | 103891 | 2017 | 6,219,313 | Ferguson 2623 | QUEENS | 57-10 49 Place | Retail Store | 87,810 | 7.0 | 162.9 | 180.2 | 83.6 | 261.8 | 278.8 | 14.0 | 3.0 | 1.0 | 10.0 | 0.0 | |||||||||
| 103892 | 103892 | 2017 | 6,228,079 | Ferguson 2624 | MANHATTAN | 207 East 119th Street | Retail Store | 31,848 | 99.0 | 13.6 | 13.8 | 48.3 | 38.0 | 38.1 | 432.0 | 361.0 | 106.0 | 70.0 | 0.0 | |||||||||
| 104253 | 104253 | 2017 | 4,222,831 | Forest Avenue S.C. | STATEN IS | 1489 Forest Avenue | Retail Store | 198,430 | 72.0 | 65.0 | 65.0 | 89.4 | 174.0 | 173.1 | 12.0 | 10.0 | 2.0 | 2.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");