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

309 rows where Calendar Year = 2022 and Property Type = "Retail Store" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Avoided GHG Offsite (MtCO2e)

Borough 5

Property Type 1

  • Retail Store · 309 ✖

Calendar Year 1

  • 2022 · 309 ✖
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)
241785 241785 2022 16852095 218-01 Merrick Blvd QUEENS 218-01 Merrick Blvd Retail Store 35,900 166.3 49.51 94.9 71.4 166.3   0.0 0.0 157.9 45.0 73.3
241830 241830 2022 18057555 1001-1011 Brighton Beach Avenue BROOKLYN 1001-1011 Brighton Beach Avenue Retail Store 46,017 367.2 86.11 95.8 271.4 367.2   0.0 0.0 186.4 0.0 109.0
241920 241920 2022 21694896 Morton Barrow Condo - 456 Hudson St MANHATTAN 456 Hudson St Retail Store 14,130 72.7 54.9 24.2 48.5 72.7   0.0 0.0 59.1 0.0 72.8
241943 241943 2022 22839001 1329 Willoughby Avenue BROOKLYN 1329 Willoughby Avenue Retail Store 37,585 125.3 35.52 55.3 70.0 125.3   0.0 0.0 165.7 0.0 49.7
242406 242406 2022 7534450 110 East 138th Street BRONX 110 East 138 Street Retail Store 30,284 0.0 0.0 0.0 0.0 0.0   0.0 0.0 115.4 0.0 0.0
242580 242580 2022 2749777 Maverick: 600 - 614 West 181st St MANHATTAN 600-614 W 181 St Retail Store 56,897 412.1 77.5 64.0 348.1 412.1   0.0 0.0 294.9 19.0 93.5
242700 242700 2022 2829947 Majestic Rayon: 116 West 23rd Street MANHATTAN 116 West 23rd Street Retail Store 180,000 837.6 50.59 50.4 787.2 837.6   0.0 0.0 885.1 54.0 57.0
242735 242735 2022 2967532 Werber: 91-30 Van Wyck Expressway QUEENS 91-30 Van Wyck Expressway Retail Store 53,555 187.9 37.67 64.8 123.1 187.9   0.0 0.0 225.5 0.0 50.0
242756 242756 2022 2974917 Parkwill: 72-25 Woodhaven Blvd QUEENS 72-25 Woodhaven Blvd Retail Store 57,245 120.6 22.6 43.1 77.5 120.6   0.0 0.0 329.6 99.0 30.2
242779 242779 2022 3075252 Mehran: 37-02 Main Street QUEENS 37-02 Main Street Retail Store 81,668 410.8 53.82 200.5 210.2 410.8   0.0 0.0 425.3 53.0 76.7
243372 243372 2022 5866115 Blumenfeld: 72-12 25th Ave QUEENS 72-12 25th Ave Retail Store 113,000 398.0 37.67 18.9 379.1 398.0   0.0 0.0 417.6 0.0 42.8
243373 243373 2022 5866120 Blumenfeld: 115 Bricktown Way STATEN IS 115 Bricktown Way Retail Store 110,000 315.8 31.22 109.8 206.1 315.8   0.0 0.0 463.7 0.0 40.9
243374 243374 2022 5866122 Blumenfeld: 55 Tyrellan Ave STATEN IS 55 Tyrellan Ave Retail Store 160,292 160.3 10.76 157.5 2.8 160.3   0.0 0.0 962.1 0.0 18.7
243375 243375 2022 5866126 Blumenfeld: 60 Tyrellan Ave STATEN IS 60 Tyrellan Ave Retail Store 154,893 616.0 43.06 214.8 401.2 616.0   0.0 0.0 653.2 0.0 56.7
243376 243376 2022 5866129 Blumenfeld 517 East 117th St MANHATTAN 517 East 117th Street Retail Store 510,265 4324.8 91.49 594.3 3730.6 4324.8   0.0 0.0 1958.0 0.0 108.4
243379 243379 2022 5866148 Blumenfeld: 245 Bricktown Way STATEN IS 245 Bricktown Way Retail Store 60,241 252.8 45.21 35.5 217.3 252.8   0.0 0.0 231.4 0.0 53.8
243588 243588 2022 6282540 Chatam: 1176 Webster Avenue BRONX 1176 Webster Avenue Retail Store 32,250 80.7 26.91 13.3 67.5 80.7   0.0 0.0 125.2 0.0 32.5
243713 243713 2022 6282697 Jem: 961 Southern Blvd BRONX 961 Southern Blvd Retail Store 35,507 194.6 59.2 71.3 123.3 194.6   0.0 0.0 151.0 0.0 78.9
243754 243754 2022 6282748 Louis Lefkowitz Realty: 37-15 82nd St QUEENS 37-15 82nd Street Retail Store 45,494 276.3 65.66 16.1 260.2 276.3   0.0 0.0 168.9 0.0 74.3
243767 243767 2022 6282766 Maverick: 222-226 E Fordham Rd BRONX 222-226 E Fordham Rd Retail Store 40,375 303.3 80.73 58.0 245.3 303.3   0.0 0.0 193.2 11.0 98.9
243768 243768 2022 6282767 Maverick: 493 Fulton St BROOKLYN 493 Fulton St Retail Store 30,056 81.4 29.06 39.4 41.9 81.4   0.0 0.0 165.0 94.0 41.2
243776 243776 2022 6282776 Mehran: 37-11 Main St QUEENS 37-11 Main St Retail Store 48,160 349.6 78.58 5.4 344.2 349.6   0.0 0.0 214.0 9.0 86.6
244023 244023 2022 6405400 Blumenfeld: 925 Hunts Point Ave BRONX 925 Hunts Point Ave Retail Store 45,224 503.8 119.48 139.8 364.1 503.8   0.0 0.0 184.6 0.0 153.4
244058 244058 2022 6600302 2465 BROADWAY ASSOCIA: 2465 Broadway MANHATTAN 2465 Broadway Retail Store 32,524 390.2 129.17 184.8 205.4 390.2   0.0 0.0 145.7 0.0 181.7
244132 244132 2022 6664908 Adorama Camera: 42 West 18th St MANHATTAN 42 West 18th Street Retail Store 29,532 217.6 79.65 63.5 154.1 217.6   0.0 0.0 157.5 20.0 90.7
244137 244137 2022 6664914 Crown NY: 453 Broome MANHATTAN 453 Broome Street Retail Store 34,886 236.6 73.19 12.0 224.6 236.6   0.0 0.0 129.1 0.0 82.6
244160 244160 2022 6664939 Sopher: 564 West 125th St MANHATTAN 564 West 125th Street Retail Store 28,223 280.7 106.56 31.8 248.9 280.7   0.0 0.0 107.2 0.0 125.5
244304 244304 2022 6778571 ACHS Management: 1007-1011 Flatbush BROOKLYN 1007 - 1011 Flatbush Ave Retail Store 141,599 765.0 58.13 2.6 762.4 765.0   0.0 0.0 513.9 0.0 64.0
244308 244308 2022 6778579 ACHS Management: 1030 Southern BRONX 1030 Southern Boulevard Retail Store 32,100 166.8 55.97 34.4 132.4 166.8   0.0 0.0 126.9 0.0 69.0
244343 244343 2022 6790095 Mehran: 133-28 37th QUEENS 135-28 37th Avenue Retail Store 27,264 154.0 60.28 75.2 78.8 154.0   0.0 0.0 149.9 47.0 86.1
244486 244486 2022 6881850 Samaritan: 88-83 Van Wyck Exp. QUEENS 88-83 Van Wyck Expressway Retail Store 40,660 302.5 79.65 124.2 178.3 302.5   0.0 0.0 213.5 18.0 109.4
244518 244518 2022 7069124 Ashkenazy: 601 8th Ave. MANHATTAN 601 8th Avenue Retail Store 30,763 305.3 106.56 117.3 188.0 305.3   0.0 0.0 160.8 4.0 144.1
244570 244570 2022 7095172 Somerstein: 1245 Broadway BROOKLYN 1245 BROADWAY Retail Store 36,412 257.8 76.42 78.6 179.2 257.8   0.0 0.0 567.7 96.0 98.8
244714 244714 2022 9636120 Triangle: 2510 Valentine Ave. BRONX 2510 Valentine Ave Retail Store 43,503 23.3 5.38 7.5 15.8 23.3   0.0 0.0 181.2 0.0 7.5
244719 244719 2022 9648795 Triangle: 1726 McDonald Ave. BROOKLYN 1726 McDonald Ave Retail Store 36,000 154.3 46.28 0.0 154.3 154.3   0.0 0.0 158.4 52.0 50.7
244886 244886 2022 10856355 CCM: 97 N 10th St.   97 North 10th Avenue Retail Store 33,120 192.6 62.43 49.9 142.8 192.6   0.0 0.0 134.0 0.0 79.3
244887 244887 2022 10856356 Douglaston: 82-01 37th Ave. QUEENS 82-01 37th Avenue Retail Store 64,392 195.6 32.29 0.0 195.6 195.6   0.0 0.0 233.4 0.0 35.9
244913 244913 2022 11530290 ACHS: 168-42 Jamaica Ave.   168 Jamaica Avenue Retail Store 36,954 249.5 73.19 60.2 189.4 249.5   0.0 0.0 180.1 19.0 91.3
244914 244914 2022 11530291 ACHS: 2162 Nostrand Ave BROOKLYN 2162 Nostrand Ave Retail Store 27,495 257.9 101.18 57.8 200.2 257.9   0.0 0.0 109.5 0.0 125.7
244919 244919 2022 11621492 Cornerstone: 32 Greene St MANHATTAN 32 Greene St Retail Store 30,396 102.2 36.6 47.6 54.6 102.2   0.0 0.0 135.6 0.0 50.7
244927 244927 2022 11665519 ASG: 438 87th St. BROOKLYN 438 87th St Retail Store 35,000 365.7 111.94 80.1 285.5 365.7   0.0 0.0 139.2 0.0 139.6
244956 244956 2022 11986538 Weinstein: 33-09 College Point Blvd QUEENS 33-09 College Point Blvd Retail Store 39,045 64.7 18.3 20.6 44.0 64.7   0.0 0.0 162.4 0.0 23.3
244977 244977 2022 12711956 Common: 231 Roebling St BROOKLYN 231 Roebling St Retail Store 28,481 91.3 34.44 0.0 91.3 91.3   0.0 0.0 103.2 0.0 37.9
245025 245025 2022 14910015 154 Northern Property LLC: 154-19 Northern blvd QUEENS 154-19 Northern Blvd Retail Store 30,418 18.0 6.46 0.0 18.0 18.0   0.0 0.0 133.9 100.0 7.0
245199 245199 2022 16754519 ACHS: 301 W 125th St MANHATTAN 301-303 West 125th Street Retail Store 96,000 436.3 48.44 27.8 408.4 436.3   0.0 0.0 461.5 55.0 55.8
245254 245254 2022 17981908 Midwood: 55 Lombardy BROOKLYN 55 LOMBARDY STREET Retail Store 48,080 271.4 60.28 0.0 271.4 271.4   0.0 0.0 212.4 26.0 66.8
245410 245410 2022 21971100 ACHS Management : 5132 KINGS HIGHWAY BROOKLYN 5132 KINGS HIGHWAY Retail Store 96,734 537.6 60.28 100.4 437.2 537.6   0.0 0.0 463.1 35.0 73.0
245411 245411 2022 21971101 ACHS Management : 2230 CHURCH AVENUE BROOKLYN 2230 CHURCH AVENUE Retail Store 28,462 148.3 55.97 43.4 105.0 148.3   0.0 0.0 142.5 46.0 72.3
245412 245412 2022 21971102 ACHS Management : 515 86 Street BROOKLYN 515 86 Street Retail Store 35,247 49.7 15.07 0.0 49.7 49.7   0.0 0.0 156.5 100.0 16.7
245458 245458 2022 25464591 ASG Equities LLC : 25 Church Street MANHATTAN 25 Church Street Retail Store 33,000 268.2 87.19 0.0 268.2 268.2   0.0 0.0 210.8 26.0 108.1
245486 245486 2022 26634251 Andrews Building Corp : 142 Duane Street MANHATTAN 142 Duane Street Retail Store 31,030 90.5 31.22 26.5 64.0 90.5   0.0 0.0 155.4 89.0 40.5
245657 245657 2022 12065676 740 Madison Ave MANHATTAN 740 Madison Avenue Retail Store 37,428 227.5 65.66 0.0 227.5 227.5   0.0 0.0 148.5 13.0 71.9
245760 245760 2022 2694218 Mutual Redevelopment -Commercial Building #1 MANHATTAN 230 9th Ave Retail Store 9,835 71.4 78.58 71.4 0.0 71.4   0.0 0.0 72.8 51.0 136.6
245776 245776 2022 25514498 BestBuy 8923 Bay Pkwy (3345607) BROOKLYN 8923 BAY PARKWAY Retail Store 38,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 144.8 0.0 0.0
246333 246333 2022 6812093 TOWER HILL CORP MANHATTAN 2231 3 AVENUE Retail Store 28,500 87.8 33.37 32.6 55.2 87.8   0.0 0.0 107.1 68.0 44.5
246633 246633 2022 6699313 William Gottlieb Management MANHATTAN 9 9th Avenue Retail Store 58,659 422.7 77.5 0.3 422.5 422.7   0.0 0.0 326.4 25.0 85.3
246651 246651 2022 6605030 76-01 37th Ave. Realty Corp. QUEENS 76-01 37th Ave. Retail Store 27,520 73.4 29.06 0.0 73.4 73.4   0.0 0.0 74.2 0.0 31.5
246699 246699 2022 6698367 Advance Realty MANHATTAN 235 West 23rd Street Retail Store 49,183 168.0 36.6 52.8 115.1 168.0   0.0 0.0 248.8 82.0 47.9
247193 247193 2022 25416371 103 Prince St MANHATTAN 103 Prince St Retail Store 28,434 236.7 89.34 3.8 232.9 236.7   0.0 0.0 152.8 12.0 99.4
247194 247194 2022 1160595 STATEN ISLAND, NY-2463 STATEN IS 140 MARSH AVE Retail Store 179,200 577.0 34.44 63.3 513.7 577.0   0.0 0.0 843.8 81.0 40.6
247195 247195 2022 1160893 BRONX, NY-2718 BRONX 100 BAYCHESTER AVE Retail Store 166,320 603.6 38.75 90.7 512.9 603.6   0.0 0.0 967.7 86.0 46.7
247196 247196 2022 1160897 ELMHURST, NY-2814 QUEENS 92-59 59TH AVE Retail Store 204,340 744.8 38.75 76.9 668.0 744.8   0.0 0.0 1130.7 83.0 45.7
247197 247197 2022 4137142 Brooklyn, NY- 0197 BROOKLYN 360 Gateway Drive Retail Store 123,942 215.4 18.3 19.6 195.9 215.4   0.0 0.0 579.3 99.0 21.7
247210 247210 2022 4409936 61-45 188 Street   61 188 Street Retail Store 136,500 493.6 38.75 69.7 423.9 493.6   0.0 0.0 524.6 0.0 46.3
247216 247216 2022 10550349 Bruckner Commons (Dream Closeouts) BRONX 1948 Bruckner Boulevard Retail Store 44,000 152.9 37.67 125.9 27.0 152.9   0.0 0.0 289.7 93.0 61.1
247221 247221 2022 14946439 Kingswood Crossing RKI2 BROOKLYN 1712 East 14th Street Retail Store 114,433 573.2 53.82 21.4 551.7 573.2   0.0 0.0 609.4 55.0 60.6
247230 247230 2022 6272320 Forest Ave Plaza 113430 STATEN IS 1520 Forest Avenue Retail Store 46,063 347.3 80.73 117.0 230.3 347.3   0.0 0.0 227.7 12.0 107.0
247237 247237 2022 20399995 2424 Hylan Boulevard-Kimco #117710 STATEN IS 2424 Hylan Boulevard Retail Store 57,835 121.2 22.6 0.3 120.9 121.2   0.0 0.0 209.8 0.0 24.8
247238 247238 2022 23359094 Party City STATEN IS 1549 Forest Ave Retail Store 19,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 72.4 0.0 0.0
247240 247240 2022 23359114 Mattress Firm STATEN IS 1539 Forest Avenue Retail Store 7,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 26.7 0.0 0.0
247242 247242 2022 23359166 TJ Maxx STATEN IS 1509 Forest Avenue Retail Store 45,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 171.5 0.0 0.0
247244 247244 2022 23359232 T-Mobile STATEN IS 34 Barrett Ave Retail Store 5,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 19.1 0.0 0.0
247245 247245 2022 23359283 Michaels STATEN IS 30 Barrett Ave Retail Store 22,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 83.8 0.0 0.0
247338 247338 2022 3448572 623 5th Avenue MANHATTAN 623 5th Avenue Retail Store 1,042,944 5321.9 54.9 114.2 5207.7 5321.9   0.0 0.0 6295.4 63.0 64.8
247483 247483 2022 6261083 1 East Fordham Road BRONX 1 East Fordham Road Retail Store 35,082 158.3 48.44 28.2 130.0 158.3   0.0 0.0 137.0 0.0 59.0
247552 247552 2022 6349034 136-31 Roosevelt Avenue QUEENS 136-31 Roosevelt Avenue Retail Store 28,550 456.8 172.22 226.6 230.2 456.8   0.0 0.0 162.9 1.0 244.8
247573 247573 2022 6547563 1402 Sheepshead Bay Road BROOKLYN 1400 SHEEPSHEAD BAY RD Retail Store 29,460 168.4 61.35 41.8 126.6 168.4   0.0 0.0 176.0 53.0 77.6
247574 247574 2022 6547565 220-5 Hillside Avenue QUEENS 220-5 Hillside Avenue Retail Store 36,215 45.6 13.99 18.2 27.4 45.6   0.0 0.0 189.5 100.0 18.4
247615 247615 2022 6798010 1601 Kings Highway BROOKLYN 1601 KINGS HGWY Retail Store 85,606 298.1 37.67 26.8 271.3 298.1   0.0 0.0 377.2 69.0 43.4
247618 247618 2022 6810889 V.I.M. - 2265 East Tremont Avenue BRONX 2265 East Tremont Avenue Retail Store 30,000 58.4 20.45 9.5 48.9 58.4   0.0 0.0 141.8 98.0 25.3
247631 247631 2022 7536616 464 Rockaway Avenue BROOKLYN 464 ROCKAWAY AVE Retail Store 27,300 59.9 23.68 12.1 47.7 59.9   0.0 0.0 137.3 97.0 29.1
247633 247633 2022 7914122 98 North 6th Street BROOKLYN 96 NORTH 6 ST Retail Store 35,741 235.7 71.04 37.5 198.2 235.7   0.0 0.0 178.7 23.0 85.4
247640 247640 2022 8792669 164-01 Jamaica Avenue QUEENS 16401 JAMAICA AVE Retail Store 42,600 156.4 39.83 39.9 116.5 156.4   0.0 0.0 181.0 63.0 50.0
247710 247710 2022 15097812 Bellerose Jamaica LLC 251-21 Jamaica Avenue QUEENS 251-21 Jamaica Avenue Retail Store 36,667 191.3 55.97 32.7 158.6 191.3   0.0 0.0 211.9 59.0 68.0
247883 247883 2022 8016082 1832 REALTY LLC BROOKLYN 1832 86 STREET Retail Store 26,743 224.3 90.42 80.0 144.3 224.3   0.0 0.0 225.8 50.0 120.2
247884 247884 2022 10714240 MARSHALLS OF MA INC BROOKLYN 1611 AVENUE Y Retail Store 26,431 140.2 57.05 7.9 132.4 140.2   0.0 0.0 155.1 59.0 64.8
248635 248635 2022 6182209 Staples QUEENS 24-41 31st St Retail Store 26,700 115.0 46.28 20.7 94.3 115.0   0.0 0.0 112.8 48.0 56.4
248687 248687 2022 12914173 Seward Park Housing (Bldg Retail Only) MANHATTAN 357 GRAND STREET Retail Store 18,000 282.0 168.99 173.2 108.8 282.0   0.0 0.0 105.7 1.0 252.6
248769 248769 2022 2799416 Wooster Condominiums MANHATTAN 111 Wooster Street Retail Store 55,459 285.4 54.9 160.7 124.7 285.4   0.0 0.0 295.0 0.0 67.6
248983 248983 2022 26661886 135 Kent Ave BROOKLYN 135 Kent Avenue Retail Store 25,000 79.3 34.44 0.0 79.3 79.3   0.0 0.0 90.6 0.0 37.5
249035 249035 2022 4315073 BR - 8470 - ROCKEFELLER CENTER MANHATTAN 626 5TH AVE Retail Store 47,652 134.9 30.14 0.0 134.9 134.9   0.0 0.0 152.3 61.0 33.5
249036 249036 2022 4349693 ON - 5137 - HARLEM USA MANHATTAN 300 W 125TH ST Retail Store 33,824 182.4 58.13 0.0 182.4 182.4   0.0 0.0 179.8 48.0 63.8
249037 249037 2022 4349694 ON - 5138 - JAMAICA CENTER QUEENS 159-18 JAMAICA AVENUE Retail Store 29,173 269.6 99.03 0.0 269.6 269.6   0.0 0.0 145.6 5.0 109.3
249038 249038 2022 4349865 ON - 5589 - 18TH & 6TH - NY   610 AVENUE OF THE AMERICAS Retail Store 53,030 395.6 80.73 15.9 379.7 395.6   0.0 0.0 303.2 24.0 90.3
249039 249039 2022 4350022 ON - 5927 - 144-150 W 34TH ST   150 W 34TH ST Retail Store 77,760 585.0 80.73 14.1 570.9 585.0   0.0 0.0 464.4 27.0 90.3
249040 249040 2022 4350273 ON - 6548 - GATEWAY-NY   381 Gateway Dr Retail Store 38,327 123.5 34.44 9.2 114.3 123.5   0.0 0.0 198.1 86.0 39.8
249041 249041 2022 10890626 3444 - TIMES SQUARE and 4132 - TIMES SQUARE MANHATTAN 1514 BROADWAY Retail Store 119,000 635.4 57.05 5.5 630.0 635.4   0.0 0.0 443.0 17.0 63.5
249042 249042 2022 10890630 90084 - 55 THOMAS - NYC CORP MANHATTAN 55 Thomas Street Retail Store 297,678 747.5 26.91 55.1 692.4 747.5   0.0 0.0 1161.8 85.0 31.0
249107 249107 2022 6696625 177 Dyckman Street MANHATTAN 177 Dyckman Street Retail Store 25,520 150.1 63.51 15.5 134.7 150.1   0.0 0.0 96.5 0.0 73.8
249143 249143 2022 23242619 Microsoft MEC MANHATTAN 677 5th Avenue Retail Store 31,250 534.3 184.06 0.0 534.3 534.3   0.0 0.0 137.0 1.0 204.2

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