The Legal Last Mile

Administrative Law, Water Access & the Limits of Judicial Inclusion — Global Water Law Judicial Decisions Dataset (v1.0)

83,596 decisions Brazil: 11,724 Netherlands: 68,654 Canada: 3,218 2016 – 2025
83,596
Total Decisions
3 jurisdictions · 2016–2025
11,724
Brazil
8 state courts + historical TJSP
68,654
Netherlands
11 district courts + appellate
3,218
Canada
CanLII + Legal Data Hunter
21
Governance Categories
4 languages · v2.0 coding engine
7
Coded Variables
Per decision, all jurisdictions

Temporal coverage

Judicial Decisions by Year & Country
Netherlands on right axis (different scale). Dual-axis chart.

Dataset composition

Total Decisions by Country
Netherlands dominates by volume due to open XML data feed coverage.

Global governance distribution

All 83,596 Decisions — Top Categories Across All Countries
other_water (69.0%) and not_water_related (18.6%) excluded to show substantive governance categories.
Brazil signal: Tariff disputes dominate (48.1%). Connection refusal accounts for only 9.9% — the access threshold question is systematically underrepresented in the formal legal record.
Netherlands signal: Virtually no household connection disputes (<0.1%). Administrative pre-litigation absorption channels resolve service disputes before courts.
Canada signal: Fisheries (5.0%) and riparian rights (3.4%) dominate — resource governance, not household access. Reflects jurisdictional fragmentation and federal/provincial split.
Administrative Ghost: Informal settlements account for only 0.8% of Brazilian decisions (96 of 11,724) — not because excluded populations lack legal problems, but because they cannot enter the formal judicial system as plaintiffs.

Brazil

11,724 decisions · 2016–2025 8 state courts + TJSP historical
11,724
Total Cases
48.1%
Tariff Disputes
5,634 cases
9.9%
Connection Refusal
1,160 cases
0.8%
Informal Settlement
96 cases — Administrative Ghost
31.2%
User Win Rate
of 4,481 coded decisions
1.9%
HR Language
226 decisions cite right to water

Governance distribution

Brazil — All Governance Categories

Win/Loss outcomes

4,481 Coded Decisions
~7,243 decisions had unclear or no outcome language (particularly TJDFT/Brasília which uses administrative docket framing).

Temporal trend

Cases per Year (2016–2025)

Win/loss trend

Outcomes by Year — Pre/Post Reform
Shaded region: post Lei 14.026/2020 (Novo Marco do Saneamento). User win rate stable at ~31% before and after reform.

Human rights language

HR / Right-to-Water Framing by Year (2016–2025)
Only 1.9% of decisions invoke explicit HR framing despite Art. 6 CF/1988 constitutional guarantee — consistent with the rights-access gap thesis.
The Brazilian Paradox: Brazil has one of the world's strongest constitutional frameworks for water rights (Art. 6, Art. 225 CF/1988; STF recognition of the right to water as a fundamental right). Yet the formal judicial record is dominated by tariff disputes (48.1%) presupposing a formal connection, while the populations most in need — irregular settlement residents — account for less than 1% of decisions. Rights are declared but administratively inaccessible to those who need them most.
CategoryCount%Distribution

Netherlands

68,654 decisions · 2016–2025 11 Rechtbanken + RvS + appellate
68,654
Total Cases
22.7%
Immigration Pre-filter
15,589 not-water-related
1.8%
Flood Protection
1,266 dijk/waterkering cases
<0.1%
Connection Refusal
12 cases — pre-litigation absorption
0%
HR Language
Absent from Dutch decisions
High
Pre-litigation Absorption
Bezwaar/Awb/Geschillencommissie

Governance distribution

Netherlands — Excluding other_water & not_water_related
Substantive categories from 52,476 classified decisions. Flood protection and environmental licensing dominate — systemic governance, not household access.

Composition breakdown

Full NL Dataset Composition

Temporal trend

Netherlands — Cases per Year (2016–2025)
Consistent growth reflects expanding Rechtspraak.nl publication coverage and Omgevingswet transition activity (2023–2025).
Pre-litigation absorption model: The near-total absence of household connection refusal cases (12 out of 68,654 decisions, <0.1%) reflects the Netherlands' layered dispute resolution architecture. The universal service obligation (Drinkwaterbesluit), administrative objections procedure (bezwaar under the Awb), the Geschillencommissie Energie & Water consumer tribunal, and the National Ombudsman collectively absorb household water disputes before they escalate to courts. Dutch courts adjudicate water governance at the systemic level — dijk management, waterschap governance, spatial planning water assessments — not at the household service level.
CategoryCount%Distribution

