{"uid":"cap_w6wfd3qUEKwajL1IE5KTs","slug":"transport-ridership-exact-row-deduplication-daily-sum-series-20c9ac56","name":"Transport Ridership — Exact Row Deduplication + Daily Sum Series","description":"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.","url":"https://market.datapackvibe.com/x402/assistant-ib26-economics-05-044?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_6UTBxe5ckkEG-QmfnfNME","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Daily Passenger Count Rollup","prompt":"I have 180 rows of raw bus ridership data with duplicates — each row has a row_id, region, date, and passenger_count. Can you deduplicate them and show me the daily total passenger counts as a time series?"},{"title":"Service Count Deduplication Audit","prompt":"Our transit dataset has some repeated entries mixed in. Can you run exact row deduplication on my 120 service records and also give me a daily sum series for service_count so I can spot anomalies by date?"},{"title":"Multi-Region Ridership Cleanup","prompt":"I've got ridership records across two regions, group-a and group-b, with possible duplicate rows. Please deduplicate the data and produce a daily passenger_count sum series so I can compare trends over time."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:31:59.630Z","isFirstParty":false,"canonicalSlug":"transport-ridership-exact-row-deduplication-daily-sum-series-20c9ac56"}