British Canoeing Results

Race results for canoe and kayak races in the UK. The data are limited to marathon results and don’t include other event types like sprint. The majority of the races are part of the Hasler Series, which is the club championship.

Data were scraped from https://entries.gbcanoemarathon.co.uk/results/races and are published at https://datawookie.gitlab.io/british-canoeing-results/.

Data

These data files are available in the public/ directory:

results.json — compact JSON data dumped by crawler
results-indented.json — indented JSON data with some cleaning
results.csv — flattened CSV data.

For analytical purposes the CSV file might be most useful.

Data Dictionary

Column	Description	Type	Example
`date`	The date of the race (`YYYY-MM-DD`)	date	`2024-06-16`
`race`	The name of the race event	string	`Exe Hasler 2024`
`region`	The region where the race took place	string	`South West`
`category`	The race category (based on `division`)	string	`Div7`
`result_id`	Unique identifier for the result	integer	`125797`
`position`	The position in the race	integer	`7`
`name`	Full name of the participant	string	`Emma Riley`
`name_first`	First name of the participant	string	`Emma`
`name_last`	Last name of the participant	string	`Riley`
`club`	Abbreviated name of the participant’s club	string	`FOY`
`club_full`	Full name of the participant’s club	string	`Fowey River CC`
`class`	Short class code of the participant	string	`VFK`
`class_full`	Full description of the participant’s class	string	`Veteran Female Kayak`
`division`	Division of the participant	integer	`7`
`time`	Race completion time (`HH:MM:SS`)	string	`0:31:17`
`points`	Points awarded	integer	`44`

Notes:

Each boat has either one or two paddlers.
The result_id is not a unique row identifier. If there are two paddlers in a boat then there will be two entries with the same result_id.
The category field reflects the division of the paddler(s). This is a number from 1 (highest, elite) to 9 (lowest, beginner) that indicates skill level based on previous results. If there are two paddlers in a boat then the effective division is the average of their respective divisions, rounded down (towards lower numerical value).
The distance of Hasler races depend on division: ~12 miles (with portages) for divisions 1-3, ~8 miles (with portages) for divisions 4-6, and ~4 miles (without portages) for divisions 7-9.
Race distances are generally not measured with great precision and vary between venue and sometimes between years at the same venue.

These data are collected and curated by Andrew Collier (datawookie) [blog].