{"uid":"cap_WonjtkujIpGawdY3dLpM7","slug":"water-service-coverage-analyzer-category-frequencies-adjacent-row-e47aadd4","name":"Water Service Coverage Analyzer — Category Frequencies & Adjacent Row Changes","description":"Water service coverage — Category frequencies + Adjacent row changes: Category frequencies + Adjacent row changes 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-104?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"}}},"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_KmDtRgsVCRH4mxg6AikQE","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 analytical reports on water service coverage data: category frequency counts and adjacent row change detection for served_households or total_households fields.","exampleAgentPrompt":"I have water service coverage records for several regions — can you run a category frequency report and adjacent row change analysis on the served_households field? Here are up to 200 rows with row_id, region, date, served_households, and total_households.","exampleUseCases":[{"title":"Regional water access coverage audit","prompt":"I have monthly water service data for 12 regions over the past year — row_id, region, date, served_households, total_households. Can you run category frequencies and adjacent row changes on the served_households field so I can see which regions dominate and how coverage shifted month to month?"},{"title":"Detecting sudden drops in total households served","prompt":"We track total_households served by our water utility each week across districts. Can you analyze these 150 rows for adjacent row changes on total_households so I can spot any sudden drops or spikes between consecutive entries?"},{"title":"Summarizing household distribution across service zones","prompt":"I want a frequency breakdown of how our served_households values are distributed across the different regions in this dataset of 80 water coverage records — please run both the category frequency and row change reports using the served_households field."}],"resultDescription":"Returns two analytical reports: (1) category frequency counts showing how often each distinct value or category appears in the selected field across all supplied rows, and (2) adjacent row change values showing the difference between consecutive rows for the selected numeric field (served_households or total_households). Results are derived entirely from the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, region, date, served_households, total_households) cause validation errors","Exceeding 200 rows returns an error or truncates input","Invalid date format (non YYYY-MM-DD) fails pattern validation","Null values in numeric fields may affect adjacent row change calculations","Invalid field enum value (not served_households or total_households) causes rejection","Empty rows array returns an error"],"whenToPreferThis":"Choose this endpoint when you have tabular water service coverage data (up to 200 rows) and need two lightweight statistical summaries — category frequencies and row-to-row change detection — computed locally without any external data lookup, prediction, or enrichment. It is ideal for quick offline-style analytics on regional household water supply records at very low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:36:05.371Z","isFirstParty":false,"canonicalSlug":"water-service-coverage-analyzer-category-frequencies-adjacent-row-e47aadd4"}