Skip to content
Almanac
Menu
⚽

Football

  • 159 competitions
  • 72 countries
  • 113 active leagues
  • 1,380 season tables
  • 91,361 matches

Last night

Jobs that started in the last 24 hours

No nightly job has recorded a run yet; next run weekly-refresh at 00:00 UTC.

Stuck: 7 items automation couldn't finish

Stuck

2 held · 5 duplicate
  • HeldNigeria Professional Football League 2022-23, 2021-22
    • The ingestion config builds 2022 where the coverage grid expects 2022-23; check seasonFormat
    • The ingestion config builds 2021 where the coverage grid expects 2021-22; check seasonFormat
    Next: Retries when its config changes
  • HeldCampeonato Brasileiro Série C 2021
    • Multi-phase competition (promotion-group-b, promotion-group-c): the ingest job only imports single-table seasons
    Next: Retries when its config changes
  • DuplicateReal Valladolid II and Valladolid Promesas
    • One name contains the other
    • Same parent team
    • Created by a recent refresh with few seasons
    Next: No automatic fix yet
  • DuplicateDukla Banská Bystrica and Dukla Banská Bystrica
    • Same name after normalising
    • Created by a recent refresh with few seasons
    Next: No automatic fix yet
  • DuplicateFK Kukësi and Kukësi
    • One name contains the other
    • Same competition in adjacent seasons, no overlap
    • Created by a recent refresh with few seasons
    Next: No automatic fix yet
Show all (+2)
  • Duplicate FK Voždovac and VoždovacOne name contains the other · Next: No automatic fix yet
  • Duplicate Kecskeméti TE and KecskemétOne name contains the other · Next: No automatic fix yet

17 more suspected duplicate pairs in Suspected duplicate stubs.

Goals

What each nightly job is working towards
  • Events58 of 68,607 finished API-Football matches have events
    44,829 still to fetch.
  • Transfers1,060 of 56,115 players have transfers stored
    1,097 transfer rows. Players checked will come from the job's cursor once it runs.
  • Player profiles2,215 of 57,593 API-Football players have a full name and birth date
    55,378 still to fill.
  • Gap planner66 of 113 leagues have 5 complete seasons
    128 league-seasons to go, 40 picked for tonight.
  • Ingest queue0 of 8 queued seasons done
    0 imported, 0 skipped. Seasons come from the files in apps/jobs/ingest-queue.

Seasons by competition

0 of 159 competitions
10 seasons20 seasonsAll
Filters (1)
Data source
Clear filters
Complete tablePartial tableMatches onlyWith eventsIn progress (fill = played)Marked current, season overSkipped by the nightly importQueued for the nightly importMissingNot tracked (cups, before first stored season)Not running
Competition16–2011–156–10Last 5Now
20060708091011121314151617181920212223242526

No competitions match these filters.

Backfill queue

66 of 113 leagues at 5 seasons · 128 seasons to go · The nightly import hasn't run yet; next run 03:30 UTC

Tonight's run picks 40 seasons (it stops at 40): queue files first, then the newest gaps, top tiers first.

TonightLaterHeld
  • No league in the queue matches these filters.

Data checks

Things the stored data doesn't add up on

Sorted by count. No daily history of these counts is stored yet, so there is no change since yesterday to show.

Scheduled jobs

Every unattended job in both services. Times UTC.
Every scheduled job with its last and next run
JobLast runNext run
weekly-refresh

API · daily 00:00 UTC

Refreshes current-season standings and fixtures from API-Football and rolls finished seasons over

Never run
quality-scan

API · daily 01:00 UTC

Runs the data quality checks and records new findings

Never run
daily-stats-refresh

API · daily 03:00 UTC

Pulls player leaderboards (scorers, assists, cards) for current seasons of the mapped leagues

Never run
stub-snapshot

API · daily 04:00 UTC

Records the daily stub team count and checks for suspected duplicate stubs

Never run
heartbeat

Jobs · daily 03:30 UTC

Writes one run and one data change to prove the jobs service ran

Never run
fixtures-backfill

Jobs · daily 03:30 UTC

Fetches API-Football fixtures for past league seasons with missing matches, newest first, linking matches already stored

Never run
events-backfill

Jobs · daily 03:30 UTC

Fetches match events and line-ups for finished matches that have none, newest first

Never run
transfers-backfill

Jobs · daily 03:30 UTC

Fetches transfer history for players with the most match minutes first

Never run
ingest

Jobs · daily 03:30 UTC

Imports queued Wikipedia standings seasons that pass the auto-gate

Never run
dissolved-backfill

Jobs · daily 03:30 UTC

Sets dissolved years on teams from Wikidata, at most once a week

Never run
player-profiles

Jobs · daily 03:30 UTC

Fills missing names, birth dates, nationality and photos for stub players

Never run
smoke

Jobs · daily 03:30 UTC

Walks the production site and alerts on pages that keep failing

Never run

