{"uid":"cap_SFScCxvKgK6at-48mQBLb","slug":"tourism-observations-exact-row-deduplication-numeric-row-ordering-9314d0fd","name":"Tourism Observations — Exact Row Deduplication + Numeric Row Ordering","description":"Tourism observations — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering for supplied tourism observations records (visitor_count, overnight_stays). 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-14-042?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","visitor_count","overnight_stays"],"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},"visitor_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"overnight_stays":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","visitor_count":10,"overnight_stays":1},{"date":"2026-10-02","region":"group-b","row_id":"row-2","visitor_count":20,"overnight_stays":2},{"date":"2026-10-03","region":"group-a","row_id":"row-3","visitor_count":15,"overnight_stays":3},{"date":"2026-10-04","region":"group-b","row_id":"row-4","visitor_count":30,"overnight_stays":4}],"maxItems":200,"minItems":1},"field":{"enum":["visitor_count","overnight_stays"],"type":"string","default":"visitor_count"}}},"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_c2R4F3gLdGl4T1sEs4-t0","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 exact duplicate rows and applies numeric ordering to tourism observation records (visitor_count, overnight_stays) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Can you deduplicate and numerically order my tourism observation rows? I have records with visitor_count and overnight_stays across several regions — here are up to 200 rows and I want 2 reports back covering deduplication and numeric row ordering for the visitor_count field.","exampleUseCases":[{"title":"Clean regional tourism dataset before reporting","prompt":"I have 150 rows of regional tourism data with visitor_count and overnight_stays — can you deduplicate the exact duplicate rows and then sort them numerically by visitor_count? I need both reports for my quarterly review."},{"title":"Audit overnight stays data for duplicates","prompt":"Before I submit this dataset to my analytics team, can you run exact row deduplication and numeric ordering on my tourism observations, focusing on the overnight_stays field? There are about 80 rows across different regions and dates."},{"title":"Standardize tourism observation export","prompt":"I exported tourism observation records from our system and I suspect there are duplicate entries — can you deduplicate them exactly and give me a numerically ordered view sorted by visitor_count? I've got around 60 rows with region, date, visitor_count, and overnight_stays."}],"resultDescription":"Returns 2 analytical reports: one covering exact row deduplication (identifying and removing fully duplicate rows) and one covering numeric row ordering applied to the selected field (visitor_count or overnight_stays), based entirely on the submitted data with no external lookups.","failureModes":["Missing required fields (row_id, region, date, visitor_count, overnight_stays) cause validation errors","Exceeding 200 row limit returns an error","Invalid date format (not YYYY-MM-DD) triggers a pattern validation failure","Empty rows array is rejected","Selecting a field value outside the enum (visitor_count, overnight_stays) causes an error"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local-only deduplication and numeric ordering for tourism observation datasets (visitor counts and overnight stays) without any external data enrichment or prediction. Ideal for data cleaning pipelines that need two bundled reports at low cost ($0.01 USDC) for datasets up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:53:08.264Z","isFirstParty":false,"canonicalSlug":"tourism-observations-exact-row-deduplication-numeric-row-ordering-9314d0fd"}