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

136 rows where Borough = "BROOKLYN" and Property Type = "Refrigerated Warehouse" 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

  • Refrigerated Warehouse · 136 ✖

Borough 1

  • BROOKLYN · 136 ✖
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)
309091 309091 2024 2784952 211 LOMBARDY ST LLC (Parent) BROOKLYN 211 LOMBARDY STREET Refrigerated Warehouse 79,551 424.24 57.37 159.87 264.37     0.0 0.0 828.93 0.0 66.7
311572 311572 2024 3523418 24 Rock Street BROOKLYN 24 Rock Street Refrigerated Warehouse 136,758 1420.51 111.84 197.44 1223.07     0.0 0.0 661.93 10.0 104.9
311604 311604 2024 3525911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 63,445 556.47 94.4 7.7 548.77     0.0 0.0 492.95 42.0 77.4
312716 312716 2024 4394748 H & C Food - 1300 Metropolitan Ave BROOKLYN 1300 Metropolitan ave Refrigerated Warehouse 120,000 362.88 32.51 109.33 253.55     0.0 0.0 721.82 82.0 35.5
315151 315151 2024 6118565 GPM 48th St LLC BROOKLYN 4802 2nd Ave Refrigerated Warehouse 40,250 0.0 0.0 0.0 0.0     0.0 0.0 299.25 0.0 0.0
318231 318231 2024 6600615 Steve Realty Corp - 200 Stewart ave BROOKLYN 200 Stewart ave Refrigerated Warehouse 31,750 138.88 47.04 20.9 117.97     0.0 0.0 132.12 47.0 44.7
323157 323157 2024 10865018 970 Meeker Avenue BROOKLYN 970 Meeker Avenue Refrigerated Warehouse 27,313 186.31 73.41 0.78 185.53     0.0 0.0 131.33 29.0 59.6
323164 323164 2024 10865641 333 Vandervoort Avenue BROOKLYN 333 Vandervoort Avenue Refrigerated Warehouse 30,350 52.67 18.73 8.11 44.56     0.0 0.0 185.45 94.0 17.8
324008 324008 2024 12882290 471 Sutter Avenue BROOKLYN 471 Sutter Avenue Refrigerated Warehouse 30,855 17.8 6.24 14.41 3.39     0.0 0.0 407.22 100.0 9.7
324981 324981 2024 15583500 650 Fountain Ave BROOKLYN 650 Fountain Ave Refrigerated Warehouse 89,914 1157.18 138.53 172.66 984.52     0.0 0.0 1100.36 47.0 131.3
325815 325815 2024 18105301 340 Johnson Avenue BROOKLYN 340 Johnson Avenue Refrigerated Warehouse 33,657 443.81 141.98 90.14 353.67     0.0 0.0 338.83 0.0 141.7
326987 326987 2024 21099495 NYC00601 - Brooklyn Logistics Center 3 (150 52 St) BROOKLYN 150 52 STREET Refrigerated Warehouse 126,999 855.75 72.55 37.49 818.26     0.0 0.0 532.35 21.0 61.5
329298 329298 2024 23261506 90 Varick Avenue BROOKLYN 90 Varick Avenue Refrigerated Warehouse 36,952 438.44 127.77 50.1 388.34     0.0 0.0 260.89 20.0 116.8
329412 329412 2024 23992442 Brooklyn Fire Proof Inc. : 505 JOHNSON AVENUE BROOKLYN 505 JOHNSON AVENUE Refrigerated Warehouse 61,322 81.4 14.32 41.95 39.45     0.0 0.0 657.34 0.0 18.5
330951 330951 2024 28449894 513 Irving Avenue BROOKLYN 513 Irving Avenue Refrigerated Warehouse 57,800 658.65 122.71 48.44 610.22     0.0 0.0 356.85 16.0 107.5
334189 334189 2024 45912500 20 Washington Ave BROOKLYN 20 Washington Ave Refrigerated Warehouse 20,219 0.0 0.0 0.0 0.0     0.0 0.0 150.32 0.0 0.0
334197 334197 2024 45982492 22 Washington Ave BROOKLYN 22 Washington Ave Refrigerated Warehouse 5,067 0.0 0.0 0.0 0.0     0.0 0.0 37.67 0.0 0.0
339426 339426 2024 57100392 JLL - 333 North Henry Street BROOKLYN 274 RUSSELL STREET Refrigerated Warehouse 55,500 547.01 106.13 23.98 523.03     0.0 0.0 335.26 22.0 90.0
340398 340398 2024 58968692 HSS - 55 Washington Ave BROOKLYN 55 Washington Avenue Refrigerated Warehouse 35,350 0.0 0.0 0.0 0.0     0.0 0.0 262.82 0.0 0.0
344990 344990 2024 66128693 211 LOMBARDY STREET (Child) BROOKLYN 211 LOMBARDY ST Refrigerated Warehouse 41,583 424.24 109.79 159.87 264.37     0.0 0.0 262.28 22.0 127.6
344991 344991 2024 66128992 245 LOMBARDY STREET (Child) BROOKLYN 211 LOMBARDY ST Refrigerated Warehouse 37,968 0.0 0.0 0.0 0.0     0.0 0.0 282.28 0.0 0.0
277780 277780 2023 10865018 970 Meeker Avenue BROOKLYN 970 Meeker Avenue Refrigerated Warehouse 27,313 177.0 69.97 0.8 176.3     0.0 0.0 122.4 28.0 59.9
277781 277781 2023 10865641 333 Vandervoort Avenue BROOKLYN 333 Vandervoort Avenue Refrigerated Warehouse 30,350 62.8 22.6 26.7 36.0     0.0 0.0 186.2 91.0 27.5
278415 278415 2023 12053341 149 47 St BROOKLYN 149 47 Street Refrigerated Warehouse 33,045 19.7 6.46 11.1 8.6     0.0 0.0 101.4 97.0 8.7
278788 278788 2023 12882290 471 Sutter Avenue BROOKLYN 471 Sutter Avenue Refrigerated Warehouse 30,855 28.8 9.69 16.1 12.7     0.0 0.0 371.9 100.0 13.6
283333 283333 2023 2784952 211 LOMBARDY ST LLC BROOKLYN 211 LOMBARDY ST Refrigerated Warehouse 80,000 395.3 52.74 169.3 226.0     0.0 0.0 494.3 62.0 65.8
286471 286471 2023 3523418 24 Rock Street BROOKLYN 24 Rock Street Refrigerated Warehouse 136,758 1381.5 108.72 216.3 1165.2     0.0 0.0 632.8 10.0 108.1
286472 286472 2023 3525911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 63,445 626.0 106.56 24.9 601.0     0.0 0.0 469.7 33.0 94.5
290846 290846 2023 15583500 650 Fountain Ave BROOKLYN 650 Fountain Ave Refrigerated Warehouse 89,914 1085.5 130.24 210.6 874.9     0.0 0.0 1052.1 48.0 133.6
292209 292209 2023 18105301 340 Johnson Avenue BROOKLYN 340 Johnson Avenue Refrigerated Warehouse 31,400 411.0 141.01 78.3 332.7     0.0 0.0 300.6 0.0 144.4
293294 293294 2023 21099495 nyc00601 - Brooklyn Logistics Center 3 BROOKLYN 150 52nd St Refrigerated Warehouse 126,133 777.1 66.74 66.3 710.8     0.0 0.0 509.9 23.0 61.7
295980 295980 2023 23261506 90 Varick Avenue BROOKLYN 90 Varick Avenue Refrigerated Warehouse 36,800 388.9 114.1 39.9 349.0     0.0 0.0 244.8 23.0 107.7
296031 296031 2023 23992442 Brooklyn Fire Proof Inc. : 505 JOHNSON AVENUE BROOKLYN 505 JOHNSON AVENUE Refrigerated Warehouse 61,322 82.0 13.99 47.7 34.4     0.0 0.0 648.6 0.0 19.8
297957 297957 2023 28449894 513 Irving Avenue BROOKLYN 513 Irving Avenue Refrigerated Warehouse 57,800 616.5 115.17 46.4 570.1     0.0 0.0 328.9 15.0 105.8
298251 298251 2023 27911414 28TH STREET ASSOCIATES BROOKLYN 178 28TH STREET Refrigerated Warehouse 25,000 98.7 41.98 12.8 85.8     0.0 0.0 144.9 70.0 41.2
298702 298702 2023 4394748 H & C Food - 1300 Metropolitan Ave BROOKLYN 1300 Metropolitan ave Refrigerated Warehouse 120,000 365.9 32.29 123.1 242.8     0.0 0.0 701.3 80.0 37.9
305286 305286 2023 6600615 Steve Realty Corp - 200 Stewart ave BROOKLYN 200 Stewart ave Refrigerated Warehouse 31,750 105.7 35.52 14.9 90.9     0.0 0.0 123.2 58.0 35.1
241833 241833 2022 18105301 340 Johnson Avenue BROOKLYN 340 Johnson Avenue Refrigerated Warehouse 31,400 355.3 121.63 92.3 263.1 355.3   0.0 0.0 249.5 0.0 154.4
241949 241949 2022 23261506 90 Varick Avenue BROOKLYN 90 Varick Avenue Refrigerated Warehouse 36,800 285.2 83.96 52.8 232.4 285.2   0.0 0.0 207.2 31.0 101.7
245443 245443 2022 23992442 Brooklyn Fire Proof Inc. : 505 JOHNSON AVENUE BROOKLYN 505 JOHNSON AVENUE Refrigerated Warehouse 61,322 86.6 15.07 53.7 32.8 86.6   0.0 0.0 581.7 0.0 22.8
246330 246330 2022 2784952 211 LOMBARDY ST LLC BROOKLYN 211 LOMBARDY ST Refrigerated Warehouse 80,000 396.6 53.82 206.0 190.6 396.6   0.0 0.0 440.2 55.0 76.7
253291 253291 2022 12053341 149 47 St BROOKLYN 149 47 Street Refrigerated Warehouse 33,045 0.0 0.0 27.5 0.0 0.0   0.0 0.0 185.5 0.0 0.0
255991 255991 2022 27911414 28TH STREET ASSOCIATES BROOKLYN 178 28TH STREET Refrigerated Warehouse 25,000 86.8 37.67 18.3 68.5 86.8   0.0 0.0 124.5 69.0 46.2
258040 258040 2022 4394748 H & C Food - 1300 Metropolitan Ave BROOKLYN 1300 Metropolitan ave Refrigerated Warehouse 120,000 345.7 31.22 140.2 205.6 345.7   0.0 0.0 604.4 77.0 42.3
258259 258259 2022 6600615 Steve Realty Corp - 200 Stewart ave BROOKLYN 200 Stewart ave Refrigerated Warehouse 31,750 114.0 38.75 31.7 82.3 114.0   0.0 0.0 108.2 46.0 49.5
258701 258701 2022 21099495 Prologis - nyc00601 - 150 52nd St BROOKLYN 150 52nd St Refrigerated Warehouse 126,133 419.5 35.52 71.4 348.0 419.5   0.0 0.0 449.6 54.0 43.3
261600 261600 2022 3523418 24 Rock Street BROOKLYN 24 Rock Street Refrigerated Warehouse 136,758 1362.4 107.64 354.9 1007.5 1362.4   0.0 0.0 539.1 6.0 136.0
261601 261601 2022 3525911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 63,445 577.3 97.95 33.5 543.8 577.3   0.0 0.0 373.1 24.0 111.3
265866 265866 2022 12882290 471 Sutter Avenue BROOKLYN 471 Sutter Avenue Refrigerated Warehouse 30,855 21.3 7.53 19.5 1.8 21.3   0.0 0.0 408.9 100.0 12.6
267087 267087 2022 10865018 970 Meeker Avenue BROOKLYN 970 Meeker Avenue Refrigerated Warehouse 27,313 29.5 11.84 1.2 28.3 29.5   0.0 0.0 102.3 94.0 13.1
267088 267088 2022 10865641 333 Vandervoort Avenue BROOKLYN 333 Vandervoort Avenue Refrigerated Warehouse 30,350 63.7 22.6 27.7 36.0 63.7   0.0 0.0 146.3 86.0 31.2
224142 224142 2021 10865018 970 Meeker Avenue BROOKLYN 970 Meeker Avenue Refrigerated Warehouse 27,313 26.7 10644.3 0.8 25.9 26.7 73.8 0.0 0.0   93.0 13.4
226265 226265 2021 21099495 Prologis - 150 52nd St BROOKLYN 150 52nd St Refrigerated Warehouse 126,133 125.9 10755.36 0.0 125.9 125.9 73.8 0.0 0.0   93.0 13.5
227403 227403 2021 4394748 H & C 1300 Metropolitan Ave BROOKLYN 1300 Metropolitan ave Refrigerated Warehouse 120,000 311.5 27941.29 130.9 180.6 311.5 73.8 0.0 0.0   78.0 40.9
227586 227586 2021 6600615 Steve Realty Corp - 200 Stewart ave BROOKLYN 200 Stewart ave Refrigerated Warehouse 31,750 129.6 45000.05 57.0 72.6 129.6 73.8 0.0 0.0   41.0 57.5
229006 229006 2021 12882290 471 Sutter Avenue BROOKLYN 471 Sutter Avenue Refrigerated Warehouse 30,855 16.7 5991.9 15.0 1.6 16.7 73.8 0.0 0.0   100.0 9.9
233782 233782 2021 12053341 149 47 St BROOKLYN 149 47 Street Refrigerated Warehouse 33,045 28.2 9198.24 25.7 2.6 28.2 73.8 0.0 0.0   96.0 15.7
239080 239080 2021 3523418 24 Rock Street BROOKLYN 24 Rock Street Refrigerated Warehouse 160,000 1248.6 83998.78 369.2 879.4 1248.6 73.8 0.0 0.0   9.0 117.9
239081 239081 2021 3525911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 63,445 509.9 87119.25 34.9 475.1 509.9 73.8 0.0 0.0   24.0 111.8
240228 240228 2021 18105301 340 Johnson Avenue BROOKLYN 340 Johnson Avenue Refrigerated Warehouse 31,400 311.1 108020.94 104.0 207.0 311.1 73.8 0.0 0.0   0.0 151.7
241646 241646 2021 10865641 333 Vandervoort Avenue BROOKLYN 333 Vandervoort Avenue Refrigerated Warehouse 30,350 51.7 18549.79 22.7 28.9 51.7 73.8 0.0 0.0   88.0 27.0
187693 187693 2020 2784952 211 LOMBARDY ST LLC BROOKLYN 211 LOMBARDY ST Refrigerated Warehouse 80000 295.7 39.79 118.7 177.0 295.7 79.5 0.0 0.0   66.0 55.8
190544 190544 2020 3523418 24 Rock Street BROOKLYN 24 Rock Street Refrigerated Warehouse 160000 1323.4 89.03 355.1 968.4 1323.4 79.5 0.0 0.0   9.0 117.9
190581 190581 2020 3525911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 63445 546.3 92.68 30.5 515.9 546.3 79.5 0.0 0.0   23.0 111.4
192066 192066 2020 4394748 H & C 1300 Metropolitan Ave BROOKLYN 1300 Metropolitan ave Refrigerated Warehouse 120000 321.5 28.84 138.5 183.0 321.5 79.5 0.0 0.0   79.0 40.9
193404 193404 2020 4865941 MBD Brooklyn BROOKLYN 2 Atlantic Ave Refrigerated Warehouse 721396 2059.6 30.73 1730.5 329.2 2059.6 79.5 0.0 0.0   86.0 50.9
199370 199370 2020 6375325 398 Morgan Ave BROOKLYN 398 Morgan Ave Refrigerated Warehouse 25000 116.2 50.03 0.0 116.2 116.2 79.5 0.0 0.0   44.0 58.5
200494 200494 2020 6600615 Steve Realty Corp - 200 Stewart ave BROOKLYN 200 Stewart ave Refrigerated Warehouse 31750 94.0 31.87 19.7 74.3 94.0 79.5 0.0 0.0   53.0 38.7
207783 207783 2020 10865018 970 Meeker Avenue BROOKLYN 970 Meeker Avenue Refrigerated Warehouse 27313 33.5 13.2 0.8 32.7 33.5 79.5 0.0 0.0   90.0 15.6
207792 207792 2020 10865641 333 Vandervoort Avenue BROOKLYN 333 Vandervoort Avenue Refrigerated Warehouse 30350 52.6 18.66 26.0 26.6 52.6 79.5 0.0 0.0   89.0 27.2
208181 208181 2020 11613016 305 Johnson Ave Realty LLC BROOKLYN 305 Johnson Ave Refrigerated Warehouse 25000 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
208626 208626 2020 12053341 149 47 St BROOKLYN 149 47 Street Refrigerated Warehouse 33045 32.8 10.68 32.8 0.0 32.8 79.5 0.0 0.0   94.0 18.7
209324 209324 2020 12882290 471 Sutter Avenue BROOKLYN 471 Sutter Avenue Refrigerated Warehouse 30855 18.9 6.59 16.8 2.1 18.9 79.5 0.0 0.0   100.0 11.1
162333 162333 2019 3523418 24 Rock Street BROOKLYN 24 Rock Street Refrigerated Warehouse 160,000 1321.8 88923.27 307.5 1014.3 1321.8 84.7 0.0 0.0   25.0 111.0
162371 162371 2019 3525911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 63,445 607.7 103828.92 35.8 571.9 607.7 84.7 0.0 0.0   14.0 117.0
163974 163974 2019 4394748 H & C 1300 Metropolitan Ave BROOKLYN 1300 Metropolitan ave Refrigerated Warehouse 120,000 931.6 83563.74 726.6 204.9 931.6 84.7 0.0 0.0   36.0 134.2
165164 165164 2019 4574542 brothers real estate BROOKLYN 1201 Flushing Avenue Refrigerated Warehouse 51,956 221.8 46812.41 6.1 215.6 221.8 84.7 0.0 0.0   48.0 51.2
165465 165465 2019 4865941 MBD Brooklyn BROOKLYN 2 Atlantic Ave Refrigerated Warehouse 721,396 1828.6 27299.4 1680.0 148.5 1828.6 84.7 0.0 0.0   90.0 46.3
173280 173280 2019 6600615 Steve Realty Corp - 200 Stewart ave BROOKLYN 200 Stewart ave Refrigerated Warehouse 31,750 109.2 37916.71 20.5 88.7 109.2 84.7 0.0 0.0   49.0 42.7
181839 181839 2019 10865018 970 Meeker Avenue BROOKLYN 970 Meeker Avenue Refrigerated Warehouse 27,313 38.1 15189.06 1.8 36.3 38.1 84.7 0.0 0.0   90.0 16.9
181848 181848 2019 10865641 333 Vandervoort Avenue BROOKLYN 333 Vandervoort Avenue Refrigerated Warehouse 30,350 72.7 26084.52 35.2 37.5 72.7 84.7 0.0 0.0   83.0 36.5
182860 182860 2019 12053341 149 47 St BROOKLYN 149 47 Street Refrigerated Warehouse 33,045 37.2 12133.85 37.2 0.0 37.2 84.7 0.0 0.0   93.0 21.2
183577 183577 2019 12882290 471 Sutter Avenue BROOKLYN 471 Sutter Avenue Refrigerated Warehouse 30,855 33.6 12055.57 31.5 2.1 33.6 79.5 0.0 0.0   100.0 20.1
135542 135542 2018 2974996 Wing Hon Holding, Inc. BROOKLYN 1101 Metropolitan Avenue Refrigerated Warehouse 70,000 490.6 75439.56 128.2 362.4 490.6 84.7 0.0 0.0   30.0 95.6
135543 135543 2018 2974996 Wing Hon Holding, Inc. BROOKLYN 1101 Metropolitan Avenue Refrigerated Warehouse 70,000 490.6 75439.56 128.2 362.4 490.6 84.7 0.0 0.0   30.0 95.6
137122 137122 2018 3525911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 60,000 650.2 116644.8 36.1 614.0 650.2 84.7 0.0 0.0   10.0 132.2
138855 138855 2018 4394748 H & C 1300 Metropolitan Ave BROOKLYN 1300 Metropolitan ave Refrigerated Warehouse 120,000 206.6 18531.85 8.7 197.9 206.6 84.7 0.0 0.0   88.0 20.8
140060 140060 2018 4574542 brothers real estate BROOKLYN 1201 Flushing Avenue Refrigerated Warehouse 51,956 219.5 46326.98 5.9 213.5 219.5 84.7 0.0 0.0   49.0 50.7
140368 140368 2018 4865941 MBD Brooklyn BROOKLYN 2 Atlantic Ave Refrigerated Warehouse 721,396 2011.7 30032.92 1880.0 131.7 2011.7 84.7 0.0 0.0   88.0 51.2
140522 140522 2018 4907099 24 Rock Street BROOKLYN 24 Rock Street Refrigerated Warehouse 122,000 1253.5 110594.66 350.6 902.9 1253.5 84.7 0.0 0.0   12.0 141.5
147217 147217 2018 6375325 398 Morgan Ave BROOKLYN 398 Morgan Ave Refrigerated Warehouse 25,000 140.6 60536.17 0.0 140.6 140.6 84.7 0.0 0.0   36.0 66.4
148491 148491 2018 6600615 Steve Realty Corp - 200 Stewart ave BROOKLYN 200 Stewart ave Refrigerated Warehouse 31,750 96.1 33368.09 7.9 88.1 96.1 84.7 0.0 0.0   52.0 37.5
151289 151289 2018 6704379 April Holdings LLC. BROOKLYN 269 Randolph Street Refrigerated Warehouse 29,000 106.5 39529.49 76.9 29.6 106.5 84.7 0.0 0.0   45.0 62.0
94826 94826 2017 4,865,941 MBD Brooklyn BROOKLYN 2 Atlantic Ave Refrigerated Warehouse 721,396 2.0 29.86 1.0 195.4 2.0 88.7   0.0   97.0 53.1
95041 95041 2017 4,574,542 brothers real estate BROOKLYN 1201 Flushing Avenue Refrigerated Warehouse 51,956 234.4 49471.73 9.1 225.2 234.4 88.7   0.0   63.0 52.2
98149 98149 2017 2,974,996 Wing Hon Holding, Inc. BROOKLYN 1101 Metropolitan Avenue Refrigerated Warehouse 70,000 586.9 90247.61 161.1 425.8 586.9 88.7   0.0   35.0 111.9
98988 98988 2017 3,525,911 25 Rock Street BROOKLYN 25 Rock Street Refrigerated Warehouse 60,000 723.9 129866.45 31.0 692.8 723.9 88.7   0.0   13.0 140.0
104545 104545 2017 2,974,996 Wing Hon Holding, Inc. BROOKLYN 1101 Metropolitan Avenue Refrigerated Warehouse 70,000 586.9 90247.61 161.1 425.8 586.9 88.7   0.0   35.0 111.9
109700 109700 2017 6,375,325 398 Morgan Ave BROOKLYN 398 Morgan Ave Refrigerated Warehouse 25,000 137.5 59201.45 0.0 137.5 137.5 88.7   0.0   52.0 62.1
109902 109902 2017 6,375,325 398 Morgan Ave BROOKLYN 398 Morgan Ave Refrigerated Warehouse 25,000 137.5 59201.45 0.0 137.5 137.5 88.7   0.0   52.0 62.1

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