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

3,197 rows where Borough = "BROOKLYN" and Calendar Year = 2015 sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Avoided GHG Offsite (MtCO2e)

Calendar Year 1

  • 2015 · 3,197 ✖

Borough 1

  • BROOKLYN · 3,197 ✖
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)
62316 62316 2015 2716774 Linden Boulevard Multiplex BROOKLYN 2784 Linden Boulevard Other - Entertainment/Public Assembly 69126 664.5 103.47 86.9 577.7 664.5 82.9 0.0 0.0   0.0 124.4
62322 62322 2015 2920468 Union Temple BROOKLYN 17 Eastern Parkway Worship Facility 73144 581.2 85.53 512.1 69.1 581.2 82.9 0.0 0.0   0.0 104.4
62352 62352 2015 2660415 881 WASHINGTON AVENUE BROOKLYN 881 WASHINGTON AVENUE Multifamily Housing 80700 341.8 45.59 323.1 18.7 341.8 82.9 0.0 0.0   0.0 73.1
62354 62354 2015 2714266 98 DeKalb Ave BROOKLYN 98 DeKalb Ave Parking 61650 48.2 8.42 5.9 42.3 48.2 82.9 0.0 0.0   0.0 377.0
62356 62356 2015 4440264 Brooklyn Friends School BROOKLYN 375 Pearl Street K-12 School 110000 521.2 51.0 280.1 241.2 521.2 82.9 0.0 0.0   91.0 74.4
62357 62357 2015 2977472 5461 KINGS HIGHWAY BROOKLYN 5461 kings highway Multifamily Housing 59064 284.7 51.88 270.4 14.3 284.7 82.9 0.0 0.0   0.0 84.0
62358 62358 2015 2921320 1487 SCHENECTADY AVE BROOKLYN 1020 EAST 48TH STREET Distribution Center 88000 280.0 34.25 0.9 279.0 280.0 82.9 0.0 0.0   94.0 9.1
62359 62359 2015 2715862 100 Woodruff Ave - 38218 BROOKLYN 100 Woodruff Ave Multifamily Housing 108549 526.7 52.23 420.0 106.7 526.7 82.9 0.0 0.0   63.0 84.7
62360 62360 2015 2715864 135 Ocean Ave - 38286 BROOKLYN 135 Ocean Ave Multifamily Housing 72684 399.8 59.21 312.6 87.1 399.8 82.9 0.0 0.0   51.0 95.4
62361 62361 2015 2715972 20 Woodruff Ave - 38219 BROOKLYN 20 Woodruff Ave Multifamily Housing 101200 511.3 54.38 439.3 72.0 511.3 82.9 0.0 0.0   73.0 90.3
62362 62362 2015 2715984 231 Ocean Ave - 38270 BROOKLYN 231 Ocean Ave Multifamily Housing 64165 312.6 52.44 247.3 65.3 312.6 82.9 0.0 0.0   77.0 84.8
62363 62363 2015 2715998 395 Ocean Ave - 38222 BROOKLYN 395 Ocean Ave Multifamily Housing 116873 447.3 41.2 333.8 113.4 447.3 82.9 0.0 0.0   87.0 65.5
62364 62364 2015 2716002 417 Ocean Ave - 38223 BROOKLYN 417 Ocean Ave Multifamily Housing 74169 393.8 57.15 315.9 78.0 393.8 82.9 0.0 0.0   63.0 92.9
62365 62365 2015 2716006 550 Ocean Avenue - 24263 BROOKLYN 550 Ocean Avenue Multifamily Housing 56430 283.8 54.13 223.0 60.7 283.8 82.9 0.0 0.0   45.0 87.4
62366 62366 2015 3093074 33 Crooke Ave - 39741 BROOKLYN 33 Crooke Ave Multifamily Housing 76670 398.2 55.9 331.9 66.4 398.2 82.9 0.0 0.0   59.0 91.9
62367 62367 2015 2869788 240 Willoughby Street BROOKLYN 240 Willoughby Street Medical Office 200000 530.1 28.53 53.5 476.6 530.1 82.9 0.0 0.0   89.0 33.8
62368 62368 2015 2869789 121 DeKalb Avenue BROOKLYN 121 DeKalb Avenue Hospital (General Medical & Surgical) 700000 4543.1 69.86 32.5 4510.5 4543.1 82.9 0.0 0.0   100.0 78.6
62384 62384 2015 2676224 GMG Realty Corp BROOKLYN 295 Ocean Parkway Multifamily Housing 110957 414.2 40.18 313.4 100.8 414.2 82.9 0.0 0.0   93.0 64.1
62385 62385 2015 2796456 Graham Realty Assoc. LLC BROOKLYN 1225 Ocean Parkway Multifamily Housing 147000 486.4 35.62 350.4 136.1 486.4 82.9 0.0 0.0   92.0 56.0
62386 62386 2015 2796523 Van Houten Realty Assoc. LLC BROOKLYN 1860 Ocean Parkway Multifamily Housing 70000 249.2 38.32 195.1 54.1 249.2 82.9 0.0 0.0   90.0 61.8
62387 62387 2015 2796722 902 Ocean Parkway Owners Cop\rp BROOKLYN 902 Ocean Parkway Multifamily Housing 81600 233.1 30.75 169.8 63.3 233.1 82.9 0.0 0.0   97.0 48.5
62388 62388 2015 2796727 Elison Realty Assoc. LLC BROOKLYN 305 Ocean Parkway Multifamily Housing 72800 287.2 42.46 219.1 68.1 287.2 82.9 0.0 0.0   84.0 67.9
62389 62389 2015 3987737 Bomel Realty Company, LLC BROOKLYN 105 Buckingham Road Multifamily Housing 77863 353.7 48.9 300.6 53.1 353.7 82.9 0.0 0.0   78.0 75.6
62390 62390 2015 2643941 Sunset Gardens HDFC BROOKLYN 405 44th Street Multifamily Housing 67415 335.5 53.57 271.1 64.4 335.5 82.9 0.0 0.0   0.0 87.2
62391 62391 2015 3488156 1864 corp. BROOKLYN 1864 85 st. Multifamily Housing 72000 309.6 46.28 231.4 78.2 309.6 82.9 0.0 0.0   83.0 73.6
62394 62394 2015 2610560 28 Marine Avenue BROOKLYN 28 Marine Avenue Multifamily Housing 64800 16.7 2.77 0.0 16.7 16.7 82.9 0.0 0.0   100.0 3.1
62406 62406 2015 2800249 80 Greene Avenue - 25966 BROOKLYN 80 Greene Avenue Multifamily Housing 88741 422.0 51.19 272.7 149.2 422.0 82.9 0.0 0.0   56.0 78.1
62407 62407 2015 2800312 41 Utica Avenue - 25967 BROOKLYN 41 Utica Avenue Multifamily Housing 209963 822.5 42.17 635.6 186.9 822.5 82.9 0.0 0.0   93.0 67.7
62410 62410 2015 2800328 379 Washington Avenue - 32418 BROOKLYN 379 Washington Avenue Multifamily Housing 95280 741.5 83.77 517.1 224.4 741.5 82.9 0.0 0.0   11.0 130.6
62465 62465 2015 4407973 1520 Ocean Avenue - 42246 BROOKLYN 1520 Ocean Avenue Multifamily Housing 62200 199.5 34.52 154.4 45.2 199.5 82.9 0.0 0.0   97.0 55.5
62475 62475 2015 3268613 Hanson Place Central UMC BROOKLYN 144 St. Felix Street Worship Facility 60000 0.0 0.0 0.0 0.0 0.0 82.9 0.0 0.0   0.0 0.0
62476 62476 2015 2910131 202 Tillary Street (American Self Storage) BROOKLYN 202 Tillary Street Non-Refrigerated Warehouse 114500 127.5 11.99 119.5 8.0 127.5 82.9 0.0 0.0   99.0 20.5
62478 62478 2015 2910148 45 Clinton Avenue (American Self Storage) BROOKLYN 45 Clinton Avenue Non-Refrigerated Warehouse 66633 662.5 107.02 392.9 269.6 662.5 82.9 0.0 0.0   3.0 159.8
62501 62501 2015 2813826 1760 Union St LLC BROOKLYN 1760 Union St Multifamily Housing 66010 211.8 34.54 157.8 53.9 211.8 82.9 0.0 0.0   96.0 54.9
62502 62502 2015 2813828 1777 Management Co. BROOKLYN 1777 Ocean Pkwy Multifamily Housing 90563 343.6 40.84 255.5 88.1 343.6 82.9 0.0 0.0   0.0 64.9
62503 62503 2015 2813831 M&B Lincoln REalty Corp BROOKLYN 57 Lincoln Rd Multifamily Housing 83847 331.5 42.56 235.6 95.9 331.5 82.9 0.0 0.0   0.0 66.7
62504 62504 2015 2813832 9302 Realty LLC BROOKLYN 9302 Kings Hwy Multifamily Housing 65826 288.0 47.09 227.6 60.4 288.0 82.9 0.0 0.0   77.0 76.1
62505 62505 2015 2813846 40 Woodruff LLC BROOKLYN 40 Woodruff Ave Multifamily Housing 76065 326.5 46.2 254.5 72.0 326.5 82.9 0.0 0.0   76.0 74.4
62506 62506 2015 2813849 961 Eastern Realty Co. Inc. BROOKLYN 961 Eastern Pkwy Multifamily Housing 89562 380.8 45.77 258.8 122.0 380.8 82.9 0.0 0.0   73.0 70.8
62511 62511 2015 3698664 DLX Industries BROOKLYN 193 Hinsdale Street Manufacturing/Industrial Plant 70000 216.8 33.34 135.3 81.4 216.8 82.9 0.0 0.0   0.0 50.4
62512 62512 2015 2643921 Shore Hill Housing Associates, L.P. BROOKLYN 9000 Shore Road Multifamily Housing 414000 2208.6 57.42 1512.7 695.9 2208.6 82.9 0.0 0.0   36.0 89.1
62530 62530 2015 2604497 150 Brighton 15th Street BROOKLYN 150 Brighton 15th St. Multifamily Housing 62500 313.0 53.91 250.3 62.7 313.0 82.9 0.0 0.0   89.0 78.3
62531 62531 2015 2607346 2011 Ocean Avenue BROOKLYN 2011 Ocean Avenue Multifamily Housing 61000 270.0 47.64 201.3 68.7 270.0 82.9 0.0 0.0   88.0 71.9
62532 62532 2015 2607350 2510 Ocean Parkway BROOKLYN 2510 Ocean Parkway Multifamily Housing 63404 286.9 48.71 197.6 89.3 286.9 82.9 0.0 0.0   0.0 75.7
62541 62541 2015 2608476 3085-3097 Brighton 13th St. BROOKLYN 3085-3097 Brighton 13th St. Multifamily Housing 71593 367.4 55.24 258.4 109.0 367.4 82.9 0.0 0.0   0.0 81.7
62547 62547 2015 3267780 101 Clinton Street BROOKLYN 101 Clinton Street Multifamily Housing 51276 296.7 62.28 133.1 163.6 296.7 82.9 0.0 0.0   13.0 87.4
62548 62548 2015 2715986 3152 Brighton 6th Street - 39802 BROOKLYN 3152 Brighton 6th Street Multifamily Housing 153978 742.2 51.88 476.8 265.4 742.2 82.9 0.0 0.0   0.0 79.1
62549 62549 2015 2716004 501 Brightwater Ct - 39801 BROOKLYN 501 Brightwater Ct Multifamily Housing 112200 451.5 43.31 374.2 77.3 451.5 82.9 0.0 0.0   84.0 71.1
62571 62571 2015 3788344 5202 15th Avenue - 41591 BROOKLYN 5202 15th Avenue Multifamily Housing 55250 216.7 42.22 164.1 52.6 216.7 82.9 0.0 0.0   91.0 67.4
62574 62574 2015 2715866 1451 52nd Street - 36383 BROOKLYN 1451 52nd Street Multifamily Housing 83028 279.5 36.23 205.5 74.0 279.5 82.9 0.0 0.0   0.0 57.3
62575 62575 2015 2715978 2114 Albermarle Road - 36378 BROOKLYN 2114 Albermarle Road Multifamily Housing 63361 200.1 33.99 157.2 42.8 200.1 82.9 0.0 0.0   97.0 54.9
62576 62576 2015 2715980 2116 Ditmas Avenue - 36377 BROOKLYN 2116 Ditmas Avenue Multifamily Housing 75900 309.8 43.93 244.7 65.1 309.8 82.9 0.0 0.0   92.0 71.0
62588 62588 2015 2661787 1270 Realty Co. LLC BROOKLYN 1270 East 19th Street Multifamily Housing 97620 363.6 40.09 287.3 76.4 363.6 82.9 0.0 0.0   88.0 64.8
62589 62589 2015 2661793 130 Ave P LLC BROOKLYN 130 Avenue P Multifamily Housing 108000 330.7 32.96 246.1 84.6 330.7 82.9 0.0 0.0   96.0 52.4
62590 62590 2015 2661774 2285 Ocean LLC BROOKLYN 2285 Ocean Avenue Multifamily Housing 96600 370.7 41.31 281.0 89.7 370.7 82.9 0.0 0.0   87.0 66.0
62593 62593 2015 2661620 Medjugorje Realty LLC BROOKLYN 2387 Ocean Avenue Multifamily Housing 71400 367.2 55.36 268.1 99.1 367.2 82.9 0.0 0.0   45.0 87.4
62594 62594 2015 2661781 MACT Realty LLC BROOKLYN 1755 Ocean Parkway Multifamily Housing 158250 655.2 44.57 484.0 171.2 655.2 82.9 0.0 0.0   75.0 70.6
62595 62595 2015 2661789 Fatima Realty LLC BROOKLYN 1280 East 12th Street Multifamily Housing 65500 315.3 51.81 194.4 120.9 315.3 82.9 0.0 0.0   45.0 78.1
62596 62596 2015 2661804 MGA Realty Corp BROOKLYN 2134 Homecrest Ave Multifamily Housing 75300 308.5 44.1 233.8 74.6 308.5 82.9 0.0 0.0   78.0 70.4
62597 62597 2015 2661807 DiMaggioRealty Corp BROOKLYN 2245 E. 19th Street Multifamily Housing 84000 311.7 39.94 248.2 63.4 311.7 82.9 0.0 0.0   86.0 64.7
62601 62601 2015 4014223 33 Trinity Realty LLC BROOKLYN 1648 West 9th Street Multifamily Housing 62640 207.3 35.62 162.4 45.0 207.3 82.9 0.0 0.0   94.0 57.5
62602 62602 2015 4843831 Saint Joseph Realty LLC BROOKLYN 2306 Ocean Ave Multifamily Housing 84375 378.2 48.25 310.5 67.8 378.2 82.9 0.0 0.0   70.0 79.0
62611 62611 2015 3999704 400 Avenue U BROOKLYN 400 Avenue U Multifamily Housing 79000 410.8 55.97 185.1 225.8 410.8 82.9 0.0 0.0   23.0 78.6
62613 62613 2015 3112634 1201aveK BROOKLYN 1201 Ave K Multifamily Housing 71875 350.5 52.49 340.6 9.9 350.5 82.9 0.0 0.0   78.0 85.9
62614 62614 2015 3116364 1106-1124 Ave K BROOKLYN 1106-1124 Ave K Multifamily Housing 71875 322.3 48.27 301.9 20.4 322.3 82.9 0.0 0.0   84.0 77.9
62615 62615 2015 2947147 5301 1st Ave BROOKLYN 5301 1st ave Non-Refrigerated Warehouse 56000 43.4 8.34 33.9 9.5 43.4 82.9 0.0 0.0   98.0 13.5
62616 62616 2015 2947149 1100 Coney Island Ave BROOKLYN 1100 Coney Island Ave Office 43000 127.6 31.94 62.7 64.9 127.6 82.9 0.0 0.0   99.0 45.7
62618 62618 2015 2942054 1710 Cortelyou Road - 40241 BROOKLYN 1710 Cortelyou Road Multifamily Housing 147088 648.7 47.47 479.6 169.1 648.7 82.9 0.0 0.0   0.0 75.3
62619 62619 2015 2942059 570 Lefferts Ave - 40244 BROOKLYN 570 Lefferts Ave Multifamily Housing 55123 268.5 52.43 211.9 56.6 268.5 82.9 0.0 0.0   66.0 84.8
62620 62620 2015 2942072 3857 Kings Highway - 40239 BROOKLYN 3857 Kings Highway Multifamily Housing 84368 429.3 54.77 271.7 157.5 429.3 82.9 0.0 0.0   50.0 83.2
62621 62621 2015 2942073 777 East 31 Street - 40240 BROOKLYN 777 East 31 Street Multifamily Housing 121664 597.4 52.85 460.1 137.3 597.4 82.9 0.0 0.0   71.0 84.8
62622 62622 2015 2942077 140 Clarkson Ave - 40242 BROOKLYN 140 Clarkson Ave Multifamily Housing 76440 294.1 41.41 226.2 67.9 294.1 82.9 0.0 0.0   88.0 66.4
62623 62623 2015 2942082 560 Lefferts Ave - 40243 BROOKLYN 560 Lefferts Ave Multifamily Housing 60707 249.4 44.22 190.8 58.6 249.4 82.9 0.0 0.0   87.0 70.8
62633 62633 2015 2652133 80 Cranberry/60 Henry (158) BROOKLYN 80 Cranberry Street Multifamily Housing 108750 654.5 64.78 485.3 169.2 654.5 82.9 0.0 0.0   0.0 102.8
62647 62647 2015 2652765 185 Montague (E10) BROOKLYN 185 Montague Street Office 58000 349.9 64.94 100.5 249.4 349.9 82.9 0.0 0.0   0.0 84.5
62655 62655 2015 2947162 Brooklyn Excelsior Charter School BROOKLYN 856 Quincy Street K-12 School 55627 317.8 61.49 125.5 192.3 317.8 82.9 0.0 0.0   44.0 84.2
62656 62656 2015 2796396 1257 Yeled Vyalda Childhood Center BROOKLYN 1263 38th Street K-12 School 70000 433.5 66.66 109.7 323.8 433.5 82.9 0.0 0.0   33.0 85.3
62657 62657 2015 2800790 1312 Yeled Vyalda Childhood Center BROOKLYN 1312 38th Street Office 60000 502.8 90.2 144.5 358.3 502.8 82.9 0.0 0.0   0.0 117.3
62660 62660 2015 3128742 934 Carroll St BROOKLYN 934 Carroll St Multifamily Housing 50808 375.5 79.55 373.6 1.9 375.5 82.9 0.0 0.0   0.0 107.3
62708 62708 2015 2788761 seico realty associates BROOKLYN 5801-5805 2nd avenue Non-Refrigerated Warehouse 360400 580.4 17.33 130.7 449.7 580.4 82.9 0.0 0.0   83.0 21.9
62740 62740 2015 4036554 1237 Myrtle Holding LLC BROOKLYN 960 Willoughby Avenue Multifamily Housing 59000 260.1 47.45 116.2 143.9 260.1 82.9 0.0 0.0   87.0 66.5
62743 62743 2015 2966740 213 Georgia Avenue BROOKLYN 213 Georgia Avenue Non-Refrigerated Warehouse 91476 130.8 15.39 101.8 29.0 130.8 82.9 0.0 0.0   81.0 24.8
62745 62745 2015 2941923 Lindsay Park HGS Corp. 3 BROOKLYN 54 Boerum Street Multifamily Housing 387600 2595.6 72.08 1961.2 634.4 2595.6 82.9 0.0 0.0   21.0 115.0
62746 62746 2015 2941948 Lindsay Park HGS Corp. 4 BROOKLYN 29-31 Leonard Street Multifamily Housing 387600 2606.6 72.39 1961.2 645.4 2606.6 82.9 0.0 0.0   20.0 115.3
62747 62747 2015 2941953 Lindsay Park HGS Corp. 5 BROOKLYN 91 Boerum Street Multifamily Housing 387600 2576.6 71.55 1961.2 615.4 2576.6 82.9 0.0 0.0   22.0 114.4
62748 62748 2015 2941956 Lindsay Park HGS Corp. 1 BROOKLYN 30 Montrose Avenue Multifamily Housing 387600 2632.0 73.09 1961.2 670.8 2632.0 82.9 0.0 0.0   19.0 116.1
62749 62749 2015 2945698 Lindsay Park HGS Corp. 7 BROOKLYN 29 Moore Street Multifamily Housing 387600 2617.6 72.69 1961.2 656.3 2617.6 82.9 0.0 0.0   19.0 115.7
62750 62750 2015 2945699 Lindsay Park HGS Corp. 2 BROOKLYN 25 Boerum Street Multifamily Housing 387600 2617.6 72.69 1961.2 656.3 2617.6 82.9 0.0 0.0   19.0 115.7
62751 62751 2015 2945709 Lindsay Park HGS Corp. 6 BROOKLYN 67 Manhattan Ave. Multifamily Housing 387600 2610.9 72.51 1961.2 649.7 2610.9 82.9 0.0 0.0   20.0 115.5
62757 62757 2015 4392234 Lenox 65 Inc. BROOKLYN 65 Lenox Road Multifamily Housing 84000 218.1 27.95 201.4 16.6 218.1 82.9 0.0 0.0   100.0 47.5
62758 62758 2015 4393256 G & S Realty Corp BROOKLYN 2069 Nostrand Ave Multifamily Housing 50871 242.4 51.29 221.0 21.4 242.4 82.9 0.0 0.0   72.0 86.8
62759 62759 2015 4393322 354 Ocean Ave Realty BROOKLYN 354 Ocean Ave Multifamily Housing 55200 170.7 33.29 153.1 17.5 170.7 82.9 0.0 0.0   99.0 56.1
62761 62761 2015 4393500 AKAM A.1911 Albemarle BROOKLYN 1911 Albemarle Rd Multifamily Housing 85200 345.3 43.62 316.1 29.2 345.3 82.9 0.0 0.0   90.0 74.0
62762 62762 2015 4393981 60-17 Realty Company BROOKLYN 60 East 17 Street Multifamily Housing 84600 353.2 44.94 323.2 29.9 353.2 82.9 0.0 0.0   88.0 76.2
62763 62763 2015 2694101 The Colony House BROOKLYN 225 Sterling Place Multifamily Housing 72756 329.9 48.81 224.8 105.2 329.9 82.9 0.0 0.0   78.0 75.6
62764 62764 2015 2771259 50 Ocean Parkway BROOKLYN 50 ocean parkway Multifamily Housing 69444 253.7 39.32 190.7 63.0 253.7 82.9 0.0 0.0   0.0 62.6
62765 62765 2015 2772563 1685 East 5th Street BROOKLYN 1685 East 5th Street Multifamily Housing 66186 292.1 47.5 220.0 72.1 292.1 82.9 0.0 0.0   0.0 75.7
62775 62775 2015 2774276 530 Herzl Associates LLC BROOKLYN 530 Herzl St Multifamily Housing 51900 201.6 41.81 154.9 46.7 201.6 82.9 0.0 0.0   68.0 67.0
62832 62832 2015 2726128 465 Ocean Pkwy - 32514 BROOKLYN 465 Ocean Pkwy Multifamily Housing 90228 628.6 74.99 523.8 104.8 628.6 82.9 0.0 0.0   0.0 123.3
62833 62833 2015 2726146 706 Eastern Pkwy - 32507 BROOKLYN 706 Eastern Pkwy Multifamily Housing 68000 400.7 63.43 298.1 102.6 400.7 82.9 0.0 0.0   30.0 95.6

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