# Public Spending Budgets — Grouped Numeric Summary + Date-by-Category Pivot

> Public Spending Budgets — Grouped Numeric Summary + Date-by-Category Pivot is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-11-22).

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.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-economics-01-097?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-22
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/public-spending-budgets-grouped-numeric-summary-date-by-category-pivot-875be53c
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_5FVqbDrw1Hm8ReQ5qLYXx

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability public-spending-budgets-grouped-numeric-summary-date-by-category-pivot-875be53c -d '<json body>'
```

Example prompt: 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?

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/public-spending-budgets-grouped-numeric-summary-date-by-category-pivot-875be53c/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)
