{"uid":"cap_sxOolHhQKO5k_705L4_3Z","slug":"transport-ridership-exact-row-deduplication-duplicate-key-report-88b5f0f1","name":"Transport Ridership — Exact Row Deduplication + Duplicate Key Report","description":"Transport ridership — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report 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-038?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_pTx3miP7dzG1bEbu7gm7X","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 exact rows and generates a duplicate key report for transport ridership records (passenger_count, service_count) across up to 200 rows.","exampleAgentPrompt":"I have a batch of up to 200 transport ridership records with passenger_count and service_count fields — can you run exact row deduplication and generate a duplicate key report so I can see which rows are identical and which row_ids are repeated?","exampleUseCases":[{"title":"Transit data pipeline deduplication audit","prompt":"We just ingested 150 ridership records from three regional transit agencies into our data warehouse. Can you run exact row deduplication and give me a duplicate key report on these rows so I know which ones to drop before we load them?"},{"title":"Monthly ridership quality check","prompt":"Before I finalize the October ridership report, can you check these 80 rows of passenger_count and service_count records for exact duplicates and tell me which row_ids appear more than once?"},{"title":"Multi-region transit data merge cleanup","prompt":"I merged ridership data from group-a and group-b regions and now I have 200 rows that might have duplicates. Can you deduplicate them exactly and produce a report of any duplicate keys so I can fix the source feeds?"}],"resultDescription":"Returns two reports: (1) an exact row deduplication report identifying which rows are identical across all fields, and (2) a duplicate key report listing row_ids that appear more than once — both derived analytically from the supplied ridership records without any external lookups.","failureModes":["Exceeding 200 rows in the input array returns a validation error","Missing required fields (row_id, region, date, passenger_count, service_count) cause row-level rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation error","Numeric values outside the allowed range (-1,000,000,000,000 to 1,000,000,000,000) are rejected","Empty rows array (minItems: 1 not met) returns an error","Payment of 0.01 USDC not settled via x402 protocol results in an authorization failure"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a duplicate key report in a single call for transport ridership data (passenger_count, service_count). It is ideal for data quality pipelines, pre-load audits, or post-merge cleanups where the dataset is up to 200 rows and no live external data or predictions are required. Prefer it over generic deduplication tools when your data specifically contains ridership fields and you want two structured analytical reports from one cheap ($0.01 USDC) call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T12:42:31.954Z","isFirstParty":false,"canonicalSlug":"transport-ridership-exact-row-deduplication-duplicate-key-report-88b5f0f1"}