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

90 rows where Calendar Year = 2011 and Property Type = "Senior Care Facility" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Electricity (kBtu), Fuel Oil #2 Use (kBtu)

Borough 5

Property Type 1

  • Senior Care Facility · 90 ✖

Calendar Year 1

  • 2011 · 90 ✖
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
10664 10664 2011 2815576 Cabrini MANHATTAN 542 East 5th street 10,009 Senior Care Facility 88,299 1970   94 96.9 98.9 188.4 591.37 72334.63 277.11 314.26 3.0 5.0           1004000031 1005026
10786 10786 2011 2798879 Rivington House MANHATTAN 45 Rivington Street 10,022 Senior Care Facility 157,500 1900   66 69.3 68.6 221.0 995.85 68275.35 38.07 957.78 10.0 715.0 10.0         1004200047 1005601
10913 10913 2011 2798880 Village Care Rehabilitation & Nursing Center MANHATTAN 214 West Houston Street 10,014 Senior Care Facility 67,473 2009   1 161.7 160.0 515.6 995.01 159853.55 38.07 956.93 10.0 715.0           1005280012 1088511
11497 11497 2011 2604568 2613 21St Street QUEENS 2613 21St Street 11,102 Senior Care Facility 159,582 1900   77 116.2 121.3 194.8 1.0 67.7 715.97 477.89 5.0 13.0           4008840065 4535406
12581 12581 2011 2798881 Village Housing Development MANHATTAN 510 West 46th street 10,036 Senior Care Facility 74,478 1999   100 40.9 41.8 90.6 225.24 32762.98 79.74 145.5 1.0 1.0           1010747502 1085777
12807 12807 2011 2671368 (7164) - The Fitzgerald Condo MANHATTAN 201 West 74th Street 10,023 Senior Care Facility 129,190 1922   0                             1011667501 1030741
12867 12867 2011 2944928 305 West End Avenue MANHATTAN 305 West End Avenue 10,023 Senior Care Facility 184,060 1900   0                             1011840077 1031008
13132 13132 2011 3238014 Archcare: MANHATTAN 150 Riverside Drive 10,024 Senior Care Facility 251,069 1940   62 71.7 71.7 239.3 1.0 42.88   1.0 17.0             1012490001 1033956
13970 13970 2011 2679127 Mary Manning Walsh Home MANHATTAN 1339 York Ave. 10,021 Senior Care Facility 255,982 1968   0                             1014660021  
14156 14156 2011 3238000 Archare: 1 MANHATTAN 1339 York Ave 10,021 Senior Care Facility 119,952 1968   56 71.7 71.7 239.3 806.94 72990.1   806.94 8.0             1014660021 1045836
14731 14731 2011 3122096 Cohen Rehab 30 W 138 ST. MANHATTAN 30 W 138 ST. 10,037 Senior Care Facility 90,000 1975   4 181.5 181.5 322.4 1.0 119.6 788.71 503.19 5.0 909.0   10.0       1017350047 1053921
14813 14813 2011 3111123 NORTHERN M MANHATTAN 116 E 125 ST 10,035 Senior Care Facility 127,000 1995   69 151.0 155.7 237.4 1.0 84.76 786.58 412.3 4.0 14.0           1017730007 1087050
15867 15867 2011 2818284 Rehabilitation and Continuing Care Center BRONX 2175 Quarry Road 10,457 Senior Care Facility 110,465 1994   1 452.6 452.6 635.2 4.0 391.41 3.0 793.04 8.0         41.0   2030640001 2094217;2094218;2094219;2094220;2815606;2822948;2118237
15976 15976 2011 2815635 Daughters BRONX 1160 Teller Ave 10,456 Senior Care Facility   1972                                 2023400045 2002160
16391 16391 2011 2794703 BETHCO - 6 BRONX 612 Allerton Avenue 10,467 Senior Care Facility 486,162 1934   79 114.2 113.3 201.7 4.0 88.59 2.0 1.0 17.0 2.0   34.0       2044270029 2051277;2801660;2111063
16459 16459 2011 2840010 Bronx Lebanon - 1650 Selwyn Ave. BRONX 1650 Selwyn Avenue 10,457 Senior Care Facility 255,597 1923   100 27.7 27.2 82.2 636.45 26865.43 78.54 557.91 5.0 234.0   898.0       2028240005 2094530
16460 16460 2011 2840040 Bronx Lebanon Hospital Center - 1770 Grand Concourse BRONX 1770 Grand Concourse 10,457 Senior Care Facility 140,700 1960   94 124.8 124.8 168.2 1.0 76.88 1.0 238.09 2.0 648.0       14.0   2028250017 2007876
16784 16784 2011 3164953 LACONIA NU BRONX 1040 E 230 ST 10,466 Senior Care Facility 74,400 1972   30 181.9 186.4 298.2 862.07 125395.07 533.81 328.25 3.0 10.0           2048760006 2065164
16877 16877 2011 3171835 Kittay Hou BRONX 2550 Webb Avenue 10,468 Senior Care Facility 200,776 1970   99 50.1 49.2 125.7 861.73 46377.88 256.13 605.6 6.0 1.0       2.0   2032200016 BIN# 2014843
16973 16973 2011 2741461 Kingsbridg BRONX 3400 Cannon Place 10,463 Senior Care Facility 133,600 1972   8 126.6 128.7 285.8 1.0 80.93 425.25 838.35 8.0 7.0   15.0       2032580162 2094698;2094699
17239 17239 2011 2729158 Grand Mano BRONX 700 White Plains Road 10,473 Senior Care Facility 78,347 1979   34 175.2 173.3 280.6 865.35 119417.19 553.51 311.84 3.0 10.0           2036040001 2022204
17325 17325 2011 2431296 Rebekah Rehab & Extended Care Rehab BRONX 1070 HAVEMEYER AVE ENT 10,462 Senior Care Facility 136,164 2007   20 144.8 150.4 313.6 1.0 79.15 537.05 903.11 9.0 10.0           2038270201 2026971
17455 17455 2011 3111261 SEPHARDIC HOME FOR THE AGED BROOKLYN 2266 CROPSEY AVE 11,214 Senior Care Facility 120,618 1931   8 207.1 205.3 388.2 1.0 89.7 850.73 846.53 9.0 15.0     69.0     3064710013 3329131
17493 17493 2011 3129529 Morningsid BRONX 1000 Pelham Parkway South 10,461 Senior Care Facility 115,000 1974   2 278.8 273.8 435.4 1.0 93.6 1.0 675.65 7.0 24.0   485.42       2043290001 2049614
17504 17504 2011 3129533 Morningside House Nursing - 1050 Pelham BRONX 1050 Pelham Parkway South 10,461 Senior Care Facility 115,000 1976   13 219.3 214.6 339.6 1.0 93.6 1.0 518.04 5.0 19.0   485.42       2043300001 2049625
17523 17523 2011 2812939 Goldcrest Care Center BRONX 2316 Bruner Avenue 10,469 Senior Care Facility   1954                                 2044160001 2097378
17524 17524 2011 2730462 Kings Harb BRONX 2000 East Gunhill Road 10,469 Senior Care Facility 188,760 1974   47 169.3 171.0 257.0 1.0 57.25 1.0 616.51 6.0 25.0           2044230001 2051208
17539 17539 2011 3209013 2401 Lacon BRONX 2401 Laconia Avenue 10,469 Senior Care Facility 50,396 1973   40 177.7 182.8 313.7 590.61 127145.34 327.31 263.3 2.0 6.0           2044490001 2095042
17575 17575 2011 2812903 Feildston Lodge LLC BRONX 666 Kappock Street 10,463 Senior Care Facility   1967                                 2057430029 2083468
17577 17577 2011 3130336 bronxwood BRONX 799 east gunhill road 10,467 Senior Care Facility 77,403 1973   23 71.7 71.7 239.3 520.71 72790.52   520.71 5.0             2046580021 Bin#2057709
17697 17697 2011 2977605 Workmen's BRONX 3155 Grace Avenue 104,693,134 Senior Care Facility 232,000 1951   12 176.0 174.6 298.4 3.0 139.19 2.0 1.0 11.0 4.0     24.0     2047770002 2062196
17735 17735 2011 2815629 Bay Park Center for Nursing & Rehab BRONX 801 Co-op City Blvd 10,475 Senior Care Facility   1974                                 2051410280 2072356
17739 17739 2011 2811671 3200 Baychester Ave. BRONX 3200 Baychester Ave. 10,475 Senior Care Facility 107,668 1900   88 197.6 219.4 247.6 1.0 100.6 1.0 179.34 1.0 19.0           2052230001 2072372
17747 17747 2011 2694082 Providence Rest BRONX 3304 Waterbury Avenue 10,465 Senior Care Facility 116,000 1940   18 159.5 165.0 271.7 1.0 92.79 703.19 497.62 5.0 13.0     44.0     2054090100 2075316
17748 17748 2011 2810979 Throgs Neck Extended Care Facility BRONX 707 Throgs Neck Expressway 10,465 Senior Care Facility   1977                                 2054340055 2077017
17772 17772 2011 3109946 MANHATTANVILLE HEALTHCARE CENTER BRONX 311 W 231 ST 10,463 Senior Care Facility 58,795 1975   15 171.7 175.4 388.2 754.52 140027.2 252.77 501.75 5.0 4.0           2057140141 2083218
17894 17894 2011 3121073 6585 Broadway BRONX 6585 Broadway 10,471 Senior Care Facility 59,499 1900   15 187.5 187.5 331.2 736.87 134433.81 408.12 328.75 3.0 7.0           2058721054 2085330
17904 17904 2011 2791082 Hebrew Hom BRONX 5901 Palisade Ave 10,471 Senior Care Facility 221,547 1931   14 186.7 178.5 325.5 2.0 97.41 1.0 1.0 12.0 28.0   708.0       2059330224 2116428;2100720;2086138;2116936
17934 17934 2011 2791058 Hebrew Hom BRONX 5931 Palisade Ave 10,471 Senior Care Facility 68,750 1986   23 162.2 165.6 299.9 756.61 119765.8 390.34 366.27 3.0 7.0   219.0       2059330210 2086137
17935 17935 2011 2791084 Hebrew Hom BRONX 5901 Palisade Ave 10,471 Senior Care Facility 313,451 1966   16 181.8 186.0 320.3 3.0 103.17 2.0 1.0 17.0 38.0   1.0       2059330225 2116937;2820375;2829101;2100720
18019 18019 2011 3109813 KFG LAND I LLC HOPKINS CENTER FOR REHAB BROOKLYN 155 DEAN ST 11,217 Senior Care Facility 135,000 1993   18 139.2 138.0 336.5 1.0 79.73 403.9 1.0 11.0 7.0   69.0       3001890001 3392440
18204 18204 2011 2682204 Prospect P BROOKLYN 1 Prospect Park West 11,215 Senior Care Facility 153,067 1931   4 103.5 103.3 208.2 1.0 70.35 487.95 625.7 6.0 9.0           3010660035  
18226 18226 2011 2794726 BETHCO - 5   520 Procpect Place 11,238 Senior Care Facility 118,230 1975   1 203.1 205.4 447.2 1.0 91.22 634.22 1.0 12.0 11.0           3011630001 3330782
18282 18282 2011 2735129 Marcus Garvey Rehab Pavilion BROOKLYN 810 St. Marks Avenue 11,213 Senior Care Facility 121,000 1976   80 58.2 57.0 188.5 656.33 58385.71 23.72 632.62 6.0         299.0   3012280017 3031031
18475 18475 2011 2794715 St. John's BROOKLYN 1840 Fulton Street 11,233 Senior Care Facility 124,239 1995   8 212.8 212.8 360.2 1.0 86.81 1.0 699.3 7.0 18.0           3017030014 3815533
18617 18617 2011 2815958 Atlantis - BROOKLYN 140 Saint Edwards Street 11,201 Senior Care Facility 129,776 1976   49 169.2 171.2 254.3 1.0 83.44 935.95 409.77 4.0 17.0           3020680117 3058264
18798 18798 2011 2931524 Buena Vida Continuing Care BROOKLYN 48 Cedar street 11,221 Senior Care Facility 110,000 2000   72 180.8 180.8 284.2 1.0 97.85 815.6 427.6 4.0 15.0         3.0 3032320001 3387647
19026 19026 2011 3104821 86 East 49 BROOKLYN 86 East 49th Street 11,203 Senior Care Facility 230,000 1925   1 358.2 357.9 614.2 5.0 234.0 3.0 2.0 23.0 58.0           3046020001 3327557
19208 19208 2011 3210511 NY Congregational Inc 11 BROOKLYN 135 Linden Blvd 11,226 Senior Care Facility 99,367 1997   6 149.6 152.8 280.6 1.0 108.73 505.28 504.15 5.0 9.0           3050840082 3350370
19306 19306 2011 2819359 DITHOLD ASSOCIATES BROOKLYN 2107 ditmas ave 11,226 Senior Care Facility 122,676 1975   69 90.1 90.9 220.4 862.3 76079.6 228.79 633.51 6.0 4.0           3051850042 3119523
19406 19406 2011 2736924 Palm Garde BROOKLYN 615 Avenue C 11,218 Senior Care Facility 111,667 1968   8 188.1 193.5 305.5 1.0 96.97 836.14 496.53 5.0 15.0           3053580041  
19451 19451 2011 2813838 631 Foster Avenue BROOKLYN 631 Foster Avenue 11,230 Senior Care Facility 51,420 1971   67 124.0 127.4 207.0 409.58 86444.67 246.96 162.61 1.0 4.0           3054280094 3128180
19460 19460 2011 3135223 Kfm Holdin BROOKLYN 5110 19th ave 11,204 Senior Care Facility 83,526 1931   99 70.7 73.2 122.2 385.71 50021.01 220.93 164.79 1.0 4.0           3054680035 3129735
19622 19622 2011 2817703 Hamilton Park Realty LLC BROOKLYN 691 92nd Street 11,229 Senior Care Facility 137,000 1990   1 781.5 781.5 961.2 6.0 471.41 5.0 802.27 8.0 98.0           3060940005 3388853
19677 19677 2011 3109843 KFG OPERATING 2 BROOKLYN 1740 84TH ST 11,214 Senior Care Facility 99,941 1974   48 99.7 99.7 264.8 814.56 88564.06 158.23 656.33 6.0 2.0           3063260038 3165136
19916 19916 2011 2731076 Chapin Hom QUEENS 165-01 Chapin Parkway 11,432 Senior Care Facility 98,642 1960   53 119.2 119.2 246.7 839.7 92229.05 347.4 492.31 5.0 6.0   45.0       4098580039 4210855
19952 19952 2011 2811129 Haym Salom BROOKLYN 2340 Cropsey Ave 11,214 Senior Care Facility 115,672 1970   18 224.1 223.0 384.4 1.0 93.6 1.0 714.13 7.0 15.0   3.0       3069250055 3187569
19978 19978 2011 2815491 Spring Creek Rehab BROOKLYN 660 Louisiana Ave 11,239 Senior Care Facility   2006                                 3082350150 3391223
19984 19984 2011 2602873 Metropolitan Jewish Healthcare System - Shorefront Center BROOKLYN 3015 West 29th Street 11,224 Senior Care Facility 174,788 1994   15 199.7 199.7 358.6 2.0 123.72 1.0 1.0 11.0 23.0           3070680014 3256861
19987 19987 2011 2744084 New Sea Cr BROOKLYN 3035 West 24th Street 11,224 Senior Care Facility 106,000 1973   72 133.9 138.8 293.6 1.0 101.55 377.46 666.0 7.0 7.0           3070700148 3189635
20045 20045 2011 2720409 Shore View BROOKLYN 2865 Brighton 3rd Street 11,235 Senior Care Facility 110,000 1969   35 237.2 236.4 334.6 1.0 97.85 1.0 388.48 4.0 21.0   0.0       3072610008 3196342
20231 20231 2011 2815658 River Mano BROOKLYN 611 E 103rd St 11,236 Senior Care Facility 123,140 1975   0                           47.0 3081720027 3229467
20237 20237 2011 2988237 Four Seasons Nursing & Rehab BROOKLYN 1555 Rockaway Parkway 11,236 Senior Care Facility 130,147 1975   21 96.8 98.0 284.5 1.0 82.8 117.1 976.0 10.0 2.0           3082050011 3230126
20338 20338 2011 2605035 Metropolitan Jewish Healthcare System - Menorah Center BROOKLYN 1516 Oriental Blvd. 11,235 Senior Care Facility 275,000 1985   20 115.6 116.8 237.3 2.0 78.28 949.06 1.0 13.0 17.0           3087600200 3246887
20356 20356 2011 2796713 SHEEPSHEAD NURSING HOME BROOKLYN 2840 KNAPP ST 11,235 Senior Care Facility 66,242 1969   7 161.4 161.4 366.2 800.64 130575.89 265.62 535.02 5.0 4.0           3088080045 3247955
20358 20358 2011 2933448 Palm Beach BROOKLYN 2900 Bragg Street 11,235 Senior Care Facility 89,472 1976   100 55.5 56.0 123.8 368.67 44587.94 128.03 240.64 2.0 2.0           3088150112  
20368 20368 2011 3116900 3900 Shore Parkway BROOKLYN 3900 Shore Parkway 11,235 Senior Care Facility 50,500 1960   3 151.5 156.0 290.8 539.98 116245.81 265.49 274.49 2.0 4.0   693.0       3088430164 3248660
20807 20807 2011 2932890 QUEENS BOU QUEENS 6111 QUEENS BLVD 11,377 Senior Care Facility 150,000 1995   24 138.8 132.4 250.9 1.0 71.76 740.26 648.53 6.0 13.0           4013390002 4449695
20940 20940 2011 2850851 Hofgur LLC DBA Queens Adult Care Center QUEENS 80-08 45th ave 11,373 Senior Care Facility 97,800 1926   92 108.2 113.0 169.7 663.87 73668.35 437.82 226.05 2.0 8.0   138.0       4015330036 4038364
21047 21047 2011 2819181 SIMONOFF, ELINORE QUEENS 59-20VAN DOREN STREET 11,368 Senior Care Facility 62,907 1970   41 150.4 148.6 268.5 627.29 108904.63 341.29 286.0 3.0 6.0           4019700025 4048470
21638 21638 2011 2610145 Flushing M QUEENS 139-66 35th avenue 11,354 Senior Care Facility 87,106 1972   7 152.4 151.5 270.1 1.0 123.72 639.74 406.2 4.0 927.0   8.0       4050020046 BIN #: 4113174
21640 21640 2011 2935573 Flushing M QUEENS 35-15 Parsons Boulevard 11,354 Senior Care Facility 95,000 1950   49 118.2 120.6 197.5 722.22 81830.57 435.45 286.77 3.0 8.0       12.0   4050030006 BIN# 4113182
21657 21657 2011 2679665 Flushing M QUEENS 36-17 Parsons Boulevard 11,354 Senior Care Facility 114,521 1997   0                             4050140004 BIN: 4113418
22116 22116 2011 2797082 Golden Gate Rehabilitation and Health Care Center STATEN IS 191 Bradley Ave 10,314 Senior Care Facility   1972                                 5007660017 5019636
22178 22178 2011 2954343 Resort Nursing Home QUEENS 430 Beach 68th Street 11,692 Senior Care Facility 94,116 1974   24 142.7 142.7 239.9 865.56 99114.91 516.66 348.9 3.0 9.0           4160410006 4439002
22188 22188 2011 2612621 Parker Jewish Institute For Health Care & Rehabilitation QUEENS 271-11 76th Ave 110,401,433 Senior Care Facility 381,993 1972   0                             4085200175 4-08520-0175
22249 22249 2011 2794704 BETHCO - 1 QUEENS 164-11 Chapin Parkway 11,432 Senior Care Facility 95,412 1950   4 287.0 287.7 398.7 1.0 113.3 1.0 383.72 4.0 23.0           4098580011 4210853
22432 22432 2011 2677469 Peninsula Center for Extended Care and Rehabilitation QUEENS 50-15 Beach Channel Drive 11,691 Senior Care Facility 125,000 1972   0                             4158420100 4301899
22474 22474 2011 2970316 West Lawre QUEENS 1410 Seagirt Blvd 11,691 Senior Care Facility 81,500 1973   0 156.6 156.6 222.5 962.29 127876.46 568.52 393.77 2.0 10.0           4156270045 4299228
22476 22476 2011 2815626 Brookhaven Rehab & Hcc QUEENS 250 Beach 17th St 11,691 Senior Care Facility   1974                                 4156310017 4299269
22493 22493 2011 2953874 Long Island Living Center Living Pro QUEENS 431 Beach 20th st 11,691 Senior Care Facility 97,800 1974   91 75.9 78.4 171.2 927.99 102977.23 186.47 741.52 3.0 3.0           4157670050 4301056
22515 22515 2011 2721444 Horizon Ca QUEENS 64-11 Beach Channel Drive 11,692 Senior Care Facility 87,036 1975   25 188.2 186.4 298.9 1.0 123.72 665.92 362.96 3.0 12.0           4159080009 4301970
22542 22542 2011 3189242 Park Inn H QUEENS 115-02 Ocean Promenade 11,694 Senior Care Facility 50,877 1928   0                           5.0 4161880034 4444819
22549 22549 2011 2610478 Boulevard Alp QUEENS 71-61 159th Street 11,365 Senior Care Facility 150,000 2005   12 171.7 175.0 255.8 1.0 71.76 1.0 467.39 4.0 20.0           4679740079 4531560
22573 22573 2011 2642148 harbor ter STATEN IS 110 henderson ave 10,301 Senior Care Facility 73,115 1975   91 42.0 42.0 140.3 288.31 42511.51   288.31 3.0             5000910043 BIN# 5002173
22574 22574 2011 2815788 Staten Isl STATEN IS 200 Lafayette Ave 10,301 Senior Care Facility 94,000 1975   0                           11.0 5000910070 5002177
22575 22575 2011 2951719 Silver Lake Nursing Home STATEN IS 275 Castleton Ave 10,301 Senior Care Facility   1967                                 5001190104 5002835
22587 22587 2011 2647074 135 Vanderbilt Avenue STATEN IS 135 Vanderbilt Avenue 10,304 Senior Care Facility 109,287 1900   5 236.9 242.2 416.4 1.0 98.75 950.92 753.02 8.0 17.0           5005340049 5013953
22627 22627 2011 2750743 Clove Lake STATEN IS 25 Fanning Street 103,145,307 Senior Care Facility 216,000 1968   94 39.0 39.0 130.2 790.75 39405.34   790.75 8.0             5007140001  
22629 22629 2011 2750743 Clove Lake STATEN IS 25 Fanning Street 103,145,307 Senior Care Facility 216,000 1968   94 39.0 39.0 130.2 790.75 39405.34   790.75 8.0             5007140065  

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