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

6 rows where Borough = "BRONX" and Property Type = "Entertainment/Culture" 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 2
  • 2011 2
  • 2012 2

Property Type 1

  • Entertainment/Culture · 6 ✖

Borough 1

  • BRONX · 6 ✖
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)
27186 27186 2012 2730626 Whitestone Multiplex BRONX 2505 Bruckner Boulevard Entertainment/Culture 64760   0.0 0.0        
27442 27442 2012 2734903 Concourse Plaza BRONX 214 East 161st Street Entertainment/Culture 55000   0.0 0.0        
16081 16081 2011 2734903 Concourse BRONX 214 East 161st Street Entertainment/Culture 55,000              
17744 17744 2011 2730626 Whitestone BRONX 2505 Bruckner Boulevard Entertainment/Culture 64,760              
3524 3524 2010 2734903 Concourse Plaza BRONX 214 East 161st Street Entertainment/Culture 55,000              
3526 3526 2010 2730626 Whitestone Multiplex BRONX 2505 Bruckner Boulevard Entertainment/Culture 64,760              

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