Public award intelligence / Federal + Texas / Source dates, clearly stated
SunsetIQ radar markSunsetIQ

Provenance / scope / limitations

The record comes first.

Public award data only. No source-selection information, leaked proposals, pre-award deliberations, or ungranted login material. The operating agent loads records; this app only reads the base.

Federal source of record

USASpending API v2 + bulk downloads are free and require no API key. Founding loaded slice: Texas place of performance, award types A–D, action dates 2025-11-01 through 2026-11-01, search award amount at least $250,000; only 600 detail-checked candidates in the founding expiry window were loaded. This is a partial slice. Vendor full federal footprints have not been established.

Texas coverage

DIR via data.texas.gov is the structured Texas source. LBB and SmartBuy have no verified bulk/API route; hand-verified capture is sample-only. ESBD corroborates notices and is never the system of record for an expiry.

SAM Public-tier gate

No operator key verified, no SAM load, no SAM data claimed. The app holds no SAM credentials. FOUO and Sensitive data are never requested or stored. Opted-out entities may be absent from Public data; absence never means unregistered.

Three counts, three meanings

Sourced is the matching upstream population. Loaded is rows in this base. Published is eligible rows visible in the app: published flag plus source, source identifier, and source as-of. Different counts are not interchangeable.

Expiry date definitions

pop_current_end
Period of performance current end date (USASpending)
dir_term
DIR contract page term date
dir_expiration
DIR contract page expiration date
published_end
End date as published by source

Dates reflect the source record. Options and extensions exist; an end date does not establish that a contract will be recompeted, renewed, or terminated.

Source reconciliation · read from the base

SourceSourcedLoadedPublished
USASpending1077846374637
DIR5179 dataset rows · prior load note, live count unverified764764
LBB · sample onlyNo universe count00
SmartBuy-Statewide · sample onlyNo universe count00

Counts as documented on 2026-11-01. Federal count uses the founding filters and counts sourced awards before the loader’s expiry selection; it is not an expiry-window count. The live count disagrees with the older source registry’s 15,339 claim; that discrepancy is retained below. The registry documents half-year search partitions; the partition execution has not been independently re-run. DIR’s dataset-row count and loaded contract/vendor pairs have different grains. Texas source hosts could not be resolved during verification, so neither the live DIR count nor contract-page term/expiration comparison passed verification.

Public source registry

USASpending API v2 + bulk downloads

U.S. Department of the Treasury / Bureau of the Fiscal Service · Cadence: Nightly (DATA Act Broker)

Federal contract awards (types A-D). v5 slice (2026-11-10 full-Texas load, JR GO): Texas place of performance, action dates 2025-11-01..2026-11-01, search-stub Award Amount >= $250,000 -> 15,443 sourced / 10,832 unique stubs (founding 2026-11-01: 15,339 / 10,778; delta is index refresh). Founding 600 already loaded excluded by generated_unique_award_id; remaining 10,233 stubs detail-checked per-award via /api/v2/awards/{id} (0 failures); PoP current end date verified in the EXTENDED 18-month window 2026-11-01..2028-04-30 -> 4,037 newly loaded. Base totals after v5: 5,401 contracts (4,637 USASpending + 764 DIR), 5,400 expirations, 2,572 vendors, 32 agencies. DIR kept separate. Search cap ~10,000/query - partitioned in two date halves as at founding.

DIR Current Active Cooperative Contracts (data.texas.gov vipt-h4ye)

Texas Department of Information Resources via Texas Open Data Portal · Cadence: As published by DIR on data.texas.gov

5,179 dataset rows deduped to 764 distinct contract_number + primary_vendor_name pairs, all loaded 2026-11-01. Expiry = dataset field contract_termination_date, labelled published_end; DIR pages carry term vs expiration separately (not in this dataset).

LBB Contracts Database

Texas Legislative Budget Board · Cadence: Nightly CAPPS integration (per LBB)

197,000+ contracts / ~$357.2B per LBB. NO bulk load at founding - hand-verified sample only, plus a written export-route query. Never scrape around its login.

Comptroller Statewide Contracts / Texas SmartBuy

Texas Comptroller of Public Accounts (SPD) · Cadence: As published

TxSmartBuy term / managed / TXMAS contracts. Hand-verified capture only at founding.

Electronic State Business Daily (ESBD)

Texas Comptroller of Public Accounts via Texas SmartBuy · Cadence: Daily

Solicitation + award notices >= $25,000. Corroboration only - never the system of record for an expiry.

SAM.gov Entity Management (Public tier)

U.S. General Services Administration · Cadence: Monthly full extract / daily deltas (extracts); API live

GATED: no key held, no load performed, no SAM field populated at founding. Public tier only - FOUO/Sensitive permanently out. Opted-out entities are absent from Public data; absence never proves unregistered.

Rollups without n, period, and source set are withheld. Personal vendor contact details are never a product field or a lead list.