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

129 rows where Borough = "QUEENS" and Property Type = "Other - Lodging/Residential" 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

  • Other - Lodging/Residential · 129 ✖

Borough 1

  • QUEENS · 129 ✖
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)
309130 309130 2024 2787516 93 Jamaica Realty, LLC QUEENS 170-02 93rd Ave Other - Lodging/Residential 54,615 283.29 55.86 163.71 119.58     0.0 0.0 361.45 0.0 75.5
309132 309132 2024 2787550 Hillside Avenue Development, LLC QUEENS 160-11 89th Avenue Other - Lodging/Residential 58,625 513.79 94.29 372.81 140.99     0.0 0.0 400.42 0.0 140.6
310415 310415 2024 2961856 175-15 Rockaway Blvd. QUEENS 175-15 Rockaway Boulevard Other - Lodging/Residential 74,900 635.57 91.39 166.06 469.51     0.0 0.0 472.87 0.0 93.3
311025 311025 2024 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Other - Lodging/Residential 68,760 0.0 0.0 0.0 220.47     0.0 0.0 372.66 0.0 0.0
313095 313095 2024 4409117 Beach 65, LLC QUEENS 316 BEACH 65th ST Other - Lodging/Residential 65,000 747.59 123.78 420.25 327.34     0.0 0.0 428.76 0.0 165.5
314280 314280 2024 4988475 7900 Development, LLC QUEENS 7900 Queens Boulevard Other - Lodging/Residential 92,400 1120.78 130.57 741.5 379.27     0.0 0.0 769.57 0.0 143.8
318888 318888 2024 6675619 Westway Associates, LLC QUEENS 71-11 Astoria Boulevard N Other - Lodging/Residential 38,160 250.31 70.61 59.1 191.21     0.0 0.0 251.33 0.0 64.4
320261 320261 2024 6789453 Pam's Place Women Shelter QUEENS 40-03 29Th Street Other - Lodging/Residential 56,156 363.95 69.75 140.37 223.58     0.0 0.0 357.21 0.0 81.7
321331 321331 2024 6932877 West Canyon, LLC QUEENS 132-10 South Conduit Ave., Queens Other - Lodging/Residential 29,000 301.9 112.05 184.04 117.86     0.0 0.0 193.21 0.0 154.8
321935 321935 2024 8151625 163-03 89 Avenue QUEENS 163-03 89 Avenue Other - Lodging/Residential 39,000 544.27 150.26 474.44 69.83     0.0 0.0 371.47 0.0 180.6
322141 322141 2024 8720174 S and Z Associates, LLC QUEENS 87-02 23rd Avenue Other - Lodging/Residential 38,260 361.11 101.61 185.27 175.84     0.0 0.0 249.81 0.0 131.1
323070 323070 2024 10829269 127-03 20th Avenue LLC QUEENS 127-03 20th Avenue Other - Lodging/Residential 42,208 255.84 65.23 76.66 179.17     0.0 0.0 263.9 0.0 71.1
327829 327829 2024 21354352 DOC_1171_Rikers Island DOI/IG QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0     0.0 0.0 17.34 0.0 0.0
327833 327833 2024 21354356 DOC_1175_Rikers Island SOD Visits / NSD / Law library QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0     0.0 0.0 17.34 0.0 0.0
327837 327837 2024 21354360 DOC_1179_Rikers Island ASRS Locker Room QUEENS Rikers Island Other - Lodging/Residential 8,000 0.0 0.0 0.0 0.0     0.0 0.0 43.36 0.0 0.0
327838 327838 2024 21354361 DOC_1180_Rikers Island Compost Facility QUEENS Rikers Island Other - Lodging/Residential 9,000 0.0 0.0 0.0 0.0     0.0 0.0 48.78 0.0 0.0
327839 327839 2024 21354362 DOC_1181_Rikers Island DCJC / OT CTRL QUEENS Rikers Island Other - Lodging/Residential 4,800 0.0 0.0 0.0 0.0     0.0 0.0 26.01 0.0 0.0
327840 327840 2024 21354363 DOC_1182_Rikers Island DIV 1 & 2 / OPC QUEENS Rikers Island Other - Lodging/Residential 2,400 0.0 0.0 0.0 0.0     0.0 0.0 13.01 0.0 0.0
327867 327867 2024 21354390 DOC_1209_Rikers Island Bridge Abutment Checkpoint QUEENS Rikers Island Other - Lodging/Residential 600 38.53 691.15 0.0 38.53     0.0 0.0 3.54 0.0 558.0
331216 331216 2024 30734629 Van Dam Terrace LLC - 52-34 Van Dam St QUEENS 52-34 Van Dam St Other - Lodging/Residential 67,223 526.82 84.39 130.84 395.98     0.0 0.0 416.07 0.0 87.8
331725 331725 2024 33055651 37-06 36TH STREET HOLDINGS LLC QUEENS 35-02 37 AVENUE Other - Lodging/Residential 80,200 351.33 47.15 0.0 351.33     0.0 0.0 473.28 0.0 38.1
331727 331727 2024 33055732 90-10 Ditmars Blvd QUEENS 90-10 Ditmars Blvd Other - Lodging/Residential 189,250 1010.84 57.48 3.68 1007.16     0.0 0.0 1117.56 0.0 46.6
331728 331728 2024 33055803 3859 11th St LLC QUEENS 3859 11th St Other - Lodging/Residential 182,685 916.79 54.03 229.25 687.54     0.0 0.0 1131.08 0.0 56.3
333498 333498 2024 34764420 Roosevelt Ave QUEENS 9109 Roosevelt Ave Other - Lodging/Residential 78,953 378.47 51.56 0.0 378.47     0.0 0.0 465.92 0.0 41.7
334201 334201 2024 46071792 138-68 94 Ave LLC QUEENS 138-68 94th Avenue, Jamaica, New York 11435 Other - Lodging/Residential 21,375 0.0 0.0 0.0 0.0     0.0 0.0 115.84 0.0 0.0
334734 334734 2024 49376698 9411 110th St QUEENS 9411 110th St Other - Lodging/Residential 1,404 0.13 0.97 0.13 0.0     0.0 0.0 7.78 0.0 1.7
339957 339957 2024 58720892 Rego Park LLC QUEENS 92-73 Queens Blvd Other - Lodging/Residential 61,780 244.4 42.63 0.0 244.4     0.0 0.0 364.58 0.0 34.4
339960 339960 2024 58721092 VOA QUEENS 95-10 218 Street Other - Lodging/Residential 27,827 165.38 63.94 0.0 165.38     0.0 0.0 164.21 0.0 51.6
344720 344720 2024 65522392 Crosstown Management : 36-41 UNION STREET QUEENS 36-41 UNION STREET Other - Lodging/Residential 37,255 234.13 67.6 158.74 75.39     0.0 0.0 251.86 0.0 97.8
272416 272416 2023 6675619 Westway Associates, LLC QUEENS 71-11 Astoria Boulevard N Other - Lodging/Residential 38,160 328.5 92.57 143.4 185.1     0.0 0.0 267.9 0.0 95.2
275420 275420 2023 6932877 West Canyon, LLC QUEENS 132-10 South Conduit Ave., Queens Other - Lodging/Residential 29,000 302.2 111.94 198.3 103.9     0.0 0.0 190.8 0.0 161.7
276346 276346 2023 8151625 163-03 89 Avenue QUEENS 163-03 89 Avenue Other - Lodging/Residential 39,000 560.7 155.0 493.6 67.2     0.0 0.0 366.3 0.0 189.1
276490 276490 2023 8720174 S and Z Associates, LLC QUEENS 87-02 23rd Avenue Other - Lodging/Residential 38,260 362.6 102.26 192.7 169.9     0.0 0.0 243.3 0.0 135.7
277679 277679 2023 10829269 127-03 20th Avenue LLC QUEENS 127-03 20th Avenue Other - Lodging/Residential 42,208 256.2 65.66 88.9 167.4     0.0 0.0 255.9 0.0 76.1
283507 283507 2023 2787516 93 Jamaica Realty, LLC QUEENS 170-02 93rd Ave Other - Lodging/Residential 54,615 275.1 53.82 174.0 101.1     0.0 0.0 356.9 0.0 77.0
283509 283509 2023 2787550 Hillside Avenue Development, LLC QUEENS 160-11 89th Avenue Other - Lodging/Residential 58,625 538.5 99.03 384.2 154.3     0.0 0.0 391.8 0.0 147.6
284949 284949 2023 2961856 175-15 Rockaway Blvd. QUEENS 175-15 149 road Other - Lodging/Residential 74,477 583.9 83.96 140.8 443.1     0.0 0.0 441.8 0.0 89.6
285690 285690 2023 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Other - Lodging/Residential 75,225 411.7 59.2 201.4 210.4     0.0 0.0 479.6 0.0 74.7
287478 287478 2023 30734629 Van Dam Terrace LLC - 52-34 Van Dam St QUEENS 52-34 Van Dam St Other - Lodging/Residential 67,223 517.0 82.88 161.1 355.9     0.0 0.0 404.0 0.0 93.8
288067 288067 2023 33055651 37-06 36TH STREET HOLDINGS LLC QUEENS 37-06 36th Street Other - Lodging/Residential 80,200 306.3 40.9 1.4 305.0     0.0 0.0 447.6 0.0 35.3
288547 288547 2023 33055732 90-10 Ditmars Blvd QUEENS 90-10 Ditmars Blvd Other - Lodging/Residential 189,250 933.7 52.74 10.5 923.2     0.0 0.0 1057.8 0.0 45.9
288548 288548 2023 33055803 3859 11th St LLC QUEENS 3859 11th St Other - Lodging/Residential 182,685 805.0 47.36 216.0 589.0     0.0 0.0 1086.2 0.0 51.9
290673 290673 2023 34764420 Roosevelt Ave QUEENS 9109 Roosevelt Ave Other - Lodging/Residential 78,953 220.7 30.14 0.0 220.7     0.0 0.0 477.1 0.0 23.7
294304 294304 2023 21354352 DOC_1171_Rikers Island DOI/IG QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0     0.0 0.0 16.3 0.0 0.0
294308 294308 2023 21354356 DOC_1175_Rikers Island SOD Visits / NSD / Law library QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0     0.0 0.0 16.3 0.0 0.0
294312 294312 2023 21354360 DOC_1179_Rikers Island ASRS Locker Room QUEENS Rikers Island Other - Lodging/Residential 8,000 0.0 0.0 0.0 0.0     0.0 0.0 40.7 0.0 0.0
294313 294313 2023 21354361 DOC_1180_Rikers Island Compost Facility QUEENS Rikers Island Other - Lodging/Residential 9,000 0.0 0.0 0.0 0.0     0.0 0.0 45.8 0.0 0.0
294314 294314 2023 21354362 DOC_1181_Rikers Island DCJC / OT CTRL QUEENS Rikers Island Other - Lodging/Residential 4,800 0.0 0.0 0.0 0.0     0.0 0.0 24.4 0.0 0.0
294315 294315 2023 21354363 DOC_1182_Rikers Island DIV 1 & 2 / OPC QUEENS Rikers Island Other - Lodging/Residential 2,400 0.0 0.0 0.0 0.0     0.0 0.0 12.2 0.0 0.0
294342 294342 2023 21354390 DOC_1209_Rikers Island Bridge Abutment Checkpoint QUEENS Rikers Island Other - Lodging/Residential 600 38.6 693.2 0.0 38.6     0.0 0.0 3.3 0.0 592.0
297948 297948 2023 28499930 URI/ 84-42 Smedley Street QUEENS 84-42 Smedley Street Other - Lodging/Residential 39,898 252.2 67.81 145.4 106.8     0.0 0.0 256.8 0.0 93.2
299270 299270 2023 4409117 Beach 65, LLC QUEENS 316 BEACH 65th ST Other - Lodging/Residential 65,000 748.1 123.78 447.7 300.4     0.0 0.0 420.9 0.0 172.2
300751 300751 2023 4988475 7900 Development, LLC QUEENS 7900 Queens Boulevard Other - Lodging/Residential 92,400 764.9 89.34 407.8 357.1     0.0 0.0 688.1 0.0 95.0
252980 252980 2022 8151625 163-03 89 Avenue QUEENS 163-03 89 Avenue Other - Lodging/Residential 39,000 492.2 135.63 437.1 55.0 492.2   0.0 0.0 347.3 0.0 171.3
259864 259864 2022 28499930 URI/ 84-42 Smedley Street QUEENS 84-42 Smedley Street Other - Lodging/Residential 39,898 169.0 45.21 98.6 70.4 169.0   0.0 0.0 226.1 0.0 67.4
260264 260264 2022 2787516 93 Jamaica Realty, LLC QUEENS 170-02 93rd Ave Other - Lodging/Residential 54,615 275.5 53.82 182.1 93.4 275.5   0.0 0.0 322.8 0.0 83.0
260266 260266 2022 2787550 Hillside Avenue Development, LLC QUEENS 160-11 89th Avenue Other - Lodging/Residential 58,625 499.9 91.49 373.2 126.7 499.9   0.0 0.0 363.6 0.0 145.4
260296 260296 2022 4409117 Beach 65, LLC QUEENS 316 BEACH 65th ST Other - Lodging/Residential 65,000 519.4 86.11 276.3 243.2 519.4   0.0 0.0 358.7 0.0 124.3
260297 260297 2022 4988475 7900 Development, LLC QUEENS 7900 Queens Boulevard Other - Lodging/Residential 92,400 1101.5 128.09 786.6 315.0 1101.5   0.0 0.0 691.4 0.0 155.0
260332 260332 2022 6675619 Westway Associates, LLC QUEENS 71-11 Astoria Boulevard N Other - Lodging/Residential 38,160 569.3 160.38 422.4 146.9 569.3   0.0 0.0 293.8 0.0 194.7
260354 260354 2022 6932877 West Canyon, LLC QUEENS 132-10 South Conduit Ave., Queens Other - Lodging/Residential 29,000 291.3 107.64 201.0 90.4 291.3   0.0 0.0 174.1 0.0 167.3
260365 260365 2022 8720174 S and Z Associates, LLC QUEENS 87-02 23rd Avenue Other - Lodging/Residential 38,260 335.8 94.72 201.1 134.7 335.8   0.0 0.0 218.6 0.0 140.6
260368 260368 2022 10829269 127-03 20th Avenue LLC QUEENS 127-03 20th Avenue Other - Lodging/Residential 42,208 259.0 65.66 108.9 150.1 259.0   0.0 0.0 220.3 0.0 90.6
270198 270198 2022 21354352 DOC_1171_Rikers Island DOI/IG QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0 0.0   0.0 0.0 13.9 0.0 0.0
270202 270202 2022 21354356 DOC_1175_Rikers Island SOD Visits / NSD / Law library QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0 0.0   0.0 0.0 13.9 0.0 0.0
270206 270206 2022 21354360 DOC_1179_Rikers Island ASRS Locker Room QUEENS Rikers Island Other - Lodging/Residential 8,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 34.7 0.0 0.0
270207 270207 2022 21354361 DOC_1180_Rikers Island Compost Facility QUEENS Rikers Island Other - Lodging/Residential 9,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 39.1 0.0 0.0
270208 270208 2022 21354362 DOC_1181_Rikers Island DCJC / OT CTRL QUEENS Rikers Island Other - Lodging/Residential 4,800 0.0 0.0 0.0 0.0 0.0   0.0 0.0 20.8 0.0 0.0
270209 270209 2022 21354363 DOC_1182_Rikers Island DIV 1 & 2 / OPC QUEENS Rikers Island Other - Lodging/Residential 2,400 0.0 0.0 0.0 0.0 0.0   0.0 0.0 10.4 0.0 0.0
270236 270236 2022 21354390 DOC_1209_Rikers Island Bridge Abutment Checkpoint QUEENS Rikers Island Other - Lodging/Residential 600 28.7 515.59 0.0 28.7 28.7   0.0 0.0 2.6 0.0 566.8
271635 271635 2022 2961856 175-15 Rockaway Blvd. QUEENS 175-15 149 road Other - Lodging/Residential 74,477 543.1 78.58 165.1 378.0 543.1   0.0 0.0 370.9 0.0 100.3
271636 271636 2022 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Other - Lodging/Residential 75,225 370.6 52.74 203.7 166.9 370.6   0.0 0.0 424.5 0.0 75.8
222554 222554 2021 21354352 DOC_1171_Rikers Island DOI/IG QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
222558 222558 2021 21354356 DOC_1175_Rikers Island SOD Visits / NSD / Law library QUEENS Rikers Island Other - Lodging/Residential 3,200 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
222562 222562 2021 21354360 DOC_1179_Rikers Island ASRS Locker Room QUEENS Rikers Island Other - Lodging/Residential 8,000 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
222563 222563 2021 21354361 DOC_1180_Rikers Island Compost Facility QUEENS Rikers Island Other - Lodging/Residential 9,000 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
222564 222564 2021 21354362 DOC_1181_Rikers Island DCJC / OT CTRL QUEENS Rikers Island Other - Lodging/Residential 4,800 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
222565 222565 2021 21354363 DOC_1182_Rikers Island DIV 1 & 2 / OPC QUEENS Rikers Island Other - Lodging/Residential 2,400 0.0 0.0 0.0 0.0 0.0 73.8 0.0 0.0   0.0 0.0
222592 222592 2021 21354390 DOC_1209_Rikers Island Bridge Abutment Checkpoint QUEENS Rikers Island Other - Lodging/Residential 600 25.0 448.5 0.0 25.0 25.0 73.8 0.0 0.0   0.0 564.3
234649 234649 2021 10829269 127-03 20th Avenue LLC QUEENS 127-03 20th Avenue Other - Lodging/Residential 42,208 191.8 49155.14 52.9 138.9 191.8 73.8 0.0 0.0   0.0 68.2
234659 234659 2021 8151625 163-03 89 Avenue QUEENS 163-03 89 Avenue Other - Lodging/Residential 39,000 601.2 165929.66 558.9 42.4 601.2 73.8 0.0 0.0   0.0 210.6
236132 236132 2021 2787550 Hillside Avenue Development, LLC QUEENS 160-11 89th Avenue Other - Lodging/Residential 58,625 430.9 79968.35 334.1 96.8 430.9 73.8 0.0 0.0   0.0 129.7
236133 236133 2021 6932877 West Canyon, LLC QUEENS 132-10 South Conduit Ave., Queens Other - Lodging/Residential 29,000 285.9 106117.21 188.2 97.8 285.9 73.8 0.0 0.0   0.0 167.9
238798 238798 2021 2961856 175-15 Rockaway Blvd. QUEENS 175-15 149 road Other - Lodging/Residential 74,477 517.7 75303.66 186.8 330.9 517.7 73.8 0.0 0.0   0.0 105.8
238799 238799 2021 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Other - Lodging/Residential 75,225 333.3 47834.77 194.1 139.2 333.3 73.8 0.0 0.0   0.0 73.1
239061 239061 2021 4409117 Beach 65, LLC QUEENS 316 BEACH 65th ST Other - Lodging/Residential 65,000 1006.8 166724.53 544.1 462.8 1006.8 73.8 0.0 0.0   0.0 254.1
240095 240095 2021 2787516 93 Jamaica Realty, LLC QUEENS 170-02 93rd Ave Other - Lodging/Residential 54,615 261.9 52204.91 176.3 85.6 261.9 73.8 0.0 0.0   0.0 82.0
240103 240103 2021 6675619 Westway Associates, LLC QUEENS 71-11 Astoria Boulevard N Other - Lodging/Residential 38,160 610.4 172902.23 484.4 126.0 610.4 73.8 0.0 0.0   0.0 215.8
240110 240110 2021 8720174 S and Z Associates, LLC QUEENS 87-02 23rd Avenue Other - Lodging/Residential 38,260 306.0 86677.72 196.8 109.3 306.0 73.8 0.0 0.0   0.0 135.5
240208 240208 2021 4988475 7900 Development, LLC QUEENS 7900 Queens Boulevard Other - Lodging/Residential 92,400 957.2 111991.36 674.5 282.7 957.2 73.8 0.0 0.0   0.0 139.8
187736 187736 2020 2787516 93 Jamaica Realty, LLC QUEENS 170-02 93rd Ave Other - Lodging/Residential 54615 262.8 51.79 169.6 93.2 262.8 79.5 0.0 0.0   0.0 80.0
187738 187738 2020 2787550 Hillside Avenue Development, LLC QUEENS 160-11 89th Avenue Other - Lodging/Residential 58625 516.8 94.89 398.8 118.0 516.8 79.5 0.0 0.0   0.0 153.4
189111 189111 2020 2961856 175-15 Rockaway Blvd. QUEENS 175-15 149 road Other - Lodging/Residential 74477 591.8 85.53 289.3 302.4 591.8 79.5 0.0 0.0   0.0 124.2
189866 189866 2020 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Other - Lodging/Residential 75225 361.6 51.74 210.4 151.2 361.6 79.5 0.0 0.0   0.0 77.9
192579 192579 2020 4409117 Beach 65, LLC QUEENS 316 BEACH 65th ST Other - Lodging/Residential 65000 765.3 126.73 517.0 248.4 765.3 79.5 0.0 0.0   0.0 197.8
194112 194112 2020 4988475 7900 Development, LLC QUEENS 7900 Queens Boulevard Other - Lodging/Residential 92400 1015.4 118.29 733.0 282.4 1015.4 79.5 0.0 0.0   0.0 145.4
201520 201520 2020 6675619 Westway Associates, LLC QUEENS 71-11 Astoria Boulevard N Other - Lodging/Residential 38160 0.0 0.0 0.0 121.8 0.0 79.5 0.0 0.0   0.0 0.0
205051 205051 2020 6932877 West Canyon, LLC QUEENS 132-10 South Conduit Ave., Queens Other - Lodging/Residential 29000 292.4 108.53 194.9 97.5 292.4 79.5 0.0 0.0   0.0 168.8
205900 205900 2020 8151625 163-03 89 Avenue QUEENS 163-03 89 Avenue Other - Lodging/Residential 39000 533.8 147.33 487.3 46.4 533.8 79.5 0.0 0.0   0.0 185.4
206228 206228 2020 8720174 S and Z Associates, LLC QUEENS 87-02 23rd Avenue Other - Lodging/Residential 38260 336.0 94.53 214.6 121.4 336.0 79.5 0.0 0.0   0.0 145.5

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