§ showcase · what's in the database

Every field. Every source. Live from our DB.

Two demo pages that expose every dimension of the foot.io database — shown on the records with the most metadata we have. No mock-ups, no dummy data, no shrinkwrap over the API: each page queries live Supabase the same way your integration will.

Richest team record

Manchester United.

Full bio row + 38 seasons of standings + 1,300+ matches + 884 lineups + 8 external IDs (Wikidata, FBref, Transfermarkt, StatsBomb, Understat, football-data.org, social handles) + canonical home-kit palette.
1,307
Matches
38
Seasons
884
Lineups
8
External IDs
Open team showcase →
Richest player record

Mohamed Salah.

Complete biography + 13 seasons of career stats across 40+ stat columns (goals, assists, xG, xAG, SCA, GCA, progressive passes, key passes, cards, minutes) + timestamped match events + 10 external IDs — more cross-source links than any other player we store.
13
Seasons
195
Career goals
325
Events
10
External IDs
Open player showcase →

What these pages prove

Depth on live data

Every widget is a live Supabase query — refresh the page and you'll see any new rows that landed overnight. No pre-rendered HTML, no stale cache.

Cross-source linkage

We don't just store our own data — each entity is cross-referenced to Wikidata, FBref, Transfermarkt, StatsBomb, Understat, football-data.org and more. One join, any source.

Raw record transparency

Both pages include a collapsible "Raw record" section with the untouched JSON dump. No marketing layer — this is literally what's in the database.

Frequently asked

Why not show the average record?

Because the ceiling matters for integrators. You want to know what's possible with our data, not what the coverage floor looks like. The floor is documented in the data catalogue.

How was the richest record chosen?

We scored every team and player across: row-field completeness, number of external IDs, related-row counts (matches, lineups, events, season stats, standings). The top scorers were Manchester United (id 423) and Mohamed Salah (id 10577).

Can I replicate these pages for any entity?

Yes — these pages hit public Supabase endpoints. Clone the markup, swap the hardcoded id, and you have a rich dashboard for any team or player. The underlying queries are plain PostgREST.

Why is some data sparse on other records?

Long tail. Top-flight European clubs have 30+ seasons of FBref coverage; third-division Moldovan clubs don't. We don't fabricate data to fill gaps — missing fields are returned as null, and you can filter for records that meet your coverage bar.