{"uid":"cap_FTbCE4BxtiQHIQlhHq1rV","slug":"water-service-coverage-exact-row-deduplication-category-frequencies-f37b160e","name":"Water Service Coverage — Exact Row Deduplication + Category Frequencies","description":"Water service coverage — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies 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-041?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_lBgO6OXTbeoIQgKUNg90x","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 water service coverage records and computes category frequency statistics for region and date fields across served/total household data.","exampleAgentPrompt":"I have a list of up to 200 water service coverage records with region, date, served_households, and total_households — can you deduplicate the exact rows and give me a frequency breakdown by category (like how many records per region)?","exampleUseCases":[{"title":"Cleaning regional water survey data","prompt":"I've collected water service coverage records from multiple field teams and I suspect there are duplicate entries. Can you deduplicate the exact rows and show me how many records we have per region? Here are up to 200 rows with row_id, region, date, served_households, and total_households."},{"title":"Auditing household coverage dataset quality","prompt":"Before I submit this water coverage dataset to our reporting system, can you check it for exact duplicate rows and also give me category frequency counts by region and date so I can spot data collection issues?"},{"title":"Summarizing coverage data by region frequency","prompt":"I have water service records for several regions spanning multiple dates — can you remove any exact duplicates and then tell me how frequently each region and date appears in the cleaned dataset?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate records from the submitted water service coverage rows, and (2) category frequency counts showing how often each region and date value appears across the dataset. Results are derived purely from the submitted rows (up to 200) with no external lookups.","failureModes":["Payload exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, region, date, served_households, total_households) cause validation errors","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Numeric values outside allowed range (-1T to +1T) are rejected","Empty rows array returns error due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you have a batch of up to 200 water service coverage records (with served_households and total_households fields) and need both exact duplicate removal and category frequency analysis in a single low-cost call. Ideal for data quality checks before reporting or aggregation pipelines where you need region/date frequency distributions alongside deduplication. Not suitable for live data lookup, predictive modeling, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-03T12:43:09.254Z","isFirstParty":false,"canonicalSlug":"water-service-coverage-exact-row-deduplication-category-frequencies-f37b160e"}