{"uid":"cap_eIAUxL7tF178DEBhMrXGD","slug":"water-service-coverage-record-quality-audit-duplicate-key-report-6bb06280","name":"Water Service Coverage — Record Quality Audit + Duplicate Key Report","description":"Water service coverage — Record quality audit + Duplicate key report: Record quality audit + Duplicate key report for supplied water service coverage records (served_households, total_households). 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-19-003?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","served_households","total_households"],"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},"total_households":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"served_households":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","total_households":1,"served_households":10},{"date":"2026-10-02","region":"group-b","row_id":"row-2","total_households":2,"served_households":20},{"date":"2026-10-03","region":"group-a","row_id":"row-3","total_households":3,"served_households":15},{"date":"2026-10-04","region":"group-b","row_id":"row-4","total_households":4,"served_households":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_YjmZ53WK96sjZxm27OFlf","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":"Runs two local analytical reports on water service coverage data: a record quality audit and a duplicate key detection report, for up to 200 rows.","exampleAgentPrompt":"Can you audit this water service coverage dataset for record quality issues and flag any duplicate row IDs? I have up to 50 rows with fields like row_id, region, date, served_households, and total_households that I want checked.","exampleUseCases":[{"title":"Pre-load data quality check","prompt":"Before I import this water coverage dataset into our database, can you run a quality audit and duplicate key check on these 120 rows — each row has a row_id, region, date, served_households, and total_households?"},{"title":"Monthly reporting data validation","prompt":"I've got this month's water service coverage report with 80 records across different regions. Can you audit them for quality issues and tell me if any row IDs are duplicated before I send it upstream?"},{"title":"Data migration deduplication","prompt":"We're migrating water household coverage records from a legacy system — here are 200 rows with served_households and total_households values. Can you flag any quality problems and identify duplicate keys so we can clean them up first?"}],"resultDescription":"Two independent analytical reports: (1) a record quality audit covering completeness, format validity, and value range issues for each row; and (2) a duplicate key report identifying rows with repeated row_id values or other key collisions — all computed locally without any external lookups or live data access.","failureModes":["Rows array is empty or missing — minimum 1 row required","More than 200 rows submitted — maxItems limit exceeded","row_id field is missing or blank — minLength 1 required","date field does not match YYYY-MM-DD pattern — pattern validation failure","served_households or total_households values outside ±1,000,000,000,000 range","Additional properties included in row objects — additionalProperties: false enforced","Payment not included or insufficient — endpoint requires $0.01 USDC via x402"],"whenToPreferThis":"Choose this endpoint when you need to validate water service coverage records (served_households, total_households) for data quality and duplicate keys in a single low-cost call. It is best suited for batch validation of up to 200 rows before ingestion, reporting, or migration, where no live data lookup or external enrichment is needed and you want two distinct diagnostic reports for a flat $0.01 USDC fee.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:36:31.249Z","isFirstParty":false,"canonicalSlug":"water-service-coverage-record-quality-audit-duplicate-key-report-6bb06280"}