title: Data quality in the Norwegian dairy herd recording system: agreement between the national database and disease recording on farm.
abstract: The majority of herds in Norway participate in the national dairy herd recording system. For disease events, this involves transferring information registered on farm, using individual cow health cards (CHC), to the central cattle database (CCD). Before using data from such a database, validation with an aim of describing data quality should be performed, but is rarely done. In this study, diagnostic events from CHC and CCD from 74 dairy herds were compared. Events in 2008 from female cattle with minimum age of 1 yr were included (n=1,738). Discrepancies between the 2 data sources and assessment of data quality were evaluated using agreement between events on CHC and in CCD, calculating completeness and correctness for the CCD, and using a multivariable regression model for agreement (1/0). The agreement evaluation described the concordance between the 2 data sources, whereas the calculations of completeness and correctness depended on a reference data source assumed to be more reliable. Completeness of the CCD was defined as the proportion of diagnostic events on the CHC that was recorded therein. Correctness was defined as the proportion of the CCD events that was also recorded on the CHC, and with the same date and diagnostic code. The agreement was up to 87.5%, the majority of disagreement being caused by unreported events on the CHC (between 10 and 12% of all events). Completeness of the CCD was regarded as high, between 0.87 and 0.88, and correctness excellent, between 0.97 and 0.98. The multivariable regression model found 4 factors that increased the odds for diagnostic events being in agreement between CHC and CCD. These were the events occurring during the 305-d lactation period; the herd size being 75 cows or less; the event occurring during the spring, summer, or winter rather than autumn; and lastly, the diagnostic code for the disease event being preprinted on the CHC, involving a simple check mark as opposed to writing a 3-digit code. The model found a high degree of clustering within herd. In conclusion, disease data in the Norwegian national database for dairy cows are valid to use for epidemiologic research, having in particular an excellent correctness, but it is of concern that at least 10% of data are missing. The proportion of unreported data should be taken into consideration whenever data from this database are used. Reasons for discrepancies found are important to be aware of in any work aiming to improve data transfer from farm to central databases.
authors: Norwegian School of Veterinary Science, Department of Production Animal Clinical Sciences, PO Box 8146 Dep., NO-0033 Oslo, Norway. Electronic address: mari.espetvedt@nvh.no.
authors: M N
authors: MN
authors: Espetvedt
authors: Norwegian School of Veterinary Science, Department of Production Animal Clinical Sciences, PO Box 8146 Dep., NO-0033 Oslo, Norway.
authors: O
authors: O
authors: Reksen
authors: University of Helsinki, Department of Veterinary Biosciences, PO Box 66, FI-00014 Helsinki, Finland.
authors: S
authors: S
authors: Rintakoski
authors: Norwegian School of Veterinary Science, Department of Production Animal Clinical Sciences, PO Box 8146 Dep., NO-0033 Oslo, Norway; TINE Extension Services, TINE SA, PO Box 58, 1431 Ås, Norway.
authors: O
authors: O
authors: Østerås
mesh_terms: D000818:Animals; D002417:Cattle; D002418:Cattle Diseases / Q000175:diagnosis / Q000453:epidemiology*; D003612:Dairying / Q000379:methods*; D003628:Database Management Systems / Q000706:statistics & numerical data; D005260:Female; D007774:Lactation; D009664:Norway; D015203:Reproducibility of Results; D012621:Seasons