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

33 rows where Borough = "BRONX" and Property Type = "Courthouse" 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), Indoor Water Intensity (gal/ft2)

Calendar Year 11

  • 2015 4
  • 2019 4
  • 2016 3
  • 2017 3
  • 2018 3
  • 2020 3
  • 2021 3
  • 2022 3
  • 2023 3
  • 2024 3
  • 2014 1

Property Type 1

  • Courthouse · 33 ✖

Borough 1

  • BRONX · 33 ✖
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)
328506 328506 2024 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 0.0 0.0 0.0 0.0 0.0 0.0  
328891 328891 2024 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
328892 328892 2024 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
295101 295101 2023 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 534.1 534.1 0.0 534.1 0.0 0.0  
295512 295512 2023 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
295513 295513 2023 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
271001 271001 2022 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 927.7 927.7 0.0 927.7 0.0 0.0  
271399 271399 2022 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
271400 271400 2022 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
223381 223381 2021 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 814.2 814.2 0.0 814.2 0.0 0.0  
223793 223793 2021 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
223794 223794 2021 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
197869 197869 2020 6294258 DCAS - 2101266 - Bronx Housing Court (LL84) (Leased) BRONX 1118 Grand Concourse Courthouse 99000 745.0 745.0 0.0 745.0 0.0 0.0  
197901 197901 2020 6294301 DCAS - 2002869 - Bronx County Courthouse (LL84) BRONX 851 Grand Concourse Courthouse 550600 0.0 0.0 0.0 0.0 0.0 0.0  
208875 208875 2020 12344539 BBL 2-02454-0001: DCAS, HRA, NYPD (LL84) BRONX 215 East 161st St Courthouse 497440 0.0 0.0 0.0 0.0 0.0 0.0  
170326 170326 2019 6294258 DCAS - 2101266 - Bronx Housing Court (LL84) BRONX 1118 Grand Concourse Courthouse 99,000 12853.3 12853.3 0.0 12853.3 0.0 0.0  
170361 170361 2019 6294301 DCAS - 2002869 - Bronx County Courthouse (LL84) BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
170362 170362 2019 6294302 DCAS - 2002704 - Bronx Family and Criminal Court (LL84) BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
183138 183138 2019 12344539 BBL 2-02454-0001: DCAS, HRA, NYPD (LL84) BRONX 215 East 161st St Courthouse 497,440 0.0 0.0 0.0 0.0 0.0 0.0  
145363 145363 2018 6294258 DCAS - 2101266 - Bronx Housing Court (LL84) BRONX 1118 Grand Concourse Courthouse 99,000 0.0 0.0 0.0 0.0 0.0 0.0  
145398 145398 2018 6294301 DCAS - 2002869 - Bronx County Courthouse (LL84) BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
145399 145399 2018 6294302 DCAS - 2002704 - Bronx Family and Criminal Court (LL84) BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
105573 105573 2017 6,294,302 DCAS - 2002704 - Bronx Family and Criminal Court (LL84) BRONX 215 East 161st St Courthouse 388,800              
106630 106630 2017 6,294,258 DCAS - 2101266 - Bronx Housing Court (LL84) BRONX 1118 Grand Concourse Courthouse 99,000              
106910 106910 2017 6,294,301 DCAS - 2002869 - Bronx County Courthouse (LL84) BRONX 851 Grand Concourse Courthouse 550,000              
84927 84927 2016 4,628,872 DCAS - 2101266 - Bronx Housing Court (LL84) BRONX 1118 Grand Concourse Courthouse 99,000 0.0 0.0 0.0 0.0 0.0 0.0  
84961 84961 2016 4,628,915 DCAS - 2002869 - Bronx County Courthouse (LL84) BRONX 851 Grand Concourse Courthouse 550,000 0.0 0.0 0.0 0.0 0.0 0.0  
84962 84962 2016 4,628,916 DCAS - 2002704 - Bronx Family and Criminal Court (LL84) BRONX 215 East 161st St Courthouse 388,800 0.0 0.0 0.0 0.0 0.0 0.0  
70025 70025 2015 4405711 131 Walnut Avenue, Bronx BRONX 131 Walnut Avenue, Bronx Courthouse 110000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74470 74470 2015 4628872 DCAS - 2101266 - Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74503 74503 2015 4628915 DCAS - 2002869 - Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74504 74504 2015 4628916 DCAS - 2002704 - Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 388800 0.0 0.0 0.0 0.0 0.0 0.0 0.0
61246 61246 2014 4405711 131 Walnut Avenue, Bronx BRONX 131 Walnut Avenue, Bronx Courthouse 110000 602.0 602.0   602.0     5.47

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