{"uid":"cap_GfgxI19nO2NRYEMrHdVIL","slug":"air-quality-observations-duplicate-key-report-category-frequencies-a2a55722","name":"Air Quality Observations — Duplicate Key Report + Category Frequencies","description":"Air quality observations — Duplicate key report + Category frequencies: Duplicate key report + Category frequencies for supplied air quality observations records (concentration, observation_count). 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-weather-10-057?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station_group","date","concentration","observation_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"concentration":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"station_group":{"type":"string","default":"","maxLength":80},"observation_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","concentration":10,"station_group":"group-a","observation_count":1},{"date":"2026-10-02","row_id":"row-2","concentration":20,"station_group":"group-b","observation_count":2},{"date":"2026-10-03","row_id":"row-3","concentration":15,"station_group":"group-a","observation_count":3},{"date":"2026-10-04","row_id":"row-4","concentration":30,"station_group":"group-b","observation_count":4}],"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_qYg0EKGovXirYhKvZLzSN","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 air quality observation rows to produce a duplicate key report and category frequency distribution for concentration and observation_count fields.","exampleAgentPrompt":"Can you check these air quality observation records for duplicate station-date keys and also give me a frequency breakdown of the categories across concentration and observation_count? I have about 50 rows with fields like row_id, station_group, date, concentration, and observation_count.","exampleUseCases":[{"title":"Audit air quality dataset for duplicates","prompt":"I've got a batch of air quality readings from multiple monitoring stations — can you scan them for any duplicate row IDs or repeated station-date combinations and tell me which keys are duplicated?"},{"title":"Category frequency breakdown for concentration data","prompt":"For my air quality dataset with about 120 rows of concentration measurements and observation counts, can you generate a frequency distribution showing how often each category appears across the data?"},{"title":"Pre-pipeline data quality check","prompt":"Before I load these 80 air quality observation records into our pipeline, can you run a duplicate key check and category frequency report on the concentration and observation_count columns so I can catch any data issues early?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying which row_id, station_group, or date combinations appear more than once across the submitted records, and (2) a category frequency table showing how often each distinct category value appears in the concentration and observation_count fields — all computed locally from the supplied data, covering up to 200 rows.","failureModes":["Submitting more than 200 rows returns an error or truncates input","Missing required fields (row_id, station_group, date, concentration, observation_count) cause validation failure","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Empty rows array returns an error (minItems: 1)","Non-numeric values in concentration or observation_count fields cause type validation failure"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously check for duplicate keys AND get category frequency distributions in a single call on air quality observation data (up to 200 rows). It is ideal for lightweight, local data quality audits that do not require live lookups, predictions, or external data enrichment. It is cost-effective at $0.01 USDC for two reports in one call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:47:30.417Z","isFirstParty":false,"canonicalSlug":"air-quality-observations-duplicate-key-report-category-frequencies-a2a55722"}