{"uid":"cap_Kf1Nm9gacs3Ud-TGCAOGq","slug":"company-headcount-observations-category-frequencies-date-by-category-90675488","name":"Company Headcount Observations — Category Frequencies & Date-by-Category Pivot","description":"Company headcount observations — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot for supplied company headcount observations records (headcount, open_roles). 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-company-12-110?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","headcount","open_roles"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"headcount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"open_roles":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","headcount":10,"open_roles":1,"company_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","headcount":20,"open_roles":2,"company_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","headcount":15,"open_roles":3,"company_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","headcount":30,"open_roles":4,"company_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["headcount","open_roles"],"type":"string","default":"headcount"}}},"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_27uzmYn0T1e2rgc4FaWdc","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":"Runs two analytical reports on supplied company headcount data: category frequency counts and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"I have headcount observation records for several company groups — can you run category frequency counts and a date-by-category pivot on them? The field I care about is headcount, and here are my rows: group-a had 10 employees on 2024-01-01 with 1 open role, group-b had 20 employees on 2024-01-01 with 3 open roles, group-a had 12 on 2024-02-01 with 2 open roles.","exampleUseCases":[{"title":"Quarterly headcount distribution review","prompt":"I have 150 headcount snapshots across five company divisions from Q1 2024. Can you give me a frequency table showing how often each division appears and a pivot of headcount figures by date and division?"},{"title":"Open roles analysis by team","prompt":"Here are 80 rows of open_roles observations across different company groups over the past six months. Run category frequencies and a date-by-category pivot on the open_roles field so I can see how hiring demand is spread."},{"title":"Benchmarking headcount across subsidiaries","prompt":"I'm comparing headcount across our three subsidiaries — Alpha, Beta, and Gamma — across 12 monthly snapshots. Can you give me both a category frequency count and a date-by-category pivot on the headcount field?"}],"resultDescription":"Two analytical reports: (1) a category frequency table showing how often each company_group value appears in the supplied rows, and (2) a date-by-category pivot table showing the selected field (headcount or open_roles) values broken down by date and company_group. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Rows array is empty or missing — returns validation error","More than 200 rows supplied — request rejected, maxItems exceeded","Invalid date format (not YYYY-MM-DD) — schema pattern validation fails","Missing required fields (row_id, company_group, date, headcount, open_roles) — request rejected","Invalid field selector (not 'headcount' or 'open_roles') — enum validation fails","Null numeric values may be excluded or treated as missing in pivot output"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of company headcount observations (with company_group, date, headcount, and open_roles fields) and need both a category frequency summary and a date-by-category pivot in a single low-cost call. Ideal for HR analysts, workforce planners, or agent pipelines that need structured summaries of headcount data without building custom analytics. Not suitable for live data lookup, prediction, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:31.093Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-category-frequencies-date-by-category-90675488"}