home / nyc_ll84

Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

10 rows where Calendar Year = 2023 and Property Type = "Other - Specialty Hospital" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Borough 4

  • MANHATTAN 6
  • BROOKLYN 2
  • BRONX 1
  • QUEENS 1

Property Type 1

  • Other - Specialty Hospital · 10 ✖

Calendar Year 1

  • 2023 · 10 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) Total Water Use (kgal) Indoor Water Use (kgal) Outdoor Water Use (kgal) Municipal Indoor Water (kgal) Municipal Outdoor Water (kgal) Municipal Mixed Water (kgal) Indoor Water Intensity (gal/ft2)
279816 279816 2023 1418514 Kimmel MANHATTAN 351 E 68 St Other - Specialty Hospital 60,273 3140.3 3140.3 0.0 3140.3 0.0 0.0  
281097 281097 2023 2382101 Evelyn H. Lauder Breast and Imaging Center MANHATTAN 300 E 65 St Other - Specialty Hospital 233,086 9218.2 9218.2 0.0 9218.2 0.0 0.0  
281477 281477 2023 2641471 NH Zucker Hillside QUEENS 75-59 263rd Street Other - Specialty Hospital 154,210 44465.1 44465.1 0.0 44465.1 0.0 0.0  
287059 287059 2023 4030401 ASPCA MANHATTAN 424 East 92nd Street Other - Specialty Hospital 50,302 2109.7 2109.7 0.0 2109.7 0.0 0.0  
293151 293151 2023 20828250 Maimonides - 6300 8th Ave BROOKLYN 6300 8th Ave Other - Specialty Hospital 71,500 1410.0 1410.0 0.0 1410.0 0.0 0.0  
293413 293413 2023 20828250 Maimonides - 6300 8th Ave BROOKLYN 6300 8th Ave Other - Specialty Hospital 71,500 1410.0 1410.0 0.0 1410.0 0.0 0.0  
299265 299265 2023 4410386 MSKCC - Josie Robertson Center MANHATTAN 1133 York Ave Other - Specialty Hospital 186,947 9699.8 9699.8 0.0 9699.8 0.0 0.0  
300352 300352 2023 4929345 Main Campus - Lot 05 (Child of MSKCC Super Campus) MANHATTAN 1275 York Ave Other - Specialty Hospital 1,208,625 0.0 0.0 0.0 0.0 0.0 0.0  
300581 300581 2023 4943431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 331,624 18959.3 18959.3 0.0 18959.3 0.0 0.0  
301208 301208 2023 5802690 Memorial Sloan-Kettering Cancer Center: David H. Koch Center for Cancer Care MANHATTAN 530 East 74th St Other - Specialty Hospital 795,283 0.0 0.0 0.0 0.0 0.0 0.0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE water(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Total Water Use (kgal)" REAL,
  "Indoor Water Use (kgal)" REAL,
  "Outdoor Water Use (kgal)" REAL,
  "Municipal Indoor Water (kgal)" REAL,
  "Municipal Outdoor Water (kgal)" REAL,
  "Municipal Mixed Water (kgal)" REAL,
  "Indoor Water Intensity (gal/ft2)" REAL
);
CREATE INDEX "idx_water_Calendar Year" ON [water] ("Calendar Year");
CREATE INDEX "idx_water_Property ID" ON [water] ("Property ID");
CREATE INDEX "idx_water_Borough" ON [water] ("Borough");
CREATE INDEX "idx_water_Property Type" ON [water] ("Property Type");
Powered by Datasette · Queries took 86.753ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability