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

98 rows where Borough = "MANHATTAN" and Property Type = "Retail" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Postal Code, District Steam Use (kBtu), Fuel Oil #2 Use (kBtu), Fuel Oil #4 Use (kBtu), Fuel Oil #5 & 6 Use (kBtu), Water Use (kgal)

Calendar Year 3

Property Type 1

  • Retail · 98 ✖

Borough 1

  • MANHATTAN · 98 ✖
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
23053 23053 2012 2343724 7777 MANHATTAN 770 Broadway 10,003 Retail 154099 1996   1 602.4 603.4 854.8         9121814.81 0.0 83578913.46 0.0 0.0 0.0   1005540001 1008952
23538 23538 2012 2598106 1540 Broadway MANHATTAN 1540 Broadway 10,036 Retail 169173 1990   1 611.1 607.5 1957.2         97196831.94 6183919.35 0.0 0.0 0.0 0.0   1009987501 1076844
23539 23539 2012 2598113 478-482 Broadway MANHATTAN 478-482 Broadway 10,013 Retail 55015 1874   0 150.5 150.5 392.3         5672350.06 27580.65 0.0 2579615.56 0.0 0.0   1004730010 1079887
23540 23540 2012 2598139 201 E 66th Street MANHATTAN 201 E 66th Street 10,065 Retail 24890 1961   1 257.4 254.4 800.0         5758524.3 647580.65 0.0 0.0 0.0 0.0   1014210001 1043872
23541 23541 2012 2598145 828-850 Madison MANHATTAN 828-850 Madison Ave 10,021 Retail 18231 1926   56 52.0 52.0 173.6         947322.65 0.0 0.0 0.0 0.0 0.0   1013847502 1041297
23612 23612 2012 2606288 980 Madison Avenue MANHATTAN 980 Madison Avenue 10,075 Retail 121480 1949   74 73.6 73.9 224.2         7707513.55 0.0 1229903.58 0.0 0.0 0.0   1013910014 1041796
24260 24260 2012 2646585 (71003A) Herald Square MANHATTAN 441 7th Ave 10,001 Retail 2169496 1902   87 53.2 53.2 174.2         112101380.7 3252436.62 0.0 0.0 0.0 0.0   1008100001 1015219
24444 24444 2012 2653163 22 West 34th (W10) MANHATTAN 22 WEST 34 STREET 10,001 Retail 68000 1937   0 114.4 112.2 382.1         7779629.55 0.0 1527.0 0.0 0.0 0.0   1008350056 1083636
25541 25541 2012 2671527 Manhattan Ford Lincoln MANHATTAN 787 11th Avenue 10,019 Retail 411845 1929   0 42.1 43.5 102.4         10481206.39 6838270.94 0.0 0.0 0.0 0.0   1011020029 1027156
26164 26164 2012 2686505 Graphics Seven Condominium MANHATTAN 217 West 25 street 10,001 Retail 31701 1839   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   1007757501 1014211
26442 26442 2012 2704311 1 Times Square MANHATTAN 1 Times Square 10,036 Retail 132920 1908   17 128.6 125.9 429.5         17092755.2 0.0 3223.8 0.0 0.0 0.0   1009950001 1022581
26635 26635 2012 2707995 Esquire - 660 Madison Ave MANHATTAN 660 Madison Avenue 10,065 Retail 490242 1958   7 239.1 222.4 486.5         45383650.37 0.0 71829750.48 0.0 0.0 0.0   1013757502 1040808
26917 26917 2012 2716808 1-5 Bond Street MANHATTAN 1-5 Bond Street 10,012 Retail 53047 1900   0 102.0 107.9 232.1         2898340.46 2512200.0 0.0 0.0 0.0 0.0   1005297504 1008423
27899 27899 2012 2749777 Maverick: 600 - 614 West 181st St MANHATTAN 600-614 W 181 St 10,033 Retail 79575 1975   69 60.2 60.1 172.6         3802192.91 990200.0 0.0 0.0 0.0 0.0   1021620063 1063910
28432 28432 2012 2785927 40 East 14th Street MANHATTAN 40 E 14th Street 10,003 Retail 206442 1971   10 178.6 178.6 465.5         25074093.05 11803196.77 0.0 0.0 0.0 0.0   1005650011 1009216
29744 29744 2012 2806521 120 East 87th Street MANHATTAN 120 East 87th Street 10,128 Retail 77543 1989   0 26379.0 30316.7 32199.5         10227401.76 0.0 2035280460.0 0.0 0.0 0.0   1015157502 1047955
30314 30314 2012 2814410 38 East 19th Street MANHATTAN 38 East 19th Street 10,003 Retail 132400 1900   0 68.3 65.5 227.6         9009491.34 36158.15 0.0 0.0 0.0 0.0   1008470027 1080755
30343 30343 2012 2814713 DISCARD: 230 West 125th St MANHATTAN 230 W 125 St 10,027 Retail 162894 1989   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   1019300044 1058644
30489 30489 2012 2816270 Paragon Sports MANHATTAN 867 Broadway 10,003 Retail 52810 1882   86 98.9 102.4 304.4         4629766.52 308617.11 0.0 284348.34 0.0 0.0   1008460060 1016138
30632 30632 2012 2817494 208-220 West 125th Street MANHATTAN 208-220 West 125th Street 10,027 Retail 67725 1973   69 65.0 66.2 199.3         3876168.48 528400.0 0.0 0.0 0.0 0.0   1019300037 1058641
30633 30633 2012 2817494 208-220 West 125th Street MANHATTAN 208-220 West 125th Street 10,027 Retail 67725 1973   69 65.0 66.2 199.3         3876168.48 528400.0 0.0 0.0 0.0 0.0   1019300037 1058641
30992 30992 2012 2825944 150 West 34th Street MANHATTAN 150 West 34th Street 10,001 Retail 77761 1998   12 116.7 113.9 388.3         9025298.33 47172.73 0.0 0.0 0.0 0.0   1008090069 1015211
31037 31037 2012 2829947 Yes: 116 West 23rd Street MANHATTAN 116 West 23rd Street 10,010 Retail 204000 1910   53 97.6 95.6 225.1         11067361.1 449700.0 0.0 0.0 8399374.06 0.0   1007980041 1014802
31486 31486 2012 2872715 360 Amsterdam MANHATTAN 360 Amsterdam Avenue 10,024 Retail 1650 1929   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   1011690029 1030887
32075 32075 2012 2973029 Bergdorf Goodman MANHATTAN 754 5th Ave 10,019 Retail 211000 1928   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   1012730033 1081141
32639 32639 2012 3098765 JEMB - 1293 Broadway MANHATTAN 1293 Broadway 10,001 Retail 272412 1910   41 93.0 97.1 276.9         21024435.82 0.0 4309957.92 0.0 0.0 0.0   1008090045 1015199
33990 33990 2012 3197938 42 Trinity Place MANHATTAN 42 Trinity Place 10,006 Retail 62089 1930   51 61.2 62.9 178.5         3098075.53 699800.0 0.0 0.0 0.0 0.0   1000190013 1000797
34075 34075 2012 3236962 1239 Broadway MANHATTAN 1239 Broadway 10,001 Retail 205997 1985   0 31.1 30.2 93.5         5492144.12 0.0 0.0 0.0 913310.23 0.0   1008320001 1082273
34250 34250 2012 3299214 Lord & Taylor MANHATTAN 426 Fifth Avenue 10,018 Retail 692729 1920   0 66010.0 72888.0 79962.9         29559927.68 0.0 45697448580.0 0.0 0.0 0.0   1008400042 1016004
35481 35481 2012 3533784 Home Depot #6175 MANHATTAN 28-40 W 23rd Street 10,010 Retail 106322 2004   24 105.7 106.2 353.2         11242921.46 0.0 0.0 0.0 0.0 0.0   1008240028 1080672
35512 35512 2012 3535793 195 Chrystie Street MANHATTAN 195 Chrystie Street 10,002 Retail 85995 1920   100 14.6 14.7 45.9         1147684.2 106300.0 0.0 0.0 0.0 0.0   1004260029 1005719
35932 35932 2012 3551393 Walgreens Drug Store MANHATTAN 1160 Third Avenue 10,065 Retail 10785 2002   34 170.8 161.1 570.5         1842107.7 0.0 0.0 0.0 0.0 0.0   1014027501 1076299
10382 10382 2011 3197938 42 Trinity MANHATTAN 42 Trinity Place 10,006 Retail 62,089 1930   31 81.7 84.3 234.4 433.97 75342.09 55.66 378.31 4.0 1.0           1000190013 1000797
10753 10753 2011 2785927 40 East 14th Street MANHATTAN 40 E 14th Street 10,003 Retail 206,442 1971   5 217.2 215.8 550.5 3.0 156.76 837.73 2.0 29.0 15.0           1005650011 1009216
10843 10843 2011 2598113 478-482 Broadway MANHATTAN 478-482 Broadway 10,013 Retail 55,015 1874   0 108.7 108.7 362.1 560.56 109705.67 1.34 559.22 5.0 25.0           1004730010 1079887
10950 10950 2011 2716808 1-5 Bond S MANHATTAN 1-5 Bond Street 10,012 Retail 53,047 1900   0 109.6 113.3 243.0 430.01 87331.79 151.53 278.48 2.0 2.0           1005297504 1008423
11041 11041 2011 2343724 7777 MANHATTAN 770 Broadway 10,003 Retail 154,099 1996   1 5.0 5.0 6.0 64.0 4473.31   64.0 10.0   804.0         1005540001 1008952
11442 11442 2011 2686505 Graphics S MANHATTAN 217 West 25 street 10,001 Retail 31,701 1839   0                             1007751001 1014211
11579 11579 2011 2829947 Yes: 116 West 23rd Street MANHATTAN 116 West 23rd Street 10,010 Retail 204,000 1910   79 48.5 47.7 157.0 910.91 48063.45 23.91 887.01 9.0 449.0       0.0 0.0 1007980041 1014802
11654 11654 2011 3098765 JEMB - 129 MANHATTAN 1293 Broadway 10,001 Retail 258,412 1910   34 104.5 106.7 306.7 2.0 83.44   2.0 21.0   5.0         1008090045 1015199
11657 11657 2011 2825944 150 West 3 MANHATTAN 150 West 34th Street 10,001 Retail 77,761 1998   11 120.0 118.0 400.8 875.99 122455.44   875.99 9.0 0.0         653.9 1008090069 1015211
11659 11659 2011 2646585 (71003A) H MANHATTAN 455 7th Ave 10,001 Retail 2,169,496 1902   85 57.2 57.2 187.5 11.0 59201.45 186.18 11.0 120.0 3.0           1008100001  
11660 11660 2011 2646585 (71003A) H MANHATTAN 455 7th Ave 10,001 Retail 2,169,496 1902   85 57.2 57.2 187.5 11.0 59201.45 186.18 11.0 120.0 3.0           1008110001  
11798 11798 2011 3236962 1239 Broad MANHATTAN 1239 Broadway 10,001 Retail 205,997 1985   90 59.9 59.6 122.4 1.0 52.51 505.39 513.75 5.0       6.0     1008320001 1082273
11820 11820 2011 2653163 22 West 34th (W10) MANHATTAN 22 WEST 34 STREET 10,001 Retail 68,000 1937   0 114.5 112.5 382.2 730.69 115662.85   730.69 7.0   1.0         1008350056 1083635;1083636;1083634
11853 11853 2011 3240390 Lord and T MANHATTAN 424 Fifth Ave 10,018 Retail 600,000 1914   77 60.8 59.7 200.4 3.0 53.82 37.57 3.0 35.0 706.0           1008400042 1016004
11903 11903 2011 3094937 ABC Home Furnishing MANHATTAN 888 Broadway 10,003 Retail 115,800 1881   61 69.7 68.2 200.5 734.19 68719.55 127.02 607.17 6.0         1.0   1008477501  
12325 12325 2011 2704311 1 Times Square MANHATTAN 1 Times Square 10,036 Retail 132,920 1908   29 107.8 105.7 353.6 1.0 81.54   1.0 13.0 0.0 396.0         1009950001 1022581
12344 12344 2011 2598106 1540 Broadway MANHATTAN 1540 Broadway 10,036 Retail 169,173 1990   1 617.8 617.8 1.0 9.0 573.23 425.53 9.0 96.0 7.0           1009987501 1076844
12539 12539 2011 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE 10,019 Retail 65,625 1930   67 95.7 100.5 177.1 423.7 70164.07 217.15 206.56 2.0 4.0           1010790003 1080967
12616 12616 2011 3121348 Toyota of MANHATTAN 645 11th Ave 10,036 Retail 75,000 1942   0                             1010950029  
12623 12623 2011 2671527 Manhattan MANHATTAN 787 11th Avenue 10,019 Retail 411,845 1929   81 62.4 62.4 120.6 1.0 26.19 848.9 933.1 9.0 15.0   562.0     3.0 1011020029 1027156
12822 12822 2011 2872715 360 Amsterdam MANHATTAN 360 Amsterdam Avenue 10,024 Retail 1,650 1929   0                             1011690029 1030887
13274 13274 2011 2973029 Bergdorf Goodman MANHATTAN 754 5th Ave 10,019 Retail 211,000 1928   36 253.5 262.4 619.0 4.0 204.05 813.66 3.0 32.0 15.0 6.0         1012730033 1081141;1081142
13352 13352 2011 3110951 Racquet an MANHATTAN 370 Park Avenue 10,022 Retail 105,560 1918   0                           6.0 1012880033  
13696 13696 2011 3119946 Heaven 660 MANHATTAN 660 Madison Ave. 10,065 Retail 474,498 1958   23 91.3 91.3 305.1 4.0 90.83   4.0 43.0             1013757502 1040808
13742 13742 2011 2707995 Esquire - MANHATTAN 660 Madison Avenue 10,065 Retail 475,893 1958   8 238.7 232.0 482.7 9.0 203.95   9.0 43.0   70.0         1013757502 1040808
13797 13797 2011 2598145 828-850 Madison MANHATTAN 828-850 Madison Ave 10,021 Retail 16,692 1926   74 40.2 40.2 134.3 63.02 42396.31   63.02 671.0             1013847502 1041297
13845 13845 2011 2606288 980 Madison Avenue MANHATTAN 980 Madison Avenue 10,075 Retail 121,490 1900   70 77.8 78.4 239.5 869.98 77391.55   869.98 8.0   1.0         1013910014 1041796
13992 13992 2011 2598139 201 E 66th Street MANHATTAN 201 E 66th Street 10,065 Retail 24,890 1961   1 115.6 115.6 386.0 270.06 121120.78   270.06 2.0             1014210001 1043872
14042 14042 2011 2652601 CBRE - 306 East 61st Street MANHATTAN 306 East 61st Street 10,022 Retail 53,242 1901   0 37.0 37.0 45.8 158.19 32127.2 140.12 18.07 192.0 25.0       1.0   1014350044 1044217
14261 14261 2011 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE 10,035 Retail 91,256 2004   67 80.8 82.7 182.2 550.34 65096.76 185.91 364.42 3.0 3.0           1017920005 1087849
14398 14398 2011 2598283 The Lucida MANHATTAN 151 E 85th St 10,028 Retail 95,554 2009   53 66.9 66.9 223.4 600.16 68000.65   600.16 6.0             1015147502 1088463
14403 14403 2011 2806521 120 East 8 MANHATTAN 120 East 87th Street 10,128 Retail 77,543 1989   1 41.0 44.0 50.0 254.0 35506.89   254.0 9.0   3.0       3.0 1015151102  
15133 15133 2011 2817494 208-220 We MANHATTAN 208-220 West 125th Street 10,027 Retail 67,680 1973   97 24.4 25.4 73.5 145.37 23354.45 12.44 132.93 1.0 233.0           1019300037 1058641
15134 15134 2011 2814713 Parkseen R MANHATTAN 230 W 125 St 10,027 Retail 162,894 1989   30 92.9 92.9 310.4 1.0 66.44   1.0 15.0           0.0 1019300044 1058644
15628 15628 2011 2749777 Maverick: 600 - 614 West 181st St MANHATTAN 600-614 W 181 St 10,033 Retail 79,575 1975   68 64.2 62.3 177.3 427.28 58217.71 68.87 358.41 3.0 1.0         0.0 1021620063 1063910
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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");