{"uid":"cap_ZYHLRh9nsFy2a2UcwetJK","slug":"water-service-coverage-record-quality-audit-trailing-mean-series-43d02686","name":"Water Service Coverage — Record Quality Audit + Trailing Mean Series","description":"Water service coverage — Record quality audit + Trailing mean series: Record quality audit + Trailing mean series 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-010?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},"field":{"enum":["served_households","total_households"],"type":"string","default":"served_households"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_atU0w--lja1pxWZ8u_37z","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 trailing mean time series, for up to 200 rows of served/total household data.","exampleAgentPrompt":"Can you run a record quality audit and trailing mean series on my water service coverage data? I have 150 rows with region, date, served_households, and total_households — use served_households as the target field with a window of 7.","exampleUseCases":[{"title":"Monthly water coverage data quality check","prompt":"I just pulled 120 rows of monthly water service records for our districts — each row has a region, date, served_households, and total_households. Can you run a quality audit on them and also compute a trailing mean for served_households with a window of 4 so I can spot trends?"},{"title":"Detecting bad records in household water data","prompt":"We received a batch of 80 water coverage records from field teams and I'm worried some have nulls or bad values. Run a record quality audit on served_households and total_households for me — here are all 80 rows with row_id, region, and date included."},{"title":"Rolling average for water access reporting","prompt":"For our quarterly infrastructure report I need a trailing mean series for total_households across 60 regional water service records spanning the last two years. Use a window of 6 and flag any quality issues you find in the data while you're at it."}],"resultDescription":"Returns two independent reports: (1) a record quality audit identifying issues such as nulls, out-of-range values, or schema violations in the served_households and total_households fields; and (2) a trailing mean time series computing rolling averages over the specified window for the chosen field, grouped by region and date.","failureModes":["Fewer than 1 or more than 200 rows submitted — validation error","Invalid date format (not YYYY-MM-DD) — schema rejection","Missing required fields (row_id, region, date, served_households, total_households) — validation error","Window size larger than number of rows — trailing mean may return empty or partial results","Non-numeric values in served_households or total_households — quality audit flags or processing error","Payment not provided or insufficient — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously validate the integrity of water service coverage records and compute rolling averages over time, without needing live data lookup, external enrichment, or predictive modeling. It is ideal for batch quality assurance workflows on utility datasets of up to 200 rows where both a data audit and a time-series smoothing report are needed in a single call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:38:48.055Z","isFirstParty":false,"canonicalSlug":"water-service-coverage-record-quality-audit-trailing-mean-series-43d02686"}