Independent private directory · Federal contracts only · Not affiliated with the U.S. Government
SAM.gov & USASpending methodology
OpenFedBids
Home / Data Sources & Methodology

Data Sources & Methodology

OpenFedBids is an independent private directory built strictly on public-domain U.S. government data (17 U.S.C. § 105). We are not affiliated with GSA, SAM.gov, or the U.S. Treasury.

1. SAM.gov Daily Bulk Extract
Last-Modified: Sun, 22 Nov 2026 04:30:19 GMT

Source: Official GSA public CSV (ContractOpportunitiesFullCSV.csv, decoded as Windows-1252). Never scraped from SAM.gov web pages.

2. USASpending.gov API v2
Last Refreshed: 2026-11-22

Source: U.S. Treasury api.usaspending.gov/api/v2/search/spending_by_award/ for past 12-month contract awards and rolling next-12-month expiration dates.

Four Hard Data-Integrity Rules

1. Solicitation Deduplication (~29.3% clutter removed): Raw SAM.gov extracts include multiple active rows for the same solicitation (amendments, presolicitation + solicitation pairs). OpenFedBids deduplicates by Sol# (retaining the latest PostedDate) and separates immediately biddable Solicitations / Combined Synopsis from Sources Sought, Presolicitations, and Special Notices.
2. Honest Work Location vs. Buying Office Labeling: Place of Performance (PopState) is always used when supplied. Contracting Office (State) is used only when Place of Performance is blank and is explicitly badged “Buying office: [ST]; work location not supplied.” Confirmed out-of-state work is never mixed onto a buying office's state page.
3. Past Award Amount Medians (Not Unit Prices): USASpending medians and middle-50% (p25–p75) ranges are computed strictly on positive (>$0) contract obligation amounts, sorted chronologically rather than by size. A median resists mega-contract outliers but is not a recommended bid price — always compare scope and duration.
4. Expiring-Contract Watchlist: Built by scanning active federal contracts ≥$25,000 with actions in the prior 4 years whose Period of Performance Current End Date falls in the rolling next 12 months. Expiration does not guarantee a new solicitation.

Recent ETL Runs

SourceStatusDedup / UpsertedStarted (UTC)
USASPENDINGSUCCESS7 / 11532026-11-22T20:53:42
USASPENDINGSUCCESS27 / 37072026-11-22T20:29:56
USASPENDINGSUCCESS14 / 29412026-11-22T20:24:36
SAM_CSVSUCCESS1734 / 17342026-11-22T20:23:33