Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

18 rows where Borough = "BROOKLYN" and Property Type = "Hospital (General Medical and Surgical)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Indoor Water Use (kgal)

These facets timed out: Property Type

Calendar Year 2

Borough 1

  • BROOKLYN · 18 ✖
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)
26935 26935 2012 2718357 Kingsbrook Jewish Medical Center BROOKLYN 585 Schenectady Avenue Hospital (General Medical and Surgical) 355550   122167.5 0.0        
28369 28369 2012 2783907 4801 10th Avenue BROOKLYN 4801 10th Avenue Hospital (General Medical and Surgical) 214990   0.0 0.0        
28370 28370 2012 2783908 1001-17 49th Street BROOKLYN 1001-17 49th Street Hospital (General Medical and Surgical) 100990   0.0 0.0        
28371 28371 2012 2783909 1001-19 49th Street BROOKLYN 1001-19 49th Street Hospital (General Medical and Surgical) 179990   0.0 0.0        
28374 28374 2012 2783912 6300 8th Avenue BROOKLYN 6300 8th Avenue Hospital (General Medical and Surgical) 65000   0.0 0.0        
31483 31483 2012 2869789 Brooklyn Hospital Center BROOKLYN 121 DeKalb Avenue Hospital (General Medical and Surgical) 700000   28126.8 0.0        
32261 32261 2012 2992712 NY Methodist Hospital BROOKLYN 506 6th Street Hospital (General Medical and Surgical) 733613   208433.4 0.0        
32736 32736 2012 3107497 2525 Kings Highway - 37298 BROOKLYN 2525 Kings Highway Hospital (General Medical and Surgical) 113300   8268.9 0.0        
34456 34456 2012 3354009 Interfaith Medical Center BROOKLYN 55 Albany Avenue Hospital (General Medical and Surgical) 328782   0.0 0.0        
18210 18210 2011 2992712 NY Methodi BROOKLYN 506 6th Street Hospital (General Medical and Surgical) 733,613              
18622 18622 2011 2869789 Brooklyn H BROOKLYN 121 DeKalb Avenue Hospital (General Medical and Surgical) 700,000              
19027 19027 2011 2718357 Kingsbrook BROOKLYN 585 Schenectady Avenue Hospital (General Medical and Surgical) 355,550              
19487 19487 2011 2783911 4723 10th BROOKLYN 4723 10th Avenue Hospital (General Medical and Surgical) 120,000              
19492 19492 2011 2783909 1001-19 49 BROOKLYN 1001-19 49th Street Hospital (General Medical and Surgical) 180,000              
19493 19493 2011 2783907 4801 10th BROOKLYN 4801 10th Avenue Hospital (General Medical and Surgical) 215,000              
19494 19494 2011 3128445 1001-17 49th St BROOKLYN 1001-17 49th St Hospital (General Medical and Surgical) 101,000              
19530 19530 2011 2783912 6300 8th A BROOKLYN 6300 8th Avenue Hospital (General Medical and Surgical) 65,000              
19893 19893 2011 3107497 2525 Kings Highway - 37298 BROOKLYN 2525 Kings Highway Hospital (General Medical and Surgical) 113,300              

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