Government Contract Index

Snowflake table name : CYBERSYN.GOVERNMENT_CONTRACT_INDEX

View data source documentation here.

Name	Description	Type	Example
CONTRACT_SOLICITATION_ID	Unique solicitation number provided by the System for Award Management (sam.gov) for a specific contract. Joinable to the GOVERNMENT_CONTRACT_AWARD_INDEX table.	VARCHAR	W911YN21Q0005
ORIGINAL_CONTRACT_TITLE	A short summary of the goods and services to be provided to the Federal government in the contract.	VARCHAR	ANNUAL SERVICE AND PREVENTATIVE MAINTENANCE ON THE GE VIVID E95 ...
ORIGINAL_CONTRACT_DESCRIPTION	A detailed statement of work and requirements of the services or products to be provided to the Federal government in the contract.	VARCHAR	Please fill in block 12, 17a, 30a, 30b, & 30c. Startin on page 3...
DEPARTMENT	The Federal Department seeking services or products (e.g., Dept of Defense)	VARCHAR	Commerce, Department Of
AGENCY	The agency underneath the department offering the contract (e.g., Dept of Navy)	VARCHAR	Dept Of The Army
AGENCY_OFFICE	The specific office within the agency handling the contract (e.g., Naval Research Laboratory)	VARCHAR	252-Network Contract Office 12 (36c252)
FIRST_POSTED_DATE	The earliest date the contract was posted on the System for Award Management (sam.gov)	TIMESTAMP_TZ	2012-08-22 10:31:52-04:00
RESPONSE_DEADLINE	Deadline for organizations to submit proposals for the contract	TIMESTAMP_TZ	2016-04-01 16:00:00-05:00
NAICS_CODE	The North American Industry Classification System code that best classifies the goods or services in the contract opportunity	NUMBER	336411
NAICS_DESCRIPTION	Human-readable description of the industry related to the contract	VARCHAR	Aircraft Manufacturing
SPECIAL_AWARD_PROVISION	Indication of exclusivity for all or part of a contract to be set aside or reserved for a small or underrepresented business	VARCHAR	Total Small Business Set-Aside (FAR 19.5)
PERFORMANCE_CITY	The city location where the contract will be fulfilled	VARCHAR	Miami
PERFORMANCE_STATE	The state location where the contract will be fulfilled	VARCHAR	Florida
PERFORMANCE_ZIPCODE	The zipcode location where the contract will be fulfilled	VARCHAR	80729
PERFORMANCE_COUNTRY	The country location where the contract will be fulfilled	VARCHAR	United States
PERFORMANCE_GEO_ID_CITY	The unique identifier for the contract fulfillment city that is joinable to the GEOGRAPHY_INDEX	VARCHAR	geoId/1217935
PERFORMANCE_GEO_ID_STATE	The unique identifier for the contract fulfillment state that is joinable to the GEOGRAPHY_INDEX	VARCHAR	geoId/08
PERFORMANCE_GEO_ID_ZIP	The unique identifier for the contract fulfillment zipcode that is joinable to the GEOGRAPHY_INDEX	VARCHAR	zip/80729
PERFORMANCE_GEO_ID_COUNTRY	The unique identifier for the contract fulfillment country that is joinable to the GEOGRAPHY_INDEX	VARCHAR	country/USA