Skip to content
Season 2026/27

Premier League JSON dataset

JSON samples mirror workspace export shape: meta, columns, and rows. Download capped public samples here, then continue in Ask for custom datasets.

Live sample structure

Real capped payload (5 player rows). Public APIs max out at 200 rows.

{
  "meta": {
    "generatedAt": "2026-10-20T08:41:03.362Z",
    "season": "2026/27",
    "competition": "Premier League",
    "rowCount": 5,
    "columnCount": 11
  },
  "columns": [
    {
      "key": "player_name",
      "label": "Player",
      "type": "string"
    },
    {
      "key": "club",
      "label": "Club",
      "type": "string"
    },
    {
      "key": "position",
      "label": "Position",
      "type": "string"
    },
    {
      "key": "appearances",
      "label": "Appearances",
      "type": "number"
    },
    {
      "key": "starts",
      "label": "Starts",
      "type": "number"
    },
    {
      "key": "minutes",
      "label": "Minutes",
      "type": "number"
    },
    {
      "key": "goals",
      "label": "Goals",
      "type": "number"
    },
    {
      "key": "assists",
      "label": "Assists",
      "type": "number"
    },
    {
      "key": "xg",
      "label": "xG",
      "type": "number"
    },
    {
      "key": "xa",
      "label": "xA",
      "type": "number"
    },
    {
      "key": "clean_sheets",
      "label": "Clean sheets",
      "type": "number"
    }
  ],
  "rows": [
    {
      "player_name": "Charalampos Kostoulas",
      "club": "Brighton",
      "position": "Forward",
      "appearances": 7,
      "starts": 6,
      "minutes": 487,
      "goals": 3,
      "assists": 2,
      "xg": 1.83,
      "xa": 0.12,
      "clean_sheets": null
    },
    {
      "player_name": "Lewis Dunk",
      "club": "Brighton",
      "position": "Defender",
      "appearances": 6,
      "starts": 5,
      "minutes": 479,
      "goals": 1,
      "assists": null,
      "xg": 0.03,
      "xa": 0.1,
      "clean_sheets": 2
    },
    {
      "player_name": "Johan Manzambi",
      "club": "Aston Villa",
      "position": "Midfielder",
      "appearances": 4,
      "starts": 3,
      "minutes": 257,
      "goals": 2,
      "assists": 2,
      "xg": 1.42,
      "xa": 0.44,
      "clean_sheets": null
    },
    {
      "player_name": "Sidiki Cherif",
      "club": "Coventry",
      "position": "Forward",
      "appearances": 3,
      "starts": 2,
      "minutes": 168,
      "goals": 1,
      "assists": null,
      "xg": 0.35,
      "xa": 0.02,
      "clean_sheets": null
    },
    {
      "player_name": "Alysson",
      "club": "Aston Villa",
      "position": "Midfielder",
      "appearances": 6,
      "starts": 1,
      "minutes": 136,
      "goals": 1,
      "assists": null,
      "xg": 0.06,
      "xa": 0.02,
      "clean_sheets": null
    }
  ]
}

Developer use cases

  • Prototype dashboards against the same meta / columns / rows shape as workspace exports.
  • Validate parsers for player and match samples before wiring Ask queries for full extracts.
  • Deep-link analysts into Ask when they outgrow the public sample caps.

How this tool works

  1. Preview a live truncated players JSON payload built server-side.
  2. Download capped players or matches JSON from the public APIs.
  3. Ask / workspace export uses the same ExportService JSON layout at full query scale.

Related tools

Answerable questions

These examples use fields supported by CrunchClash's Premier League query catalog.

Need a custom JSON dataset?

Build it in Ask →

FAQ

What is in meta?

generatedAt, season label, competition, rowCount, and columnCount when available — never fabricated freshness.