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
| Source | Status | Dedup / Upserted | Started (UTC) |
|---|---|---|---|
| USASPENDING | SUCCESS | 7 / 1153 | 2026-11-22T20:53:42 |
| USASPENDING | SUCCESS | 27 / 3707 | 2026-11-22T20:29:56 |
| USASPENDING | SUCCESS | 14 / 2941 | 2026-11-22T20:24:36 |
| SAM_CSV | SUCCESS | 1734 / 1734 | 2026-11-22T20:23:33 |