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

14 rows where Calendar Year = 2014 and Property Type = "Other - Specialty Hospital" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal), Indoor Water Intensity (gal/ft2)

Borough 3

  • MANHATTAN 10
  • BRONX 2
  • QUEENS 1

Property Type 1

  • Other - Specialty Hospital · 14 ✖

Calendar Year 1

  • 2014 · 14 ✖
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)
49481 49481 2014 2382145 MSKCC Main Campus - Super Block MANHATTAN 1275 York Ave Other - Specialty Hospital 1382117 0.0 0.0   0.0     0.0
50293 50293 2014 2641471 NSLIJ Zucker Hillside QUEENS 75-59 263rd Street Other - Specialty Hospital 154210 0.0 0.0   0.0     0.0
53308 53308 2014 2772258 HSS-Dana Center MANHATTAN 510 East 73rd St Other - Specialty Hospital 39000 0.0 0.0   0.0     0.0
53562 53562 2014 2787046 Mount Sinai Medical Center   One Gustave Levy Place Other - Specialty Hospital 2995911 0.0 0.0   0.0     0.0
53825 53825 2014 2794961 HSS-310 E 71st MANHATTAN 310 East 71st Street Other - Specialty Hospital 59000 1791.1 1791.1   1791.1     30.36
53842 53842 2014 2795476 HSS-Main Hospital MANHATTAN 535 E 70th St Other - Specialty Hospital 512295 0.0 0.0   0.0     0.0
53843 53843 2014 2795490 HSS-429 E 75th Street MANHATTAN 429 E 75th Street Other - Specialty Hospital 31500 0.0 0.0   0.0     0.0
53867 53867 2014 2796211 HSS-ERPB MANHATTAN 523 E 72nd ST Other - Specialty Hospital 53677 0.0 0.0   0.0     0.0
53884 53884 2014 2796651 HSS-Belaire MANHATTAN 525 East 71st St Other - Specialty Hospital 211990 0.0 0.0   0.0     0.0
54427 54427 2014 2806562 HSS-1365 York Ave MANHATTAN 1365 York Ave Other - Specialty Hospital 10000 0.0 0.0   0.0     0.0
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
58945 58945 2014 3987327 Center for Science and Medicine MANHATTAN 4 E 102nd St Other - Specialty Hospital 953717 0.0 0.0   0.0     0.0
61336 61336 2014 4406842 HSS-Caspary Center MANHATTAN 541 E 71st Street Other - Specialty Hospital 81767 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 1435.708ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability