# Transport Ridership — Exact Row Deduplication + Daily Sum Series

> Transport Ridership — Exact Row Deduplication + Daily Sum Series 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-25).

Deduplicates transport ridership records and computes daily sum time series for passenger_count or service_count, returning two analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-economics-05-044?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-25
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/transport-ridership-exact-row-deduplication-daily-sum-series-20c9ac56
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_w6wfd3qUEKwajL1IE5KTs

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-exact-row-deduplication-daily-sum-series-20c9ac56 -d '<json body>'
```

Example prompt: Can you deduplicate these transport ridership rows and give me a daily sum series for passenger_count? I have about 150 rows with columns row_id, region, date, passenger_count, and service_count.

## When to prefer this

Choose this endpoint when you need both exact duplicate removal and a daily sum time series for transport ridership data (passenger or service counts) in a single $0.01 call covering up to 200 rows. Ideal for pre-processing raw transit logs before deeper analysis, auditing data pipelines for duplicate entries, or producing quick daily rollups without setting up local infrastructure. Not suitable for live lookups, predictions, or datasets exceeding 200 rows.

## Known failure modes

- Input exceeds 200 rows — request rejected with validation error
- Missing required fields (row_id, region, date, passenger_count, service_count) — schema validation failure
- Invalid date format (must match YYYY-MM-DD pattern) — parsing error
- Numeric values outside allowed range (±1,000,000,000,000) — validation rejection
- Empty rows array — minItems constraint violation
- Payment not fulfilled via x402 protocol — 402 response before processing

## How this service works

Transport ridership — Exact row deduplication + Daily sum series: Exact row deduplication + Daily sum series for supplied transport ridership records (passenger_count, service_count). 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 deduplicated version of the submitted ridership rows with exact duplicates removed, and (2) a daily sum time series aggregating the selected field (passenger_count or service_count) by date across all records, up to 200 input 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-exact-row-deduplication-daily-sum-series-20c9ac56/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)