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	36C25721P0262
ORIGINAL_CONTRACT_TITLE	A short summary of the goods and services to be provided to the Federal government in the contract.	VARCHAR	59--RESISTOR,VARIABLE,N
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	Proposed procurement for NSN 5995015890228 CABLE ASSEMBLY,RADI: ...
DEPARTMENT	The Federal Department seeking services or products (e.g., Dept of Defense)	VARCHAR	Homeland Security, Department Of
AGENCY	The agency underneath the department offering the contract (e.g., Dept of Navy)	VARCHAR	Veterans Affairs, Department Of
AGENCY_OFFICE	The specific office within the agency handling the contract (e.g., Naval Research Laboratory)	VARCHAR	Ofc Of Acqusition Grants-National
FIRST_POSTED_DATE	The earliest date the contract was posted on the System for Award Management (sam.gov)	TIMESTAMP_TZ	2014-01-07 19:09:09-05:00
RESPONSE_DEADLINE	Deadline for organizations to submit proposals for the contract	TIMESTAMP_TZ	2021-05-18 00:00:00-04:00
NAICS_CODE	The North American Industry Classification System code that best classifies the goods or services in the contract opportunity	NUMBER	541330
NAICS_DESCRIPTION	Human-readable description of the industry related to the contract	VARCHAR	Other Aircraft Parts and Auxiliary Equipment 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	Camp Lejeune
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	37015
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/4827000
PERFORMANCE_GEO_ID_STATE	The unique identifier for the contract fulfillment state that is joinable to the GEOGRAPHY_INDEX	VARCHAR	geoId/51
PERFORMANCE_GEO_ID_ZIP	The unique identifier for the contract fulfillment zipcode that is joinable to the GEOGRAPHY_INDEX	VARCHAR	zip/76102
PERFORMANCE_GEO_ID_COUNTRY	The unique identifier for the contract fulfillment country that is joinable to the GEOGRAPHY_INDEX	VARCHAR	country/USA