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

242 rows where Borough = "QUEENS" and Property Type = "Strip Mall" 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

  • Strip Mall · 242 ✖

Borough 1

  • QUEENS · 242 ✖
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)
308435 308435 2024 2691395 Howard Plaza Realty - 82-07 153rd Ave QUEENS 82-07 153RD AVENUE Strip Mall 56,315 1094.64 209.25 35.13 1059.51     0.0 0.0 532.83 0.0 175.2
309394 309394 2024 2800451 Redmont Realty Company QUEENS 153-15 Cross Island Parkway Strip Mall 205,430 1451.49 76.1 331.47 1120.02     0.0 0.0 2018.4 0.0 77.8
309804 309804 2024 2814700 CAMPUS - 138-09 and 139-13 20 AVENUE - [140-01 20th Avenue] QUEENS 138-09 20 AVENUE Strip Mall 76,728 461.51 64.69 45.56 415.96     0.0 0.0 735.2 0.0 58.3
310266 310266 2024 2870719 Combined-Bay Terrace Shopping Center 1-4 QUEENS 212-15 26 Avenue Strip Mall 198,298 0.0 0.0 0.0 1906.36     0.0 0.0 1780.58 0.0 0.0
310267 310267 2024 2870723 Combined-Bay Terrace Shopping Center 5 QUEENS 211-01 26Th Avenue Strip Mall 132,289 1693.54 137.78 594.86 1098.68     0.0 0.0 1331.82 0.0 156.8
311612 311612 2024 3527121 FCE : 24902 Horace Harding Expressway QUEENS 24902 Horace Harding Expressway Strip Mall 54,463 1242.93 245.63 405.63 837.3     0.0 0.0 545.58 0.0 273.8
312573 312573 2024 4259004 90-30 Metropolitan Ave/ 80004 QUEENS 9030 Metropolitan Ave Strip Mall 59,826 637.47 114.74 95.11 542.35     0.0 0.0 578.83 0.0 108.7
313277 313277 2024 4413933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Strip Mall 129,888 1395.95 115.71 521.45 874.5     0.0 0.0 1313.53 0.0 134.1
314975 314975 2024 5934957 133-40 79th Street QUEENS 133-40 79th Street Strip Mall 139,370 1093.99 84.5 322.52 771.46     0.0 0.0 1387.4 0.0 91.7
314976 314976 2024 5934962 135-25 79th Street QUEENS 135-25 79th Street Strip Mall 93,880 464.7 53.28 85.13 379.57     0.0 0.0 356.73 0.0 52.2
315012 315012 2024 5966043 Clocktower Plaza Shopping Center/ 80030 QUEENS 92-06 ATLANTIC AVENUE Strip Mall 78,820 139.31 19.05 12.88 126.42     0.0 0.0 754.35 0.0 17.0
315217 315217 2024 6167848 The Plaza at Little Neck Hills, LLC QUEENS 252-20 Northern Boulevard Strip Mall 52,515 355.34 72.87 121.07 234.27     0.0 0.0 652.63 0.0 71.6
315338 315338 2024 6187120 220-10 Hillside Avenue QUEENS 220-10 Hillside Avenue Strip Mall 90,864 895.76 106.13 188.61 707.15     0.0 0.0 889.66 0.0 106.7
315340 315340 2024 6187130 163-02 Jamaica Avenue QUEENS 163-02 Jamaica Avenue Strip Mall 42,000 218.01 55.86 0.0 218.01     0.0 0.0 394.99 0.0 45.1
316585 316585 2024 6287992 Springfield Associates, LLC QUEENS 61-02 SPRINGFIELD BOULEVARD Strip Mall 26,936 372.0 148.65 193.68 178.32     0.0 0.0 280.72 0.0 192.9
317313 317313 2024 6355281 Horace Harding Shopping LP_59-16 99th Street QUEENS 5916 99 ST Strip Mall 55,378 559.19 108.72 28.45 530.74     0.0 0.0 1020.36 0.0 92.9
317780 317780 2024 6457791 89-28 165th Street AKA 89-41 164th Street QUEENS 89-28 165th Street AKA 89-41 164th Street Strip Mall 89,829 264.2 31.65 126.25 137.95     0.0 0.0 927.93 0.0 39.8
319123 319123 2024 6686937 Expressway Shopping LP_57-02_57-16 99th Street QUEENS 5702 99 ST Strip Mall 41,004 311.68 81.81 0.0 311.68     0.0 0.0 150.46 0.0 66.0
320331 320331 2024 6791297 36-35 College Point Blvd QUEENS 36-35 College Point Blvd Strip Mall 25,987 3.68 1.51 3.68 0.0     0.0 0.0 300.78 0.0 2.7
320988 320988 2024 6814670 102-20 Atlantic Ave QUEENS 102-20 Atlantic Ave Strip Mall 34,604 0.0 0.0 0.0 629.67     0.0 0.0 310.72 0.0 0.0
322094 322094 2024 8703913 Pelican: 2-29 Beach 20th St. QUEENS 2-29 Beach 20th Street Strip Mall 43,091 777.31 194.18 39.36 737.95     0.0 0.0 409.14 0.0 166.0
322352 322352 2024 9636381 71-26 Main Street QUEENS 71-26 Main Street Strip Mall 28,000 185.88 71.47 76.63 109.25     0.0 0.0 321.77 0.0 70.8
324308 324308 2024 14844770 78-14 Roosevelt Avenue (Parent Property) QUEENS 78-14 Roosevelt Avenue Strip Mall 61,229 458.86 80.62 99.48 359.39     0.0 0.0 600.23 0.0 81.6
324733 324733 2024 15354001 74-25 Grand Ave QUEENS 74-25 Grand Avenue Strip Mall 47,501 781.52 177.07 417.27 364.24     0.0 0.0 496.41 0.0 232.0
325489 325489 2024 16825113 Cross Bay QUEENS 160-04 Cross Bay Boulevard Strip Mall 40,699 358.08 94.08 91.95 266.13     0.0 0.0 404.75 0.0 98.7
325898 325898 2024 18968107 156-10 and 156-44 Northern Boulevard QUEENS 156-10 Northern Boulevard Strip Mall 48,595 1256.76 278.35 427.06 829.71     0.0 0.0 488.11 0.0 313.8
326874 326874 2024 20807780 163-28 Northern Boulevard QUEENS 163-28 Northern Boulevard Strip Mall 31,837 55.39 29.49 15.63 39.76     0.0 0.0 200.89 0.0 31.6
329507 329507 2024 24727173 208-02 Cross Island Pkwy QUEENS 208-02 Cross Island Pkwy Strip Mall 38,475 449.32 125.72 127.26 322.06     0.0 0.0 382.13 0.0 135.0
331323 331323 2024 31476676 Little Neck Plaza QUEENS 254-21 Nassau Boulevard Strip Mall 79,395 1017.25 137.89 314.6 702.65     0.0 0.0 792.63 0.0 151.5
333328 333328 2024 33987336 23-44 BELL BOULEVARD QUEENS 23-42 BELL BOULEVARD Strip Mall 15,930 233.77 157.91 41.83 191.94     0.0 0.0 155.02 0.0 154.1
333331 333331 2024 33987513 Combined-Bay Terrace Shopping Center 1-4 Campus QUEENS 212-45 26th Ave. Strip Mall 214,228 0.0 0.0 0.0 2095.46     0.0 0.0 1923.62 0.0 0.0
333609 333609 2024 35178304 Expressway Shopping LP_57-02_57-16 99th Street_ QUEENS 5702 99 ST Strip Mall 44,000 0.0 0.0 0.0 0.0     0.0 0.0 395.09 0.0 0.0
334861 334861 2024 49852692 RIPCO Management:48-18 NORTHERN BOULEVARD QUEENS 48-18 NORTHERN BOULEVARD Strip Mall 241,993 2572.26 114.42 299.96 2272.3     0.0 0.0 2326.72 0.0 104.9
335468 335468 2024 51757794 PARENT - 139-13 20 AVENUE - [140-01 20th Avenue] QUEENS 139-13 20 AVENUE Strip Mall 38,364 248.15 69.64 40.18 207.98     0.0 0.0 372.09 0.0 66.8
335470 335470 2024 51759592 PARENT - 138-09 20 AVENUE - [140-01 20th Avenue] QUEENS 138-09 20 AVENUE Strip Mall 38,364 248.15 69.64 40.18 207.98     0.0 0.0 372.09 0.0 66.8
336134 336134 2024 53019392 56-21 Marathon Parkway QUEENS 56-21 Marathon Parkway Strip Mall 13,454 157.42 125.94 102.89 54.53     0.0 0.0 144.2 0.0 179.2
337477 337477 2024 54076693 211-37 26 AVENUE QUEENS 211-37 26 AVENUE Strip Mall 44,096 0.0 0.0 0.0 0.0     0.0 0.0 395.95 0.0 0.0
337478 337478 2024 54077792 210-35 26 AVENUE QUEENS 210-35 26 AVENUE Strip Mall 44,096 0.0 0.0 0.0 0.0     0.0 0.0 395.95 0.0 0.0
337479 337479 2024 54077892 210-31 26 AVENUE QUEENS 210-31 26 AVENUE Strip Mall 44,097 0.0 0.0 0.0 0.0     0.0 0.0 395.96 0.0 0.0
337612 337612 2024 54114293 212-49 26 AVENUE QUEENS 212-49 26 AVENUE Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337613 337613 2024 54114992 212-51 26 AVENUE QUEENS 212-51 26 AVENUE Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337614 337614 2024 54114993 213-15 26 AVENUE QUEENS 213-15 26 AVENUE Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337615 337615 2024 54115092 24-20 BELL BOULEVARD QUEENS 24-20 BELL BOULEVARD Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337616 337616 2024 54115093 23-56 BELL BOULEVARD QUEENS 23-56 BELL BOULEVARD Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337617 337617 2024 54115192 24-22 BELL BOULEVARD QUEENS 24-22 BELL BOULEVARD Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337618 337618 2024 54115292 23-52 BELL BOULEVARD QUEENS 23-52 BELL BOULEVARD Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337619 337619 2024 54115293 213-25 26 AVENUE QUEENS 213-25 26 AVENUE Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337620 337620 2024 54115392 23-58 BELL BOULEVARD QUEENS 23-58 BELL BOULEVARD Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
337621 337621 2024 54115492 24-26 BELL BOULEVARD QUEENS 24-26 BELL BOULEVARD Strip Mall 18,027 0.0 0.0 0.0 0.0     0.0 0.0 161.87 0.0 0.0
338748 338748 2024 56015035 Redmont Realty Company - 5 of 8 BINs QUEENS 153-55 CROSS ISLAND PARKWAY Strip Mall 25,678 0.0 0.0 0.0 0.0     0.0 0.0 230.57 0.0 0.0
338751 338751 2024 56017893 Redmont Realty Company - 2 of 8 BINs QUEENS 153-27 CROSS ISLAND PARKWAY Strip Mall 25,678 0.0 0.0 0.0 0.0     0.0 0.0 230.57 0.0 0.0
338755 338755 2024 56019495 Redmont Realty Company - 6 of 8 BINs QUEENS 153-65 CROSS ISLAND PARKWAY Strip Mall 25,678 0.0 0.0 0.0 0.0     0.0 0.0 230.57 0.0 0.0
338760 338760 2024 56019794 Redmont Realty Company - 4 of 8 BINs QUEENS 153-37 CROSS ISLAND PARKWAY Strip Mall 25,678 0.0 0.0 0.0 0.0     0.0 0.0 230.57 0.0 0.0
338761 338761 2024 56019795 Redmont Realty Company - 7 of 8 BINs QUEENS 153-69 CROSS ISLAND PARKWAY Strip Mall 25,678 0.0 0.0 0.0 0.0     0.0 0.0 230.57 0.0 0.0
338762 338762 2024 56020292 Redmont Realty Company - 1 of 8 BINs QUEENS 153-23 CROSS ISLAND PARKWAY Strip Mall 25,678 0.0 0.0 0.0 0.0     0.0 0.0 230.57 0.0 0.0
338763 338763 2024 56020293 Redmont Realty Company - 3 of 8 BINs QUEENS 153-15 CROSS ISLAND PARKWAY Strip Mall 25,678 0.0 0.0 0.0 0.0     0.0 0.0 230.57 0.0 0.0
338764 338764 2024 56020294 Redmont Realty Company - 8 of 8 BINs QUEENS 151-20 14 ROAD Strip Mall 25,684 0.0 0.0 0.0 0.0     0.0 0.0 230.62 0.0 0.0
339359 339359 2024 56868193 91-20 59 Avenue QUEENS 91-20 59 Avenue Strip Mall 303 0.0 0.0 0.0 0.0     0.0 0.0 2.72 0.0 0.0
339360 339360 2024 56869193 91-18 59 Avenue QUEENS 91-18 59 Avenue Strip Mall 157 0.0 0.0 0.0 0.0     0.0 0.0 1.41 0.0 0.0
340085 340085 2024 58846992 40-13 78th Street QUEENS 40-13 78th Street Strip Mall 9,908 0.0 0.0 0.0 0.0     0.0 0.0 88.97 0.0 0.0
340086 340086 2024 58847192 40-02 79th Street QUEENS 40-02 79th Street Strip Mall 51,321 0.0 0.0 0.0 0.0     0.0 0.0 460.83 0.0 0.0
343365 343365 2024 64765392 249-02 Horace Harding Expressway QUEENS 249-02 Horace Harding Expressway Strip Mall 90,666 1110.25 131.86 316.81 793.44     0.0 0.0 900.87 0.0 141.8
343521 343521 2024 65090293 Cross Bay Commons 4438969 QUEENS 156-40 Cross Bay Blvd Strip Mall 3,579 0.0 0.0 0.0 0.0     0.0 0.0 32.14 0.0 0.0
343641 343641 2024 65359895 102-20 Atlantic Ave Nat Grid Placeholder 4 QUEENS 102-20 Atlantic Ave Strip Mall 1 0.0 0.0 0.0 0.0     0.0 0.0 0.0 0.0 0.0
343642 343642 2024 65359896 102-20 AtlanticAve Nat Grid Placeholder 8 QUEENS 102-20 Atlantic Ave Strip Mall 1 52.08 560602.75 52.08 0.0     0.0 0.0 0.01 0.0 980556.1
343647 343647 2024 65361194 102-20 Atlantic Ave Nat Grid Placeholder 3 QUEENS 102-20 Atlantic Ave Strip Mall 1 4.87 52452.92 4.87 0.0     0.0 0.0 0.01 0.0 91746.0
343649 343649 2024 65361494 102-20 Atlantic Ave Nat Grid Placeholder 2 QUEENS 102-20 Atlantic Ave Strip Mall 1 2.02 21762.45 2.02 0.0     0.0 0.0 0.01 0.0 38065.0
343650 343650 2024 65361495 102-20 Atlantic Ave Nat Grid Placeholder 6 QUEENS 102-20 Atlantic Ave Strip Mall 1 6.01 64731.19 6.01 0.0     0.0 0.0 0.01 0.0 113222.0
343654 343654 2024 65363392 102-20 Atlantic Ave Nat Grid Placeholder QUEENS 102-20 Atlantic Ave Strip Mall 34,597 28.96 9.04 28.96 0.0     0.0 0.0 400.44 0.0 15.8
343655 343655 2024 65363393 102-20 Atlantic Ave Nat Grid Placeholder 7 QUEENS 102-20 Atlantic Ave Strip Mall 1 0.75 8054.95 0.75 0.0     0.0 0.0 0.01 0.0 14089.0
343656 343656 2024 65363492 102-20 Atlantic Ave Nat Grid Placeholder 5 QUEENS 102-20 Atlantic Ave Strip Mall 1 5.44 58608.04 5.44 0.0     0.0 0.0 0.01 0.0 102512.0
272763 272763 2023 6686937 Expressway Shopping LP_57-02_57-16 99th Street QUEENS 5702 99 ST Strip Mall 44,000 216.5 52.74 0.0 216.5     0.0 0.0 390.9 0.0 45.2
273722 273722 2023 6750813 AAG: 133-11 20th Ave QUEENS 133-11 20th Ave Strip Mall 84,530 1366.5 174.38 327.2 1039.3     0.0 0.0 795.3 0.0 186.0
273951 273951 2023 6779362 36-58 Main Street QUEENS 36-58 Main Street Strip Mall 25,287 199.0 85.03 66.6 132.4     0.0 0.0 243.6 0.0 97.8
274294 274294 2023 6791297 36-35 College Point Blvd QUEENS 36-35 College Point Blvd Strip Mall 25,987 35.6 15.07 14.1 21.5     0.0 0.0 254.3 0.0 17.9
275222 275222 2023 6814670 102-20 Atlantic Ave QUEENS 102-20 Atlantic Ave Strip Mall 34,604 521.8 162.53 0.0 521.8     0.0 0.0 307.4 0.0 138.7
276028 276028 2023 8703913 Pelican: 2-29 Beach 20th St. QUEENS 2-29 Beach 20th Street Strip Mall 43,091 88.7 22.6 38.6 50.1     0.0 0.0 425.9 0.0 27.6
276524 276524 2023 9636381 71-26 Main Street QUEENS 71-26 Main Street Strip Mall 28,000 205.8 79.65 84.5 121.3     0.0 0.0 302.3 0.0 83.3
277805 277805 2023 11168455 The Shops At Skyview Center (sk030, sk031, sk032) QUEENS 40-24 College Point Blvd Strip Mall 1,997,508 5741.4 31.22 477.0 5264.4     0.0 0.0 18096.7 0.0 28.7
279183 279183 2023 14844770 78-14 Roosevelt Avenue QUEENS 78-14 Roosevelt Avenue Strip Mall 61,229 337.5 59.2 0.0 337.5     0.0 0.0 544.0 0.0 50.7
279360 279360 2023 15144900 AAC: 242-02 61st Ave QUEENS 242-02 61st Ave Strip Mall 368,392 1987.2 58.13 163.6 1823.6     0.0 0.0 3336.9 0.0 53.9
279412 279412 2023 15355788 176-60 Union Turnpike QUEENS 176-60 Union Turnpike Strip Mall 178,682 941.4 57.05 79.2 862.2     0.0 0.0 1619.2 0.0 52.7
283754 283754 2023 2800451 Redmont Realty Company QUEENS 153-15 Cross Island Parkway Strip Mall 148,673 1330.7 96.88 290.2 1040.5     0.0 0.0 1391.4 0.0 101.1
284852 284852 2023 2870719 Combined-Bay Terrace Shopping Center 1-4 QUEENS 212-45 26th Ave. Strip Mall 210,659 2275.2 116.25 411.3 1863.9     0.0 0.0 1953.7 0.0 118.1
284853 284853 2023 2870723 Combined-Bay Terrace Shopping Center 5 QUEENS 211-01 26th Ave Strip Mall 132,289 1554.4 127.01 391.0 1163.4     0.0 0.0 1248.3 0.0 136.5
286341 286341 2023 3527121 FCE : 24902 Horace Harding Expressway QUEENS 24902 Horace Harding Expressway Strip Mall 54,463 1096.5 216.35 313.7 782.8     0.0 0.0 518.4 0.0 240.6
286767 286767 2023 3541760 184-04 Merrick Boulevard QUEENS 13440 SPRINGFIELD BLVD HOUSE Strip Mall 100,875 1739.7 185.14 539.5 1200.1     0.0 0.0 965.9 0.0 210.1
287833 287833 2023 31476676 Little Neck Plaza QUEENS 254-21 Nassau Boulevard Strip Mall 48,275 1013.1 226.04 322.0 691.0     0.0 0.0 463.1 0.0 257.2
290106 290106 2023 33987336 23-44 BELL BOULEVARD QUEENS 212-45 26th Ave. Strip Mall 210,659 227.0 11.84 49.0 178.0     0.0 0.0 1970.5 0.0 12.2
290107 290107 2023 33987513 Combined-Bay Terrace Shopping Center 1-4 Campus QUEENS 212-45 26th Ave. Strip Mall 210,659 2502.2 128.09 460.3 2041.9     0.0 0.0 1955.2 0.0 130.3
290573 290573 2023 35178304 Expressway Shopping LP_57-02_57-16 99th Street_ QUEENS 5702 99 ST Strip Mall 44,000 216.5 52.74 0.0 216.5     0.0 0.0 390.9 0.0 45.2
291691 291691 2023 16825113 Cross Bay QUEENS 160-04 Cross Bay Boulevard Strip Mall 31,430 318.1 108.72 76.5 241.5     0.0 0.0 295.8 0.0 116.5
292262 292262 2023 18968107 156-10 & 156-44 Northern Boulevard QUEENS 156-10 Northern Boulevard Strip Mall 48,595 1080.2 238.96 347.9 732.4     0.0 0.0 466.7 0.0 273.4
292653 292653 2023 20001936 LaGuardia Center Realty LLC QUEENS 43-02 Ditmars Blvd Strip Mall 85,744 1015.7 127.01 312.7 703.0     0.0 0.0 820.5 0.0 144.1
292937 292937 2023 20581767 249-02 Horace Harding Expressway QUEENS 249-02 Horace Harding Expressway Strip Mall 51,059 1117.6 235.73 328.0 789.6     0.0 0.0 486.8 0.0 263.2
293240 293240 2023 20807780 163-28 Northern Boulevard QUEENS 163-28 Northern Boulevard Strip Mall 29,130 60.0 22.6 16.4 43.6     0.0 0.0 276.3 0.0 24.3
296039 296039 2023 24727173 208-02 Cross Island Pkwy QUEENS 208-02 Cross Island Pkwy Strip Mall 38,475 489.6 136.7 180.2 309.4     0.0 0.0 373.8 0.0 162.2
298336 298336 2023 4259004 90-30 Metropolitan Ave/ 80004 QUEENS 9030 Metropolitan Ave Strip Mall 59,826 740.1 133.47 100.1 640.0     0.0 0.0 548.8 0.0 129.9
299120 299120 2023 4413933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Strip Mall 129,888 885.5 73.19 347.1 538.4     0.0 0.0 1269.7 0.0 88.4
301413 301413 2023 5966043 Clocktower Plaza Shopping Center/ 80030 QUEENS 94-02 93 Street Strip Mall 78,820 0.0 0.0 0.0 0.0     0.0 0.0 686.0 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");