summarize_spend
Rank total disclosed contract value by buyer, supplier, or category to identify top spenders, with transparent notes on excluded amounts and currencies.
Instructions
Rank total disclosed contract value by buyer, supplier or category. Use for "who spends most on X", "which suppliers earn the most", or comparing buyers over a period.
For the individual contracts behind a total, use search_awards.
Two things make every total a floor rather than a true total, and both are reported on the
result: awards that disclosed no amount are excluded rather than counted as zero, and only one
currency is summed per call because the source mixes CAD, USD and EUR with no conversion. The
notes field states both in words — repeat them when you report a figure. A total presented
as complete is wrong.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| since | No | Only awards dated on or after this date, as YYYY-MM-DD. | |
| top_n | No | How many groups to rank. | |
| until | No | Only awards dated on or before this date, as YYYY-MM-DD. The whole day counts. | |
| currency | No | The single currency to total, e.g. 'CAD' (the default and 92% of rows), 'USD', 'EUR', or 'unspecified' for awards naming no currency. Amounts are never converted or combined. Every result reports the period's full currency split so you can see what was left out. | CAD |
| group_by | No | What to rank. 'buyer' for the government department awarding the contracts, 'supplier' for the company winning them, 'category' for the kind of procurement. | buyer |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||