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

192 rows where Borough = "QUEENS" and Property Type = "Library" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address 1, Grid Emissions Rate (kgCO2e/MBtu)

Calendar Year 15

Property Type 1

  • Library · 192 ✖

Borough 1

  • QUEENS · 192 ✖
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)
327412 327412 2024 21353909 QPL_4745_Long Island City Community Library QUEENS 37-44 21st St Library 18,000 184.42 110.33 3.16 181.26     0.0 0.0 106.61 0.0 90.8
328193 328193 2024 21354828 CUNY CC > QCC_548_Queensborough CC: Kurt Schmeller Library QUEENS 222-05 56th Ave Library 108,533 0.0 0.0 0.0 0.0     0.0 0.0 603.36 0.0 0.0
328824 328824 2024 21355511 QPL_4722_Broadway Community Library QUEENS 40-20 Broadway Library 15,700 78.47 53.82 0.0 78.47     0.0 0.0 92.69 0.0 43.4
328825 328825 2024 21355512 QPL_4726_Douglaston/Little Neck Community Library QUEENS 249-01 Northern Blvd Library 10,200 34.21 36.06 9.99 24.22     0.0 0.0 63.71 0.0 39.1
328826 328826 2024 21355513 QPL_4727_East Elmhurst Community Library QUEENS 95-06 Astoria Blvd Library 13,761 92.93 72.66 10.63 82.3     0.0 0.0 83.02 0.0 66.5
328827 328827 2024 21355514 QPL_4732_Forest Hills Community Library QUEENS 108-19 71st Ave Library 21,950 149.39 73.3 42.13 107.26     0.0 0.0 136.82 0.0 78.6
328828 328828 2024 21355515 QPL_4735_Glendale Community Library QUEENS 78-60 73rd Pl Library 10,800 73.07 72.87 15.51 57.56     0.0 0.0 66.4 0.0 73.3
328829 328829 2024 21355516 QPL_4740_Kew Gardens Hills Community Library QUEENS 72-33 Vleigh Pl Library 11,666 102.15 94.29 18.34 83.81     0.0 0.0 71.27 0.0 92.0
328830 328830 2024 21355517 QPL_4741_Langston Hughes Community Library QUEENS 100-01 Northern Blvd Library 23,000 172.81 80.84 35.45 137.36     0.0 0.0 141.21 0.0 80.9
328831 328831 2024 21355518 QPL_4753_Peninsula (ALC) Community Library QUEENS 92-25 Rockaway Beach Blvd Library 12,750 80.2 67.7 18.44 61.76     0.0 0.0 78.66 0.0 69.3
328832 328832 2024 21355519 QPL_4761_Ridgewood Community Library QUEENS 20-12 Madison St Library 14,000 109.19 83.96 37.66 71.52     0.0 0.0 88.37 0.0 95.0
328833 328833 2024 21355520 QPL_4774_Woodside Community Library QUEENS 54-22 Skillman Ave Library 10,800 74.89 74.59 32.87 42.02     0.0 0.0 69.48 0.0 91.1
328837 328837 2024 21355524 QPL_5158_Flushing (ALC) Community Library QUEENS 41-17 Main St Library 76,000 880.37 124.65 0.0 880.37     0.0 0.0 448.68 0.0 100.7
328877 328877 2024 21355578 QPL_11593_Hunters Point Community Library QUEENS 47-40 Center Blvd Library 21,800 296.17 146.28 49.93 246.23     0.0 0.0 132.9 0.0 141.3
328933 328933 2024 21355636 QPL_4756_Queens Central Library QUEENS 89-11 Merrick Blvd Library 239,750 2003.95 89.99 385.99 1617.96     0.0 0.0 1468.42 0.0 88.9
329005 329005 2024 21355756 QPL_4769_Steinway (ALC) Community Library QUEENS 21-45 31st St Library 11,200 59.79 57.48 28.65 31.14     0.0 0.0 72.65 0.0 72.3
275738 275738 2023 7447886 Feil - 31-11 Thomson Avenue QUEENS 31-11 Thomson Avenue Library 138,475 1721.5 133.47 460.0 1261.5     0.0 0.0 823.4 0.0 146.3
293865 293865 2023 21353909 QPL_4745_Long Island City Community Library QUEENS 37-44 21st St Library 18,000 173.5 103.33 23.7 149.8     0.0 0.0 103.7 0.0 101.3
294697 294697 2023 21354767 CUNY SC > QC_483_Queens College: Benjamin Rosenthal Library QUEENS 65-76 Kissena Blvd Library 241,178 0.0 0.0 0.0 0.0     0.0 0.0 1376.0 0.0 0.0
294757 294757 2023 21354828 CUNY CC > QCC_548_Queensborough CC: Kurt Schmeller Library QUEENS 222-05 56th Ave Library 108,533 0.0 0.0 0.0 0.0     0.0 0.0 619.2 0.0 0.0
295441 295441 2023 21355511 QPL_4722_Broadway Community Library QUEENS 40-20 Broadway Library 15,700 77.7 52.74 0.0 77.7     0.0 0.0 87.6 0.0 45.5
295442 295442 2023 21355512 QPL_4726_Douglaston/Little Neck Community Library QUEENS 249-01 Northern Blvd Library 10,200 35.7 37.67 11.1 24.6     0.0 0.0 61.3 0.0 42.7
295443 295443 2023 21355513 QPL_4727_East Elmhurst Community Library QUEENS 95-06 Astoria Blvd Library 11,860 81.9 74.27 5.6 76.3     0.0 0.0 67.2 0.0 68.0
295444 295444 2023 21355514 QPL_4732_Forest Hills Community Library QUEENS 108-19 71st Ave Library 23,739 113.5 51.67 29.2 84.2     0.0 0.0 140.8 0.0 55.8
295445 295445 2023 21355515 QPL_4735_Glendale Community Library QUEENS 78-60 73rd Pl Library 10,800 74.6 74.27 29.4 45.2     0.0 0.0 66.3 0.0 89.8
295446 295446 2023 21355516 QPL_4740_Kew Gardens Hills Community Library QUEENS 72-33 Vleigh Pl Library 11,666 103.8 95.8 15.2 88.6     0.0 0.0 67.4 0.0 94.3
295447 295447 2023 21355517 QPL_4741_Langston Hughes Community Library QUEENS 100-01 Northern Blvd Library 23,000 198.0 92.57 39.0 159.0     0.0 0.0 134.4 0.0 95.5
295448 295448 2023 21355518 QPL_4753_Peninsula (ALC) Community Library QUEENS 92-25 Rockaway Beach Blvd Library 12,750 70.1 59.2 13.1 57.0     0.0 0.0 74.3 0.0 60.5
295449 295449 2023 21355519 QPL_4761_Ridgewood Community Library QUEENS 20-12 Madison St Library 14,000 97.3 74.27 26.5 70.7     0.0 0.0 83.4 0.0 82.1
295450 295450 2023 21355520 QPL_4774_Woodside Community Library QUEENS 54-22 Skillman Ave Library 10,800 84.6 83.96 30.2 54.4     0.0 0.0 65.7 0.0 99.0
295454 295454 2023 21355524 QPL_5158_Flushing (ALC) Community Library QUEENS 41-17 Main St Library 76,000 853.3 120.56 16.9 836.4     0.0 0.0 425.8 0.0 105.4
295497 295497 2023 21355578 QPL_11593_Hunters Point Community Library QUEENS 47-40 Center Blvd Library 23,180 277.5 129.17 49.6 227.9     0.0 0.0 134.9 0.0 130.7
295554 295554 2023 21355636 QPL_4756_Queens Central Library QUEENS 89-11 Merrick Blvd Library 239,750 1833.6 81.81 294.3 1539.3     0.0 0.0 1389.0 0.0 82.2
295628 295628 2023 21355756 QPL_4769_Steinway (ALC) Community Library QUEENS 21-45 31st St Library 11,200 17.8 17.22 0.0 17.8     0.0 0.0 62.5 0.0 14.6
263068 263068 2022 7447886 Feil - 31-11 Thomson Avenue QUEENS 31-11 Thomson Avenue Library 138,475 1584.9 122.71 549.0 1035.9 1584.9   0.0 0.0 698.0 0.0 163.1
269758 269758 2022 21353909 QPL_4745_Long Island City Community Library QUEENS 37-44 21st St Library 18,000 148.0 88.26 51.3 96.7 148.0   0.0 0.0 90.8 0.0 117.2
270592 270592 2022 21354767 CUNY SC > QC_483_Queens College: Benjamin Rosenthal Library QUEENS 65-76 Kissena Blvd Library 241,178 0.0 0.0 0.0 0.0 0.0   0.0 0.0 1176.7 0.0 0.0
270652 270652 2022 21354828 CUNY CC > QCC_548_Queensborough CC: Kurt Schmeller Library QUEENS 222-05 56th Ave Library 108,533 0.0 0.0 0.0 0.0 0.0   0.0 0.0 529.5 0.0 0.0
271329 271329 2022 21355511 QPL_4722_Broadway Community Library QUEENS 40-20 Broadway Library 15,700 142.2 97.95 98.0 44.3 142.2   0.0 0.0 94.3 0.0 150.8
271330 271330 2022 21355512 QPL_4726_Douglaston/Little Neck Community Library QUEENS 249-01 Northern Blvd Library 10,200 32.2 34.44 12.7 19.5 32.2   0.0 0.0 52.6 0.0 46.0
271331 271331 2022 21355513 QPL_4727_East Elmhurst Community Library QUEENS 95-06 Astoria Blvd Library 11,860 63.8 58.13 10.9 52.9 63.8   0.0 0.0 55.2 0.0 70.1
271332 271332 2022 21355514 QPL_4732_Forest Hills Community Library QUEENS 108-19 71st Ave Library 23,739 89.5 40.9 33.6 55.9 89.5   0.0 0.0 121.3 0.0 54.5
271333 271333 2022 21355515 QPL_4735_Glendale Community Library QUEENS 78-60 73rd Pl Library 10,800 65.2 64.58 31.5 33.6 65.2   0.0 0.0 58.2 0.0 91.8
271334 271334 2022 21355516 QPL_4740_Kew Gardens Hills Community Library QUEENS 72-33 Vleigh Pl Library 11,666 103.5 95.8 36.5 67.0 103.5   0.0 0.0 59.0 0.0 126.8
271335 271335 2022 21355517 QPL_4741_Langston Hughes Community Library QUEENS 100-01 Northern Blvd Library 23,000 141.8 66.74 46.9 95.0 141.8   0.0 0.0 115.1 0.0 87.2
271336 271336 2022 21355518 QPL_4753_Peninsula (ALC) Community Library QUEENS 92-25 Rockaway Beach Blvd Library 12,750 57.6 48.44 13.7 43.8 57.6   0.0 0.0 61.2 0.0 61.0
271337 271337 2022 21355519 QPL_4761_Ridgewood Community Library QUEENS 20-12 Madison St Library 14,000 97.4 75.35 34.5 62.9 97.4   0.0 0.0 70.8 0.0 99.6
271338 271338 2022 21355520 QPL_4774_Woodside Community Library QUEENS 54-22 Skillman Ave Library 10,800 63.3 63.51 27.8 35.5 63.3   0.0 0.0 56.9 0.0 87.3
271342 271342 2022 21355524 QPL_5158_Flushing (ALC) Community Library QUEENS 41-17 Main St Library 76,000 572.5 80.73 16.0 556.5 572.5   0.0 0.0 333.3 0.0 90.6
271384 271384 2022 21355578 QPL_11593_Hunters Point Community Library QUEENS 47-40 Center Blvd Library 23,180 227.4 105.49 63.0 164.4 227.4   0.0 0.0 113.2 0.0 135.1
271442 271442 2022 21355636 QPL_4756_Queens Central Library QUEENS 89-11 Merrick Blvd Library 239,750 1476.3 66.74 336.0 1140.4 1476.3   0.0 0.0 1144.7 0.0 82.6
271524 271524 2022 21355756 QPL_4769_Steinway (ALC) Community Library QUEENS 21-45 31st St Library 11,200 21.8 20.45 0.0 21.8 21.8   0.0 0.0 48.6 0.0 23.0
222113 222113 2021 21353909 QPL_4745_Long Island City Community Library QUEENS 37-44 21st St Library 18,000 143.6 85872.0 48.0 95.6 143.6 73.8 0.0 0.0   0.0 122.2
222969 222969 2021 21354767 CUNY SC > QC_483_Queens College: Benjamin Rosenthal Library QUEENS 65-76 Kissena Blvd Library 241,178 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
223030 223030 2021 21354828 CUNY CC > QCC_548_Queensborough CC: Kurt Schmeller Library QUEENS 222-05 56th Ave Library 108,533 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
223711 223711 2021 21355511 QPL_4722_Broadway Community Library QUEENS 40-20 Broadway Library 15,700 253.4 181838.15 194.2 59.2 253.4 73.8 0.0 0.0   0.0 284.0
223712 223712 2021 21355512 QPL_4726_Douglaston/Little Neck Community Library QUEENS 249-01 Northern Blvd Library 10,200 27.0 29062.53 11.9 15.1 27.0 73.8 0.0 0.0   0.0 42.0
223713 223713 2021 21355513 QPL_4727_East Elmhurst Community Library QUEENS 95-06 Astoria Blvd Library 11,860 70.2 68693.25 11.4 58.8 70.2 73.8 0.0 0.0   0.0 85.4
223714 223714 2021 21355514 QPL_4732_Forest Hills Community Library QUEENS 108-19 71st Ave Library 23,739 84.5 39545.63 30.4 54.1 84.5 73.8 0.0 0.0   0.0 55.0
223715 223715 2021 21355515 QPL_4735_Glendale Community Library QUEENS 78-60 73rd Pl Library 10,800 59.0 63507.01 27.6 31.4 59.0 73.8 0.0 0.0   0.0 87.6
223716 223716 2021 21355516 QPL_4740_Kew Gardens Hills Community Library QUEENS 72-33 Vleigh Pl Library 11,666 76.0 74368.76 16.6 59.4 76.0 73.8 0.0 0.0   0.0 95.8
223717 223717 2021 21355517 QPL_4741_Langston Hughes Community Library QUEENS 100-01 Northern Blvd Library 23,000 155.8 72913.72 53.5 102.4 155.8 73.8 0.0 0.0   0.0 104.1
223718 223718 2021 21355518 QPL_4753_Peninsula (ALC) Community Library QUEENS 92-25 Rockaway Beach Blvd Library 12,750 62.0 55613.48 22.3 39.7 62.0 73.8 0.0 0.0   0.0 75.2
223719 223719 2021 21355519 QPL_4761_Ridgewood Community Library QUEENS 20-12 Madison St Library 14,000 91.9 70657.32 30.6 61.3 91.9 73.8 0.0 0.0   0.0 100.5
223720 223720 2021 21355520 QPL_4774_Woodside Community Library QUEENS 54-22 Skillman Ave Library 10,800 61.4 66090.35 29.2 32.2 61.4 73.8 0.0 0.0   0.0 91.4
223724 223724 2021 21355524 QPL_5158_Flushing (ALC) Community Library QUEENS 41-17 Main St Library 76,000 439.9 62303.15 116.6 323.3 439.9 73.8 0.0 0.0   0.0 86.5
223778 223778 2021 21355578 QPL_11593_Hunters Point Community Library QUEENS 47-40 Center Blvd Library 23,180 160.0 74879.3 41.2 118.8 160.0 73.8 0.0 0.0   0.0 102.9
223836 223836 2021 21355636 QPL_4756_Queens Central Library QUEENS 89-11 Merrick Blvd Library 239,750 1470.1 66209.24 386.6 1083.4 1470.1 73.8 0.0 0.0   0.0 91.6
223861 223861 2021 21355661 QPL_11886_Glendale Community Library QUEENS 78-60 73rd Pl Library 13,356 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
223924 223924 2021 21355756 QPL_4769_Steinway (ALC) Community Library QUEENS 21-45 31st St Library 11,200 83.9 82099.2 67.4 16.5 83.9 73.8 0.0 0.0   0.0 133.3
224938 224938 2021 7447886 Feil - 31-11 Thomson Avenue QUEENS 31-11 Thomson Avenue Library 138,475 75.5 5888.95 0.0 75.5 75.5 73.8 0.0 0.0   0.0 7.4
198400 198400 2020 6297287 QPL - 4157389 - Bayside Community Library (LL84) QUEENS 214-20 Northern Blvd Library 10300 50.5 52.77 11.8 38.7 50.5 79.5 0.0 0.0   0.0 68.9
198401 198401 2020 6297291 QPL - 4011018 - Broadway Community Library (LL84) QUEENS 40-20 Broadway Library 15700 388.9 266.63 339.4 49.4 388.9 79.5 0.0 0.0   0.0 446.7
198402 198402 2020 6297292 QPL - 4536041 - Cambria Heights Community Library (LL84) QUEENS 218-13 Linden Blvd Library 18000 108.7 65.0 30.2 78.5 108.7 79.5 0.0 0.0   0.0 86.5
198403 198403 2020 6297294 QPL - 4169275 - Douglaston Little Neck Community Library (LL84) QUEENS 249-01 Northern Blvd Library 10200 30.9 32.61 9.3 21.6 30.9 79.5 0.0 0.0   0.0 43.9
198404 198404 2020 6297295 QPL - 4437122 - East Elmhurst Community Library (LL84) QUEENS 95-06 Astoria Blvd Library 11860 72.0 65.35 9.5 62.5 72.0 79.5 0.0 0.0   0.0 81.3
198405 198405 2020 6297297 QPL - 4539447 - Elmhurst (ALC) Community Library (LL84) QUEENS 85-08 51st Ave Library 30000 245.1 87.94 70.7 174.4 245.1 79.5 0.0 0.0   0.0 117.5
198406 198406 2020 6297301 QPL - 4052345 - Forest Hills Community Library (LL84) QUEENS 108-19 71st Ave Library 23739 113.1 51.28 54.0 59.1 113.1 79.5 0.0 0.0   0.0 74.2
198407 198407 2020 6297303 QPL - 4177530 - Glen Oaks Community Library (LL84) QUEENS 256-04 Union Tpke Library 18000 126.9 75.89 38.4 88.4 126.9 79.5 0.0 0.0   0.0 102.0
198408 198408 2020 6297309 QPL - 4029693 - Jackson Heights Community Library (LL84) QUEENS 35-51 81st St Library 18038 82.9 49.47 18.9 64.0 82.9 79.5 0.0 0.0   0.0 64.3
198409 198409 2020 6297310 QPL - 4144059 - Kew Gardens Hills Community Library (LL84) QUEENS 72-33 Vleigh Pl Library 11666 82.0 75.66 20.4 61.6 82.0 79.5 0.0 0.0   0.0 99.4
198410 198410 2020 6297311 QPL - 4437193 - Langston Hughes Community Library (LL84) QUEENS 100-01 Northern Blvd Library 23000 144.3 67.53 54.6 89.7 144.3 79.5 0.0 0.0   0.0 93.8
198411 198411 2020 6297323 QPL - 4303629 - Peninsula (ALC) Community Library (LL84) QUEENS 92-25 Rockaway Beach Blvd Library 12750 57.1 48.21 20.6 36.4 57.1 79.5 0.0 0.0   0.0 66.4
198412 198412 2020 6297326 QPL - 4209635 - Queens Central Library (LL84) QUEENS 89-11 Merrick Blvd Library 239750 1482.3 66.55 392.4 1089.9 1482.3 79.5 0.0 0.0   0.0 88.0
198413 198413 2020 6297327 QPL - 4226761 - Queens Village Community Library (LL84) QUEENS 94-11 217th St Library 12300 39.1 34.22 12.9 26.2 39.1 79.5 0.0 0.0   0.0 46.6
198414 198414 2020 6297330 QPL - 4193458 - Richmond Hill Community Library (LL84) QUEENS 118-14 Hillside Ave Library 13000 51.7 42.81 43.3 8.4 51.7 79.5 0.0 0.0   0.0 70.8
198415 198415 2020 6297331 QPL - 4083512 - Ridgewood Community Library (LL84) QUEENS 20-12 Madison St Library 14000 105.8 81.34 38.3 67.5 105.8 79.5 0.0 0.0   0.0 112.2
198416 198416 2020 6297336 QPL - 4539786 - South Jamaica Community Library (LL84) QUEENS 108-41 Guy R. Brewer Blvd Library 13500 58.6 46.72 29.4 29.1 58.6 79.5 0.0 0.0   0.0 68.2
198417 198417 2020 6297344 QPL - 4030847 - Woodside Community Library (LL84) QUEENS 54-22 Skillman Ave Library 10800 73.1 72.86 28.0 45.1 73.1 79.5 0.0 0.0   0.0 101.3
198423 198423 2020 6297358 QPL - 4114282 - Flushing (ALC) Community Library (LL84) QUEENS 41-17 Main St Library 76000 642.5 91.0 277.3 365.2 642.5 79.5 0.0 0.0   0.0 129.2
208924 208924 2020 12344625 BBL 4-00019-0021: QPL (LL84) QUEENS 47-40 Center Blvd Library 46360 140.4 32.6 7.2 133.2 140.4 79.5 0.0 0.0   0.0 39.1
170979 170979 2019 6297287 QPL - 4157389 - Bayside Community Library (LL84) QUEENS 214-20 Northern Blvd Library 10,300 55.5 59739.64 13.7 41.8 55.5 79.5 0.0 0.0   0.0 76.0
170980 170980 2019 6297291 QPL - 4011018 - Broadway Community Library (LL84) QUEENS 40-20 Broadway Library 15,700 430.3 308780.41 363.6 66.6 430.3 79.5 0.0 0.0   0.0 489.5
170981 170981 2019 6297292 QPL - 4536041 - Cambria Heights Community Library (LL84) QUEENS 218-13 Linden Blvd Library 18,000 105.9 63327.61 24.7 81.2 105.9 79.5 0.0 0.0   0.0 82.6
170982 170982 2019 6297294 QPL - 4169275 - Douglaston Little Neck Community Library (LL84) QUEENS 249-01 Northern Blvd Library 10,200 31.3 33691.01 13.0 18.3 31.3 79.5 0.0 0.0   0.0 46.5
170983 170983 2019 6297295 QPL - 4437122 - East Elmhurst Community Library (LL84) QUEENS 95-06 Astoria Blvd Library 11,860 75.1 73488.08 20.2 54.9 75.1 79.5 0.0 0.0   0.0 90.3
170984 170984 2019 6297297 QPL - 4539447 - Elmhurst (ALC) Community Library (LL84) QUEENS 85-08 51st Ave Library 30,000 305.8 109720.02 66.8 239.0 305.8 79.5 0.0 0.0   0.0 142.2
170985 170985 2019 6297301 QPL - 4052345 - Forest Hills Community Library (LL84) QUEENS 108-19 71st Ave Library 23,739 107.7 50403.13 40.5 67.3 107.7 79.5 0.0 0.0   0.0 67.7
170986 170986 2019 6297303 QPL - 4177530 - Glen Oaks Community Library (LL84) QUEENS 256-04 Union Tpke Library 18,000 130.4 77978.48 31.1 99.2 130.4 79.5 0.0 0.0   0.0 101.9
170987 170987 2019 6297305 QPL - 4090100 - Glendale Community Library (LL84) (Out of service) QUEENS 78-60 73rd Pl Library 10,800 29.3 31538.23 0.0 29.3 29.3 84.7 0.0 0.0   0.0 32.1

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