GHG — Emissions and Intensity

Total, direct, indirect, and net GHG emissions. Includes GHGI (kgCO2e/m²) calculated for all years.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

188 rows where Borough = "QUEENS" and Property Type = "Residential Care Facility" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Grid Emissions Rate (kgCO2e/MBtu), ENERGY STAR Score

Calendar Year 9

Property Type 1

  • Residential Care Facility · 188 ✖

Borough 1

  • QUEENS · 188 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Net GHG (MtCO2e) Grid Emissions Rate (kgCO2e/MBtu) Avoided GHG Onsite (MtCO2e) Avoided GHG Offsite (MtCO2e) National Median GHG (MtCO2e) ENERGY STAR Score Site EUI (kBtu/ft2)
307293 307293 2024 2612621 Parker Jewish Institute For Health Care & Rehabilitation QUEENS 271-11 76th Ave Residential Care Facility 356,093 6360.39 192.24 3041.95 3318.43     0.0 0.0 5860.62 38.0 219.8
307920 307920 2024 2666061 Hillside Manor Rehabilitation and Extended Care enter, LLC QUEENS 182-15 Hillside Ave Residential Care Facility 124,108 1555.74 134.98 785.56 770.18     0.0 0.0 605.05 0.0 173.2
311533 311533 2024 3522450 119-15 27th Avenue (Parent Property) QUEENS 119-15 27th Avenue Residential Care Facility 55,969 1447.83 278.46 1123.52 324.31     0.0 0.0 289.4 0.0 428.3
311845 311845 2024 3553056 69-95 Queens Midtown Expressway QUEENS 69-95 Queens Midtown Expressway Residential Care Facility 66,223 509.12 82.77 126.5 382.62     0.0 0.0 307.2 0.0 86.0
313969 313969 2024 4931422 36-17 Parsons Blvd QUEENS 36-17 Parsons Blvd Residential Care Facility 173,519 1528.01 104.73 568.56 959.45     0.0 0.0 746.19 0.0 121.2
321831 321831 2024 7773411 Far Rockaway NH QUEENS 13-11 Virginia St Residential Care Facility 31,157 0.0 0.0 0.0 136.53     0.0 0.0 153.61 0.0 0.0
321832 321832 2024 7773412 Holliswood Center QUEENS 195-44 Woodhull Avenue Residential Care Facility 75,600 921.09 131.1 717.76 203.33     0.0 0.0 425.54 0.0 184.4
322126 322126 2024 8716365 2938 Far Rockaway Boulevard QUEENS 2938 Far Rockaway Boulevard Residential Care Facility 44,950 530.64 127.12 156.35 374.29     0.0 0.0 210.22 0.0 137.8
323158 323158 2024 10865438 Blake Partners - 9502 Rockaway Beach Boulevard QUEENS 9502 Rockaway Beach Boulevard Residential Care Facility 52,494 439.9 90.2 191.76 248.14     0.0 0.0 252.59 0.0 109.8
323159 323159 2024 10865439 Blake Partners - 210 Beach 47th Street QUEENS 210 Beach 47th Street Residential Care Facility 30,935 287.92 100.21 84.05 203.87     0.0 0.0 144.6 0.0 108.4
323163 323163 2024 10865536 Blake Partners - 350 Beach 54th St QUEENS 3-57 BEACH 53 STREET Residential Care Facility 67,161 342.44 54.9 68.16 274.28     0.0 0.0 308.26 0.0 54.6
323176 323176 2024 10868754 Meadow Park Rehab - 78-10 164th St QUEENS 78-10 164th St Residential Care Facility 31,236 367.68 126.69 152.49 215.18     0.0 0.0 149.65 0.0 151.8
323939 323939 2024 12660186 116-30 Sutphin Boulevard QUEENS 116-30 Sutphin Boulevard Residential Care Facility 48,148 346.84 77.5 146.33 200.51     0.0 0.0 231.01 0.0 93.4
325081 325081 2024 15624173 260-19 Nassau Boulevard QUEENS 260-19 Nassau Boulevard Residential Care Facility 46,411 389.69 90.42 191.76 197.94     0.0 0.0 225.91 0.0 114.8
326153 326153 2024 19927206 64-11 Beach Channel Drive QUEENS 3-20 Beach 65 Street Residential Care Facility 87,630 348.21 42.73 74.9 273.31     0.0 0.0 403.46 0.0 43.2
330214 330214 2024 26118881 80-45 Winchester Boulevard Building 74 QUEENS 80-45 Winchester Boulevard Building 74 Residential Care Facility 7,030 9679.44 14820.6 4109.35 5570.09     0.0 0.0 33.75 0.0 17890.0
331007 331007 2024 28621238 Fairview Nursing Care Center : 69-70 Grand Central Parkway QUEENS 69-70 Grand Central Parkway Residential Care Facility 51,467 611.76 127.98 232.49 379.27     0.0 0.0 244.85 0.0 149.1
332981 332981 2024 33950106 26-13 21st St QUEENS 26-13 21st St Residential Care Facility 159,582 1286.92 86.76 523.0 763.92     0.0 0.0 763.27 0.0 103.3
333450 333450 2024 34362608 29-64 Beach Channel Drive QUEENS 29-64 Beach Channel Drive Residential Care Facility 28,484 261.6 98.81 122.24 139.36     0.0 0.0 137.94 0.0 123.3
337499 337499 2024 54086895 BRC - VUE HOTEL - 40-47 22nd Street, LIC QUEENS 22-01 41 AVENUE Residential Care Facility 26,407 225.55 91.92 53.87 171.68     0.0 0.0 122.15 0.0 94.9
337500 337500 2024 54086896 BRC - Blue Sky Residence QUEENS 112-16 ASTORIA BOULEVARD Residential Care Facility 87,661 412.46 50.7 0.0 412.46     0.0 0.0 387.33 0.0 40.9
339304 339304 2024 56698598 182-15 Hillside Avenue QUEENS 182-15 Hillside Avenue Residential Care Facility 176,929 1596.77 97.09 831.03 765.74     0.0 0.0 867.04 0.0 125.9
341618 341618 2024 59760497 119-15 27th Avenue QUEENS 119-15 27th Avenue Residential Care Facility 27,985 0.0 0.0 0.0 0.0     0.0 0.0 137.97 0.0 0.0
341619 341619 2024 59763392 119-29 Rear 27th Avenue QUEENS 119-15 27th Avenue Residential Care Facility 27,984 0.0 0.0 0.0 0.0     0.0 0.0 137.97 0.0 0.0
273378 273378 2023 6707637 Queens Village for Mental Health - 116-30 Sutphin Blvd QUEENS 116-30 Sutphin Blvd Residential Care Facility 48,148 0.0 0.0 0.0 0.0     0.0 0.0 222.7 0.0 0.0
276331 276331 2023 7773411 Far Rockaway NH QUEENS 13-11 Virginia St Residential Care Facility 31,157 294.5 102.26 175.3 119.2     0.0 0.0 155.4 0.0 135.8
276332 276332 2023 7773412 Holliswood Center QUEENS 195-44 Woodhull Avenue Residential Care Facility 75,600 943.6 134.55 683.6 260.0     0.0 0.0 427.3 0.0 175.9
276493 276493 2023 8716365 2938 Far Rockaway Blvd QUEENS 2938 Far Rockaway Blvd Residential Care Facility 44,950 527.5 125.94 179.5 348.0     0.0 0.0 203.7 0.0 146.4
277524 277524 2023 10865438 Blake Partners - 9502 Rockaway Beach Boulevard QUEENS 9502 Rockaway Beach Boulevard Residential Care Facility 52,494 405.7 82.88 172.2 233.5     0.0 0.0 243.1 0.0 102.7
277525 277525 2023 10865439 Blake Partners - 210 Beach 47th Street QUEENS 210 Beach 47th Street Residential Care Facility 30,935 272.8 94.72 90.4 182.3     0.0 0.0 139.9 0.0 109.2
277529 277529 2023 10865536 Blake Partners - 350 Beach 54th St QUEENS 350 Beach 54th St Residential Care Facility 67,161 317.3 50.59 57.7 259.6     0.0 0.0 292.7 0.0 51.7
277530 277530 2023 10868754 Meadow Park Rehab - 78-10 164th St QUEENS 78-10 164th St Residential Care Facility 31,236 360.0 123.78 149.5 210.4     0.0 0.0 144.3 0.0 152.1
278441 278441 2023 12660186 116-30 Sutphin Boulevard QUEENS 116-30 Sutphin Boulevard Residential Care Facility 48,148 338.0 75.35 158.1 179.9     0.0 0.0 225.5 0.0 96.2
278560 278560 2023 11991738 Far Rockaway QUEENS 2964 Beach Channel Drive Residential Care Facility 27,981 138.2 52.74 138.2 0.0     0.0 0.0 152.2 0.0 93.0
278565 278565 2023 12051203 Gittel Realty QUEENS 143 Beach 118th Street Residential Care Facility 41,365 324.0 83.96 209.3 114.7     0.0 0.0 203.2 0.0 120.7
282033 282033 2023 2666061 Hillside Manor Rehabilitation and Extended Care enter, LLC QUEENS 182-15 Hillside Ave Residential Care Facility 124,108 1365.5 118.4 671.8 693.7     0.0 0.0 606.7 0.0 150.1
286552 286552 2023 3522450 119-15 27th Avenue QUEENS 119-15 27th Avenue Residential Care Facility 55,969 346.4 66.74 35.9 310.6     0.0 0.0 239.4 0.0 63.1
286948 286948 2023 3553056 69-95 Queens Midtown Expressway QUEENS 69-95 Queens Midtown Expressway Residential Care Facility 66,223 465.3 75.35 115.1 350.2     0.0 0.0 293.3 0.0 81.4
286956 286956 2023 3790092 119-19 Graham Court QUEENS 119-19 Graham Court Residential Care Facility 80,703 988.9 132.4 248.2 740.7     0.0 0.0 357.7 0.0 142.3
286957 286957 2023 3807576 119-09 26th Avenue QUEENS 119-09 26th Avenue Residential Care Facility 76,000 589.0 82.88 54.5 534.4     0.0 0.0 324.2 0.0 78.2
290007 290007 2023 33950106 26-13 21st St QUEENS 26-13 21st St Residential Care Facility 159,582 848.7 57.05 132.8 715.9     0.0 0.0 691.3 0.0 56.9
290043 290043 2023 33963887 112-16 Astoria Boulevard QUEENS 112-16 Astoria Boulevard Residential Care Facility 87,661 612.3 75.35 227.5 384.8     0.0 0.0 400.5 0.0 89.2
290718 290718 2023 35461037 143 Beach 118 St QUEENS 143 Beach 118 Street Residential Care Facility 41,365 324.2 83.96 209.3 115.0     0.0 0.0 203.1 0.0 120.8
290827 290827 2023 15624173 260-19 Nassau Boulevard QUEENS 260-19 Nassau Boulevard Residential Care Facility 46,411 593.1 137.78 378.9 214.2     0.0 0.0 227.5 0.0 196.2
292323 292323 2023 19927206 64-11 Beach Channel Drive QUEENS 64-11 Beach Channel Drive Residential Care Facility 87,630 345.9 41.98 74.0 271.9     0.0 0.0 384.9 0.0 44.4
296969 296969 2023 26118881 80-45 Winchester Boulevard Building 74 QUEENS 80-45 Winchester Boulevard Building 74 Residential Care Facility 7,030 8950.1 13703.52 3653.4 5296.7     0.0 0.0 32.4 0.0 16714.1
298204 298204 2023 28097477 109-09 Saultell Ave QUEENS 109-09 Saultell Avenue Residential Care Facility 56,725 947.0 179.76 358.8 588.1     0.0 0.0 259.6 0.0 214.5
300381 300381 2023 4931422 36-17 Parsons Blvd QUEENS 36-17 Parsons Blvd Residential Care Facility 101,640 1206.8 128.09 316.2 890.6     0.0 0.0 451.8 0.0 139.2
300696 300696 2023 5281058 Beach 50th Street LLC QUEENS 50-15 BEACH CHANNEL DRIVE Residential Care Facility 128,000 0.0 0.0 0.0 0.0     0.0 0.0 592.1 0.0 0.0
301949 301949 2023 6199797 71-20 110th Street QUEENS 71-20 110th Street Residential Care Facility 46,739 821.1 189.44 514.7 306.4     0.0 0.0 228.4 0.0 267.6
305483 305483 2023 6602381 157-15 19th Ave QUEENS 157-15 19th Ave Residential Care Facility 47,000 428.7 97.95 99.1 329.7     0.0 0.0 207.3 0.0 104.2
242203 242203 2022 7423609 142-31 Franklin Avenue QUEENS 142-31 Franklin Avenue Residential Care Facility 121,785 698.7 61.35 190.6 508.1 698.7   0.0 0.0 444.1 0.0 78.8
248045 248045 2022 2666061 Hillside Manor Rehabilitation and Extended Care enter, LLC QUEENS 182-15 Hillside Ave Residential Care Facility 124,108 1506.8 130.24 617.3 889.5 1506.8   0.0 0.0 604.6 0.0 154.2
250079 250079 2022 23351968 89-34 162 STREET QUEENS 89-34 162 STREET Residential Care Facility 30,266 140.0 49.51 53.0 87.0 140.0   0.0 0.0 115.9 0.0 67.0
251365 251365 2022 7773411 Far Rockaway NH QUEENS 13-11 Virginia St Residential Care Facility 31,157 304.1 105.49 211.2 92.9 304.1   0.0 0.0 147.3 0.0 153.5
251366 251366 2022 7773412 Holliswood Center QUEENS 195-44 Woodhull Avenue Residential Care Facility 75,600 926.3 132.4 646.4 279.9 926.3   0.0 0.0 398.4 0.0 168.5
251915 251915 2022 24693308 142-31 Franklin Ave QUEENS 142-31 Franklin Avenue Residential Care Facility 121,785 822.5 73.19 202.0 620.5 822.5   0.0 0.0 438.7 0.0 91.5
251931 251931 2022 28097477 109-09 Saultell Ave QUEENS 109-09 Saultell Avenue Residential Care Facility 56,725 904.8 172.22 362.3 542.6 904.8   0.0 0.0 219.5 0.0 233.4
256402 256402 2022 19927206 64-11 Beach Channel Drive QUEENS 64-11 Beach Channel Drive Residential Care Facility 87,630 289.4 35.52 83.1 206.4 289.4   0.0 0.0 321.6 0.0 45.7
258562 258562 2022 10865438 Blake Partners - 9502 Rockaway Beach Boulevard QUEENS 9502 Rockaway Beach Boulevard Residential Care Facility 52,494 405.5 82.88 213.8 191.7 405.5   0.0 0.0 216.4 0.0 119.9
258563 258563 2022 10865439 Blake Partners - 210 Beach 47th Street QUEENS 210 Beach 47th Street Residential Care Facility 30,935 248.5 86.11 109.0 139.5 248.5   0.0 0.0 122.0 0.0 119.7
258567 258567 2022 10865536 Blake Partners - 350 Beach 54th St QUEENS 350 Beach 54th St Residential Care Facility 67,161 275.2 44.13 57.5 217.7 275.2   0.0 0.0 238.0 0.0 54.5
258568 258568 2022 10868754 Meadow Park Rehab - 78-10 164th St QUEENS 78-10 164th St Residential Care Facility 31,236 345.2 119.48 181.9 163.4 345.2   0.0 0.0 128.7 0.0 171.5
260119 260119 2022 11991738 Far Rockaway QUEENS 2964 Beach Channel Drive Residential Care Facility 27,981 134.0 51.67 134.0 0.0 134.0   0.0 0.0 152.2 0.0 90.2
261574 261574 2022 6602381 157-15 19th Ave QUEENS 157-15 19th Ave Residential Care Facility 63,920 357.3 60.28 92.2 265.1 357.3   0.0 0.0 232.0 0.0 75.9
263656 263656 2022 2850851 80-08 45th Avenue QUEENS 80-08 45th Avenue Residential Care Facility 97,800 638.0 69.97 356.2 281.8 638.0   0.0 0.0 411.9 0.0 101.9
263663 263663 2022 2953874 431 Beach 20th Street QUEENS 431 Beach 20th Street Residential Care Facility 68,700 443.3 69.97 189.9 253.3 443.3   0.0 0.0 269.5 0.0 95.7
263719 263719 2022 3392484 61-80 Woodhaven Boulevard QUEENS 61-80 Woodhaven Boulevard Residential Care Facility 51,723 381.8 79.65 222.9 158.9 381.8   0.0 0.0 219.6 0.0 117.5
263748 263748 2022 3522450 119-15 27th Avenue QUEENS 119-15 27th Avenue Residential Care Facility 55,969 331.0 63.51 86.7 244.3 331.0   0.0 0.0 203.1 0.0 80.8
263806 263806 2022 3553056 69-95 Queens Midtown Expressway QUEENS 69-95 Queens Midtown Expressway Residential Care Facility 66,223 397.5 64.58 111.3 286.2 397.5   0.0 0.0 242.3 0.0 82.8
263808 263808 2022 3553077 143-10 20th Avenue QUEENS 143-10 20th Avenue Residential Care Facility 76,200 677.7 95.8 351.6 326.1 677.7   0.0 0.0 312.7 0.0 137.5
263814 263814 2022 3788161 100-30 Ditmars Boulevard QUEENS 100-30 Ditmars Boulevard Residential Care Facility 66,462 491.5 79.65 305.7 185.8 491.5   0.0 0.0 287.9 0.0 119.7
263815 263815 2022 3790092 119-19 Graham Court QUEENS 119-19 Graham Court Residential Care Facility 80,703 770.4 102.26 179.9 590.4 770.4   0.0 0.0 289.2 0.0 128.5
263816 263816 2022 3807576 119-09 26th Avenue QUEENS 119-09 26th Avenue Residential Care Facility 76,000 479.3 67.81 49.4 430.0 479.3   0.0 0.0 257.4 0.0 79.1
264013 264013 2022 4931422 36-17 Parsons Blvd QUEENS 36-17 Parsons Blvd Residential Care Facility 101,640 1138.5 120.56 397.1 741.4 1138.5   0.0 0.0 383.9 0.0 159.8
264304 264304 2022 6199797 71-20 110th Street QUEENS 71-20 110th Street Residential Care Facility 46,739 806.9 186.22 523.2 283.7 806.9   0.0 0.0 205.4 0.0 282.6
264312 264312 2022 6202407 112-14 Corona Avenue QUEENS 112-14 Corona Avenue Residential Care Facility 45,820 400.0 93.65 213.9 186.1 400.0   0.0 0.0 189.6 0.0 135.9
265502 265502 2022 8716365 2938 Far Rockaway Blvd QUEENS 2938 Far Rockaway Blvd Residential Care Facility 44,950 425.7 102.26 154.5 271.2 425.7   0.0 0.0 170.9 0.0 136.1
265691 265691 2022 10814177 138-49 Elder Avenue QUEENS 138-49 Elder Avenue Residential Care Facility 134,259 550.8 44.13 376.4 174.4 550.8   0.0 0.0 601.4 0.0 68.1
265696 265696 2022 10821375 1526 New Haven Avenue QUEENS 1526 New Haven Avenue Residential Care Facility 31,915 283.6 95.8 199.5 84.1 283.6   0.0 0.0 144.6 0.0 148.9
265814 265814 2022 11860911 140-40 Sanford Avenue QUEENS 140-40 Sanford Avenue Residential Care Facility 47,500 401.2 90.42 320.5 80.7 401.2   0.0 0.0 227.4 0.0 147.1
265858 265858 2022 12660186 116-30 Sutphin Boulevard QUEENS 116-30 Sutphin Boulevard Residential Care Facility 48,148 285.0 63.51 143.3 141.8 285.0   0.0 0.0 196.0 0.0 90.8
266129 266129 2022 16375847 14-41 Gateway Boulevard QUEENS 14-41 Gateway Boulevard Residential Care Facility 65,874 864.4 141.01 362.3 502.1 864.4   0.0 0.0 257.3 0.0 193.7
213246 213246 2021 6285574 Fairview Nursing Care Center QUEENS 69-70 Grand Central Parkway Residential Care Facility 48,100 547.1 122686.04 297.4 249.7 547.1 73.8 0.0 0.0   0.0 186.8
224101 224101 2021 7773411 Far Rockaway NH QUEENS 13-11 Virginia St Residential Care Facility 31,157 275.4 95625.1 187.4 88.0 275.4 73.8 0.0 0.0   0.0 151.5
224102 224102 2021 7773412 Holliswood Center QUEENS 195-44 Woodhull Avenue Residential Care Facility 75,600 743.5 106706.13 703.0 40.5 743.5 73.8 0.0 0.0   0.0 150.3
224633 224633 2021 6313905 71-11 Astoria Blvd (WIN Inc.) QUEENS 71-11 Astoria Blvd N Residential Care Facility 38,160 403.4 114267.3 287.7 115.7 403.4 73.8 0.0 0.0   4.0 153.3
225754 225754 2021 2850851 80-08 45th Avenue QUEENS 80-08 45th Avenue Residential Care Facility 97,800 591.0 65582.11 361.3 229.8 591.0 73.8 0.0 0.0   0.0 101.1
225756 225756 2021 3259888 34-45 70th Street QUEENS 34-45 70th Street Residential Care Facility 150,000 973.9 69886.41 384.8 589.1 973.9 73.8 0.0 0.0   0.0 101.5
226283 226283 2021 12051203 Gittel Realty QUEENS 143 Beach 118th Street Residential Care Facility 41,365 283.2 74349.67 199.7 83.5 283.2 73.8 0.0 0.0   0.0 118.3
227829 227829 2021 10865438 Blake Partners - 9502 Rockaway Beach Boulevard QUEENS 9502 Rockaway Beach Boulevard Residential Care Facility 52,494 346.9 71807.63 189.1 157.8 346.9 73.8 0.0 0.0   0.0 108.6
227830 227830 2021 10865439 Blake Partners - 210 Beach 47th Street QUEENS 210 Beach 47th Street Residential Care Facility 30,935 216.5 77679.48 99.3 117.3 216.5 73.8 0.0 0.0   0.0 111.8
227834 227834 2021 10865536 Blake Partners - 350 Beach 54th St QUEENS 350 Beach 54th St Residential Care Facility 67,161 253.5 40726.1 59.9 193.6 253.5 73.8 0.0 0.0   0.0 55.8
227835 227835 2021 10868754 Meadow Park Rehab - 78-10 164th St QUEENS 78-10 164th St Residential Care Facility 31,236 285.1 98993.16 150.1 135.0 285.1 73.8 0.0 0.0   0.0 149.0
228420 228420 2021 11860911 140-40 Sanford Avenue QUEENS 140-40 Sanford Avenue Residential Care Facility 47,500 370.1 84759.99 302.1 68.0 370.1 73.8 0.0 0.0   0.0 139.2
228459 228459 2021 12660186 116-30 Sutphin Boulevard QUEENS 116-30 Sutphin Boulevard Residential Care Facility 48,148 277.9 62318.5 142.7 135.2 277.9 73.8 0.0 0.0   0.0 93.8
228623 228623 2021 10821375 1526 New Haven Avenue QUEENS 1526 New Haven Avenue Residential Care Facility 31,915 256.4 89027.87 177.4 78.9 256.4 73.8 0.0 0.0   0.0 138.2
229079 229079 2021 3553056 69-95 Queens Midtown Expressway QUEENS 69-95 Queens Midtown Expressway Residential Care Facility 66,223 390.1 63621.17 113.0 277.1 390.1 73.8 0.0 0.0   0.0 88.8
229850 229850 2021 2953874 431 Beach 20th Street QUEENS 431 Beach 20th Street Residential Care Facility 68,700 390.5 61813.28 178.1 212.4 390.5 73.8 0.0 0.0   0.0 90.7
229858 229858 2021 4931422 36-17 Parsons Blvd QUEENS 36-17 Parsons Blvd Residential Care Facility 101,640 1242.4 132406.63 596.3 646.1 1242.4 73.8 0.0 0.0   0.0 196.6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE ghg(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Net GHG (MtCO2e)" REAL,
  "Grid Emissions Rate (kgCO2e/MBtu)" REAL,
  "Avoided GHG Onsite (MtCO2e)" REAL,
  "Avoided GHG Offsite (MtCO2e)" REAL,
  "National Median GHG (MtCO2e)" REAL,
  "ENERGY STAR Score" REAL,
  "Site EUI (kBtu/ft2)" REAL
);
CREATE INDEX "idx_ghg_Calendar Year" ON [ghg] ("Calendar Year");
CREATE INDEX "idx_ghg_Property ID" ON [ghg] ("Property ID");
CREATE INDEX "idx_ghg_Borough" ON [ghg] ("Borough");
CREATE INDEX "idx_ghg_Property Type" ON [ghg] ("Property Type");