# US federal contract awards over $1 million since 2022

**See which companies win large US federal contracts, what the government bought, and which winners are publicly traded.** This dataset lists every federal prime contract award of one million dollars or more first obligated since fiscal year 2022, with the recipient, its parent company, the parent's stock ticker where one exists, the agency, the place of performance and a category for what was bo…

US federal contract awards over $1 million since 2022 is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `us-federal-contract-awards-over-1-million-since-2022`
- Canonical page: https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-11-13T14:15:33.010Z
- Tables: 6
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/us-federal-contract-awards-over-1-million-since-2022`
- Topics: federal contracts, government spending, usaspending, procurement, defense contractors, government vendors, stock tickers

## Table directory

Tables follow the publisher's curated order. Display labels do not change table identifiers.

Start here: contract_awards — table id: 9b351f2a-c879-4477-b70b-8cae5303356c

- source_contract_awards — table id: 585f09b2-38b7-47be-9d81-35ac8c84e99c; published name: source_contract_awards; https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022/tables?table=source-contract-awards
- source_award_labels — table id: 4e225000-3ed7-4aae-a457-fb968c01427a; published name: source_award_labels; https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022/tables?table=source-award-labels
- contract_awards — table id: 9b351f2a-c879-4477-b70b-8cae5303356c; published name: contract_awards; https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022/tables?table=contract-awards
- source_recipients — table id: 85c489cd-5e56-4b1a-820b-cdaf6dc1b926; published name: source_recipients; https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022/tables?table=source-recipients
- source_recipient_lookup_awards — table id: 3f63fbbd-d1bf-4fb5-b29d-24841fed6b48; published name: source_recipient_lookup_awards; https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022/tables?table=source-recipient-lookup-awards
- source_award_search_pages — table id: f41c772a-198b-49f8-84f7-313dd45ed716; published name: source_award_search_pages; https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022/tables?table=source-award-search-pages

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and ranked row search on public tables (search_table). An empty search query pages through a table in stored order. There is no filter, sort or download without an account.
3. Log in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: source_contract_awards

- Table id: `585f09b2-38b7-47be-9d81-35ac8c84e99c`
- Slug: `source-contract-awards`
- Immutable version: `a5bf93cd-1af7-5d18-b079-660403bfd706`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/585f09b2-38b7-47be-9d81-35ac8c84e99c/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/585f09b2-38b7-47be-9d81-35ac8c84e99c/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/585f09b2-38b7-47be-9d81-35ac8c84e99c/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/585f09b2-38b7-47be-9d81-35ac8c84e99c/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (35)

| Column | Type | Description |
| --- | --- | --- |
| `award_key` | string | USAspending's unique award identifier, built from the contract number, the awarding office's agency code and the parent contract. |
| `award_id` | string | The contract or order number (PIID) as the agency assigned it. |
| `fiscal_year` | integer | Federal fiscal year in which the award was first obligated. A fiscal year runs from 1 October to 30 September. |
| `fiscal_year_start` | date | First day of that fiscal year, and the column the table partitions on. |
| `recipient_name` | string | Name of the business or organisation that received the award. |
| `recipient_uei` | string | The recipient's Unique Entity Identifier from SAM.gov. |
| `recipient_id` | string | USAspending's recipient profile identifier. |
| `awarding_agency` | string | Top-tier federal agency that awarded the contract. |
| `awarding_agency_code` | string | Three-digit code of the awarding agency. |
| `awarding_sub_agency` | string | Bureau, service or component that awarded the contract. |
| `funding_agency` | string | Top-tier agency that paid for the contract. |
| `funding_sub_agency` | string | Bureau, service or component that paid for the contract. |
| `description` | string | The award description as the contracting officer wrote it. |
| `start_date` | date | First day of the period of performance. |
| `end_date` | date | Current last day of the period of performance. |
| `award_amount` | decimal | Total dollars obligated on the award to date, in US dollars. |
| `total_outlays` | decimal | Total dollars paid out on the award to date, in US dollars, where the agency reports outlays. |
| `contract_award_type` | string | Kind of contract action: definitive contract, delivery order, purchase order or BPA call. |
| `naics_code` | string | Six-digit NAICS industry code the agency assigned. |
| `naics_description` | string | Publisher's name for the NAICS code. |
| `psc_code` | string | Four-character Product and Service Code saying what was bought. |
| `psc_description` | string | Publisher's name for the Product and Service Code. |
| `pop_country_code` | string | Three-letter country code of the primary place of performance. |
| `pop_country` | string | Country of the primary place of performance. |
| `pop_state_code` | string | US state or territory code of the primary place of performance. |
| `pop_state` | string | US state or territory of the primary place of performance. |
| `pop_city` | string | City of the primary place of performance. |
| `pop_county` | string | County of the primary place of performance. |
| `pop_zip5` | string | Five-digit ZIP code of the primary place of performance. |
| `recipient_country_code` | string | Three-letter country code of the recipient's address. |
| `recipient_state_code` | string | US state or territory code of the recipient's address. |
| `recipient_city` | string | City of the recipient's address. |
| `last_modified` | timestamp_utc | When USAspending last recorded a change to the award, in UTC. |
| `base_obligation_date` | date | Date of the award's first obligation. |
| `search_page` | integer | The search result page the row was read from. |

## Table: source_award_labels

- Table id: `4e225000-3ed7-4aae-a457-fb968c01427a`
- Slug: `source-award-labels`
- Immutable version: `cf732cf1-4dea-5e87-ba58-54698d8a29af`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/4e225000-3ed7-4aae-a457-fb968c01427a/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/4e225000-3ed7-4aae-a457-fb968c01427a/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/4e225000-3ed7-4aae-a457-fb968c01427a/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/4e225000-3ed7-4aae-a457-fb968c01427a/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (5)

| Column | Type | Description |
| --- | --- | --- |
| `award_key` | string | USAspending's unique award identifier. |
| `bought_label` | string | The model's most probable category for what was bought, one of thirteen fixed labels. Model gemini-decision-1. |
| `bought_probability` | decimal | The model's probability for that label, from 0 to 1. |
| `ai_probability` | decimal | The model's probability that the award is about artificial intelligence or machine learning, from 0 to 1. |
| `served_model` | string | The model that answered. |

## Table: contract_awards

- Table id: `9b351f2a-c879-4477-b70b-8cae5303356c`
- Slug: `contract-awards`
- Immutable version: `c2a1030b-562a-5d52-81a1-c216a727204d`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/9b351f2a-c879-4477-b70b-8cae5303356c/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/9b351f2a-c879-4477-b70b-8cae5303356c/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/9b351f2a-c879-4477-b70b-8cae5303356c/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/9b351f2a-c879-4477-b70b-8cae5303356c/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (50)

| Column | Type | Description |
| --- | --- | --- |
| `award_key` | string | USAspending's unique award identifier, built from the contract number, the awarding office's agency code and the parent contract. |
| `award_id` | string | The contract or order number (PIID) as the agency assigned it. |
| `fiscal_year` | integer | Federal fiscal year in which the award was first obligated. A fiscal year runs from 1 October to 30 September. |
| `fiscal_year_start` | date | First day of that fiscal year, and the column the table partitions on. |
| `base_obligation_date` | date | Date of the award's first obligation. |
| `start_date` | date | First day of the period of performance. |
| `end_date` | date | Current last day of the period of performance. |
| `duration_days` | integer | Days from the start to the current end of the period of performance, by rule from the two dates. |
| `award_amount` | decimal | Total dollars obligated on the award to date, in US dollars. |
| `award_size_tier` | string | Size band of the obligated amount, by rule: 1M to 5M, 5M to 25M, 25M to 100M, 100M to 1B, or over 1B US dollars. Under 1M marks an award whose obligations have… |
| `total_outlays` | decimal | Total dollars paid out on the award to date, in US dollars, where the agency reports outlays. |
| `contract_award_type` | string | Kind of contract action: definitive contract, delivery order, purchase order or BPA call. |
| `description` | string | The award description as the contracting officer wrote it. |
| `bought_category` | string | What the government bought, one of thirteen fixed categories. The Product and Service Code decides it where the code is specific. For generic codes a classific… |
| `bought_category_source` | string | Where the category came from: psc rule or model. |
| `bought_category_probability` | decimal | The model's probability for its label, from 0 to 1. Empty where the PSC rule decided. |
| `is_ai_related` | boolean | Whether the award is about artificial intelligence or machine learning. A classification model (gemini-decision-1) answered for research, IT and keyword-matchi… |
| `ai_probability` | decimal | The model's probability that the award is about artificial intelligence or machine learning. Empty where the rule decided. |
| `recipient_name` | string | Name of the business or organisation that received the award. |
| `recipient_uei` | string | The recipient's Unique Entity Identifier from SAM.gov. |
| `recipient_id` | string | USAspending's recipient profile identifier. |
| `recipient_level` | string | P when the recipient is itself a parent company, C when it is a child of a parent, R when no parent is recorded. |
| `parent_name` | string | Name of the recipient's parent company as USAspending records it. A parent-level recipient is its own parent. |
| `parent_uei` | string | Unique Entity Identifier of the parent company. |
| `is_small_business` | boolean | True when the recipient's USAspending business types include small business. |
| `ticker` | string | US stock ticker of the parent company, or of the recipient when the parent has none. Found by an exact match of the normalized company name against SEC registr… |
| `ticker_matched_on` | string | Which name matched the listed company: parent name or recipient name. |
| `ticker_company_name` | string | The SEC registrant name the ticker belongs to. |
| `ticker_cik` | string | The SEC Central Index Key of the matched company. |
| `awarding_agency` | string | Top-tier federal agency that awarded the contract. |
| `awarding_sub_agency` | string | Bureau, service or component that awarded the contract. |
| `funding_agency` | string | Top-tier agency that paid for the contract. |
| `funding_sub_agency` | string | Bureau, service or component that paid for the contract. |
| `naics_code` | string | Six-digit NAICS industry code the agency assigned. |
| `naics_description` | string | Publisher's name for the NAICS code. |
| `naics_sector` | string | NAICS sector name, by rule from the first two digits of the code. |
| `psc_code` | string | Four-character Product and Service Code saying what was bought. |
| `psc_description` | string | Publisher's name for the Product and Service Code. |
| `psc_type` | string | Product, service or research and development, by rule from the first character of the Product and Service Code. |
| `pop_country_code` | string | Three-letter country code of the primary place of performance. |
| `pop_country` | string | Country of the primary place of performance. |
| `pop_state_code` | string | US state or territory code of the primary place of performance. |
| `pop_state` | string | US state or territory of the primary place of performance. |
| `pop_city` | string | City of the primary place of performance. |
| `pop_county` | string | County of the primary place of performance. |
| `pop_zip5` | string | Five-digit ZIP code of the primary place of performance. |
| `recipient_country_code` | string | Three-letter country code of the recipient's address. |
| `recipient_state_code` | string | US state or territory code of the recipient's address. |
| `recipient_city` | string | City of the recipient's address. |
| `last_modified` | timestamp_utc | When USAspending last recorded a change to the award, in UTC. |

## Table: source_recipients

- Table id: `85c489cd-5e56-4b1a-820b-cdaf6dc1b926`
- Slug: `source-recipients`
- Immutable version: `0096958e-b4ba-5d9f-a834-676913db9f85`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/85c489cd-5e56-4b1a-820b-cdaf6dc1b926/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/85c489cd-5e56-4b1a-820b-cdaf6dc1b926/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/85c489cd-5e56-4b1a-820b-cdaf6dc1b926/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/85c489cd-5e56-4b1a-820b-cdaf6dc1b926/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (17)

| Column | Type | Description |
| --- | --- | --- |
| `recipient_id` | string | USAspending's recipient profile identifier. The last letter says whether the profile is a parent (P), a child (C) or a standalone recipient (R). |
| `lookup_award_key` | string | The award the parent company and business categories were read from. |
| `recipient_name` | string | Recipient name on that award. |
| `recipient_uei` | string | The recipient's Unique Entity Identifier from SAM.gov. |
| `recipient_level` | string | P for a parent company, C for a child of a parent, R for a recipient with no recorded parent, from the last letter of the identifier. |
| `parent_id` | string | USAspending profile identifier of the parent company. |
| `parent_name` | string | Name of the parent company as USAspending records it. |
| `parent_uei` | string | Unique Entity Identifier of the parent company. |
| `is_small_business` | boolean | True when the award's business categories include Small Business. |
| `is_woman_owned` | boolean | True when the business categories include Woman Owned Business. |
| `is_veteran_owned` | boolean | True when the business categories include Veteran Owned Business. |
| `is_minority_owned` | boolean | True when the business categories include Minority Owned Business. |
| `is_nonprofit` | boolean | True when the business categories include Nonprofit Organization. |
| `is_higher_education` | boolean | True when the business categories include Higher Education. |
| `business_categories` | string | The publisher's full list of business categories for the recipient, lower case and separated by semicolons. |
| `state_code` | string | US state or territory code of the recipient's address. |
| `country_code` | string | Three-letter country code of the recipient's address. |

## Table: source_recipient_lookup_awards

- Table id: `3f63fbbd-d1bf-4fb5-b29d-24841fed6b48`
- Slug: `source-recipient-lookup-awards`
- Immutable version: `dd55660a-934b-55bb-ae4e-8f9629bb351c`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/3f63fbbd-d1bf-4fb5-b29d-24841fed6b48/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/3f63fbbd-d1bf-4fb5-b29d-24841fed6b48/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/3f63fbbd-d1bf-4fb5-b29d-24841fed6b48/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/3f63fbbd-d1bf-4fb5-b29d-24841fed6b48/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (3)

| Column | Type | Description |
| --- | --- | --- |
| `recipient_id` | string | USAspending's recipient profile identifier. |
| `award_key` | string | USAspending's unique identifier of the recipient's most recently modified award. |
| `award_count` | integer | How many awards of one million dollars or more the recipient holds in the awards table. |

## Table: source_award_search_pages

- Table id: `f41c772a-198b-49f8-84f7-313dd45ed716`
- Slug: `source-award-search-pages`
- Immutable version: `171e33ea-2145-5e8d-a041-9a427bded1c7`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/f41c772a-198b-49f8-84f7-313dd45ed716/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/f41c772a-198b-49f8-84f7-313dd45ed716/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/f41c772a-198b-49f8-84f7-313dd45ed716/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/f41c772a-198b-49f8-84f7-313dd45ed716/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (5)

| Column | Type | Description |
| --- | --- | --- |
| `fiscal_year` | integer | The federal fiscal year, which runs from 1 October of the previous calendar year to 30 September. |
| `page` | integer | The result page number asked for, 100 awards to a page. |
| `start_date` | string | First day of the fiscal year, as the search filter takes it. |
| `end_date` | string | Last day of the fiscal year, as the search filter takes it. |
| `agency_count` | integer | How many top-tier agencies the publisher listed when this list was built. |

## Citing this dataset

Cite the dataset by name and canonical URL (https://mostlyright.md/datasets/us-federal-contract-awards-over-1-million-since-2022), the table, and the immutable `version_id` the rows came from. A query response carries `table.version_id` and `table.content_digest`; a download carries a strong ETag and a `Content-Digest` header.
