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 Borough = "MANHATTAN" and Property Type = "Lodging" 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)

Calendar Year 3

  • 2010 11
  • 2012 2
  • 2011 1

Property Type 1

  • Lodging · 14 ✖

Borough 1

  • MANHATTAN · 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)
24387 24387 2012 2651692 thestanton MANHATTAN 196 stanton street Lodging 66371   0.0 0.0        
26787 26787 2012 2714174 New York Athletic Club MANHATTAN 180 Central Park South Lodging 400000   0.0 0.0        
12398 12398 2011 2714174 New York Athletic Club MANHATTAN 180 Central Park South Lodging 400,000              
4730 4730 2010 2669309 Murray Hill Place MANHATTAN 243 Lexington Ave. Lodging 121,600              
5397 5397 2010 2714174 New York Athletic Club MANHATTAN 180 Central Park South Lodging 400,000              
8841 8841 2010 2685972 Woodfin Realty Corp MANHATTAN 810 W 183rd St Lodging 28,559              
8859 8859 2010 2685959 355 Company, LLC MANHATTAN 347 West 55th St Lodging 25,246              
8860 8860 2010 2685983 3rd & 60th Assoc MANHATTAN 205 East 60th St Lodging 1,797              
8861 8861 2010 2685985 3rd & 60th Assoc 207 MANHATTAN 207 East 60th St Lodging 1,796              
8862 8862 2010 2685986 3rd & 60th Assoc 209 MANHATTAN 209 East 60th St Lodging 1,796              
8863 8863 2010 2685998 3rd & 60th Assoc 211 MANHATTAN 211 East 60th St Lodging 1,796              
8864 8864 2010 2685968 440 Company, LLC MANHATTAN 440 West 34th Street Lodging 61,499              
8866 8866 2010 2685955 60 West 76th, LLC MANHATTAN 60 West 76th Street Lodging 29,791              
8868 8868 2010 2685976 First New Amsterdam Realty MANHATTAN 173 W 78th St Lodging 37,706              

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