home / nyc_ll84

Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHG intensity (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

274 rows where Calendar Year = 2017 and Property Type = "Retail Store" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Number of Buildings, District Steam Use (kBtu), Fuel Oil #2 Use (kBtu)

Borough 5

  • BROOKLYN 64
  • QUEENS 61
  • MANHATTAN 58
  • BRONX 49
  • STATEN IS 27

Property Type 1

  • Retail Store · 274 ✖

Calendar Year 1

  • 2017 · 274 ✖
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
94865 94865 2017 6,182,209 Staples QUEENS 24-41 31st St 11102 Retail Store 14,700 1961 1 30 81.4 82.1 235.0 101.0 77653.85 7.7 93.2 1.0 145.0         74.1    
94869 94869 2017 2,804,420 Jamaica Ave Property QUEENS 163-19 Jamaica Ave 11432 Retail Store 54,978 1952 1 90 38.9 39.7 104.6 181.5 36178.66 32.1 149.4 1.0 79.0   376.0       4-09793-0001 4209572
95072 95072 2017 6,227,760 C21 Bay Ridge Blue LLC BROOKLYN 441 87th St 11209 Retail Store 30,000 1922 1   99.9 99.3 313.6 265.6 95296.39 0.0 265.6 2.0           757.6 3/06045/0051 6227760
95159 95159 2017 6,227,961 C21 BK Home LLC Campus BROOKLYN 423 88th St 11209 Retail Store 78,379 1922 4   117.8 120.3 333.1 769.5 106190.01 73.0 696.5 7.0 1.0         1.0 3/06050/0051  
95160 95160 2017 6,227,962 415 88th st BROOKLYN 423 88th St 11209 Retail Store 15,290 1922 1         0.0 0.0 0.0 0.0               3/6050/0059 6227962
95161 95161 2017 6,227,966 436 87th st BROOKLYN 423 88th St 11209 Retail Store 20,125 1922 1         0.0 0.0 0.0 0.0               3/06050/0019 6227966
95162 95162 2017 6,227,968 416 87th St BROOKLYN 423 88th St 11209 Retail Store 27,464 1922 1         0.0 0.0 0.0 0.0               3/0650/0015 6227968
95307 95307 2017 6,231,315 2241 WESTCHESTER AVENUE - 33697 BRONX 2241 WESTCHESTER AVENUE 10462 Retail Store 26,827 1990 1   132.6 133.9 306.7 265.4 109874.58 74.9 190.5 2.0 1.0         1.0 2-03963-0057 2041407
95877 95877 2017 6,289,129 Cameo Holding QUEENS 45-01 Greenpoint Avenue 11104 Retail Store 30,500 1931 1 100 0.1 0.1 0.4 0.4 143.52 0.0 0.4 4.0           2.0    
96122 96122 2017 4,742,798 6001-New York MANHATTAN 424 Fifth Ave 10018 Retail Store 796,488 2000 1 78 55.7 58.9 135.8 3.0 40.57 51.1 3.0 28.0 961.0 15.0       13.0 1-00840-0042 1016004
96123 96123 2017 4,742,807 06601-New York, NY MANHATTAN 611 Fifth Avenue 10022 Retail Store 661,000 2000 1 26 120.5 123.2 296.3 6.0 97.71 150.8 6.0 51.0 2.0 24.0       4.0 1-01285-7501 1081145
96139 96139 2017 5,866,066 Not A Pratt Building BROOKLYN 524 Myrtle Ave 11205 Retail Store 125,000 2013 1             6.1     114.0         51.6 3-01905-7501 504524
96423 96423 2017 2,788,856 Jackson Heights Shopping Center   75-01 - 75-81 31st Avenue 11370 Retail Store 120,900 1959 1 80 86.6 85.7 271.8 927.7 83213.92 0.0 927.7 10.0     0.0       4-01124-0001 4439601;4439602
96491 96491 2017 2,788,856 Jackson Heights Shopping Center   75-01 - 75-81 31st Avenue 11370 Retail Store 120,900 1959 1 80 86.6 85.7 271.8 927.7 83213.92 0.0 927.7 10.0     0.0     9.0 4-01124-0001 4439601;4439602
96816 96816 2017 2,721,867 WIN DEPOT QUEENS 42 52 NORTHERN BLVD 11101 Retail Store 55,176 1982 1 60 62.6 68.4 114.3 229.0 44816.97 115.1 113.8 1.0 2.0         652.4 4001830146 4002368
96863 96863 2017 6,281,283 2231-2239 Broadway MANHATTAN 2231-2239 Broadway 10024 Retail Store 57,292 1899 1   114.0 118.3 263.4 487.0 91965.25 137.8 349.2 3.0 2.0           1-01227-0054 1032645
96864 96864 2017 6,281,286 3781-3799 Broadway MANHATTAN 3781-3799 Broadway 10032 Retail Store 50,560 1910 1   140.8 142.7 328.5 533.5 114850.81 146.1 387.5 4.0 2.0           1-02134-0180 1076745
97212 97212 2017 2,788,856 Jackson Heights Shopping Center   75-01 - 75-81 31st Avenue 11370 Retail Store 120,900 1959 1 80 87.0 86.2 273.2 932.7 83662.41 0.0 932.7 10.0     0.0       4-01124-0001 4439601;4439602
97422 97422 2017 6,227,961 C21 BK Home LLC Campus BROOKLYN 423 88th St 11209 Retail Store 78,379 1922 4   117.8 120.3 333.1 769.5 106190.01 73.0 696.5 7.0 1.0         1.0 3/6050/0051  
97540 97540 2017 2,856,349 Queensboro Toyota QUEENS 62-10 Northern Boulevard 11377 Retail Store 40,500 1950 1 36 133.2 144.7 222.1 343.2 92354.26 201.9 141.3 1.0 3.0         818.6 4-01185-0001  
97657 97657 2017 2,640,532 585 Dekalb BROOKLYN 585 Dekalb Avenue 11205 Retail Store 162,999 1999 1 56 83.4 86.1 210.1 1.0 66.44 214.3 847.5 9.0 4.0         2.0 3017640001 3049016
97679 97679 2017 1,296,056 10782-Staten Island   2239 Forrest Avenue 10303 Retail Store 91,047 2004 1 78 42.1 42.6 127.3 332.2 39294.15 11.0 321.2 3.0 207.0         1.0 5012500090 5141900
97893 97893 2017 2,788,856 Jackson Heights Shopping Center   75-01 - 75-81 31st Avenue 11370 Retail Store 120,900 1959 1 80 87.0 86.2 273.2 932.7 83662.41 0.0 932.7 10.0     0.0       4-01124-0001 4439601;4439602
98205 98205 2017 5,245,875 1363-1377 Jerome Ave BRONX 1363-1377 Jerome Ave 10452 Retail Store 52,250 1966 1 52 81.4 84.3 198.9 326.8 67646.97 75.5 251.3 2.0 1.0         656.0 2-02856-0020 2008289
98252 98252 2017 4,939,723 380 Lafayette Street MANHATTAN 380 Lafayette Street 10003 Retail Store 50,000 1906 1 1 283.9 287.0 571.4 1.0 215.28 441.4 582.4 6.0 5.0     1.0     1-00531-7504 1008509
98274 98274 2017 4,959,515 9 Bond St BROOKLYN 9 Bond St 11201 Retail Store 180,350 1920 1   102.3 105.2 251.4 1.0 59.8 319.8 1.0 12.0 6.0           3-00160-0007 3329441
98387 98387 2017 6,266,163 42-01 Main Street - 39886 QUEENS 42-01 Main Street 11355 Retail Store 25,500 1952 1   92.9 92.9 291.8 210.1 90459.82 0.0 210.1 2.0             4-05135-0001 4115775
98517 98517 2017 2,816,270 Paragon Sports MANHATTAN 867 Broadway 10003 Retail Store 52,810 1882 1 87 98.5   285.4 448.8 92900.74 40.5 408.3 4.0 183.0   414.0     1.0 1-00846-0060 1016138
98554 98554 2017 6,289,129 Cameo Holding QUEENS 45-01 Greenpoint Avenue 11104 Retail Store 30,500 1931 1 100 0.1 0.1 0.4 0.4 143.52 0.0 0.4 4.0           2.0 164001 4001953
98676 98676 2017 5,724,440 Tiffany & Co. MANHATTAN 727 5th Ave 10022 Retail Store 117,232 1939 1 53 199.7   481.2 1.0 92.0 8.5 1.0 14.0 160.0 8.0       3.0 1012920069 1035792
98723 98723 2017 3,346,714 11962-NEW YORK, NY MANHATTAN 1471 Broadway 10036 Retail Store 34,618 1900 1 1 358.9 374.3 891.2 1.0 316.59 0.0 1.0 8.0   4.0         1-00995-0001 1022581
99114 99114 2017 5,236,465 477 Broadway MANHATTAN 477 Broadway 10013 Retail Store 63,150 1986 1   21.4   56.7 115.2 19682.56 22.9 92.2 1.0 24.0     287.0   351.9 1-00474-0033 1007050
99433 99433 2017 2,598,113 478-482 Broadway MANHATTAN 478-482 Broadway 10013 Retail Store 55,015 1874 1   128.8   371.1 615.3 120418.68 63.3 551.9 6.0 23.0   837.0     5.0 1004730010 1079887;1079888
99434 99434 2017 2,598,358 Flushing QUEENS 13620 Roosevelt Ave 11354 Retail Store 166,738 1967 1 2 227.2 228.0 551.9 2.0 129.69 684.6 2.0 24.0 12.0         32.0 4050190005 4113546
99444 99444 2017 5,008,681 155 Spring Street MANHATTAN 155 Spring Street 10012 Retail Store 49,820 1901 1 73 57.0 59.1 144.2 239.9 52699.18 60.1 179.8 2.0     809.0     1.0 1-00501-7502 1007722
99445 99445 2017 5,010,097 150 West 34th Street MANHATTAN 150 West 34th Street 10001 Retail Store 77,760 1901 1 21 102.2 102.2 311.4 691.9 96721.33 18.8 673.1 7.0 353.0         1.0 1008090069 1015211
99449 99449 2017 5,287,312 435 Seventh Avenue MANHATTAN 435 Seventh Avenue 10001 Retail Store 42,769 1905 1 9 186.9 188.4 544.4 677.8 173708.84 46.0 631.8 7.0 865.0         274.1 1-00809-0080 1015217
99459 99459 2017 2,785,927 40 East 14th Street MANHATTAN 40 E 14th Street 10003 Retail Store 206,442 1971 1 18 171.6 171.6 429.4 2.0 104.5 574.7 2.0 24.0 10.0         11.0 1005650011 1009216;1009213
99464 99464 2017 5,306,558 692 Broadway MANHATTAN 692 Broadway 10012 Retail Store 182,605 1912 1   81.3 86.3 164.9 1.0 59.14 420.2 615.5 6.0 7.0         2.0 1-00531-7501 1008529
99510 99510 2017 3,976,452 Jamestown Premier One Times Square MANHATTAN 1 Times Square 10036 Retail Store 132,920 1908 1 17 172.5 178.0 479.8 1.0 81.54 0.0 1.0 18.0   4.0       815.6 1009950001 1022581
99594 99594 2017 6,227,961 C21 BK Home LLC Campus BROOKLYN 423 88th St 11209 Retail Store 78,379 1922 4   117.8 120.3 333.1 769.5 106190.01 73.0 696.5 7.0 1.0         1.0 3/6050/0051; 3/6050/0059; 3/6050/0019; 3/6050/0015  
99608 99608 2017 1,444,034 Bloomingdale's - 59th Street MANHATTAN 1000 Third Avenue 10022 Retail Store 858,374 1886 1 76 83.3 85.7 230.2 6.0 75.27 38.4 5.0 57.0 723.0 13.0       3.0 1013940023 1041904
99609 99609 2017 2,646,585 (71003A) Herald Square Macy's MANHATTAN 441 7th Ave 10001 Retail Store 2,169,496 1902 1 85 60.0 59.8 182.7 11.0 59201.45 307.4 11.0 124.0 5.0 65.0       63.0 1-00810-0001 1015219
99610 99610 2017 2,646,588 (71007A) Staten Island Macy's - CB STATEN IS 112 Richmond Hill Road 10314 Retail Store 271,643 1972 1 74 118.7   198.4 2.0 79.44 1.0 849.2 9.0 22.0         4.0 5-02400-0118 5039657
99611 99611 2017 2,646,593 (71022A) Parkchester Macy's BRONX 1409 Metropolitan Ave 10462 Retail Store 200,779 1941 1 93 26.2 26.3 82.2 466.0 25079.89 0.0 466.0 5.0           1.0 2-03937-1011 2096624
99612 99612 2017 2,646,602 (71001A) Queens-Rego Park Macy's QUEENS 90-15 Queens Blvd 3 North West 11373 Retail Store 375,888 1973 1 94 34.8 35.2 109.2 1.0 28.7 0.4 1.0 13.0 7.0         2.0 4-01860-0100 4464148
99613 99613 2017 6,283,100 (71185A) Flushing Macy's QUEENS 136-50 Roosevelt Ave 11364 Retail Store 276,732 1951 1 88 35.8 35.9 111.6 874.0 34085.68 4.7 869.3 9.0 88.0         4.0 4050190024 4113551
99614 99614 2017 6,283,151 (72053A) Bloomingdale's - SoHo MANHATTAN 504 Broadway 10012 Retail Store 121,976 2004 1 70 70.3 72.3 214.6 747.5 66495.99 18.6 728.9 8.0 350.0         2.0 1004830007 1079922
99812 99812 2017 5,806,599 150-24 Northern Blvd QUEENS 150-24 Northern Blvd 11354 Retail Store 50,000 1997 1 5 153.0 154.6 421.3 627.9 135173.06 75.1 552.8 6.0 1.0         1.0 4-05032-0016 4114054
99857 99857 2017 3,413,981 New York Design Center MANHATTAN 200 Lexington Ave 10016 Retail Store 470,000 1960 1 90 44.2 45.8 104.7 1.0 22.9 435.8 1.0 13.0 6.0       1.0 1.0 1-00888-0020 1018473
99970 99970 2017 1,632,816 Raymour and Flanigan Elmhurst QUEENS 86-08 Queens Blvd. 11373 Retail Store 52,862 1935 1 98 32.9 36.6 59.8 115.0 23804.78 58.4 56.6 638.0 1.0         60.7 04/02851/0022  
100009 100009 2017 6,113,826 5660 Broadway (W08) BRONX 5660 Broadway 10463 Retail Store 36,778 1966 1             92.8     1.0         931.6 2032680001 2016172
101363 101363 2017 2,038,302 1114 BROOKLYN 2307 BEVERLEY RD 11226 Retail Store 187,823 1932 1 77 48.7 52.1 105.5 659.4 37955.7 226.5 432.9 4.0 4.0         762.0 3051330014 3117881
101371 101371 2017 2,343,724 7777 MANHATTAN 770 Broadway 10003 Retail Store 154,099 1996 1 69 49.8 49.7 153.6     0.0   7.0             1005540001  
101396 101396 2017 2,343,744 9419 QUEENS 66-26 Metropolitan Avenue 11379 Retail Store 139,755 1999 1 82 37.9 37.9 119.0 469.5 36357.2 0.0 469.5 5.0           0.0 4036050001 4443103
101444 101444 2017 3,119,119 3500 48 Street Owners LLC QUEENS 34-54 48 Street 11101 Retail Store 129,790 1979 1 66 91.5 95.3 227.8 921.3 76874.27 195.9 725.4 8.0 3.0           4-00143-0010 4001352;4518761;4541446;4541575
101466 101466 2017 2,037,421 1624 STATEN IS 283 PLATINUM AVE 10314 Retail Store 182,834 1973 1                               5024000375 5039660
101467 101467 2017 2,344,695 7654 BRONX 300 Baychester Avenue 10475 Retail Store 134,028 1994 1 95 38.9 38.8 117.9 452.8 36372.34 14.6 438.2 4.0 274.0         536.0 2051410020 2102451
101468 101468 2017 2,344,723 9420 BRONX 1998 Bruckner Boulevard 10473 Retail Store 171,476 1999 1 76 51.9 53.9 150.4 752.6 47373.75 55.0 697.6 7.0 1.0           2036730001 2094839
101469 101469 2017 2,712,742 7749 MANHATTAN 250 West 34th Street 10119 Retail Store 143,471 1996 1 100 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0             1007830070  
101596 101596 2017 6,272,328 40 Gansevoort St MANHATTAN 40 Gansevoort St 10014 Retail Store 47,800 2005 1 20 116.3 119.6 301.8 441.4 101089.05 77.1 364.4 4.0 1.0         1.0 1006270005 1011671
101611 101611 2017 2,981,291 The Colosseum QUEENS 89-02 165th Street 11432 Retail Store 122,000 1947 1 76 86.3 86.7 161.4 781.1 68915.43 409.0 372.1 4.0 2.0   3.0       4097940048 4209595
101680 101680 2017 5,806,599 150-24 Northern Blvd QUEENS 150-24 Northern Blvd 11354 Retail Store 50,000 1997 1 4 173.6 174.1 442.9 682.7 146970.29 129.9 552.8 6.0 2.0         1.0 4-05032-0016 4114054
101843 101843 2017 6,289,129 Cameo Holding QUEENS 45-01 Greenpoint Avenue 11104 Retail Store 30,500 1931 1 100 0.1 0.1 0.4 0.4 143.52 0.0 0.4 4.0           2.0 4001640001 4001953
102098 102098 2017 2,981,291 The Colosseum QUEENS 89-02 165th Street 11432 Retail Store 122,000 1947 1 76 86.3 86.7 161.4 781.1 68915.43 409.0 372.1 4.0 2.0   3.0     2.0 4097940048 4209595
102138 102138 2017 4,222,831 Forest Avenue S.C. STATEN IS 1489 Forest Avenue 10302 Retail Store 198,430 1957 1 72 65.0 65.0 174.0 1.0 54.36 152.2 889.9 10.0 2.0           5-01053-0138 5110054
102139 102139 2017 4,223,265 Mill Basin Plaza BROOKLYN 5702-5716 AVENUE U 11234 Retail Store 80,708 1950 1   90.6 92.4 236.8 582.9 78428.47 97.9 485.0 5.0 1.0           3-08470-0143 3238576
102140 102140 2017 4,224,270 Richmond S.C. STATEN IS 2845-2895 RICHMOND AVE AND INDEPENDENCE AVENUE 10314 Retail Store 261,148 1962 1   53.1 53.5 120.3 1.0 41.24 308.0 715.3 8.0 5.0           5-02460-0098 5127008; 5127009; 5127011; 5159252
102141 102141 2017 4,224,272 Greenridge Plaza STATEN IS 3231-3247 RICHMOND AVE. 10312 Retail Store 100,977 1974 1   104.6 109.1 169.7 663.7 71440.0 407.4 256.3 2.0 7.0           5-05533-0058 5073738
102142 102142 2017 4,224,276 The Boulevard, formerly known as Hylan Plaza STATEN IS 2626-2696 HYLAN BLVD. AND 107 MILL ROAD 10306 Retail Store 367,318 1974 2   15.6 15.6 49.0 508.1 14902.28 0.0 508.1 5.0             5-03969-0031 5055377
102143 102143 2017 6,272,320 Forest Ave Plaza STATEN IS 1520 Forest Avenue 10302 Retail Store 66,576 1971 1   34.0 36.6 81.5 172.0 28051.38 42.7 129.4 1.0 803.0         307.2 5-394-1 5011442
102181 102181 2017 3,114,416 Bruckner BRONX 2550 Bruckner Boulevard 10465 Retail Store 135,743 2006 1 67 62.3 64.3 165.3 680.1 54226.14 105.0 575.0 6.0 1.0         936.6 2-05542-0041 2116429;2090618
102182 102182 2017 3,114,433 Zerega BRONX 635 Zerega Avenue 10473 Retail Store 137,699 2001 1 87 50.1 52.9 120.8 526.2 41342.8 128.0 398.1 4.0 2.0           2-03576-0050 2114541
102183 102183 2017 4,954,132 College Point Retail Center - BJ's Wholesale Club QUEENS 137-05 20 Ave 11356 Retail Store 119,500 1998 1   162.7 170.2 374.2 1.0 90.45 415.0 1.0 11.0 7.0         2.0 4-04143-0030 4462123
102476 102476 2017 1,547,924 GATEWAY (1401) BROOKLYN 519 GATEWAY DR 11239 Retail Store 148,939 2002 1 77 103.1 108.1 221.7 1.0 72.73 386.7 716.3 8.0 7.0         174.5 3044520520 3348833
102477 102477 2017 1,548,095 RIVERDALE (1798) BRONX 40 W 225TH ST #50 10463 Retail Store 157,011 2004 1 68 97.9 100.5 262.7 1.0 68.56 178.7 1.0 12.0 3.0         31.1 2032450060 2109471
102507 102507 2017 4,409,914 187-02 Horace Harding Expressway   187 Horace Harding Expressway 11365 Retail Store 89,343 1950 3   1.0 1.0 1.0 5.0 604.71 3.0 2.0 14.0 65.0 5.0       10.0 4070750001 4439486
102508 102508 2017 4,409,927 61-11 192 Street   61 192 Street 11365 Retail Store 156,875 2000 1   99.0 93.8 149.0 1.0 69.0 49.2 1.0 3.0 926.0 537.0       3.0 4071170130 4153294
102509 102509 2017 4,409,936 61-45 188 Street   61 188 Street 11365 Retail Store 84,060 2000 3   51.5 50.9 75.6 278.2 35649.01 137.2 140.9 874.0 2.0 134.0       1.0 4071170004 4444049
102693 102693 2017 2,872,715 360 Amsterdam MANHATTAN 360 Amsterdam Avenue 10024 Retail Store 1,650 1929 1   535.8 547.5 1.0 78.4 843889.76 0.0 78.4 884.0             01-1169-0029 1030887
103426 103426 2017 2,976,779 #6150 Staten Island East STATEN IS 545 Targee St. 10304 Retail Store 78,894 2002 1 52 103.9 109.8 219.0 582.9 80439.45 215.0 368.0 4.0 4.0         842.2 5029220020 5112730
103427 103427 2017 2,976,816 #1220 Woodhaven Blvd/Queens QUEENS 75-11 Woodhaven Blvd 11385 Retail Store 121,731 2000 1 49 94.7 99.5 222.1 866.1 77046.39 232.6 633.6 7.0 4.0         1.0 4038860074 4095037
103428 103428 2017 2,976,834 #1214 Flushing QUEENS 131-35 Avery Ave. 11355 Retail Store 122,750 1995 1 57 87.5   201.2 798.9 70485.9 229.6 569.3 6.0 4.0         319.2 4050660622 4115028
103429 103429 2017 3,065,257 #6152 Starrett City BROOKLYN 579 Gateway Drive 11239 Retail Store 125,942 2002 1 66 69.1   172.1 675.4 58159.5 143.2 532.2 6.0 2.0         908.7 3044520530 3348834
103430 103430 2017 3,065,498 #1215 Ozone Park QUEENS 11220 Rockaway Blvd 11420 Retail Store 122,384 1994 1 51 86.9   210.1 812.3 71668.16 195.2 617.0 6.0 3.0         901.6 4115430100 4457718
103431 103431 2017 3,066,772 #1255 Long Island City QUEENS 50-10 Northern Boulevard 11101 Retail Store 136,026 1999 1 45 100.6 105.7 230.4 1.0 79.15 295.4 720.0 8.0 5.0         10.4 4001200050 4000825
103432 103432 2017 3,066,775 #1225 Brooklyn BROOKLYN 550 Hamilton Avenue 11232 Retail Store 138,741 1998 1 38 137.1 146.4 259.9 1.0 78.0 601.9 682.3 7.0 11.0         872.5 3006250065 3008889
103433 103433 2017 3,066,791 #1238 Springfield Gardens QUEENS 13220 Merrick Blvd 11434 Retail Store 125,460 2001 1 63 74.4 77.0 175.2 702.9 60527.56 185.9 517.0 5.0 3.0         412.3 4129990044 4279930
103434 103434 2017 3,068,204 #1256 Cropsey BROOKLYN 2970 Cropsey Avenue 11214 Retail Store 133,137 2001 1 52 79.2 82.1 202.2 829.6 67140.84 157.3 672.3 7.0 2.0         702.0 3069470500 3348838
103435 103435 2017 3,068,497 #1249 Staten Island STATEN IS 2501 Forest Avenue 10303 Retail Store 122,661 1997 1 55 81.9   200.7 772.7 68174.31 175.5 597.2 6.0 3.0         1.0 5013800155 5028665
103436 103436 2017 3,068,525 #1277 College Point QUEENS 31-44 125 Street 11354 Retail Store 116,592 2001 1 57 93.8 98.4 200.5 782.9 72647.05 278.3 504.6 5.0 5.0         803.7 4043950002 4438019
103437 103437 2017 3,497,772 #6877 Bruckner Blvd and Brush BRONX 2550 Bruckner Boulevard 10465 Retail Store 135,743 2008 1 69 62.3 64.6 165.3 679.7 54194.24 104.6 575.1 6.0 1.0         937.0 2055420041 2090618
103438 103438 2017 3,528,195 #1221 Bronx BRONX 1806 East Gun Hill Road 10469 Retail Store 115,459 1997 1 65 68.7 68.1 179.5 632.0 59154.65 105.9 526.1 5.0 1.0         2.0 2045040412 2100885
103439 103439 2017 4,950,125 #1281 STATEN ISLAND STATEN IS 2750 Veterans Road West 10309 Retail Store 146,485 2006 1 100 30.1   52.1 285.2 21026.47 157.6 127.6 1.0 2.0         854.6 5074690200 5149741
103440 103440 2017 4,950,206 #6844 BULOVA/QUEENS QUEENS 73-01 25th Avenue 11369 Retail Store 100,944 2007 1 54 85.7 89.9 205.3 657.4 70761.88 163.4 494.0 5.0 3.0         1.0 4010270004 4530769
103584 103584 2017 4,733,225 616-620 West 46th Street MANHATTAN 616-620 West 46th Street 10036 Retail Store 52,500 1920 1   68.8 78.5 78.1 271.1 56117.18 252.2 18.8 212.0     3.0     56.1 1-01093-0042 1027104
103884 103884 2017 4,954,133 Gateway Center - Home Depot BROOKLYN 579 Gateway Drive 11239 Retail Store 135,403 2001 1   105.8 105.8 119.7 780.6 62239.26 731.2 49.4 557.0 13.0         907.2 3-04452-0530 3348834
103891 103891 2017 6,219,313 Ferguson 2623 QUEENS 57-10 49 Place 11378 Retail Store 87,810 1963 1 7 162.9 180.2 261.8 895.4 110781.56 557.4 338.0 3.0 10.0         530.2 4026020200 4058973
103892 103892 2017 6,228,079 Ferguson 2624 MANHATTAN 207 East 119th Street 10035 Retail Store 31,848 1910 1 99 13.6 13.8 38.0 35.8 12430.57 3.7 32.1 361.0 70.0         14.2 1017840005 105455
104253 104253 2017 4,222,831 Forest Avenue S.C. STATEN IS 1489 Forest Avenue 10302 Retail Store 198,430 1957 1 72 65.0 65.0 174.0 1.0 54.36 152.2 889.9 10.0 2.0           5-01053-0138 5110054

Next page

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");
Powered by Datasette · Queries took 701.299ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability