This booklet was created on 2026-01-21 as a brief overview on the available data in Gigacow collected from the DelPro herd management software. Gigacow consist of a SQL database with prepared views which can be accessed through dbplyr if you have received a SLU approval and user account (contact Tomas Klingström at for further information). To see the code generating the booklet you can visit https://github.com/TKlingstrom/gigacow_exampledata and download the entire code repository. For more information please read the following article: https://doi.org/10.3920/978-90-8686-940-4_434

Number of cows

A Swedish cow is uniquely identifiable if it got a farmnumber (pseudonymized in Gigacow), an ear tag number and a birth year. Gigacow is built on three separate datasets (farm data, Kokontrollen data and NAV data) and these values must be used to connect individuals between the datasets.

## # A tibble: 15 × 3
##    FarmName_Pseudo nrGigacow_Cow nrAnimals
##    <chr>                   <int>     <int>
##  1 <NA>                        1         1
##  2 169e580a                 7068      7065
##  3 540275a1                 1730      1730
##  4 5b581702                  500       500
##  5 5c06d92d                 3263      3262
##  6 5f7f33d6                 2257      2257
##  7 6d38bc90                 2182      2182
##  8 752efd72                 2696      2696
##  9 a624fb9a                 1541      1541
## 10 a756bc39                 1652      1652
## 11 ab18b151                 1048      1048
## 12 ad0a39f5                 3301      3301
## 13 afdd9a78                  439       439
## 14 f454e660                 1915      1915
## 15 fced84e9                 1763      1763
Del_Cow_Id FarmName_Pseudo SE_Number AnimalNumber Gender Mother Father BreedName BirthWeight BirthDate CullDecisionDate CullReason1 CullReason2 DeathDate ArrivalDate Dissected DissectedDate ExitDate Carrier BreedPart1 BreedPart1. BreedPart2 BreedPart2. BreedPart3 BreedPart3. BreedPart4 BreedPart4. BornHerdNo TwinBorn SerialNo Supplier EntryWeight BornEarNo EntryWeighingDate SlaughterWeight Weaning WeaningDate ExitReason FirstCalvingNo CalvingAge OriginalSourceFiles
44 a624fb9a SE-ad0a39f5-3051 8460 NA SE-5f7f33d6-1049 9-4844 02 SLB NA 2021-03-10 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA \storage-ua.slu.se\(\FileArea\ImportArea\a624fb9a\GIGACOW_identity_20201011.csv </td> </tr> <tr> <td style="text-align:right;"> 80 </td> <td style="text-align:left;"> 5c06d92d </td> <td style="text-align:left;"> SE-5f7f33d6-1490 </td> <td style="text-align:right;"> 2572 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> SE-169e580a-5534 </td> <td style="text-align:left;"> Odd 3-7329 (Lim) </td> <td style="text-align:left;"> 02 SLB </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> 2021-02-01 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 11 Kastning </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> \\storage-ua.slu.se\Gigacow\)\169e580a_identity_v1_20231222.csv
45 ad0a39f5 SE-5f7f33d6-0870 992 NA SE-ad0a39f5-2861 9-7852 Luster 02 SLB NA 2016-07-25 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA \storage-ua.slu.se\(\FileArea\ImportArea\ad0a39f5\GIGACOW_identity_v1_20211202.csv;\\storage-ua.slu.se\Gigacow\)0a39f5_culled_v1_20231107.csv
37 ad0a39f5 SE-169e580a-6054 8383 NA SE-169e580a-5416 3-5125 Huttney 02 SLB NA 2020-11-20 2022-03-15 32 Såld till slakt NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA \storage-ua.slu.se\(\FileArea\ImportArea\5f7f33d6\GIGACOW_identity_v1_20230824.csv;\\storage-ua.slu.se\Gigacow\)\5f7f33d6_culled_v1_20250529.csv
53 169e580a SE-5c06d92d-9517 5621 NA SE-169e580a-3393 22-8359 01 SRB NA 2020-08-19 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA \storage-ua.slu.se\(\FileArea\ImportArea\169e580a\GIGACOW_identity_v1_20210205.csv;\\storage-ua.slu.se\Gigacow\)\169e580a_culled_v1_20240129.csv
91 a756bc39 SE-a756bc39-1410 1152 NA SE-752efd72-0425 9-3864 Brewmaster 02 SLB NA 2017-04-03 2025-02-11 32 Såld till slakt NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA \storage-ua.slu.se\(\FileArea\ImportArea\169e580a\GIGACOW_identity_v1_20230809.csv </td> </tr> <tr> <td style="text-align:right;"> 26 </td> <td style="text-align:left;"> ad0a39f5 </td> <td style="text-align:left;"> SE-a624fb9a-1439 </td> <td style="text-align:right;"> 3709 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> SE-169e580a-4712 </td> <td style="text-align:left;"> 9-4914 SILANI </td> <td style="text-align:left;"> 02 SLB </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> 2022-09-05 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 01 Såld till liv </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> \\storage-ua.slu.se\Gigacow\)\169e580a_identity_v1_20210205.csv;\storage-ua.slu.se\(\FileArea\ImportArea\169e580a\GIGACOW_culled_v1_20230905.csv </td> </tr> <tr> <td style="text-align:right;"> 99 </td> <td style="text-align:left;"> 169e580a </td> <td style="text-align:left;"> SE-a756bc39-0787 </td> <td style="text-align:right;"> 3029 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> SE-540275a1-1600 </td> <td style="text-align:left;"> Smooth 3-5066 </td> <td style="text-align:left;"> 01 SRB </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> 2019-03-18 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 01 Såld till liv </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> \\storage-ua.slu.se\Gigacow\)54e660_identity_20201020.csv;\storage-ua.slu.se\(\FileArea\ImportArea\f454e660\GIGACOW_culled_20240129.csv </td> </tr> <tr> <td style="text-align:right;"> 16 </td> <td style="text-align:left;"> 752efd72 </td> <td style="text-align:left;"> SE-5f7f33d6-1235 </td> <td style="text-align:right;"> 6280 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> SE-5c06d92d-2254 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 02 SLB </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> 2016-11-25 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 18 Svårmjölkad, exteriör </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> \\storage-ua.slu.se\Gigacow\)\169e580a_identity_v1_20221112.csv
35 ab18b151 SE-a624fb9a-1236 707 NA SE-5c06d92d-2870 22-7729 01 SRB NA 2017-09-22 NA 32 Slakt NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA \storage-ua.slu.se$\752efd72_identity_v1_20201127.csv

The Gigacow database currently contain 31352 cows recorded in the on-farm herd management system.

Milking data

Milking data in data comes from farms with milk robots or milk parlours. Milking robots provide more data than milk parlours but for convenience an aggregated table with total yield per milking event from all farms has been created.

## # A tibble: 14 × 3
##    FarmName_Pseudo nrMilkings nrAnimals
##    <chr>                <int>     <int>
##  1 169e580a            869958      1090
##  2 540275a1            315778       232
##  3 5b581702            158724       140
##  4 5c06d92d           1389838       714
##  5 5f7f33d6            632718       507
##  6 6d38bc90            267872       439
##  7 752efd72           1242507       735
##  8 a624fb9a            578770       276
##  9 a756bc39            444466       323
## 10 ab18b151            308466       201
## 11 ad0a39f5            517188       482
## 12 afdd9a78             46301        68
## 13 f454e660            512572       368
## 14 fced84e9            420522       359
Del_Cow_Id FarmName_Pseudo SE_Number AnimalNumber StartDate StartTime LactationNumber DaysInMilk LactationInfoSource SessionNumber TotalYield OriginalFileSource dwh_factCowMilk_Id dwh_factCowMilkParlour_Id dwh_factCowMilkOther_Id
13147 752efd72 SE-752efd72-0450 5898 2023-12-05 NA 4 171 MilkFile 1 7.8133 752efd72_milking_v5_20250907.csv NA 15228 NA
11852 752efd72 SE-752efd72-0246 6325 2024-07-08 NA 4 101 MilkFile 3 9.9667 752efd72_milking_v5_20240522.csv NA 32267 NA
13596 169e580a SE-752efd72-0325 5457 2025-04-19 NA 1 44 MilkFile 2 12.1550 752efd72_milking_v5_20231002.csv NA 29824 NA
10513 169e580a SE-752efd72-0170 278 2023-04-25 NA 3 171 MilkFile 1 17.4400 169e580a_milking_v5_20250220.csv NA 3177 NA
10513 169e580a SE-752efd72-0441 6386 2025-07-12 NA 2 8 MilkFile 2 12.1050 169e580a_milking_v5_20250207.csv NA 24171 NA
79 169e580a SE-752efd72-0419 6278 2023-08-30 NA 4 271 MilkFile 3 5.9850 169e580a_milking_v5_20250718.csv NA 19306 NA
2919 169e580a SE-169e580a-6546 218 2025-07-24 NA 1 201 MilkFile 1 13.1133 169e580a_milking_v5_20250707.csv NA 37354 NA
2808 169e580a SE-752efd72-0172 5331 2025-09-06 NA 2 42 MilkFile 3 11.7000 169e580a_milking_v5_20250713.csv NA 25383 NA
6123 752efd72 SE-752efd72-0491 5825 2023-07-25 NA 2 44 MilkFile 2 16.2067 169e580a_milking_v5_20250926.csv NA 43849 NA
2329 752efd72 SE-752efd72-0402 439 2024-12-09 NA 3 208 MilkFile 2 12.7250 752efd72_milking_v5_20241205.csv NA 19702 NA

The Gigacow database currently contain 7705680 milking events from 5934 animals.

Robot milkings

## # A tibble: 8 × 3
##   FarmName_Pseudo nrMilkings nrAnimals
##   <chr>                <int>     <int>
## 1 afdd9a78             46301        68
## 2 ab18b151            308466       201
## 3 5f7f33d6            632718       507
## 4 fced84e9            420522       359
## 5 540275a1            315778       232
## 6 a624fb9a            578770       276
## 7 5b581702            158724       140
## 8 f454e660            512572       368
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id GroupName MilkingStartDateTime SessionNumber EquipmentName TotalYieldLF TotalYieldRF TotalYieldLR TotalYieldRR TotalYield KickOffLF KickOffLR KickOffRF KickOffRR IncompleteLF IncompleteLR IncompleteRF IncompleteRR NotMilkedTeatLF NotMilkedTeatLR NotMilkedTeatRF NotMilkedTeatRR AMD_Udder AMD_TeatLF AMD_TeatLR AMD_TeatRF AMD_TeatRR AverageFlowLF AverageFlowLR AverageFlowRF AverageFlowRR PeakFlowLF PeakFlowLR PeakFlowRF PeakFlowRR BloodLF BloodLR BloodRF BloodRR ConductivityLF ConductivityLR ConductivityRF ConductivityRR Occ MilkingUnitNumber MilkingUnitName Action Various_User Various_MilkDestination Various_ReasonForMilkSeperation OriginalFileSource dwh_factCowMilk_Id
5f7f33d6 SE-f454e660-685 592 8301 VMS 1 2023-09-30 12:12:00 1 MS2 3.90 2.83 3.33 2.19 8.85 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.54 1.38 1.56 1.20 1.68 1.44 1.98 1.98 0 0 0 1135 5.31 3.36 3.91 NA NA NA MS3 Mjölkning NA Mjölktank NA f454e660_milking_v2_20231124.csv 14586
a624fb9a SE-5f7f33d6-0716 -1 3868 Vms kor 2023-05-17 04:05:00 4 MS2 2.55 2.47 2.54 3.78 11.66 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 1.08 1.02 0.96 1.50 1.80 2.70 0.66 1.80 0 0 0 0 4.64 5.92 5.10 4.70 NA NA MS3 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20240105.csv 16006
5f7f33d6 SE-5f7f33d6-0850 1023 6833 VMS 1 2023-09-18 10:06:00 2 MS1 5.43 4.88 4.22 2.34 11.88 NA NA NA NA NA NA NA NA NA NA NA NA 0 Y NA NA NA 1.20 0.96 0.90 0.84 1.26 1.44 1.92 0.48 0 0 0 0 4.00 4.73 4.55 4.18 NA NA Vms 1 Mjölkning NA Mjölktank NA f454e660_milking_v2_20230705.csv 15258
5f7f33d6 SE-a624fb9a-1405 1394 7568 Vms kor 2023-06-19 08:07:00 2 MS5 2.62 3.22 1.55 1.78 13.94 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.78 0.96 1.92 1.08 1.86 1.62 1.56 1.26 413 0 0 0 4.49 4.03 3.97 4.19 NA NA MS1 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20231103.csv 15798
5f7f33d6 SE-5f7f33d6-1332 1478 1079 Vmskor 2023-05-14 09:09:00 1 MS3 3.31 5.85 3.71 6.82 9.46 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA Y 0.84 0.42 0.96 0.66 1.02 1.38 1.14 1.50 0 0 0 309 4.49 4.02 4.55 4.16 NA NA Vms 1 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20240113.csv 15856
5f7f33d6 SE-5f7f33d6-1212 1341 4612 Vmskor 2023-10-02 19:05:00 3 MS4 2.97 3.57 0.00 3.35 10.57 NA NA NA NA NA NA NA NA NA NA NA NA 1 NA NA NA NA 0.84 0.72 0.60 0.78 NA 1.62 1.56 1.32 NA 0 0 0 4.38 3.92 4.38 3.91 725 NA vms 2 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20230914.csv 14965
5b581702 SE-f454e660-291 735 421 Vms kor 2023-06-11 20:30:00 3 MS2 2.51 2.84 2.33 3.59 7.99 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA Y NA NA 0.84 0.66 1.02 0.96 2.46 1.14 1.14 0.72 0 0 815 0 0.00 4.00 4.29 4.18 NA NA Vms 1 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20230615.csv 16158
5f7f33d6 SE-a624fb9a-1383 2016 4322 Vms kor 2024-01-02 01:00:00 3 MS2 1.55 0.85 1.79 3.26 14.08 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 1.08 1.44 0.54 0.78 1.44 1.38 1.26 1.56 0 0 510 0 4.42 3.79 3.98 4.47 NA NA MS3 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20230712.csv 14260
a624fb9a SE-f454e660-516 795 3866 Vms kor (144 platser) 2023-05-02 21:03:00 1 MS2 2.46 2.05 2.53 3.80 12.04 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.84 1.08 0.48 1.38 1.56 1.62 1.02 1.38 0 0 0 6245 4.05 4.43 3.91 3.37 NA NA MS3 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20231023.csv 14860
5b581702 SE-5f7f33d6-0797 1179 5767 Vmskor 2023-06-15 21:11:00 1 MS1 1.16 4.65 4.98 5.64 17.85 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 1.62 1.08 1.32 0.48 1.56 1.26 1.86 1.50 3499 0 0 422 NA 4.55 4.91 4.03 NA NA MS1 Mjölkning NA Mjölktank NA 5b581702_milking_v2_20230503.csv 16080

The Gigacow database currently contain 2973851 milkings from 2151 animals in farms with milking robots.

Parlour milkings

## # A tibble: 3 × 3
##   FarmName_Pseudo nrMilkings nrAnimals
##   <chr>                <int>     <int>
## 1 a756bc39              1789       102
## 2 5c06d92d           1331677       714
## 3 ad0a39f5            517188       482
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id AnimalName GroupNumber LactationNumber DaysInMilk MilkingDate SessionNumber SessionDuration_sec SessionAverageFlow Yield SessionPeakFlow MilkingBeginTime MilkingEndTime ThisSessionNumberSevenDayAverageDuration_sec ThisSessionNumberSevenDayAverageFlow MPCNumber ParlorName ParlorNumber BatchNumber IdentificationTime RelativeYield_Percent YieldFirstTwoMinutes ECMYield LowYield SecondLap LactationInfoSource OriginalFileSource dwh_factCowMilkOther_Id
5c06d92d SE-5c06d92d-3533 2577 6400 NA 2 4 336 2024-09-21 2 248 NA 9.25 NA 07:27:00 23:04:00 NA NA 14 Stall 1 1 20 13:09:00 94 3.07 13.69 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20240320.csv 5421
5c06d92d SE-5c06d92d-3317 3365 479 NA 3 3 132 2025-03-17 3 338 NA 12.61 NA 07:23:00 09:08:00 NA NA 22 Stall 1 1 6 12:57:00 111 3.88 NA Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20251023.csv 5416
5c06d92d SE-5c06d92d-3187 3432 3338 NA 2 3 337 2023-05-25 1 371 NA 10.79 NA 07:20:00 07:20:00 NA NA 13 Stall 1 1 14 08:17:00 101 9.67 23.05 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20230711.csv 5270
5c06d92d SE-5c06d92d-3471 2536 4111 NA 2 2 246 2024-10-01 1 421 NA 7.78 NA 12:48:00 19:20:00 NA NA 2 Stall 1 1 NA 07:12:00 100 6.54 21.58 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20240918.csv 5405
5c06d92d SE-5c06d92d-3309 3270 844 NA 3 5 26 2024-09-13 2 241 NA 13.42 NA 06:13:00 14:21:00 NA NA 8 Stall 1 1 7 13:43:00 107 4.75 17.06 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20230719.csv 5234
5c06d92d SE-5c06d92d-3402 3463 3781 NA 1 2 219 2025-10-18 1 703 NA 9.48 NA 21:52:00 21:56:00 NA NA 6 Stall 1 1 3 08:57:00 101 4.57 16.33 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20231013.csv 5263
5c06d92d SE-5c06d92d-3499 3467 4889 NA 4 1 281 2025-05-06 3 299 NA 18.02 NA 07:41:00 06:39:00 NA NA 26 Stall 1 1 18 13:46:00 97 7.10 17.03 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20241213.csv 5266
5c06d92d SE-5c06d92d-3710 2690 6382 NA 3 1 273 2025-08-05 2 458 NA 11.46 NA 06:04:00 21:15:00 NA NA 2 Stall 1 1 16 17:53:00 106 5.57 13.77 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20240521.csv 5349
5c06d92d SE-5c06d92d-3294 3837 12436 NA 1 2 173 2024-10-08 3 377 NA 20.97 NA 15:58:00 08:02:00 NA NA 3 Stall 1 1 10 08:34:00 98 3.50 22.26 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20240117.csv 5268
5c06d92d SE-5c06d92d-2268 3664 2804 NA 3 1 136 2024-05-01 1 312 NA 11.15 NA 07:51:00 13:59:00 NA NA 6 Stall 1 1 19 06:38:00 99 10.28 10.65 Unchecked Unchecked MilkFile 5c06d92d_milking_v4_20240918.csv 5383

The Gigacow database currently contain 1850654 milkings from 1298 animals in farms with milking parlours.

Activity data

DeLaval activity sensors are facing serious competition from other providers such as SenseHub and Växa Control (Nedap). Växa recently switched from being a distributor of SenseHub to selling “Växa Contol” which is provided by the sensor manufacturer Nedap. SenseHub and Nedap are both recognised as highly reliable for heat detection and more advanced subscriptions can also include health monitoring, feeding behaviour and even position tracking. Currently DeLaval activity sensors are the only ones available in Gigacow.

## # A tibble: 9 × 3
##   FarmName_Pseudo nrActivity nrAnimals
##   <chr>                <int>     <int>
## 1 fced84e9               505         9
## 2 540275a1            178599       415
## 3 a624fb9a            222222       331
## 4 752efd72            153624       754
## 5 ad0a39f5            178131       485
## 6 ab18b151             25658       161
## 7 f454e660             68444       420
## 8 169e580a            239908      1257
## 9 a756bc39              1262         1
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id SourceFileDateTime AverageActivityLast24Hours RelativeActivity_InPercent HighActivityStartHour HighActivityLevel GeneralHighActivityProbability_InPercent HighActivityTimeLast24Hours HoursSinceSendingActivity HoursSinceHighActivity IsHighActivityToday IsHighActivityYesterday LowActivity GeneralLowActivityProbability_InPercent OriginalFileSource dwh_factCowActivity_Id
169e580a SE-a624fb9a-1322 401 4166 2023-12-28 00:00:00 113 99 NA Unknown 68 NA 1 NA Unchecked Unchecked Unchecked 26 752efd72_activity_v1_20240127.csv 620
752efd72 SE-169e580a-6246 586 7158 2023-06-30 00:00:00 62 88 NA (+) 61 NA 1 NA Unchecked Unchecked Unchecked 51 169e580a_activity_v1_20231005.csv 414
752efd72 SE-752efd72-0281 1433 7740 2023-06-28 00:00:00 99 87 NA Unknown 51 NA 1 NA Unchecked Unchecked Unchecked 62 752efd72_activity_v1_20230703.csv 301
169e580a SE-169e580a-6335 1482 9551 2023-09-07 00:00:00 57 98 NA Unknown 89 2023-09-10 09:00:00 1 NA Unchecked Unchecked Unchecked 55 a624fb9a_activity_v1_20230926.csv 330
752efd72 SE-752efd72-0490 574 775 2023-09-26 00:00:00 51 95 NA (++) 29 NA NA NA Unchecked Unchecked Unchecked 28 169e580a_activity_v1_20230717.csv 156
169e580a SE-752efd72-0281 6246 223 2023-05-16 00:00:00 11 96 NA Unknown 46 NA 2 NA Unchecked Unchecked Unchecked 34 a624fb9a_activity_v1_20230809.csv 14
f454e660 SE-a624fb9a-1212 627 13636 2023-12-30 00:00:00 54 100 NA Unknown 48 NA 2 NA Unchecked Unchecked Unchecked 50 169e580a_activity_v1_20240127.csv 528
752efd72 SE-169e580a-5986 1433 9737 2023-07-21 00:00:00 43 109 NA Unknown 47 NA NA NA Unchecked Unchecked Unchecked 50 169e580a_activity_v1_20231031.csv 286
169e580a SE-a624fb9a-1303 1565 10691 2023-09-10 00:00:00 30 100 NA ++ 24 NA 1 NA Unchecked Unchecked Unchecked 54 752efd72_activity_v1_20231020.csv 550
a624fb9a SE-169e580a-6231 489 704 2023-12-11 00:00:00 48 111 NA Unknown 64 NA 1 NA Unchecked Unchecked Unchecked 45 752efd72_activity_v1_20231211.csv 510

The Gigacow database currently contain 1068353 activity measurements from 3833 animals in farms participating in Gigacow.

Feed data

A new feed report is soon coming online but this is the currently available data.

## # A tibble: 11 × 3
##    FarmName_Pseudo  nrFeed nrAnimals
##    <chr>             <int>     <int>
##  1 afdd9a78          25741        69
##  2 a756bc39        3204934      1412
##  3 a624fb9a         854904       307
##  4 5f7f33d6        1173160      1282
##  5 540275a1         720516       669
##  6 ad0a39f5        1179808      1170
##  7 6d38bc90         762065       994
##  8 5b581702         382249       177
##  9 f454e660         796323       670
## 10 169e580a         135820      1042
## 11 ab18b151         269083       203
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id FeedDate FeedName FeedRation FeedConsumedPercent OriginalFileSource dwh_factCowFeed_Id
f454e660 SE-a624fb9a-1376 2430 5569 2023-04-20 Feed5 0.00 85 f454e660_feed_20230421.csv 3047950
a624fb9a SE-f454e660-338 1266 10825 2023-04-20 Feed4 6.00 0 a624fb9a_feed_v1_20230421.csv 3047937
a624fb9a SE-f454e660-407 412 2423 2023-04-20 Feed5 3.52 113 a624fb9a_feed_v1_20230421.csv 3047924
f454e660 SE-a624fb9a-1411 139 602 2023-04-20 Feed5 4.65 89 a624fb9a_feed_v1_20230421.csv 3047954
f454e660 SE-a624fb9a-1439 1439 2928 2023-04-20 Feed5 0.00 94 f454e660_feed_20230421.csv 3048516
f454e660 SE-f454e660-2430 2398 2992 2023-04-20 Feed4 2.35 101 a624fb9a_feed_v1_20230421.csv 3048486
f454e660 SE-a624fb9a-1261 1351 193 2023-04-20 Feed4 5.50 98 a624fb9a_feed_v1_20230421.csv 3047910
f454e660 SE-f454e660-548 742 9943 2023-04-20 Feed4 6.23 0 f454e660_feed_20230421.csv 3048513
a624fb9a SE-f454e660-412 548 5783 2023-04-20 Feed5 4.65 119 f454e660_feed_20230421.csv 3047956
a624fb9a SE-a624fb9a-1449 516 7476 2023-04-20 Feed4 4.64 50 f454e660_feed_20230421.csv 3047912

The Gigacow database currently contain 9504603 Feed day records from 7995 animals in farms participating in Gigacow.

Body Conditions Score data

DeLaval BCS cameras for Body Condition Scoring are available on some farms.

## # A tibble: 4 × 3
##   FarmName_Pseudo  nrBCS nrAnimals
##   <chr>            <int>     <int>
## 1 540275a1            26        26
## 2 fced84e9         60787       351
## 3 afdd9a78            50        49
## 4 5c06d92d        393580       714
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id BCSEventDate BCSValue OriginalFileSource dwh_factCowHealth_Id
5c06d92d SE-5c06d92d-3299 3010 182 2023-04-24 3.29 5c06d92d_events_v1_20240103.csv 21
5c06d92d SE-5c06d92d-3485 2457 7100 2023-07-01 3.39 5c06d92d_events_v1_20230529.csv 143
5c06d92d SE-5c06d92d-2639 2741 4640 2023-08-23 3.44 5c06d92d_events_v1_20230715.csv 162
5c06d92d SE-5c06d92d-3222 3065 1346 2023-11-23 3.64 5c06d92d_events_v1_20230711.csv 202
5c06d92d SE-5c06d92d-3076 3542 12548 2023-12-04 3.16 5c06d92d_events_v1_20230927.csv 247
5c06d92d SE-5c06d92d-3432 3534 2157 2023-10-01 3.07 5c06d92d_events_v1_20230711.csv 233
5c06d92d SE-5c06d92d-3417 2748 6917 2023-09-27 3.40 5c06d92d_events_v1_20231225.csv 179
5c06d92d SE-5c06d92d-3048 2778 5147 2023-12-02 3.17 5c06d92d_events_v1_20230425.csv 78
5c06d92d SE-5c06d92d-3338 3438 2520 2023-06-19 3.40 5c06d92d_events_v1_20231229.csv 177
5c06d92d SE-5c06d92d-2904 3482 2567 2024-01-18 3.25 5c06d92d_events_v1_20231110.csv 205

The Gigacow database currently contain 454443 BCS day records from 1140 animals in farms participating in Gigacow.

Health Diagnosis and treatments

Health Diagnosis and treatments can be logged in multiple systems including paper-based ones, Jordbruksverkets database and the on-farm herd management system. This is the data recorded in the DelPro.

## # A tibble: 10 × 3
##    FarmName_Pseudo nrHealth_DiagnosisTreatment nrAnimals
##    <chr>                                 <int>     <int>
##  1 ab18b151                                616       355
##  2 5f7f33d6                                500       386
##  3 a624fb9a                                 67        52
##  4 540275a1                                777       480
##  5 5b581702                                 88        58
##  6 f454e660                               1730       832
##  7 169e580a                              29160      4670
##  8 ad0a39f5                                  4         4
##  9 afdd9a78                                 68        57
## 10 5c06d92d                               9464       798
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id HealthEventDate DiagnosisName TreatmentName OriginalFileSource dwh_factCowHealth_Id
5c06d92d SE-169e580a-5210 5619 3064 2023-11-09 NA Penicillin 5f7f33d6_events_v1_20230428.csv 5070
169e580a SE-5c06d92d-3485 3065 10171 2020-10-21 Avmaskning Dectomax 5 mg/ml 169e580a_events_v1_20231114.csv 5059
169e580a SE-5c06d92d-3039 966 9949 2022-03-04 Boviseal Bedövad avhorning 169e580a_events_v1_20230516.csv 5029
169e580a SE-169e580a-0738 4615 6773 2022-03-04 Ketosis mild Juvertuber Benestermycin 169e580a_events_v1_20210610.csv 5022
169e580a SE-f454e660-835 5657 6918 2020-07-27 NA Bovi/Intraseal 5c06d92d_events_v1_20230306.csv 5011
169e580a SE-169e580a-6459 4712 8509 2021-03-28 NA Utan horn 169e580a_events_v1_20230524.csv 5101
5c06d92d SE-169e580a-6337 1212 2780 2023-05-19 Sintidsbeh systamex 6 169e580a_events_v1_20210728.csv 5062
169e580a SE-5c06d92d-2639 1372 12609 2023-06-01 NA Noromectin 169e580a_events_v1_20210426.csv 5030
5c06d92d SE-5c06d92d-2501 4682 7358 2021-04-26 Boviseal Bovalto RS-vaccin 2 ml 169e580a_events_v1_20231123.csv 5039
169e580a SE-ab18b151-1552 4821 12640 2021-08-30 Boviseal Dectomax 169e580a_events_v1_20220320.csv 5106

The Gigacow database currently contain 42474 entries of health events in Gigacow from 7692 animals in farms participating in Gigacow.

Reproduction_Abortion_DataView data

This is the data on abortions recorded in Gigacow

## # A tibble: 12 × 3
##    FarmName_Pseudo nrReproduction_Abortion nrAnimals
##    <chr>                             <int>     <int>
##  1 169e580a                            239       228
##  2 540275a1                             55        50
##  3 5b581702                             10        10
##  4 5c06d92d                             72        69
##  5 5f7f33d6                             26        25
##  6 752efd72                             23        22
##  7 a624fb9a                             16        14
##  8 a756bc39                             20        19
##  9 ab18b151                             26        25
## 10 ad0a39f5                             19        19
## 11 afdd9a78                              3         2
## 12 f454e660                             33        32
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id AbortionDate OriginalFileSource dwh_factCowReproduction_Id
5c06d92d SE-540275a1-1345 5122 13507 2023-01-19 169e580a_events_v1_20221018.csv 11091268
169e580a SE-169e580a-4623 3488 323 2022-07-18 540275a1_events_v1_20251108.csv 11091113
5c06d92d SE-169e580a-5836 2852 1332 2025-03-17 540275a1_events_v1_20250709.csv 11090975
169e580a SE-169e580a-6120 1363 8145 2022-07-27 5c06d92d_events_v1_20250318.csv 14122231
169e580a SE-540275a1-1286 777 12025 2022-05-03 169e580a_events_v1_20231228.csv 13702341
169e580a SE-169e580a-6067 1267 45 2023-11-30 169e580a_events_v1_20240925.csv 14122232
169e580a SE-5c06d92d-2333 4840 543 2023-06-28 169e580a_events_v1_20240105.csv 11091039
5f7f33d6 SE-169e580a-5093 3171 4762 2022-06-17 169e580a_events_v1_20230918.csv 11091025
5c06d92d SE-5b581702-1752 3039 8960 2023-06-14 169e580a_events_v1_20231021.csv 11417643
169e580a SE-5c06d92d-3039 2012 38272 2024-07-13 169e580a_events_v1_20230406.csv 11090943

The Gigacow database currently contain 542 abortions from 515 animals in farms participating in Gigacow.

Calving data

These are the calving events recorded in Gigacow

## # A tibble: 12 × 3
##    FarmName_Pseudo nrReproduction_Calving nrAnimals
##    <chr>                            <int>     <int>
##  1 a756bc39                           672       314
##  2 afdd9a78                            83        66
##  3 5f7f33d6                           618       394
##  4 ab18b151                           346       200
##  5 540275a1                           718       358
##  6 f454e660                           913       484
##  7 169e580a                          4057      1944
##  8 ad0a39f5                          1236       794
##  9 a624fb9a                           614       209
## 10 752efd72                           940       494
## 11 5b581702                           457       171
## 12 5c06d92d                          1761       713
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id CalvingDate CalvingEase CalvingSireBullID OriginalFileSource dwh_factCowReproduction_Id
ad0a39f5 SE-5c06d92d-3565 4623 13578 2023-08-18 11 Easy, without assistance 9-4825 kelvin 169e580a_events_v1_20230725.csv 11097195
169e580a SE-169e580a-5134 1497 19523 2022-07-18 11 Easy, without assistance 9-8498 Bonds f454e660_events_20231003.csv 11093179
ad0a39f5 SE-5f7f33d6-0864 922 13018 2022-12-16 11 Easy, without assistance 9-8560 Hashtag ad0a39f5_events_v1_20220727.csv 11097018
5c06d92d SE-5f7f33d6-0577 28 5411 2023-08-09 11 Easy, without assistance Odd 3-7329 (Lim) f454e660_events_20231003.csv 11092687
169e580a SE-a756bc39-1184 5116 9032 2023-05-11 11 Easy, without assistance Odd 3-7329 (Lim) 169e580a_events_v1_20220710.csv 11092652
a624fb9a SE-f454e660-506 4985 11410 2023-05-06 11 Easy, without assistance 3-5170 Swish a756bc39_events_v1_20220804.csv 11097087
752efd72 SE-d29a722f-1497 577 2164 2022-06-13 11 Easy, without assistance 9-4834 afdd9a78_events_v1_20221104.csv 11097114
5c06d92d SE-169e580a-5404 1192 3088 2022-08-27 11 Easy, without assistance 9-4917 SAGE PP 5b581702_events_v1_20230322.csv 11097060
169e580a SE-5c06d92d-3313 5617 8930 2022-09-09 11 Easy, without assistance 9-8657 Amen-PP 169e580a_events_v1_20220427.csv 11092795
169e580a SE-f454e660-0277 3565 3238 2022-07-24 11 Easy, without assistance 9-4929 5f7f33d6_events_v1_20230811.csv 11093101

The Gigacow database currently contain 12415 Reproduction_Calving records from 6141 animals in farms participating in Gigacow.

DryOff data

These are the Dry off events recorded in Gigacow

## # A tibble: 12 × 3
##    FarmName_Pseudo nrReproduction_DryOff nrAnimals
##    <chr>                           <int>     <int>
##  1 afdd9a78                           27        27
##  2 5f7f33d6                          282       220
##  3 ab18b151                          160       118
##  4 a756bc39                          380       208
##  5 540275a1                          340       220
##  6 ad0a39f5                          407       335
##  7 752efd72                          501       308
##  8 a624fb9a                          318       154
##  9 5b581702                          247       123
## 10 5c06d92d                         1133       536
## 11 169e580a                         2225      1339
## 12 f454e660                          473       305
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id DryOffDate OriginalFileSource dwh_factCowReproduction_Id
169e580a SE-169e580a-4704 4801 595 2022-09-21 5c06d92d_events_v1_20230928.csv 11086429
169e580a SE-169e580a-3667 5417 6917 2023-11-16 169e580a_events_v1_20230818.csv 11086488
169e580a SE-752efd72-0409 1854 1798 2023-03-02 169e580a_events_v1_20230512.csv 11086522
169e580a SE-27c3257a-1492 5509 829 2023-06-08 ab18b151_events_v1_20220530.csv 11086510
5c06d92d SE-f454e660-269 4970 10106 2022-10-26 5c06d92d_events_v1_20221110.csv 11086475
169e580a SE-169e580a-4462 724 5015 2023-03-23 ad0a39f5_events_v1_20220910.csv 11086442
5b581702 SE-5c06d92d-2756 3329 1769 2023-07-06 f454e660_events_20230926.csv 11086463
169e580a SE-5c06d92d-2870 1029 11216 2022-09-09 169e580a_events_v1_20220723.csv 11086388
a756bc39 SE-169e580a-4811 3737 7481 2022-07-22 169e580a_events_v1_20230217.csv 11086517
5b581702 SE-5c06d92d-3129 2750 8155 2023-07-27 5f7f33d6_events_v1_20231117.csv 11086465

The Gigacow database currently contain 6493 Reproduction_DryOff records from 3893 animals in farms participating in Gigacow.

Insemination data

These are the Insemination events recorded in Gigacow

## # A tibble: 12 × 3
##    FarmName_Pseudo nrReproduction_Insemination nrAnimals
##    <chr>                                 <int>     <int>
##  1 5f7f33d6                               1251       462
##  2 f454e660                               1614       575
##  3 169e580a                               9210      2298
##  4 afdd9a78                                121        87
##  5 a624fb9a                                964       240
##  6 752efd72                               1761       531
##  7 ad0a39f5                               1397       726
##  8 5b581702                                970       215
##  9 5c06d92d                               3311       855
## 10 a756bc39                               1091       300
## 11 540275a1                               1323       405
## 12 ab18b151                                623       280
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id InseminationDate Breeder OriginalFileSource dwh_factCowReproduction_Id
5c06d92d SE-169e580a-5457 1230 5834 2023-03-24 8531 5f7f33d6_events_v1_20230512.csv 11069151
169e580a SE-5f7f33d6-1513 1281 6042 2023-08-10 6145 169e580a_events_v1_20231010.csv 11069088
169e580a SE-f1d3c667-1092 6265 1651 2022-07-12 1412 169e580a_events_v1_20220924.csv 11068980
169e580a SE-169e580a-5594 1338 10319 2023-03-29 8531 5c06d92d_events_v1_20221225.csv 11069156
169e580a SE-5f7f33d6-1516 5237 5547 2022-06-15 4409 a756bc39_events_v1_20230617.csv 11069031
5c06d92d SE-752efd72-0514 5672 405 2022-11-20 8536 169e580a_events_v1_20221110.csv 11069127
169e580a SE-5f7f33d6-1294 6064 8400 2023-08-27 8536 5c06d92d_events_v1_20220816.csv 11069137
169e580a SE-a624fb9a-1373 5847 11984 2023-10-09 8536 169e580a_events_v1_20230428.csv 11069158
169e580a SE-5f7f33d6-0835 1394 5707 2022-09-07 8948 169e580a_events_v1_20230204.csv 11069073
752efd72 SE-5b581702-1760 5747 87 2023-03-31 9068 169e580a_events_v1_20230904.csv 11069132

The Gigacow database currently contain 23636 insemination records from 6974 animals in farms participating in Gigacow.

Lactation data

These are the Lactation days recorded in Gigacow

## # A tibble: 12 × 3
##    FarmName_Pseudo nrReproduction_Lactation nrAnimals
##    <chr>                              <int>     <int>
##  1 afdd9a78                            8559        66
##  2 a756bc39                          198795       332
##  3 5f7f33d6                          125700       394
##  4 ab18b151                           73246       201
##  5 f454e660                          233606       487
##  6 169e580a                         1075951      1944
##  7 540275a1                          145085       363
##  8 ad0a39f5                          276623       794
##  9 a624fb9a                          138292       209
## 10 752efd72                          238696       494
## 11 5b581702                          123179       173
## 12 5c06d92d                          466691       713
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id LactationInfoDate LactationNumber DaysInMilk OriginalFileSource dwh_factCowReproduction_Id
169e580a SE-ad0a39f5-2678 2862 11313 2023-01-10 2 94 169e580a_events_v1_20230714.csv 8851622
a756bc39 SE-5c06d92d-2787 5151 10401 2023-12-30 4 305 752efd72_events_v1_20221219.csv 8851740
169e580a SE-5f7f33d6-1282 4960 9490 2023-03-28 2 327 5c06d92d_events_v1_20220903.csv 8851708
a756bc39 SE-169e580a-5635 5622 12687 2022-05-16 1 140 169e580a_events_v1_20230730.csv 8851773
5c06d92d SE-5c06d92d-2689 4907 12396 2023-01-27 2 256 a624fb9a_events_v1_20220613.csv 8851756
169e580a SE-ad0a39f5-2750 539 6554 2022-07-04 2 84 169e580a_events_v1_20230308.csv 8851711
5c06d92d SE-a756bc39-1043 4540 7642 2023-10-11 2 202 169e580a_events_v1_20220701.csv 8851735
ad0a39f5 SE-169e580a-4907 3347 176 2022-08-11 4 41 169e580a_events_v1_20231227.csv 8851656
169e580a SE-ab18b151-0856 1207 10134 2023-02-11 2 19 f454e660_events_20230129.csv 8851626
a624fb9a SE-169e580a-4654 5546 5039 2022-12-02 1 647 5c06d92d_events_v1_20231011.csv 8851668

The Gigacow database currently contain 3104423 lactation days with associated lactation numbers from 6170 animals in farms participating in Gigacow.

PregnancyCheck data

These are the PregnancyCheck events recorded in Gigacow

## # A tibble: 12 × 3
##    FarmName_Pseudo nrReproduction_PregnancyCheck nrAnimals
##    <chr>                                   <int>     <int>
##  1 a756bc39                                  599       263
##  2 afdd9a78                                   74        74
##  3 5f7f33d6                                  665       439
##  4 540275a1                                  698       364
##  5 f454e660                                 1082       562
##  6 169e580a                                 7629      2214
##  7 ab18b151                                  417       274
##  8 a624fb9a                                  611       236
##  9 752efd72                                 1072       512
## 10 ad0a39f5                                  892       636
## 11 5b581702                                  763       206
## 12 5c06d92d                                 2614       819
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id PregnancyCheckDate PregnancyCheckResult OriginalFileSource dwh_factCowReproduction_Id
169e580a SE-ad0a39f5-2816 5577 13304 2022-10-25 Positive 169e580a_events_v1_20221119.csv 11100717
169e580a SE-5c06d92d-3317 499 615 2023-12-25 Negative 169e580a_events_v1_20230617.csv 11100753
ad0a39f5 SE-a624fb9a-1348 4177 5740 2022-04-29 Positive afdd9a78_events_v1_20221230.csv 11100695
a624fb9a SE-f454e660-849 4499 9884 2023-07-10 Positive 5c06d92d_events_v1_20221025.csv 11100857
5f7f33d6 SE-752efd72-0217 2796 2423 2022-10-24 Positive 752efd72_events_v1_20220515.csv 11100797
5f7f33d6 SE-752efd72-0488 4710 10945 2023-08-26 Positive 169e580a_events_v1_20230313.csv 11100750
169e580a SE-a624fb9a-1539 1307 780 2022-05-18 Positive 169e580a_events_v1_20240120.csv 11100737
752efd72 SE-a756bc39-1237 4990 9924 2024-01-15 Negative f454e660_events_20221231.csv 11100739
752efd72 SE-5c06d92d-3205 5134 1379 2022-11-09 Positive 169e580a_events_v1_20230823.csv 11100792
169e580a SE-752efd72-0402 488 3657 2023-02-08 Positive 169e580a_events_v1_20240120.csv 11100811

The Gigacow database currently contain 17116 Pregnancy Check records from 6599 animals in farms participating in Gigacow.

ReproductionStatus data

These are the ReproductionStatus events recorded in Gigacow

## # A tibble: 14 × 3
##    FarmName_Pseudo nrReproduction_ReproductionStatus nrAnimals
##    <chr>                                       <int>     <int>
##  1 afdd9a78                                    33640       243
##  2 a756bc39                                  1149076      1247
##  3 5f7f33d6                                   849709      1372
##  4 ab18b151                                   303755       613
##  5 540275a1                                   553413       996
##  6 ad0a39f5                                   981782      2211
##  7 fced84e9                                   297878      1120
##  8 6d38bc90                                   458197      1323
##  9 5b581702                                   396218       323
## 10 5c06d92d                                  1612910      1943
## 11 f454e660                                  1096143      1346
## 12 169e580a                                  4487449      4645
## 13 a624fb9a                                  1526293       868
## 14 752efd72                                  1781013      1708
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id RepoductionStatusDate ReproductionStatusCode OriginalFileSource dwh_factCowReproduction_Id
169e580a NA 4 21383 2022-04-20 Culled ad0a39f5_culled_v1_20220420.csv 3202811
169e580a NA 8347 18964 2022-04-20 Culled f454e660_culled_20220420.csv 3203495
ad0a39f5 NA 4531 21761 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3203493
169e580a NA 4703 21660 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202805
a624fb9a NA 4420 21420 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202794
169e580a NA 4543 16110 2022-04-20 Heifer a624fb9a_culled_v1_20220420.csv 3203496
169e580a NA NA 21533 2022-04-20 Culled a756bc39_culled_v1_20220420.csv 3202788
169e580a NA 5188 21597 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3203498
752efd72 NA 9658 21752 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202812
169e580a NA 5189 21617 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202814

The Gigacow database currently contain 15527476 Reproductions status records from 19958 animals in farms participating in Gigacow.

