Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHGI (kgCO2e/m²), and fuel use by type. Filter using the column boxes or left-side facets. Export to CSV or JSON.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

92 rows where Calendar Year = 2010 and Property Type = "Retail" 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

  • Retail · 92 ✖

Calendar Year 1

  • 2010 · 92 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Postal Code Property Type Floor Area (ft2) Year Built Number of Buildings ENERGY STAR Score Site EUI (kBtu/ft2) Weather Norm Site EUI (kBtu/ft2) Source EUI (kBtu/ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Electricity (kBtu) Natural Gas Use (kBtu) District Steam Use (kBtu) Fuel Oil #2 Use (kBtu) Fuel Oil #4 Use (kBtu) Fuel Oil #5 & 6 Use (kBtu) Water Use (kgal) BBL BIN
56 56 2010 2685453 32-75 Steinway St. QUEENS 32-75 Steinway St. 11,103 Retail 47,845     100 42.9 42.9 43.4 151.11 34607.08 151.11   0.0 0.0     2.0     4006760010 4530777
626 626 2010 2707995 Esquire - 660 Madison Ave MANHATTAN 660 Madison Avenue 10,065 Retail 475,893     8 235.1 220.1 484.5 9.0 203.95   9.0 44.0   67.0         1013757502 1040808
983 983 2010 1444034 Bloomingdale's - 59th Street MANHATTAN 1000 Third Avenue 10,022 Retail 958,374     1 27.0 28.0 33.0 2.0 22.47 51.92 2.0 67.0 976.0 25.0       39.0 1013940023 1041904
984 984 2010 1397939 Bloomingdale's - SoHo MANHATTAN 504 Broadway 10,012 Retail 121,976     64 77.7 75.9 253.6 876.91 78008.03 16.52 860.39 9.0 310.0           1004830007 1079922
1322 1322 2010 2814410 38 East 19th Street MANHATTAN 38 East 19th Street 10,003 Retail 132,400     0 106.0 106.0 353.9 1.0 81.54   1.0 14.0             1008470027 1080755
1464 1464 2010 2716808 1-5 Bond Street MANHATTAN 1-5 Bond Street 10,012 Retail 53,047     0 99.8 96.2 216.1 386.65 78525.7 144.23 242.42 2.0 2.0           1005297504 1008423
1508 1508 2010 2687535 3861 Nostrand Ave   3861 Norstrand Ave 11,235 Retail 80,303     0 201.0 198.4 545.0 1.0 134.55 235.11 1.0 11.0 4.0              
1942 1942 2010 2606288 980 Madison Avenue MANHATTAN 980 Madison Avenue 10,075 Retail 121,490     65 87.4 85.8 262.5 972.03 86469.7   972.03 8.0   1.0         1013910014 1041796
2132 2132 2010 2717377 4000-4026 Boston Road BRONX 4000-4026 Boston Road 10,475 Retail 76,000     0 3.9 3.8 8.9 22.23 3148.44 7.11 15.11 160.0 133.0           2052630059 2072483
2475 2475 2010 2721035 2501 Grand Concourse BRONX 2501 Grand Concourse 10,469 Retail 264,720     0 95.1 87.6 193.4 1.0 40.77 763.88 1.0 10.0 14.0           2031670001 2013811
2890 2890 2010 2790322 Amsterco 67, LLC MANHATTAN 145 West 67th Street 10,023 Retail                                     1011390001 1028849
3745 3745 2010 2675612 305 East 24th Street Owners Corp. MANHATTAN 305 East 24th Street 10,010 Retail 2,100     0                             1009300001 1020599
4016 4016 2010 2662836 9030 Metropolitan QUEENS 9030 Metropolitan Ave 11,374 Retail 64,868     29 116.8 116.4 337.1 650.29 109369.63 79.61 570.68 6.0 1.0           4038840034 4095021
4245 4245 2010 2798639 727 Fifth Avenue MANHATTAN 727 Fifth Avenue 10,022 Retail 0     0 0.0 0.0 0.0                     86.2 1012920069 1035792
4593 4593 2010 2506582 0174-NewYork0174,NY MANHATTAN 100 West 33rd St 10,001 Retail 153,459     93 56.7 56.7 189.5 817.34 57501.74   817.34 8.0             1008080040 1015190
4595 4595 2010 1160893 2718-Bronx,NY BRONX 100 Baychester Ave 10,475 Retail 166,320     71 82.3 81.1 256.3 1.0 64.84 72.45 1.0 12.0 1.0           2051410003 2087397
4596 4596 2010 1160897 2814-Elmhurst,NY QUEENS 9259 59th Ave 11,373 Retail 204,340     81 56.2 54.6 186.8 1.0 52.76 3.48 1.0 11.0 65.0           4018600102 4530817
4597 4597 2010 1160595 STATEN ISLAND, NY-2463 STATEN IS 140 MARSH AVE 10,314 Retail 179,200     72 60.7 59.7 183.1 958.93 57663.84 81.58 877.35 9.0 1.0           5024000210 5127910
4766 4766 2010 2721867 WIN DEPOT QUEENS 42 42 NORTHERN BLVD 11,101 Retail 45,500     0 66.6 68.4 141.6 219.22 52436.94 85.39 133.83 1.0 1.0         603.5    
4783 4783 2010 2692299 Lowe's #1583-NW Staten Island, NY STATEN IS 2171 Forest Avenue 10,303 Retail 155,236     60 64.0 62.9 199.4 893.32 62036.18 51.54 841.78 8.0 968.0           5012500011 5141899
4784 4784 2010 2692289 Lowe's #1674-Brooklyn, NY BROOKLYN 118 2nd Avenue 11,215 Retail 159,379     49 80.2 79.2 258.5 1.0 67.7 34.65 1.0 12.0 651.0           3010070118 3022201
4810 4810 2010 2718325 Harlem USA MANHATTAN 300 West 125th Street 10,027 Retail 285,000     52 95.6 89.7 288.8 2.0 75.54 202.96 2.0 23.0 3.0           1019510022 1059298
4856 4856 2010 2640532 585 Dekalb BROOKLYN 585 Dekalb Avenue 11,205 Retail 162,999     41 99.3 101.6 276.3 1.0 66.44 209.08 1.0 12.0 3.0           3017640001 3049016
4905 4905 2010 2653163 22 West 34th (W10) MANHATTAN 22 WEST 34 STREET 10,001 Retail 68,000     0 106.5 100.4 355.7 680.08 107651.66   680.08 7.0   1.0         1008350056 1083636
4922 4922 2010 2646602 (71001A) Queens-Rego Park QUEENS 90-15 Queens Blvd 3 North West 11,373 Retail 375,888     90 40.7 40.1 135.9 1.0 28.7 0.4 1.0 15.0 7.0         3.0 4018600100 4045999
4923 4923 2010 2646603 (71002A) Brooklyn BROOKLYN 420 Fulton Street 11,201 Retail 1,157,000     0                           13.0 3001560013 3000442
4924 4924 2010 2646585 (71003A) Herald Square MANHATTAN 455 7th Ave 10,001 Retail 2,169,496     80 78.4   211.6 14.0 75347.3 2.0 11.0 122.0 47.0           1008100001 1015219
4925 4925 2010 2646588 (71007A) Staten Island STATEN IS 100 Richmond Hill Road 10,314 Retail 271,643     76 106.6 100.3 203.5 1.0 39.72 961.89 1.0 10.0 18.0              
4926 4926 2010 2646593 (71022A) Parkchester BRONX 1409 Metropolitan Ave 10,462 Retail 200,779     84 36.4 34.5 121.5 685.91 36915.33   685.91 7.0             2039377501 2096624
4928 4928 2010 2646978 (71136A) Staten Island Furniture STATEN IS 112 Richmond Hill Road 10,314 Retail 50,896     41 53.2 52.1 177.6 254.1 54702.14   254.1 2.0             5024000118 5039657
4929 4929 2010 2646998 (71168A) Douglaston   2402-02 61st Ave 11,362 Retail 157,745     64 61.9 60.2 183.1 850.51 58310.86 86.75 763.76 8.0 1.0              
4930 4930 2010 2647009 (71185A) Flushing QUEENS 136-50 Roosevelt Ave 11,364 Retail 276,732     89 36.0 34.5 117.7 922.24 35967.03 15.76 906.48 9.0 296.0         4.0 4050190024 4113551
5385 5385 2010 2749777 181st Washington Hts Associates LLC MANHATTAN 600-614 W 181 St 10,033 Retail 79,575     61 71.7 72.8 201.1 481.61 65620.28 71.06 410.54 4.0 1.0           1021620063 1063910
5437 5437 2010 2655817 CBRE- 306 E 61st St MANHATTAN 306 E 61st St 10,065 Retail 66,007     85 43.6 42.3 93.5 247.91 40431.49 116.39 131.53 1.0 21.0       1.0   1014350044 1044217
5634 5634 2010 2681207 Peartree Square BRONX 691 Co-Op City Boulevard 10,475 Retail 139,646     68 110.0 108.3 367.4 1.0 77.44   1.0 15.0             2051410394 2118946
5969 5969 2010 1775104 College Point Retail Center QUEENS 135-05 20th Ave 11,356 Retail 331,130     3 84.3 81.5 281.5 2.0 65.04   2.0 27.0             4041430001 4462119
5972 5972 2010 2721100 Gateway Center Bronx 560 Exterior St. BRONX 560 Exterior Street 10,451 Retail 186,000     100 5.0 5.2 12.9 75.02 4341.44 17.2 57.82 615.0 323.0           2023560020 2001147
5973 5973 2010 2721101 Gateway Center Bronx 610 Exterior St. BRONX 610 Exterior Street 10,451 Retail 186,000     1 270.3 275.4 728.9 4.0 231.48 750.08 3.0 36.0 14.0           2023570035 2119100
5974 5974 2010 2721111 Gateway Center Bronx 651 River Ave BRONX 651 River Avenue 10,451 Retail 186,000     79 48.9 48.9 159.5 840.93 48664.98 16.08 824.85 8.0 302.0           2023570040 2119101
5975 5975 2010 2721102 Gateway Center Bronx 700 Exterior St. BRONX 700 Exterior Street 10,451 Retail 186,000     2 222.5 224.8 635.7 3.0 173.61 463.54 3.0 32.0 8.0           2023570045 2119099
5976 5976 2010 1775094 Gateway Center Brooklyn BROOKLYN 501 Gateway Drive 11,239 Retail 637,985     4 82.9 80.0 276.8 4.0 67.59   4.0 52.0             3044520520 3348833
5981 5981 2010 2721113 Hub Retail/Office Center 2994 3rd Ave BRONX 2994 3rd Ave 10,455 Retail 57,660     98 21.6 22.1 72.2 116.95 22084.88   116.95 1.0             2023630016 2001182
5982 5982 2010 2721129 Hub Retail/Office Center 3018 3rd Ave BRONX 3018 3rd Avenue 10,455 Retail 57,660     96 25.5 26.0 85.0 137.82 26025.98   137.82 1.0             2023630024 2117395
5983 5983 2010 2721131 Hub Retail/Office Center 3020 3rd Ave BRONX 3020 3rd Avenue 10,455 Retail 57,660     23 106.9 104.1 318.4 539.15 101813.28 51.71 487.44 5.0 972.0           2023630024 2117395
6023 6023 2010 1770628 Union Square South MANHATTAN 1 Union Square South 10,003 Retail 473,516     0 86.7 88.1 217.1 3.0 68.27 796.54 2.0 26.0 14.0           1005659021 1087083
6148 6148 2010 2686505 Graphics Seven Condominium MANHATTAN 217 West 25 street 10,001 Retail 0     0 0.0 0.0 0.0                       1007757501 1014211
6667 6667 2010 2671527 Manhattan Ford Lincoln MANHATTAN 787 11th Avenue 10,019 Retail 411,845     83 61.5 59.2 118.8 1.0 26.19 839.03 918.17 9.0 15.0   534.0       1011020029 1027156
6804 6804 2010 1548267 STATEN ISLAND (2006) STATEN IS 2900 VETERANS RD W 10,309 Retail 143,876     72 76.5 75.7 221.1 945.48 71168.2 114.89 830.58 8.0 2.0           5074810001 5149742
6805 6805 2010 1547633 COLLEGE POINT (1150) QUEENS 13505 20TH AVE 11,356 Retail 139,899     72 85.0 86.8 237.8 1.0 77.44 149.53 852.36 9.0 2.0           4041430001 4462119
6829 6829 2010 2271555 Pratt Store BROOKLYN 550 Myrtle Ave 11,205 Retail 15,000     0 56.8 56.8 136.7 65.9 47289.4 18.51 47.39 504.0 348.0           3019050120 3395391
6874 6874 2010 1547842 QUEENS PLACE (1344) QUEENS 8801 QUEENS BLVD 11,373 Retail 238,504     86 57.7 57.1 151.6 999.22 45191.19 21.66 977.56 9.0 407.0           4018437501 4437281
7045 7045 2010 2808024 Austin Street   69-30 - 7000 Austin Street 11,375 Retail 78,938     0 431.6 431.6 661.7 2.0 276.0 1.0 678.18 7.0 26.0              
7051 7051 2010 2788856 Jackson Heights Shopping Center   75-05 - 75-79 31st Avenue 11,370 Retail 120,840     1 37.0 37.0 39.0 238.0 21348.4 237.0 1.0 14.0 4.0              
7275 7275 2010 2598106 1540 Broadway MANHATTAN 1540 Broadway 10,036 Retail 169,173     1 527.7 513.6 1.0 8.0 509.53 381.94 7.0 82.0 7.0           1009987501 1076844
7277 7277 2010 2785849 1750 - 1780 Gun Hill Road BRONX 1750 - 1780 E Gun Hill Rd 10,469 Retail 138,835     90 69.4 71.0 140.4 679.35 52988.81 294.47 384.88 4.0 5.0           2044940001 2118930
7280 7280 2010 2598139 201 E 66th Street MANHATTAN 201 E 66th Street 10,065 Retail 24,890     1 124.2 120.3 414.9 290.31 130202.83   290.31 3.0             1014210001 1043872
7282 7282 2010 2797549 25 West 14th Street MANHATTAN 25 W 14th St 10,011 Retail 60,582     17 132.5 133.2 373.9 679.8 121954.99 96.48 583.32 6.0 1.0           1008160023 1015290
7287 7287 2010 2785927 40 East 14th Street MANHATTAN 40 E 14th Street 10,003 Retail 206,442     4 240.7 233.6 582.0 3.0 156.76 1.0 2.0 29.0 19.0           1005650011 1009216
7289 7289 2010 2598113 478-482 Broadway MANHATTAN 478-482 Broadway 10,013 Retail 55,015     0 107.2 104.7 358.1 553.73 108368.99   553.73 5.0             1004730010 1079887
7298 7298 2010 2598145 828-850 Madison MANHATTAN 828-850 Madison Ave 10,021 Retail 16,692     75 40.2 40.2 134.3 63.02 42396.31   63.02 671.0             1013847502 1041297
7301 7301 2010 2598293 Rego II QUEENS 61-35 Junction Blvd 11,374 Retail 623,684     58 79.0 79.0 264.0 4.0 69.11   4.0 49.0             4020807501 4615634
7305 7305 2010 2653920 Bruckner Plaza II   White Plains Rd / Turnbull Ave 10,473 Retail 230,671     54 94.6 91.2 282.5 1.0 46.8 178.69 1.0 18.0 3.0              
7307 7307 2010 2598358 Flushing QUEENS 13620 Roosevelt Ave 11,354 Retail 166,738     100 8.9 8.9 28.3 135.11 8760.91 5.18 129.93 1.0 97.0           4050190005 4113546
7308 7308 2010 2598400 Forest Plaza STATEN IS 2040 Forest Ave 10,303 Retail 165,076     91 35.1 33.6 117.3 544.3 35507.82   544.3 5.0             5016960008 5110626
7310 7310 2010 2605702 KP - Lowe's   Avenue U and Flatbush Avenue 11,234 Retail 114,000     65 174.3 174.3 182.5 1.0 94.42 1.0   0.0 19.0              
7311 7311 2010 2605687 KP - Macy's   Avenue U and Flatbush Avenue 11,234 Retail 339,000     93 97.6 97.6 102.2 1.0 31.75 1.0   0.0 33.0              
7312 7312 2010 2605707 KP - Mall   Avenue U and Flatbush Avenue 11,234 Retail 620,442     38 428.5 412.1 448.6 14.0 243.06 14.0   0.0 265.0              
7313 7313 2010 2605688 KP - Sears   Avenue U and Flatbush Avenue 11,234 Retail 289,215     95 85.5 85.5 89.5 1.0 37.25 1.0   0.0 24.0              
7315 7315 2010 2598405 Queens Boulevard QUEENS 99-01 Queens Boulevard 11,374 Retail 56,916     65 55.1 55.1 184.0 294.37 56581.59   294.37 3.0             4021180001 4050967
7316 7316 2010 2797575 Rego Park QUEENS 96-31 Queens Boulevard 11,374 Retail 342,728     54 79.9 78.4 267.0 2.0 62.95   2.0 27.0                
7317 7317 2010 2598283 The Lucida MANHATTAN 151 E 85th St 10,028 Retail 95,554     54 66.9 66.9 223.4 600.13 67997.26   600.13 6.0             1015147502 1088463
7420 7420 2010 2678668 Harlem Center MANHATTAN 105 W. 125 Street 10,027 Retail 124,622     0 55.6 55.1 179.5 1.0 86.81 40.02 1.0 14.0 752.0           1019107501 1085673
7715 7715 2010 2038302 1114 BROOKLYN 2307 BEVERLEY RD 11,226 Retail 187,823     80 59.6 62.5 141.1 857.94 49383.85 252.89 605.06 6.0 4.0           3051330014 3117881
7716 7716 2010 2037331 1143 BROOKLYN 5200 KINGS PLAZA 11,234 Retail 283,387     91 29.3 29.3 97.8 779.07 29631.91 0.24 778.84 8.0 4.0         1.0 3084700055 3326830
7717 7717 2010 2038377 1544 QUEENS 9605 QUEENS BLVD 11,374 Retail 197,645     66 58.4 58.5 173.1 1.0 54.64 101.55 905.37 9.0 1.0           4020840101 4050415
7718 7718 2010 2037421 1624 STATEN IS 283 PLATINUM AVE 10,314 Retail 188,744     81 47.2 45.2 133.5 791.07 45292.54 139.2 651.86 6.0 286.0   1.0       5024000375 5039660
7741 7741 2010 2345461 3201 STATEN IS 2660 Hylan Blvd 10,306 Retail 101,445     64 59.3 57.8 172.7 519.2 55332.84 59.92 459.29 4.0 1.0              
7742 7742 2010 2343247 4248 STATEN IS 2875 Richmond Ave 10,314 Retail 93,600     65 56.1 53.2 184.2 487.54 56428.3 6.67 480.87 5.0 125.0           5024600001 5127010
7743 7743 2010 2344695 7654 BRONX 300 Baychester Avenue 10,475 Retail 134,028     67 57.2 55.9 182.4 699.33 56175.51 26.83 672.5 7.0 504.0           2051410020 2102451
7744 7744 2010 2343724 7777 MANHATTAN 770 Broadway 10,003 Retail 154,099     42 70.0 68.5 233.6 1.0 69.9   1.0 10.0             1005540001 1008952
7745 7745 2010 2343744 9419 QUEENS 66-26 Metropolitan Ave 11,379 Retail 139,755     48 68.7 68.7 229.6 901.96 69846.1   901.96 9.0             4036050001 4443103
7746 7746 2010 2344723 9420 BRONX 1998 Bruckner Blvd 10,473 Retail 171,476     35 86.7 83.6 267.3 1.0 62.95 89.11 1.0 13.0 1.0           2036730001 2094839
8288 8288 2010 2789702 001. 1600-1652 Bruckner Blvd. BRONX 1600 - 1652 Bruckner Blvd. 10,473 Retail 77,616     0 370.6 366.0 856.7 2.0 279.58 686.27 1.0 15.0 12.0           2036530050 2094831
8302 8302 2010 2789705 12/525 Nepperhan Ave   525 Nepperhan Avenue 10,703 Retail 14,760     0 129.7 133.4 208.5 120.87 92930.9 76.95 43.92 467.0 1.0              
8688 8688 2010 2812767 Abeco 162-11 Jamaica QUEENS 162-11 Jamaica Ave 11,432 Retail 57,325     24 92.9 92.9 310.4 500.23 94463.61   500.23 5.0             4097610095 4540158
8689 8689 2010 2812379 Abeco 785 Flushing BROOKLYN 785 Flushing Ave 11,206 Retail 130,000     10 92.9 92.9 310.4 1.0 82.8   1.0 12.0             3031270001 3326062
8737 8737 2010 2809775 1239BWAY MANHATTAN 1239 Broadway 10,001 Retail 205,997     97 51.8 50.0 86.4 845.6 44399.77 562.76 282.84 3.0       7.0     1008320001 1082273
8957 8957 2010 2814713 Parkseen Realty MANHATTAN 230 W 125 St 10,027 Retail 148,355     30 92.9 92.9 310.4 1.0 72.73   1.0 13.0             1019300044 1058644
9153 9153 2010 2771229 259-19 Union Tpke QUEENS 259-19 Union Tpke 11,004 Retail 145,918     16 85.4 86.0 244.8 1.0 74.23 136.79 928.25 9.0 2.0           4085130002 4439455
9862 9862 2010 2791438 (7062) - Silk Building Condominium MANHATTAN 14 E 4th St 10,012 Retail 156,849     0 82.8 84.5 167.3 915.15 63144.76 397.31 517.84 5.0 7.0           1005317501 1008529
9976 9976 2010 2816070 Musso Properties   249-00 - 249-46 Horace harding Expressway 11,362 Retail 50,900     13 122.0 123.4 356.2 536.76 115552.62 60.65 476.11 5.0 1.0              
10280 10280 2010 2816270 Paragon Sports MANHATTAN 867 Broadway 10,003 Retail 52,810     0                             1008460060 1016138

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE summary(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Postal Code" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Year Built" TEXT,
  "Number of Buildings" TEXT,
  "ENERGY STAR Score" TEXT,
  "Site EUI (kBtu/ft2)" REAL,
  "Weather Norm Site EUI (kBtu/ft2)" REAL,
  "Source EUI (kBtu/ft2)" REAL,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Electricity (kBtu)" REAL,
  "Natural Gas Use (kBtu)" 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,
  "Water Use (kgal)" REAL,
  BBL TEXT,
  BIN TEXT
);
CREATE INDEX "idx_summary_Calendar Year" ON [summary] ("Calendar Year");
CREATE INDEX "idx_summary_Property ID" ON [summary] ("Property ID");
CREATE INDEX "idx_summary_Borough" ON [summary] ("Borough");
CREATE INDEX "idx_summary_Property Type" ON [summary] ("Property Type");
CREATE INDEX "idx_summary_Postal Code" ON [summary] ("Postal Code");