Data exports

Match Play offers a handful of easy-to-access data exports. These provide large data sets without putting strain on the API. If the data you're seeking is available as an export, use the export rather than the API.

Some of these exports will generate CSV files you can import these into your spreadsheet software.

Export OPDB

The OPDB dataset is available in three different export formats. Each file is updated once per day.

Full dataset V2 format (easier to consume than V1):

https://mp-data.sfo3.cdn.digitaloceanspaces.com/opdb-v2.json

"Slim" dataset containing only machine/manufacturer name and the backglass image:

https://mp-data.sfo3.cdn.digitaloceanspaces.com/opdb-slim.json

Full dataset in the legacy V1 format (for backwards compatibility):

https://mp-data.sfo3.cdn.digitaloceanspaces.com/latest-opdb.json

Export PinTips

The entire PinTips dataset in a single JSON file (about 1MB):

https://mp-data.sfo3.cdn.digitaloceanspaces.com/latest-pintips.json

Export Match Play Ratings

The latest ratings for all players are available in a single CSV file (about 8MB):

https://mp-ratings.sfo3.cdn.digitaloceanspaces.com/latest-ratings.csv

Export Match Play Rating history

The rating history for all players for the past year available in a single CSV file (about 19MB). Please note that the file only contains rating changes. A players RD value changes daily, but those changes are not reflected in the file. If you need the RD for a specific data you must advance the RD yourself from the last rating period where the rating changed. The tournament-utils package includes a Glicko calculator which can perform that action through the advanceRD function (see Match Play Ratings for the system constants).

https://mp-ratings.sfo3.cdn.digitaloceanspaces.com/latest-rating-revisions.csv

Export players

Enter the following URL into your browser, replacing TOURNAMENT_ID with the numeric id for your tournament:

https://app.matchplay.events/api/tournaments/TOURNAMENT_ID/players/csv

Export single-player games

Enter the following URL into your browser, replacing TOURNAMENT_ID with the numeric id for your tournament:

https://app.matchplay.events/api/tournaments/TOURNAMENT_ID/single-player-games/csv

Export match play games

Enter the following URL into your browser, replacing TOURNAMENT_ID with the numeric id for your tournament:

https://app.matchplay.events/api/tournaments/TOURNAMENT_ID/games/csv

Export entries

Enter the following URL into your browser, replacing TOURNAMENT_ID with the numeric id for your tournament:

https://app.matchplay.events/api/tournaments/TOURNAMENT_ID/entries/csv