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

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

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 3

  • MANHATTAN 4
  • BRONX 3
  • QUEENS 1

Property Type 1

  • Other - Specialty Hospital · 9 ✖

Calendar Year 1

  • 2013 · 9 ✖
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)
36352 36352 2013 2382145 MSKCC Main Campus - Super Block MANHATTAN 1275 York Ave Other - Specialty Hospital 1382117 0.0 0.0   0.0   0.0 0.0
37232 37232 2013 2641471 NSLIJ Zucker Hillside QUEENS 75-59 263rd Street Other - Specialty Hospital 260866 0.0 0.0   0.0   0.0 0.0
40974 40974 2013 2787046 Mount Sinai Medical Center   One Gustave Levy Place Other - Specialty Hospital 3029625 0.0 0.0   0.0   0.0 0.0
41323 41323 2013 2795476 HSS-Main Hospital MANHATTAN 535 E 70th St Other - Specialty Hospital 512295 0.0 0.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
43582 43582 2013 2924591 HSS-Caspary Center MANHATTAN 537 East 71 St Other - Specialty Hospital 81767 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
47425 47425 2013 3987327 Center for Science and Medicine MANHATTAN 4 E 102nd St Other - Specialty Hospital 953717 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 21.614ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability