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

2,996 rows where 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), Avoided GHG Offsite (MtCO2e)

Calendar Year 15

Borough 5

Property Type 1

  • Residence Hall/Dormitory · 2,996 ✖
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)
307036 307036 2024 2271560 Stabile Hall BROOKLYN 203 Emerson Pl Residence Hall/Dormitory 79,756 550.32 74.27 267.44 282.87     0.0 0.0 596.05 56.0 85.4
307086 307086 2024 2425340 101 Ludlow MANHATTAN 101 Ludlow St Residence Hall/Dormitory 100,632 0.0 0.0 0.0 0.0     0.0 0.0 848.91 0.0 0.0
307093 307093 2024 2445669 215 E23 MANHATTAN 215 East 23rd Street Residence Hall/Dormitory 86,104 526.12 65.77 216.31 309.8     0.0 0.0 576.18 57.0 78.6
307308 307308 2024 2614534 Woodbridge MANHATTAN 431 Riverside Drive Residence Hall/Dormitory 69,078 181.41 28.31 108.22 73.18     0.0 0.0 481.52 96.0 38.7
307313 307313 2024 2617128 Loeb Hall - 135 E 12th St MANHATTAN 131 E 12th St Residence Hall/Dormitory 59,134 235.09 42.84 26.99 208.1     0.0 0.0 375.69 83.0 39.2
307316 307316 2024 2617519 Stuyvesant Park Residence - 318 E 15th St MANHATTAN 318 E 15th Street Residence Hall/Dormitory 116,996 532.82 48.98 5.59 527.23     0.0 0.0 750.91 77.0 41.2
307317 307317 2024 2617683 Alumni Hall MANHATTAN 210 west 27th STREET Residence Hall/Dormitory 134,433 908.55 72.76 0.0 908.55     0.0 0.0 960.76 55.0 75.6
307477 307477 2024 2646463 Palladium Hall MANHATTAN 140 East 14 Street Residence Hall/Dormitory 462,087 3688.84 85.9 914.39 2774.45     0.0 0.0 3747.59 51.0 89.4
307483 307483 2024 2646962 Ruggles MANHATTAN 508 West 114th Street Residence Hall/Dormitory 48,717 89.05 19.7 4.41 84.63     0.0 0.0 269.15 99.0 16.8
307484 307484 2024 2646973 Watt Dormitory   549 West 113th Residence Hall/Dormitory 50,443 310.9 66.31 232.15 78.75     0.0 0.0 309.75 49.0 100.2
307671 307671 2024 2658209 460 Riverside MANHATTAN 460 Riverside Drive Residence Hall/Dormitory 50,233 55.0 11.73 15.16 39.84     0.0 0.0 327.75 100.0 12.6
307676 307676 2024 2658276 Broadway Residence MANHATTAN 2900 Broadway Residence Hall/Dormitory 149,229 601.6 43.38 0.0 601.6     0.0 0.0 1307.71 0.0 35.0
307683 307683 2024 2658502 Carman MANHATTAN 545 West 114th Street Residence Hall/Dormitory 156,383 0.0 0.0 0.0 0.0     0.0 0.0 1319.21 0.0 0.0
307755 307755 2024 2661692 Kaufman Hall MANHATTAN 406 West 31 Street Residence Hall/Dormitory 326,794 2572.83 84.71 1220.21 1352.62     0.0 0.0 2289.81 40.0 106.2
307787 307787 2024 2663886 Nagler Hall MANHATTAN 220 West 27 Street Residence Hall/Dormitory 62,542 550.29 94.72 0.0 550.29     0.0 0.0 420.88 26.0 116.7
307790 307790 2024 2663922 Coed Hall MANHATTAN 230 West 27 Street Residence Hall/Dormitory 107,633 574.72 57.48 7.88 566.85     0.0 0.0 770.92 73.0 61.6
308201 308201 2024 2674719 WCMC Olin Hall MANHATTAN 445 East 69th ST Residence Hall/Dormitory 105,477 737.92 75.35 0.0 737.92     0.0 0.0 1082.64 0.0 86.3
308422 308422 2024 2690683 Willoughby Hall BROOKLYN 215 Willoughby Ave Residence Hall/Dormitory 289,258 1385.3 51.56 913.46 471.84     0.0 0.0 1911.51 74.0 73.6
308432 308432 2024 2691090 Leo Pantas BROOKLYN 224 Grand Ave Residence Hall/Dormitory 66,590 433.14 69.97 214.9 218.24     0.0 0.0 508.92 63.0 80.7
308454 308454 2024 2694253 1 Washington Square Village MANHATTAN 1 Washington Square Village Residence Hall/Dormitory 306,626 4258.48 149.51 2124.64 2133.84     0.0 0.0 2063.09 6.0 190.9
308556 308556 2024 2706312 Founders Hall MANHATTAN 120 East 12 Street Residence Hall/Dormitory 189,845 856.65 48.55 226.81 629.84     0.0 0.0 1303.99 79.0 51.3
308557 308557 2024 2706343 14 Washington Place MANHATTAN 12 Washington Place Residence Hall/Dormitory 131,838 670.43 54.79 442.29 228.14     0.0 0.0 937.28 75.0 78.2
308559 308559 2024 2706432 15 Washington Place MANHATTAN 9 Washington Place Residence Hall/Dormitory 73,733 329.0 48.01 240.07 88.93     0.0 0.0 657.57 90.0 54.8
308579 308579 2024 2709699 29 Washington Square West MANHATTAN 29 Washington Square West Residence Hall/Dormitory 140,708 623.44 47.68 463.56 159.88     0.0 0.0 930.29 79.0 71.9
308580 308580 2024 2709720 37 Washington Square West MANHATTAN 37 Washington Square West Residence Hall/Dormitory 119,123 302.8 27.34 162.29 140.51     0.0 0.0 890.17 98.0 29.0
308585 308585 2024 2710342 Alumni Hall MANHATTAN 33 3 Avenue Residence Hall/Dormitory 147,029 1379.84 100.97 17.35 1362.49     0.0 0.0 1242.65 41.0 104.1
308588 308588 2024 2710412 Brittany Hall MANHATTAN 55 East 10 Street Residence Hall/Dormitory 148,430 694.53 50.38 201.87 492.66     0.0 0.0 1008.92 77.0 54.4
308590 308590 2024 2710473 Carlyle I, II, III MANHATTAN 25 Union Square West Residence Hall/Dormitory 214,333 1029.19 51.67 359.02 670.17     0.0 0.0 2009.63 0.0 58.7
308891 308891 2024 2741415 50 Haven Ave MANHATTAN 50 Haven Ave Residence Hall/Dormitory 174,349 583.21 44.24 86.11 497.09     0.0 0.0 913.19 81.0 41.9
308893 308893 2024 2741534 Tower 1 MANHATTAN 52 Haven Ave, 60 Haven Ave Residence Hall/Dormitory 268,810 1328.98 51.88 115.56 1213.41     0.0 0.0 1744.06 71.0 46.2
308894 308894 2024 2741571 Towers 2,3 MANHATTAN 100 Haven Avenue Residence Hall/Dormitory 331,464 11742.14 353.06 8547.9 3194.24     0.0 0.0 2627.25 1.0 527.0
308896 308896 2024 2741656 154 Haven Dormitory MANHATTAN 154 Haven Avenue Residence Hall/Dormitory 84,075 547.52 70.07 172.34 375.19     0.0 0.0 565.76 52.0 77.4
308932 308932 2024 2746882 Hogan Hall MANHATTAN 566 West 114th Street Residence Hall/Dormitory 60,689 148.66 26.37 3.25 145.41     0.0 0.0 392.77 96.0 21.8
308933 308933 2024 2746906 Hartley Hall MANHATTAN 1124 Amsterdam Avenue Residence Hall/Dormitory 81,943 0.0 0.0 0.0 0.0     0.0 0.0 691.25 0.0 0.0
308936 308936 2024 2746925 Georgian MANHATTAN 617 W 168 Street Residence Hall/Dormitory 96,998 721.02 79.98 523.0 198.02     0.0 0.0 1249.17 0.0 90.4
308947 308947 2024 2747217 Wien Hall MANHATTAN 411 West 116th Street Residence Hall/Dormitory 106,655 0.0 0.0 0.0 0.0     0.0 0.0 0.0 100.0 0.0
308949 308949 2024 2747238 Schapiro Hall MANHATTAN 605 West 115th Street Residence Hall/Dormitory 118,242 571.22 51.99 2.99 568.22     0.0 0.0 795.23 75.0 42.2
308952 308952 2024 2747271 John Jay MANHATTAN 511 West 114th Street Residence Hall/Dormitory 153,226 0.0 0.0 0.0 0.0     0.0 0.0 1292.58 0.0 0.0
309049 309049 2024 2777323 Barnard Plimpton Hall MANHATTAN 1235 Amsterdam Ave Residence Hall/Dormitory 79,036 482.05 65.66 197.71 284.35     0.0 0.0 535.73 59.0 78.4
309050 309050 2024 2777341 Barnard Cathedral Gardens MANHATTAN 217 Manhattan Ave Residence Hall/Dormitory 103,699 567.25 58.88 295.05 272.2     0.0 0.0 583.73 52.0 76.4
309051 309051 2024 2777344 Barnard Residence Hall 600 MANHATTAN 600 W 116th St Residence Hall/Dormitory 92,348 792.13 92.35 452.73 339.4     0.0 0.0 960.97 0.0 115.0
309052 309052 2024 2777352 Barnard Residence Hall 616 MANHATTAN 616 W 116th St Residence Hall/Dormitory 63,500 343.51 58.23 219.18 124.33     0.0 0.0 414.44 66.0 82.0
309053 309053 2024 2777355 Barnard Residence Hall 620 MANHATTAN 620 W 116th St Residence Hall/Dormitory 62,250 240.14 41.55 182.72 57.42     0.0 0.0 417.93 86.0 63.3
309069 309069 2024 2780733 East Campus MANHATTAN 410 West 118th Street Residence Hall/Dormitory 379,011 23.16 0.65 23.16 0.0     0.0 0.0 3014.59 100.0 1.2
309136 309136 2024 2787562 642 Willoughby Ave. Equities, LLC BROOKLYN 642 Willoughby Ave. Residence Hall/Dormitory 22,000 0.0 0.0 0.0 0.0     0.0 0.0 185.59 0.0 0.0
309587 309587 2024 2806292 Lee Residence Hall BRONX 4455 Manhattan College Parkway Residence Hall/Dormitory 126,369 1831.21 155.97 154.55 1676.66     0.0 0.0 724.12 1.0 138.3
309590 309590 2024 2806383 Horan Hall Residence BRONX 4381 Post Road Residence Hall/Dormitory 148,224 1001.07 72.66 561.21 439.87     0.0 0.0 1009.48 50.0 97.1
309673 309673 2024 2809945 McBain MANHATTAN 562 West 113th Street Residence Hall/Dormitory 92,130 696.11 81.38 331.92 364.19     0.0 0.0 672.34 47.0 102.2
309692 309692 2024 2810835 646 Willoughby Ave. Equities, LLC BROOKLYN 646 Willoughby Ave. Residence Hall/Dormitory 22,000 203.99 99.78 78.58 125.41     0.0 0.0 123.62 10.0 116.8
309693 309693 2024 2810841 652 Willoughby Ave. Equities, LLC BROOKLYN 652 Willoughby Ave. Residence Hall/Dormitory 22,000 0.0 0.0 0.0 0.0     0.0 0.0 185.59 0.0 0.0
309926 309926 2024 2825112 D'Agostino Hall MANHATTAN 134 Mac Dougal Street Residence Hall/Dormitory 146,061 12.19 0.86 3.65 8.54     0.0 0.0 942.22 100.0 1.0
309931 309931 2024 2825625 Gramercy Green MANHATTAN 302 3 Avenue Residence Hall/Dormitory 290,634 1229.75 45.53 257.42 972.33     0.0 0.0 1952.42 81.0 45.7
309932 309932 2024 2825644 Lipton Hall MANHATTAN 35 Washington Square West Residence Hall/Dormitory 180,516 17.02 0.97 16.71 0.31     0.0 0.0 1444.83 100.0 1.8
309935 309935 2024 2825704 Hayden Hall MANHATTAN 246 Mercer Street Residence Hall/Dormitory 298,327 235.1 8.5 25.48 209.63     0.0 0.0 1878.86 100.0 7.7
309938 309938 2024 2826033 Rubin Hall MANHATTAN 35 5 Avenue Residence Hall/Dormitory 163,451 587.19 38.64 1.74 585.46     0.0 0.0 906.7 80.0 31.3
309943 309943 2024 2826127 Third Avenue North Residence Hall MANHATTAN 67 3 Avenue Residence Hall/Dormitory 322,838 2153.35 71.8 65.96 2087.39     0.0 0.0 2339.07 56.0 77.0
309944 309944 2024 2826164 University Hall MANHATTAN 106 East 14 Street Residence Hall/Dormitory 213,880 883.85 44.45 43.73 840.11     0.0 0.0 1376.99 80.0 38.0
309948 309948 2024 2826200 Weinstein Residence Hall MANHATTAN 5 University Place Residence Hall/Dormitory 168,754 97.98 6.24 97.98 0.0     0.0 0.0 1366.46 100.0 10.9
310520 310520 2024 2977586 Greenberg Hall MANHATTAN 545 First Avenue Residence Hall/Dormitory 217,465 1268.3 62.75 6.61 1261.7     0.0 0.0 2227.84 85.0 61.7
310556 310556 2024 3054453 CMSV 3 BRONX 750 West 261 Street Residence Hall/Dormitory 200,261 680.11 36.6 299.09 381.02     0.0 0.0 1508.85 92.0 44.7
310666 310666 2024 3100655 330 E 25th MANHATTAN 330 E 25th Street Residence Hall/Dormitory 11,494 15.87 14.85 0.0 15.87     0.0 0.0 74.05 100.0 12.0
310667 310667 2024 3100660 334 E 26th (Vilcek) MANHATTAN 334 E 26th Street Residence Hall/Dormitory 147,994 973.17 70.83 0.0 973.17     0.0 0.0 1153.55 63.0 79.5
310912 310912 2024 3116304 Cct BROOKLYN 238 Classon Ave Residence Hall/Dormitory 29,259 139.91 51.45 51.04 88.87     0.0 0.0 213.46 82.0 59.2
310945 310945 2024 3117707 Stratford Arms Hotel - 117 West 70th St MANHATTAN 117 West 70th St Residence Hall/Dormitory 76,448 603.86 85.03 312.56 291.29     0.0 0.0 694.24 61.0 90.6
310955 310955 2024 3118760 ELJ BROOKLYN 243 Ryerson St Residence Hall/Dormitory 44,801 161.29 38.75 109.45 51.84     0.0 0.0 301.07 89.0 49.4
311043 311043 2024 3122390 Townhouses - Emerson Pl BROOKLYN 172-186 Emerson Pl Residence Hall/Dormitory 28,048 125.03 48.01 91.7 33.33     0.0 0.0 318.53 0.0 63.3
311045 311045 2024 3122399 Townhouses - Steuben St   171- 185 Syeuben St Residence Hall/Dormitory 28,048 119.78 45.96 91.32 28.45     0.0 0.0 322.47 0.0 61.6
311046 311046 2024 3122409 Townhouses - Willoughby Ave BROOKLYN 220-234 Willoughby Ave Residence Hall/Dormitory 28,048 116.24 44.56 95.63 20.62     0.0 0.0 328.58 0.0 62.0
311401 311401 2024 3465987 E.H.S CLARK RESID. LLC BROOKLYN 51 CLARK ST Residence Hall/Dormitory 332,375 2508.41 81.27 1520.88 987.53     0.0 0.0 3286.13 0.0 112.0
311917 311917 2024 3820243 The Urban Glass House MANHATTAN 330 Spring Street Residence Hall/Dormitory 87,172 625.87 77.28 185.59 440.28     0.0 0.0 564.13 41.0 84.0
312470 312470 2024 4046073 Othmer Residence Hall BROOKLYN 101 Johnson Street Residence Hall/Dormitory 124,926 817.71 70.5 316.68 501.03     0.0 0.0 862.82 54.0 82.6
312598 312598 2024 4343225 BARD HALL MANHATTAN 410 West 58 Street Residence Hall/Dormitory 55,945 186.83 35.95 34.73 152.1     0.0 0.0 351.27 89.0 35.3
312688 312688 2024 4389685 129 3rd Avenue MANHATTAN 125 3Rd Avenue Residence Hall/Dormitory 113,000 545.58 51.99 272.19 273.39     0.0 0.0 1092.39 0.0 66.4
312740 312740 2024 4398320 636 Greenwich Street MANHATTAN 636 Greenwich Street Residence Hall/Dormitory 86,690 489.07 60.71 206.85 282.22     0.0 0.0 568.68 62.0 73.2
313105 313105 2024 4409441 TO BE DELETED 0253 - St Nicholas Tolentine -Rectory(NOT ON CBL) BRONX 2345 University Avenue Residence Hall/Dormitory 13,800 0.0 0.0 0.0 0.0     0.0 0.0 116.41 0.0 0.0
313106 313106 2024 4409442 TOBE DELETED 0253 - St Nicholas of Tolentine - Convent NOT ON CBL BRONX 2341 University Avenue Residence Hall/Dormitory 10,296 0.0 0.0 0.0 0.0     0.0 0.0 86.85 0.0 0.0
314592 314592 2024 5819576 2525 Amsterdam Avenue MANHATTAN 2525 Amsterdam Ave Residence Hall/Dormitory 90,234 397.84 47.47 221.2 176.65     0.0 0.0 605.77 80.0 63.2
314593 314593 2024 5819586 2501 Amsterdam Avenue MANHATTAN 2501 amsterdam ave Residence Hall/Dormitory 134,550 837.12 66.95 441.21 395.91     0.0 0.0 1308.34 0.0 87.3
314595 314595 2024 5819630 48 east 34th street MANHATTAN 48 E 34th St Residence Hall/Dormitory 92,302 591.7 69.0 3.01 588.68     0.0 0.0 683.81 62.0 83.4
314596 314596 2024 5819641 119 east 29th street MANHATTAN 119 East 29th Street Residence Hall/Dormitory 62,475 195.36 33.69 0.06 195.3     0.0 0.0 396.73 91.0 27.2
314758 314758 2024 5851568 LL84 Wagner College - Harborview STATEN IS 1 Campus Road Residence Hall/Dormitory 161,500 0.0 0.0 0.0 0.0     0.0 0.0 1362.38 0.0 0.0
314770 314770 2024 5857119 205 State Street BROOKLYN 205 STATE ST. Residence Hall/Dormitory 311,600 1514.31 52.31 582.88 931.43     0.0 0.0 2008.45 71.0 61.2
314850 314850 2024 5866250 Salon: 2283 3 AVENUE MANHATTAN 2283 3 AVENUE Residence Hall/Dormitory 54,726 310.16 61.03 122.48 187.68     0.0 0.0 408.39 71.0 71.9
314858 314858 2024 5866758 24th Street Residence Hall (407 First) MANHATTAN 340 East 24th Street Residence Hall/Dormitory 147,851 432.46 31.43 132.78 299.68     0.0 0.0 923.31 91.0 34.5
315344 315344 2024 6187624 148 east 35th street MANHATTAN 150 East 35th St Residence Hall/Dormitory 42,577 162.25 41.01 3.29 158.97     0.0 0.0 248.08 82.0 33.9
316170 316170 2024 6282460 Andrews: 200 East 6th Street MANHATTAN 200 East 6th Street Residence Hall/Dormitory 48,463 453.34 100.64 120.19 333.14     0.0 0.0 342.6 25.0 106.4
316724 316724 2024 6293353 320 E 22nd St MANHATTAN 320 E 22nd St Residence Hall/Dormitory 69,670 332.74 51.45 209.8 122.94     0.0 0.0 598.65 87.0 56.5
317143 317143 2024 6313799 Bushwick Realty Holdings BROOKLYN 871 Bushwick Ave Residence Hall/Dormitory 130,787 456.69 37.57 59.55 397.14     0.0 0.0 788.08 85.0 35.0
317185 317185 2024 6319733 Haven Apartments BRONX 2145 Southern Blvd. Residence Hall/Dormitory 37,100 163.26 47.36 46.33 116.93     0.0 0.0 265.74 84.0 50.9
317186 317186 2024 6319929 Hunter Apartments BRONX 806 Fairmont Place Residence Hall/Dormitory 33,474 229.27 73.73 112.06 117.21     0.0 0.0 252.18 58.0 93.5
317990 317990 2024 6572009 0082 - St. Joseph Yorkville - Rectory (NOT ON CBL) MANHATTAN 404 East 87th Street Residence Hall/Dormitory 6,488 0.0 0.0 0.0 0.0     0.0 0.0 54.73 0.0 0.0
318378 318378 2024 6627982 Newport Office Center_180 Broadway MANHATTAN 180 Broadway Residence Hall/Dormitory 149,347 793.85 57.26 224.57 569.28     0.0 0.0 948.87 65.0 61.4
318914 318914 2024 6677232 1241 LaFayette Ave BRONX 1241 Lafayette Avenue Residence Hall/Dormitory 33,590 289.85 92.89 72.15 217.7     0.0 0.0 308.76 0.0 96.8
319720 319720 2024 6702385 764SRR Substance Abuse Treatment Residential BRONX 764 E. 176Th Street Residence Hall/Dormitory 30,990 304.37 105.7 107.23 197.13     0.0 0.0 208.14 17.0 120.4
320468 320468 2024 6795764 Austell Place QUEENS 47-37 Austell Place Residence Hall/Dormitory 155,265 1838.21 127.44 220.21 1618.0     0.0 0.0 1025.53 10.0 109.7
320497 320497 2024 6797673 27 Washington Square North MANHATTAN 27 Washington Square North Residence Hall/Dormitory 49,133 161.16 35.31 139.23 21.93     0.0 0.0 335.2 92.0 57.2
321131 321131 2024 6821840 Jasper Hall BRONX 4481 Manhattan College Parkway Residence Hall/Dormitory 62,044 1436.2 249.18 1436.2 0.0     0.0 0.0 673.67 3.0 312.0
321139 321139 2024 6821886 Chrysostom Hall BRONX 4481 Manhattan College Parkway Residence Hall/Dormitory 22,119 0.0 0.0 0.0 0.0     0.0 0.0 186.59 0.0 0.0
321228 321228 2024 6863812 390 Fort Washington MANHATTAN 390 Fort Washington Ave Residence Hall/Dormitory 39,592 81.72 22.17 2.72 78.99     0.0 0.0 246.49 99.0 18.6
321625 321625 2024 7386341 St.Vincent's Hospital Westchester QUEENS 90-10 150th Street Residence Hall/Dormitory 36,700 301.03 88.26 149.96 151.08     0.0 0.0 267.71 39.0 112.7

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