1,860 stub teams: 1,318 in API-Football leagues, 542 Wikipedia only. 145 new in the last 14 days. All stub teams →

Suspected duplicate stubs (22)

  • 70Real Valladolid II and Valladolid Promesas
    Spain · API 9587 · 2021-22 · twin 1991-92 to 2019-20
    One name contains the otherSame parent teamCreated by a recent refresh with few seasons
  • 65Dukla Banská Bystrica and Dukla Banská Bystrica
    Slovakia · API 10533 · 2026-27 · twin 2024-25
    Same name after normalisingCreated by a recent refresh with few seasons
  • 65FK Kukësi and Kukësi
    Albania · API 577 · 2021-22 · twin 2020-21 to 2023-24
    One name contains the otherSame competition in adjacent seasons, no overlapCreated by a recent refresh with few seasons
  • 65FK Voždovac and Voždovac
    Serbia · API 2658 · 2021-22 to 2022-23 · twin 2023-24
    One name contains the otherSame competition in adjacent seasons, no overlapCreated by a recent refresh with few seasons
  • 65Kecskeméti TE and Kecskemét
    Hungary · API 5111 · 2022-23 · twin 2023-24 to 2024-25
    One name contains the otherSame competition in adjacent seasons, no overlapCreated by a recent refresh with few seasons
  • 65KF Gostivari and Gostivar
    North Macedonia · API 4338 · 2023-24 · twin 2024-25
    One name contains the otherSame competition in adjacent seasons, no overlapCreated by a recent refresh with few seasons
  • 65Mezokovesd-zsory and Mezőkövesd
    Hungary · API 2389 · 2021-22 to 2022-23 · twin 2023-24
    One name contains the otherSame competition in adjacent seasons, no overlapCreated by a recent refresh with few seasons
  • 55Al-Ittihad Kalba and Kalba
    United Arab Emirates · API 2876 · 2025-26 to 2026-27 · twin 2024-25
    One name contains the otherSame competition in adjacent seasons, no overlap
  • 55América Mineiro and Americana
    Brazil · API 125 · 2010 to 2026 · twin 2011
    One name contains the otherSame competition in adjacent seasons, no overlap
  • 55Athletic Carpi and Carpi
    Italy · API 17825 · 2025-26 to 2026-27 · twin 2011-12 to 2024-25
    One name contains the otherSame competition in adjacent seasons, no overlap

Stubs created in the last 14 days (145)

Stub teams created recently
TeamCountryLeagueAPI IDCreated
Andorra CFSpainSegunda División B Group 22026-10-16
BalingenGermanyRegionalliga Südwest93602026-10-16
BW LohneGermanyRegionalliga Nord146292026-10-16
ChamGermany197612026-10-16
KirchanschöringGermany128052026-10-16
RSV EintrachtGermany147542026-10-16
UD OurenseSpain96172026-10-16
HildenGermanyRegionalliga West127902026-10-16
SE DonsEngland283452026-10-16
Tadley CallevaEngland89642026-10-16

Every automatic data change the nightly jobs make is listed in the changelog.

2. Bundesliga

Germany · tier 2 · API-Football #79 + Wikipedia · Competition page

✓ 5 seasons: 5/5✓ 10 seasons: 10/10✓ 15 seasons: 15/15✓ 20 seasons: 20/20
2006 to 2026
SeasonStateRowsMatchesEventsStagesLink
2026-27In progress18/1865/30621Open
2025-26Complete18/1830802 · ZOpen
2024-25Complete18/18002 · ZOpen
2023-24Complete18/18002 · ZOpen
2022-23Complete18/18002 · ZOpen
2021-22Complete18/18002 · ZOpen
2020-21Complete18/18002 · ZOpen
2019-20Complete18/18002 · ZOpen
2018-19Complete18/18002 · ZOpen
2017-18Complete18/18002 · ZOpen
2016-17Complete18/18002 · ZOpen
2015-16Complete18/18002 · ZOpen
2014-15Complete18/18002 · ZOpen
2013-14Complete18/18002 · ZOpen
2012-13Complete18/18002 · ZOpen
2011-12Complete18/18002 · ZOpen
2010-11Complete18/18002 · ZOpen
2009-10Complete18/18001Open
2008-09Complete18/18001Open
2007-08Complete18/18001Open
2006-07Complete18/18001Open
2005-06Complete18/18001Open
2004-05Complete18/18001Open
2003-04Complete18/18001Open
2002-03Complete18/18001Open
2001-02Complete18/18001Open
2000-01Complete18/18001Open
1999-00Complete18/18001Open
1998-99Complete18/18001Open
1997-98Complete18/18001Open
1996-97Complete18/18001Open
1995-96Complete18/18001Open
1994-95Complete18/18001Open
1993-94Complete20/20001Open

13 older seasons before 2006 are included above.

Rows show stored / expected. Matches show played / stored. Z means promotion and relegation zones are set.