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

211 rows where Calendar Year = 2019 and Property Type = "Residence Hall/Dormitory" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Grid Emissions Rate (kgCO2e/MBtu)

Borough 5

Property Type 1

  • Residence Hall/Dormitory · 211 ✖

Calendar Year 1

  • 2019 · 211 ✖
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)
156058 156058 2019 2271560 Stabile Hall BROOKLYN 203 Emerson Pl Residence Hall/Dormitory 79,756 635.6 86601.71 419.8 215.8 635.6 84.7 0.0 0.0   39.0 127.5
156156 156156 2019 2425340 101 Ludlow MANHATTAN 101 Ludlow St Residence Hall/Dormitory 105,250 858.3 87987.19 325.5 532.7 858.3 84.7 0.0 0.0   20.0 118.0
156168 156168 2019 2445669 215 E23 MANHATTAN 215 East 23rd Street Residence Hall/Dormitory 89,100 488.5 59080.51 242.4 246.1 488.5 84.7 0.0 0.0   41.0 107.2
156230 156230 2019 2550071 MSHS. MS WEST Graduate Residence MANHATTAN 515 West 59th Street Residence Hall/Dormitory 402,707 2307.0 61771.93 39.0 2268.0 2307.0 84.7 0.0 0.0   68.0 81.0
156420 156420 2019 2609568 Overlook Manor BRONX 435 West 238th Street Residence Hall/Dormitory 92,000 541.9 63401.71 378.9 163.0 541.9 84.7 0.0 0.0   45.0 98.5
156525 156525 2019 2614534 Woodbridge MANHATTAN 431 Riverside Drive Residence Hall/Dormitory 68,096 120.3 19042.61 71.0 49.2 120.3 79.5 0.0 0.0   100.0 28.7
156539 156539 2019 2617128 Loeb Residence MANHATTAN 135 East 12th Street Residence Hall/Dormitory 57,263 351.2 66320.73 203.0 148.2 351.2 79.5 0.0 0.0   50.0 99.3
156543 156543 2019 2617519 Stuyvesant Park Residence MANHATTAN 318 E 15th Street Residence Hall/Dormitory 106,852 1248.0 126729.69 12.2 1235.7 1248.0 79.5 0.0 0.0   13.0 167.7
156544 156544 2019 2617683 Alumni Hall MANHATTAN 210 west 27th STREET Residence Hall/Dormitory 130,096 875.8 72515.57 0.0 875.8 875.8 84.7 0.0 0.0   47.0 91.4
156645 156645 2019 2637427 LC. McMahon Hall MANHATTAN 155 W 60th St Residence Hall/Dormitory 282,506 1303.7 49762.04 774.7 529.0 1303.7 84.7 0.0 0.0   78.0 73.7
156675 156675 2019 2638713 RH. O'Hare and Tierney Halls BRONX 671 East Fordham Road Residence Hall/Dormitory 227,416 938.8 44516.08 660.8 277.9 938.8 84.7 0.0 0.0   86.0 69.1
156817 156817 2019 2646463 Palladium Hall MANHATTAN 140 East 14th Street Residence Hall/Dormitory 462,087 3304.0 76978.19 1095.9 2208.1 3304.0 84.7 0.0 0.0   47.0 101.1
156831 156831 2019 2646962 Ruggles MANHATTAN 508 West 114th Street Residence Hall/Dormitory 48,608 67.0 15024.61 4.5 62.5 67.0 79.5 0.0 0.0   99.0 17.9
156832 156832 2019 2646973 Watt Dormitory   549 West 113th Residence Hall/Dormitory 43,641 229.1 57349.06 163.0 66.0 229.1 79.5 0.0 0.0   57.0 89.4
157048 157048 2019 2658206 39 Claremont MANHATTAN 39 Claremont Avenue Residence Hall/Dormitory 74,328 69.9 10167.52 29.4 40.5 69.9 79.5 0.0 0.0   100.0 14.3
157049 157049 2019 2658209 460 Riverside MANHATTAN 460 Riverside Drive Residence Hall/Dormitory 49,668 48.4 10632.1 16.7 31.7 48.4 79.5 0.0 0.0   100.0 14.4
157050 157050 2019 2658213 464 Riverside MANHATTAN 464 Riverside Drive Residence Hall/Dormitory 49,668 32.0 7029.49 2.0 30.0 32.0 79.5 0.0 0.0   100.0 8.4
157051 157051 2019 2658221 520 West 114th MANHATTAN 520 West 114th Street Residence Hall/Dormitory 42,128 55.0 14095.58 17.3 37.7 55.0 79.5 0.0 0.0   100.0 19.0
157055 157055 2019 2658276 Broadway Residence MANHATTAN 2900 Broadway Residence Hall/Dormitory 144,818 445.4 33293.34 0.0 445.4 445.4 79.5 0.0 0.0   83.0 38.7
157063 157063 2019 2658502 Carman MANHATTAN 545 West 114th Street Residence Hall/Dormitory 155,609 1344.7 93382.04 53.0 1291.7 1344.7 79.5 0.0 0.0   11.0 110.9
157190 157190 2019 2661692 Kaufman Hall MANHATTAN 406 West 31 Street Residence Hall/Dormitory 350,000 2409.7 74107.91 1355.1 1054.6 2409.7 84.7 0.0 0.0   46.0 107.9
157231 157231 2019 2663886 Nagler Hall MANHATTAN 220 West 27 Street Residence Hall/Dormitory 66,230 550.2 89731.78 0.0 550.2 550.2 84.7 0.0 0.0   29.0 119.0
157236 157236 2019 2663922 Coed Hall MANHATTAN 230 West 27 Street Residence Hall/Dormitory 97,000 565.0 62696.94 8.0 557.0 565.0 84.7 0.0 0.0   66.0 81.0
157828 157828 2019 2674719 WCMC Olin Hall MANHATTAN 445 East 69th ST Residence Hall/Dormitory 105,477 587.6 60236.83 0.0 587.6 587.6 84.7 0.0 0.0   61.0 76.1
157829 157829 2019 2674737 WCMC Lasdon House MANHATTAN 420 East 70th St Residence Hall/Dormitory 250,461 1499.7 64570.48 0.2 1499.5 1499.7 84.7 0.0 0.0   61.0 83.3
158147 158147 2019 2690683 Willoughby Hall BROOKLYN 215 Willoughby Ave Residence Hall/Dormitory 289,258 1514.3 56400.6 1169.2 345.1 1514.3 84.7 0.0 0.0   67.0 90.2
158159 158159 2019 2691090 Leo Pantas BROOKLYN 224 Grand Ave Residence Hall/Dormitory 66,590 511.4 83403.92 349.6 161.8 511.4 84.7 0.0 0.0   45.0 124.0
158339 158339 2019 2706312 Founders Hall MANHATTAN 120 East 12th Street Residence Hall/Dormitory 189,845 757.0 43112.55 305.4 451.6 757.0 84.7 0.0 0.0   81.0 58.4
158373 158373 2019 2710342 Alumni Hall MANHATTAN 33 Third Avenue Residence Hall/Dormitory 147,029 1113.0 81498.1 0.0 1113.0 1113.0 84.7 0.0 0.0   52.0 102.7
158377 158377 2019 2710412 Brittany Hall MANHATTAN 55 East 10th Street Residence Hall/Dormitory 148,430 582.7 42379.22 211.1 371.7 582.7 84.7 0.0 0.0   80.0 56.3
158379 158379 2019 2710473 Carlyle I, II, III MANHATTAN 25 Union Square West Residence Hall/Dormitory 214,333 1273.9 64075.38 652.5 621.4 1273.9 84.7 0.0 0.0   58.0 91.6
158961 158961 2019 2746882 Hogan Hall MANHATTAN 566 West 114th Street Residence Hall/Dormitory 72,109 160.0 23919.78 4.8 155.3 160.0 79.5 0.0 0.0   92.0 28.3
158962 158962 2019 2746906 Hartley Hall MANHATTAN 1124 Amsterdam Avenue Residence Hall/Dormitory 79,951 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
158963 158963 2019 2746908 Hamilton Hall MANHATTAN 1130 Amsterdam Avenue Residence Hall/Dormitory 87,639 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
158964 158964 2019 2746913 Wallach Hall MANHATTAN 1116 Amsterdam Avenue Residence Hall/Dormitory 78,464 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
158977 158977 2019 2747217 Wien Hall MANHATTAN 411 West 116th Street Residence Hall/Dormitory 106,415 69.5 7057.46 0.0 69.5 69.5 79.5 0.0 0.0   100.0 8.2
158979 158979 2019 2747238 Schapiro Hall MANHATTAN 609 West 115th Street Residence Hall/Dormitory 116,827 350.7 32542.24 10.7 340.0 350.7 79.5 0.0 0.0   84.0 38.3
158982 158982 2019 2747271 John Jay MANHATTAN 511 West 114th Street Residence Hall/Dormitory 148,292 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
159158 159158 2019 2777323 Barnard Plimpton Hall MANHATTAN 1235 Amsterdam Ave Residence Hall/Dormitory 90,040 365.2 43677.51 199.9 165.2 365.2 84.7 0.0 0.0   82.0 63.5
159159 159159 2019 2777341 Barnard Cathedral Gardens MANHATTAN 217 Manhattan Ave Residence Hall/Dormitory 103,699 519.4 54279.32 316.3 203.2 519.4 84.7 0.0 0.0   41.0 80.5
159160 159160 2019 2777344 Barnard Residence Hall 600 MANHATTAN 600 W 116th St Residence Hall/Dormitory 92,348 521.6 61026.63 273.4 248.1 521.6 84.7 0.0 0.0   0.0 74.5
159161 159161 2019 2777352 Barnard Residence Hall 616 MANHATTAN 616 W 116th St Residence Hall/Dormitory 59,000 251.3 45846.92 185.8 65.5 251.3 84.7 0.0 0.0   81.0 72.4
159162 159162 2019 2777355 Barnard Residence Hall 620 MANHATTAN 620 W 116th St Residence Hall/Dormitory 59,000 234.9 42854.92 188.3 46.6 234.9 84.7 0.0 0.0   85.0 69.4
159181 159181 2019 2780733 East Campus MANHATTAN 410 West 118th Street Residence Hall/Dormitory 352,040 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
159973 159973 2019 2806292 East Hill Residence Hall BRONX 4455 Manhattan College Parkway Residence Hall/Dormitory 125,784 430.3 37053.65 272.4 157.8 430.3 84.7 0.0 0.0   84.0 55.6
159976 159976 2019 2806383 Horan Hall Residence BRONX 4381 Post Road Residence Hall/Dormitory 144,307 711.4 53176.66 362.6 348.8 711.4 84.7 0.0 0.0   59.0 75.8
159985 159985 2019 2806421 100 Morningside MANHATTAN 100 Morningside Drive Residence Hall/Dormitory 59,730 224.8 41012.28 180.3 44.5 224.8 79.5 0.0 0.0   89.0 66.2
160066 160066 2019 2809819 21 Claremont MANHATTAN 21 Claremont Ave. Residence Hall/Dormitory 61,807 54.6 9634.57 20.8 33.8 54.6 79.5 0.0 0.0   100.0 13.2
160073 160073 2019 2809829 445 Riverside Drive MANHATTAN 445-8 Riverside Drive Residence Hall/Dormitory 54,156 76.4 15228.93 29.9 46.5 76.4 79.5 0.0 0.0   100.0 21.2
160074 160074 2019 2809830 523 West 112th Street MANHATTAN 523 West 112th Street Residence Hall/Dormitory 54,567 205.7 41002.49 165.9 39.8 205.7 79.5 0.0 0.0   90.0 66.4
160075 160075 2019 2809849 25 Claremont MANHATTAN 25 Claremont Ave. Residence Hall/Dormitory 62,244 56.3 9774.32 17.2 39.2 56.3 79.5 0.0 0.0   100.0 13.1
160078 160078 2019 2809867 423 West 120th Street MANHATTAN 423 West 120th Street Residence Hall/Dormitory 102,430 598.0 63106.0 366.7 231.3 598.0 79.5 0.0 0.0   54.0 95.8
160079 160079 2019 2809888 425 West 121 Street MANHATTAN 425 West 121 Street Residence Hall/Dormitory 122,100 1679.6 148188.91 781.5 898.1 1679.6 79.5 0.0 0.0   2.0 213.1
160082 160082 2019 2809892 450 Riverside Drive MANHATTAN 450 Riverside Drive Residence Hall/Dormitory 58,965 38.9 7219.24 4.0 34.9 38.9 79.5 0.0 0.0   100.0 8.7
160086 160086 2019 2809939 600 West 113th Street MANHATTAN 600 West 113th Street Residence Hall/Dormitory 88,332 362.9 44388.86 138.1 224.7 362.9 79.5 0.0 0.0   78.0 61.5
160091 160091 2019 2809945 McBain MANHATTAN 562 West 113th Street Residence Hall/Dormitory 92,038 722.6 84543.41 419.2 303.4 722.6 79.5 0.0 0.0   35.0 127.2
160434 160434 2019 2825112 D'Agostino Hall / Alcott House MANHATTAN 110 West 3rd Street Residence Hall/Dormitory 151,022 173.0 12332.15 44.0 129.1 173.0 84.7 0.0 0.0   0.0 15.6
160440 160440 2019 2825578 Goddard Hall MANHATTAN 79 Washington Sq E / 43-51 W 4th St Residence Hall/Dormitory 76,900 49.8 7053.19 5.0 44.7 49.8 84.7 0.0 0.0   0.0 8.1
160441 160441 2019 2825625 Gramercy Green MANHATTAN 316 Third Avenue Residence Hall/Dormitory 290,634 1183.9 43942.69 454.8 729.2 1183.9 84.7 0.0 0.0   78.0 59.1
160442 160442 2019 2825644 Lipton Hall MANHATTAN 33 Washington Square West Residence Hall/Dormitory 180,497 179.7 10745.96 43.3 136.4 179.7 84.7 0.0 0.0   0.0 13.4
160444 160444 2019 2825704 Hayden Hall MANHATTAN 240 Mercer Street Residence Hall/Dormitory 298,327 204.4 7383.02 24.9 179.5 204.4 84.7 0.0 0.0   0.0 8.7
160448 160448 2019 2826033 Rubin Hall MANHATTAN 35 Fifth Avenue Residence Hall/Dormitory 155,630 1119.6 77750.08 760.2 359.4 1119.6 84.7 0.0 0.0   49.0 93.0
160453 160453 2019 2826127 Third Avenue North Residence Hall MANHATTAN 75 Third Avenue Residence Hall/Dormitory 322,838 2229.7 74534.99 66.3 2163.4 2229.7 84.7 0.0 0.0   47.0 94.2
160454 160454 2019 2826164 University Hall MANHATTAN 110 East 14th Street Residence Hall/Dormitory 213,880 1108.3 56007.65 452.9 655.4 1108.3 84.7 0.0 0.0   62.0 76.1
160458 160458 2019 2826200 Weinstein Residence Hall MANHATTAN 5-11 University Place Residence Hall/Dormitory 168,754 154.0 9866.91 154.0 0.0 154.0 84.7 0.0 0.0   0.0 17.2
160676 160676 2019 2946993 St. Mary's Home for Working Girls MANHATTAN 225 East 72nd Street Residence Hall/Dormitory 95,267 779.1 88275.31 2.0 777.2 779.1 84.7 0.0 0.0   34.0 116.8
160829 160829 2019 2971811 97 Claremont Avenue MANHATTAN 97 Claremont Avenue Residence Hall/Dormitory 75,000 105.1 15083.81 11.1 94.0 105.1 84.7 0.0 0.0   100.0 17.6
160909 160909 2019 2977586 Greenberg Hall MANHATTAN 545 First Avenue Residence Hall/Dormitory 215,584 1303.9 65279.3 6.5 1297.4 1303.9 84.7 0.0 0.0   77.0 79.3
160972 160972 2019 3054453 CMSV 3 BRONX 750 West 261 Street Residence Hall/Dormitory 200,261 523.8 28190.65 220.4 303.4 523.8 84.7 0.0 0.0   94.0 38.6
161028 161028 2019 3078576 RH. Campbell and Salice-Conley Halls BRONX 441 E Fordham Road Residence Hall/Dormitory 166,600 918.5 59558.09 383.4 535.2 918.5 84.7 0.0 0.0   63.0 81.3
161114 161114 2019 3100655 330 E 25th MANHATTAN 330 E 25th Street Residence Hall/Dormitory 9,595 13.0 15547.86 0.0 13.0 13.0 84.7 0.0 0.0   100.0 16.0
161116 161116 2019 3100660 334 E 26th (Vilcek) MANHATTAN 334 E 26th Street Residence Hall/Dormitory 144,423 847.7 63364.99 0.0 847.7 847.7 84.7 0.0 0.0   66.0 79.7
161353 161353 2019 3114649 438 W 116th St MANHATTAN 438 W 116th St Residence Hall/Dormitory 54,138 150.4 29979.45 49.4 101.0 150.4 79.5 0.0 0.0   88.0 40.7
161419 161419 2019 3116304 Cct BROOKLYN 238 Classon Ave Residence Hall/Dormitory 29,259 135.3 50219.16 59.5 75.7 135.3 84.7 0.0 0.0   78.0 68.9
161464 161464 2019 3117707 AMDA - Stratford Arms Hotel - 117 West 70th St MANHATTAN 117 West 70th St Residence Hall/Dormitory 75,000 694.3 99645.01 469.2 225.2 694.3 84.7 0.0 0.0   50.0 123.3
161480 161480 2019 3118760 ELJ BROOKLYN 243 Ryerson St Residence Hall/Dormitory 39,000 375.7 103692.24 316.5 59.2 375.7 84.7 0.0 0.0   25.0 145.0
161611 161611 2019 3122390 Townhouses - Emerson Pl BROOKLYN 172-186 Emerson Pl Residence Hall/Dormitory 28,048 167.6 64429.63 150.9 16.7 167.6 84.7 0.0 0.0   57.0 104.8
161613 161613 2019 3122399 Townhouses - Steuben St   171- 185 Syeuben St Residence Hall/Dormitory 28,048 160.9 61853.98 144.5 16.3 160.9 84.7 0.0 0.0   68.0 100.4
161614 161614 2019 3122409 Townhouses - Willoughby Ave BROOKLYN 220-234 Willoughby Ave Residence Hall/Dormitory 28,048 150.9 58009.73 140.3 10.6 150.9 84.7 0.0 0.0   69.0 95.1
161810 161810 2019 3179321 13th Street Residence MANHATTAN 118 W 13th Street Residence Hall/Dormitory 33,244 0.0 0.0 0.0 25.5 0.0 79.5 0.0 0.0   0.0 0.0
161811 161811 2019 3179329 20th Street Residence MANHATTAN 300 W 20th Street Residence Hall/Dormitory 45,263 370.0 88503.18 253.0 117.0 370.0 79.5 0.0 0.0   42.0 137.8
161905 161905 2019 3265368 Loftus 182-22 150th Ave. QUEENS 182-22 150th Ave. Residence Hall/Dormitory 61,000 628.7 110938.75 340.6 288.2 628.7 84.7 0.0 0.0   0.0 156.1
162004 162004 2019 3349786 E&M 633 East 104th Street BROOKLYN 633 EAST 104 STREET Residence Hall/Dormitory 107,544 710.3 71454.19 201.7 508.7 710.3 84.7 0.0 0.0   30.0 91.2
162115 162115 2019 3465987 E.H.S CLARK RESID. LLC BROOKLYN 51 CLARK ST Residence Hall/Dormitory 332,375 2333.9 75668.27 1563.7 770.3 2333.9 84.7 0.0 0.0   51.0 115.9
162577 162577 2019 3533688 55 West 110th Street MANHATTAN 55 West 110th Street Residence Hall/Dormitory 62,307 454.1 78836.89 307.3 146.8 454.1 84.7 0.0 0.0   52.0 120.7
162778 162778 2019 3618185 1 hoyt st BROOKLYN 452 Fulton Street Residence Hall/Dormitory 72,000 745.3 111421.31 409.6 335.7 745.3 84.7 0.0 0.0   20.0 130.6
162799 162799 2019 3688317 International House - 500 Riverside Dr. MANHATTAN 500 Riverside Drive Residence Hall/Dormitory 300,000 1147.5 41171.92 756.5 391.0 1147.5 84.7 0.0 0.0   85.0 62.9
162828 162828 2019 3820243 The Urban Glass House MANHATTAN 330 Spring Street Residence Hall/Dormitory 87,172 542.1 67070.23 233.2 309.0 542.1 84.7 0.0 0.0   45.0 92.2
162908 162908 2019 3949541 International House - 524 Riverside Dr. MANHATTAN 524 Riverside Drive Residence Hall/Dormitory 110,111 819.7 80210.63 678.4 141.3 819.7 84.7 0.0 0.0   66.0 102.0
163563 163563 2019 4046073 Othmer Residence Hall BROOKLYN 101 Johnson St Residence Hall/Dormitory 124,926 904.6 78524.39 530.7 373.9 904.6 84.7 0.0 0.0   43.0 115.3
163773 163773 2019 4343225 BARD GRADUATE CENTER MANHATTAN 410 WEST 58TH STREET Residence Hall/Dormitory 55,945 262.7 51412.3 120.9 141.8 262.7 84.7 0.0 0.0   70.0 70.6
165012 165012 2019 4489692 80 Lafayette Street MANHATTAN 80 Lafayette Street Residence Hall/Dormitory 317,464 2160.2 73350.72 1429.4 730.7 2160.2 84.7 0.0 0.0   49.0 104.6
165013 165013 2019 4489693 321 Bowery LLC MANHATTAN 321 Bowery Residence Hall/Dormitory 156,365 500.9 34561.78 289.9 211.0 500.9 84.7 0.0 0.0   88.0 50.8
165389 165389 2019 4842346 ADL00320E Adler 320 East 53rd Street MANHATTAN 320 East 53rd Street Residence Hall/Dormitory 68,538 149.2 23617.26 16.4 132.8 149.2 84.7 0.0 0.0   0.0 27.4
165954 165954 2019 4947936 CB - 47 West 13th MANHATTAN 47 West 13th Street Residence Hall/Dormitory 60,248 331.1 59398.79 173.3 157.8 331.1 84.7 0.0 0.0   60.0 85.1
166760 166760 2019 5819576 Morgenstern Residence Hall MANHATTAN 2525 amsterdam ave Residence Hall/Dormitory 72,187 436.2 65211.29 342.4 93.8 436.2 79.5 0.0 0.0   80.0 79.6
166763 166763 2019 5819586 Rubin Residence Hall MANHATTAN 2501 amsterdam ave Residence Hall/Dormitory 102,095 1410.9 148890.06 923.0 487.9 1410.9 79.5 0.0 0.0   9.0 180.2
166765 166765 2019 5819630 Brookdale Residence Hall MANHATTAN 50 east 34th st Residence Hall/Dormitory 87,550 624.9 77314.5 3.9 621.1 624.9 79.5 0.0 0.0   52.0 103.4
166766 166766 2019 5819641 Schottenstein Residence Hall MANHATTAN 119 east 29th st Residence Hall/Dormitory 52,604 382.4 79156.06 254.0 128.3 382.4 79.5 0.0 0.0   44.0 121.6
166990 166990 2019 5851568 LL84 Wagner College - Harborview STATEN IS 1 Campus Road Residence Hall/Dormitory 161,500 151.3 10115.39 0.1 151.2 151.3 84.7 0.0 0.0   100.0 11.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");