# Water Service Coverage — Exact Row Deduplication + Category Frequencies

> Water Service Coverage — Exact Row Deduplication + Category Frequencies is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-11-03).

Deduplicates water service coverage records and computes category frequency statistics for region and date fields across served/total household data.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-economics-19-041?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-03
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/water-service-coverage-exact-row-deduplication-category-frequencies-f37b160e
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_FTbCE4BxtiQHIQlhHq1rV

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability water-service-coverage-exact-row-deduplication-category-frequencies-f37b160e -d '<json body>'
```

Example prompt: I have a list of up to 200 water service coverage records with region, date, served_households, and total_households — can you deduplicate the exact rows and give me a frequency breakdown by category (like how many records per region)?

## When to prefer this

Choose this endpoint when you have a batch of up to 200 water service coverage records (with served_households and total_households fields) and need both exact duplicate removal and category frequency analysis in a single low-cost call. Ideal for data quality checks before reporting or aggregation pipelines where you need region/date frequency distributions alongside deduplication. Not suitable for live data lookup, predictive modeling, or datasets exceeding 200 rows.

## Known failure modes

- Payload exceeds 200 rows — request will be rejected or truncated
- Missing required fields (row_id, region, date, served_households, total_households) cause validation errors
- Malformed date strings not matching YYYY-MM-DD pattern are rejected
- Numeric values outside allowed range (-1T to +1T) are rejected
- Empty rows array returns error due to minItems:1 constraint

## How this service works

Water service coverage — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies for supplied water service coverage records (served_households, total_households). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.

## Output

Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate records from the submitted water service coverage rows, and (2) category frequency counts showing how often each region and date value appears across the dataset. Results are derived purely from the submitted rows (up to 200) with no external lookups.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "region",
     "date",
     "served_households",
     "total_households"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "region": {
      "type": "string",
      "default": "",
      "maxLength": 80
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "total_households": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "served_households": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "region": "group-a",
     "row_id": "row-1",
     "total_households": 1,
     "served_households": 10
    },
    {
     "date": "2026-10-02",
     "region": "group-b",
     "row_id": "row-2",
     "total_households": 2,
     "served_households": 20
    },
    {
     "date": "2026-10-03",
     "region": "group-a",
     "row_id": "row-3",
     "total_households": 3,
     "served_households": 15
    },
    {
     "date": "2026-10-04",
     "region": "group-b",
     "row_id": "row-4",
     "total_households": 4,
     "served_households": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/water-service-coverage-exact-row-deduplication-category-frequencies-f37b160e/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)