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 = "QUEENS" and Property Type = "Laboratory" 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), Municipal Mixed Water (kgal)

Calendar Year 4

  • 2024 5
  • 2022 2
  • 2023 2
  • 2021 1

Property Type 1

  • Laboratory · 10 ✖

Borough 1

  • QUEENS · 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)
305925 305925 2024 1216329 FDA Queens QUEENS 158-15 Liberty Avenue Laboratory 275,506 7999.7 7999.7 0.0 7999.7 0.0 0.0  
320165 320165 2024 6783667 30-02 48th Avenue QUEENS 30-02 48th Avenue Laboratory 140,569 992.9 0.0 0.0 0.0 0.0 992.9  
323520 323520 2024 11715394 NH Little Neck Community Services 4618919 QUEENS 59-25 Little Neck Parkway Laboratory 36,321 784.7 784.7 0.0 784.7 0.0 0.0  
331758 331758 2024 33080410 Hatch QUEENS 43-10 23rd Street Laboratory 215,000 0.0 0.0 0.0 0.0 0.0 0.0  
338106 338106 2024 54581596 10-01 45 Road QUEENS 10-01 45 Road Laboratory 90,000 0.0 0.0 0.0 0.0 0.0 0.0  
273881 273881 2023 6783667 30-02 48th Avenue QUEENS 30-02 48th Avenue Laboratory 141,885 0.0 0.0 0.0 0.0 0.0 0.0  
288553 288553 2023 33080410 Hatch QUEENS 43-10 23rd Street Laboratory 215,000 188.7 188.7 0.0 188.7 0.0 0.0  
260784 260784 2022 6783667 AC LIC QUEENS 30-02 48th Avenue Laboratory 141,885 0.0 0.0 0.0 0.0 0.0 0.0  
260797 260797 2022 20414010 47-50 30th St QUEENS 47-50 30th St Laboratory 52,500 0.0 0.0 0.0 0.0 0.0 0.0  
224444 224444 2021 20414010 47-50 30th St QUEENS 47-50 30th St Laboratory 52,500 9.4 9.4 0.0 9.4 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 187.946ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability