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

231 rows where Calendar Year = 2020 and Property Type = "Mixed Use Property" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Grid Emissions Rate (kgCO2e/MBtu), Avoided GHG Onsite (MtCO2e), ENERGY STAR Score

Borough 5

Property Type 1

  • Mixed Use Property · 231 ✖

Calendar Year 1

  • 2020 · 231 ✖
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)
183851 183851 2020 1261447 Time Warner Center MANHATTAN 10 Columbus Circle Mixed Use Property 2588546 15683.6 65.22 388.1 15295.6 15683.6 79.5 0.0 0.0   0.0 83.4
183935 183935 2020 1600063 590 Madison Avenue MANHATTAN 590 Madison Avenue Mixed Use Property 1029577 1773.5 18.54 0.0 1773.5 1773.5 222.9 0.0 0.0   63.0 72.8
184968 184968 2020 2364194 Sothebys NY MANHATTAN 1334 York Ave Mixed Use Property 403660 3813.7 101.7 4.2 3809.5 3813.7 79.5 0.0 0.0   0.0 127.7
185030 185030 2020 2397515 Silk Halpern - 425 Madison Ave MANHATTAN 425 Madison Ave Mixed Use Property 85705 632.4 79.42 26.9 605.5 632.4 79.5 0.0 0.0   0.0 100.5
185086 185086 2020 2539004 Franhill Realty, LLC QUEENS 205-07 Hillside Avenue Mixed Use Property 99258 131.3 14.24 59.9 71.4 131.3 79.5 0.0 0.0   0.0 20.4
185297 185297 2020 2611920 Walter & Samuels - 500 8th Ave MANHATTAN 500 8th Ave Mixed Use Property 234132 892.5 41.03 346.3 546.2 892.5 79.5 0.0 0.0   0.0 49.5
185407 185407 2020 2636742 ABS - 380 Second Avenue MANHATTAN 380 Second Avenue Mixed Use Property 198000 1000.6 54.4 208.6 792.0 1000.6 79.5 0.0 0.0   0.0 64.8
185491 185491 2020 2640229 Waterman- 400 Park Avenue MANHATTAN 400 Park Avenue Mixed Use Property 193910 804.7 44.67 0.0 804.7 804.7 79.5 0.0 0.0   76.0 53.5
186544 186544 2020 2678609 42nd Street MANHATTAN 234 W 42 St. Mixed Use Property 631262 6324.1 107.83 2748.6 3575.5 6324.1 79.5 0.0 0.0   0.0 153.3
186597 186597 2020 2681034 Newlo Realty Company BRONX 347-349 Rider Avenue Mixed Use Property 53750 108.9 21.81 69.0 39.9 108.9 79.5 0.0 0.0   0.0 33.5
186650 186650 2020 2682622 Riverdale YM YWHA BRONX 5625 Arlington ave. Mixed Use Property 46161 332.0 77.42 143.4 188.6 332.0 79.5 0.0 0.0   0.0 110.4
186667 186667 2020 2683707 17198 - 866 Third Avenue MANHATTAN 866 Third Avenue Mixed Use Property 458682 3096.2 72.66 0.9 3095.3 3096.2 79.5 0.0 0.0   0.0 89.1
186728 186728 2020 2688331 CBRE- 99 Tenth Ave MANHATTAN 99 Tenth Ave Mixed Use Property 429980 2455.8 61.48 433.2 2022.6 2455.8 79.5 0.0 0.0   0.0 78.2
187233 187233 2020 2733417 Renaissance 627 Broadway MANHATTAN 627 Broadway Mixed Use Property 120000 509.1 45.67 132.6 376.5 509.1 79.5 0.0 0.0   0.0 60.3
187668 187668 2020 2781114 663 Fifth Avenue (Sator Realty) MANHATTAN 663 Fifth Avenue Mixed Use Property 77586 593.6 82.35 0.0 593.6 593.6 79.5 0.0 0.0   0.0 103.9
187669 187669 2020 2781115 655 Fifth Avenue (Sator Realty) MANHATTAN 655 Fifth Avenue Mixed Use Property 54301 417.0 82.66 14.4 402.6 417.0 79.5 0.0 0.0   0.0 103.1
187774 187774 2020 2789702 1600-1652 Bruckner Blvd BRONX 1600 - 1652 Bruckner Blvd Mixed Use Property 82360 1274.8 166.61 141.5 1133.3 1274.8 79.5 0.0 0.0   0.0 205.5
188100 188100 2020 2800451 Redmont Realty Company QUEENS 153-15 Cross Island Parkway Mixed Use Property 148673 1236.6 89.53 377.5 859.1 1236.6 79.5 0.0 0.0   0.0 120.5
188240 188240 2020 2805211 207 W 25 street - 39875 MANHATTAN 207 W 25 street Mixed Use Property 147600 640.7 46.72 240.2 400.5 640.7 79.5 0.0 0.0   0.0 64.8
188461 188461 2020 2809822 2828 Broadway MANHATTAN 2828 Broadway Mixed Use Property 166489 284.5 18.39 175.3 109.1 284.5 79.5 0.0 0.0   0.0 27.9
188652 188652 2020 3332311 Prince Tower Condominium   133-53 Thirty-seventh Avenue Mixed Use Property 134096 764.3 61.35 431.9 332.4 764.3 79.5 0.0 0.0   0.0 91.8
188985 188985 2020 2930246 890 Broadway Condominium MANHATTAN 890 Broadway Mixed Use Property 135988 549.6 43.5 285.3 264.3 549.6 79.5 0.0 0.0   0.0 55.5
189066 189066 2020 2954442 ConEd Brinkerhoff Building QUEENS 179-45 110th Avenue Mixed Use Property 127112 9.1 0.77 0.0 9.1 9.1 79.5 0.0 0.0   0.0 0.9
189107 189107 2020 2961637 11-05 44th Drive QUEENS 11-05 44th Drive Mixed Use Property 54000 213.6 42.58 67.1 146.5 213.6 79.5 0.0 0.0   0.0 57.5
189170 189170 2020 2972060 Turnpike: 2529 Parsons QUEENS 25-03 Parsons Blvd Mixed Use Property 54571 270.0 53.26 58.8 211.2 270.0 79.5 0.0 0.0   0.0 69.0
189247 189247 2020 2978550 BRANCO QUEENS 44-02 23rd street Mixed Use Property 65000 356.6 59.05 218.0 138.6 356.6 79.5 0.0 0.0   0.0 71.4
189284 189284 2020 3052621 Vertical Industrial Park Associates QUEENS 66-26 Metropolitan Ave Mixed Use Property 1659044 6745.0 43.76 2599.8 4145.3 6745.0 79.5 0.0 0.0   0.0 60.9
189351 189351 2020 3086659 70-39 Parsons Blvd   70-39 Parson Blvd Mixed Use Property 57408 411.3 77.12 235.6 175.6 411.3 79.5 0.0 0.0   0.0 115.8
189638 189638 2020 3114481 Union Square South MANHATTAN 1 Union Square South Mixed Use Property 458931 2456.4 57.61 720.5 1735.9 2456.4 79.5 0.0 0.0   0.0 77.2
189643 189643 2020 3114581 Bronx Terminal Market - 610 Exterior St - Retail B/F BRONX 610 Exterior Street Mixed Use Property 408472 2625.8 69.19 650.1 1975.7 2625.8 79.5 0.0 0.0   0.0 90.8
189703 189703 2020 3114882 476 Jefferson BROOKLYN 476 Jefferson Street Mixed Use Property 72000 396.5 59.28 248.6 148.0 396.5 79.5 0.0 0.0   0.0 90.9
189921 189921 2020 3127469 Gravesend 1601 Gravesend neck Rd. BROOKLYN 1601 Gravesend neck Rd. Mixed Use Property 51143 448.3 94.35 62.3 386.0 448.3 79.5 0.0 0.0   0.0 117.9
190016 190016 2020 3129518 Tower 53 MANHATTAN 825 seventh Ave Mixed Use Property 358000 2150.5 64.66 20.8 2129.7 2150.5 79.5 0.0 0.0   0.0 86.7
190145 190145 2020 3265358 Steinberg 110 W 32nd St. And 115 W 31st St. MANHATTAN 110 W 32nd St. Mixed Use Property 102145 382.5 40.31 92.2 290.3 382.5 79.5 0.0 0.0   75.0 47.9
190161 190161 2020 3273500 Clinton Towers/PP&H BRONX 730 Oakland Place Mixed Use Property 145330 791.1 58.59 218.4 572.7 791.1 79.5 0.0 0.0   0.0 137.0
190162 190162 2020 3274282 Clinton Tower/PP&H BRONX 730 E 178 ST Mixed Use Property 145330 1297.5 96.1 146.1 1151.4 1297.5 79.5 0.0 0.0   0.0 208.1
190163 190163 2020 3274386 Clinton Tower/ PP & H BRONX 750 E 179 ST Mixed Use Property 145330 1432.3 106.08 313.3 1119.0 1432.3 79.5 0.0 0.0   0.0 244.2
190201 190201 2020 3318456 Terreno GAT01 151-02 132nd Ave. QUEENS 151-02 132nd Ave. Mixed Use Property 69144 182.0 28.33 5.8 176.2 182.0 79.5 0.0 0.0   0.0 33.7
190236 190236 2020 3349022 Sycamore Court BRONX 3050 Corlear Avenue Mixed Use Property 96250 171.4 19.17 99.6 71.8 171.4 79.5 0.0 0.0   0.0 28.9
190946 190946 2020 3616399 NYU: Washington Square CoGen Campus MANHATTAN 70 Washington Square South Mixed Use Property 6899870 78844.2 123.0 66462.9 12381.3 78844.2 79.5 0.0 0.0   0.0 201.0
191114 191114 2020 3989710 Astoria - 32-75 Steinway Street QUEENS 32-75 Steinway Street Mixed Use Property 51000 135.7 28.64 4.5 131.2 135.7 79.5 0.4 0.0   0.0 34.1
191314 191314 2020 4038777 Maxwell: 2300 Frederick Douglass Blvd MANHATTAN 2300 Frederick Douglas Boulevard Mixed Use Property 148870 582.6 42.12 172.9 409.7 582.6 79.5 0.0 0.0   0.0 56.5
191676 191676 2020 4044995 12 - 16 43rd Ave QUEENS 12 - 16 43rd Ave Mixed Use Property 108880 996.1 98.47 252.6 743.5 996.1 79.5 0.0 0.0   0.0 129.6
191868 191868 2020 4327694 Macklowe - 156 William St MANHATTAN 156 William Street Mixed Use Property 247929 989.5 42.96 0.0 989.5 989.5 79.5 0.0 0.0   0.0 53.7
191968 191968 2020 4380809 LC. Law School/McKeon Hall MANHATTAN 150 West 62 St Mixed Use Property 478306 1998.0 44.96 563.4 1434.5 1998.0 79.5 0.0 0.0   0.0 59.9
193263 193263 2020 4778352 Annex Building & Garage MANHATTAN 523 East 70th St Mixed Use Property 396315 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
193388 193388 2020 4861121 Salvation Army - 120 W 14th St MANHATTAN 120 W 14th Street Mixed Use Property 198000 1902.2 103.41 37.0 1865.2 1902.2 79.5 0.0 0.0   0.0 138.5
193710 193710 2020 4930972 459 East 149th St BRONX 459 East 149th St Mixed Use Property 90636 586.9 69.7 67.3 519.5 586.9 79.5 0.0 0.0   0.0 86.1
193898 193898 2020 4951014 105 E 106th Street MANHATTAN 105 East 107th Street Mixed Use Property 96550 446.2 49.74 37.9 408.3 446.2 79.5 0.0 0.0   0.0 60.6
194249 194249 2020 5048906 400E Fordham Road BRONX 400 East Fordham Road Mixed Use Property 271927 1511.9 59.85 191.9 1320.0 1511.9 79.5 0.0 0.0   0.0 74.4
194339 194339 2020 5216687 27-35 JACKSON AVE: 27-35 Jackson QUEENS 27-35 JACKSON AVENUE Mixed Use Property 78000 416.9 57.53 109.2 307.7 416.9 79.5 0.0 0.0   0.0 76.0
194454 194454 2020 5736238 The Olivia MANHATTAN 315 West 33rd Street Mixed Use Property 555125 3163.3 61.34 1293.5 1869.9 3163.3 79.5 0.0 0.0   0.0 86.3
194781 194781 2020 5848365 LL84 Wagner College - 16 Buildings STATEN IS 631 Howard Avenue Mixed Use Property 530936 3103.8 62.92 1292.3 1811.5 3103.8 79.5 0.0 0.0   0.0 86.3
194990 194990 2020 5867503 Claremont Park LLC - Webster Avenue BRONX 1465-1475 Webster Avenue Mixed Use Property 28547 148.3 55.92 125.6 22.7 148.3 79.5 0.0 0.0   0.0 92.8
195168 195168 2020 5934957 133-40 79th Street QUEENS 13340 79 ST Mixed Use Property 140184 624.3 47.94 240.0 384.3 624.3 79.5 0.0 0.0   0.0 66.7
195169 195169 2020 5934962 135-25 79th Street QUEENS 13525 79 ST Mixed Use Property 93880 405.1 46.45 105.2 299.9 405.1 79.5 0.0 0.0   0.0 61.3
195258 195258 2020 5988101 250 Utica Avenue BROOKLYN 250 Utica Avenue Mixed Use Property 39521 407.4 110.96 244.6 162.8 407.4 79.5 0.0 0.0   0.0 168.4
195558 195558 2020 6170929 5615 Northern Blvd QUEENS 56-15 Northern Blvd Mixed Use Property 25000 38.8 16.71 0.0 38.8 38.8 79.5 0.0 0.0   0.0 19.5
195560 195560 2020 6170972 2519 Borden Ave QUEENS 25-19 Borden Ave. Mixed Use Property 27000 130.4 51.99 0.0 130.4 130.4 79.5 0.0 0.0   0.0 60.8
195683 195683 2020 6183617 1505 Carroll BROOKLYN 350 Troy Avenue Mixed Use Property 30000 113.2 40.62 35.2 78.0 113.2 79.5 0.0 0.0   0.0 54.8
195827 195827 2020 6204140 Calvary Church MANHATTAN 277 Park Ave So Mixed Use Property 42944 181.0 45.37 137.6 43.4 181.0 79.5 0.0 0.0   0.0 73.0
195841 195841 2020 6210039 Forman Fifth, LLC. MANHATTAN 319 Fifth Avenue Mixed Use Property 27157 369.7 146.53 251.9 117.8 369.7 79.5 0.0 0.0   0.0 211.7
195968 195968 2020 6224304 1915 Third Avenue MANHATTAN 1915 Third Avenue Mixed Use Property 35900 359.2 107.7 62.2 297.0 359.2 79.5 0.0 0.0   0.0 136.7
195977 195977 2020 6224693 HHH REALTY CORP. BRONX 1420-36 CLAY AVENUE Mixed Use Property 118582 198.5 18.02 77.5 121.0 198.5 79.5 0.0 0.0   0.0 25.2
196077 196077 2020 6227722 Greenpoint BROOKLYN 99 Meserole Ave Mixed Use Property 49404 299.9 65.34 238.6 61.3 299.9 79.5 0.0 0.0   0.0 106.5
196078 196078 2020 6227723 Harlem MANHATTAN 180 West 135th St Mixed Use Property 70545 578.7 88.3 361.9 216.8 578.7 79.5 0.0 0.0   0.0 111.6
196089 196089 2020 6227734 West Side MANHATTAN 5 West 63rd St Mixed Use Property 278156 2485.2 96.17 58.2 2426.9 2485.2 79.5 0.0 0.0   0.0 128.3
196106 196106 2020 6230081 489 Broome Street MANHATTAN 489 Broome Street Mixed Use Property 25000 349.5 150.48 184.8 164.8 349.5 79.5 0.0 0.0   0.0 222.1
196144 196144 2020 6232124 1420 Clay Ave. Child BRONX 1420-36 CLAY AVENUE Mixed Use Property 59430 75.3 13.64 13.6 61.6 75.3 79.5 0.0 0.0   0.0 17.4
196145 196145 2020 6232127 1436 Clay Ave. Child BRONX 1420-36 CLAY AVENUE Mixed Use Property 59152 123.7 22.51 64.3 59.4 123.7 79.5 0.0 0.0   99.0 33.1
196192 196192 2020 6236828 380 BROADWAY LLC MANHATTAN 380 BROADWAY Mixed Use Property 27500 82.6 32.33 56.8 25.8 82.6 79.5 0.0 0.0   0.0 50.7
196203 196203 2020 6237738 0123-St. Gregory the Great-School(leased2018) MANHATTAN 138 West 90th Street Mixed Use Property 33756 112.3 35.81 94.5 17.8 112.3 79.5 0.0 0.0   0.0 44.0
196271 196271 2020 6246651 Randazzo LLC QUEENS 164-10 Northern Blvd Mixed Use Property 27662 120.2 46.77 55.9 64.4 120.2 79.5 0.0 0.0   0.0 67.3
197438 197438 2020 6283534 SUN WIN REALTY INC BROOKLYN 2502 86TH STREET Mixed Use Property 29700 282.2 102.28 25.0 257.3 282.2 79.5 0.0 0.0   0.0 124.8
197526 197526 2020 6288145 Manton Holding QUEENS 116-29 Queens Boulevard Mixed Use Property 37681 241.2 68.9 181.1 60.1 241.2 79.5 0.0 0.0   0.0 84.7
197593 197593 2020 6289758 Broadway Plaza Flushing LLC QUEENS 163-10 Northern Blvd Mixed Use Property 29487 151.1 55.16 92.6 58.5 151.1 79.5 0.0 0.0   0.0 84.1
197637 197637 2020 6291814 Krinos Properties MANHATTAN 143 Franklin Street Mixed Use Property 33800 120.5 38.37 6.1 114.4 120.5 79.5 0.0 0.0   0.0 46.0
197645 197645 2020 6292079 536 West 28th Street MANHATTAN 536 West 28th Street Mixed Use Property 31106 214.6 74.26 54.0 160.6 214.6 79.5 0.0 0.0   0.0 97.7
198730 198730 2020 6303591 845 Flatbush Avenue BROOKLYN 833-845 Flatbush Avenue Mixed Use Property 32247 164.9 55.04 0.0 164.9 164.9 79.5 0.0 0.0   0.0 64.4
198787 198787 2020 6308871 Rocklyn: 284 Warwick Street St Micheal St Malachy BROOKLYN 284 Warwick St Mixed Use Property 125117 119.7 10.3 36.4 83.3 119.7 79.5 0.0 0.0   0.0 13.9
198930 198930 2020 6311201 400 JB LIBERTY AVE LLC BROOKLYN 400 Liberty Ave Mixed Use Property 33296 103.3 33.39 46.8 56.5 103.3 79.5 0.0 0.0   0.0 47.8
199104 199104 2020 6317312 743 Amsterdam Avenue MANHATTAN 743 Amsterdam Avenue Mixed Use Property 35600 117.8 35.62 0.0 117.8 117.8 79.5 0.0 0.0   0.0 42.5
199110 199110 2020 6317603 Five Boro Storage BRONX 220 east 134th Street Mixed Use Property 39264 124.1 34.02 55.8 68.3 124.1 79.5 0.0 0.0   84.0 48.6
199229 199229 2020 6342019 East River Housing 453-457& 573&577 MANHATTAN 453 FDR Drive Mixed Use Property 1008322 5396.3 57.61 4116.5 1279.9 5396.3 79.5 0.0 0.0   0.0 92.8
199230 199230 2020 6342023 East river 473-477 & 568-572 MANHATTAN 570 Grand Street Mixed Use Property 1231250 5433.2 47.5 4260.5 1172.7 5433.2 79.5 0.0 0.0   0.0 77.1
199232 199232 2020 6342025 Hillman 500 MANHATTAN 500 Grand Street Mixed Use Property 300383 2042.4 73.19 1627.2 415.2 2042.4 79.5 0.0 0.0   0.0 119.2
199234 199234 2020 6342085 551 Stores MANHATTAN 549 Grand Street Mixed Use Property 41733 543.9 140.28 163.7 380.3 543.9 79.5 0.0 0.0   0.0 188.2
199605 199605 2020 6404226 60 West 55th Street Corp MANHATTAN 60 West 55th Street Mixed Use Property 29393 414.1 151.65 145.9 268.1 414.1 79.5 0.0 0.0   0.0 216.7
199688 199688 2020 6410265 911 Kings Highway BROOKLYN 911 Kings Highway Mixed Use Property 37072 51.1 14.84 3.1 48.0 51.1 79.5 0.0 0.0   0.0 17.9
200398 200398 2020 6595123 RP 82 LLC BROOKLYN 82 ROCKAWAY PKWAY Mixed Use Property 39110 375.4 103.32 323.0 52.4 375.4 79.5 0.0 0.0   0.0 172.3
200472 200472 2020 6600338 AAG: 112-47 Queens Blvd QUEENS 112-47 Queens Boulevard Mixed Use Property 28585 115.6 43.53 2.2 113.3 115.6 79.5 0.0 0.0   0.0 51.4
200539 200539 2020 6603661 141 SOUTH 5TH LLC BROOKLYN 141 South 5th St Mixed Use Property 30775 105.3 36.83 63.0 42.3 105.3 79.5 0.0 0.0   0.0 55.9
200605 200605 2020 6616463 WALLABOUT DEVELOPMENT LLC/ 341 wall BROOKLYN 341 WALLABOUT ST Mixed Use Property 29284 139.0 51.09 78.0 61.0 139.0 79.5 0.0 0.0   0.0 76.3
200635 200635 2020 6619957 82-94 Rockaway Parkway BROOKLYN 82-95 Rockaway Parkway Mixed Use Property 73100 742.7 109.36 654.3 88.5 742.7 79.5 0.0 0.0   0.0 182.4
200689 200689 2020 6626386 COOPER STREET HOLDINGS LLC QUEENS 56-06 COOPER AVE Mixed Use Property 35600 106.1 32.08 38.3 67.7 106.1 79.5 0.0 0.0   0.0 44.2
200745 200745 2020 6629466 Rocklyn: 43-19 30th Ave QUEENS 43-19 30th Ave Mixed Use Property 46963 91.4 20.95 32.1 59.3 91.4 79.5 0.0 0.0   0.0 28.8
200977 200977 2020 6654276 Echo Place LLC BRONX 1706 Selwyn Avenue Mixed Use Property 28856 154.1 57.48 149.2 4.9 154.1 79.5 0.0 0.0   59.0 99.5
201008 201008 2020 6655064 Rom Realty 30-39 Greenpoint QUEENS 30-39 Greenpoint Avenue Mixed Use Property 30000 143.3 51.42 100.9 42.4 143.3 79.5 0.0 0.0   0.0 81.1
201048 201048 2020 6664031 4255 Amboy STATEN IS 4255 Amboy Road Mixed Use Property 26025 359.4 148.65 197.0 162.3 359.4 79.5 0.0 0.0   0.0 221.0
201254 201254 2020 6669835 Queens Crossing Condominum QUEENS 136-20 38 Ave Mixed Use Property 336985 1817.9 58.07 105.9 1712.0 1817.9 79.5 0.0 0.0   0.0 69.8

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