Table 1.
Results of data editing of reported sales and purchases of cattle during the period between July 1st 2005 and June 30th 2006 in a dataset extracted from the Swedish database of cattle movements
n | Kept in dataset | Excluded from dataset | |
Total number of reports (sales and purchases) | 515572 | ||
Reports with perfect match | 414246 | x | |
Reports with different dates | 71158 | x | |
Non-matching holding reported by one of the farmers | 7 216 | x | |
Non-matching holding reported by one of the farmers, different dates reported but less than 7 days between reported dates | 2 918 | x | |
Reports without match, but where the location of the animal was correct according to the report | 14 434 | x | |
Reports also reported as slaughter or to or from pasture | 393 | x | |
Duplicates and triplicates | 709 | x | |
Inconsistent transport (e.g. animal reported to have left the same holding twice without returning in between) | 1 532 | x | |
Remaining, unexplainable reports | 2 975 | x |