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

65 rows where Calendar Year = 2014 and Property Type = "Mixed Use Property" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Number of Buildings, ENERGY STAR Score, District Steam Use (kBtu), Fuel Oil #2 Use (kBtu), Fuel Oil #4 Use (kBtu), Fuel Oil #5 & 6 Use (kBtu), Water Use (kgal)

Borough 5

Property Type 1

  • Mixed Use Property · 65 ✖

Calendar Year 1

  • 2014 · 65 ✖
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
49928 49928 2014 2611920 Walter & Samuels - 500 8th Ave MANHATTAN 500 8th Ave 10018 Mixed Use Property 234132 1922 1 Not Available 75.7 75.9 170.9 1397.1 64.23 536.8 860.3 10373433.4 442400.0 0.0 6916325.4 0.0 0.0 0.0 1-00785-0001 1014421
50764 50764 2014 2659197 Buildings 3-4 BROOKLYN 219-253 36th St; 34,68,88 35th Street 11232 Mixed Use Property 689803 1900 0 Not Available 64.8 63.6 114.8 2833.4 44.21 1552.6 1280.7 15442486.6 29231913.8 0.0 0.0 0.0 0.0 0.0 3006910001 3345565;3345565;3336903
50768 50768 2014 2659276 Buildings 2 BROOKLYN 220-254 36th Street 11232 Mixed Use Property 265775 1900 1 Not Available 66.8 65.7 120.8 1135.4 45.98 601.2 534.2 6441611.3 11318244.9 0.0 0.0 0.0 0.0 0.0 3006950020 3855924;3856283
50769 50769 2014 2659277 Buildings 7-8   33,67,87 34th Street; 32,68,88 33rd Street 11232 Mixed Use Property 703914 1900 0 Not Available 66.2 65.0 119.0 2971.4 45.44 1589.2 1382.2 16665841.6 29920372.1 0.0 0.0 0.0 0.0 0.0 3006830001 3801582;3336897;
51249 51249 2014 2669309 Murray Hill Place MANHATTAN 243 Lexington Ave. 10016 Mixed Use Property 121600 2000 1 Not Available 82.4 79.5 149.3 640.9 56.73 338.0 302.9 3652116.7 6363536.0 0.0 0.0 0.0 0.0 2528.3 1-00890-0025 1087628
51756 51756 2014 2681034 Newlo Realty Corp BRONX 347-349 Rider Avenue 10451 Mixed Use Property 53750 1900 1 Not Available 8.0 8.0 25.2 35.7 7.15 0.0 35.7 430891.2 0.0 0.0 0.0 0.0 0.0 21366.3 2023400195 2000989
51839 51839 2014 2682622 Riverdale YM YWHA BRONX 5625 Arlington ave. 10471 Mixed Use Property 40500 1985 1 Not Available 187.5 181.5 359.3 497.1 132.12 236.0 261.1 3148104.6 4444139.8 0.0 0.0 0.0 0.0 0.0 2059520374 2086312
52082 52082 2014 2695335 38 East 32nd Street MANHATTAN 38 East 32nd Street 10016 Mixed Use Property 83937 1912 1 Not Available 51.1 0.0 114.1 340.0 43.6 135.9 204.1 2461145.2 2935.5 0.0 1829065.8 0.0 0.0 1208.4 1008610049 1016994
53740 53740 2014 2792593 BRP BROOKLYN 333 Adams Street 11201 Mixed Use Property 1367356 1996 2 Not Available 142.4 142.4 279.5 13134.9 103.4 6060.8 7074.1 85297731.2 97452302.2 0.0 6401598.8 0.0 0.0 7279.3 3-00140-0160;3-00140-7501 3391417;3000259
54093 54093 2014 2801611 Flushing Plaza   41-55 - 79 Kissena Boulevard 11355 Mixed Use Property 247643 1983 1 16 140.0 136.8 392.8 2729.1 118.62 312.3 2416.8 29140877.5 4666233.4 0.0 868710.1 0.0 0.0 1024.4 4-05045-0001 4114293
54165 54165 2014 2803732 Lambert Houses- East-Commercial BRONX 2030 Boston Road 10460 Mixed Use Property 57963 1973 1 Not Available 112.6 108.6 277.6 478.3 88.82 111.7 366.6 4420795.7 2103158.0 0.0 0.0 0.0 0.0 1954.3 2-03139-0001 2013281;2808047
54464 54464 2014 2808024 Austin Street   69-32 - 6960 Austin Street 11375 Mixed Use Property 81338 1997 1 Not Available 47.9 48.1 111.8 278.3 36.83 79.8 198.5 2393367.9 1502599.9 0.0 0.0 0.0 0.0 7637.8 4-03234-0150 4077469
55126 55126 2014 2817667 East 163rd LLC BRONX 935 East 163rd Street 10459 Mixed Use Property 61872 1910 1 10 118.1 0.0 142.0 548.3 95.39 494.0 54.3 654169.3 310368.8 0.0 0.0 6342962.7 0.0 0.0 2-02703-0025 2005456
55127 55127 2014 2817668 East 163 LLC BRONX 945 East 163rd Street 10459 Mixed Use Property 61872 1910 1 8 100.4 0.0 126.5 468.0 81.42 407.9 60.0 724042.9 246206.2 0.0 0.0 5244199.6 0.0 0.0 2-02703-0053 2005463
55857 55857 2014 2938815 Waterfront NY Realty Corp. MANHATTAN 224 12th Ave 10001 Mixed Use Property 1125420 1891 0 Not Available 13.7 13.5 27.1 1023.0 9.78 453.2 569.9 6871192.0 8532161.9 0.0 0.0 0.0 0.0 15820.7 1006730001 1079184
56006 56006 2014 2961637 11-05 44th Drive QUEENS 11-05 44th Drive 111015107 Mixed Use Property 54000 1931 1 Not Available 99.6 97.5 260.2 405.5 80.83 72.0 333.4 4020448.6 1356246.2 0.0 0.0 0.0 0.0 1031.7 4-00447-0021 4005233
56223 56223 2014 2978550 BRANCO QUEENS 44-02 23rd street 11101 Mixed Use Property 65000 1930 1 Not Available 87.6 87.6 140.4 440.8 73.0 309.2 131.5 1585681.8 0.0 0.0 0.0 4107417.9 0.0 1596.5 4-00439-0039 4005192
56284 56284 2014 3052621 Vertical Industrial Park Associates QUEENS 66-26 Metropolitan Ave 11379 Mixed Use Property 1659044 1973 0 Not Available 53.6 53.5 138.6 6669.7 43.27 1247.7 5422.0 65376889.4 23490698.6 0.0 0.0 0.0 0.0 0.0 4-03605-0001 4443103
56559 56559 2014 3107607 17212 - 36 East 31st Street MANHATTAN 36 East 31st Street 10016 Mixed Use Property 160686 1915 0 Not Available 45.4 40.7 72.8 565.2 37.86 396.9 168.3 2029230.0 1287.9 0.0 0.0 0.0 5267110.8 1187.9 1008600049 1016969
57273 57273 2014 3128782 The Abbey Condominium MANHATTAN 205 East 16th St. 10003 Mixed Use Property 60000 1888 1 Not Available 32503.6 29635.2 39125.9 129502.7 23232.57 1.4 129501.3 708461.1 26513.7 1949478544.0 0.0 0.0 0.0 2112.7 1-00897-7501;1-00897-1001;1-00897-1002;1-00897-1003;1-00897-1004;1-00897-1005;1-00897-1006;1-00897-1007;1-00897-1008;1-00897-1009;1-00897-10101-00897-1011;1-00897-1012;1-00897-1013;1-00897-1014;1-00897-1015;1-00897-1016;1-00897-1017;1-00897-1018;1-00897-1019;1-00897-1020;1-00897-10211-00897-1022;1-00897-1023;1-00897-1024;1-00897-1025;1-00897-1026;1-00897-1027;1-00897-1028;1-00897-1029;1-00897-1030;1-00897-1031;1-00897-1032;1-00897-1033;1-00897-1034;1-00897-1035;1-00897-1036; 1019536
57310 57310 2014 3129518 Tower 53 MANHATTAN 825 seventh Ave 10019 Mixed Use Property 358000 1960 1 24 121.6 118.5 238.8 3142.0 94.47 137.0 3005.0 17299282.1 2578538.7 23649734.2 0.0 0.0 0.0 0.0 1-01006-7501 1023166
57407 57407 2014 3221240 Royal Third Ave RLTYCP BRONX 3706 3 Ave 10456 Mixed Use Property 56200 1920 1 Not Available 106.6 104.1 216.1 401.9 76.98 169.6 232.2 2800283.5 3193406.2 0.0 0.0 0.0 0.0 3888.4 2-02926-0002 2009624;2806358;2806357
57442 57442 2014 3239928 Alwayne Construction Corp BROOKLYN 37 Otsego Street 11231 Mixed Use Property 60700 1953 1 Not Available 48.7 48.7 74.5 177.3 31.44 121.2 56.1 676890.3 2280970.4 0.0 0.0 0.0 0.0 8146.9 3-00579-0001 3329546;3809539;3835581
57644 57644 2014 3375862 55-01 Second Street QUEENS 55-01 Second Street 11101 Mixed Use Property 195286 1940 2 Not Available 51.7 49.4 134.1 758.9 41.83 140.6 618.2 7454657.0 2647989.9 0.0 0.0 0.0 0.0 1134.4 4-00011-0001 4436570;4436569;4835483
58752 58752 2014 3790762 161 West St AKA 15 Huron St BROOKLYN 161 West Street 11222 Mixed Use Property 50000 1971 1 Not Available 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3025200001 3064105
58919 58919 2014 3965114 73 Fifth Avenue MANHATTAN 73 Fifth Avenue 10003 Mixed Use Property 75572 1907 1 Not Available 106.5 106.2 177.9 574.2 81.78 370.7 203.5 2453904.1 2111097.0 0.0 3484637.9 0.0 0.0 330.5 1-00843-7501 1016069
59071 59071 2014 4022825 Parish - The Basillica Of Our Lady Of Perpetual Help - 526 59th Street BROOKLYN 526 59th Street 11220 Mixed Use Property 88750 1908 1 Not Available 156.0 147.7 230.7 1049.6 127.3 797.9 251.7 3035401.7 714770.6 0.0 0.0 10093563.5 0.0 0.0 3-00864-0001 3337343
59600 59600 2014 4040856 775 Columbus Avenue MANHATTAN 775 Columbus Avenue 10025 Mixed Use Property 100257 2007 0 2 125.6 122.5 273.8 871.7 93.59 307.0 564.7 6809084.1 5779146.1 0.0 0.0 0.0 0.0 0.0 1018337505 1088481
59601 59601 2014 4040862 795 Columbus Avenue MANHATTAN 795 Columbus Avenue 10025 Mixed Use Property 270366 2007 1 Not Available 99.1 97.2 218.8 1866.2 74.3 635.3 1231.0 14842844.2 11959985.9 0.0 0.0 0.0 0.0 0.0 1018337506 1088631
59602 59602 2014 4040931 805 Columbus Avenue MANHATTAN 805 Columbus Avenue 10025 Mixed Use Property 128196 2007 1 6 98.7 96.7 211.0 868.5 72.92 322.3 546.2 6585687.3 6068355.3 0.0 0.0 0.0 0.0 0.0 1018337507 1088152
59603 59603 2014 4040938 801 Amsterdam Avenue MANHATTAN 801 Amsterdam Avenue 10025 Mixed Use Property 159316 2008 1 54 91.0 89.2 172.9 945.9 63.91 457.0 489.0 5895929.9 8603116.3 0.0 0.0 0.0 0.0 0.0 1018527502 1088438
59604 59604 2014 4040942 808 Columbus Avenue MANHATTAN 808 Columbus Avenue 10025 Mixed Use Property 608750 2007 1 Not Available 124.3 122.8 229.5 4879.2 86.27 2488.5 2390.7 28826719.5 46850449.5 0.0 0.0 0.0 0.0 0.0 1018527501 1088432
59605 59605 2014 4040945 10 Hanover Square MANHATTAN 10 Hanover Square 10005 Mixed Use Property 510613 1972 1 33 53.8 53.8 143.1 2091.1 44.08 336.8 1754.3 21152432.4 6341226.3 0.0 0.0 0.0 0.0 0.0 1000310001 1000859
59607 59607 2014 4040948 401 East 34th Street MANHATTAN 401 East 34th Street 10016 Mixed Use Property 859144 1985 1 Not Available 23.9 24.0 67.9 1614.3 20.22 154.2 1460.1 17605077.5 2904038.2 0.0 0.0 0.0 0.0 0.0 1009660001 1022057
59645 59645 2014 4042680 Manor Road Allied Shopping Center STATEN IS 754-778 Manor Road 10314 Mixed Use Property 65237 1964 2 Not Available 95.1 95.1 277.1 494.6 81.61 35.7 458.9 5532713.2 672300.0 0.0 0.0 0.0 0.0 0.0 5-00714-0015 5018078
59652 59652 2014 4042763 33 ninth LLC MANHATTAN 29 9th avenue 10014 Mixed Use Property 69160 1910 1 Not Available 45.0 43.5 78.0 195.6 30.44 111.0 84.6 1019555.4 2090185.5 0.0 0.0 0.0 0.0 17342.1 1-00646-0047 1012238
59923 59923 2014 4045050 40-07 73rd Street / 73-02 Roosevelt Avenue   40-07 73rd Street / 73-02 Roosevelt Avenue 11377 Mixed Use Property 58758 2010 1 Not Available 19.6 19.6 49.1 85.1 15.59 18.5 66.6 802966.5 348200.0 0.0 0.0 0.0 0.0 0.0 4013050023 4030453
60033 60033 2014 4046567 150 Greenway Terrace QUEENS 150 Greenway Terrace 11375 Mixed Use Property 139142 1910 1 Not Available 0.0 0.0 0.0 609.4 47.14 498.2 111.2 1340887.5 9379128.9 0.0 0.0 0.0 0.0 0.0 4032720001 4078317
60036 60036 2014 4046572 286 5th AVE MANHATTAN 286 5th AVE 10037 Mixed Use Property 44380 1910 1 1 105.5 102.6 212.7 366.8 88.96 183.5 183.3 2210234.2 0.0 0.0 2473167.1 0.0 0.0 0.0 1008320041 1015786
60246 60246 2014 4288074 180 Livingston Street BROOKLYN 180 Livingston St 11201 Mixed Use Property 242086 1900 1 76 59.6 58.9 157.8 1095.1 48.69 180.6 914.5 11027323.1 3399243.7 0.0 0.0 0.0 0.0 0.0 3001647501 3000484
60283 60283 2014 4335611 220 West 148th Street MANHATTAN 220 West 148th Street 10039 Mixed Use Property 98581 1903 1 81 50.5 47.1 104.8 337.4 36.84 135.2 202.2 2437532.8 2545400.0 0.0 0.0 0.0 0.0 0.0 1020337501 1060526
60506 60506 2014 4382972 1548-1560 Saint Nicholas Equities, LLC MANHATTAN 1548 Saint Nicholas Avenue 10040 Mixed Use Property 51676 1924 1 99 54.8 0.0 64.9 205.6 42.83 186.8 18.8 226616.0 304234.4 0.0 2299287.0 0.0 0.0 5700.4 1021580007 1063808
60507 60507 2014 4382977 1114 Ward Ave, LLC BRONX 1114 Ward Ave 10472 Mixed Use Property 73308 1928 1 99 57.2 0.0 67.7 301.1 44.21 273.5 27.6 332192.1 606631.3 0.0 3251472.2 0.0 0.0 5127.9 2037420005 2023923
60525 60525 2014 4387157 110 GREENWICH LLC MANHATTAN 110-112 GREENWICH STREET 10006 Mixed Use Property 115882 1929 1 Not Available 45.2 0.0 72.8 320.2 29.74 204.0 116.2 1401008.1 3841446.0 0.0 0.0 0.0 0.0 0.0 1000530033 Not Available
60651 60651 2014 4392809 10 West End Avenue MANHATTAN 10 West End Avenue 10023 Mixed Use Property 234440 2005 1 18 95.3 90.9 164.0 1400.3 64.29 804.8 595.5 7180349.7 15152799.9 0.0 0.0 0.0 0.0 0.0 1011517502 1087651
60691 60691 2014 4394134 HBO   1100 Avenue of the America's 10036 Mixed Use Property Not Available 1980 1 Not Available 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Not Available Not Available
60786 60786 2014 4398342 260 11th Avenue, New York MANHATTAN 260 11th Avenue, New York 10001 Mixed Use Property 224609 1911 1 Not Available 66.1 63.0 143.4 1172.5 56.19 502.4 670.1 8079852.6 13108.3 0.0 6760067.9 0.0 0.0 0.0 1-00698-0001 1012389
60873 60873 2014 4401095 22-15 43rd Avenue QUEENS 22-15 43rd Avenue 11101 Mixed Use Property 60000 1918 1 Not Available 90.1 87.3 195.4 373.3 66.97 133.3 240.0 2893521.2 2510120.1 0.0 0.0 0.0 0.0 324.3 4-00426-0001 4005067
60881 60881 2014 4401166 54-08 Vernon Boulevard QUEENS 54-08 Vernon Boulevard 11101 Mixed Use Property 55000 1967 1 Not Available 70.0 63.9 128.1 247.4 48.42 128.3 119.1 1436497.3 2415662.5 0.0 0.0 0.0 0.0 0.0 4-0036-0001 4000204
61025 61025 2014 4403225 873 Broadway, New York MANHATTAN 873 Broadway, New York 10003 Mixed Use Property 94418 1900 1 Not Available 94.4 0.0 226.7 682.8 77.84 202.3 480.6 5794657.7 1396951.7 0.0 0.0 0.0 0.0 0.0 1-00847-0016 1080750
61037 61037 2014 4403241 111-119 West 19th Street, New York MANHATTAN 111-119 West 19th Street, New York 10011 Mixed Use Property 166000 1901 1 Not Available 91.3 88.9 204.9 1202.9 78.0 475.1 727.8 8775638.8 251732.3 0.0 0.0 6133021.6 0.0 0.0 1-00795-0028 1014730
61127 61127 2014 4403963 981 8th Ave MANHATTAN 981 8th Ave 10019 Mixed Use Property 102720 1987 1 Not Available 121.3 121.5 329.2 988.1 103.54 0.0 988.1 9716746.5 0.0 2744695.8 0.0 0.0 0.0 0.0 1-01048-0033 1026054
61145 61145 2014 4404216 35 E 21st Street MANHATTAN 35 E 21st Street E 21st Street 10010 Mixed Use Property 9890 1903 2 Not Available 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1-00850-0025 1080768;1080769
61157 61157 2014 4404697 530 W 27th Street MANHATTAN 530 W 27th Street 10001 Mixed Use Property 5777 1909 1 Not Available 768.3 737.0 1553.9 297.3 553.94 126.1 171.3 2065254.7 2373328.0 0.0 0.0 0.0 0.0 0.0 1-00698-0054 1012398
61168 61168 2014 4404858 542 W 27th Street MANHATTAN 542 W 27th Street 10001 Mixed Use Property 49242 1901 1 Not Available 3.8 3.8 11.3 15.1 3.3 0.9 14.2 171122.9 16900.0 0.0 0.0 0.0 0.0 0.0 1-00698-0057 1012400
61201 61201 2014 4405516 Petro Maspeth QUEENS 55-60 58th St 11378 Mixed Use Property 100525 1957 1 92 63.5 59.9 101.7 434.0 46.47 290.8 143.2 1726813.2 2586100.3 0.0 2068054.2 0.0 0.0 443.7 4-02585-0021 4058947
61262 61262 2014 4405918 Madison Ave MANHATTAN 89-95 Madison Ave 10016 Mixed Use Property 160036 1913 1 Not Available 54.3 50.2 86.9 665.9 44.79 466.2 199.7 2407507.2 0.0 0.0 6282588.0 0.0 0.0 0.0 Not Available Not Available
61579 61579 2014 4409008 33 W End Ave MANHATTAN 33 West End Avenue 10023 Mixed Use Property 219648 2006 1 Not Available 169.9 164.8 254.5 2220.9 108.84 1558.2 662.6 7989577.1 29337314.9 0.0 0.0 0.0 0.0 0.0 1011717506 1087589
61733 61733 2014 4410455 10 GRAND HOLDING LLC BROOKLYN 10 GRAND ST 11205 Mixed Use Property 58905 1935 1 Not Available 65.3 63.1 117.0 244.9 44.75 131.7 113.2 1365342.5 2479799.9 0.0 0.0 0.0 0.0 1430.3 3-01877-0030 3054157
61748 61748 2014 4410712 200 Lafayette Street MANHATTAN 200 Lafayette Street 10012 Mixed Use Property 115963 1900 1 Not Available 35.6 32.3 66.0 266.6 24.75 134.6 131.9 1590982.5 2534404.0 0.0 0.0 0.0 0.0 637.9 1-00482-0037 1007223
61942 61942 2014 4413247 95-02 Seaview Avenue, Brooklyn BROOKLYN 95-02 Seaview Avenue, Brooklyn 11236 Mixed Use Property 28133 1950 1 Not Available 195.6 0.0 333.8 348.2 133.22 204.4 143.8 1733750.9 3564234.8 0.0 203605.2 0.0 0.0 0.0 3-08318-0008 3235056
61995 61995 2014 4413940 949-959 Southern Boulevard, Bronx BRONX 949-959 Southern Boulevard, Bronx 10459 Mixed Use Property 79141 1913 1 Not Available 73.9 0.0 167.2 449.2 61.1 165.1 284.0 3424871.3 0.0 0.0 1721964.0 0.0 0.0 0.0 2-02724-0186 2005787
61998 61998 2014 4413996 8500 4 Ave BROOKLYN 8500 4 Avenue 11209 Mixed Use Property 65000 1927 1 Not Available 0.0 0.0 0.0 0.0 0.0 290.4 0.0 0.0 4743499.6 0.0 0.0 511000.0 0.0 0.0 3060340041 3153126
61999 61999 2014 4414000 9201 4 Ave BROOKLYN 9201 4 Avenue 11209 Mixed Use Property 81000 1990 1 Not Available 0.0 0.0 0.0 0.0 0.0 131.0 0.0 0.0 2465700.0 0.0 0.0 0.0 0.0 0.0 3061080022 3155318
62023 62023 2014 4414302 151 Lawrence BROOKLYN 151 Lawrence Street 11201 Mixed Use Property 159000 1921 1 Not Available 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3001520006 3000404

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