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	W58RGZ05G00050086
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	SP4510-12-Q-0037
AWARD_NAME	A short summary of the goods and services in the awarded contract	VARCHAR	FY 2023 1st QUARTER MEAT SUBSISTENCE
AWARD_DESCRIPTION	A detailed statement of work and requirements of the services or products in the awarded contract	VARCHAR	WIRING HARNESS. THIS PROCUREMENT IS COMPETITIVE WITH REQUIRED PU...
AWARD_AMOUNT	The total amount of the awarded contract	FLOAT	97725.0
AWARD_DATE	The date the contract was awarded	DATE	2012-08-30
RECIPIENT	The name and address of the organization receiving the contract	VARCHAR	Good Source Solutions, Inc. Ca Usa
PRIMARY_AWARDER_CONTACT_ID	Unique identifier for the primary government contact awarding the contract.	VARCHAR	f86a9800d922236eba317f029a2f5424
PRIMARY_AWARDER_CONTACT_NAME	Name of the primary government contact at the office awarding the contract	VARCHAR	Lawrence Watson
PRIMARY_AWARDER_CONTACT_TITLE	Title of the primary government contact at the office awarding the contract	VARCHAR	Contract Negotiator
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	7037679546
PRIMARY_AWARDER_CONTACT_FAX	Fax number of the primary government contact at the office awarding the contract	VARCHAR	4057397422