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

285 rows where Property Type = "Courthouse" 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 12

Borough 5

Property Type 1

  • Courthouse · 285 ✖
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)
322398 322398 2024 9776905 Brooklyn Family Court (330 Jay) BROOKLYN 330 Jay Street Courthouse 977,656 6406.4 70.5 1473.98 4932.42     0.0 0.0 7702.48 63.0 72.2
327676 327676 2024 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 2977.1 108.93 369.92 2607.18     0.0 0.0 2622.84 0.0 100.3
327678 327678 2024 21354176 DCAS_1048_Queens Family Court QUEENS 151-20 Jamaica Ave Courthouse 291,589 2586.41 95.48 369.92 2216.48     0.0 0.0 2506.29 47.0 89.6
327707 327707 2024 21354224 DCAS_5571_Richmond County Supreme Court STATEN IS 26 Central Ave Courthouse 182,000 940.33 55.65 322.19 618.14     0.0 0.0 1544.6 81.0 62.7
327730 327730 2024 21354247 Benchmarking Group - 2 MANHATTAN 100 Centre St Courthouse 1,545,842 6668.49 46.39 3194.9 3473.59     0.0 0.0 14760.02 0.0 58.4
327731 327731 2024 21354248 DCAS_1025_Manhattan Criminal Court MANHATTAN 100 Centre St Courthouse 795,700 6572.76 88.91 3194.9 3377.86     0.0 0.0 6979.71 54.0 112.5
327926 327926 2024 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 3822.0 64.8 1587.25 2234.75     0.0 0.0 6023.96 0.0 76.9
327928 327928 2024 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 3649.91 67.17 1587.25 2062.66     0.0 0.0 5009.35 72.0 80.9
327937 327937 2024 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 2451.42 62.0 1093.39 1358.02     0.0 0.0 4038.73 0.0 76.0
327938 327938 2024 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 2451.42 99.89 1093.39 1358.02     0.0 0.0 2446.07 49.0 122.6
328224 328224 2024 21354863 DCAS_1052_Staten Island Supreme Court STATEN IS 18 Richmond Ter Courthouse 63,200 197.01 33.58 0.0 197.01     0.0 0.0 476.82 94.0 27.1
328506 328506 2024 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 662.19 72.01 79.82 582.37     0.0 0.0 902.73 71.0 66.3
328508 328508 2024 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 308.67 67.17 118.48 190.19     0.0 0.0 515.38 82.0 65.6
328518 328518 2024 21355192 DCAS_1019_Harlem Courthouse MANHATTAN 170 East 121st St Courthouse 25,700 446.39 186.97 390.16 56.23     0.0 0.0 276.95 16.0 223.9
328521 328521 2024 21355195 DCAS_1023_Manhattan Appellate Court MANHATTAN 27 Madison Ave Courthouse 54,300 673.66 133.58 9.93 663.73     0.0 0.0 517.19 29.0 134.3
328522 328522 2024 21355196 DCAS_1027_Manhattan Supreme Court MANHATTAN 60 Centre St Courthouse 322,300 2340.92 78.15 0.0 2340.92     0.0 0.0 3062.31 69.0 86.1
328523 328523 2024 21355197 DCAS_1028_Midtown Community Court MANHATTAN 314 West 54th St Courthouse 43,233 355.81 88.59 83.64 272.17     0.0 0.0 342.59 47.0 91.1
328529 328529 2024 21355203 DCAS_1044_Long Island City Courthouse QUEENS 25-10 Court Sq Courthouse 59,300 353.41 64.15 186.66 166.75     0.0 0.0 473.96 70.0 83.7
328531 328531 2024 21355205 DCAS_1049_Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308,200 1454.53 50.81 657.7 796.83     0.0 0.0 2764.24 87.0 62.3
328533 328533 2024 21355207 DCAS_1053_Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 18,000 122.28 73.09 42.86 79.42     0.0 0.0 151.54 65.0 83.2
328534 328534 2024 21355208 DCAS_1055_Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 12,300 97.08 84.93 35.76 61.32     0.0 0.0 102.49 54.0 98.1
328614 328614 2024 21355292 DCAS_3864_Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 21,500 37.08 18.51 25.64 11.44     0.0 0.0 196.43 100.0 27.1
328889 328889 2024 21355591 DCAS_1024_Manhattan Civil Court MANHATTAN 111 Centre St Courthouse 467,000 2251.26 51.88 0.0 2251.26     0.0 0.0 4027.4 85.0 51.7
328890 328890 2024 21355592 DCAS_1026_Manhattan Family Court MANHATTAN 60 Lafayette St Courthouse 491,000 2208.12 48.44 0.0 2208.12     0.0 0.0 4322.04 88.0 47.0
328891 328891 2024 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 2470.78 48.33 1238.72 1232.06     0.0 0.0 5758.14 93.0 49.9
328892 328892 2024 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 2510.99 55.11 11.1 2499.9     0.0 0.0 4958.14 88.0 44.6
328893 328893 2024 21355595 DCAS_1047_Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 320,535 1187.38 39.83 268.03 919.35     0.0 0.0 2516.34 90.0 40.5
330639 330639 2024 26656539 DCAS_1046_Queens Criminal Court and Annex QUEENS 125-01 Queens Blvd Courthouse 648,000 2849.83 47.36 327.74 2522.09     0.0 0.0 4837.38 83.0 43.2
330662 330662 2024 26672463 Benchmarking Group - 215 QUEENS 125-01 Queens Blvd Courthouse 1,162,654 3353.68 31.0 339.37 3014.31     0.0 0.0 10404.6 0.0 28.0
335723 335723 2024 52441595 141 Livingston Owner LLC BROOKLYN 141 Livingston Street Courthouse 193,195 1159.79 64.58 267.01 892.77     0.0 0.0 1516.75 69.0 66.2
276547 276547 2023 9776905 Brooklyn Family Court (330 Jay) BROOKLYN 330 Jay Street Courthouse 977,656 6224.0 68.89 1357.1 4866.9     0.0 0.0 7285.0 61.0 71.9
293252 293252 2023 20986369 90-01 Beach Channel Drive QUEENS 90-01 Beach Channel Drive Courthouse 35,977 47.0 13.99 0.0 47.0     0.0 0.0 295.4 0.0 12.0
294129 294129 2023 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 2846.2 104.41 318.2 2528.1     0.0 0.0 2481.9 0.0 99.2
294131 294131 2023 21354176 DCAS_1048_Queens Family Court QUEENS 151-20 Jamaica Ave Courthouse 291,589 2475.0 91.49 318.2 2156.9     0.0 0.0 2365.8 46.0 88.4
294178 294178 2023 21354223 Benchmarking Group - 193 STATEN IS 26 Central Ave Courthouse 182,000 1444.3 85.03 329.6 1114.6     0.0 0.0 0.0 0.0 90.2
294179 294179 2023 21354224 DCAS_5571_Richmond County Supreme Court STATEN IS 26 Central Ave Courthouse 182,000 931.1 54.9 329.6 601.4     0.0 0.0 1472.4 79.0 64.3
294202 294202 2023 21354247 Benchmarking Group - 2 MANHATTAN 100 Centre St Courthouse 1,545,842 6920.0 48.44 3229.8 3690.2     0.0 0.0 14235.7 0.0 61.3
294203 294203 2023 21354248 DCAS_1025_Manhattan Criminal Court MANHATTAN 100 Centre St Courthouse 795,700 6305.2 85.03 3229.8 3075.5     0.0 0.0 6759.4 55.0 112.0
294419 294419 2023 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 3364.1 57.05 1308.2 2055.9     0.0 0.0 5731.4 0.0 68.6
294421 294421 2023 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 3208.0 59.2 1308.2 1899.9     0.0 0.0 4737.5 76.0 72.0
294430 294430 2023 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 2526.8 63.51 1310.8 1216.1     0.0 0.0 3975.7 0.0 84.2
294431 294431 2023 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 2526.8 103.33 1310.8 1216.1     0.0 0.0 2393.5 45.0 135.8
294791 294791 2023 21354863 DCAS_1052_Staten Island Supreme Court STATEN IS 18 Richmond Ter Courthouse 63,200 177.4 30.14 0.0 177.4     0.0 0.0 447.0 94.0 25.8
295101 295101 2023 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 556.8 60.28 68.1 488.7     0.0 0.0 853.1 78.0 58.4
295103 295103 2023 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 168.3 36.6 0.0 168.3     0.0 0.0 402.2 93.0 31.3
295113 295113 2023 21355192 DCAS_1019_Harlem Courthouse MANHATTAN 170 East 121st St Courthouse 25,700 51.1 21.53 1.1 50.0     0.0 0.0 161.1 97.0 18.7
295116 295116 2023 21355195 DCAS_1023_Manhattan Appellate Court MANHATTAN 27 Madison Ave Courthouse 54,300 575.5 114.1 10.4 565.1     0.0 0.0 497.5 38.0 119.9
295117 295117 2023 21355196 DCAS_1027_Manhattan Supreme Court MANHATTAN 60 Centre St Courthouse 322,300 2225.2 74.27 0.0 2225.2     0.0 0.0 3019.5 71.0 86.5
295118 295118 2023 21355197 DCAS_1028_Midtown Community Court MANHATTAN 314 West 54th St Courthouse 43,233 423.9 105.49 81.4 342.5     0.0 0.0 322.4 29.0 108.3
295124 295124 2023 21355203 DCAS_1044_Long Island City Courthouse QUEENS 25-10 Court Sq Courthouse 59,300 312.1 57.05 150.9 161.2     0.0 0.0 452.3 75.0 72.9
295126 295126 2023 21355205 DCAS_1049_Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308,200 1271.5 44.13 564.2 707.3     0.0 0.0 2664.4 90.0 55.1
295128 295128 2023 21355207 DCAS_1053_Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 18,000 104.3 62.43 34.6 69.7     0.0 0.0 143.9 72.0 71.8
295129 295129 2023 21355208 DCAS_1055_Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 12,300 83.2 73.19 25.7 57.4     0.0 0.0 96.4 61.0 82.3
295211 295211 2023 21355292 DCAS_3864_Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 21,500 39.0 19.38 30.8 8.2     0.0 0.0 196.3 100.0 30.5
295510 295510 2023 21355591 DCAS_1024_Manhattan Civil Court MANHATTAN 111 Centre St Courthouse 467,000 2148.0 49.51 0.0 2148.0     0.0 0.0 3906.4 85.0 52.4
295511 295511 2023 21355592 DCAS_1026_Manhattan Family Court MANHATTAN 60 Lafayette St Courthouse 491,000 2127.8 46.28 0.0 2127.8     0.0 0.0 4107.0 88.0 46.9
295512 295512 2023 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 1158.6 22.6 54.0 1104.6     0.0 0.0 4269.3 99.0 20.3
295513 295513 2023 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 2676.5 59.2 430.2 2246.4     0.0 0.0 4832.6 85.0 58.7
295514 295514 2023 21355595 DCAS_1047_Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 320,535 980.0 33.37 199.6 780.5     0.0 0.0 2383.1 94.0 34.0
297838 297838 2023 26656539 DCAS_1046_Queens Criminal Court and Annex QUEENS 125-01 Queens Blvd Courthouse 648,000 2837.1 47.36 235.9 2601.3     0.0 0.0 4529.5 80.0 43.6
297848 297848 2023 26672463 Benchmarking Group - 215 QUEENS 125-01 Queens Blvd Courthouse 1,162,654 3101.2 29.06 247.5 2853.7     0.0 0.0 9747.7 0.0 26.5
298077 298077 2023 29892141 141 Livingston Owner LLC BROOKLYN 141 Livingston Street Courthouse 193,195 1047.6 58.13 227.6 820.0     0.0 0.0 1311.7 66.0 61.2
255703 255703 2022 9776905 Brooklyn Family Court (330 Jay) BROOKLYN 330 Jay Street Courthouse 977,656 5690.3 62.43 1681.2 4009.1 5690.3   0.0 0.0 6208.3 56.0 80.9
266401 266401 2022 20986369 90-01 Beach Channel Drive QUEENS 90-01 Beach Channel Drive Courthouse 35,977 36.4 10.76 0.0 36.4 36.4   0.0 0.0 170.4 100.0 12.0
270022 270022 2022 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 2328.5 85.03 479.8 1848.6 2328.5   0.0 0.0 2059.5 0.0 103.9
270024 270024 2022 21354176 DCAS_1048_Queens Family Court QUEENS 151-20 Jamaica Ave Courthouse 291,589 2031.6 75.35 479.8 1551.8 2031.6   0.0 0.0 2013.3 49.0 92.8
270071 270071 2022 21354223 Benchmarking Group - 193 STATEN IS 26 Central Ave Courthouse 182,000 1287.1 76.42 457.6 829.5 1287.1   0.0 0.0 0.0 0.0 100.8
270072 270072 2022 21354224 DCAS_5571_Richmond County Supreme Court STATEN IS 26 Central Ave Courthouse 182,000 890.0 52.74 457.6 432.4 890.0   0.0 0.0 1357.3 78.0 75.0
270095 270095 2022 21354247 Benchmarking Group - 2 MANHATTAN 100 Centre St Courthouse 1,545,842 7554.4 52.74 3792.0 3762.3 7554.4   0.0 0.0 12372.2 0.0 75.0
270096 270096 2022 21354248 DCAS_1025_Manhattan Criminal Court MANHATTAN 100 Centre St Courthouse 795,700 6026.6 81.81 3791.6 2235.0 6026.6   0.0 0.0 6303.3 53.0 122.9
270314 270314 2022 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 3438.7 58.13 1876.7 1562.1 3438.7   0.0 0.0 5301.5 0.0 82.3
270316 270316 2022 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 3327.2 61.35 1876.7 1450.5 3327.2   0.0 0.0 4478.7 71.0 87.1
270325 270325 2022 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 3068.7 77.5 2092.4 976.3 3068.7   0.0 0.0 3749.3 0.0 119.6
270326 270326 2022 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 2976.4 121.63 2092.4 884.0 2976.4   0.0 0.0 2318.4 30.0 188.8
270686 270686 2022 21354863 DCAS_1052_Staten Island Supreme Court STATEN IS 18 Richmond Ter Courthouse 63,200 130.6 22.6 0.0 130.6 130.6   0.0 0.0 355.6 96.0 24.4
271001 271001 2022 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 447.6 48.44 95.6 352.0 447.6   0.0 0.0 715.5 80.0 60.2
271003 271003 2022 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 296.5 64.58 167.9 128.6 296.5   0.0 0.0 476.2 80.0 76.4
271013 271013 2022 21355192 DCAS_1019_Harlem Courthouse MANHATTAN 170 East 121st St Courthouse 25,700 258.6 108.72 221.1 37.4 258.6   0.0 0.0 255.7 49.0 133.4
271016 271016 2022 21355195 DCAS_1023_Manhattan Appellate Court MANHATTAN 27 Madison Ave Courthouse 54,300 492.9 97.95 10.1 482.8 492.9   0.0 0.0 437.4 40.0 120.7
271017 271017 2022 21355196 DCAS_1027_Manhattan Supreme Court MANHATTAN 60 Centre St Courthouse 322,300 3563.8 119.48 1003.5 2560.3 3563.8   0.0 0.0 3039.3 37.0 150.3
271018 271018 2022 21355197 DCAS_1028_Midtown Community Court MANHATTAN 314 West 54th St Courthouse 43,233 348.6 87.19 102.4 246.2 348.6   0.0 0.0 276.2 32.0 112.0
271024 271024 2022 21355203 DCAS_1044_Long Island City Courthouse QUEENS 25-10 Court Sq Courthouse 59,300 330.6 60.28 214.4 116.2 330.6   0.0 0.0 430.2 68.0 91.2
271026 271026 2022 21355205 DCAS_1049_Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308,200 1386.9 48.44 826.6 560.3 1386.9   0.0 0.0 2516.9 85.0 70.1
271028 271028 2022 21355207 DCAS_1053_Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 18,000 103.0 61.35 56.5 46.5 103.0   0.0 0.0 135.5 69.0 89.6
271029 271029 2022 21355208 DCAS_1055_Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 12,300 85.3 74.27 40.6 44.6 85.3   0.0 0.0 88.0 52.0 105.1
271111 271111 2022 21355292 DCAS_3864_Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 21,500 52.6 25.83 43.2 9.4 52.6   0.0 0.0 190.5 98.0 43.0
271397 271397 2022 21355591 DCAS_1024_Manhattan Civil Court MANHATTAN 111 Centre St Courthouse 467,000 1795.5 40.9 0.0 1795.5 1795.5   0.0 0.0 3404.2 87.0 50.8
271398 271398 2022 21355592 DCAS_1026_Manhattan Family Court MANHATTAN 60 Lafayette St Courthouse 491,000 1920.6 41.98 0.0 1920.6 1920.6   0.0 0.0 3585.7 86.0 51.0
271399 271399 2022 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 2233.3 44.13 1436.6 796.7 2233.3   0.0 0.0 5333.6 93.0 52.8
271400 271400 2022 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 2503.4 54.9 838.2 1665.3 2503.4   0.0 0.0 4292.3 83.0 70.7
271401 271401 2022 21355595 DCAS_1047_Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 320,535 953.9 32.29 313.8 640.1 953.9   0.0 0.0 2087.5 91.0 41.3
271605 271605 2022 26656539 DCAS_1046_Queens Criminal Court and Annex QUEENS 125-01 Queens Blvd Courthouse 648,000 2391.5 39.83 243.2 2148.2 2391.5   0.0 0.0 3672.2 78.0 45.9
271615 271615 2022 26672463 Benchmarking Group - 215 QUEENS 125-01 Queens Blvd Courthouse 1,162,654 2456.5 22.6 261.8 2194.7 2456.5   0.0 0.0 7781.4 0.0 26.4
222378 222378 2021 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 2519.4 92240.03 830.9 1688.6 2519.4 73.8 0.0 0.0   0.0 130.3
222380 222380 2021 21354176 DCAS_1048_Queens Family Court QUEENS 151-20 Jamaica Ave Courthouse 291,589 2171.9 80337.16 830.9 1341.0 2171.9 73.8 0.0 0.0   40.0 115.3
222427 222427 2021 21354223 Benchmarking Group - 193 STATEN IS 26 Central Ave Courthouse 182,000 1267.5 74962.88 457.1 810.4 1267.5 73.8 0.0 0.0   0.0 104.6
222428 222428 2021 21354224 DCAS_5571_Richmond County Supreme Court STATEN IS 26 Central Ave Courthouse 182,000 891.5 52725.37 457.1 434.4 891.5 73.8 0.0 0.0   73.0 76.6
222451 222451 2021 21354247 Benchmarking Group - 2 MANHATTAN 100 Centre St Courthouse 1,545,842 9072.1 97651177.19 5163.5 3908.6 9072.1 73.8 0.0 0.0   0.0 97.2
222452 222452 2021 21354248 DCAS_1025_Manhattan Criminal Court MANHATTAN 100 Centre St Courthouse 795,700 7375.2 99856.5 5154.5 2220.7 7375.2 73.8 0.0 0.0   35.0 159.8
222670 222670 2021 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 3566.5 60455.83 2129.6 1436.9 3566.5 73.8 0.0 0.0   0.0 92.8

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