# Join Coverage Analytics — Exact Row Deduplication + Numeric Distribution

> Join Coverage Analytics — Exact Row Deduplication + Numeric Distribution is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-23).

Analyzes up to 200 join coverage records by performing exact row deduplication and numeric distribution reporting on matched_rows or source_rows fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-039?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-23
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/join-coverage-analytics-exact-row-deduplication-numeric-distribution-4bfe1e4f
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_5dlMThE1NQEqDMwpTraHH

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 join-coverage-analytics-exact-row-deduplication-numeric-distribution-4bfe1e4f -d '<json body>'
```

Example prompt: Can you deduplicate these join coverage rows and give me a numeric distribution report on the matched_rows field? I have 4 records across two groups (group-a and group-b) from October 2026 with row IDs row-1 through row-4.

## When to prefer this

Choose this endpoint when you need to simultaneously deduplicate join coverage records and compute numeric distribution statistics on matched_rows or source_rows in a single low-cost call. Ideal for data quality checks on ETL join outputs, pipeline audit workflows, or any scenario where you have up to 200 join coverage records and want both deduplication and distributional analysis without external dependencies or live data lookups.

## Known failure modes

- Input array exceeds 200 rows — request will be rejected
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation failure
- Invalid date format (non-YYYY-MM-DD) causes schema rejection
- Numeric values outside ±1,000,000,000,000 range cause validation error
- Empty rows array (minItems:1 violated) causes rejection

## How this service works

Join coverage — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution for supplied join coverage records (matched_rows, source_rows). 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 duplicate records from the submitted rows, and (2) a numeric distribution report summarizing the statistical spread of the selected field (matched_rows or source_rows) across the submitted dataset. Both reports are computed locally with no external lookups.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-analytics-exact-row-deduplication-numeric-distribution-4bfe1e4f/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)