Act counts by type, period and province
act_statsCount BORME acts by act type, period (month, quarter or year) and province: how many companies and entries had mergers, spin-offs, capital increases or any other act type, newest period first.
Use it for trends ("mergers per quarter in Spain since 2020"). To read the acts themselves use search_events.
Returns JSON {grain, count, truncated, rows: [{period, act_type, province, companies, events}], data_through, built_from, built_to, note, plan_window}, plus hidden_by_plan when the plan left buckets out, and not_built (no rows, never zeros) when the range reaches years outside built_from..built_to. period is the bucket's first day by BORME publication date. companies counts distinct companies in that bucket: never add rows up. Province "*" is all of Spain; a community gives one row per province, not a total.
Read-only; one request per call. Needs the pro plan or higher: send your key in the X-API-Key header (https://bormeapi.com/account).
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "act_stats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| grain | No | The length of each period, one of "month" (default), "quarter", "year", e.g. "quarter". | month |
| limit | No | Maximum rows, integer 1-5000, e.g. 200 (default 1000); truncated is true when more matched. | |
| date_to | No | Optional YYYY-MM-DD, e.g. 2025-12-31; periods starting on or before this day. | |
| act_types | No | Optional list of act type enums to count, e.g. ["MERGER_BY_ABSORPTION", "TOTAL_SPIN_OFF"]; omit for every act type. Full list: list_act_types. | |
| date_from | No | Optional YYYY-MM-DD, e.g. 2024-01-01; the period holding this day is the first one. Data starts on 2009-01-02. | |
| provinces | No | Optional list of BORME province names, accent- and case-insensitive, e.g. ["MADRID", "BARCELONA"]; an autonomous community gives one row per province, e.g. ["Cataluña"]. Omit for the all-provinces rows (province "*"). | |
| by_province | No | Without provinces: true gives one row per province instead of the all-provinces rows, e.g. true (default false). |