# Transport Ridership Data Quality Audit, Deduplication, and Adjacent Row Changes

> Transport Ridership Data Quality Audit, Deduplication, and Adjacent Row Changes 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-26).

Runs three local analytical reports on transport ridership data: record quality audit, exact row deduplication, and adjacent row change detection — all in a single call for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-economics-05-217?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-26
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/transport-ridership-data-quality-audit-deduplication-and-adjacent-row-8e8a6b9c
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_tv-Oa59SkFHrKEqVW3jH_

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 transport-ridership-data-quality-audit-deduplication-and-adjacent-row-8e8a6b9c -d '<json body>'
```

Example prompt: Can you run a quality audit, exact deduplication check, and adjacent row change detection on my transport ridership records? Here are the rows — I want to analyze the passenger_count field across regions like 'north-line' and 'south-line' for dates in October 2025.

## When to prefer this

Choose this endpoint when you need three standard data quality operations — quality audit, exact deduplication, and adjacent row change detection — on transport ridership data in a single low-cost call. It is ideal for pre-processing pipelines that validate transit datasets before downstream analysis or reporting. Prefer this over separate tools when your dataset fits within 200 rows and you want all three reports bundled for $0.01 USDC. Not suitable if you need live ridership lookups, predictive analytics, or processing beyond 200 rows.

## Known failure modes

- More than 200 rows submitted — request will be rejected or truncated
- Missing required fields (row_id, region, date, passenger_count, service_count) cause validation errors
- Invalid date format (not YYYY-MM-DD) causes schema rejection
- Field selector not in allowed enum ['passenger_count','service_count'] causes error
- Empty rows array rejected due to minItems:1 constraint
- Payment failure via x402 protocol prevents execution

## How this service works

Transport ridership — Record quality audit + Exact row deduplication + Adjacent row changes: Record quality audit + Exact row deduplication + Adjacent row changes for supplied transport ridership records (passenger_count, service_count). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.

## Output

Three independent analytical reports returned together: (1) a record quality audit flagging nulls, type mismatches, or out-of-range values in the specified field; (2) an exact row deduplication report identifying fully duplicated rows; (3) an adjacent row changes report showing value differences between consecutive rows for the chosen field (passenger_count or service_count). No external data is fetched — all analysis is performed locally on the supplied rows.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "region",
     "date",
     "passenger_count",
     "service_count"
    ],
    "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
     },
     "service_count": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "passenger_count": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "region": "group-a",
     "row_id": "row-1",
     "service_count": 1,
     "passenger_count": 10
    },
    {
     "date": "2026-10-02",
     "region": "group-b",
     "row_id": "row-2",
     "service_count": 2,
     "passenger_count": 20
    },
    {
     "date": "2026-10-03",
     "region": "group-a",
     "row_id": "row-3",
     "service_count": 3,
     "passenger_count": 15
    },
    {
     "date": "2026-10-04",
     "region": "group-b",
     "row_id": "row-4",
     "service_count": 4,
     "passenger_count": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "passenger_count",
    "service_count"
   ],
   "type": "string",
   "default": "passenger_count"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/transport-ridership-data-quality-audit-deduplication-and-adjacent-row-8e8a6b9c/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)
