Government contract forensics — subaward chains, payment timelines, vehicle tracking, partnership mapping
TIER 1: DEPTH ANALYSIS — This skill traces government contracts through their full lifecycle: prime awards, subcontractor chains, payment timelines, vehicle competition, and teaming partnerships. LLMs can process hundreds of transaction records, cross-reference every contractor name against the investigation, and detect payment anomalies that humans miss in tabular data. Record every factual discovery separately. Do not theorize about procurement intent — record the money flows and flag patterns.
/analyze-contract "Palantir Technologies" — search for awards by recipient name/analyze-contract --award-id "W31P4Q20C0042" — analyze a specific award/analyze-contract --uei "ZE2JVFS8ML75" — all awards for a specific entity (by UEI)uv run python tools/investigation_context.py show
WORKDIR=$(mktemp -d /tmp/osint-XXXXXXXX)
echo "Session workdir: $WORKDIR"
# Search by recipient name (USASpending)
uv run python tools/query_usaspending.py awards --recipient "<NAME>" --output $WORKDIR/usa-awards.json
# Search by recipient (HigherGov — richer detail)
uv run python tools/query_highergov.py contract --awardee-uei <UEI> --output $WORKDIR/hg-contracts.json
# If you have a parent award / vehicle key
uv run python tools/query_highergov.py contract --parent-award <PARENT_ID> --all-pages --output $WORKDIR/hg-vehicle-contracts.json
Select the most significant awards by: dollar value, relevance to investigation threads, awarding agency, and recency.
# Full award detail (USASpending)
uv run python tools/query_usaspending.py award <AWARD_ID> --output $WORKDIR/award-detail.json
Extract and record:
This is the core forensic capability — follow the money through the supply chain.
# Get all subawards under this prime
uv run python tools/query_usaspending.py subawards --award-id <AWARD_ID> --output $WORKDIR/subawards.json
# For each significant subcontractor, get their detail
uv run python tools/query_highergov.py subcontract --awardee-uei <SUB_UEI> --output $WORKDIR/sub-<slug>.json
For each subcontractor:
Register each subcontractor:
uv run python tools/entity_tracker.py add-entity --name "<SUB_NAME>" --entity-type <TYPE> --source "USASpending:<AWARD_ID>"
# Transaction-level payment history
uv run python tools/query_usaspending.py transactions --award-id <AWARD_ID> --sort obligation_desc --output $WORKDIR/transactions.json
# Spending trends over time
uv run python tools/query_usaspending.py timeline --recipient "<NAME>" --output $WORKDIR/timeline.json
Read the transaction data and map:
Cross-reference transaction dates against investigation key_dates:
uv run python -c "
import yaml
with open('investigations/<ACTIVE>/config.yaml') as f:
dates = yaml.safe_load(f).get('key_dates', [])
for d in dates:
print(f'{d}')
"
This reveals the competitive landscape and corporate relationships.
# What vehicle is this contract on?
uv run python tools/query_highergov.py idv --award-id <PARENT_AWARD> --output $WORKDIR/hg-idv.json
# All contracts under this vehicle
uv run python tools/query_highergov.py contract --vehicle-key <VEHICLE_KEY> --all-pages --output $WORKDIR/hg-vehicle-all.json
# Who does this contractor team with?
uv run python tools/query_highergov.py partnership --awardee-key <AWARDEE_KEY> --output $WORKDIR/hg-partnerships.json
# Vehicle metadata
uv run python tools/query_highergov.py vehicle --vehicle-key <VEHICLE_KEY> --output $WORKDIR/hg-vehicle-meta.json
Analyze:
# Registration details
uv run python tools/query_sam.py entity --uei <UEI> --output $WORKDIR/sam-entity.json
# Debarment/suspension check
uv run python tools/query_sam.py exclusions --name "<NAME>" --output $WORKDIR/sam-exclusions.json
# Local bulk data (faster, more fields)
uv run python tools/ingest_sam.py entity-by-uei <UEI> --output $WORKDIR/sam-bulk.json
Check:
# Check every contractor name against entities
uv run python tools/entity_tracker.py lookup --name "<CONTRACTOR>"
# Check for existing findings
uv run python tools/findings_tracker.py search "<CONTRACTOR>" --output $WORKDIR/xref.json
# Geographic analysis — where was the work performed?
uv run python tools/query_usaspending.py geography --recipient "<NAME>" --output $WORKDIR/geography.json
Flag:
One finding per discrete discovery:
# Contract metadata
uv run python tools/findings_tracker.py add \
--target "<CONTRACTOR>" \
--summary "<AGENCY> awarded $<AMOUNT> contract (<AWARD_ID>) to <CONTRACTOR> for <DESCRIPTION>, period <START>-<END>" \
--type financial \
--evidence "USASpending:<AWARD_ID>" \
--claim-type paraphrase \
--source-quote "USASpending:<AWARD_ID>:Total Obligation $X, Award Type Y, Agency Z" \
--sources usaspending \
--confidence high
# Subcontractor relationship
uv run python tools/findings_tracker.py connect \
--person-a "<PRIME>" --person-b "<SUB>" \
--type financial --strength strong \
--evidence "USASpending:<AWARD_ID>" \
--finding-id <FID>
# Payment anomaly (inference)
uv run python tools/findings_tracker.py add \
--target "<CONTRACTOR>" \
--summary "Contract <AWARD_ID> shows $X obligation spike on <DATE>, coinciding with <KEY_DATE_EVENT>" \
--type financial \
--evidence "USASpending:<AWARD_ID>" \
--claim-type inference \
--source-quote "USASpending:<AWARD_ID>:Federal Action Obligation $X on <DATE>" \
--sources usaspending \
--confidence medium
# Unknown subcontractor
uv run python tools/lead_tracker.py add \
--title "Trace <SUBCONTRACTOR> — received $<AMOUNT> as sub on <AWARD_ID>" \
--category entity --priority medium \
--target "<SUBCONTRACTOR>" --source "agent:analyze-contract"
# Officer of contracting entity
uv run python tools/lead_tracker.py add \
--title "Investigate <OFFICER> — <ROLE> at <CONTRACTOR>, $<TOTAL> in federal contracts" \
--category person --priority medium \
--target "<OFFICER>" --source "agent:analyze-contract"
# Related vehicle analysis
uv run python tools/lead_tracker.py add \
--title "Analyze vehicle <VEHICLE_KEY> — <N> contracts, $<TOTAL> obligated" \
--category contract --priority medium \
--target "<VEHICLE_NAME>" --source "agent:analyze-contract"
A human analyst looking at a contract sees: recipient, amount, agency. They rarely trace subcontractor chains, analyze payment timing patterns across hundreds of transactions, or cross-reference every contractor name against an investigation database of thousands of entities.
An LLM agent processes the full transaction history and complete subcontractor tree, then cross-references every name. This surfaces: