The Legal Last Mile

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

83,596 decisions Brazil: 11,724 Netherlands: 68,654 Canada: 3,218 2016 – 2026
v0.3.0 · May 2026 · Validated Residual audit complete: genuine other_water residual reduced 89.2% → 8.3%. NWR filter precision 99.79% (207-case gold-standard, pop.-weighted). Cohen's κ = 0.568 three-label; binary WATER/NOT_WATER κ = 0.932 (n = 59, excludes UNCERTAIN). Read Audit ↗ Validation Folder ↗
83,596
Total Decisions
3 jurisdictions · 2016–2026
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 · v0.3.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
not_water_related (81.0%) and other_water genuine residual (8.3%) excluded. v0.3.0 water-core vocabulary filter applied globally — residual reduced from 89.2% → 8.3%.
Brazil signal: Tariff disputes dominate (48.5%). Connection refusal: 10.9% — v0.3.0 rescue patterns recovered 115 additional cases vs v0.2.x. The access threshold question remains systematically underrepresented.
Netherlands signal: 98.6% of 68,654 decisions are scraping false positives with no water vocabulary. Of 989 genuine water decisions, only 8 involve household connection refusal — pre-litigation absorption confirmed at near-total scale.
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: 0.75% of Brazilian decisions (88 of 11,724). Zero user wins across all 88 cases. Zero HR language. The absence itself is the finding — confirmed by residual audit.

Brazil

11,724 decisions · 2016–2026 8 state courts + TJSP historical
11,724
Total Cases
99.7% genuine water-related
48.5%
Tariff Disputes
5,689 cases (↑55 vs v0.2.x)
10.9%
Connection Refusal
1,275 cases (↑115 via rescue patterns)
0.75%
Informal Settlement
88 cases · 0 user wins · Administrative Ghost
31.2%
User Win Rate
of 4,481 coded outcomes
1.9%
HR Language
226 decisions · 0 in informal settlement

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
98.6%
False Positives
67,665 — no water vocabulary (v0.3.0 audit)
989
Genuine Water Decisions
1.4% of total — confirmed by vocabulary check
8
Connection Refusal
0.012% of total — pre-litigation absorption
212
Flood Protection
21.4% of genuine water decisions
High
Pre-litigation Absorption
Bezwaar/Awb/Geschillencommissie/Ombudsman

Governance distribution

Netherlands — Excluding other_water & not_water_related
Substantive categories from 989 confirmed genuine water decisions (v0.3.0 water-vocabulary filter). Flood protection and spatial planning 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 — v0.3.0 finding: The residual audit confirms that 98.6% of the NL dataset (67,665 of 68,654 decisions) contains no water vocabulary — these are scraping false positives, not concealed water cases. Of the 989 confirmed genuine water decisions, only 8 involve household connection refusal (0.012% of total dataset). The Dutch model — universal service obligation (Drinkwaterbesluit), bezwaar procedure under the Awb, Geschillencommissie Energie & Water, and the National Ombudsman — absorbs household water access disputes virtually completely before courts are reached. The 989 genuine cases adjudicate systemic water governance: dijk management, waterschap regulation, spatial planning assessments — not individual service delivery.
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.5%
Connection refusal
10.9%
Informal settlement
0.75%
HR language
1.9%
User win rate
31.2%
🇳🇱 NETHERLANDS — Key ratios
False positives
98.6%
Genuine water cases
1.4%
Flood protection
0.31%
Connection refusal
0.012%
HR language
0%
🇨🇦 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–2026 + 1997–2015 (TJSP)2016–20252016–2025
Genuine water decisions11,686 (99.7%)989 (1.4%)421 (13.1%)
False positives (v0.3.0)38 (0.3%)67,665 (98.6%)2,797 (86.9%) residual
Dominant disputeTariff (48.5%)Flood protection (21.4% of water)Fisheries/riparian (8.4% of water)
Connection refusal10.9% (1,275)0.012% (8)0%
Informal settlement0.75% (88) · 0 user wins0%0%
HR language1.9% (226) · 0 in informal settlement0%0%
Win/loss coded4,481 outcomes codedNot availableNot available
User win rate31.2% (of coded outcomes)
Utility win rate26.0%
Pre-litigation absorptionLowHigh (Awb/Geschillencommissie/Ombudsman)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 v0.3.0: Broad water-core vocabulary filter applied to ALL decisions (replaces narrow NL immigration filter). Three Brazil rescue patterns (tariff, connection, pipe). Result: genuine other_water reduced from 89.2% → 8.3%; 67,703 decisions reclassified as not_water_related. Validation infrastructure added: residual audit, kappa calculator, XLM-RoBERTa transformer classifier, second-coder protocol.

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).