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

11 rows where Borough = "QUEENS" 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), Indoor Water Use (kgal)

Calendar Year 3

  • 2012 5
  • 2011 4
  • 2010 2

Property Type 1

  • Entertainment/Culture · 11 ✖

Borough 1

  • QUEENS · 11 ✖
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)
27441 27441 2012 2734844 College Point Multiplex QUEENS 28-55 Ulmer Street Entertainment/Culture 71815   0.0 0.0        
31557 31557 2012 2902584 Bay Terrace Shopping Center-5-Cinema QUEENS 211-01 26th Ave Entertainment/Culture 22092   6.1 0.0        
31700 31700 2012 2936194 astoria ice QUEENS 34-37 37th street Entertainment/Culture 53550   0.0 0.0        
33435 33435 2012 3120800 UA Kaufman Astoria Stadium 14 QUEENS 35-30 38th Street Entertainment/Culture 95384   0.0 0.0        
34247 34247 2012 3295026 Northern RKO LLC QUEENS 135-29 Northern Boulevard Entertainment/Culture 103131   0.0 0.0        
20627 20627 2011 3120800 UA Kaufman Astoria Stadium 14 QUEENS 35-30 38th Street Entertainment/Culture 95,384              
20628 20628 2011 3120800 UA Kaufman Astoria Stadium 14 QUEENS 35-30 38th Street Entertainment/Culture 95,384              
21548 21548 2011 2734844 College Po QUEENS 28-55 Ulmer Street Entertainment/Culture 71,815              
21840 21840 2011 2902584 Bay Terrac QUEENS 211-01 26th Ave Entertainment/Culture 22,092 4.0 4.0         210.65
3527 3527 2010 2734844 College Point Multiplex QUEENS 28-55 Ulmer Street Entertainment/Culture 71,815              
3667 3667 2010 1755636 Citi Field QUEENS Citi Field Entertainment/Culture 1,242,968              

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