Government Contract Award Index

Snowflake table name : CYBERSYN.GOVERNMENT_CONTRACT_AWARD_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
CONTRACT_AWARD_ID	Award number provided by the System for Award Management (sam.gov) that is unique to each award for a given contract.	VARCHAR	SPE5EK18P1327
CONTRACT_SOLICITATION_ID	Unique solicitation number provided by the System for Award Management (sam.gov) for a specific contract. Joinable to the GOVERNMENT_CONTRACT_INDEX table.	VARCHAR	SPE5EK18T3725
AWARD_NAME	A short summary of the goods and services in the awarded contract	VARCHAR	15--SUPPORT,STRUCTURAL
AWARD_DESCRIPTION	A detailed statement of work and requirements of the services or products in the awarded contract	VARCHAR
AWARD_AMOUNT	The total amount of the awarded contract	FLOAT	730000000.0
AWARD_DATE	The date the contract was awarded	DATE	2021-07-23
RECIPIENT	The name and address of the organization receiving the contract	VARCHAR	Null
PRIMARY_AWARDER_CONTACT_ID	Unique identifier for the primary government contact awarding the contract.	VARCHAR	9db7d414ed8823391ed2470d7524650e
PRIMARY_AWARDER_CONTACT_NAME	Name of the primary government contact at the office awarding the contract	VARCHAR	Katherine E Seymour
PRIMARY_AWARDER_CONTACT_TITLE	Title of the primary government contact at the office awarding the contract	VARCHAR	Contract Specialist
PRIMARY_AWARDER_CONTACT_EMAIL	Email of the primary government contact at the office awarding the contract	VARCHAR	[e-mail]
PRIMARY_AWARDER_CONTACT_PHONE	Phone number of the primary government contact at the office awarding the contract	VARCHAR	6146927765
PRIMARY_AWARDER_CONTACT_FAX	Fax number of the primary government contact at the office awarding the contract	VARCHAR	8175742615