GrantTroveGrantTrove Docs
Using the product

How amounts are shown

Four separate money columns, the rule about ranges, and the floor that turns a range into an upper bound.

Four money columns, never merged: amount_min, amount_max, amount_typical and amount_total_pool.

The rule about ranges

A floor and a ceiling render as a range only when both are stated. One endpoint alone renders as one figure plus Not stated, never as a range with an invented end.

Collapsing a pool and a ceiling into one range produces a span that describes no real award, and it is the most common display error in this category.

The "up to" rule

Where a floor is present but effectively meaningless — a stated minimum of one dollar or less — the pair is rendered as up to the ceiling rather than as a range starting at that floor. A range reading "$1 – $250,000" is technically what the source said and is a worse description of the programme than "up to $250,000".

The floor is still stored. The rule is about display, not about discarding what the source published.

Notes travel with figures

Where a source qualifies an amount — a per-unit cap, a carry-over note, a subject-to-appropriation caveat — that sentence is stored in amount_note and shown beside the number rather than folded into it.

Aggregates print their basis

Any figure computed across records prints the number of records it was computed from. A median over four records and one over four hundred are not the same claim.

Table of Contents