{"uid":"cap_5dlMThE1NQEqDMwpTraHH","slug":"join-coverage-analytics-exact-row-deduplication-numeric-distribution-4bfe1e4f","name":"Join Coverage Analytics — Exact Row Deduplication + Numeric Distribution","description":"Join coverage — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution for supplied join coverage records (matched_rows, source_rows). 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-analytics-09-039?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["matched_rows","source_rows"],"type":"string","default":"matched_rows"}}},"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_Nsu5cQLTmHMNWYCZ5ynE2","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":"Analyzes up to 200 join coverage records by performing exact row deduplication and numeric distribution reporting on matched_rows or source_rows fields.","exampleAgentPrompt":"Can you deduplicate these join coverage rows and give me a numeric distribution report on the matched_rows field? I have 4 records across two groups (group-a and group-b) from October 2026 with row IDs row-1 through row-4.","exampleUseCases":[{"title":"ETL pipeline join coverage audit","prompt":"I have 150 rows of join coverage data from our nightly ETL run with row IDs, dataset groups, dates, and matched_rows counts — can you deduplicate them exactly and show me the numeric distribution of matched_rows across all groups?"},{"title":"Source row count distribution check","prompt":"Here are 80 join coverage records tagged with dataset groups and dates. Run exact row deduplication on them and give me a distribution report on the source_rows field so I can see how the counts spread out."},{"title":"Cross-group duplicate detection","prompt":"I need to check whether any of these 200 join coverage records from group-alpha and group-beta are exact duplicates, and also get a numeric distribution on matched_rows — can you run both reports at once?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing duplicate records from the submitted rows, and (2) a numeric distribution report summarizing the statistical spread of the selected field (matched_rows or source_rows) across the submitted dataset. Both reports are computed locally with no external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation failure","Invalid date format (non-YYYY-MM-DD) causes schema rejection","Numeric values outside ±1,000,000,000,000 range cause validation error","Empty rows array (minItems:1 violated) causes rejection"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously deduplicate join coverage records and compute numeric distribution statistics on matched_rows or source_rows in a single low-cost call. Ideal for data quality checks on ETL join outputs, pipeline audit workflows, or any scenario where you have up to 200 join coverage records and want both deduplication and distributional analysis without external dependencies or live data lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:29.127Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-exact-row-deduplication-numeric-distribution-4bfe1e4f"}