Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

7 rows where Borough = "QUEENS" and Property Type = "Hospital (Acute Care or Children's)" 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)

Property Type 1

  • Hospital (Acute Care or Children's) · 7 ✖

Calendar Year 1

Borough 1

  • QUEENS · 7 ✖
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)
2729 2729 2010 2643392 Holliswood QUEENS 195-44 Woodhull Avenue Hospital (Acute Care or Children's) 75,600              
4752 4752 2010 2646028 NSLIJ Forest Hills QUEENS 102-01 66th Road Hospital (Acute Care or Children's) 187,635              
4753 4753 2010 2641036 NSLIJ LIJ Medical QUEENS 270-05 76th Avenue Hospital (Acute Care or Children's) 1,005,604              
4811 4811 2010 1747000 Main Hospital QUEENS 56-45 Main Street Hospital (Acute Care or Children's) 590,371              
4812 4812 2010 2386047 West Wing QUEENS 56-45 Main Street Hospital (Acute Care or Children's) 171,780              
5687 5687 2010 2646028 NSLIJ Forest Hills QUEENS 102-01 66th Road Hospital (Acute Care or Children's) 187,635              
5688 5688 2010 2641036 NSLIJ LIJ Medical QUEENS 270-05 76th Avenue Hospital (Acute Care or Children's) 1,005,604              

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