ListTrac

AFL player movement, list, contract-status, and draft tracker — Spotrac/Tankathon for Australian sport.

Scope (v1 — AFL)

• List tracker (current club lists)
• Trade & movement tracker
• Draft tracker (order, points, pick trade history)
• Contract status board (status only — no salary figures; AFL doesn't disclose these)

Structure

• scraper/ — data ingestion (AFL Tables, Draftguru, Zerohanger, AFL.com.au, Squiggle API)
• data/ — schema.sql + load.py (builds listtrac.db from the scrapers via identity.py)
• api/ — FastAPI read API over the SQLite DB (uvicorn api.app:app serves API + frontend)
• admin/ — manual entry tool for trades/contract status (no clean public source exists)
• web/ — frontend (vanilla SPA, no build step; served by FastAPI everywhere). Must NOT be renamed public/ — Vercel strips that folder from function bundles.

Deploy (Vercel)

Everything routes through the Python function (api/index.py): vercel.json bundles the whole repo into it (includeFiles: "**") and FastAPI serves both the API and web/ static files. data/listtrac.db is a committed read-only snapshot that ships with each deploy. To refresh the data: python data/load.py, commit the new DB, push — Vercel redeploys. Scraper-only deps live in scraper/requirements.txt so the function stays lean.

News spotlights (web layer)

Aggregate existing contract/trade/free-agency coverage, Spotrac-spotlights style: headline + source + link out only. Paywalled/firewalled pieces get linked like everything else — never reproduced or summarized around the paywall.

Data sources

• AFL Tables (afltables.com) — historical player/club data
• Footywire — current squads, stats
• Draftguru (draftguru.com.au) — historical drafts, trades, lists by year
• Zerohanger + AFL.com.au — contract status / free agent lists
• Squiggle API (squiggle.com.au) — ladder/standings, proper public API
• Manual/reporter-sourced — trades, draft picks, contract status

Roadmap: draft & trade depth (agreed 2026-07-21)

• Trade machine (Spotrac's NBA trade machine as the case study): build multi-club trades from players + picks with DVI valuation and contract status context. Sits in the Trades section alongside the historical browser. Next major build.
• 3-year prospect runway (nbadraft.net as the case study): extend the prospect pool back to U16 National Championships squads, so 2027/2028 draft classes are trackable from their U16 year. Rookie Me Central covers U16 champs the same way it covers U18s.
• Pick intel (shipped): per-pick DVI, avg games, AA%, premiership%, Rising Star% from Draftguru pick histories + Wikipedia nominee lists, 1986–2020 cohort.

Roadmap: v1.5 — fantasy context layer

Fantasy-as-context, not fantasy-tools. FanFooty owns live scoring, planners, projections, and editorial player news — don't compete there. ListTrac's wedge is fantasy data alongside the structural layer nobody else has: contract status, FA class, trade history, draft pedigree on the same player page.

• fantasy_score table: player_id, year, round, sc_points, af_points, af_price, breakeven
• FootyWire scraper for SC/AF points per round (fitzRoy has a reference implementation; doubles as the footywire_id reconciliation source)
• AFL Fantasy JSON feed for prices/ownership
• Generated "player notes" view merging scoring trends with movement/contract flags — e.g. "off-contract 2026, restricted FA, SC average up 18 on last year". Data-driven blurbs only; no editorial, no live scores.
• FanFooty is a competitor reference, not a data source (proprietary feed)

Non-goals (v1)

• Contract dollar values (no public source, don't fabricate)
• NRL/NBL support (planned expansion, not v1)
• Live fantasy scoring, team planners, projections (FanFooty's turf — see v1.5)