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

16 rows where Borough = "QUEENS" 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

  • 2012 9
  • 2011 7

Borough 1

  • QUEENS · 16 ✖
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)
22969 22969 2012 1747000 Main Hospital QUEENS 56-45 Main Street Hospital (General Medical and Surgical) 590371   0.0 0.0        
23125 23125 2012 2386047 West Building QUEENS 139-24 Booth Memorial Ave Hospital (General Medical and Surgical) 171780   0.0 0.0        
24081 24081 2012 2641036 NSLIJ LIJ Medical QUEENS 270-05 76th Avenue Hospital (General Medical and Surgical) 1222133   0.0 0.0        
24128 24128 2012 2643392 Holliswood QUEENS 195-44 Woodhull Avenue Hospital (General Medical and Surgical) 75600   14215.5 0.0        
24247 24247 2012 2646028 NSLIJ Forest Hills QUEENS 102-01 66th Road Hospital (General Medical and Surgical) 190934   19674.4 0.0        
31971 31971 2012 2965375 St. Mary's Hospital for Children QUEENS 29-01 216 ST Hospital (General Medical and Surgical) 187274   0.0 0.0        
34726 34726 2012 3488480 Mount Sinai Queens QUEENS 2510 30th Ave Hospital (General Medical and Surgical) 61080   8388.6 0.0        
35573 35573 2012 3537770 Flushing Manor Care Center QUEENS 139-62 35th Ave Hospital (General Medical and Surgical) 87106   0.0 0.0        
35576 35576 2012 3537809 Flushing Manor - Dr. William O. Benenson Rehabiliation Pavilion QUEENS 36-11 Parsons Blvd Hospital (General Medical and Surgical) 101640   0.0 0.0        
21098 21098 2011 2646028 NSLIJ Forest Hills QUEENS 102-01 66th Road Hospital (General Medical and Surgical) 190,934 0.0 0.0         0.0
21754 21754 2011 1747000 Main Hospital QUEENS 56-45 Main Street Hospital (General Medical and Surgical) 590,371              
21855 21855 2011 2965375 St. Mary's QUEENS 29-01 216 ST Hospital (General Medical and Surgical) 80,000              
21863 21863 2011 2386047 West Building QUEENS 139-24 Booth Memorial Ave Hospital (General Medical and Surgical) 129,020              
22187 22187 2011 2641036 NSLIJ LIJ Medical QUEENS 270-05 76th Avenue Hospital (General Medical and Surgical) 1,222,133              
22401 22401 2011 2643392 Holliswood QUEENS 195-44 Woodhull Avenue Hospital (General Medical and Surgical) 75,600              
22510 22510 2011 2266601 Peninsula Hospital QUEENS 51-15 Beach Channel Drive Hospital (General Medical and Surgical) 124,800              

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 1757.654ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability