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

19 rows where Borough = "BRONX" and Property Type = "Other - Specialty Hospital" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal), Indoor Water Intensity (gal/ft2)

Calendar Year 11

  • 2013 3
  • 2014 2
  • 2015 2
  • 2017 2
  • 2018 2
  • 2019 2
  • 2020 2
  • 2016 1
  • 2022 1
  • 2023 1
  • 2024 1

Property Type 1

  • Other - Specialty Hospital · 19 ✖

Borough 1

  • BRONX · 19 ✖
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)
314047 314047 2024 4943431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 331,624 23304.0 23304.0 0.0 23304.0 0.0 0.0  
300581 300581 2023 4943431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 331,624 18959.3 18959.3 0.0 18959.3 0.0 0.0  
248992 248992 2022 4943431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 331,624 29326.3 29326.3 0.0 29326.3 0.0 0.0  
193810 193810 2020 4943310 1650 Grand Concourse Division BRONX 1650 Grand Concourse Other - Specialty Hospital 447195 36816.1 36816.1 0.0 36816.1 0.0 0.0  
193813 193813 2020 4943431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 331624 24197.2 24197.2 0.0 24197.2 0.0 0.0  
165902 165902 2019 4943310 1650 Grand Concourse Division BRONX 1650 Grand Concourse Other - Specialty Hospital 447,195 41250.0 41250.0 0.0 41250.0 0.0 0.0  
165905 165905 2019 4943431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 331,624 14181.4 14181.4 0.0 14181.4 0.0 0.0  
140845 140845 2018 4943310 1650 Grand Concourse Division BRONX 1650 Grand Concourse Other - Specialty Hospital 447,195 39450.9 39450.9 0.0 39450.9 0.0 0.0  
140848 140848 2018 4943431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 274,806 13759.8 13759.8 0.0 13759.8 0.0 0.0  
96278 96278 2017 4,943,431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 274,806 86.0 86.0   86.0      
98717 98717 2017 4,943,431 1276 Fulton Franklin Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 274,806 86.0 86.0   86.0      
93959 93959 2016 4,943,431 Bronx-Lebanon Hospital-Fulton Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 274,806 2791.2 2791.2 0.0 2791.2 0.0 0.0  
64773 64773 2015 4491682 1910 Arthur Avenue BRONX 1910 Arthur Avenue Other - Specialty Hospital 65181 0.0 0.0 0.0 0.0 0.0 0.0 0.0
66970 66970 2015 4943431 Bronx-Lebanon Hospital-Fulton Division BRONX 1276 Fulton Avenue Other - Specialty Hospital 274806 2311.4 2311.4 0.0 2311.4 0.0 0.0 8.41
57584 57584 2014 3325292 Bronx-Lebanon Hospital-Concourse Div. BRONX 1650 Grand Concourse Other - Specialty Hospital 447195 12480.5 0.0   0.0     0.0
57586 57586 2014 3325297 Bronx-Lebanon Hospital-Fulton Div. BRONX 1276 Fulton Ave. Other - Specialty Hospital 274806 20583.0 0.0   0.0     0.0
41383 41383 2013 2796878 Starhill BRONX 1600 Macombs Road Other - Specialty Hospital 80370 0.0 0.0   0.0   0.0 0.0
45758 45758 2013 3325292 Bronx-Lebanon Hospital-Concourse Div. BRONX 1650 Grand Concourse Other - Specialty Hospital 447195 0.0 0.0   0.0   0.0 0.0
45760 45760 2013 3325297 Bronx-Lebanon Hospital-Fulton Div. BRONX 1276 Fulton Ave. Other - Specialty Hospital 274806 0.0 0.0   0.0   0.0 0.0

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