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

1,333 rows where Calendar Year = 2011 and Property Type = "Office" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Borough 5

Property Type 1

  • Office · 1,333 ✖

Calendar Year 1

  • 2011 · 1,333 ✖
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
10330 10330 2011 1261451 1 NY Plaza MANHATTAN One New York Plaza 10,004 Office 2,428,325 1970   60 122.0 118.2 358.9 30.0 161458.5 2.0 28.0 239.0 49.0 70.0       38.0 1000047501  
10331 10331 2011 2712342 Cushman & MANHATTAN 125 Broad Street Condo 10,004 Office 1,338,000 1970   77 119.2 121.0 235.9 11.0 118402.9   11.0 62.0   34.0         1000057501 1000006
10334 10334 2011 2897761 Wolfson Group 1 State Street MANHATTAN 1 State Street 10,004 Office 852,840 1969   23 157.9 162.0 432.4 12.0 151.6   12.0 96.0   38.0         1000090001 1000018
10335 10335 2011 2605878 17 State Street MANHATTAN 17 State Street 10,004 Office 574,105 1900   61 91.5 93.0 277.0 4.0 75.01   4.0 44.0   7.0         1000090014 1000020
10336 10336 2011 1426421 24 State S MANHATTAN 24 State Street 10,004 Office 859,807 1969   40 137.2 133.9 311.9 10.0 125.31   10.0 58.0   59.0       5.0 1000090029 1000021
10337 10337 2011 2673567 90 Broad S MANHATTAN 90 Broad Street 10,004 Office 380,788 1930   75 53.5 54.2 154.0 1.0 28.33   1.0 15.0   4.0         1000100016 1-00010-0016
10338 10338 2011 1423569 1 Whitehal MANHATTAN 1 Whitehall Street 10,004 Office 329,991 1964   57 113.1 111.3 254.2 3.0 98.15   3.0 18.0   19.0       4.0 1000100023 1000027
10341 10341 2011 2855379 80 Broad Street MANHATTAN 80 Broad Street 10,004 Office 400,000 1935   69 77.2 78.8 193.7 2.0 53.82   2.0 18.0   12.0         1000110021 1000038
10342 10342 2011 3116048 1 Broadway   One Broadway 10,004 Office 182,899 1882   0                             1000130001  
10343 10343 2011 2591254 BOWLING GR MANHATTAN 5 BROADWAY 10,004 Office 423,348 1958   72 100.9 102.5 238.3 3.0 76.34   3.0 23.0   19.0         1000130005 BIN# 1000044
10344 10344 2011 2895860 Wolfson Group 25 Broadway MANHATTAN 25 Broadway 10,004 Office 807,690 1921   27 132.8 133.7 372.6 9.0 120.04   9.0 80.0   26.0         1000130027 1000045
10346 10346 2011 2784974 Newmark - 17 Battery MANHATTAN 17 Battery Place 10,004 Office 1,346,985 1902   0 66.8 66.4 172.1 7.0 75347.3 2.0 5.0 60.0 6.0     23.0     1000157501 1082634
10353 10353 2011 1261466 One World Financial Center MANHATTAN 200 Liberty Street 10,281 Office 1,485,610 1986   86 117.3 118.1 256.9 14.0 150694.6 38.73 14.0 84.0 728.0 30.0       15.0 1000160120  
10359 10359 2011 2590245 New York Mercantile Exchange   One North End Ave. 10,282 Office 622,439 1997   82 144.6 143.2 358.3 7.0 121.14 50.0 7.0 53.0 939.0 35.0         1000160225 1085502
10360 10360 2011 2667339 Mayflower MANHATTAN 99 Madison Avenue 10,016 Office 123,350 1916   89 44.2 44.2 147.5 511.36 44749.82 0.0 511.36 5.0 68.57           1008590024 2667339
10370 10370 2011 2546540 3 Park Ave MANHATTAN 3 Park Avenue 10,016 Office   1974                                 1008897501 BIN# 1087537
10383 10383 2011 2492880 29 Broadway MANHATTAN 29 Broadway 10,006 Office 297,419 1929   7 326.2 326.2 478.0 7.0 253.69   7.0 11.0   85.0         1000200001 1000802
10384 10384 2011 2630986 39 Broadway MANHATTAN 39 Broadway 10,006 Office 447,452 1900   79 68.2 69.8 188.9 2.0 48.16   2.0 22.0   8.0         1000200004 1000803
10385 10385 2011 3122411 39 Broadwa MANHATTAN 39 Broadway 10,006 Office 447,452 1960   1 18.0 19.0 22.0 651.0 15676.28   651.0 0.0   8.0         1000200004  
10386 10386 2011 2630987 45 Broadway MANHATTAN 45 Broadway 10,006 Office 368,315 1900   57 89.0 90.3 253.0 2.0 58.5   2.0 25.0   7.0         1000200009 1000804
10387 10387 2011 2806019 45 Broadwa MANHATTAN 45 Broadway 10,006 Office 404,448 1950   1 17.0 18.0 21.0 554.0 14760.4   554.0 25.0   6.0         1000200009 1000804
10388 10388 2011 2214240 55 Broadway MANHATTAN 55 Broadway 10,006 Office 363,378 1981   71 86.7 86.7 248.7 2.0 59.31 31.2 2.0 24.0 586.0 6.0         1000200016 1000807
10389 10389 2011 2214222 61 Broadway MANHATTAN 61 Broadway 10,006 Office 650,000 1916   88 62.7 63.9 184.3 3.0 49.68   3.0 33.0   7.0         1000210001 1000808
10390 10390 2011 2796739 65 Broadwa MANHATTAN 65 Broadway 10,006 Office 331,684 1917   1 55.0 54.0 67.0 1.0 32.52   1.0 35.0   18.0         1000210004 1000809
10393 10393 2011 2680992 Newmark- 2 MANHATTAN 26 Broadway 10,004 Office 686,571 1917   67 89.2 89.4 182.7 5.0 78.45 2.0 2.0 27.0 36.0       33.0   1000220013 1000811
10394 10394 2011 2630988 32 Broadway MANHATTAN 32 Broadway 10,006 Office 143,000 1900   59 88.7 88.0 238.0 1.0 75.27 283.24 855.09 9.0         3.0   1000220017 1078979
10395 10395 2011 2630984 42 Broadway MANHATTAN 42 Broadway 10,006 Office 389,927 1900   54 97.6 96.8 261.8 3.0 83.01 849.79 2.0 27.0         10.0   1000220020 1000812
10396 10396 2011 2816242 42 Broadwa MANHATTAN 42 Broadway 10,004 Office   1953                                 1000220020 1000812
10397 10397 2011 2812115 50 Broadway MANHATTAN 50 Broadway 10,004 Office 343,345 1927   71 65.8 67.2 178.2 2.0 62.76   2.0 15.0   6.0       1.0 1000220024 1000813
10398 10398 2011 2812116 52 Broadway MANHATTAN 52 Broadway 10,004 Office 384,831 1980   74 74.7 75.8 195.1 2.0 56.06   2.0 18.0   9.0       8.0 1000220028 1000814
10400 10400 2011 1465130 20 Broad Street MANHATTAN 20 Broad Street 10,005 Office 473,042 1956   79 119.3 117.6 297.5 4.0 91.03   4.0 34.0   22.0       20.0 1000230050 1000816
10401 10401 2011 2667624 Wells 60 Broad Street, LLC MANHATTAN 60 Broad Street 10,004 Office 1,067,151 1962   81 89.0 90.6 228.2 8.0 86111.2   8.0 60.0   34.0       5.0 1000240001 1000817
10402 10402 2011 2673668 30 Broad MANHATTAN 30 Broad Street 10,004 Office 419,795 1932   81 63.7 64.0 181.6 2.0 51.38   2.0 20.0   6.0       9.0 1000240029 1000819
10403 10403 2011 2746854 50 Broad Street MANHATTAN 50 Broad Street 10,004 Office 205,940 1913   0 67.3 67.5 203.6 1.0 52.51   1.0 11.0   2.0         1000240036 1000820
10404 10404 2011 2592008 150 WILLIA MANHATTAN 72 ANN STREET 10,038 Office 587,831 1968   100 64.5 64.5 80.1 3.0 55.01   3.0 573.0   37.0         1000930001 BIN# 1001280
10406 10406 2011 1423560 55 Broad S MANHATTAN 55 Broad Street 10,004 Office 410,295 1967   53 111.5 113.1 292.5 4.0 105.01   4.0 30.0   15.0       9.0 1000250001 1000821
10408 10408 2011 2792930 40 Exchang MANHATTAN 40 Exchange Place 10,004 Office 237,000 1902   77 88.9 89.2 194.9 1.0 45.42 560.41 988.31 10.0 10.0           1000250027 1000825
10414 10414 2011 3089535 20 Exchange Place MANHATTAN 20 Exchange Place 10,005 Office 826,289 1929   90 47.2 48.2 130.1 3.0 39.09 528.29 2.0 29.0 9.0 10.0         1000277502 1000830
10415 10415 2011 2855367 5 Hanover Square MANHATTAN 5 Hanover Square 10,004 Office 325,000 1962   50 129.8 126.5 257.9 3.0 99.36   3.0 15.0   26.0         1000280005 1000832
10416 10416 2011 2782696 11 Hanover MANHATTAN 76 Beaver Street 10,005 Office   1931                                 1000280012 1000833
10420 10420 2011 2682108 JEMB - 75 Broad St MANHATTAN 75 Broad Street 10,004 Office 671,172 1929   1 220.8 221.6 677.6 13.0 208.54   13.0 129.0   18.0         1000290070 1000849
10423 10423 2011 2964283 7 Hanover Square MANHATTAN 7 Hanover Square 10,004 Office 802,690 1983   74 80.4 81.2 222.1 5.0 67.11 866.79 4.0 48.0 16.0           1000300019 1000855
10427 10427 2011 2481300 55 Water MANHATTAN 55 Water St 10,041 Office 3,667,682 1972   42 144.8 144.8 401.8 47.0 168634.43 508.55 47.0 390.0 928.0 133.0       113.0 1000327501  
10428 10428 2011 2649703 77 Water S MANHATTAN 77 Water Street, 13 th Floor 10,005 Office 669,211 1969   88 76.0 76.0 147.4 4.0 64.36   4.0 17.0   33.0         1000330001 1-00033-0001
10429 10429 2011 2831599 Claremont MANHATTAN 99 Wall Street 10,005 Office 91,353 1931   69 83.2 85.6 191.1 657.93 77823.0   657.93 3.0   3.0         1000330022 BIN# 1000865
10430 10430 2011 1422213 110 Wall S MANHATTAN 110 Wall Street 10,005 Office 292,627 1965   63 108.9 107.9 239.8 2.0 73.73   2.0 14.0   17.0       3.0 1000370008 1000872
10431 10431 2011 3058817 SL Green Realty Corporation 180 Maiden Lane MANHATTAN 180 Maiden Lane 10,038 Office 1,100,000 1983   79 85.0 84.5 234.1 8.0 86111.2 57.97 8.0 67.0 1.0 24.0         1000370023 1000874
10432 10432 2011 1439911 120 Wall Street MANHATTAN 120 Wall Street 10,005 Office 608,966 1931   85 60.7 62.2 162.5 3.0 53.11   3.0 25.0   11.0         1000377501 1000871
10433 10433 2011 2878162 100 Wall S MANHATTAN 100 Wall Street 10,005 Office 426,531 1969   61 104.0 104.0 254.0 3.0 75.8   3.0 25.0   18.0         1000380001  
10434 10434 2011 2741463 88 Pine St. MANHATTAN 88 Pine Street 10,005 Office 664,900 1973   53 139.8 137.5 283.6 7.0 113.47   7.0 35.0   57.0         1000380017 1000876
10435 10435 2011 2273784 80 Wall Street MANHATTAN 80 Wall Street 10,005 Office 56,271 1906   100 19.9 19.9 66.3 104.98 20178.47   104.98 1.0   2.0         1000390004  
10436 10436 2011 2273786 82 Wall Street MANHATTAN 82 Wall Street 10,005 Office 56,271 1902   0 43.1 45.0 83.8 203.92 39195.97   203.92 836.0   1.0         1000390004  
10437 10437 2011 1423089 80 Pine St MANHATTAN 80 Pine Street 10,005 Office 1,084,110 1960   38 146.4 143.3 327.3 13.0 139930.7   13.0 76.0   82.0       16.0 1000390012 1000880
10440 10440 2011 1240203 Deutsche B MANHATTAN 60 Wall Street 10,005 Office 1,625,483 1989   0 137.5 137.3 387.4 20.0 215278.0 284.17 19.0 169.0 2.0 49.0         1000400003 1001004
10441 10441 2011 3104088 48 Wall Street MANHATTAN 48 Wall Street 10,005 Office 324,000 1928   81 60.2 60.4 182.0 1.0 33.22   1.0 16.0   2.0         1000400014 1001005
10442 10442 2011 3089570 70 Pine Street MANHATTAN 70 Pine Street 10,270 Office 918,919 1932   100 5.9 5.7 18.7 492.92 5779.67 21.45 471.47 5.0 403.0 4.0         1000410001 1001007
10447 10447 2011 2689243 80 Maiden MANHATTAN 80 Maiden Lane 10,038 Office 527,605 1911   1 21.0 20.0 26.0 901.0 18402.8   901.0 18.0   11.0         1000420031 1001015
10449 10449 2011 2637355 44 Wall Street MANHATTAN 44 Wall Street 10,005 Office 341,291 1927   68 83.9 86.5 211.9 2.0 63.13   2.0 17.0   10.0       3.0 1000430001 1001017
10450 10450 2011 2614197 40 Wall Street MANHATTAN 40 Wall Street 10,005 Office   1900                                 1000430002 1001018
10451 10451 2011 2681935 30 Wall St MANHATTAN 30 Wall St 10,005 Office 138,880 1954   0 76.6 75.9 225.9 969.25 75600.8   969.25 8.0   1.0         1000430005 1001019
10452 10452 2011 2498265 JPMorgan Chase-1CMP MANHATTAN 1 Chase Manhattan Plaza 10,005 Office 2,199,000 1961   42 155.3 155.3 360.7 29.0 156076.55 39.11 29.0 178.0 735.0 162.0 0.0     83.0 1000440001 BBL: 1-00044-0001
10454 10454 2011 2558651 GC Fieldstone Capital MANHATTAN 2 Wall Street 10,005 Office 192,500 1932   44 109.1 110.1 298.6 1.0 56.06   1.0 15.0   5.0         1000460001 1001023
10455 10455 2011 3177709 100 Broadway MANHATTAN 100 Broadway 10,006 Office 395,000 1896   1 1.0 1.0 2.0 53.0 1444.27   53.0 13.0   656.0         1000460003  
10456 10456 2011 1439342 120 Broadway Holdings, LLC MANHATTAN 120 Broadway 10,271 Office 1,878,140 1915   80 77.0 75.9 213.2 12.0 129166.8 128.78 12.0 106.0 2.0 36.0         1000477501 1001026
10457 10457 2011 1052478 140 Broadway MANHATTAN 140 Broadway 10,005 Office 1,178,137 1967   50 155.2 155.2 318.5 15.0 161458.5   15.0 72.0   110.0         1000480001 1001027
10458 10458 2011 2665529 Stellar - MANHATTAN 2 Rector Street 10,006 Office 491,400 1984   62 91.0 94.1 249.7 4.0 87.69   4.0 32.0   12.0         1000510001 1001031
10459 10459 2011 2430721 Trinity- 6   68 Trinity 10,006 Office 255,406 1927   65 96.0 96.0 187.6 2.0 84.42 6.8 2.0 8.0 127.0 15.0         1000510007 1001032
10460 10460 2011 2714770 86 Trinity Place MANHATTAN 86 Trinity Place 10,006 Office 167,555 1921   1 655.5 655.5 809.7 8.0 515.64   8.0 1.0   108.0         1000510013 1001033
10461 10461 2011 3095325 86 Greenwi MANHATTAN 86 Greenwich Street 10,006 Office 150,000 1920   0                             1000510013 1001033 2010 Bench Marking Building ID : 2714770
10462 10462 2011 2731615 22 Thames Street LLC MANHATTAN 22 Thames Street 10,006 Office 97,589 1900   0 1.0 1.0 1.0 7.0 776.78   7.0 371.0   100.0         1000510014 1001034
10468 10468 2011 2557397 40 Rector MANHATTAN 40 Rector Street 10,006 Office 441,821 1921   50 102.3 99.7 227.6 3.0 73.22   3.0 21.0   23.0         1000557501 BIN# 1088750
10470 10470 2011 1261446 One Liberty MANHATTAN 165 Broadway 10,006 Office 2,346,193 1972   70 113.9 113.9 300.7 23.0 123784.85 29.1 23.0 179.0 547.0 87.0       38.0 1000627501  
10471 10471 2011 2973494 SG: 22 Cor MANHATTAN 22 Cortlandt Street 10,007 Office 666,930 1973   44 85.7 84.5 286.1 5.0 80.81   5.0 57.0           0.0 1000630003 1001069
10474 10474 2011 2682163 JEMB - 150 MANHATTAN 150 Broadway 10,038 Office 276,000 1600   87 55.6 57.2 153.0 1.0 39.0   1.0 11.0   4.0         1000640012 1001087
10475 10475 2011 2591375 BROADWAY L MANHATTAN 160 BROADWAY 10,038 Office 145,000 1908   75 105.2 105.2 221.5 1.0 74.23 578.65 671.79 7.0 863.0     7.0     1000640015 BIN# 1079040, 1079037, 1079038, 1079039
10476 10476 2011 2655724 Heller- 15 MANHATTAN 15 Maiden Lane 10,038 Office 144,200 1908   88 62.0 62.6 159.6 790.91 59119.97   790.91 5.0   3.0         1000650007 1001097
10479 10479 2011 2233950 FRBNY HO MANHATTAN 33 Liberty Street 10,045 Office 870,210 1924   50 133.9 136.0 306.3 10.0 123.72 84.38 9.0 59.0 1.0 55.0       30.0 1000660001 1-00066-0001
10481 10481 2011 1427700 33 Maiden MANHATTAN 33 Maiden Lane 10,038 Office 617,356 1986   80 60.1 60.8 182.7 3.0 52.34   3.0 31.0   5.0       10.0 1000670023 1001109
10482 10482 2011 2797282 CBRE - 83 MANHATTAN 83 Maiden Lane 10,038 Office 155,714 1959   89 79.9 78.5 148.7 1.0 69.44 14.58 1.0 3.0 274.0 8.0         1000680007 1001111
10483 10483 2011 2796479 75 Maiden MANHATTAN 75 Maiden Lane 10,038 Office 155,026 1925   1 13.0 14.0 16.0 166.0 11527.79   166.0 8.0   2.0         1000680011 1001112
10486 10486 2011 2649463 CBRE- 100 MANHATTAN 100 William Street 10,038 Office 383,042 1974   70 114.6 114.6 382.7 4.0 112.42   4.0 43.0             1000680036 1001116
10490 10490 2011 3095579 Witkoff - MANHATTAN 233 Broadway 10,007 Office 890,767 1913   72 79.8 81.9 208.8 6.0 72.57   6.0 46.0   24.0         1001237501 1087167
10492 10492 2011 3089543 116 John Street MANHATTAN 116 John Street 10,038 Office 342,310 1931   100 36.2 35.8 79.2 1.0 31.47   1.0 5.0 0.0 6.0         1000690032 1001126
10495 10495 2011 2701977 160 Water Street MANHATTAN 160 Water Street 10,038 Office 491,442 1972   100 63.3 63.5 77.0 2.0 43.84   2.0 88.0   31.0         1000700043 1001135
10496 10496 2011 2270240 Maiden Lan MANHATTAN 125 Maiden Lane 10,038 Office 316,008 1959   67 95.9 98.5 215.5 2.0 68.13   2.0 14.0   15.0         1000707501  
10498 10498 2011 1413685 175 Water MANHATTAN 175 Water Street 10,038 Office 510,858 1983   50 96.3 97.6 288.0 4.0 84.42 29.09 4.0 41.0 546.0 7.0         1000717501 1001137 1804058
10501 10501 2011 1796894 One Seaport Plaza MANHATTAN 199 Water Street 10,038 Office 988,890 1984   69 80.5 80.5 230.3 7.0 76.26 2.7 7.0 61.0 50.0 17.0       120.9 1000747501 1001162
10503 10503 2011 2379801 40 Fulton Street MANHATTAN 40 Fulton St 10,038 Office 249,885 1986   68 58.7 58.7 196.0 1.0 43.23   1.0 14.0           1.0 1000750021 1075618
10504 10504 2011 2591922 111 JOHN R MANHATTAN 103 JOHN STREET 10,038 Office 298,776 1936   86 75.2 76.9 188.3 1.0 36.12   1.0 13.0   8.0         1000750030 BIN# 1001167
10509 10509 2011 3104084 110 William Street MANHATTAN 110 William Street 10,038 Office 900,000 1956   90 57.6 57.4 150.0 4.0 47.84   4.0 33.0   17.0         1000770008 1001186
10517 10517 2011 2873013 195 B'way MANHATTAN 195 Broadway 10,007 Office 1,166,100 1916   75 72.3 75.5 179.1 7.0 75347.3   7.0 50.0   34.0         1000800001 1001227
10518 10518 2011 1443197 7 World Trade Center, LLC MANHATTAN 250 Greenwich St. 10,007 Office 1,715,800 2006   74 81.1 81.1 220.8 12.0 129166.8 49.22 12.0 98.0 925.0 39.0         1000840036 1086510
10519 10519 2011 2313463 90 Church MANHATTAN 90 Church Street 10,007 Office 1,234,704 1938   82 66.8 65.9 184.6 7.0 75347.3   7.0 60.0   22.0         1000860001 1001230
10520 10520 2011 2562042 20 Vesey MANHATTAN 20 Vesey Street 10,007 Office 96,154 1907   83 71.0 71.0 166.3 581.61 65212.42 215.01 366.6 3.0       2.0   1.0 1000880005 1001235
10522 10522 2011 2591226 225 BROADW MANHATTAN 225 BROADWAY 10,007 Office 461,731 1915   86 83.7 83.7 187.2 3.0 70.05 1.0 1.0 20.0 7.0     18.0     1000880018 BIN# 1001241
10523 10523 2011 2818856 The Bennette Building MANHATTAN 99 Nassau Street 10,038 Office 100,000 1872   0 73.8 73.5 191.5 644.72 69397.02 173.48 471.24 5.0     2.0     31.0 1000890001 1001242
10529 10529 2011 2656282 Heller- 12 MANHATTAN 126-132 Nassau Street 10,038 Office 126,000 1915   77 88.7 88.7 185.1 901.87 77044.75 418.68 483.18 5.0 1.0     4.0     1000920030 1079101
10532 10532 2011 2615091 Park Murra MANHATTAN 11 Park Place 10,007 Office   1926                                 1001240004 Building Identification Number (BIN): 1001399
10541 10541 2011 2688590 375 Pearl Street MANHATTAN 375 Pearl Street 10,038 Office 1,120,000 1975   0 39.9 41.0 111.7 4.0 43055.6   4.0 33.0   11.0       8.0 1001137501 1001389
10542 10542 2011 2785324 The Woolworth Building MANHATTAN 233 Broadway 10,279 Office 900,134 1913   64 77.5 78.3 204.9 6.0 71.76   6.0 46.0   22.0         1001237501 1087167

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");