{"uid":"cap_d3ookrKKdJeGkJyLVO0C8","slug":"water-service-coverage-category-frequencies-daily-sum-series-c8ce28a1","name":"Water Service Coverage — Category Frequencies + Daily Sum Series","description":"Water service coverage — Category frequencies + Daily sum series: Category frequencies + Daily sum 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-102?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_Lvj0Cy8bpkgdIPCUBBcjT","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":"Computes category-frequency counts and a daily sum time series for water service coverage data (served_households, total_households) from up to 200 supplied rows.","exampleAgentPrompt":"I have water service coverage records for two regions — here are 4 rows with row_id, region, date, served_households, and total_households fields — can you run both a category frequency breakdown and a daily sum series on the served_households field?","exampleUseCases":[{"title":"Regional water access frequency audit","prompt":"I have 150 daily water service records across multiple districts with served_households and total_households — can you give me a category frequency count by region and a daily sum series for served_households so I can see which areas show up most and how totals trend over time?"},{"title":"Daily household coverage trend analysis","prompt":"Run a daily sum series on the total_households field for my water utility dataset — I've got about 80 rows with dates, regions, row IDs, served_households, and total_households — I want to see the aggregated totals per day."},{"title":"Water utility coverage reporting for a municipality","prompt":"I need two reports on this municipal water coverage dataset: first, how frequently each region category appears, and second, the daily summed total for served_households — the data has row_id, region, date, served_households, and total_households columns across 60 rows."}],"resultDescription":"Two independent analytical reports: (1) category frequency counts showing how often each distinct value (e.g. region) appears in the dataset, and (2) a daily sum series aggregating the selected numeric field (served_households or total_households) by date. Results are derived entirely from the supplied rows with no external data sources.","failureModes":["Missing required fields (row_id, region, date, served_households, total_households) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Submitting more than 200 rows exceeds the maxItems limit","Null numeric values may affect sum calculations for affected dates","Invalid field enum value (anything other than served_households or total_households) causes rejection","Empty rows array is rejected due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you have tabular water service coverage data (up to 200 rows) and need both a categorical frequency breakdown and a date-based numeric sum series in a single cost-efficient call. It is ideal for offline/batch analytical use cases where no live lookup, external enrichment, or predictive modeling is needed — just local statistical summarization of supplied records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:36:04.579Z","isFirstParty":false,"canonicalSlug":"water-service-coverage-category-frequencies-daily-sum-series-c8ce28a1"}