AFL Platform Update - 16th March 2026
AFL Warehouse 1.3 Update [16/03/2026]​
Match Periods Table​
This update adds the FIXTURES.MATCH_PERIODS table which returns the periods that occurred in each match, along with their actual start and end times (essential when working with match transaction timings).
Matches table additions​
This update adds the following columns to the FIXTURES.MATCHES table and the FIXTURES.MATCHES_BY_SQUAD view:
- Coin toss result and decision
- Match Attendance
- G.B.P for both squads
- Phase Name (i.e. Home & Away, Finals)
- Tier Code (AFLTIER1, AFLTIER2)
Match Player Stats Zero Id Fix​
A fix has been applied to the STATISTICS.MATCH_PLAYER_STATS table to remove rows assigned to Player Id 0 (zero). These rows are in fact Squad Stats that were appearing in the Player Stats table in error.
Calculated Metrics View​
A new view, REFERENCE.CALCULATED_METRICS has been added to the warehouse which returns the metric glossary entries for calculated metrics only. This makes it easier to identify them from the regular metrics that have actual statistic values.
AFL API 1.68 Update [23/03/2026]​
Season Player Availability Endpoint​
This updates adds a new API endpoint, the Season Player Availability Endpoint, which returns for a given season the availability of each player to play in each round. Where a player wasn't available, endpoint indicates the reason why not. This covers the player playing in a different competition and being unable to play due to injury (the type of injury specified).
- /v1/leagues/leagueId/levels/levelId/seasons/seasonId/playeravailability
New Metrics​
In general, all new metrics added to the AFL API are also available from the AFL Warehouse. Any exceptions will be highlighted here in the release notes.
Last Disposal Against Metric​
This update adds the 'Last Disposal Infringement Against' metric, which returns the number of times the lasso rule is applied. This metric is available at both Player- and Squad-level.
| Metric | Description |
|---|---|
| LAST_DISPOSAL_AGAINST Last Disposal Infringement Against | When the ball goes out of bounds via a disposal and possession is awarded to the opposing team |
45 Kick Retention Metrics​
This update adds 24 metrics that return how many 45 kicks resulted in possession retention or not. They are available at both Player- and Squad-level.
| Metric | Description |
|---|---|
| KICK_DIRECTION_45_RETAIN Forty-Five Kick Retained | 45 Kicks that resulted in a possession to a teammate |
| KICK_DIRECTION_45_LOSS Forty-Five Kick Loss | 45 Kicks that resulted in a possession to an opposition player |
| KICK_DIRECTION_45_RETAIN_SCORE Forty-Five Kick Retained Score | 45 Kicks retained that resulted in a score during the given chain |
| KICK_DIRECTION_45_LOSS_PUNISH Forty-Five Kick Loss Punished | 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_STOPPAGE Forty-Five Kick Stoppage | 45 Kicks that resulted in a stoppage before any possession has been won |
| KICK_DIRECTION_45_INBOARD_RETAIN Inboard Forty-Five Kick Retained | Inboard 45 Kicks that resulted in a possession to a teammate |
| KICK_DIRECTION_45_INBOARD_LOSS Inboard Forty-Five Kick Loss | Inboard 45 Kicks that resulted in a possession to an opposition player |
| KICK_DIRECTION_45_INBOARD_STOPPAGE Inboard Forty-Five Kick Stoppage | Inboard 45 Kicks that resulted in a stoppage before any possession has been won |
| KICK_DIRECTION_45_INBOARD_RETAIN_SCORE Inboard Forty-Five Kick Retained Score | Inboard 45 Kicks retained that resulted in a score during the given chain |
| KICK_DIRECTION_45_INBOARD_LOSS_PUNISH Inboard Forty-Five Kick Loss Punished | Inboard 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_OUTBOARD_RETAIN Outboard Forty-Five Kick Retained | Outboard 45 Kicks 45 Kicks that resulted in a possession to a teammate |
| KICK_DIRECTION_45_OUTBOARD_LOSS Outboard Forty-Five Kick Loss | Outboard 45 Kicks 45 Kicks that resulted in a possession to an opposition player |
| KICK_DIRECTION_45_OUTBOARD_STOPPAGE Outboard Forty-Five Kick Stoppage | Outboard 45 Kicks 45 Kicks that resulted in a stoppage before any possession has been won |
| KICK_DIRECTION_45_OUTBOARD_RETAIN_SCORE Outboard Forty-Five Kick Retained Score | Outboard 45 Kicks 45 Kicks retained that resulted in a score during the given chain |
| KICK_DIRECTION_45_OUTBOARD_LOSS_PUNISH Outboard Forty-Five Kick Loss Punished | Outboard 45 Kicks 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_RETAIN_SCORE_PCT Forty-Five Kick Retained Score Percentage | Percentage of 45 Kicks retained that resulted in a score during the given chain |
| KICK_DIRECTION_45_PUNISH_PCT Forty-Five Kick Punish Percentage | Percentage of 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_LOSS_PUNISH_PCT Forty-Five Kick Loss Punish Percentage | Percentage of 45 Kicks lost that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_INBOARD_RETAIN_SCORE_PCT Inboard Forty-Five Kick Retained Score Percentage | Percentage of Inboard 45 Kicks retained that resulted in a score during the given chain |
| KICK_DIRECTION_45_INBOARD_PUNISH_PCT Inboard Forty-Five Kick Punish Percentage | Percentage of Inboard 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_INBOARD_LOSS_PUNISH_PCT Inboard Forty-Five Kick Loss Punish Percentage | Percentage of Inboard 45 Kicks lost that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_OUTBOARD_RETAIN_SCORE_PCT Outboard Forty-Five Kick Retained Score Percentage | Percentage of Outboard 45 Kicks 45 Kicks retained that resulted in a score during the given chain |
| KICK_DIRECTION_45_OUTBOARD_PUNISH_PCT Outboard Forty-Five Kick Punish Percentage | Percentage of Outboard 45 Kicks 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain |
| KICK_DIRECTION_45_OUTBOARD_LOSS_PUNISH_PCT Outboard Forty-Five Kick Loss Punish Percentage | Percentage of Outboard 45 Kicks 45 Kicks lost that resulted in a possession to an opposition player who converted this into a scoring chain |