Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

8 rows where Borough = "BROOKLYN" and Property Type = "Hospital (Acute Care or Children's)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Property Type 1

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

Calendar Year 1

Borough 1

  • BROOKLYN · 8 ✖
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)
1211 1211 2010 2633732 Long Island College Hospital BROOKLYN 339 Hicks Street Hospital (Acute Care or Children's) 742,538              
1915 1915 2010 2783909 1001-19 49th Street BROOKLYN 1001-19 49th Street Hospital (Acute Care or Children's) 180,000              
1916 1916 2010 2783911 4723 10th Avenue BROOKLYN 4723 10th Avenue Hospital (Acute Care or Children's) 120,000              
1917 1917 2010 2783907 4801 10th Avenue BROOKLYN 4801 10th Avenue Hospital (Acute Care or Children's) 215,000              
1919 1919 2010 2783912 6300 8th Avenue BROOKLYN 6300 8th Avenue Hospital (Acute Care or Children's) 65,000              
1922 1922 2010 2783910 920 48th Street BROOKLYN 920 48th Street Hospital (Acute Care or Children's) 63,000              
1924 1924 2010 2783908 1001-17 49th Street BROOKLYN 1001-17 49th Street Hospital (Acute Care or Children's) 101,000              
4719 4719 2010 2718357 Kingsbrook Jewish Medical Center BROOKLYN 585 Schenectady Avenue Hospital (Acute Care or Children's) 585,550              

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