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

19 rows where Borough = "MANHATTAN" and Property Type = "Prison/Incarceration" 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)

Calendar Year 10

  • 2015 2
  • 2016 2
  • 2017 2
  • 2018 2
  • 2019 2
  • 2021 2
  • 2022 2
  • 2023 2
  • 2024 2
  • 2020 1

Property Type 1

  • Prison/Incarceration · 19 ✖

Borough 1

  • MANHATTAN · 19 ✖
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)
327732 327732 2024 21354249 DOC_1152_Manhattan CC: Manhattan Detention House South MANHATTAN 125 White St Prison/Incarceration 514,000 0.0 0.0 0.0 0.0 0.0 0.0  
327733 327733 2024 21354250 DOC_8963_Manhattan CC: Manhattan Detention House North MANHATTAN 84 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
294204 294204 2023 21354249 DOC_1152_Manhattan CC: Manhattan Detention House South MANHATTAN 125 White St Prison/Incarceration 514,000 0.0 0.0 0.0 0.0 0.0 0.0  
294205 294205 2023 21354250 DOC_8963_Manhattan CC: Manhattan Detention House North MANHATTAN 84 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
270097 270097 2022 21354249 DOC_1152_Manhattan CC: Manhattan Detention House South MANHATTAN 125 White St Prison/Incarceration 514,000 0.0 0.0 0.0 0.0 0.0 0.0  
270098 270098 2022 21354250 DOC_8963_Manhattan CC: Manhattan Detention House North MANHATTAN 84 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
222453 222453 2021 21354249 DOC_1152_Manhattan CC: Manhattan Detention House South MANHATTAN 125 White St Prison/Incarceration 514,000 0.0 0.0 0.0 0.0 0.0 0.0  
222454 222454 2021 21354250 DOC_8963_Manhattan CC: Manhattan Detention House North MANHATTAN 84 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
198448 198448 2020 6297409 DOC - 1002364 - Manhattan CC Campus: Manhattan Detention House North (LL84) MANHATTAN 84 Baxter St Prison/Incarceration 236142 0.0 0.0 0.0 0.0 0.0 0.0  
170414 170414 2019 6294364 DOC - 1088394 - Manhattan CC Campus: Manhattan Detention House South (LL84) MANHATTAN 125 White St Prison/Incarceration 514,000 2018.2 2018.2 0.0 2018.2 0.0 0.0  
171039 171039 2019 6297409 DOC - 1002364 - Manhattan CC Campus: Manhattan Detention House North (LL84) MANHATTAN 84 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
145450 145450 2018 6294364 DOC - 1088394 - Manhattan CC Campus: Manhattan Detention House South (LL84) MANHATTAN 125 White St Prison/Incarceration 514,000 0.0 0.0 0.0 0.0 0.0 0.0  
146074 146074 2018 6297409 DOC - 1002364 - Manhattan CC Campus: Manhattan Detention House North (LL84) MANHATTAN 100 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
105612 105612 2017 6,297,409 DOC - 1002364 - Manhattan CC Campus: Manhattan Detention House North (LL84) MANHATTAN 100 Baxter St Prison/Incarceration 236,142              
105826 105826 2017 6,294,364 DOC - 1088394 - Manhattan CC Campus: Manhattan Detention House South (LL84) MANHATTAN 125 White St Prison/Incarceration 514,000              
85013 85013 2016 4,628,977 DOC - 1088394 - Manhattan CC Campus: Manhattan House Detention, South Tower MANHATTAN 125 White St Prison/Incarceration 514,000 0.0 0.0 0.0 0.0 0.0 0.0  
85539 85539 2016 4,629,804 DOC - 1002364 - Manhattan CC Campus: Manhattan House Detention, North Tower MANHATTAN 100 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
74555 74555 2015 4628977 DOC - 1088394 - Manhattan CC Campus: Manhattan House Detention, South Tower MANHATTAN 125 White St Prison/Incarceration 514000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75074 75074 2015 4629804 DOC - 1002364 - Manhattan CC Campus: Manhattan House Detention, North Tower MANHATTAN 100 Baxter St Prison/Incarceration 236142 0.0 0.0 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 1439.244ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability