Government Contract Index

Snowflake table name : CYBERSYN.GOVERNMENT_CONTRACT_INDEX

View data sources, attributes, and sample queries 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	M67400-16-T-0063
ORIGINAL_CONTRACT_TITLE	A short summary of the goods and services to be provided to the Federal government in the contract.	VARCHAR	66--GAGE ROD,LIQUID LEV
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	This acquisition is to provide refuse collection services at the...
DEPARTMENT	The Federal Department seeking services or products (e.g., Dept of Defense)	VARCHAR	Dept Of Defense
AGENCY	The agency underneath the department offering the contract (e.g., Dept of Navy)	VARCHAR	Federal Aviation Administration
AGENCY_OFFICE	The specific office within the agency handling the contract (e.g., Naval Research Laboratory)	VARCHAR	697dck Regional Acquisitions Svcs
FIRST_POSTED_DATE	The earliest date the contract was posted on the System for Award Management (sam.gov)	TIMESTAMP_TZ	2005-05-17 01:00:00-04:00
RESPONSE_DEADLINE	Deadline for organizations to submit proposals for the contract	TIMESTAMP_TZ	2010-03-08 00: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	336120
NAICS_DESCRIPTION	Human-readable description of the industry related to the contract	VARCHAR	Solid Waste Collection
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	Quantico
PERFORMANCE_STATE	The state location where the contract will be fulfilled	VARCHAR	Pennsylvania
PERFORMANCE_ZIPCODE	The zipcode location where the contract will be fulfilled	VARCHAR	20375
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/5138424
PERFORMANCE_GEO_ID_STATE	The unique identifier for the contract fulfillment state that is joinable to the GEOGRAPHY_INDEX	VARCHAR	geoId/11
PERFORMANCE_GEO_ID_ZIP	The unique identifier for the contract fulfillment zipcode that is joinable to the GEOGRAPHY_INDEX	VARCHAR	zip/22203
PERFORMANCE_GEO_ID_COUNTRY	The unique identifier for the contract fulfillment country that is joinable to the GEOGRAPHY_INDEX	VARCHAR	country/USA