SQL Database Downloads

Overview

We provide the entire data set used by USAspending.gov as a PostgreSQL archive, which includes DATA Act data from Fiscal Year 2001 to present.

Additionally, we offer a much smaller subset of the data for developers or testers as PostgreSQL archive.
It includes a random sampling of awards, submission, and reference data. Which are enough data for running the application locally

Database download archives are generated on a monthly basis.

Guide

Setup guide to downloading, unzipping, and restoring our database:
usaspending-db-setup.pdf (69.8 KB)

Please read the setup guide prior to downloading either database as it outlines the operations process.
It sets expectations on hard disk space needed for the fully restored complete database, and provides technical requirements.

Downloads

Name	Description	Link	Zip File Size
USAspending Database 2023-03-07 zip	Complete PostgreSQL Dump Archive	full database zip	190G
Subset Database 2023-02-08 zip	Reduced-data PostgreSQL Dump Archive	subset database zip	80G