System Overview
Quick Actions
Upload Data to Database
USASpending.gov CSV File
Or drag and drop your CSV file here
Puerto Rico Government Excel File
Or drag and drop your Excel file here
Run Matching Process
Start Automated Matching
This will match PR government grants with USASpending.gov records using FAIN, UEI, CFDA, and name similarity.
Review & Approve Matches
Sync with USASpending.gov
Automatic Grant Sync
This will connect to the USASpending.gov API, search for grants awarded to Puerto Rico recipients, download new grants, and automatically import them to your database. Duplicates are automatically detected and skipped.
- Recipient Location: Puerto Rico (PR)
- Award Types: Grants (02, 03, 04, 05)
- Time Range: Last 90 days (or 1 year if first sync)
- Limit: Up to 1000 grants per sync
Sync History
View your recent sync operations and their results.
Export Data
π Export Matched Data
Export matched grants filtered by status or confidence level.
π Export Raw Data
Export complete datasets from your database.