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

281 rows where Borough = "QUEENS" and Property Type = "Other - Public Services" 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

These facets timed out: Property Type

Calendar Year 10

Borough 1

  • QUEENS · 281 ✖
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)
328072 328072 2024 21354645 Benchmarking Group - 50 QUEENS Fort Totten Other - Public Services 643,459 2478.78 41.44 1076.53 1402.25     0.0 0.0 2919.69 0.0 41.5
328100 328100 2024 21354673 FDNY_10423_Fort Totten: Building 103 (EMS Marine 4/Training) QUEENS 103 Totten Ave Other - Public Services 4,591 0.0 0.0 0.0 0.0     0.0 0.0 15.77 0.0 0.0
328101 328101 2024 21354674 FDNY_10424_Fort Totten: Building 107 QUEENS 107 Duane Rd Other - Public Services 12,404 0.0 0.0 0.0 0.0     0.0 0.0 42.62 0.0 0.0
328102 328102 2024 21354675 FDNY_10425_Fort Totten: Building 316 QUEENS 316 Sergeant Beers Ave Other - Public Services 4,287 0.0 0.0 0.0 0.0     0.0 0.0 14.73 0.0 0.0
328103 328103 2024 21354676 FDNY_10426_Fort Totten: Building 325 QUEENS 325 Pratt Ave Other - Public Services 31,892 0.0 0.0 0.0 0.0     0.0 0.0 109.58 0.0 0.0
328104 328104 2024 21354677 FDNY_10427_Fort Totten: Building 336 QUEENS 336 Shore Rd Other - Public Services 23,732 0.0 0.0 0.0 0.0     0.0 0.0 81.54 0.0 0.0
328105 328105 2024 21354678 FDNY_10428_Fort Totten: Building 418 QUEENS 418 Weaver Ave Other - Public Services 10,935 0.0 0.0 0.0 0.0     0.0 0.0 37.57 0.0 0.0
328106 328106 2024 21354679 FDNY_10446_Fort Totten: Building 411 QUEENS 411 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 47.17 0.0 0.0
328109 328109 2024 21354682 FDNY_10450_Fort Totten: Building 413 QUEENS 413 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 47.17 0.0 0.0
328110 328110 2024 21354683 FDNY_10451_Fort Totten: Building 327 QUEENS Fort Totten Other - Public Services 101 0.0 0.0 0.0 0.0     0.0 0.0 0.35 0.0 0.0
328111 328111 2024 21354684 FDNY_10452_Fort Totten: Building 409 QUEENS 409 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 47.17 0.0 0.0
328112 328112 2024 21354689 FDNY_10457_Fort Totten: Building 129 QUEENS 129 Sergeant Beers Ln Other - Public Services 4,566 0.0 0.0 0.0 0.0     0.0 0.0 15.69 0.0 0.0
328113 328113 2024 21354690 FDNY_10458_Fort Totten: Building 135 QUEENS 135 General Berry Dr Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 14.91 0.0 0.0
328114 328114 2024 21354691 FDNY_10459_Fort Totten: Building 136 QUEENS 136 General Berry Dr Other - Public Services 4,287 0.0 0.0 0.0 0.0     0.0 0.0 14.73 0.0 0.0
328115 328115 2024 21354693 FDNY_10461_Fort Totten: Building 138 QUEENS 138 General Berry Dr Other - Public Services 4,048 0.0 0.0 0.0 0.0     0.0 0.0 13.91 0.0 0.0
328116 328116 2024 21354700 FDNY_10471_Fort Totten: Building 304 QUEENS 304 Shore Rd Other - Public Services 28,831 0.0 0.0 0.0 0.0     0.0 0.0 99.06 0.0 0.0
328117 328117 2024 21354701 FDNY_10472_Fort Totten: Building 305 QUEENS 305 Shore Rd Other - Public Services 1,555 0.0 0.0 0.0 0.0     0.0 0.0 5.34 0.0 0.0
328118 328118 2024 21354702 FDNY_10473_Fort Totten: Building 306 QUEENS 306 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 14.41 0.0 0.0
328119 328119 2024 21354703 FDNY_10474_Fort Totten: Building 307 QUEENS 307 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 14.41 0.0 0.0
328120 328120 2024 21354704 FDNY_10475_Fort Totten: Building 308 QUEENS 308 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 14.41 0.0 0.0
328122 328122 2024 21354706 FDNY_10477_Fort Totten: Building 311 QUEENS 311 Theater Rd Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 3.0 0.0 0.0
328123 328123 2024 21354707 FDNY_10479_Fort Totten: Building 400 QUEENS 400 Murray Ave Other - Public Services 10,935 0.0 0.0 0.0 0.0     0.0 0.0 37.57 0.0 0.0
328124 328124 2024 21354708 FDNY_10480_Fort Totten: Building 315 QUEENS Fort Totten Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 3.0 0.0 0.0
328125 328125 2024 21354709 FDNY_10481_Fort Totten: Building 331 QUEENS 331 Pratt ave Other - Public Services 2,550 0.0 0.0 0.0 0.0     0.0 0.0 8.76 0.0 0.0
328126 328126 2024 21354710 FDNY_10482_Fort Totten: Building 317 QUEENS 317 Murray Ave Other - Public Services 6,056 0.0 0.0 0.0 0.0     0.0 0.0 20.81 0.0 0.0
328127 328127 2024 21354711 FDNY_10483_Fort Totten: Building 401 QUEENS 401 Murray Ave Other - Public Services 12,401 0.0 0.0 0.0 0.0     0.0 0.0 42.61 0.0 0.0
328130 328130 2024 21354714 FDNY_10486_Fort Totten: Building 323 QUEENS 323 Story Ave Other - Public Services 31,902 0.0 0.0 0.0 0.0     0.0 0.0 109.61 0.0 0.0
328131 328131 2024 21354715 FDNY_10487_Fort Totten: Building 134 QUEENS 134 Sergeant Beers Ln Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 14.91 0.0 0.0
328132 328132 2024 21354716 FDNY_10488_Fort Totten: Building 326 QUEENS 326 Story Ave Other - Public Services 12,108 0.0 0.0 0.0 0.0     0.0 0.0 41.6 0.0 0.0
328133 328133 2024 21354717 FDNY_10489_Fort Totten: Building 410 QUEENS 410 Walter Reed Rd Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 3.0 0.0 0.0
328135 328135 2024 21354719 FDNY_10491_Fort Totten: Building 318 QUEENS 318 Murray Ave Other - Public Services 12,966 0.0 0.0 0.0 0.0     0.0 0.0 44.55 0.0 0.0
328136 328136 2024 21354720 FDNY_10492_Fort Totten: Building 332 QUEENS 332 Theater Rd Other - Public Services 6,288 0.0 0.0 0.0 0.0     0.0 0.0 21.6 0.0 0.0
328137 328137 2024 21354721 FDNY_10493_Fort Totten: Building 101 QUEENS Fort Totten Other - Public Services 112 0.0 0.0 0.0 0.0     0.0 0.0 0.38 0.0 0.0
328139 328139 2024 21354724 FDNY_10500_Fort Totten: Building 333 QUEENS 333 Pratt Ave Other - Public Services 17,602 0.0 0.0 0.0 0.0     0.0 0.0 60.48 0.0 0.0
328140 328140 2024 21354725 FDNY_10501_Fort Totten: Building 402 QUEENS 402 Murray Ave Other - Public Services 12,041 0.0 0.0 0.0 0.0     0.0 0.0 41.37 0.0 0.0
328141 328141 2024 21354726 FDNY_10502_Fort Totten: Building 403 QUEENS 403 Sylvester Ln Other - Public Services 1,748 0.0 0.0 0.0 0.0     0.0 0.0 6.01 0.0 0.0
328142 328142 2024 21354727 FDNY_10503_Fort Totten: Building 310 QUEENS 310 Sergeant Beers Ave Other - Public Services 4,208 0.0 0.0 0.0 0.0     0.0 0.0 14.46 0.0 0.0
328143 328143 2024 21354728 FDNY_10504_Fort Totten: Building 312 QUEENS 312 Sergeant Beers Ave Other - Public Services 4,282 0.0 0.0 0.0 0.0     0.0 0.0 14.71 0.0 0.0
328144 328144 2024 21354729 FDNY_10505_Fort Totten: Building 314 QUEENS 314 Sergeant Beers Ave Other - Public Services 3,274 0.0 0.0 0.0 0.0     0.0 0.0 11.25 0.0 0.0
328146 328146 2024 21354731 FDNY_10507_Fort Totten: Building 100 QUEENS 100 Totten Ave Other - Public Services 63 0.0 0.0 0.0 0.0     0.0 0.0 0.22 0.0 0.0
328147 328147 2024 21354732 FDNY_10508_Fort Totten: Building 106 QUEENS Fort Totten Other - Public Services 48 0.0 0.0 0.0 0.0     0.0 0.0 0.16 0.0 0.0
328148 328148 2024 21354733 FDNY_10509_Fort Totten: Building 414 QUEENS 414 Walter Reed Rd Other - Public Services 864 0.0 0.0 0.0 0.0     0.0 0.0 2.97 0.0 0.0
328149 328149 2024 21354734 FDNY_10510_Fort Totten: Building 108 QUEENS Fort Totten Other - Public Services 319 0.0 0.0 0.0 0.0     0.0 0.0 1.1 0.0 0.0
328150 328150 2024 21354735 FDNY_10512_Fort Totten: Building 417 QUEENS 417 Walter Reed Rd Other - Public Services 660 0.0 0.0 0.0 0.0     0.0 0.0 2.27 0.0 0.0
328151 328151 2024 21354736 FDNY_10513_Fort Totten: Building 105 QUEENS Fort Totten Other - Public Services 600 0.0 0.0 0.0 0.0     0.0 0.0 2.06 0.0 0.0
328152 328152 2024 21354737 FDNY_10514_Fort Totten: Building 419 QUEENS 419 Walter Reed Rd Other - Public Services 660 0.0 0.0 0.0 0.0     0.0 0.0 2.27 0.0 0.0
328153 328153 2024 21354738 FDNY_10515_Fort Totten: Building 420 QUEENS 420 Weaver Ave Other - Public Services 10,935 22.08 21.74 22.08 0.0     0.0 0.0 71.72 0.0 27.2
328154 328154 2024 21354739 FDNY_10520_Fort Totten: Building 104 QUEENS Fort Totten Other - Public Services 105 0.0 0.0 0.0 0.0     0.0 0.0 0.36 0.0 0.0
328155 328155 2024 21354740 FDNY_10521_Fort Totten: Building 313 QUEENS 313 Theater Rd Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.25 0.0 0.0
328157 328157 2024 21354742 FDNY_10524_Fort Totten: Building 321 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.25 0.0 0.0
328158 328158 2024 21354743 FDNY_10525_Fort Totten: Building 324 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.25 0.0 0.0
328159 328159 2024 21354744 FDNY_10526_Fort Totten: Building 328 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.25 0.0 0.0
328160 328160 2024 21354745 FDNY_10527_Fort Totten: Building 337 QUEENS Fort Totten Other - Public Services 150 0.0 0.0 0.0 0.0     0.0 0.0 0.52 0.0 0.0
328162 328162 2024 21354748 FDNY_10531_Fort Totten: Building 404 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.25 0.0 0.0
328164 328164 2024 21354756 FDNY_10555_Fort Totten: Building 416 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.25 0.0 0.0
328165 328165 2024 21354757 FDNY_11882_EMS 53 (Fort Totten Bldg 103) QUEENS 103 Totten Ave Other - Public Services 4,591 98.92 231.96 98.92 0.0     0.0 0.0 30.11 0.0 290.4
328166 328166 2024 21354758 FDNY_14635_Fort Totten Operation Bldg #135B QUEENS 135 General Berry Rd Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 14.91 0.0 0.0
340260 340260 2024 58934892 FDNY_4244_34-02 Queens Blvd QUEENS 34-02 Queens Blvd Other - Public Services 81,822 825.16 108.5 0.0 825.16     0.0 0.0 300.23 0.0 87.6
340869 340869 2024 59208293 ICL Real Property Holdings : 21-10 BORDEN AVENUE QUEENS 21-10 BORDEN AVENUE Other - Public Services 55,000 166.49 32.61 88.49 78.0     0.0 0.0 224.15 0.0 42.6
340921 340921 2024 59263393 ADDABBO LLC:62-00 BEACH CHANNEL DRIVE QUEENS 62-00 BEACH CHANNEL DRIVE Other - Public Services 40,848 243.38 64.15 0.0 243.38     0.0 0.0 149.89 0.0 51.8
340932 340932 2024 59281793 150-50 14 Road QUEENS 150-50 14th Rd Other - Public Services 31,575 124.99 42.63 47.12 77.86     0.0 0.0 124.67 0.0 49.5
294594 294594 2023 21354645 Benchmarking Group - 50 QUEENS Fort Totten Other - Public Services 643,459 2413.6 40.9 1129.5 1284.1     0.0 0.0 2862.1 0.0 42.0
294622 294622 2023 21354673 FDNY_10423_Fort Totten: Building 103 (EMS Marine 4/Training) QUEENS 103 Totten Ave Other - Public Services 4,591 0.0 0.0 0.0 0.0     0.0 0.0 14.5 0.0 0.0
294623 294623 2023 21354674 FDNY_10424_Fort Totten: Building 107 QUEENS 107 Duane Rd Other - Public Services 12,404 0.0 0.0 0.0 0.0     0.0 0.0 39.2 0.0 0.0
294624 294624 2023 21354675 FDNY_10425_Fort Totten: Building 316 QUEENS 316 Sergeant Beers Ave Other - Public Services 4,287 0.0 0.0 0.0 0.0     0.0 0.0 13.5 0.0 0.0
294625 294625 2023 21354676 FDNY_10426_Fort Totten: Building 325 QUEENS 325 Pratt Ave Other - Public Services 31,892 0.0 0.0 0.0 0.0     0.0 0.0 100.7 0.0 0.0
294626 294626 2023 21354677 FDNY_10427_Fort Totten: Building 336 QUEENS 336 Shore Rd Other - Public Services 23,732 0.0 0.0 0.0 0.0     0.0 0.0 74.9 0.0 0.0
294627 294627 2023 21354678 FDNY_10428_Fort Totten: Building 418 QUEENS 418 Weaver Ave Other - Public Services 10,935 0.0 0.0 0.0 0.0     0.0 0.0 34.5 0.0 0.0
294628 294628 2023 21354679 FDNY_10446_Fort Totten: Building 411 QUEENS 411 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 43.3 0.0 0.0
294631 294631 2023 21354682 FDNY_10450_Fort Totten: Building 413 QUEENS 413 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 43.3 0.0 0.0
294632 294632 2023 21354683 FDNY_10451_Fort Totten: Building 327 QUEENS Fort Totten Other - Public Services 101 0.0 0.0 0.0 0.0     0.0 0.0 0.3 0.0 0.0
294633 294633 2023 21354684 FDNY_10452_Fort Totten: Building 409 QUEENS 409 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 43.3 0.0 0.0
294634 294634 2023 21354689 FDNY_10457_Fort Totten: Building 129 QUEENS 129 Sergeant Beers Ln Other - Public Services 4,566 0.0 0.0 0.0 0.0     0.0 0.0 14.4 0.0 0.0
294635 294635 2023 21354690 FDNY_10458_Fort Totten: Building 135 QUEENS 135 General Berry Dr Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 13.7 0.0 0.0
294636 294636 2023 21354691 FDNY_10459_Fort Totten: Building 136 QUEENS 136 General Berry Dr Other - Public Services 4,287 0.0 0.0 0.0 0.0     0.0 0.0 13.5 0.0 0.0
294637 294637 2023 21354693 FDNY_10461_Fort Totten: Building 138 QUEENS 138 General Berry Dr Other - Public Services 4,048 0.0 0.0 0.0 0.0     0.0 0.0 12.8 0.0 0.0
294638 294638 2023 21354700 FDNY_10471_Fort Totten: Building 304 QUEENS 304 Shore Rd Other - Public Services 28,831 0.0 0.0 0.0 0.0     0.0 0.0 91.0 0.0 0.0
294639 294639 2023 21354701 FDNY_10472_Fort Totten: Building 305 QUEENS 305 Shore Rd Other - Public Services 1,555 0.0 0.0 0.0 0.0     0.0 0.0 4.9 0.0 0.0
294640 294640 2023 21354702 FDNY_10473_Fort Totten: Building 306 QUEENS 306 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 13.2 0.0 0.0
294641 294641 2023 21354703 FDNY_10474_Fort Totten: Building 307 QUEENS 307 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 13.2 0.0 0.0
294642 294642 2023 21354704 FDNY_10475_Fort Totten: Building 308 QUEENS 308 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 13.2 0.0 0.0
294644 294644 2023 21354706 FDNY_10477_Fort Totten: Building 311 QUEENS 311 Theater Rd Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 2.8 0.0 0.0
294645 294645 2023 21354707 FDNY_10479_Fort Totten: Building 400 QUEENS 400 Murray Ave Other - Public Services 10,935 0.0 0.0 0.0 0.0     0.0 0.0 34.5 0.0 0.0
294646 294646 2023 21354708 FDNY_10480_Fort Totten: Building 315 QUEENS Fort Totten Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 2.8 0.0 0.0
294647 294647 2023 21354709 FDNY_10481_Fort Totten: Building 331 QUEENS 331 Pratt ave Other - Public Services 2,550 0.0 0.0 0.0 0.0     0.0 0.0 8.1 0.0 0.0
294648 294648 2023 21354710 FDNY_10482_Fort Totten: Building 317 QUEENS 317 Murray Ave Other - Public Services 6,056 0.0 0.0 0.0 0.0     0.0 0.0 19.1 0.0 0.0
294649 294649 2023 21354711 FDNY_10483_Fort Totten: Building 401 QUEENS 401 Murray Ave Other - Public Services 12,401 0.0 0.0 0.0 0.0     0.0 0.0 39.2 0.0 0.0
294652 294652 2023 21354714 FDNY_10486_Fort Totten: Building 323 QUEENS 323 Story Ave Other - Public Services 31,902 0.0 0.0 0.0 0.0     0.0 0.0 100.7 0.0 0.0
294653 294653 2023 21354715 FDNY_10487_Fort Totten: Building 134 QUEENS 134 Sergeant Beers Ln Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 13.7 0.0 0.0
294654 294654 2023 21354716 FDNY_10488_Fort Totten: Building 326 QUEENS 326 Story Ave Other - Public Services 12,108 0.0 0.0 0.0 0.0     0.0 0.0 38.2 0.0 0.0
294655 294655 2023 21354717 FDNY_10489_Fort Totten: Building 410 QUEENS 410 Walter Reed Rd Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 2.8 0.0 0.0
294657 294657 2023 21354719 FDNY_10491_Fort Totten: Building 318 QUEENS 318 Murray Ave Other - Public Services 12,966 0.0 0.0 0.0 0.0     0.0 0.0 40.9 0.0 0.0
294658 294658 2023 21354720 FDNY_10492_Fort Totten: Building 332 QUEENS 332 Theater Rd Other - Public Services 6,288 0.0 0.0 0.0 0.0     0.0 0.0 19.9 0.0 0.0
294659 294659 2023 21354721 FDNY_10493_Fort Totten: Building 101 QUEENS Fort Totten Other - Public Services 112 0.0 0.0 0.0 0.0     0.0 0.0 0.4 0.0 0.0
294661 294661 2023 21354724 FDNY_10500_Fort Totten: Building 333 QUEENS 333 Pratt Ave Other - Public Services 17,602 0.0 0.0 0.0 0.0     0.0 0.0 55.6 0.0 0.0
294662 294662 2023 21354725 FDNY_10501_Fort Totten: Building 402 QUEENS 402 Murray Ave Other - Public Services 12,041 0.0 0.0 0.0 0.0     0.0 0.0 38.0 0.0 0.0
294663 294663 2023 21354726 FDNY_10502_Fort Totten: Building 403 QUEENS 403 Sylvester Ln Other - Public Services 1,748 0.0 0.0 0.0 0.0     0.0 0.0 5.5 0.0 0.0
294664 294664 2023 21354727 FDNY_10503_Fort Totten: Building 310 QUEENS 310 Sergeant Beers Ave Other - Public Services 4,208 0.0 0.0 0.0 0.0     0.0 0.0 13.3 0.0 0.0
294665 294665 2023 21354728 FDNY_10504_Fort Totten: Building 312 QUEENS 312 Sergeant Beers Ave Other - Public Services 4,282 0.0 0.0 0.0 0.0     0.0 0.0 13.5 0.0 0.0
294666 294666 2023 21354729 FDNY_10505_Fort Totten: Building 314 QUEENS 314 Sergeant Beers Ave Other - Public Services 3,274 0.0 0.0 0.0 0.0     0.0 0.0 10.3 0.0 0.0

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