Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

49 rows where Borough = "BROOKLYN" 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), Municipal Mixed Water (kgal)

Calendar Year 11

Property Type 1

  • Courthouse · 49 ✖

Borough 1

  • BROOKLYN · 49 ✖
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)
322398 322398 2024 9776905 Brooklyn Family Court (330 Jay) BROOKLYN 330 Jay Street Courthouse 977,656 0.0 0.0 0.0 0.0 0.0 0.0  
327926 327926 2024 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 443.7 443.7 0.0 443.7 0.0 0.0  
327928 327928 2024 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
327937 327937 2024 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 5426.4 5426.4 0.0 5426.4 0.0 0.0  
327938 327938 2024 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 0.0 0.0 0.0 0.0 0.0 0.0  
328508 328508 2024 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
335723 335723 2024 52441595 141 Livingston Owner LLC BROOKLYN 141 Livingston Street Courthouse 193,195 3176.2 3176.2 0.0 3176.2 0.0 0.0  
276547 276547 2023 9776905 Brooklyn Family Court (330 Jay) BROOKLYN 330 Jay Street Courthouse 977,656 12231.2 12231.2 0.0 12231.2 0.0 0.0  
294419 294419 2023 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 343.9 343.9 0.0 343.9 0.0 0.0  
294421 294421 2023 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
294430 294430 2023 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 5723.3 5723.3 0.0 5723.3 0.0 0.0  
294431 294431 2023 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 0.0 0.0 0.0 0.0 0.0 0.0  
295103 295103 2023 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
298077 298077 2023 29892141 141 Livingston Owner LLC BROOKLYN 141 Livingston Street Courthouse 193,195 0.0 0.0 0.0 0.0 0.0 0.0  
255703 255703 2022 9776905 Brooklyn Family Court (330 Jay) BROOKLYN 330 Jay Street Courthouse 977,656 11340.9 11340.9 0.0 11340.9 0.0 0.0  
270314 270314 2022 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 0.0 0.0 0.0 0.0 0.0 0.0  
270316 270316 2022 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
270325 270325 2022 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 4594.5 4594.5 0.0 4594.5 0.0 0.0  
270326 270326 2022 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 0.0 0.0 0.0 0.0 0.0 0.0  
271003 271003 2022 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
222670 222670 2021 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 14.0 14.0 0.0 14.0 0.0 0.0  
222672 222672 2021 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
222681 222681 2021 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 4115.0 4115.0 0.0 4115.0 0.0 0.0  
222682 222682 2021 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 0.0 0.0 0.0 0.0 0.0 0.0  
223383 223383 2021 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
186545 186545 2020 2678635 330 Jay Street BROOKLYN 330 Jay Street Courthouse 1110000 7907.7 0.0 0.0 0.0 0.0 7907.7  
197871 197871 2020 6294260 DCAS - 3001881 - Brooklyn Appellate Court (LL84) BROOKLYN 45 Monroe Pl Courthouse 49500 0.0 0.0 0.0 0.0 0.0 0.0  
197872 197872 2020 6294261 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court (LL84) BROOKLYN 120 Schermerhorn St Courthouse 264100 4070.9 4070.9 0.0 4070.9 0.0 0.0  
197904 197904 2020 6294307 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court (LL84) BROOKLYN 360 Adams St Courthouse 585000 0.0 0.0 0.0 0.0 0.0 0.0  
170328 170328 2019 6294260 DCAS - 3001881 - Brooklyn Appellate Court (LL84) BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
170329 170329 2019 6294261 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court (LL84) BROOKLYN 120 Schermerhorn St Courthouse 264,100 56181.9 56181.9 0.0 56181.9 0.0 0.0  
170365 170365 2019 6294307 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court (LL84) BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
132637 132637 2018 2678635 330 Jay Street BROOKLYN 330 Jay Street Courthouse 1,100,000 10184.8 0.0 0.0 0.0 0.0 10184.8  
145365 145365 2018 6294260 DCAS - 3001881 - Brooklyn Appellate Court (LL84) BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
145366 145366 2018 6294261 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court (LL84) BROOKLYN 120 Schermerhorn St Courthouse 264,100 0.0 0.0 0.0 0.0 0.0 0.0  
145402 145402 2018 6294307 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court (LL84) BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
99754 99754 2017 2,678,635 330 Jay Street BROOKLYN 330 Jay Street Courthouse 1,100,000 10.0         10.0  
106168 106168 2017 6,294,307 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court (LL84) BROOKLYN 360 Adams St Courthouse 621,817              
106455 106455 2017 6,294,260 DCAS - 3001881 - Brooklyn Appellate Court (LL84) BROOKLYN 45 Monroe Pl Courthouse 49,500              
107276 107276 2017 6,294,261 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court (LL84) BROOKLYN 120 Schermerhorn St Courthouse 264,100              
84929 84929 2016 4,628,874 DCAS - 3001881 - Brooklyn Appellate Court (LL84) BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
84930 84930 2016 4,628,875 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court (LL84) BROOKLYN 120 Schermerhorn St Courthouse 264,100 0.0 0.0 0.0 0.0 0.0 0.0  
84965 84965 2016 4,628,921 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court (LL84) BROOKLYN 360 Adams St Courthouse 621,817 0.0 0.0 0.0 0.0 0.0 0.0  
90125 90125 2016 2,678,635 330 Jay Street BROOKLYN 330 Jay Street Courthouse 1,100,000 12184.3 0.0 0.0 0.0 0.0 12184.3  
74472 74472 2015 4628874 DCAS - 3001881 - Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49500 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74473 74473 2015 4628875 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264100 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74507 74507 2015 4628921 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 621817 0.0 0.0 0.0 0.0 0.0 0.0 0.0
76585 76585 2015 2678635 330 Jay Street BROOKLYN 330 Jay Street Courthouse 1100000 11876.0 0.0 0.0 0.0 0.0 11876.0 0.0
38709 38709 2013 2678635 330 Jay Street BROOKLYN 330 Jay Street Courthouse 1100000 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");