Table gpqueries:contracts.raw contains the unmodified data from the USASpending.gov archives. It's constructed from <year>_All_Contracts_Full_20160515.csv.zip files and includes contracts from 2000 to May 15, 2016.

Table gpqueries:contracts.raw contains 45M rows and 225 columns.

Each row refers to a transaction (a purchase or refund) made by a federal agency. It may be a pizza or an airplane.

The columns are grouped into categories:

Transaction: unique_transaction_id - baseandalloptionsvalue

- Buyer (government agency): maj_agency_cat - fundedbyforeignentity

- Dates: signeddate - lastdatetoorder , last_modified_date

- , Contract: contractactiontype - programacronym

- Contractor (supplier, vendor): vendorname - statecode

- Place of performance: PlaceofPerformanceCity - placeofperformancecongressionaldistrict

- Product or service bought: psc_cat - manufacturingorganizationtype

- General contract information: agencyid - idvmodificationnumber

- Competitive procedure: solicitationid - statutoryexceptiontofairopportunity

- Contractor details: organizationaltype - otherstatutoryauthority

- Contractor's executives: prime_awardee_executive1 - interagencycontractingauthority

Detailed description for each variable is available in the official codebook: