Open Data & API

Every stat on this site is built from ranked matches captured straight from Age of Empires II: DE's community API, then aggregated. The raw capture and the aggregate are published here so you can run your own analysis — no scraping, no account. Everything refreshes weekly.

Downloads

matches.parquet — one row per match players.parquet — one row per player per match ranked_data.json — the pre-aggregated stats this site reads

JSON endpoint

The aggregate the front-end consumes is a stable, CORS-readable static file — treat it as a read-only JSON API. It carries civ win/pick rates by ladder · ELO · patch, win rate by game length, weekly series, per-map civ stats, and the 1v1 matchup matrix.

GET https://aoe2-guide.vercel.app/data/ranked_data.json

matches.parquet

Column	Type	Description
match_id	int	Relic match id (unique)
ladder	str	`1v1` or `team` (Random Map)
matchtype_id	int	Relic match-type enum
map	str	normalized map name
num_players	int	players in the match
start_time / completion_time	int	unix timestamps
duration_min	float	match length in minutes
avg_elo	float	mean pre-game rating across players
week_end	str	ISO date of the Sunday ending that week
patch	int	patch bucket stamped on capture

players.parquet

Column	Type	Description
match_id	int	joins to matches.parquet
profile_id	int	Relic player profile id
civ_id	int	game civilization id (incl. newest DLC civs)
civ	str	civ name, or null for ids not yet mapped
team	int	team index
won	bool	did this player win
old_rating / new_rating	int	rating before / after the match
rating_change	int	new − old
career_wins / career_losses / streak	int	player career counts at match time

Refresh & provenance

Refreshed daily, accumulating every game of the current patch (it resets when the next patch launches). The aggregate JSON updates each day; the raw Parquet dumps are a periodic snapshot.
Source: the Age of Empires II: DE community API (aoe-api.worldsedgelink.com). Match facts only.
Not included: in-game detail such as opening strategy or age-up timings (these aren't exposed by the match API).
Civilization names, icons and tech-tree data are Microsoft's, used under the Game Content Usage Rules. The match statistics themselves are facts, free for you to use.