Standings and League History: proof

#1329 ยท data: production D1 read-only snapshot 2026-10-17 14:45 UTC; MFL exports fetched the same hour. "Branch worker" = this preview's code run offline on that snapshot. Nothing here was written anywhere.

1. 2026 seeds after Week 5, three independent ways

Recomputed from MFL's raw weeklyResults (no repo code), compared with MFL's own leagueStandings and D1, then with the live route on main and the branch route. โœ“ = records, All-Play and PF identical in all three sources.

SeedTeamAll-PlayW-LPFMFL=D1=recomputemain orderbranch orderWhy below the team above
1C-Town Chivalry45-1011-21297.3โœ“11
2Blake Bombers40-159-41242.5โœ“22all_play
3HammerTime ๐Ÿ”จ โฐ37-189-41187.2โœ“33all_play
4Real Deal Creel32-239-41145.8โœ“44all_play
5CBP32-237-61106.2โœ“55overall
6Pure Greatness31-246-71151.0โœ“66all_play
โ€”Hawks29-266-71041.0โœ“77all_play
โ€”Cleon Ca$h23-326-71046.9โœ“88all_play
โ€”L.A. Looks20-356-7997.7โœ“99all_play
โ€”Gride16-393-10961.9โœ“1010all_play
โ€”The Long Haulers14-413-101008.5โœ“1111all_play
โ€”Sex Manther11-443-10931.2โœ“1212all_play

2. Seed order after every week (branch worker)

Week 4 equals the order published after Week 4 in #1197.

AfterSeeds 1-6Next out
Week 1HammerTime ๐Ÿ”จ โฐ, CBP, Pure Greatness, Real Deal Creel, Gride, Cleon Ca$hSex Manther
Week 2HammerTime ๐Ÿ”จ โฐ, CBP, Pure Greatness, C-Town Chivalry, Blake Bombers, Real Deal CreelGride
Week 3HammerTime ๐Ÿ”จ โฐ, C-Town Chivalry, Blake Bombers, CBP, Real Deal Creel, HawksPure Greatness
Week 4C-Town Chivalry, HammerTime ๐Ÿ”จ โฐ, Blake Bombers, CBP, Hawks, Real Deal CreelCleon Ca$h
Week 5C-Town Chivalry, Blake Bombers, HammerTime ๐Ÿ”จ โฐ, Real Deal Creel, CBP, Pure GreatnessHawks

3. Finished seasons: /api/standings seeds on main vs the recorded seeds

Main recomputes old seasons with today's 4+2 rule. Mismatching seeds per season, and teams wrongly in or out of the six-team field. (The branch leaves this unchanged on purpose; changing historical seeds is a decision in #1329.)

SeasonSeeds โ‰  recordedField differs (franchise ids)
201020001, 0002
20113โ€”
201230004, 0012
201340003, 0004, 0009
20144โ€”
20153โ€”
20160โ€”
201750001, 0003, 0010, 0012
20182โ€”
201930005, 0010
20203โ€”
20212โ€”
20224โ€”
20232โ€”
20240โ€”
20250โ€”

4. Finish โ†’ rookie pick, from 281 traced picks (2012-2025)

Each Round 1-5 slot traced to its original owner through every recorded pick trade, joined to that owner's prior-season finish.

FinishCanon pickMatchesSlots seen
11.1223 of 23.12ร—23
21.1124 of 24.11ร—24
31.1015 of 18.10ร—15, .02ร—2, .01ร—1
41.0929 of 30.09ร—29, .01ร—1
51.0718 of 19.07ร—18, .02ร—1
61.0822 of 25.08ร—22, .01ร—2, .07ร—1
71.0120 of 23.01ร—20, .02ร—2, .07ร—1
81.0214 of 17.02ร—14, .03ร—2, .05ร—1
91.0319 of 23.03ร—19, .04ร—4
101.0418 of 24.04ร—18, .03ร—3, .05ร—1, .11ร—1, .12ร—1
111.0516 of 24.05ร—16, .01ร—3, .07ร—2, .02ร—1, .04ร—1, .08ร—1
121.0630 of 31.06ร—30, .01ร—1

5. History facts shown wrong today (proposed corrections, not applied)

SeasonTopicFranchiseStoredProposedConfidence
2011placements0007118high
2011placements0008811high
2011seeds/regular finish0007/0008{"0007": 8, "0008": 11}{"0007": 11, "0008": 8}high
2015placements0003,0009,0004,0012{"0011": 6, "0003": 6, "0009": 7, "0004": 8, "0012": 9, "none": 10}{"0011": 6, "0003": 7, "0009": 8, "0004": 9, "0012": 10}high
2023placements0009/0011{"0009": 9, "0011": 10}{"0011": 9, "0009": 10}high
2023seeds/regular finish0001/0007{"0001": 4, "0007": 5}{"0007": 4, "0001": 5}high
2013seeds/regular finish0003/0007{"0003": 6, "0007": 6, "none": 7}{"0003": 6, "0007": 7}medium
2014seeds/regular finish0004/0011{"0004": 10, "0011": 11}{"0011": 10, "0004": 11}low
2010divisionsall"4 codes (00-03), identical by franchise id to the uncorrected 2011 layout""MFL 2-division layout; division winners 0008 (01) and 0001 (00)"high
2016-2018standingsall"0-0, pct 0 for all 36 rows""load MFL/local division records"high
2010standings11 of 12"16-19 games, league W 105 vs L 106 (e.g. 0008 12-6, 0007 5-12)""MFL leagueStandings h2hwlt"high
2011standingsall"full season incl. playoffs (0010 2904.7)""MFL regular-season pf"high
2010standingsall"matches neither W1-13 nor W1-16 weekly sums (0008 2285 vs 1881.3 / 2494.7)""W1-13 sum of src_franchise_weekly_score, flagged as reconstructed"low
2012division titles0010 vs 0011"worker comparator (Overall, Div PCT, PF, AP; no pairwise H2H) picks 0011 (PF 20"0010 (Shawn Blake)"medium
2011-2012identity0008"\"Raining Bullets\"""Bad Newz Kennels"high
2014-2017identity0002"\"Crystal Blue Persuasian\"""Crystal Blue Persuasion"high
2010/2011identity2010 0009 / 2011 0006"\"Dave Murray\" (2010) vs \"David Murray\" (2011)""one spelling (Keith to confirm same person)"medium
2010-2025identity0008 (and all)"0008 franchise_championships 1, last 2010; every franchise_seasons_played = 16""decision: exclude 2010 from franchise-id lineage, or map 2010 ids to 2011 lineamedium
allidentityall 12"owner_seasons_count 0, owner_championships 0, owner_allplay_pct 0, all *_years "rebuild (pipelines/etl/scripts/rebuild_franchise_career_stats.py) and verify"high

6. Tests

FileResultWhat it proves

7. D1 cost (measured rows_read)

ReadRows
/api/standings 2026, uncached (main โ†’ branch)โ‰ˆ720 โ†’ โ‰ˆ564
/api/standings 2025, uncached (main)โ‰ˆ2,140
/api/playoff-bracket 2026, current-season path (main โ†’ branch)โ‰ˆ156 โ†’ โ‰ˆ216
Weekly / top-score / team history / scored-faced views0 extra (computed from the standings response)
This audit: snapshot + measurements7,242 + 2,860 once
Phone preview recording (app boot reads, once)โ‰ˆ175k (12 empty past-season leaderboard calls the app makes on boot; flagged separately)