Methodology

The app uses two fact tables: one transactional state payment layer and one annual county expenditure layer. They are related conceptually, but they are not merged into a fake geography model.

Payments drive payee, agency, object, and transaction analysis. County expenditure reports drive maps and county detail pages.

Procurement/vendor enrichment is stored separately and linked to payees through explicit match records. Public payment outputs do not include vendor IDs, so these matches are approximate by design.

The UI always presents enrichment as context, not as an authoritative identity claim.