# USAspending Subaward to Prime-Contractor Mapping Scraper (`jungle_synthesizer/usaspending-subaward-prime-mapping-scraper`) Actor Extract USAspending federal subaward records with full prime-contractor mapping: subawardee, prime contractor (name, UEI), awarding agency, amounts, NAICS, PSC, and place of performance. Built for federal contracting analytics, competitive intel, and small-business teaming discovery. - **URL**: https://apify.com/jungle\_synthesizer/usaspending-subaward-prime-mapping-scraper.md - **Developed by:** [BowTiedRaccoon](https://apify.com/jungle_synthesizer) (community) - **Categories:** Business, Other, Developer tools - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing Pay per event This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## USAspending Subaward to Prime-Contractor Mapping Scraper Extracts federal subaward records from [USAspending.gov](https://api.usaspending.gov) and maps each one to its prime contractor. Returns subawardee name and UEI, prime contractor name and UEI, awarding agency, NAICS code, PSC code, place of performance, and dollar amounts — structured JSON for the full subaward-to-prime graph. ### USAspending Subaward Scraper Features - **Extracts subaward records** with direct links to the prime award on USAspending.gov - **Maps subawardees to prime contractors** — both name and SAM.gov UEI, so you can pivot in either direction - **Enriches from award detail** — NAICS code and description, PSC code and description, prime award total obligation, and prime contractor state all come from the award detail endpoint when the search results omit them - **Filters by award type** — contracts (A/B/C/D), grants (02–05), loans, direct payments, or any combination - **Filters by awarding agency** — DoD, DoE, HHS, NASA, GSA, and 16 other top-tier federal agencies - **Filters by NAICS code** — 2, 4, or 6-digit codes (the API is strict; 3 and 5-digit prefixes are silently skipped rather than returning HTTP 400) - **Filters by minimum dollar amount** — useful when you only care about material subcontracts - **Filters by recipient UEI** — track specific companies' subcontracting activity across the federal base - **No API key needed** — USAspending.gov is a public government API, no auth required ### What Can You Do With USAspending Subaward Data? - **Competitive intelligence analysts** — map which small businesses are receiving work under specific prime contracts before those relationships show up elsewhere - **Federal BD teams** — identify primes awarding subawards in your NAICS codes and reach out before the next recompete - **Teaming consultants** — find small business subcontractors already working with target primes to assess teaming fit - **Grant researchers** — trace which nonprofits and universities receive subawards under federal grants by agency and period - **Compliance and DCAA auditors** — pull subaward activity for specific primes or recipients by contract type and date range - **Data vendors and GovTech platforms** — build enriched federal contracting datasets that the standard USAspending exports don't include ### How It Works 1. **Configure your filters** — set award type, awarding agency, NAICS code, date range, and minimum amount. Leave everything blank for all FY2025 contract and grant subawards. 2. **The scraper queries the USAspending API** — it calls `POST /api/v2/search/spending_by_award/` with `subawards: true`, paginating through results 100 at a time. Award type groups are split into separate queries since the API requires codes from a single group per request. 3. **Each record is enriched from the award detail endpoint** — `GET /api/v2/awards//` fills in NAICS, PSC, prime contractor UEI, prime contractor state, and total obligation when the search results don't include them. Results are cached per prime award to avoid redundant calls. 4. **Clean JSON lands in your dataset** — one record per subaward, ready to export. ### USAspending Subaward Scraper Input ```json { "awardType": ["A", "B", "C", "D"], "awardingAgency": "Department of Defense", "naicsCode": "541330", "dateFrom": "2024-10-01", "dateTo": "2025-09-30", "minAmount": 25000, "maxItems": 100 } ```` | Field | Type | Default | Description | |-------|------|---------|-------------| | `awardType` | array | all | Award type codes. Contracts: A, B, C, D. Grants: 02–05. Loans: 07, 08. Leave blank for contracts + grants. | | `awardingAgency` | string | all | Top-tier federal awarding agency name. | | `naicsCode` | string | — | NAICS code filter. Must be 2, 4, or 6 digits. | | `ueiList` | array | — | SAM.gov UEIs to filter by (subaward recipient). | | `dateFrom` | string | 2024-10-01 | Start date for subaward action date (YYYY-MM-DD). | | `dateTo` | string | 2025-09-30 | End date for subaward action date (YYYY-MM-DD). | | `minAmount` | integer | 0 | Minimum subaward dollar amount. | | `maxItems` | integer | 15 | Maximum number of records to return. | ### USAspending Subaward Scraper Output Fields ```json { "subaward_id": "2025-ESC02395-0005", "prime_award_id": "W912DY-24-C-0017", "subaward_type": "sub-contract", "subawardee_name": "ACME ENVIRONMENTAL SERVICES LLC", "subawardee_uei": "MK3G7QQTZXP6", "subawardee_state": "VA", "prime_contractor_name": "PRIME DEFENSE CONTRACTOR INC", "prime_contractor_uei": "J4WB9PHQLXK7", "prime_contractor_state": "MD", "awarding_agency": "Department of Defense", "awarding_subagency": "Dept of the Army", "subaward_amount_usd": 485000, "prime_award_amount_usd": 12400000, "naics_code": "562910", "naics_description": "Remediation Services", "psc_code": "F109", "psc_description": "ENVIRONMENTAL PROTECTION/RESTORATION: HAZARDOUS MATERIAL CONTROL", "place_of_performance_state": "VA", "subaward_action_date": "2025-01-15", "description": "Environmental remediation services at Fort Belvoir", "source_url": "https://www.usaspending.gov/award/CONT_AWD_W912DY24C0017" } ``` | Field | Type | Description | |-------|------|-------------| | `subaward_id` | string | Subaward number / identifier | | `prime_award_id` | string | Prime award PIID (contracts) or FAIN (grants) | | `subaward_type` | string | "sub-contract" or "sub-grant" | | `subawardee_name` | string | Sub-awardee (sub-recipient) name | | `subawardee_uei` | string | Sub-awardee SAM.gov Unique Entity Identifier | | `subawardee_state` | string | Sub-awardee location state code | | `prime_contractor_name` | string | Prime contractor / prime recipient name | | `prime_contractor_uei` | string | Prime contractor SAM.gov Unique Entity Identifier | | `prime_contractor_state` | string | Prime contractor location state code | | `awarding_agency` | string | Federal agency that made the prime award | | `awarding_subagency` | string | Sub-agency within the awarding agency | | `subaward_amount_usd` | number | Subaward dollar amount | | `prime_award_amount_usd` | number | Prime award total obligation | | `naics_code` | string | NAICS industry code (from prime award) | | `naics_description` | string | NAICS industry description | | `psc_code` | string | Product/Service Code (from prime award) | | `psc_description` | string | Product/Service Code description | | `place_of_performance_state` | string | Place of performance state code | | `subaward_action_date` | string | Subaward action date (YYYY-MM-DD) | | `description` | string | Award description | | `source_url` | string | Link to the prime award on USAspending.gov | ### 🔍 FAQ #### How do I scrape subaward data from USAspending.gov? USAspending Subaward Scraper calls the public USAspending REST API — no login, no API key. Configure your filters (agency, NAICS, date range, amount), set `maxItems`, and run it. Results appear in the dataset within seconds for small queries; longer date ranges or unfiltered runs take a few minutes. #### What data can I get from USAspending subawards? USAspending Subaward Scraper returns subawardee name and UEI, prime contractor name and UEI, awarding agency, NAICS and PSC codes, subaward and prime award dollar amounts, place of performance, and a direct link to the prime award record — the full graph for analyzing federal subcontracting relationships. #### Can I filter by NAICS code? USAspending Subaward Scraper accepts 2, 4, or 6-digit NAICS codes (for example, "54", "5413", or "541330"). The USAspending API rejects 3 and 5-digit prefixes with HTTP 400, so the scraper validates the length before sending the request. Enter a valid length and it works. Enter an odd-length code and the NAICS filter is silently skipped rather than failing the run. #### Does USAspending Subaward Scraper need proxies? USAspending Subaward Scraper does not use proxies. USAspending.gov is a public government API that accepts datacenter IPs at a reasonable request pace. No residential proxies, no browser — just direct API calls with a 200ms courtesy delay between pages. #### How much does it cost to run? USAspending Subaward Scraper charges $0.10 per start plus $0.001 per record. A run returning 500 subawards costs around $0.60. The enrichment calls (award detail endpoint) don't add to record count — you pay per subaward saved, not per API request made. *** ### Need More Features? Need custom fields, additional filter types, or a bulk export mode? [File an issue](https://console.apify.com/actors/issues) or get in touch. ### Why Use USAspending Subaward Scraper? - **Subaward-to-prime graph** — returns both sides of the relationship (subawardee and prime contractor, with UEIs for both) in a single record, which is what you actually need for competitive analysis - **Enriched output** — NAICS, PSC, total obligation, and prime contractor state come from the award detail endpoint when the search results omit them, so you get complete records even when the base API returns partial data - **No infrastructure needed** — no API keys, no proxies, no browser automation; it calls a public government API at a courteous pace and returns structured JSON # Actor input Schema ## `sp_intended_usage` (type: `string`): Please describe how you plan to use the data extracted by this crawler. ## `sp_improvement_suggestions` (type: `string`): Provide any feedback or suggestions for improvements. ## `sp_contact` (type: `string`): Provide your email address so we can get in touch with you. ## `awardType` (type: `array`): Filter subawards by award type group. Leave blank for all (contracts + grants). ## `ueiList` (type: `array`): Recipient UEIs to filter by. Leave blank for all. ## `naicsCode` (type: `string`): NAICS prefix to filter by (e.g. '541' for professional services). ## `awardingAgency` (type: `string`): Filter by federal awarding agency name. ## `dateFrom` (type: `string`): Start date for subaward action date filter (YYYY-MM-DD). Minimum: 2007-10-01. ## `dateTo` (type: `string`): End date for subaward action date filter (YYYY-MM-DD). ## `minAmount` (type: `integer`): Filter for subawards at or above this dollar amount. ## `maxItems` (type: `integer`): Maximum number of subaward records to return. ## `proxyConfiguration` (type: `object`): USAspending is a government API and does not require proxies. ## Actor input object example ```json { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "awardType": [], "ueiList": [], "dateFrom": "2024-10-01", "dateTo": "2025-09-30", "minAmount": 0, "maxItems": 15, "proxyConfiguration": { "useApifyProxy": false } } ``` # Actor output Schema ## `results` (type: `string`): No description # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "awardType": [], "ueiList": [], "naicsCode": "", "awardingAgency": "", "dateFrom": "2024-10-01", "dateTo": "2025-09-30", "minAmount": 0, "maxItems": 15, "proxyConfiguration": { "useApifyProxy": false } }; // Run the Actor and wait for it to finish const run = await client.actor("jungle_synthesizer/usaspending-subaward-prime-mapping-scraper").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "awardType": [], "ueiList": [], "naicsCode": "", "awardingAgency": "", "dateFrom": "2024-10-01", "dateTo": "2025-09-30", "minAmount": 0, "maxItems": 15, "proxyConfiguration": { "useApifyProxy": False }, } # Run the Actor and wait for it to finish run = client.actor("jungle_synthesizer/usaspending-subaward-prime-mapping-scraper").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "awardType": [], "ueiList": [], "naicsCode": "", "awardingAgency": "", "dateFrom": "2024-10-01", "dateTo": "2025-09-30", "minAmount": 0, "maxItems": 15, "proxyConfiguration": { "useApifyProxy": false } }' | apify call jungle_synthesizer/usaspending-subaward-prime-mapping-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=jungle_synthesizer/usaspending-subaward-prime-mapping-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "USAspending Subaward to Prime-Contractor Mapping Scraper", "description": "Extract USAspending federal subaward records with full prime-contractor mapping: subawardee, prime contractor (name, UEI), awarding agency, amounts, NAICS, PSC, and place of performance. Built for federal contracting analytics, competitive intel, and small-business teaming discovery.", "version": "0.1", "x-build-id": "N7no4WFqPhbYOAMZh" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/jungle_synthesizer~usaspending-subaward-prime-mapping-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-jungle_synthesizer-usaspending-subaward-prime-mapping-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/jungle_synthesizer~usaspending-subaward-prime-mapping-scraper/runs": { "post": { "operationId": "runs-sync-jungle_synthesizer-usaspending-subaward-prime-mapping-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/jungle_synthesizer~usaspending-subaward-prime-mapping-scraper/run-sync": { "post": { "operationId": "run-sync-jungle_synthesizer-usaspending-subaward-prime-mapping-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "sp_intended_usage", "sp_improvement_suggestions" ], "properties": { "sp_intended_usage": { "title": "What is the intended usage of this data?", "minLength": 1, "type": "string", "description": "Please describe how you plan to use the data extracted by this crawler." }, "sp_improvement_suggestions": { "title": "How can we improve this crawler for you?", "minLength": 1, "type": "string", "description": "Provide any feedback or suggestions for improvements." }, "sp_contact": { "title": "Contact Email", "minLength": 1, "type": "string", "description": "Provide your email address so we can get in touch with you." }, "awardType": { "title": "Award Type", "type": "array", "description": "Filter subawards by award type group. Leave blank for all (contracts + grants).", "items": { "type": "string", "enum": [ "A", "B", "C", "D", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11" ], "enumTitles": [ "BPA Call (A)", "Purchase Order (B)", "Delivery Order (C)", "Definitive Contract (D)", "Block Grant (02)", "Formula Grant (03)", "Project Grant (04)", "Cooperative Agreement (05)", "Direct Payment Specified Use (06)", "Guaranteed/Insured Loan (07)", "Direct Loan (08)", "Direct Payment Unrestricted (09)", "Insurance (10)", "Other Financial Assistance (11)" ] } }, "ueiList": { "title": "UEI List", "type": "array", "description": "Recipient UEIs to filter by. Leave blank for all.", "items": { "type": "string" } }, "naicsCode": { "title": "NAICS Code Filter", "type": "string", "description": "NAICS prefix to filter by (e.g. '541' for professional services)." }, "awardingAgency": { "title": "Awarding Agency", "enum": [ "", "Department of Agriculture", "Department of Commerce", "Department of Defense", "Department of Education", "Department of Energy", "Department of Health and Human Services", "Department of Homeland Security", "Department of Housing and Urban Development", "Department of Justice", "Department of Labor", "Department of State", "Department of the Interior", "Department of the Treasury", "Department of Transportation", "Department of Veterans Affairs", "Environmental Protection Agency", "General Services Administration", "National Aeronautics and Space Administration", "National Science Foundation", "Small Business Administration", "Agency for International Development" ], "type": "string", "description": "Filter by federal awarding agency name." }, "dateFrom": { "title": "Date From", "type": "string", "description": "Start date for subaward action date filter (YYYY-MM-DD). Minimum: 2007-10-01." }, "dateTo": { "title": "Date To", "type": "string", "description": "End date for subaward action date filter (YYYY-MM-DD)." }, "minAmount": { "title": "Minimum Subaward Amount (USD)", "type": "integer", "description": "Filter for subawards at or above this dollar amount.", "default": 0 }, "maxItems": { "title": "Max Items", "minimum": 1, "type": "integer", "description": "Maximum number of subaward records to return.", "default": 15 }, "proxyConfiguration": { "title": "Proxy configuration", "type": "object", "description": "USAspending is a government API and does not require proxies." } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```