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

24 rows where Borough = "BRONX" 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, Indoor Water Use (kgal)

These facets timed out: Property Type

Calendar Year 2

  • 2012 13
  • 2011 11

Borough 1

  • BRONX · 24 ✖
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)
24126 24126 2012 2643357 Bronx Center for Rehab BRONX 1010 Underhill Avenue Hospital (General Medical and Surgical) 64600   0.0 0.0        
24131 24131 2012 2643416 Split Rock BRONX 3525 Baychester Avenue Hospital (General Medical and Surgical) 80844   7408.9 0.0        
27328 27328 2012 2731799 100 East Gunhill Road BRONX 100 East Gunhill Road Hospital (General Medical and Surgical) 99526   0.0 0.0        
27330 27330 2012 2731801 1776 Hoe Avenue BRONX 1776 Hoe Avenue Hospital (General Medical and Surgical) 68952   0.0 0.0        
27331 27331 2012 2731802 3400 Bainbridge Avenue BRONX 3400 Bainbridge Avenue Hospital (General Medical and Surgical) 379500   0.0 0.0        
27332 27332 2012 2731803 111 East 210th Street BRONX 111 East 210th Street Hospital (General Medical and Surgical) 625000   0.0 0.0        
27335 27335 2012 2731806 3415 Bainbridge Avenue BRONX 3415 Bainbridge Avenue Hospital (General Medical and Surgical) 207000   0.0 0.0        
27336 27336 2012 2731807 3444 Kossuth Avenue BRONX 3444 Kossuth Avenue Hospital (General Medical and Surgical) 78620   0.0 0.0        
28260 28260 2012 2780502 Calvary Hospital BRONX 1740 Eastchester Road Hospital (General Medical and Surgical) 172268   0.0 0.0        
30907 30907 2012 2818252 St. Barnabas Hospital BRONX 4422 Third Avenue Hospital (General Medical and Surgical) 342366   0.0 0.0        
33239 33239 2012 3117231 NY Westchester: 2475 St. Raymond Ave BRONX 2475 St. Raymond Ave Hospital (General Medical and Surgical) 137500   0.0 0.0        
36081 36081 2012 3601676 Jacobi Medical Center BRONX 1400 Pelham Parkway South Hospital (General Medical and Surgical) 169617   0.0 0.0        
36082 36082 2012 3601857 North Central Bronx Hospital BRONX 3424 Kossuth Ave Hospital (General Medical and Surgical) 69958   0.0 0.0        
15748 15748 2011 2818252 St. Barnabas Hospital BRONX 4422 Third Avenue Hospital (General Medical and Surgical) 342,366              
16682 16682 2011 2731801 1776 Hoe Avenue BRONX 1776 Hoe Avenue Hospital (General Medical and Surgical) 58,962              
17129 17129 2011 2731807 3444 Kossuth Avenue BRONX 3444 Kossuth Avenue Hospital (General Medical and Surgical) 71,620              
17130 17130 2011 2731806 3415 Bainbridge Avenue BRONX 3415 Bainbridge Avenue Hospital (General Medical and Surgical) 179,051              
17131 17131 2011 2731799 100 East Gunhill Road BRONX 100 East Gunhill Road Hospital (General Medical and Surgical) 89,526              
17132 17132 2011 2731803 111 East 210th Street BRONX 111 East 210th Street Hospital (General Medical and Surgical) 537,154              
17175 17175 2011 2731802 3400 Bainbridge Avenue BRONX 3400 Bainbridge Avenue Hospital (General Medical and Surgical) 334,650              
17287 17287 2011 2643357 Bronx Center for Rehab BRONX 1010 Underhill Avenue Hospital (General Medical and Surgical) 64,600              
17394 17394 2011 3117231 NY Westchester: 2475 St. Raymond Ave BRONX 2475 St. Raymond Ave Hospital (General Medical and Surgical) 137,500              
17420 17420 2011 2780502 Calvary Ho BRONX 1740 Eastchester Road Hospital (General Medical and Surgical) 172,268              
17716 17716 2011 2643416 Split Rock BRONX 3525 Baychester Avenue Hospital (General Medical and Surgical) 80,844              

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