SAM.gov

System for Awards Management

Overview

The System for Award Management (SAM.gov) is a government procurement database managed by the US General Services Administration (GSA). The platform provides a central location for third parties to register to do business with the US government and for government agencies to post contract opportunities and awards. Data published by SAM.gov includes:

• Name of the government agency posting a contract opportunity

• Contract opportunity description

• Date a contract opportunity was posted and the deadline for response

• Location a contract opportunity will be fulfilled

• Name of the recipient of the contract award

• Value and description of the contract award

• Primary government contact who awarded the contract

Key Attributes

Geographic Coverage	United States
Entity Level	Government Contracts, Government Contracts Awards
Release Frequency	Monthly, within the first week
History	December 31, 1969

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes & Methodology

US government contracts data revolves around two main entities: Contracts and Contract Awards. Contracts represent listings soliciting bids on goods and services that the Federal US government is seeking from contractors. Metadata about contracts includes the department of the Federal government that oversees the contract, the date the contract was originally posted, the deadline for response, and the location where the contract will be fulfilled. The contract_solicitation_id field can be used to find the original contract on sam.gov.

Contract Awards represent accepted bids or solicitations from third-party contractors to fulfill a contract. Metadata about the award contract includes the name of the recipient of the award (business or individual), the value of the award, the date of the award, description of the award, and the primary contact from the government who awarded the contract. Note that the description of the contract award may differ from that of the original contract if the government reopened the contract or awarded multiple awards from a single original contract solicitation. The contract_award_id corresponds to the award number on SAM.gov and can be used to search for the award in the SAM.gov portal.

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Tables & Sources

Tables	Sources
GOVERNMENT_CONTRACT_AWARD_INDEX GOVERNMENT_CONTRACT_INDEX	SAM.gov

Cybersyn Products

Tables above are available in the following Cybersyn data products:

• Government Essentials

• LLM Training Essentials

• Enterprise

Examples & Sample Queries

Pull details about the highest-value contracts awarded by government agencies

Find descriptions of the largest Missile Defense Agency contract awarded in recent years.

SELECT
    awards.award_name,
    awards.award_description,
    contracts.department,
    contracts.agency,
    contracts.agency_office,
    contracts.first_posted_date,
    awards.award_date,
    awards.award_amount,
    contracts.naics_description
FROM cybersyn.government_contract_index AS contracts
JOIN cybersyn.government_contract_award_index AS awards
    ON (contracts.contract_solicitation_id = awards.contract_solicitation_id)
WHERE contracts.department = 'Dept Of Defense'
AND contracts.agency_office = 'Missile Defense Agency (Mda)'
AND YEAR(awards.award_date) >= 2021
ORDER BY award_amount DESC NULLS LAST
LIMIT 50;

Disclaimers

The data in this product is sourced from System for Award Management (SAM.gov).

Cybersyn is not endorsed by or affiliated with any of these providers. Contact [e-mail] for questions.