Canada (Ontario focus)

3,218 decisions · 2016–2025 CanLII + Legal Data Hunter
3,218
Total Cases
5.0%
Fisheries Act
160 cases — federal jurisdiction
3.4%
Riparian / Waterway
108 cases
1.4%
Hydroelectric / Dam
44 cases
0%
Connection Refusal
Opaque administrative processing
Medium
Pre-litigation Absorption
Fragmented; provincial variation

Governance distribution

Canada — Classified Decisions (421 total)
86.9% of Canadian decisions are unclassifiable (other_water) due to title-only CanLII records with no summary text.

Temporal trend

Canada — Cases per Year (2016–2025)
2020 dip reflects COVID-19 court closures. Stable collection across all years.
Fragmented opacity: Canada's water law is characterized by constitutional division of powers: water services are provincially regulated, First Nations water is a federal responsibility (historically under-funded), and environmental water governance is shared. The dominance of fisheries (5.0%) and riparian rights (3.4%) in the classified decisions reflects the jurisdictional reach of the federal Fisheries Act — the one federal instrument that consistently generates water-related litigation across provinces. The absence of household service access cases likely reflects both genuine pre-litigation resolution at the municipal level and significant unmet legal need that never reaches courts.
Indigenous water gap: 0 cases coded as indigenous_water — an almost certain undercount. First Nations water insecurity generates substantial political and administrative contestation, but Title-only CanLII records rarely contain the substantive language needed for coding. The Legal Data Hunter semantic search component was designed partly to surface these cases; the near-zero count signals a limitation of the available data, not the absence of legal activity.
CategoryCount%Distribution

Cross-National Comparison

Governance distributions — top categories per country (excluding other_water)

Classified Decisions by Governance Category and Country
🇧🇷 BRAZIL — Key ratios
Tariff disputes
48.1%
Connection refusal
9.9%
Informal settlement
0.8%
HR language
1.9%
User win rate
31.2%
🇳🇱 NETHERLANDS — Key ratios
Flood protection
1.8%
Connection refusal
<0.1%
Env. protection
0.5%
HR language
0%
Not-water (filter)
22.7%
🇨🇦 CANADA — Key ratios
Fisheries
5.0%
Riparian / waterway
3.4%
Connection refusal
0%
HR language
0%
Hydroelectric/dam
1.4%
Dimension Brazil Netherlands Canada
Total decisions11,72468,6543,218
Data period2016–2025 + 1997–2015 (TJSP)2016–20252016–2025
Dominant disputeTariff (48.1%)Flood/env. governance (2.3%)Fisheries/riparian (8.4%)
Connection refusal9.9% (1,160)<0.1% (12)0%
Informal settlement0.8% (96)0%0%
HR language1.9% (226)0%0%
Win/loss coded4,481 decisionsNot availableNot available
User win rate31.2%
Utility win rate26.0%
MP involvement3.6% (427)N/AN/A
Public interest framing13.8% (1,616)
Pre-litigation absorptionLowHigh (Awb/Geschillencommissie)Medium (fragmented)
Legal Last Mile modelRights-declared, admin-deficientPre-litigation absorptionFragmented opacity
Courts covered8 state courts (of 27)All 11 Rechtbanken + appellateCanLII databases (multi-province)

Research Findings & Theoretical Framework

From: The Legal Last Mile: Administrative Law, Water Access, and the Limits of Judicial Inclusion — Preliminary research, 2026.

🚪

The Gatekeeper Thesis

Administrative law functions as a gatekeeper that determines whether physical access to water infrastructure translates into legally enforceable entitlement. Bureaucratic procedures — documentation requirements, property registration, formal address systems — filter who can assert rights before courts are ever reached.

👻

The Administrative Ghost

Populations excluded from formal administrative systems become invisible in the judicial record. Brazil's informal settlement cases (<1% of decisions) are not evidence of fewer legal problems — they are evidence of exclusion from the formal system. The absence itself is the finding.

⚖️

The Rights-Access Gap

