---
title: Map ESPN stat 80 to field goals under 40 yards
type: task
status: completed
description: >-
  libs-server/espn.mjs maps ESPN stat 80 (field goals made under 40 yards) to
  field_goals_made_30_39_yards, mislabelling a bucket in every stored ESPN kicker row.
base_uri: user:task/league/map-espn-stat-80-to-field-goals-under-40.md
created_at: '2026-10-29T20:26:54.393Z'
entity_id: a8f1dbce-3a9b-4af2-b545-c0388f5be286
finished_at: '2026-10-29T23:49:04.882Z'
owner_identity_uri: █████████████████████████
priority: Medium
public_read: true
relations:
  - relates [[███████████████████████-████-███████████-████-██████-██████-██████████]]
started_at: '2026-10-29T22:38:55.832Z'
tags:
  - user:tag/league-xo-football.md
updated_at: '2026-10-29T23:49:04.882Z'
visibility_analyzed_at: '2026-11-05T23:49:42.837Z'
---

## Problem

`libs-server/espn.mjs` maps ESPN stat 80 to `field_goals_made_30_39_yards`, but stat 80 is field goals made under 40 yards (0-39). Every stored ESPN kicker projection therefore files its short field goals in the 30-39 bucket. Comparing that column to our 0-39 sum lifts ESPN-to-gamelog matches by 38-101 rows a season. Found 2026-10-29 by the ESPN leak audit.

## Plan

- [x] Confirm the stat id's meaning against ESPN's own stat map, and whether ESPN carries finer buckets (0-19, 20-29) to map instead. Done 2026-10-29: 80 = 81 - 82 and 80 + 77 + 74 = 83 on every kicker line in the 2020-2026 feeds; ESPN has no finer id.
- [x] Fix the mapping, with a spec. Done 2026-10-29 (league `457e4a2e5`): id 80 splits across 20-29 and 30-39 by the measured make mix in `complete-kicking-projection.mjs`, 0-19 folded into 20-29.
- [x] Decide whether to rewrite stored ESPN kicker rows; if so, rebuild the consensus and derived points for those seasons. Done 2026-10-29: 2,857 index and 18,099 history rows split in place (a column relabel, not a value revision); 2020-2025 rebuilt and 2026 weeks 1-7 recomputed. The split exposed two leaked 2020 week 2 kicker zero lines, now corrected.

## Done when

ESPN's short field goals land in a column that means what ESPN means, and any rewritten seasons are re-derived.