Government Contracts
The government spending data provides comprehensive information about government contracts, transactions, product specifications, entity details, locations, competition, and compensation.
Data arrives late Friday night 11 pm - 12 am after market close US-EST time.
Tutorials are the best documentation — Government Contracts Tutorial
Input Datasets
Governmental Filings
Models Used
Parsing, Regex, Entity Recognition
Model Outputs
Standardized Contracts
Description
This dataset provides comprehensive information about government contracts, including details on transactions, product specifications, entities, locations, competition, and compensation.
It offers investors valuable insights into companies' relationships with government agencies, allowing for risk assessment, comparative analysis, and informed decision-making in the context of government spending and contracts.
Data Access
Contracts Data
Data about contract award details, potential total value, federal action obligations, performance duration, and recipient details.
Transactions Data:
The data includes information about individual transactions related to contracts, such as federal action obligations, transaction descriptions, and last modified dates.
Product Specifications
Data about the products or services associated with contracts, such as product or service code descriptions, NAICS codes and descriptions, country of origin, and sustainability information.
Entity Specification
Data about the entities involved in contracts, such as recipient unique identifiers, recipient names, parent company details, and matching information with other datasets like Bloomberg.
Location Data
Data about the geographical locations associated with contracts, such as recipient country, address, city, county, state, and zip code, as well as the primary place of performance details.
Competition Data:
Data related to the competition aspect of contracts, such as the extent of competition, number of offers received, and solicitation procedures.
Compensation Date
Data about the compensation of highly compensated officers in recipient organization, only published voluntarily by a few companies.
Data Dictionaries
Government Contracts
| Column Name | Description | Example |
|---|---|---|
ticker | Stock ticker symbol identifying the company. | TSLA |
date | Date of the record. | 2023-10-02 |
contract_award_unique_key | Unique key identifying the prime award. | CONT_AWD_SPE7LX24F0359_9700_SPE7LX22D0144_9700 |
potential_total_value_of_award | Total amount that could be obligated on a contract if all options are exercised. | 8526.629883 |
total_federal_action_obligation | Total value of federal obligations for the contract. | 8526.629883 |
obligation_value_difference | Difference between the total federal action obligation and the potential total value of the award. | 0.0 |
performance_duration | Duration of the contract's performance period in days. | 30.0 |
awards_past_year | Count of awards per recipient name in the past year. | 7.0 |
transactions_per_award | Count of unique transactions per award. | 1.0 |
prime_award_base_transaction_description | Description of the transaction or award at the prime award level. | 8510186794!BATTERY POWER SUPPLY |
period_of_performance_start_date | Agreed start date for the contract's requirements. | 2023-10-02 |
period_of_performance_current_end_date | Scheduled completion date for the contract. | 2023-11-01 |
period_of_performance_potential_end_date | Date when awardee effort is completed if all potential options were exercised. | 2023-11-01 |
extension_days_available | Number of days available for extension. | 0.0 |
time_to_start_performance | Number of days between the action date and the period of performance start date. | 0.0 |
modification_number | Identifier of an action indicating the specific change to the initial award. | 0 |
last_modified_date | The date capturing the change or modification. | 2023-10-02 |
recipient_name | The name of the awardee or recipient associated with the unique identifier. | TESLA INDUSTRIES, INC. |
recipient_uei | Unique Entity Identifier of the recipient organization. | WK5RYJL58YY9 |
Government Transactions
| Column Name | Description | Example |
|---|---|---|
contract_transaction_unique_key | A system-generated key used to uniquely identify each contract transaction record. It's a concatenation of various elements like agencyID, PIID, etc., with 'none' used for blank fields. | 9700_9700_8Z03_0_DAAB1502D1002_0 |
federal_action_obligation | Amount of the Federal government’s obligation, de-obligation, or liability, in dollars, for a transaction. | 248398.0 |
transaction_description | Description of the transaction or award. | CLIN 0129AA AST - MESSAGING TECHNOLOGIES |
contract_award_unique_key | Unique key to identify the prime award. It's a concatenation of elements such as PIID, agencyID, ParentAwardId, and Referenced IDV Agency Identifier, with 'none' for blank fields. | CONT_AWD_8Z03_9700_DAAB1502D1002_9700 |
last_modified_date | Date when the transaction record was last modified. | 2019-10-16T00:00:00 |
Product Specifications
| Column Name | Description | Example |
|---|---|---|
ticker | Stock ticker symbol identifying the company. | TSLA |
contract_award_unique_key | Unique key to identify the prime award, consisting of concatenation of elements like PIID, agencyID, ParentAwardId, and Referenced IDV Agency Identifier. | CONT_AWD_SPE7LX20F345T_9700_SPE7LX18D0042_9700 |
product_or_service_code_description | Description explaining the meaning of the product or service code. | CONVERTERS, ELECTRICAL, NONROTATING |
naics_code | North American Industrial Classification System Code assigned to the solicitation and resulting award. | 335999.0 |
naics_description | The title associated with the NAICS Code. | ALL OTHER MISCELLANEOUS ELECTRICAL EQUIPMENT AND COMPONENT MFG |
country_of_product_or_service_origin | Country of origin of the product or service. | UNITED STATES |
place_of_manufacture | Description explaining the place of manufacture. | MFG IN U.S. |
epa_designated_product | Description explaining the EPA-Designated Product Field. | NOT REQUIRED |
recovered_materials_sustainability | Description explaining the Recovered Materials/Sustainability Field. | NO CLAUSES INCLUDED AND NO SUSTAINABILITY INCLUDED |
Entity Specification
| Column Name | Description | Example |
|---|---|---|
ticker | Stock ticker symbol identifying the company. | TSLA |
recipient_uei | Unique Entity Identifier (UEI) of the recipient organization, used in financial and business reporting processes. | WK5RYJL58YY9 |
recipient_parent_uei | Unique Entity Identifier (UEI) of the highest-level parent organization of the recipient. | WK5RYJL58YY9 |
recipient_name | The name of the awardee or recipient that relates to the unique identifier, as filed in formation documents with individual states. | TESLA INDUSTRIES, INC. |
recipient_parent_name | The name of the ultimate parent of the awardee or recipient. | TESLA INDUSTRIES, INC. |
names | A name associated with the recipient entity, derived during data processing and matching. | TESLA INDUSTRIES, INC. |
similarity | A score representing the similarity between the 'names' field and a corresponding entity in another dataset, used for data matching. | 0.9562 |
bloomberg_share_id | Bloomberg Share ID, a unique identifier for a share class at the Bloomberg level, obtained through data matching with Bloomberg's dataset. | BBG001SQKGD7 |
For the misstatements, all of the variables have been changed into negative indicators, so that when the company overreports the financial health and corrects it later on, that is a negative sign.
Location Dictionary
| Column Name | Description | Example |
|---|---|---|
ticker | Stock ticker symbol identifying the company. | TSLA |
contract_award_unique_key | Unique key to identify the prime award, a concatenation of PIID, agencyID, ParentAwardId, and Referenced IDV Agency Identifier. | CONT_AWD_0542_9700_SPM7MX13D0089_9700 |
recipient_country_name | The name corresponding to the country code of the awardee or recipient. | UNITED STATES |
recipient_address_line_1 | First line of the awardee or recipient’s legal business address. | 109 CENTERPOINT BLVD |
recipient_city_name | Name of the city in which the awardee or recipient’s legal business address is located. | NEW CASTLE |
recipient_county_name | Name of the county in which the awardee or recipient’s legal business address is located. | NEW CASTLE |
recipient_state_code | United States Postal Service two-letter abbreviation for the state or territory in which the awardee or recipient’s legal business address is located. | DE |
recipient_state_name | The name or abbreviation for the state, territory, or province in which the award recipient's legal business address is located. | DELAWARE |
recipient_zip_4_code | USPS zoning code associated with the awardee or recipient’s legal business address for domestic recipients only. | 197204180 |
primary_place_of_performance_country_code | Country code where the predominant performance of the award will be accomplished. | USA |
primary_place_of_performance_country_name | Name of the country where the predominant performance of the award will be accomplished. | UNITED STATES |
primary_place_of_performance_city_name | The name of the city where the predominant performance of the award will be accomplished. | NEW CASTLE |
primary_place_of_performance_county_name | The name of the county where the predominant performance of the award will be accomplished. | NEW CASTLE |
primary_place_of_performance_state_code | USPS two-letter abbreviation for the state or territory indicating where the predominant performance of the award will be accomplished. | DE |
primary_place_of_performance_state_name | The name of the state or territory where the predominant performance of the award will be accomplished. | DELAWARE |
primary_place_of_performance_zip_4 | ZIP code identifying where the predominant performance of the award will be accomplished. | 197204180 |
same_country | Is the place of performance the same as the location of the recepient | 1 |
same_state | Is the place of performance the same as the location of the recepient | 1 |
Competition Dictionary
| Column Name | Description | Example |
|---|---|---|
ticker | Stock ticker symbol identifying the company. | TSLA |
contract_award_unique_key | Unique key to identify the prime award, a concatenation of PIID, agencyID, ParentAwardId, and Referenced IDV Agency Identifier. | CONT_AWD_0162_9700_SPM43003D4053_9700 |
extent_competed | Description explaining the meaning of the code provided in the Extent Competed Field. | FULL AND OPEN COMPETITION AFTER EXCLUSION OF S... |
number_of_offers_received | The number of actual offers/bids received in response to the solicitation. | 2.0 |
solicitation_procedures | Description explaining the meaning of the code provided in the Solicitation Procedures Field. | ONLY ONE SOURCE |
Compensation
| Column Name | Description | Example |
|---|---|---|
ticker | Stock ticker symbol identifying the company. | ACCA |
date | Date of the record. | 2018-10-31 |
recipient_uei | Unique Entity Identifier (UEI) of the recipient organization, used in financial and business reporting processes. | K5TBNBLVG1F8 |
recipient_name | The name of the awardee or recipient that relates to the unique identifier, as filed in formation documents with individual states. | ID TECHNOLOGIES, LLC |
recipient_parent_name | The name of the ultimate parent of the awardee or recipient. | ACACIA INVESTMENT HOLDINGS LLC |
highly_compensated_officer_1_name | The name of an individual identified as one of the five most highly compensated "Executives." | CHRISTOPHER OLIVER |
highly_compensated_officer_1_amount | The cash and noncash dollar value earned by the first of the five most highly compensated “Executives” during the awardee's preceding fiscal year. | 485518.12500 |
highly_compensated_officer_2_name | The name of an individual identified as the second of the five most highly compensated "Executives." | DYLAN CONNER |
highly_compensated_officer_2_amount | The cash and noncash dollar value earned by the second of the five most highly compensated “Executives” during the awardee's preceding fiscal year. | 820596.2500 |
highly_compensated_officer_3_name | The name of an individual identified as the third of the five most highly compensated "Executives." | GAVIN LONG |
highly_compensated_officer_3_amount | The cash and noncash dollar value earned by the third of the five most highly compensated “Executives” during the awardee's preceding fiscal year. | 519297.12500 |
highly_compensated_officer_4_name | The name of an individual identified as the fourth of the five most highly compensated "Executives." | JEFFERY PANEBIANCO |
highly_compensated_officer_4_amount | The cash and noncash dollar value earned by the fourth of the five most highly compensated “Executives” during the awardee's preceding fiscal year. | 818678.1250 |
highly_compensated_officer_5_name | The name of an individual identified as the fifth of the five most highly compensated "Executives." | THOMAS BRADY |
highly_compensated_officer_5_amount | The cash and noncash dollar value earned by the fifth of the five most highly compensated “Executives” during the awardee's preceding fiscal year. | 365064.81250 |
Use Cases
Understanding these tables is essential for investors:
Risk Assessment: By analyzing the Misstatement and its industry-adjusted tables, investors can gauge the risk associated with a company's financial reporting.
Comparative Analysis: The industry-adjusted tables enable investors to compare companies within the same sector on a like-for-like basis, making the analysis more relevant and accurate.
Informed Decision-Making: Comprehensive data covering raw financials and industry-adjusted scores empowers investors to make well-informed investment decisions.
Last updated
