Summary — Key Metrics (start here)
Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability
127 rows where Calendar Year = 2022 and Property Type = "Other - Lodging/Residential" sorted by Calendar Year descending
This data as json, CSV (advanced)
Suggested facets: Number of Buildings, District Steam Use (kBtu), Fuel Oil #2 Use (kBtu)
| Link | rowid | Calendar Year ▲ | Property ID | Property Name | Borough | Address 1 | Postal Code | Property Type | Floor Area (ft2) | Year Built | Number of Buildings | ENERGY STAR Score | Site EUI (kBtu/ft2) | Weather Norm Site EUI (kBtu/ft2) | Source EUI (kBtu/ft2) | Total GHG (MtCO2e) | GHGI (kgCO2e/m2) | Direct GHG (MtCO2e) | Indirect GHG (MtCO2e) | Electricity (kBtu) | Natural Gas Use (kBtu) | District Steam Use (kBtu) | Fuel Oil #2 Use (kBtu) | Fuel Oil #4 Use (kBtu) | Fuel Oil #5 & 6 Use (kBtu) | Water Use (kgal) | BBL | BIN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 242466 | 242466 | 2022 | 26605742 | Covenant House New York | MANHATTAN | 460 West 41st Street | 10036 | Other - Lodging/Residential | 80,496 | 2021 | 1 | Not Available | 55.1 | 55.1 | 151.7 | 371.3 | 49.51 | 6.6 | 364.6 | 4312959.2 | 125100.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1010500001 | 1080922 , 1080924 |
| 245609 | 245609 | 2022 | 6813940 | POWELL REALTY HOLDING | BROOKLYN | 313 POWELL STREET | 11212 | Other - Lodging/Residential | 52,431 | 2020 | 1 | Not Available | 20.0 | 20.0 | 21.9 | 56.7 | 11.84 | 54.4 | 2.3 | 27261.9 | 1023300.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3037630003 | 3426500 |
| 246571 | 246571 | 2022 | 21821063 | 253 Empire Bvd. aka 375 Rogers Ave | BROOKLYN | 253 Empire Bvd | 11230 | Other - Lodging/Residential | 64,366 | 2021 | 1 | Not Available | 44.0 | 44.0 | 93.8 | 205.4 | 34.44 | 57.5 | 147.9 | 1749653.1 | 1082900.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3013087501 | 3426422;3337871 |
| 250312 | 250312 | 2022 | 28457815 | 1084 OGDEN AVENUE | BRONX | 1084 Ogden Ave | 10452 | Other - Lodging/Residential | 29,070 | 2021 | 1 | Not Available | 55.7 | 55.7 | 119.7 | 118.0 | 44.13 | 32.1 | 85.9 | 1015916.2 | 604600.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1156.2 | 2025140011 | 2129599 |
| 252980 | 252980 | 2022 | 8151625 | 163-03 89 Avenue | QUEENS | 163-03 89 Avenue | 11432 | Other - Lodging/Residential | 39,000 | 1957 | 1 | Not Available | 171.3 | 175.5 | 203.4 | 492.2 | 135.63 | 437.1 | 55.0 | 650972.1 | 496270.9 | 0.0 | 5535262.9 | 0.0 | 0.0 | 4420.2 | 4098130001 | 4210032 |
| 254911 | 254911 | 2022 | 12815261 | 175 West 137th Street, New York, NY | MANHATTAN | 175 West 137th Street | 10030 | Other - Lodging/Residential | 26,250 | 1931 | 1 | Not Available | 67.8 | 67.3 | 143.2 | 128.5 | 52.74 | 37.2 | 91.4 | 1080594.1 | 699516.7 | 0.0 | 0.0 | 0.0 | 0.0 | 3203.5 | 102006/0007 | 1081808 |
| 255206 | 255206 | 2022 | 10882565 | Eastview Independent Senior Living | MANHATTAN | 2306 3rd ave | 10035 | Other - Lodging/Residential | 316,658 | 2019 | 1 | Not Available | 24.1 | 24.2 | 49.9 | 544.9 | 18.3 | 169.1 | 375.8 | 4445139.9 | 3183596.1 | 0.0 | 0.0 | 0.0 | 0.0 | 336.2 | 1017740033 | 1090826 |
| 257972 | 257972 | 2022 | 3187683 | Jacob Shafran - 599 Ralph Ave | BROOKLYN | 599 Ralph Ave | 11233 | Other - Lodging/Residential | 52,100 | 1921 | 1 | Not Available | 70.1 | 69.0 | 140.1 | 256.2 | 52.74 | 89.0 | 167.2 | 1978103.6 | 1675500.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3014750004 | 3330725 |
| 259855 | 259855 | 2022 | 6187155 | URHE / 308-308 West 144 Street | 304-308 | 10030 | Other - Lodging/Residential | 29,365 | 1920 | 1 | Not Available | 134.2 | 135.7 | 219.4 | 250.7 | 91.49 | 139.5 | 111.3 | 1316431.5 | 2625499.8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1020440017 | 1060778 | |
| 259856 | 259856 | 2022 | 6187161 | URI / 1011 Ocean Ave | 1011 | 11226 | Other - Lodging/Residential | 36,000 | 1931 | 1 | Not Available | 29.1 | 28.7 | 73.3 | 83.3 | 24.76 | 8.8 | 74.4 | 880070.9 | 166600.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3391.7 | 3052200040 | 3120583 | |
| 259857 | 259857 | 2022 | 7084774 | 2170 Prospect Avenue LLC | BRONX | 2170 Prospect Avenue | 10457 | Other - Lodging/Residential | 36,699 | 2014 | 1 | Not Available | 119.1 | 122.4 | 166.3 | 259.3 | 76.42 | 186.2 | 73.1 | 864471.2 | 3506199.7 | 0.0 | 0.0 | 0.0 | 0.0 | 3529.3 | 2031100054 | 2128907 |
| 259858 | 259858 | 2022 | 12881549 | NAICA / 1527 SOUTHERN FEE OWNER LLC | BRONX | 1521 Southern BLVD. | 10460 | Other - Lodging/Residential | 35,000 | 2018 | 1 | Not Available | 90.6 | 90.6 | 151.7 | 204.0 | 62.43 | 108.3 | 95.7 | 1131982.2 | 2038100.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2029777501 | 2010519 |
| 259859 | 259859 | 2022 | 16775245 | Urban Resource Institute /926 Southern Blvd. | BRONX | 926 Southern Blvd | 10459 | Other - Lodging/Residential | 54,460 | 1911 | 1 | Not Available | 77.8 | 78.6 | 155.6 | 297.4 | 59.2 | 103.1 | 194.2 | 2297637.4 | 1941600.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2027357501 | 2005883 |
| 259860 | 259860 | 2022 | 20790743 | 1535 Taylor Ave. | BRONX | 1535 Taylor Ave. | 10456 | Other - Lodging/Residential | 32,910 | 2021 | 1 | Not Available | 13.3 | 13.3 | 23.4 | 34.3 | 10.76 | 18.9 | 15.4 | 182221.3 | 2200.0 | 0.0 | 253644.0 | 0.0 | 0.0 | 2448.8 | 2039200005 | 2028627 |
| 259861 | 259861 | 2022 | 26598736 | 1604/ St Johns Place Family Center Housing Development | BROOKLYN | 1604 St Johns Place | 11233 | Other - Lodging/Residential | 46,600 | 1924 | 1 | Not Available | 54.6 | 56.4 | 79.1 | 153.3 | 35.52 | 104.2 | 49.1 | 581046.6 | 1961300.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3046.3 | 3013870013 | 3037202;3037203 |
| 259862 | 259862 | 2022 | 26598751 | 1620/ St Johns Place Family Center Housing Development | BROOKLYN | 1620 St Johns Place | 11233 | Other - Lodging/Residential | 47,600 | 1924 | 1 | Not Available | 70.2 | 72.7 | 83.6 | 185.9 | 41.98 | 163.1 | 22.9 | 270721.7 | 3069799.9 | 0.0 | 0.0 | 0.0 | 0.0 | 1602.3 | 3013870024 | 3037204 |
| 259863 | 259863 | 2022 | 26598752 | 1630/ St Johns Place Family Center Housing Development | BROOKLYN | 1630 St Johns Place | 11233 | Other - Lodging/Residential | 45,360 | 1924 | 1 | Not Available | 15.7 | 15.7 | 38.3 | 55.6 | 12.92 | 7.8 | 47.8 | 565443.5 | 147200.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1332.3 | 3013870029 | 3037205 |
| 259864 | 259864 | 2022 | 28499930 | URI/ 84-42 Smedley Street | QUEENS | 84-42 Smedley Street | 11435 | Other - Lodging/Residential | 39,898 | 2021 | 1 | Not Available | 67.4 | 66.6 | 107.3 | 169.0 | 45.21 | 98.6 | 70.4 | 833005.7 | 1856499.9 | 0.0 | 0.0 | 0.0 | 0.0 | 1612.7 | 4097360141 | 4208450 |
| 260264 | 260264 | 2022 | 2787516 | 93 Jamaica Realty, LLC | QUEENS | 170-02 93rd Ave | 11433 | Other - Lodging/Residential | 54,615 | 2006 | 1 | Not Available | 83.0 | 84.6 | 122.5 | 275.5 | 53.82 | 182.1 | 93.4 | 1104403.0 | 3429000.2 | 0.0 | 0.0 | 0.0 | 0.0 | 7753.3 | 4-10219-0001 | 4217650 |
| 260265 | 260265 | 2022 | 2787543 | Willow, LLC | BRONX | 190 Willow Ave. | 10454 | Other - Lodging/Residential | 54,684 | 1931 | 1 | Not Available | 122.7 | 125.3 | 218.7 | 444.6 | 87.19 | 207.3 | 237.3 | 2807052.3 | 3902999.8 | 0.0 | 0.0 | 0.0 | 0.0 | 9166.6 | 2-02588-0001 | 2003998 |
| 260266 | 260266 | 2022 | 2787550 | Hillside Avenue Development, LLC | QUEENS | 160-11 89th Avenue | 11432 | Other - Lodging/Residential | 58,625 | 1927 | 1 | Not Available | 145.4 | 148.0 | 197.4 | 499.9 | 91.49 | 373.2 | 126.7 | 1498376.4 | 7026800.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4-09764-0091 | 4813452 |
| 260267 | 260267 | 2022 | 2787552 | Junius (23-25 Junius St.) Development, LLC | BROOKLYN | 23-25 Junius St. | 11212 | Other - Lodging/Residential | 65,500 | 1927 | 1 | Not Available | 61.8 | 63.0 | 64.9 | 215.2 | 35.52 | 215.2 | 0.0 | 0.0 | 4051099.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3-03679-0022 | 3378454 |
| 260268 | 260268 | 2022 | 2787554 | Junius (1 Junius St.) Development, LLC | BROOKLYN | 1 JUNIUS ST | 11212 | Other - Lodging/Residential | 65,500 | 1927 | 1 | Not Available | 193.0 | 193.3 | 448.6 | 960.7 | 158.23 | 182.5 | 778.2 | 9204658.1 | 3436500.1 | 0.0 | 0.0 | 0.0 | 0.0 | 29255.4 | 3-03679-0030 | 3083426 |
| 260269 | 260269 | 2022 | 2787559 | Junius Liberty Development, LLC | BROOKLYN | 73 Junius St. | 11212 | Other - Lodging/Residential | 141,500 | 1928 | 1 | Not Available | 110.3 | 111.8 | 187.2 | 1010.3 | 76.42 | 522.2 | 488.1 | 5773718.3 | 9831200.3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3-03679-0001 | 3083424 |
| 260271 | 260271 | 2022 | 2793060 | 104th Street Realty, LLC | MANHATTAN | 325 East 104th St. | 10029 | Other - Lodging/Residential | 101,375 | 1910 | 1 | Not Available | 101.1 | 102.0 | 158.2 | 639.1 | 67.81 | 383.9 | 255.2 | 3018350.8 | 7227500.0 | 0.0 | 0.0 | 0.0 | 0.0 | 8340.1 | 1-01676-0011 | 1052712 |
| 260285 | 260285 | 2022 | 2954490 | 3339 Park LLC | BRONX | 3339 Park Avenue | 10456 | Other - Lodging/Residential | 65,700 | 1920 | 1 | Not Available | 65.2 | 65.3 | 150.9 | 324.8 | 52.74 | 63.0 | 261.8 | 3097243.0 | 1185700.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2-02424-0053 | 2097112 |
| 260295 | 260295 | 2022 | 4046570 | DWN MANAGEMENT INC | BROOKLYN | 1226 FLUSHING AVE | 11237 | Other - Lodging/Residential | 65,402 | 1931 | 1 | Not Available | 114.7 | 117.0 | 234.6 | 532.6 | 87.19 | 171.8 | 360.8 | 4267558.9 | 3234800.3 | 0.0 | 0.0 | 0.0 | 0.0 | 7690.0 | 3-03168-0001 | 3072163 |
| 260296 | 260296 | 2022 | 4409117 | Beach 65, LLC | QUEENS | 316 BEACH 65th ST | 11692 | Other - Lodging/Residential | 65,000 | 1976 | 1 | Not Available | 124.3 | 124.3 | 207.9 | 519.4 | 86.11 | 276.3 | 243.2 | 2876452.6 | 5201376.9 | 0.0 | 0.0 | 0.0 | 0.0 | 5843.0 | 4-15908-0007 | 4301969 |
| 260297 | 260297 | 2022 | 4988475 | 7900 Development, LLC | QUEENS | 7900 Queens Boulevard | 11373 | Other - Lodging/Residential | 92,400 | 1963 | 1 | Not Available | 155.0 | 157.9 | 228.8 | 1101.5 | 128.09 | 786.6 | 315.0 | 3725467.5 | 0.0 | 0.0 | 10599407.5 | 0.0 | 0.0 | 33042.2 | 4-02453-0040 | 4056461 |
| 260300 | 260300 | 2022 | 6271302 | 1564 Development, LLC | BRONX | 1564 St Peters Avenue | 10461 | Other - Lodging/Residential | 34,595 | 2005 | 1 | Not Available | 106.1 | 107.0 | 188.9 | 243.1 | 75.35 | 113.6 | 129.5 | 1531339.7 | 2139100.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2-03986-0007 | 2041898 |
| 260302 | 260302 | 2022 | 6429656 | 3600 Jerome LLC | BRONX | 3600 Jerome Avenue | 10467 | Other - Lodging/Residential | 79,275 | 1929 | 1 | Not Available | 54.1 | 53.7 | 126.5 | 350.9 | 47.36 | 81.7 | 269.2 | 3184525.6 | 0.0 | 0.0 | 1100549.9 | 0.0 | 0.0 | 2951.8 | 2-03329-0085 | 2017852 |
| 260328 | 260328 | 2022 | 6618686 | 4747 Bronx Boulevard Realty, LLC | BRONX | 4747 Bronx Boulevard | 10470 | Other - Lodging/Residential | 43,700 | 1926 | 1 | Not Available | 75.6 | 76.6 | 162.0 | 240.4 | 59.2 | 65.9 | 174.4 | 2063396.7 | 1241300.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1361.5 | 2-05102-0027 | 2071640 |
| 260330 | 260330 | 2022 | 6675610 | 500 East 134th Owners, LLC | BRONX | 500 East 134th Street | 10454 | Other - Lodging/Residential | 41,080 | 1931 | 1 | Not Available | 66.3 | 66.3 | 143.0 | 198.8 | 51.67 | 53.1 | 145.7 | 1723622.9 | 999400.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2-02261-0005 | 2092081 |
| 260331 | 260331 | 2022 | 6675611 | CAPRI WHITESTONE LLC | BRONX | 555 Hutchinson River Parkway | 10465 | Other - Lodging/Residential | 33,320 | 1962 | 1 | Not Available | 152.0 | 153.7 | 295.9 | 403.2 | 130.24 | 179.2 | 224.0 | 2649547.6 | 0.0 | 0.0 | 2415262.2 | 0.0 | 0.0 | 0.0 | 2-05610-0087 | 2081724 |
| 260332 | 260332 | 2022 | 6675619 | Westway Associates, LLC | QUEENS | 71-11 Astoria Boulevard N | 11370 | Other - Lodging/Residential | 38,160 | 1961 | 1 | Not Available | 194.7 | 198.9 | 278.2 | 569.3 | 160.38 | 422.4 | 146.9 | 1738185.4 | 0.0 | 0.0 | 5691837.8 | 0.0 | 0.0 | 5794.4 | 4-01003-0011 | 4021796 |
| 260333 | 260333 | 2022 | 6679816 | Broadway Bronx Motel Company | BRONX | 2244 Tillotson Avenue | 10475 | Other - Lodging/Residential | 41,952 | 1960 | 1 | Not Available | 124.9 | 127.1 | 194.9 | 326.3 | 83.96 | 197.2 | 129.1 | 1527375.0 | 3712799.9 | 0.0 | 0.0 | 0.0 | 0.0 | 10087.5 | 2-05245-0001 | 2072410 |
| 260340 | 260340 | 2022 | 6693135 | 470 EAST 161 LLC | BRONX | 470 EAST 161 Street | 10451 | Other - Lodging/Residential | 62,717 | 1951 | 1 | Not Available | 94.4 | 95.9 | 185.6 | 411.9 | 71.04 | 149.8 | 262.1 | 3100170.3 | 2820700.4 | 0.0 | 0.0 | 0.0 | 0.0 | 2809.2 | 2-02382-0048 | 2001501 |
| 260341 | 260341 | 2022 | 6693144 | Emmons Development, LLC | BROOKLYN | 3154 Emmons Avenue | 11235 | Other - Lodging/Residential | 32,009 | 1980 | 1 | Not Available | 164.7 | 166.9 | 336.8 | 374.2 | 125.94 | 120.8 | 253.4 | 2997647.0 | 2273400.1 | 0.0 | 0.0 | 0.0 | 0.0 | 9189.8 | 3-08815-0101 | 3248044 |
| 260342 | 260342 | 2022 | 6693147 | 745 East 178 LLC | BRONX | 745 East 178th Street | 10457 | Other - Lodging/Residential | 26,200 | 1915 | 1 | Not Available | 152.3 | 155.8 | 188.5 | 301.3 | 123.78 | 258.4 | 42.9 | 507528.2 | 0.0 | 0.0 | 3482264.3 | 0.0 | 0.0 | 3307.1 | 2-03093-0032 | 2012644 |
| 260343 | 260343 | 2022 | 6693153 | Putnam Equities, LLC | BROOKLYN | 1149 Putnam Avenue | 11221 | Other - Lodging/Residential | 36,000 | 1935 | 1 | Not Available | 131.4 | 135.5 | 158.0 | 264.2 | 78.58 | 229.3 | 34.9 | 412626.8 | 4316899.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3-03367-0056 | 3077002 |
| 260344 | 260344 | 2022 | 6693159 | 321 East Tremont, LLC | BRONX | 321 East Tremont Avenue | 10457 | Other - Lodging/Residential | 25,440 | 1920 | 1 | Not Available | 107.8 | 106.9 | 199.5 | 185.1 | 78.58 | 79.1 | 106.0 | 1254237.5 | 1488300.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2-02814-0017 | 2007764 |
| 260346 | 260346 | 2022 | 6701567 | 1387 Realty, LLC | BRONX | 1387 Grand Concourse | 10453 | Other - Lodging/Residential | 33,420 | 1923 | 1 | Not Available | 157.5 | 161.1 | 201.7 | 301.4 | 96.88 | 242.8 | 58.6 | 693376.5 | 4570699.7 | 0.0 | 0.0 | 0.0 | 0.0 | 6992.3 | 2-02842-0065 | 2008088 |
| 260348 | 260348 | 2022 | 6795412 | New Syndicate LLC | MANHATTAN | 316 West 97th Street | 10025 | Other - Lodging/Residential | 32,046 | 1920 | 1 | Not Available | 147.1 | 150.5 | 204.0 | 278.9 | 93.65 | 202.2 | 76.7 | 907383.8 | 3806600.3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1-01887-0031 | 1057063 |
| 260350 | 260350 | 2022 | 6797457 | 249 Varet LLC | BROOKLYN | 249 Varet Street | 11206 | Other - Lodging/Residential | 26,400 | 1931 | 1 | Not Available | 78.7 | 80.2 | 139.5 | 137.4 | 55.97 | 64.9 | 72.5 | 857551.6 | 1221400.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3-03110-0028 | 3325981 |
| 260353 | 260353 | 2022 | 6897863 | 286 Audubon Holdings, LLC | MANHATTAN | 286 Audubon Avenue | 10033 | Other - Lodging/Residential | 29,460 | 1931 | 1 | Not Available | 59.9 | 60.0 | 131.4 | 129.9 | 47.36 | 32.4 | 97.5 | 1153245.7 | 610100.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1-02153-0047 | 1063629 |
| 260354 | 260354 | 2022 | 6932877 | West Canyon, LLC | QUEENS | 132-10 South Conduit Ave., Queens | 11430 | Other - Lodging/Residential | 29,000 | 1959 | 1 | Not Available | 167.3 | 171.6 | 240.2 | 291.3 | 107.64 | 201.0 | 90.4 | 1068901.1 | 3783600.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4-11886-0016 | 4257536 |
| 260365 | 260365 | 2022 | 8720174 | S and Z Associates, LLC | QUEENS | 87-02 23rd Avenue | 11369 | Other - Lodging/Residential | 38,260 | 1940 | 1 | Not Available | 140.6 | 142.1 | 220.5 | 335.8 | 94.72 | 201.1 | 134.7 | 1593260.7 | 3786400.2 | 0.0 | 0.0 | 0.0 | 0.0 | 4982.0 | 4-01082-0001 | 4023533 |
| 260368 | 260368 | 2022 | 10829269 | 127-03 20th Avenue LLC | QUEENS | 127-03 20th Avenue | 11356 | Other - Lodging/Residential | 42,208 | 1925 | 1 | Not Available | 90.6 | 92.5 | 168.8 | 259.0 | 65.66 | 108.9 | 150.1 | 1775116.8 | 2050600.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4-04133-0001 | 4098952 |
| 260371 | 260371 | 2022 | 11662745 | 691 East 140 LLC | BRONX | 691 East 140 Street | 10454 | Other - Lodging/Residential | 25,247 | 2006 | 1 | Not Available | 77.8 | 79.3 | 112.5 | 118.3 | 50.59 | 80.7 | 37.6 | 445098.8 | 1519000.0 | 0.0 | 0.0 | 0.0 | 0.0 | 334.8 | 2025680073 | 2117333 |
| 260388 | 260388 | 2022 | 22861965 | King David of Brooklyn | BROOKLYN | 2316 Surf Avenue | 11224 | Other - Lodging/Residential | 40,344 | 1978 | 1 | Not Available | 52.6 | 52.6 | 138.4 | 173.0 | 46.28 | 11.0 | 162.0 | 1916134.8 | 207000.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3-07070-0120 | 3189629 |
| 260393 | 260393 | 2022 | 26649283 | Junius Development LLC-Campus | BROOKLYN | 1-23 Junius Street | 11212 | Other - Lodging/Residential | 131,000 | 1927 | 2 | Not Available | 127.4 | 127.9 | 256.8 | 1175.9 | 96.88 | 397.7 | 778.2 | 9204658.1 | 7487599.8 | 0.0 | 0.0 | 0.0 | 0.0 | 29255.4 | 3-03679-0030;3-03679-0022 | 3083426;3378454 |
| 267113 | 267113 | 2022 | 15045087 | 2006 MADISON AVENUE | MANHATTAN | 2006 MADISON AVENUE | 10035 | Other - Lodging/Residential | 28,800 | 2002 | 1 | Not Available | 99.6 | 98.6 | 204.0 | 203.8 | 76.42 | 65.5 | 138.3 | 1636019.9 | 1233499.9 | 0.0 | 0.0 | 0.0 | 0.0 | 138.4 | 1017520057 | 1087856 |
| 267115 | 267115 | 2022 | 15055743 | 511 EAST 164 STREET | BRONX | 511 EAST 164 STREET | 10456 | Other - Lodging/Residential | 30,999 | 2017 | 1 | Not Available | 72.5 | 73.3 | 159.4 | 165.7 | 57.05 | 40.9 | 124.7 | 1475543.3 | 770500.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2023690045 | 2001246 |
| 267123 | 267123 | 2022 | 15362796 | 1055 DR M L KING JR BOULEVARD | BRONX | 1055 DR M L KING JR BOULEVARD | 10452 | Other - Lodging/Residential | 89,457 | 1927 | 1 | Not Available | 96.6 | 98.9 | 126.9 | 500.1 | 60.28 | 390.1 | 110.0 | 1301357.3 | 7343700.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2025270061 | 2003497 |
| 267124 | 267124 | 2022 | 15363025 | 1195 SHERMAN AVENUE | BRONX | 1195 SHERMAN AVENUE | 10456 | Other - Lodging/Residential | 28,000 | 2003 | 1 | Not Available | 147.7 | 152.0 | 179.7 | 232.0 | 89.34 | 198.7 | 33.4 | 394642.2 | 3740699.8 | 0.0 | 0.0 | 0.0 | 0.0 | 3700.6 | 2024560237 | 2002759 |
| 267125 | 267125 | 2022 | 15363107 | 1387 GRAND CONCOURSE | BRONX | 1387 GRAND CONCOURSE | 10452 | Other - Lodging/Residential | 33,420 | 1923 | 1 | Not Available | 157.5 | 161.1 | 201.7 | 301.4 | 96.88 | 242.8 | 58.6 | 693376.5 | 4570699.7 | 0.0 | 0.0 | 0.0 | 0.0 | 6992.3 | 2028420065 | 2008088 |
| 267126 | 267126 | 2022 | 15363163 | 1802 CROTONA AVENUE | BRONX | 1802 CROTONA AVENUE | 10457 | Other - Lodging/Residential | 49,207 | 2014 | 1 | Not Available | 78.0 | 79.9 | 113.4 | 231.6 | 50.59 | 156.7 | 75.0 | 886778.8 | 2949599.7 | 0.0 | 0.0 | 0.0 | 0.0 | 4526.9 | 2029480003 | 2129071;2806601;2806600 |
| 267127 | 267127 | 2022 | 15363317 | 1838 VYSE AVENUE | BRONX | 1838 VYSE AVENUE | 10460 | Other - Lodging/Residential | 44,525 | 2001 | 1 | Not Available | 36.3 | 36.3 | 64.4 | 106.8 | 25.83 | 50.4 | 56.5 | 667960.4 | 948100.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2029980029 | 2010809 |
| 267128 | 267128 | 2022 | 15363446 | 2346 PROSPECT AVENUE | BRONX | 2346 PROSPECT AVENUE | 10460 | Other - Lodging/Residential | 30,508 | 2015 | 1 | Not Available | 91.7 | 93.1 | 149.2 | 177.6 | 62.43 | 99.7 | 77.9 | 921263.9 | 1877100.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2603.8 | 2031140044 | 2129001;2127019;2013042 |
| 267129 | 267129 | 2022 | 15363812 | 463 EAST 173 STREET | 463 EAST 173 STREET | 10457 | Other - Lodging/Residential | 54,700 | 1945 | 1 | Not Available | 113.6 | 112.6 | 171.2 | 381.0 | 75.35 | 243.7 | 137.3 | 1623893.6 | 4588599.9 | 0.0 | 0.0 | 0.0 | 0.0 | 4961.3 | 2029060093 | 2094575;2094576;2817131;2817132;2817133;2124550;2094574 | |
| 267130 | 267130 | 2022 | 15364020 | 1138 TELLER AVENUE | BRONX | 1138 TELLER AVENUE | 10456 | Other - Lodging/Residential | 30,165 | 2015 | 1 | Not Available | 71.5 | 72.4 | 120.6 | 139.2 | 49.51 | 72.9 | 66.3 | 784323.3 | 1372700.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2024290012 | 2124470;2002142 |
| 267841 | 267841 | 2022 | 6249896 | Concourse House | BRONX | 2751 Grand Concourse | 10468 | Other - Lodging/Residential | 42,288 | 1930 | 1 | Not Available | 121.6 | 126.1 | 167.0 | 303.0 | 77.5 | 222.6 | 80.4 | 951252.0 | 4190200.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2-03315-0001 | 2110098 |
| 269620 | 269620 | 2022 | 21353767 | Benchmarking Group - 121 | Classified DHS Location | 11205 | Other - Lodging/Residential | 295,300 | 1952 | 4 | Not Available | 88.1 | 90.3 | 155.9 | 1718.2 | 62.43 | 814.7 | 903.5 | 10687606.4 | 15337669.8 | 0.0 | 0.0 | 0.0 | 0.0 | 3929.9 | 3020390101 | 3251647 | |
| 269621 | 269621 | 2022 | 21353768 | DHS_10348_Classified DHS Location | Classified DHS Location | 11205 | Other - Lodging/Residential | 77,910 | 1952 | 0 | Not Available | 137.2 | 135.4 | 384.1 | 903.5 | 124.86 | 0.0 | 903.5 | 10687606.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3020390101 | 3251647 | |
| 270198 | 270198 | 2022 | 21354352 | DOC_1171_Rikers Island DOI/IG | QUEENS | Rikers Island | 11370 | Other - Lodging/Residential | 3,200 | 1970 | 0 | Not Available | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026050040 | 0 |
| 270202 | 270202 | 2022 | 21354356 | DOC_1175_Rikers Island SOD Visits / NSD / Law library | QUEENS | Rikers Island | 11370 | Other - Lodging/Residential | 3,200 | 1970 | 0 | Not Available | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026050040 | 0 |
| 270206 | 270206 | 2022 | 21354360 | DOC_1179_Rikers Island ASRS Locker Room | QUEENS | Rikers Island | 11370 | Other - Lodging/Residential | 8,000 | 1970 | 0 | Not Available | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026050040 | 0 |
| 270207 | 270207 | 2022 | 21354361 | DOC_1180_Rikers Island Compost Facility | QUEENS | Rikers Island | 11370 | Other - Lodging/Residential | 9,000 | 1970 | 0 | Not Available | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026050040 | 0 |
| 270208 | 270208 | 2022 | 21354362 | DOC_1181_Rikers Island DCJC / OT CTRL | QUEENS | Rikers Island | 11370 | Other - Lodging/Residential | 4,800 | 1970 | 0 | Not Available | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026050040 | 0 |
| 270209 | 270209 | 2022 | 21354363 | DOC_1182_Rikers Island DIV 1 & 2 / OPC | QUEENS | Rikers Island | 11370 | Other - Lodging/Residential | 2,400 | 1970 | 0 | Not Available | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026050040 | 0 |
| 270236 | 270236 | 2022 | 21354390 | DOC_1209_Rikers Island Bridge Abutment Checkpoint | QUEENS | Rikers Island | 11370 | Other - Lodging/Residential | 600 | 1968 | 1 | Not Available | 566.8 | 566.8 | 1587.0 | 28.7 | 515.59 | 0.0 | 28.7 | 340064.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026050040 | 0 |
| 270372 | 270372 | 2022 | 21354526 | Benchmarking Group - 37 | Classified DHS Location | 11207 | Other - Lodging/Residential | 39,600 | 1954 | 2 | Not Available | 117.0 | 118.0 | 154.1 | 268.3 | 73.19 | 208.4 | 59.9 | 708043.0 | 3923544.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3646.3 | 3040770024; 3040770028 | 3090429; 3090430 | |
| 270373 | 270373 | 2022 | 21354527 | DHS_922_Classified DHS Location | Classified DHS Location | 11207 | Other - Lodging/Residential | 21,600 | 1930 | 1 | Not Available | 95.9 | 97.8 | 126.8 | 120.2 | 60.28 | 92.9 | 27.3 | 322659.2 | 1748809.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3040770028 | 3090430 | |
| 270374 | 270374 | 2022 | 21354528 | DHS_923_Classified DHS Location | Classified DHS Location | 11207 | Other - Lodging/Residential | 18,000 | 1930 | 1 | Not Available | 142.2 | 144.8 | 186.8 | 148.1 | 88.26 | 115.5 | 32.6 | 385383.8 | 2174735.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3040770024 | 3090429 | |
| 270817 | 270817 | 2022 | 21354995 | Benchmarking Group - 82 | Confidential DHS Location | 10039 | Other - Lodging/Residential | 41,872 | 1954 | 2 | Not Available | 192.6 | 189.0 | 249.2 | 611.5 | 157.15 | 503.4 | 108.2 | 1279638.8 | 5215.0 | 0.0 | 6779263.6 | 0.0 | 0.0 | 8306.0 | 1021050001 | 1076737; 1087016 | |
| 270818 | 270818 | 2022 | 21354996 | DHS_1115_Classified DHS Location | Classified DHS Location | 10039 | Other - Lodging/Residential | 41,446 | 1954 | 1 | Not Available | 193.6 | 189.9 | 249.0 | 608.1 | 158.23 | 503.4 | 104.7 | 1238749.9 | 5215.0 | 0.0 | 6779263.6 | 0.0 | 0.0 | 0.0 | 1021050001 | 1076737 | |
| 271004 | 271004 | 2022 | 21355183 | DHS_912_Classified DHS Location | Classified DHS Location | 11212 | Other - Lodging/Residential | 60,000 | 1991 | 1 | Not Available | 105.3 | 106.6 | 162.2 | 391.1 | 69.97 | 241.4 | 149.7 | 1770350.3 | 4545177.9 | 0.0 | 0.0 | 0.0 | 0.0 | 4892.7 | 3014720001 | 3319475 | |
| 271005 | 271005 | 2022 | 21355184 | DHS_913_Classified DHS Location | Classified DHS Location | 11212 | Other - Lodging/Residential | 42,000 | 1930 | 1 | Not Available | 74.9 | 76.4 | 84.7 | 171.6 | 44.13 | 159.3 | 12.3 | 145538.1 | 2998333.8 | 0.0 | 0.0 | 0.0 | 0.0 | 3535.1 | 3035830006 | 3082035 | |
| 271006 | 271006 | 2022 | 21355185 | DHS_919_Classified DHS Location | Classified DHS Location | 11207 | Other - Lodging/Residential | 12,000 | 1920 | 1 | Not Available | 216.1 | 219.9 | 269.0 | 146.8 | 131.32 | 122.4 | 24.4 | 288440.3 | 2305272.8 | 0.0 | 0.0 | 0.0 | 0.0 | 2175.9 | 3038440001 | 3085646 | |
| 271007 | 271007 | 2022 | 21355186 | DHS_920_Classified DHS Location | Classified DHS Location | 11221 | Other - Lodging/Residential | 235,200 | 1910 | 1 | Not Available | 57.6 | 60.4 | 68.0 | 1012.0 | 46.28 | 903.3 | 108.7 | 1285461.6 | 330044.0 | 0.0 | 11935965.3 | 0.0 | 0.0 | 3928.8 | 3016490001 | 3045367 | |
| 271008 | 271008 | 2022 | 21355187 | DHS_921_Classified DHS Location | Classified DHS Location | 11215 | Other - Lodging/Residential | 109,556 | 1931 | 1 | Not Available | 198.7 | 203.3 | 332.0 | 1398.9 | 137.78 | 745.8 | 653.1 | 7725805.2 | 14040362.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3011020012 | 3026581 | |
| 271034 | 271034 | 2022 | 21355213 | DHS_1110_Classified DHS Location | Classified DHS Location | 10016 | Other - Lodging/Residential | 480,000 | 1910 | 1 | Not Available | 90.4 | 93.5 | 120.9 | 2948.6 | 65.66 | 0.0 | 2948.6 | 3652368.8 | 0.0 | 39756847.2 | 0.0 | 0.0 | 0.0 | 0.0 | 1009620097 | 1087298 | |
| 271035 | 271035 | 2022 | 21355214 | DHS_1112_Classified DHS Location | Classified DHS Location | 10035 | Other - Lodging/Residential | 65,510 | 1988 | 1 | Not Available | 103.1 | 105.1 | 161.0 | 420.8 | 68.89 | 253.6 | 167.2 | 1977267.7 | 4775055.3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1017450005 | 1076434 | |
| 271036 | 271036 | 2022 | 21355215 | DHS_1113_Classified DHS Location | Classified DHS Location | 10032 | Other - Lodging/Residential | 249,473 | 1944 | 1 | Not Available | 77.4 | 0.0 | 141.5 | 1312.2 | 57.05 | 585.1 | 727.1 | 8600651.4 | 9964082.8 | 0.0 | 0.0 | 0.0 | 0.0 | 4240.5 | 1021380079 | 1063381 | |
| 271037 | 271037 | 2022 | 21355216 | DHS_1117_Classified DHS Location | Classified DHS Location | 10029 | Other - Lodging/Residential | 71,115 | 1910 | 1 | Not Available | 62.4 | 64.4 | 88.0 | 264.3 | 39.83 | 187.1 | 77.2 | 913326.9 | 3521673.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1016280024 | 1051796 | |
| 271038 | 271038 | 2022 | 21355217 | DHS_1118_Classified DHS Location | Classified DHS Location | 10003 | Other - Lodging/Residential | 23,492 | 1900 | 1 | Not Available | 38.6 | 37.8 | 108.0 | 76.6 | 35.52 | 0.0 | 76.6 | 906505.6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2782.3 | 1004580004 | 1079828 | |
| 271039 | 271039 | 2022 | 21355218 | DHS_1119_Classified DHS Location | Classified DHS Location | 10038 | Other - Lodging/Residential | 115,659 | 1950 | 1 | Not Available | 51.1 | 54.1 | 67.5 | 342.8 | 32.29 | 265.8 | 77.0 | 910794.8 | 5003957.9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1001110150 | 1083359 | |
| 271040 | 271040 | 2022 | 21355219 | DHS_1120_Classified DHS Location | Classified DHS Location | 10003 | Other - Lodging/Residential | 55,000 | 1915 | 1 | Not Available | 198.8 | 198.3 | 271.1 | 830.9 | 162.53 | 648.6 | 182.4 | 2157170.2 | 128096.0 | 0.0 | 8648142.6 | 0.0 | 0.0 | 9365.6 | 1004580011 | 1006546 | |
| 271041 | 271041 | 2022 | 21355220 | DHS_1121_Classified DHS Location | Classified DHS Location | 10017 | Other - Lodging/Residential | 32,221 | 1939 | 1 | Not Available | 146.1 | 149.1 | 270.9 | 318.0 | 106.56 | 135.1 | 182.9 | 2163562.8 | 2543188.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1013190011 | 1037587 | |
| 271042 | 271042 | 2022 | 21355221 | DHS_1122_Classified DHS Location | Classified DHS Location | 10003 | Other - Lodging/Residential | 14,910 | 1918 | 1 | Not Available | 27.2 | 27.2 | 76.3 | 34.3 | 24.76 | 0.0 | 34.3 | 406051.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1625.4 | 1004570007 | 1006537 | |
| 271043 | 271043 | 2022 | 21355223 | DHS_1125_Classified DHS Location | Classified DHS Location | 10009 | Other - Lodging/Residential | 23,530 | 1975 | 1 | Not Available | 107.0 | 109.4 | 184.3 | 164.1 | 75.35 | 82.3 | 81.8 | 967370.2 | 1549860.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1146.2 | 1003720014 | 1004357 | |
| 271044 | 271044 | 2022 | 21355224 | DHS_1128_Classified DHS Location | Classified DHS Location | 10451 | Other - Lodging/Residential | 76,743 | 2008 | 1 | Not Available | 101.4 | 101.0 | 253.7 | 616.2 | 86.11 | 70.3 | 545.9 | 6457114.3 | 1322815.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2023530057 | 2117641 | |
| 271045 | 271045 | 2022 | 21355225 | DHS_1129_Classified DHS Location | Classified DHS Location | 10456 | Other - Lodging/Residential | 97,000 | 1910 | 1 | Not Available | 18.3 | 18.3 | 51.3 | 150.2 | 16.15 | 0.0 | 150.2 | 1777167.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2026130001 | 2004260 | |
| 271046 | 271046 | 2022 | 21355226 | DHS_1130_Classified DHS Location | Classified DHS Location | 10459 | Other - Lodging/Residential | 21,633 | 1931 | 1 | Not Available | 898.9 | 944.2 | 970.3 | 1043.1 | 518.82 | 1015.4 | 27.7 | 327789.5 | 19117246.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2030070001 | 2010906 | |
| 271047 | 271047 | 2022 | 21355227 | DHS_1132_Classified DHS Location | Classified DHS Location | 10452 | Other - Lodging/Residential | 68,185 | 1990 | 1 | Not Available | 113.3 | 114.9 | 179.1 | 484.0 | 76.42 | 286.2 | 197.9 | 2340468.2 | 5387880.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2028650049 | 2090448 | |
| 271049 | 271049 | 2022 | 21355229 | DHS_1134_Classified DHS Location | Classified DHS Location | 10474 | Other - Lodging/Residential | 64,315 | 1926 | 1 | Not Available | 118.0 | 121.9 | 163.6 | 449.0 | 75.35 | 325.6 | 123.4 | 1459513.1 | 6130983.9 | 0.0 | 0.0 | 0.0 | 0.0 | 390.1 | 2027610043 | 2006338 | |
| 271050 | 271050 | 2022 | 21355230 | DHS_1135_Classified DHS Location | Classified DHS Location | 10452 | Other - Lodging/Residential | 99,975 | 1927 | 1 | Not Available | 75.0 | 75.0 | 98.6 | 433.7 | 46.28 | 337.7 | 96.0 | 1135819.3 | 6357938.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2025270014 | 2003496 | |
| 271051 | 271051 | 2022 | 21355231 | DHS_1136_Classified DHS Location | Classified DHS Location | 10456 | Other - Lodging/Residential | 174,600 | 1993 | 1 | Not Available | 28.2 | 28.5 | 52.8 | 334.2 | 20.45 | 137.9 | 196.3 | 2322084.4 | 2595886.0 | 0.0 | 0.0 | 0.0 | 0.0 | 6175.7 | 2024250020 | 2102353 | |
| 271052 | 271052 | 2022 | 21355232 | DHS_1138_Classified DHS Location | Classified DHS Location | 10454 | Other - Lodging/Residential | 36,000 | 1931 | 1 | Not Available | 49.8 | 49.8 | 139.4 | 151.6 | 45.21 | 0.0 | 151.6 | 1792908.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2025870001 | 2003989 | |
| 271053 | 271053 | 2022 | 21355233 | DHS_1139_Classified DHS Location | Classified DHS Location | 11216 | Other - Lodging/Residential | 164,320 | 1920 | 1 | Not Available | 94.7 | 0.0 | 129.5 | 924.4 | 60.28 | 685.1 | 239.3 | 2830090.3 | 12300789.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3011990015 | 3029748 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE summary(
"Calendar Year" INT,
"Property ID" TEXT,
"Property Name" TEXT,
Borough TEXT,
"Address 1" TEXT,
"Postal Code" TEXT,
"Property Type" TEXT,
"Floor Area (ft2)" TEXT,
"Year Built" TEXT,
"Number of Buildings" TEXT,
"ENERGY STAR Score" TEXT,
"Site EUI (kBtu/ft2)" REAL,
"Weather Norm Site EUI (kBtu/ft2)" REAL,
"Source EUI (kBtu/ft2)" REAL,
"Total GHG (MtCO2e)" REAL,
"GHGI (kgCO2e/m2)",
"Direct GHG (MtCO2e)" REAL,
"Indirect GHG (MtCO2e)" REAL,
"Electricity (kBtu)" REAL,
"Natural Gas Use (kBtu)" REAL,
"District Steam Use (kBtu)" REAL,
"Fuel Oil #2 Use (kBtu)" REAL,
"Fuel Oil #4 Use (kBtu)" REAL,
"Fuel Oil #5 & 6 Use (kBtu)" REAL,
"Water Use (kgal)" REAL,
BBL TEXT,
BIN TEXT
);
CREATE INDEX "idx_summary_Calendar Year" ON [summary] ("Calendar Year");
CREATE INDEX "idx_summary_Property ID" ON [summary] ("Property ID");
CREATE INDEX "idx_summary_Borough" ON [summary] ("Borough");
CREATE INDEX "idx_summary_Property Type" ON [summary] ("Property Type");
CREATE INDEX "idx_summary_Postal Code" ON [summary] ("Postal Code");