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

123 rows where Calendar Year = 2017 and Property Type = "Library" 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

  • Library · 123 ✖

Calendar Year 1

  • 2017 · 123 ✖
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)
96233 96233 2017 2,638,690 Fordham. Walsh Library BRONX 439 E Fordham Rd Library 239,113 1.0 45.04 877.5 653.3 1.0 88.7   0.0     99.9
100233 100233 2017 2,638,690 RH. Walsh Library BRONX 439 E Fordham Rd Library 239,113 1.0 45.04 877.5 653.3 1.0 88.7   0.0     99.9
101209 101209 2017 4,956,972 The Morgan Library & Museum MANHATTAN 225 Madison Avenue Library 150,701 1.0 71.76 31.8 1.0 1.0 88.7   0.0     139.6
102080 102080 2017 6,294,012 BPL - 3182576 - Kings Highway Branch Library (LL84) BROOKLYN 2115 Ocean Ave Library 25,785 158.6 68286.18 52.3 106.2 158.6 88.7   0.0     84.7
102923 102923 2017 6,294,022 BPL - 3018376 - Pacific Branch Library (LL84) BROOKLYN 25 4th Ave Library 15,758 97.5 69965.35 52.0 45.4 97.5 88.7   0.0     94.7
103052 103052 2017 6,297,272 NYPL - 5060744 - Richmondtown Branch Library (LL84) STATEN IS 200 Clarke Ave Library 14,477 100.0 76885.0 32.4 67.6 100.0 88.7   0.0     94.8
103921 103921 2017 6,297,223 NYPL - 1017602 - Mid-Manhattan Library (LL84) MANHATTAN 455 5th Ave Library 146,157 3.0 221.18 0.0 3.0 3.0 88.7   0.0     306.2
105105 105105 2017 6,297,291 QPL - 4011018 - Broadway Community Library (LL84) QUEENS 40-20 Broadway Library 15,700 400.4 287324.37 329.7 70.7 400.4 88.7   0.0     446.2
105203 105203 2017 6,297,331 QPL - 4083512 - Ridgewood Community Library (LL84) QUEENS 20-12 Madison St Library 14,000 118.9 91416.26 46.0 72.8 118.9 88.7   0.0     140.7
105210 105210 2017 6,294,020 BPL - 3090726 - New Lots Branch Library (LL84) BROOKLYN 655 New Lots Ave Library 24,558 130.7 58618.41 56.5 74.2 130.7 88.7   0.0     77.4
105236 105236 2017 6,294,230 CUNY-S - 5107301 - CSI Campus: Library Cyber Cafe (LL84)   2800-T Victory Blvd Library 118,231 1.0 91.22 82.0 1.0 1.0 88.7   0.0     138.8
105243 105243 2017 6,293,990 BPL - 3029665 - Central Library and Learning Center (LL84) BROOKLYN 10 Grand Army Plz Library 352,745 1.0 30.58 422.8 1.0 1.0 88.7   0.0     60.3
105260 105260 2017 6,294,015 BPL - 3132091 - Mapleton Branch Library (LL84) BROOKLYN 1703 60th St Library 19,821 150.2 85091.46 44.8 105.3 150.2 88.7   0.0     102.5
105311 105311 2017 6,297,204 NYPL - 1052167 - Aguilar Branch Library (LL84) MANHATTAN 174 East 110th St Library 13,126 87.0 72035.33 38.1 48.9 87.0 88.7   0.0     96.7
105316 105316 2017 6,297,225 NYPL - 1014150 - Muhlenberg Branch Library (LL84) MANHATTAN 209 West 23rd St Library 12,953 96.4 86470.0 33.6 62.8 96.4 88.7   0.0     103.5
105317 105317 2017 6,297,232 NYPL - 1004053 - Seward Park Branch Library (LL84) MANHATTAN 192 East Broadway Library 19,681 174.7 98971.23 52.3 122.4 174.7 88.7   0.0     120.2
105318 105318 2017 6,297,238 NYPL - 1044180 - Yorkville Branch Library (LL84) MANHATTAN 222 East 79th St Library 13,112 58.8 48685.95 24.4 34.4 58.8 88.7   0.0     64.6
105319 105319 2017 6,297,252 NYPL - 2000744 - Mott Haven Branch Library (LL84) BRONX 321 East 140th St Library 16,020 138.2 92973.19 37.3 100.9 138.2 88.7   0.0     114.9
105324 105324 2017 6,297,235 NYPL - 1005147 - Tompkins Square Branch Library (LL84) MANHATTAN 331 East 10th St Library 14,703 94.6 72733.21 33.3 61.3 94.6 88.7   0.0     89.7
105325 105325 2017 6,297,236 NYPL - 1062551 - Washington Heights Branch Library (LL84) MANHATTAN 1000 St. Nicholas Ave Library 17,497 83.1 52616.48 48.6 34.5 83.1 88.7   0.0     74.5
105326 105326 2017 6,297,344 QPL - 4030847 - Woodside Community Library (LL84) QUEENS 54-22 Skillman Ave Library 10,800 91.2 98166.77 43.4 47.7 91.2 88.7   0.0     132.9
105497 105497 2017 6,293,987 BPL - 3071470 - Bushwick Branch Library (LL84) BROOKLYN 340 Bushwick Ave Library 10,757 53.6 57694.5 21.9 31.8 53.6 88.7   0.0     71.6
105506 105506 2017 6,294,014 BPL - 3046408 - Macon Branch Library (LL84) BROOKLYN 361 Lewis Ave Library 10,540 98.5 106024.41 44.8 53.7 98.5 88.7   0.0     137.5
105509 105509 2017 6,294,139 CUNY-C - 3348024 - KCC Campus: Robert J. Kibbee Library and Media Center (LL84) BROOKLYN 2000 Oriental Blvd Library 124,303 901.7 78272.65 250.1 651.6 901.7 88.7   0.0     97.0
105593 105593 2017 6,297,159 NYPL - 2045398 - Morris Park Branch Library (LL84) BRONX 985 Morris Park Ave Library 16,300 35.8 24084.23 8.1 27.7 35.8 88.7   0.0     28.6
105603 105603 2017 6,297,202 NYPL - 1044749 - 67th Street Branch Library (LL84) MANHATTAN 328 East 67th St Library 13,788 81.9 67812.57 29.4 52.6 81.9 88.7   0.0     83.1
105604 105604 2017 6,297,221 NYPL - 1082668 - Jefferson Market Branch Library (LL84) MANHATTAN 425 Ave of the Americas Library 20,735 141.6 76208.41 52.8 88.9 141.6 88.7   0.0     96.2
105605 105605 2017 6,297,240 NYPL - 2012129 - Belmont Branch Library (LL84) BRONX 610 East 186th St Library 21,267 126.5 64839.68 48.0 78.4 126.5 88.7   0.0     84.1
105609 105609 2017 6,297,208 NYPL - 1034194 - Central Library - Stephen A. Schwartzman Building (LL84) MANHATTAN 476 5th Ave Library 661,428 5.0 81.42 0.0 5.0 5.0 88.7   0.0     101.0
105610 105610 2017 6,297,248 NYPL - 2007870 - Grand Concourse Branch Library (LL84) BRONX 155 East 173rd St Library 18,874 64.3 38451.04 10.3 53.9 64.3 88.7   0.0     42.5
105611 105611 2017 6,297,260 NYPL - 2009573 - Tremont Branch Library (LL84) BRONX 1866 Washington Ave Library 11,900 70.6 69084.67 2.6 68.0 70.6 88.7   0.0     68.5
105629 105629 2017 6,297,220 NYPL - 1064894 - Inwood Branch Library (LL84) MANHATTAN 4790 Broadway Library 17,334 94.9 60087.89 35.2 59.7 94.9 88.7   0.0     77.1
105641 105641 2017 6,297,287 QPL - 4157389 - Bayside Community Library (LL84) QUEENS 214-20 Northern Blvd Library 10,300 55.8 60062.56 10.5 45.3 55.8 88.7   0.0     68.8
105783 105783 2017 6,294,002 BPL - 3219626 - Flatlands Branch Library (LL84) BROOKLYN 2065 Flatbush Ave Library 11,903 65.9 64485.55 14.3 51.7 65.9 88.7   0.0     71.5
105821 105821 2017 6,294,010 BPL - 3801250 - Kensington Branch Library (LL84) BROOKLYN 4209 18th Ave Library 18,300 113.2 67692.97 31.0 82.2 113.2 88.7   0.0     82.6
105837 105837 2017 6,294,203 CUNY-C - 4439440 - QCC Campus: Kurt Schmeller Library (LL84) QUEENS 222-05 56th Ave Library 107,763 1.0 100.6 712.5 536.5 1.0 88.7   0.0     180.6
105908 105908 2017 6,297,209 NYPL - 1003425 - Chatham Square Branch Library (LL84) MANHATTAN 33 East Broadway Library 12,243 77.7 69696.25 21.3 56.3 77.7 88.7   0.0     84.7
105909 105909 2017 6,297,213 NYPL - 1063632 - Fort Washington Branch Library (LL84) MANHATTAN 535 West 179th St Library 15,158 132.7 95224.64 75.0 57.6 132.7 88.7   0.0     136.1
105910 105910 2017 6,297,219 NYPL - 1009760 - Hudson Park Branch Library (LL84) MANHATTAN 66 Leroy St Library 17,565 141.8 89783.59 77.3 64.4 141.8 88.7   0.0     124.3
105911 105911 2017 6,297,390 CUNY-C - 2119712 - BCC Campus: North Hall and Library (LL84) BRONX 200 Hall of Fame Ter Library 104,672 741.2 76713.49 408.5 332.8 741.2 88.7   0.0     109.3
105919 105919 2017 6,297,249 NYPL - 2003163 - High Bridge Branch Library (LL84) BRONX 78 West 168th St Library 10,400 71.4 76854.25 33.6 37.8 71.4 88.7   0.0     101.9
105926 105926 2017 6,294,021 BPL - 3165745 - New Utrecht Branch Library (LL84) BROOKLYN 1743 86th St Library 22,557 147.1 71971.35 28.1 119.0 147.1 88.7   0.0     82.9
106080 106080 2017 6,297,246 NYPL - 2014579 - Francis Martin Branch Library (LL84) BRONX 2150 University Ave Library 16,486 90.0 60546.94 47.7 42.4 90.0 88.7   0.0     83.4
106085 106085 2017 6,297,339 QPL - 4016923 - Steinway (ALC) Community Library (LL84) QUEENS 21-45 31st St Library 11,200 81.9 80142.13 30.3 51.6 81.9 88.7   0.0     102.9
106100 106100 2017 6,293,997 BPL - 3073751 - DeKalb Branch Library (LL84) BROOKLYN 790 Bushwick Ave Library 12,584 66.8 59919.04 30.1 36.7 66.8 88.7   0.0     78.0
106109 106109 2017 6,293,986 BPL - 3080669 - Brownsville Branch Library (LL84) BROOKLYN 61 Glenmore Ave Library 10,838 55.0 59201.45 13.9 41.2 55.0 88.7   0.0     66.9
106110 106110 2017 6,293,999 BPL - 3103597 - East Flatbush Branch Library (LL84) BROOKLYN 9612 Church Ave Library 12,329 67.7 60726.34 17.9 49.7 67.7 88.7   0.0     72.9
106176 106176 2017 6,297,212 NYPL - 1019661 - Epiphany Branch Library (LL84) MANHATTAN 228 East 23rd St Library 16,218 95.5 64247.03 41.2 54.3 95.5 88.7   0.0     85.6
106177 106177 2017 6,297,229 NYPL - 1058275 - Schomburg Black History Library (Old Building) (LL84) MANHATTAN 103 West 135th St Library 40,000 392.7 105674.59 0.0 392.7 392.7 88.7   0.0     110.7
106178 106178 2017 6,297,237 NYPL - 1045991 - Webster Branch Library (LL84) MANHATTAN 1465 York Ave Library 11,801 91.9 89927.49 44.6 47.4 91.9 88.7   0.0     116.4
106191 106191 2017 6,297,295 QPL - 4437122 - East Elmhurst Community Library (LL84) QUEENS 95-06 Astoria Blvd Library 11,860 54.4 53232.38 11.1 43.3 54.4 88.7   0.0     58.8
106192 106192 2017 6,297,297 QPL - 4539447 - Elmhurst (ALC) Community Library (LL84) QUEENS 85-08 51st Ave Library 30,000 283.5 101718.85 54.8 228.7 283.5 88.7   0.0     244.1
106193 106193 2017 6,297,326 QPL - 4209635 - Queens Central Library (LL84) QUEENS 89-11 Merrick Blvd Library 239,750 1.0 45.04 424.9 1.0 1.0 88.7   0.0     96.0
106194 106194 2017 6,297,416 NYPL - 2119474 - Kingsbridge Library (LL84) BRONX 291 West 231st St Library 12,625 123.3 110599.07 37.2 86.1 123.3 88.7   0.0     132.4
106200 106200 2017 6,293,982 BPL - 3057384 - Bedford Branch Library and Learning Center (LL84) BROOKLYN 496 Franklin Ave Library 17,184 93.8 59391.4 37.3 56.5 93.8 88.7   0.0     77.9
106206 106206 2017 6,297,262 NYPL - 2063175 - Wakefield Branch Library (LL84) BRONX 4100 Lowerre Pl Library 10,743 34.3 36920.18 12.0 22.3 34.3 88.7   0.0     44.4
106207 106207 2017 6,297,330 QPL - 4193458 - Richmond Hill Community Library (LL84) QUEENS 118-14 Hillside Ave Library 13,000 61.9 51252.72 42.6 19.3 61.9 88.7   0.0     78.5
106214 106214 2017 6,293,998 BPL - 3164019 - Dyker Branch Library (LL84) BROOKLYN 8202 13th Ave Library 10,521 54.3 58447.98 17.9 36.4 54.3 88.7   0.0     71.0
106234 106234 2017 6,297,336 QPL - 4539786 - South Jamaica Community Library (LL84) QUEENS 108-41 Guy R. Brewer Blvd Library 13,500 78.7 65162.99 28.8 49.8 78.7 88.7   0.0     81.9
106291 106291 2017 6,294,032 BPL - 3013507 - Sunset Park Branch Library (LL84) BROOKLYN 5108 4th Ave Library 12,174 123.7 110957.87 44.5 79.2 123.7 88.7   0.0     142.2
106315 106315 2017 6,294,105 CUNY-S - 2097315 - LC Campus: Library (LL84) BRONX 2853 Paul Ave Library 124,736 1.0 86.81 702.1 586.0 1.0 88.7   0.0     159.0
106409 106409 2017 6,294,013 BPL - 3068818 - Leonard Branch Library (LL84) BROOKLYN 82 Devoe St Library 10,699 60.6 65229.23 18.3 42.3 60.6 88.7   0.0     76.7
106473 106473 2017 6,297,200 NYPL - 1055236 - 115th Street Branch Library (LL84) MANHATTAN 203 West 115th St Library 14,080 93.6 71964.36 46.5 47.1 93.6 88.7   0.0     99.9
106489 106489 2017 6,297,250 NYPL - 2005755 - Hunt s Point Branch Library (LL84) BRONX 877 Southern Blvd Library 13,715 80.4 66570.58 37.0 43.4 80.4 88.7   0.0     86.5
106490 106490 2017 6,297,263 NYPL - 2013151 - West Farms Branch Library (LL84) BRONX 2085 Honeywell Ave Library 15,591 104.9 75275.54 34.9 70.0 104.9 88.7   0.0     92.8
106508 106508 2017 6,297,253 NYPL - 2028890 - Parkchester Branch Library (LL84) BRONX 1985 Westchester Ave Library 14,744 137.0 105332.45 52.3 84.8 137.0 88.7   0.0     131.6
106509 106509 2017 6,297,270 NYPL - 5052750 - New Dorp Branch Library (LL84) STATEN IS 309 New Dorp Ln Library 12,000 83.2 74629.71 27.0 56.2 83.2 88.7   0.0     95.2
106519 106519 2017 6,297,303 QPL - 4177530 - Glen Oaks Community Library (LL84) QUEENS 256-04 Union Tpke Library 18,000 99.5 59500.45 7.1 92.4 99.5 88.7   0.0     65.4
106533 106533 2017 6,298,777 CUNY-C - 2100243 - BCC Campus: Gould Memorial Library (LL84) BRONX 2060 Sedgwick Ave Library 82,721 532.9 69952.22 275.2 257.7 532.9 88.7   0.0     114.6
106572 106572 2017 6,293,980 BPL - 3087001 - Arlington Branch Library (LL84) BROOKLYN 203 Arlington Ave Library 16,385 81.0 54492.24 34.4 46.7 81.0 88.7   0.0     71.6
106642 106642 2017 6,294,001 BPL - 3116706 - Flatbush Branch Library and Learning Center (LL84) BROOKLYN 22 Linden Blvd Library 21,790 133.3 68325.14 58.8 74.4 133.3 88.7   0.0     89.4
106658 106658 2017 6,294,031 BPL - 3084596 - Stone Avenue Branch Library (LL84) BROOKLYN 581 Mother Gaston Blvd Library 14,258 76.5 58817.03 33.6 42.8 76.5 88.7   0.0     78.3
106689 106689 2017 6,293,896 CUNY-S - 1018107 - BC Campus: Library and Technology Building (LL84) MANHATTAN 151 East 25th St Library 339,255 2.0 63.5 4.3 2.0 2.0 88.7   0.0     82.1
106691 106691 2017 6,293,981 BPL - 3147279 - Bay Ridge Branch Library (LL84) BROOKLYN 7223 Ridge Blvd Library 16,506 91.6 61623.33 34.4 57.2 91.6 88.7   0.0     78.3
106701 106701 2017 6,294,165 CUNY-S - 4439913 - QC Campus: Benjamin Rosenthal Library (LL84) QUEENS 65-76 Kissena Blvd Library 241,178 1.0 44.66 867.8 1.0 1.0 88.7   0.0     116.4
106716 106716 2017 6,294,018 BPL - 3179706 - Midwood Branch Library (LL84) BROOKLYN 975 East 16th St Library 15,210 111.7 80155.18 17.1 94.6 111.7 88.7   0.0     91.3
106797 106797 2017 6,297,201 NYPL - 1054674 - 125th Street Branch Library (LL84) MANHATTAN 224 East 125th St Library 14,013 44.7 34367.6 22.6 22.2 44.7 88.7   0.0     48.2
106798 106798 2017 6,297,273 NYPL - 5000030 - St. George Library Center (LL84) STATEN IS 10 Hyatt St Library 25,029 126.4 54422.28 37.6 88.8 126.4 88.7   0.0     68.3
106803 106803 2017 6,297,479 NYPL - 5109138 - Mariner s Harbor Library (LL84) STATEN IS 206 South Ave Library 10,100 66.5 71579.93 0.0 66.5 66.5 88.7   0.0     74.3
106805 106805 2017 6,297,239 NYPL - 2053752 - Allerton Branch Library (LL84) BRONX 2740 Barnes Ave Library 10,984 41.0 44131.99 1.6 39.4 41.0 88.7   0.0     43.2
106806 106806 2017 6,297,301 QPL - 4052345 - Forest Hills Community Library (LL84) QUEENS 108-19 71st Ave Library 23,739 105.5 49373.54 31.1 74.4 105.5 88.7   0.0     60.0
106807 106807 2017 6,297,305 QPL - 4090100 - Glendale Community Library (LL84) QUEENS 78-60 73rd Pl Library 13,356 69.2 57297.07 28.9 40.2 69.2 88.7   0.0     74.8
106808 106808 2017 6,297,311 QPL - 4437193 - Langston Hughes Community Library (LL84) QUEENS 100-01 Northern Blvd Library 23,000 214.3 100291.47 61.1 153.2 214.3 88.7   0.0     125.1
106854 106854 2017 6,294,024 BPL - 3022144 - Park Slope Branch Library (LL84) BROOKLYN 431 6th Ave Library 15,868 105.0 75347.3 45.9 59.0 105.0 88.7   0.0     96.5
106952 106952 2017 6,297,218 NYPL - 1053460 - Harlem Branch Library (LL84) MANHATTAN 9 West 124th St Library 13,058 97.8 80977.65 41.1 56.7 97.8 88.7   0.0     108.3
107014 107014 2017 6,293,983 BPL - 3135907 - Borough Park Branch Library (LL84) BROOKLYN 1265 43rd St Library 19,594 86.2 48834.11 35.2 50.9 86.2 88.7   0.0     63.2
107054 107054 2017 6,297,203 NYPL - 1048501 - 96th Street Branch Library (LL84) MANHATTAN 112 East 96th St Library 13,615 79.2 65576.99 30.6 48.6 79.2 88.7   0.0     82.6
107067 107067 2017 6,297,161 NYPL - 2018123 - Mosholu Branch Library (LL84) BRONX 285 East 205th St Library 10,285 68.3 73517.44 29.8 38.4 68.3 88.7   0.0     96.8
107078 107078 2017 6,294,036 BPL - 3060090 - Williamsburg Branch Library (LL84) BROOKLYN 240 Division Ave Library 24,118 127.4 57138.37 56.1 71.3 127.4 88.7   0.0     77.1
107082 107082 2017 6,297,210 NYPL - 1026706 - Columbus Branch Library (LL84) MANHATTAN 742 10th Ave Library 11,554 75.0 73390.23 36.6 38.5 75.0 88.7   0.0     97.1
107083 107083 2017 6,297,211 NYPL - 1058275 - Countee Cullen Branch Library (LL84) MANHATTAN 104 West 136th St Library 23,345 326.4 152753.78 240.6 85.8 326.4 88.7   0.0     235.5
107084 107084 2017 6,297,217 NYPL - 1061938 - Hamilton Grange Branch Library (LL84) MANHATTAN 503 West 145th St Library 20,403 121.7 65498.33 42.9 78.7 121.7 88.7   0.0     83.1
107085 107085 2017 6,297,265 NYPL - 2004700 - Woodstock Branch Library (LL84) BRONX 761 East 160th St Library 16,524 43.3 29129.8 0.0 43.3 43.3 88.7   0.0     29.6
107094 107094 2017 6,297,309 QPL - 4029693 - Jackson Heights Community Library (LL84) QUEENS 35-51 81st St Library 18,038 93.3 55792.88 18.2 75.0 93.3 88.7   0.0     69.6
107151 107151 2017 6,293,995 BPL - 3106505 - Crown Heights Branch Library (LL84) (Leased In) BROOKLYN 560 New York Ave Library 11,119 51.8 50688.18 14.9 36.9 51.8 88.7   0.0     62.6
107152 107152 2017 6,294,011 BPL - 3202630 - Kings Bay Branch Library (LL84) BROOKLYN 3651 Nostrand Ave Library 14,885 142.7 109714.89 63.7 79.0 142.7 88.7   0.0     140.4
107231 107231 2017 6,297,407 BPL - 3245028 - Brighton Beach Branch Library (LL84) BROOKLYN 16 Brighton 1st Road Library 12,166 62.9 56420.78 18.4 44.5 62.9 88.7   0.0     69.8
107300 107300 2017 6,293,989 BPL - 3004336 - Carroll Gardens Branch Library (LL84) BROOKLYN 396 Clinton St Library 14,779 73.8 56741.13 34.9 38.8 73.8 88.7   0.0     74.1
107301 107301 2017 6,293,993 BPL - 3189001 - Coney Island Branch Library and Learning Ctr. (LL84) BROOKLYN 1901 Mermaid Ave Library 12,087 71.8 64404.0 21.9 49.9 71.8 88.7   0.0     80.7
107316 107316 2017 6,294,000 BPL - 3037543 - Eastern Parkway Branch Library and Learning Center (LL84) BROOKLYN 1044 Eastern Pkwy Library 16,024 110.6 74405.46 53.1 57.5 110.6 88.7   0.0     102.9

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