is stall_number field updated after being revised since 30th March 2011

Question

I understand the stall numbers have been revised as per the below release:

https://www.britishhorseracing.com/press_releases/revised-stalls-numbering-to-take-effect-from-wednesday-30th-march-2011/

Wondering whether this change is backdated in historic_races table i.e. is the stall_number field changed pre 30th March 2011?

Thanks in advance.

Answer 1

Hi - this question has been asked before, see below for a full answer:

https://answers.betwise.net/846/renumbering-of-stalls-and-historical-data

(Note that you can use the search bar in Betwise QA - a search on "stall number" brought this up)

The short answer is that Smartform contains the raw data, so is a matter of historical record, and this does not change despite stall numbering conventions changing.  So it would be incorrect for us to change it, though for analysis you would want to reverse the stall positions prior to 2011 on right handed courses, if included results prior to 2011 at right handed courses in any analysis of stall positions.  Note that no change is necessary for left handed courses.