Contract opportunity notices: the current file and every fiscal-year archive.
Publisher: General Services Administration, SAM.gov
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| noticeid | string | d45af4c8a293338c8a115581354b7b21 |
| title | string | G--Keyboardist- Catholic Services, 1200 SUN MCAS Futenma |
| sol | string | M6740010T0104 |
| departmentindagency | string | DEPT OF DEFENSE |
| cgac | string | 017 |
| subtier | string | DEPT OF THE NAVY |
| fpds_code | string | 1700 |
| office | string | COMMANDING OFFICER |
| aac_code | string | M67400 |
| posteddate | string | 2029-12-20 01:18:21 |
| type | string | Presolicitation |
| basetype | string | Presolicitation |
| archivetype | string | autocustom |
| archivedate | string | 2010-06-05 |
| setasidecode | string | SBA |
| setaside | string | Small Business Set Aside - Total |
| responsedeadline | string | 2010-05-21T00:00:00-05:00 |
| naicscode | string | 923110 |
| classificationcode | string | G |
| popstreetaddress | string | USDA, ARS, ERRC600 East Mermaid Lane Wyndmoor, PA 19038 |
| popcity | string | |
| popstate | string | |
| popzip | string | |
| popcountry | string | |
| active | string | No |
| awardnumber | string | F09607-02-D2001 |
| awarddate | string | 2001-09-26 |
| award | string | not to exceed 95,562.50 |
| awardee | string | King Moving and Storage1700 Cypress Street Valdosta, GA 3160 |
| primarycontacttitle | string | Purchasing Agent |
| primarycontactfullname | string | Manetta B. Williams 011-81-611-745-3128 Manetta B. Williams/ |
| primarycontactemail | string | rdennis@errc.ars.usda.gov |
| primarycontactphone | string | 215-233-6553 |
| primarycontactfax | string | 215-233-6485 |
| secondarycontacttitle | string | Contract Specialist |
| secondarycontactfullname | string | Maureen V Corpus |
| secondarycontactemail | string | maureen.corpus@moody.af.mil |
| secondarycontactphone | string | 229-257-4715 |
| secondarycontactfax | string | 229-257-4032 |
| organizationtype | string | OFFICE |
| state | string | AP |
| city | string | FPO |
| zipcode | string | 96371-9001 |
| countrycode | string | USA |
| additionalinfolink | string | |
| link | string | https://sam.gov/workspace/contract/opp/d45af4c8a293338c8a115 |
| description | string | This is a pre-solicitation notice for commercial services pr |
| source_file | string | FY2030_archived_opportunities.csv |
| fiscal_year | string | 2030 |
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.