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

492 rows where Borough = "QUEENS" and Property Type = "College/University" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Grid Emissions Rate (kgCO2e/MBtu)

Calendar Year 12

Property Type 1

  • College/University · 492 ✖

Borough 1

  • QUEENS · 492 ✖
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)
314421 314421 2024 5236727 86-01 23rd Avenue QUEENS 86-01 23rd Avenue College/University 120,049 967.61 86.76 194.04 773.57     0.0 0.0 926.02 0.0 86.4
321411 321411 2024 7067288 43-05 20th Avenue QUEENS 43-05 20th Avenue College/University 33,200 233.42 75.67 81.84 151.57     0.0 0.0 263.81 0.0 86.1
324825 324825 2024 15530348 St. John's University, Queens Campus QUEENS 8000 Utopia Parkway College/University 2,697,673 11145.72 44.45 572.06 10573.66     0.0 0.0 10057.02 0.0 37.5
324826 324826 2024 15530351 St John Hall QUEENS 8000 Utopia Parkway College/University 155,915 25.36 1.72 25.36 0.0     0.0 0.0 2068.89 0.0 2.2
324827 324827 2024 15530353 St Albert Hall QUEENS 8000 Utopia Parkway College/University 173,891 190.5 11.84 190.5 0.0     0.0 0.0 2307.41 0.0 14.8
324828 324828 2024 15530355 St Vincent QUEENS 8000 Utopia Parkway College/University 51,250 0.0 0.0 0.0 0.0     0.0 0.0 327.66 0.0 0.0
324831 324831 2024 15530358 Marillac Hall QUEENS 8000 Utopia Parkway College/University 157,355 0.0 0.0 0.0 0.0     0.0 0.0 1006.04 0.0 0.0
324832 324832 2024 15530360 St Augustine QUEENS 8000 Utopia Parkway College/University 166,605 0.0 0.0 0.0 0.0     0.0 0.0 1065.18 0.0 0.0
324833 324833 2024 15530361 Law School QUEENS 8000 Utopia Parkway College/University 227,110 0.0 0.0 0.0 0.0     0.0 0.0 1452.02 0.0 0.0
324836 324836 2024 15530365 Bent Hall QUEENS 8000 Utopia Parkway College/University 84,605 0.0 0.0 0.0 0.0     0.0 0.0 540.92 0.0 0.0
324837 324837 2024 15530366 Sullivan Hall QUEENS 8000 Utopia Parkway College/University 64,430 0.0 0.0 0.0 0.0     0.0 0.0 411.93 0.0 0.0
324850 324850 2024 15530482 D'Angelo Center QUEENS 8000 Utopia Parkway College/University 112,815 0.0 0.0 0.0 0.0     0.0 0.0 721.28 0.0 0.0
324978 324978 2024 15583490 St. John's University, Off Campus 1 QUEENS 175-05 Horace Harding Expressway College/University 42,000 265.09 67.92 62.96 202.13     0.0 0.0 326.32 0.0 70.0
324979 324979 2024 15583491 St. John's University, Off Campus 2 QUEENS 152-11 Union Turnpike College/University 39,894 209.31 56.51 59.49 149.82     0.0 0.0 312.83 0.0 60.7
328183 328183 2024 21354818 Benchmarking Group - 54 QUEENS 222-05 56th Ave College/University 953,489 9617.93 108.61 3835.12 5782.81     0.0 0.0 7650.23 0.0 128.4
328185 328185 2024 21354820 CUNY CC > QCC_540_Queensborough: Administration / Business Building QUEENS 222-11 56th Ave College/University 74,987 91.8 13.13 30.5 61.3     0.0 0.0 593.65 0.0 14.8
328186 328186 2024 21354821 CUNY CC > QCC_541_Queensborough CC: Annex A - TR1 QUEENS 220-09 56th Ave College/University 1,307 0.0 0.0 0.0 0.0     0.0 0.0 8.36 0.0 0.0
328187 328187 2024 21354822 CUNY CC > QCC_542_Queensborough CC: Annex B - TR2 QUEENS 220-09 56th Ave College/University 1,307 0.0 0.0 0.0 0.0     0.0 0.0 8.36 0.0 0.0
328188 328188 2024 21354823 CUNY CC > QCC_543_Queensborough CC: Boiler Room QUEENS 221-05 56th Ave College/University 5,215 0.0 0.0 0.0 0.0     0.0 0.0 33.34 0.0 0.0
328189 328189 2024 21354824 CUNY CC > QCC_544_Queensborough CC: C Building QUEENS 222-03 56th Ave College/University 20,644 0.0 0.0 0.0 0.0     0.0 0.0 131.99 0.0 0.0
328190 328190 2024 21354825 CUNY CC > QCC_545_Queensborough CC: Cafeteria / Student Union Building QUEENS 221-35 56th Ave College/University 42,185 0.0 0.0 0.0 0.0     0.0 0.0 269.71 0.0 0.0
328191 328191 2024 21354826 CUNY CC > QCC_546_Queensborough CC: Humanities Building QUEENS 222-25 56th Ave College/University 164,624 0.0 0.0 0.0 0.0     0.0 0.0 1052.52 0.0 0.0
328194 328194 2024 21354829 CUNY CC > QCC_549_Queensborough CC: Medical Arts Building QUEENS 222-01 56th Ave College/University 137,899 0.0 0.0 0.0 0.0     0.0 0.0 881.65 0.0 0.0
328195 328195 2024 21354830 CUNY CC > QCC_550_Queensborough CC: Oakland Building QUEENS 221-15 56th Ave College/University 24,920 0.0 0.0 0.0 0.0     0.0 0.0 159.33 0.0 0.0
328196 328196 2024 21354831 CUNY CC > QCC_551_Queensborough CC: Science Building QUEENS 222-15 56th Ave College/University 186,006 9241.39 534.75 3636.0 5605.39     0.0 0.0 1490.8 0.0 629.9
328197 328197 2024 21354832 CUNY CC > QCC_553_Queensborough CC: Technology Building QUEENS 221-25 56th Ave College/University 30,549 0.0 0.0 0.0 0.0     0.0 0.0 195.31 0.0 0.0
328198 328198 2024 21354833 CUNY CC > QCC_554_Queensborough CC: Temporary #5 - Garage QUEENS 221-01 56th Ave College/University 2,313 0.0 0.0 0.0 0.0     0.0 0.0 14.79 0.0 0.0
328199 328199 2024 21354834 CUNY CC > QCC_555_Queensborough CC: W Building QUEENS 226-11 56th Ave College/University 10,243 0.0 0.0 0.0 0.0     0.0 0.0 65.49 0.0 0.0
328200 328200 2024 21354835 CUNY CC > QCC_556_Queensborough CC: Y2 Building QUEENS 222-09 56th Ave College/University 12,850 247.67 207.42 131.55 116.12     0.0 0.0 105.94 0.0 271.3
328201 328201 2024 21354836 CUNY CC > QCC_557_Queensborough CC: Z Building QUEENS 220-09 56th Ave College/University 8,660 0.0 0.0 0.0 0.0     0.0 0.0 55.37 0.0 0.0
329056 329056 2024 21455184 CUNY CC > QCC_552_Queensborough CC: Service Building QUEENS 222-03 56th Ave College/University 26,441 0.0 0.0 0.0 0.0     0.0 0.0 169.05 0.0 0.0
332588 332588 2024 33910523 Benchmarking Group - 222 QUEENS 31-10 Thomson Ave College/University 1,340,752 7254.42 58.23 1979.78 5274.64     0.0 0.0 10489.95 0.0 62.0
332589 332589 2024 33910524 CUNY CC > LGCC_478_LaGuardia CC: C - Center 3 Building QUEENS 29-10 Thomson Ave College/University 858,680 3395.6 42.52 756.27 2639.33     0.0 0.0 6652.29 0.0 43.3
332590 332590 2024 33910525 CUNY CC > LGCC_477_LaGuardia CC: B - B Building QUEENS 30-20 Thomson Ave College/University 199,787 1027.0 55.33 64.94 962.07     0.0 0.0 1500.94 0.0 48.0
332591 332591 2024 33910526 CUNY CC > LGCC_480_LaGuardia CC: M - Joseph Shenker Hall QUEENS 31-10 Thomson Ave College/University 282,285 2831.82 107.96 1158.57 1673.25     0.0 0.0 2269.66 0.0 128.8
337170 337170 2024 53934792 Green Light Energy Conservation:71-02 113 STREET QUEENS 71-02 113 STREET College/University 64,668 115.48 19.27 8.62 106.87     0.0 0.0 486.88 0.0 16.9
338715 338715 2024 55989492 64-19 Kissena Blvd QUEENS 64-19 Kissena Blvd College/University 33,558 165.02 52.96 47.64 117.37     0.0 0.0 263.38 0.0 57.1
339588 339588 2024 57808994 CUNY > LGCC_479_LaGuardia CC: E - E Building QUEENS 31-40 Thomson Ave College/University 380,286 2421.02 68.57 0.0 2421.02     0.0 0.0 2823.12 0.0 55.3
342465 342465 2024 60408494 Green Light Energy Conservation:75-31 150 STREET QUEENS 75-31 150 STREET College/University 165,240 667.99 43.49 169.79 498.2     0.0 0.0 1288.06 0.0 45.5
273325 273325 2023 6696051 Rabbinical Seminary of America QUEENS 7601 147th Street College/University 83,794 496.9 63.51 165.0 331.9     0.0 0.0 636.8 0.0 73.5
275464 275464 2023 7067288 43-05 20th Avenue QUEENS 43-05 20th Avenue College/University 33,200 183.0 59.2 48.8 134.2     0.0 0.0 248.2 0.0 64.8
278622 278622 2023 12905026 MFRC: 64-19 Kissena Blvd. QUEENS 64-19 Kissena Boulevard College/University 35,096 158.3 48.44 49.3 109.0     0.0 0.0 265.3 0.0 55.0
279580 279580 2023 15530348 St. John's University, Queens Campus QUEENS 8000 Utopia Parkway College/University 2,697,673 9805.9 38.75 471.7 9334.2     0.0 0.0 9492.7 0.0 34.8
279581 279581 2023 15530351 St John Hall QUEENS 8000 Utopia Parkway College/University 155,915 12.0 1.08 12.0 0.0     0.0 0.0 2069.1 0.0 1.0
279582 279582 2023 15530353 St Albert Hall QUEENS 8000 Utopia Parkway College/University 173,891 109.1 6.46 109.1 0.0     0.0 0.0 2307.6 0.0 8.5
279583 279583 2023 15530355 St Vincent QUEENS 8000 Utopia Parkway College/University 51,250 0.0 0.0 0.0 0.0     0.0 0.0 316.7 0.0 0.0
279586 279586 2023 15530358 Marillac Hall QUEENS 8000 Utopia Parkway College/University 157,355 0.0 0.0 0.0 0.0     0.0 0.0 972.5 0.0 0.0
279587 279587 2023 15530360 St Augustine QUEENS 8000 Utopia Parkway College/University 166,605 0.0 0.0 0.0 0.0     0.0 0.0 1029.7 0.0 0.0
279588 279588 2023 15530361 Law School QUEENS 8000 Utopia Parkway College/University 227,110 0.0 0.0 0.0 0.0     0.0 0.0 1403.6 0.0 0.0
279591 279591 2023 15530365 Bent Hall QUEENS 8000 Utopia Parkway College/University 84,605 0.0 0.0 0.0 0.0     0.0 0.0 522.9 0.0 0.0
279592 279592 2023 15530366 Sullivan Hall QUEENS 8000 Utopia Parkway College/University 64,430 0.0 0.0 0.0 0.0     0.0 0.0 398.2 0.0 0.0
279605 279605 2023 15530482 D'Angelo Center QUEENS 8000 Utopia Parkway College/University 112,815 0.0 0.0 0.0 0.0     0.0 0.0 697.2 0.0 0.0
289659 289659 2023 33910523 Benchmarking Group - 222 QUEENS 31-10 Thomson Ave College/University 1,340,752 8605.1 68.89 1575.0 7030.2     0.0 0.0 9820.7 0.0 70.3
289660 289660 2023 33910524 CUNY CC > LGCC_478_LaGuardia CC: C - Center 3 Building QUEENS 29-10 Thomson Ave College/University 858,680 3067.1 38.75 579.4 2487.7     0.0 0.0 6298.6 0.0 39.4
289661 289661 2023 33910525 CUNY CC > LGCC_477_LaGuardia CC: B - B Building QUEENS 30-20 Thomson Ave College/University 199,787 1001.5 53.82 76.3 925.2     0.0 0.0 1426.4 0.0 49.8
289662 289662 2023 33910526 CUNY CC > LGCC_480_LaGuardia CC: M - Joseph Shenker Hall QUEENS 31-10 Thomson Ave College/University 282,285 4536.5 173.3 919.2 3617.2     0.0 0.0 2077.6 0.0 179.2
289667 289667 2023 33910531 CUNY SC > YC_564_York College: Science Building QUEENS 94-50 159th St College/University 61,773 429.0 74.27 70.3 358.7     0.0 0.0 450.4 0.0 74.8
289668 289668 2023 33910532 CUNY SC > YC_558_York College: Academic Core QUEENS 94-20 Guy R Brewer Blvd College/University 657,782 5222.9 85.03 1501.7 3721.2     0.0 0.0 4943.5 0.0 95.0
289669 289669 2023 33910533 CUNY SC > YC_561_York College: Health and Physical Education Complex QUEENS 160-30 Liberty Avenue College/University 80,767 313.6 41.98 53.7 260.0     0.0 0.0 589.9 0.0 42.1
289670 289670 2023 33910534 CUNY SC > YC_562_York College: Milton G. Bassin Performing Arts Center QUEENS 94-45 Guy R. Brewer Blvd College/University 76,713 171.0 23.68 0.0 171.0     0.0 0.0 538.0 0.0 20.5
290971 290971 2023 15583490 St. John's University, Off Campus 1 QUEENS 175-05 Horace Harding Expressway College/University 42,000 214.7 54.9 23.5 191.2     0.0 0.0 302.2 0.0 52.4
290972 290972 2023 15583491 St. John's University, Off Campus 2 QUEENS 152-11 Union Turnpike College/University 39,894 216.7 58.13 57.8 158.9     0.0 0.0 298.3 0.0 63.9
294694 294694 2023 21354764 CUNY SC > QC_476_Queens College: Queens Hall QUEENS 65-21 Main St College/University 179,841 559.4 33.37 177.7 381.7     0.0 0.0 1361.8 0.0 38.1
294695 294695 2023 21354765 CUNY SC > QC_481_Queens College: Alumni Entrepreneurship Center QUEENS 65-56 Kissena Blvd College/University 2,450 0.0 0.0 0.0 0.0     0.0 0.0 15.1 0.0 0.0
294698 294698 2023 21354768 CUNY SC > QC_484_Queens College: Campbeel Dome QUEENS 65-70 Kissena Blvd College/University 8,076 0.0 0.0 0.0 0.0     0.0 0.0 49.9 0.0 0.0
294699 294699 2023 21354769 CUNY SC > QC_485_Queens College: CEP - 1 (Professional Studies) QUEENS 15245 Melbourne Ave College/University 7,945 0.0 0.0 0.0 0.0     0.0 0.0 49.1 0.0 0.0
294700 294700 2023 21354770 CUNY SC > QC_486_Queens College: CEP - 2 (Tech Incubator) QUEENS 15245 Melbourne Ave College/University 7,872 0.0 0.0 0.0 0.0     0.0 0.0 48.7 0.0 0.0
294701 294701 2023 21354771 CUNY SC > QC_487_Queens College: Colden Auditorium QUEENS 64-18 Kissena Blvd College/University 43,128 0.0 0.0 0.0 0.0     0.0 0.0 266.6 0.0 0.0
294706 294706 2023 21354776 CUNY SC > QC_494_Queens College: G Building QUEENS 64-26 Kissena Blvd College/University 12,909 0.0 0.0 0.0 0.0     0.0 0.0 79.8 0.0 0.0
294707 294707 2023 21354777 CUNY SC > QC_495_Queens College: Gertz Speech Clinic QUEENS 64-22 Kissena Blvd College/University 7,706 9.5 12.92 0.0 9.5     0.0 0.0 54.0 0.0 11.4
294708 294708 2023 21354778 CUNY SC > QC_496_Queens College: Goldstein Theatre QUEENS 64-10 Kissena Blvd College/University 49,040 0.0 0.0 0.0 0.0     0.0 0.0 303.1 0.0 0.0
294709 294709 2023 21354779 CUNY SC > QC_497_Queens College: Gregory Razran Hall QUEENS 66-40 Kissena Blvd College/University 55,345 0.0 0.0 0.0 0.0     0.0 0.0 342.1 0.0 0.0
294710 294710 2023 21354780 CUNY SC > QC_498_Queens College: Main Gate - Security QUEENS 65-10 Kissena Blvd College/University 1,225 0.0 0.0 0.0 0.0     0.0 0.0 7.6 0.0 0.0
294711 294711 2023 21354781 CUNY SC > QC_499_Queens College: Heating Plant QUEENS 64-56 Kissena Blvd College/University 15,755 0.0 0.0 0.0 0.0     0.0 0.0 97.4 0.0 0.0
294712 294712 2023 21354782 CUNY SC > QC_500_Queens College: Honors Center QUEENS 15245 Melbourne Ave College/University 12,891 0.0 0.0 0.0 0.0     0.0 0.0 79.7 0.0 0.0
294713 294713 2023 21354783 CUNY SC > QC_502_Queens College: Hortense Powdermaker Hall QUEENS 65-70 Kissena Blvd College/University 216,650 0.0 0.0 0.0 0.0     0.0 0.0 1339.0 0.0 0.0
294714 294714 2023 21354784 CUNY SC > QC_503_Queens College: I Building QUEENS 64-60 Kissena Blvd College/University 39,506 0.0 0.0 0.0 0.0     0.0 0.0 244.2 0.0 0.0
294715 294715 2023 21354785 CUNY SC > QC_504_Queens College: L-1 B and G Admin QUEENS 64-66 Kissena Blvd College/University 2,022 0.0 0.0 0.0 0.0     0.0 0.0 12.5 0.0 0.0
294717 294717 2023 21354787 CUNY SC > QC_506_Queens College: L-3 B and G Laborers and Station Engineers QUEENS 64-64D Kissena Blvd College/University 2,100 0.0 0.0 0.0 0.0     0.0 0.0 13.0 0.0 0.0
294718 294718 2023 21354788 CUNY SC > QC_507_Queens College: L-4 B and G Shop and Storage QUEENS 64-64B Kissena Blvd College/University 6,135 0.0 0.0 0.0 0.0     0.0 0.0 37.9 0.0 0.0
294719 294719 2023 21354789 CUNY SC > QC_508_Queens College: L-5 B and G Equipment QUEENS 64-64A Kissena Blvd College/University 8,275 0.0 0.0 0.0 0.0     0.0 0.0 51.1 0.0 0.0
294720 294720 2023 21354790 CUNY SC > QC_509_Queens College: Laura Arthur Colwin Hall QUEENS 66-30 Kissena Blvd College/University 29,539 0.0 0.0 0.0 0.0     0.0 0.0 182.6 0.0 0.0
294721 294721 2023 21354791 CUNY SC > QC_510_Queens College: Lloyd T. Delany Hall QUEENS 66-20 Kissena Blvd College/University 30,409 0.0 0.0 0.0 0.0     0.0 0.0 187.9 0.0 0.0
294722 294722 2023 21354792 CUNY SC > QC_512_Queens College: Margaret Kiely Hall QUEENS 65-30 Kissena Blvd College/University 216,099 18636.7 927.85 8272.2 10364.6     0.0 0.0 1689.9 0.0 1161.8
294723 294723 2023 21354793 CUNY SC > QC_513_Queens College: Paul Klapper Hall QUEENS 65-50 Kissena Blvd College/University 152,285 0.0 0.0 0.0 0.0     0.0 0.0 941.2 0.0 0.0
294724 294724 2023 21354794 CUNY SC > QC_515_Queens College: Rathaus Hall QUEENS 64-30 Kissena Blvd College/University 42,301 0.0 0.0 0.0 0.0     0.0 0.0 261.4 0.0 0.0
294725 294725 2023 21354795 CUNY SC > QC_534_Queens College: Remsen Hall QUEENS 66-50 Kissena Blvd College/University 168,546 0.0 0.0 0.0 0.0     0.0 0.0 1041.7 0.0 0.0
294726 294726 2023 21354796 CUNY SC > QC_535_Queens College: School of Music QUEENS 64-42 Kissena Blvd College/University 118,228 0.0 0.0 0.0 0.0     0.0 0.0 730.7 0.0 0.0
294727 294727 2023 21354797 CUNY SC > QC_536_Queens College: Science Building QUEENS 66-60 Kissena Blvd College/University 263,196 211.3 8.61 184.5 26.8     0.0 0.0 2629.2 0.0 12.4
294728 294728 2023 21354798 CUNY SC > QC_537_Queens College: Student Union QUEENS 66-10 Kissena Blvd College/University 185,130 0.0 0.0 0.0 0.0     0.0 0.0 1144.2 0.0 0.0
294729 294729 2023 21354799 CUNY SC > QC_539_Queens College: Virginia Frese Hall QUEENS 65-44 Kissena Blvd College/University 20,155 0.0 0.0 0.0 0.0     0.0 0.0 124.6 0.0 0.0
294731 294731 2023 21354801 CUNY SC > QC_70_Queens College: Jefferson Hall QUEENS 65-90 Kissena Blvd College/University 49,301 0.0 0.0 0.0 0.0     0.0 0.0 304.7 0.0 0.0
294732 294732 2023 21354802 CUNY SC > QC_71_Queens College: King Hall QUEENS 64-14 Kissena Blvd College/University 34,829 0.0 0.0 0.0 0.0     0.0 0.0 215.3 0.0 0.0
294733 294733 2023 21354803 CUNY SC > QC_72_Queens College: Kissena Hall QUEENS 64-19 Kissena Blvd College/University 32,941 153.9 50.59 48.5 105.5     0.0 0.0 249.3 0.0 57.2
294747 294747 2023 21354818 Benchmarking Group - 54 QUEENS 222-05 56th Ave College/University 953,489 8801.3 99.03 3432.3 5369.0     0.0 0.0 7354.5 0.0 119.5
294749 294749 2023 21354820 CUNY CC > QCC_540_Queensborough: Administration / Business Building QUEENS 222-11 56th Ave College/University 75,200 53.0 7.53 0.0 53.0     0.0 0.0 527.4 0.0 6.5
294750 294750 2023 21354821 CUNY CC > QCC_541_Queensborough CC: Annex A - TR1 QUEENS 220-09 56th Ave College/University 1,307 0.0 0.0 0.0 0.0     0.0 0.0 8.1 0.0 0.0
294751 294751 2023 21354822 CUNY CC > QCC_542_Queensborough CC: Annex B - TR2 QUEENS 220-09 56th Ave College/University 1,307 0.0 0.0 0.0 0.0     0.0 0.0 8.1 0.0 0.0
294752 294752 2023 21354823 CUNY CC > QCC_543_Queensborough CC: Boiler Room QUEENS 221-05 56th Ave College/University 5,215 0.0 0.0 0.0 0.0     0.0 0.0 32.2 0.0 0.0
294753 294753 2023 21354824 CUNY CC > QCC_544_Queensborough CC: C Building QUEENS 222-03 56th Ave College/University 20,644 0.0 0.0 0.0 0.0     0.0 0.0 127.6 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");