Stillborn data

These are the Stillborn events recorded in Gigacow

## # A tibble: 14 × 2
##    FarmName_Pseudo nrStillborn
##    <chr>                 <int>
##  1 5f7f33d6                 84
##  2 ab18b151                 19
##  3 a624fb9a                 72
##  4 540275a1                109
##  5 6d38bc90                 72
##  6 5b581702                 17
##  7 f454e660                 65
##  8 752efd72                 79
##  9 169e580a                274
## 10 fced84e9                 80
## 11 a756bc39                 44
## 12 ad0a39f5                133
## 13 afdd9a78                 12
## 14 5c06d92d                107
FarmName_Pseudo SillbornCalfReference SourceFileDate OriginalFileSource dwh_factCowStillborn_Id
169e580a Dödfödd - {0aa4fc7f-c69d-4c3a-b291-800700772979} 2020-10-20 752efd72_culled_v1_20201127.csv 14
169e580a Dödfödd - {03ea8e6b-7254-4454-9878-3f8c549c2bba} 2020-10-02 169e580a_culled_v1_20210205.csv 18
a624fb9a Dödfödd - {1efae896-9758-4b26-85a8-c9098f610e47} 2020-10-20 5c06d92d_culled_v1_20211120.csv 5
540275a1 Dödfödd - {05ab2bd1-e71e-4976-883b-770532bdca23} 2020-10-02 169e580a_culled_v1_20231227.csv 8
a624fb9a Dödfödd - {17bf3564-639a-4014-a669-7bd49fc728dd} 2021-03-07 ad0a39f5_culled_v1_20220811.csv 40
5f7f33d6 Dödfödd - {19e4b994-fe00-43c8-a94a-494337b8c6cb} 2022-11-04 540275a1_culled_20201002.csv 74
540275a1 Dödfödd - {117c669d-8dbe-482f-95b5-ed876545981c} 2021-11-30 5c06d92d_culled_v1_20231005.csv 59
169e580a Dödfödd - {21682bb2-dce9-4086-b28e-2fe517adbfcc} 2021-02-05 a756bc39_culled_v1_20230322.csv 32
540275a1 Dödfödd - {1072dd20-37bc-42c9-88a1-da111533402e} 2023-12-27 540275a1_culled_20201002.csv 87
ad0a39f5 Dödfödd - {0e0920eb-b73b-4517-9a27-2435af310a7f} 2022-06-11 5c06d92d_culled_v1_20211120.csv 89

The Gigacow database currently contain 1167 stillborn events in farms participating in Gigacow.

Traffic data

Traffic data is collected from farms using DeLaval smart gates. Farms with milk parlours normally have free cow traffic while farms with robot milking may use free cow traffic and only have a smart gate for controlling entry into the milking robot or various forms of controlled cow traffic to direct traffic with multiple smart gates.

## # A tibble: 7 × 3
##   FarmName_Pseudo nrTraffic nrAnimals
##   <chr>               <int>     <int>
## 1 afdd9a78            56745        55
## 2 a624fb9a          4020570       284
## 3 f454e660         17960630       350
## 4 5f7f33d6            17556       214
## 5 540275a1            75312       256
## 6 5b581702          5313955       167
## 7 fced84e9           583796       366
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id GroupName TrafficEventDateTime PreviousArea TimeInArea TimeInArea_totalSeconds TrafficDeviceName TrafficResult GateDecision MilkingInterval MilkingInterval_totalSeconds IncompletedTeats OriginalFileSource dwh_factCowTraffic_Id
f454e660 SE-f454e660-663 1904 10998 Vms kor (144 platser) 2022-04-09 21:40:57 Korridor 04:26 120 Ingångsgrind Avskild Mitten till Obs grupp NA NA NA NA f454e660_traffic_20221017.csv 69
f454e660 SE-afdd9a78-1088 1921 5303 Vms kor (144 platser) 2023-02-11 19:01:39 Korridor 00:37 0 MS1 Har inte passerat, fortfarande inne Korridor NA NA NA NA f454e660_traffic_20221222.csv 70
5b581702 SE-f454e660-407 644 5532 Vms kor 2022-04-13 06:00:58 Grovfoder 00:04 0 VMS2 Pass through to Foderbord Kor som har mindre än 4,5 timmar innan mjölkningstillstånd NA NA NA a624fb9a_traffic_20210223.csv 25
f454e660 SE-f454e660-545 499 1939 Vms kor (144 platser) 2023-05-26 15:13:26 Foderbord 01:23 420 Utgångsgrind Har inte passerat, fortfarande inne Foderbord NA NA NA NA f454e660_traffic_20221128.csv 81
f454e660 SE-6d38bc90-2699 465 5845 Vms kor 2022-06-02 21:49:50 Korridor 00:02 300 VMS2 Har inte passerat, fortfarande inne Korridor Gula mjölkas NA NA NA f454e660_traffic_20221009.csv 92
a624fb9a SE-f454e660-387 2355 6125 Vms kor (144 platser) 2022-09-16 02:49:08 Korridor 00:07 300 Utgångsgrind Har inte passerat, fortfarande inne Korridor NA NA 51300 NA f454e660_traffic_20230728.csv 14
5b581702 SE-aa2bc2d3-1392 591 4039 Vms kor (144 platser) 2022-09-05 01:43:14 Korridor 00:07 300 Ingångsgrind Har inte passerat, fortfarande inne Foderbord NA NA NA NA 5b581702_traffic_20220221.csv 56
5b581702 SE-f454e660-0579 1917 5013 Vms kor (144 platser) 2023-06-10 21:08:59 Liggavdelning 00:04 4500 Ingångsgrind Har inte passerat, fortfarande inne Korridor Alla kor NA 22920 NA f454e660_traffic_20230610.csv 21
5b581702 SE-6d38bc90-2527 602 8287 Vms kor (144 platser) 2023-09-11 16:13:08 Foderbord 00:52 0 Vms 1 Avskild Mitten till Obs grupp Kor som har mindre än 4,5 timmar innan mjölkningstillstånd NA NA NA a624fb9a_traffic_20210528.csv 72
f454e660 SE-f454e660-495 600 4273 Vms kor (144 platser) 2023-04-12 16:42:09 Korridor 00:11 28980 Utgångsgrind Har inte passerat, fortfarande inne Korridor NA NA NA NA f454e660_traffic_20211211.csv 78

The Gigacow database currently contain 28028564 gate passages by 1692 animals in farms participating in Gigacow.