{"uid":"cap_5FVqbDrw1Hm8ReQ5qLYXx","slug":"public-spending-budgets-grouped-numeric-summary-date-by-category-pivot-875be53c","name":"Public Spending Budgets — Grouped Numeric Summary + Date-by-Category Pivot","description":"Public spending budgets — Grouped numeric summary + Date by category pivot: Grouped numeric summary + Date by category pivot for supplied public spending budgets records (planned_amount, actual_amount). 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-01-097?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","planned_amount","actual_amount"],"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},"actual_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"planned_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","actual_amount":1,"planned_amount":10},{"date":"2026-10-02","region":"group-b","row_id":"row-2","actual_amount":2,"planned_amount":20},{"date":"2026-10-03","region":"group-a","row_id":"row-3","actual_amount":3,"planned_amount":15},{"date":"2026-10-04","region":"group-b","row_id":"row-4","actual_amount":4,"planned_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["planned_amount","actual_amount"],"type":"string","default":"planned_amount"}}},"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_gH1LXhWadUp9w6hjVPKV3","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 public spending budget records (planned vs actual amounts) by producing two local analytical reports: a grouped numeric summary and a date-by-category pivot table.","exampleAgentPrompt":"I have 150 rows of public spending budget data with planned and actual amounts by region and date — can you run a grouped numeric summary and a date-by-category pivot on the planned_amount field for me?","exampleUseCases":[{"title":"Budget variance analysis by region","prompt":"I have quarterly spending records for 5 government departments with planned and actual budget amounts across 3 regions — please give me a grouped numeric summary and a date-by-category pivot on the actual_amount field so I can see where we're over or under budget."},{"title":"Annual public spending review","prompt":"Here are 200 rows of annual public spending budget data with dates and regional categories. Can you run both a grouped numeric summary and a date pivot using the planned_amount field so I can prepare the year-end review report?"},{"title":"Grant allocation monitoring","prompt":"I'm tracking grant disbursements across 8 regions over the past 6 months — I have the planned and actual amounts per row. Run a grouped numeric summary and a date-by-category pivot on actual_amount so I can see spending patterns."}],"resultDescription":"Returns two analytical reports computed locally from the supplied rows: (1) a grouped numeric summary of the selected field (planned_amount or actual_amount) broken down by region/category, and (2) a date-by-category pivot table showing the selected field values across dates and regions. Up to 200 rows supported. No external data is fetched.","failureModes":["Missing required fields (row_id, region, date, planned_amount, actual_amount) causes validation error","Date strings not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted exceeds the maxItems limit","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array (minItems: 1 not met) returns an error","Invalid field enum value (not planned_amount or actual_amount) causes rejection"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of public spending budget data with planned and actual amounts by region and date, and you need both a grouped numeric summary AND a date-by-category pivot in a single low-cost call ($0.01 USDC). Ideal for offline/local analytics on supplied data where no live data lookup, prediction, or external enrichment is needed. Prefer over general analytics APIs when you specifically need these two report types together on economics/public finance data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-22T00:34:20.532Z","isFirstParty":false,"canonicalSlug":"public-spending-budgets-grouped-numeric-summary-date-by-category-pivot-875be53c"}