# Water Service Coverage — Duplicate Key Report + Date by Category Pivot

> Water Service Coverage — Duplicate Key Report + Date by Category Pivot 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).

Runs two local analytical reports on water service coverage data: a duplicate key detector and a date-by-region pivot table for served or total households.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-economics-19-068?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-duplicate-key-report-date-by-category-pivot-af4cfe90
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Z7vPI-m-zfzZwkSbsYKm_

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-duplicate-key-report-date-by-category-pivot-af4cfe90 -d '<json body>'
```

Example prompt: Can you check my water service coverage records for duplicate row IDs and also pivot the served_households field by date and region? I have up to 200 rows with fields like row_id, region, date, served_households, and total_households.

## When to prefer this

Choose this endpoint when you need to simultaneously audit water service coverage records for duplicate row identifiers AND generate a date-by-region pivot summary in a single paid call. It is purpose-built for water utility household coverage data (served_households, total_households) and handles up to 200 rows at a low flat cost. Prefer it over generic analytics tools when your data already conforms to the expected schema and you want both data quality validation and pivot summarization in one step.

## Known failure modes

- Missing required fields (row_id, region, date, served_households, total_households) causes validation error
- Submitting more than 200 rows exceeds the maxItems limit and will be rejected
- Invalid date format (not YYYY-MM-DD) causes schema validation failure
- Empty rows array (minItems: 1) triggers an error
- Null numeric values may affect pivot aggregation results
- Payment failure or insufficient USDC balance prevents execution

## How this service works

Water service coverage — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot 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) a duplicate key report identifying any repeated row_id values across the supplied records, and (2) a date-by-category pivot table cross-tabulating the selected field (served_households or total_households) by date and region. Both reports are computed locally from the supplied data 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
  },
  "field": {
   "enum": [
    "served_households",
    "total_households"
   ],
   "type": "string",
   "default": "served_households"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/water-service-coverage-duplicate-key-report-date-by-category-pivot-af4cfe90/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)