{"uid":"cap_AnXnfJxms3PidYededCke","slug":"transport-ridership-record-quality-audit-and-exact-row-deduplication-87ec55d1","name":"Transport Ridership Record Quality Audit and Exact Row Deduplication","description":"Transport ridership — Record quality audit + Exact row deduplication: Record quality audit + Exact row deduplication 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-002?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}}},"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_tpkjhgag0hJdHoNY_M8T7","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":"Audits transport ridership records for data quality issues and identifies exact duplicate rows across up to 200 rows of passenger and service count data, returning two independent analytical reports.","exampleAgentPrompt":"Can you run a record quality audit and exact duplicate check on my transport ridership data? I have about 50 rows with passenger_count and service_count fields across different regions and dates — I need two reports: one for data quality issues and one showing any exact duplicate rows.","exampleUseCases":[{"title":"Pre-analysis ridership data cleanup","prompt":"Before I run my monthly ridership analysis, can you audit these 120 transit records for data quality issues and find any exact duplicate rows? The data has region, date, passenger_count, and service_count columns and I want both the quality audit and deduplication report."},{"title":"Transit agency data submission validation","prompt":"We're submitting our quarterly ridership data to the state agency and need to make sure it's clean — can you check these 80 rows for record quality problems and flag any exact duplicates in the passenger and service count data?"},{"title":"ETL pipeline data integrity check","prompt":"After our ETL pipeline ran last night I want to verify the transport ridership records it produced — please run a quality audit and exact row deduplication on these 45 rows so I can catch any bad or repeated records before they go into the warehouse."}],"resultDescription":"Returns two independent reports: (1) a record quality audit flagging issues such as missing values, out-of-range numbers, malformed dates, or invalid fields in the ridership rows; and (2) an exact row deduplication report identifying which rows are exact duplicates of one another, including row IDs and duplicate groupings. Both reports are produced locally without any external lookups or predictions.","failureModes":["Input array is empty or missing — validation error returned","More than 200 rows submitted — request rejected with row limit error","Row missing required fields (row_id, region, date, passenger_count, or service_count) — validation error with field details","Date field does not match YYYY-MM-DD pattern — format validation error","row_id exceeds 80 characters or is empty — schema validation error","Payment not provided or insufficient — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously audit ridership record quality AND detect exact duplicate rows in a single API call at low cost ($0.01 USDC). It is ideal for pre-processing transport ridership datasets (passenger counts, service counts by region and date) before downstream analytics or reporting. It works entirely on supplied data with no external lookups, making it deterministic and privacy-safe. Prefer this over general-purpose data validation tools when your data specifically contains transport ridership fields (passenger_count, service_count, region, date).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:31:52.330Z","isFirstParty":false,"canonicalSlug":"transport-ridership-record-quality-audit-and-exact-row-deduplication-87ec55d1"}