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

10 rows where Borough = "BRONX" 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 Name, Address 1

These facets timed out: Property Type

Calendar Year 1

  • 2010 10

Borough 1

  • BRONX · 10 ✖
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)
1982 1982 2010 2731806 3415 Bainbridge Avenue BRONX 3415 Bainbridge Avenue Hospital (Acute Care or Children's) 179,051              
1983 1983 2010 2731807 3444 Kossuth Avenue BRONX 3444 Kossuth Avenue Hospital (Acute Care or Children's) 71,620              
1990 1990 2010 2731802 3400 Bainbridge Avenue BRONX 3400 Bainbridge Avenue Hospital (Acute Care or Children's) 334,650              
1992 1992 2010 2731803 111 East 210th Street BRONX 111 East 210th Street Hospital (Acute Care or Children's) 537,154              
1996 1996 2010 2731801 1776 Hoe Avenue BRONX 1776 Hoe Avenue Hospital (Acute Care or Children's) 58,962              
1997 1997 2010 2731799 100 East Gunhill Road BRONX 100 East Gunhill Road Hospital (Acute Care or Children's) 89,526              
2725 2725 2010 2643416 Split Rock BRONX 3525 Baychester Avenue Hospital (Acute Care or Children's) 80,844              
2736 2736 2010 2643357 Bronx Center for Rehab BRONX 1010 Underhill Avenue Hospital (Acute Care or Children's) 64,600              
4578 4578 2010 2686455 Calvary Hospital BRONX 1740 Eastchester Road Hospital (Acute Care or Children's) 186,359 17.0 17.0         92.38
8800 8800 2010 2780502 Calvary Hospital BRONX 1740 Eastchester Road Hospital (Acute Care or Children's) 172,268              

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