A legal system can be simultaneously rights-saturated and access-deficient. Brazil has one of the world's strongest constitutional water rights frameworks, yet HR language appears in only 1.9% of decisions — and the populations most needing rights-based protection are least represented as plaintiffs.

🏗️

Pre-litigation Absorption (NL)

Where administrative systems are robust and universal, courts address systemic water governance (flood protection, spatial planning, waterboard regulation) rather than household access. The Dutch model absorbs service disputes before courts through the Awb complaints procedure and Geschillencommissie.

🧩

Fragmented Opacity (Canada)

Where jurisdiction is fragmented between federal and provincial levels with no universal service obligation, water disputes are processed through opaque administrative procedures with variable accessibility. The judicial footprint reflects resource governance, not household access — but the absence of access disputes may reflect invisibility, not resolution.

📊

Jurimetric Confirmation

The jurimetric distribution itself is evidence: 48% tariff vs. 10% connection refusal in Brazil; <0.1% connection refusal in NL; 0% in Canada. These ratios confirm the comparative MDSD analysis — the Legal Last Mile operates differently in each system, but the pattern of who doesn't appear is consistent across all three.


The Most Different Systems Design (MDSD)

Why Brazil, Netherlands, and Canada?

The three cases were selected on the basis of maximum variation on the key independent variable (administrative law model and pre-litigation architecture) while sharing the dependent variable of interest (formal constitutional or statutory recognition of water access rights):

DimensionBrazilNetherlandsCanada
Admin law traditionCivil law, fragmentedCivil law, comprehensive AwbCommon law, no general code
Water rights basisConstitutional (Art. 6, 225)Statutory (Drinkwaterbesluit)Statutory (provincial + Safe Drinking Water Act)
Universal service obligationPartial (urban utilities)Full (KWR/Vewin)None (federal)
Pre-litigation routesWeak (PROCON, ANS)Strong (bezwaar, Geschillencommissie, Ombudsman)Variable by province
Urbanisation / informalityHigh (15–20% informal)Very lowLow (urban)
Dataset coveragePartial (8 of 27 courts)Near-complete (all 11 districts)Multi-provincial via CanLII

Dataset & Methodology

Data Collection Infrastructure

Brazil (8 courts): Custom scrapers for ESAJ POST (TJAC, TJRR, TJSC, TJSP), Elasticsearch REST (TJDFT), ASP.NET WebForms (TJRJ), Rails GET (TJPI), PHP+Solr GET (TJTO). 19 of 27 courts blocked by CAPTCHA, authentication, or defunct APIs.

Netherlands: Rechtspraak.nl Open Data XML API covering all 11 Rechtbanken + Raad van State + CBb + GHARL.

Canada: CanLII REST API (keyword search + 113 extra databases) supplemented by Legal Data Hunter semantic search across the full CanLII corpus (94,502+ documents).

AI assistance: Claude (Anthropic) assisted with scraper development, data pipeline, coding engine design, and report generation. All research design and interpretation: Claudio Klaus Junior.

Jurimetric Coding Engine (v2.0)

21 governance categories in Portuguese, English, Dutch, and French (expanded from 12 in v1.0). Applied via jurimetric_coding.py (GitHub) to decision summaries and titles.

New in v2.0: flood_protection, environmental_protection, spatial_planning_water, waterboard_governance, pipe_leak_damage, water_theft_fraud, water_infrastructure_contract, fisheries_water — plus NL immigration pre-filter (not_water_related). Result: other_water reduced 75,442 → 57,695 (−23.5%).

7 variables per decision: hr_language · sust_language · governance_cat · win_loss · mp_involvement · indigenous_water · public_interest


Citation & Access

Dataset citation:
Klaus, C (2026) Global Water Law Judicial Decisions Dataset (v1.0) Zenodo <https://doi.org/10.5281/zenodo.19836413> accessed 3 May 2026.

Also archived at:
Harvard Dataverse: doi:10.7910/DVN/C9PEFS · DANS SSH: doi:10.17026/SS/RVDBUF · OSF: osf.io/admrq

Scholarly inspiration: This research is inspired by the work of Professor LaDawn Haglund (water governance, judicialization of water and sanitation rights in São Paulo, Brazil). See: Haglund (2014) Water Policy; Haglund (2019) in Economic and Social Rights in a Neoliberal World (Cambridge); Haglund (2019) Sustainability 11(19).