This booklet was created on 2024-08-28 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: 14 × 3
##    FarmName_Pseudo nrGigacow_Cow nrAnimals
##    <chr>                   <int>     <int>
##  1 <NA>                        1         1
##  2 169e580a                 5967      5964
##  3 540275a1                  843       843
##  4 5b581702                  399       399
##  5 5c06d92d                 2742      2741
##  6 5f7f33d6                 1845      1845
##  7 6d38bc90                 2055      2055
##  8 752efd72                 2282      2282
##  9 a624fb9a                 1400      1400
## 10 a756bc39                 1428      1428
## 11 ab18b151                 1048      1048
## 12 ad0a39f5                 2458      2458
## 13 afdd9a78                  439       439
## 14 f454e660                 1725      1725
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
38 a756bc39 SE-a756bc39-1432 8444 NA SE-169e580a-2983 22-8359 01 SRB NA 2023-07-24 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
14 ad0a39f5 SE-169e580a-0755 7107 NA SE-169e580a-4754 9-4807 slypp Unknown Breed NA 2022-09-06 NA 09 Benlidande 18 Svårmjölkad, exteriör 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\f454e660\GIGACOW_identity_20201020.csv;\\storage-ua.slu.se\Gigacow\)54e660_culled_20240129.csv
32 f454e660 SE-a756bc39-1046 4126 NA SE-5f7f33d6-1049 9-4883 SPA 02 SLB NA 2018-07-19 NA NA 11 Kastning 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\a756bc39\GIGACOW_identity_v1_20220222.csv </td> </tr> <tr> <td style="text-align:right;"> 64 </td> <td style="text-align:left;"> a756bc39 </td> <td style="text-align:left;"> SE-169e580a-5968 </td> <td style="text-align:right;"> 8066 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> SE-5c06d92d-2254 </td> <td style="text-align:left;"> 9-4536 </td> <td style="text-align:left;"> 01 SRB </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> 2021-03-10 </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_20221112.csv
21 a756bc39 SE-f454e660-992 9360 NA SE-169e580a-3284 Gordon 9-6199 02 SLB NA 2022-09-05 2022-02-16 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\(\FileArea\ImportArea\169e580a\GIGACOW_identity_v1_20220703.csv </td> </tr> <tr> <td style="text-align:right;"> 59 </td> <td style="text-align:left;"> 169e580a </td> <td style="text-align:left;"> SE-f454e660-2552 </td> <td style="text-align:right;"> 626 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> SE-169e580a-5534 </td> <td style="text-align:left;"> 3-7329 </td> <td style="text-align:left;"> 02 SLB </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> 2022-09-11 </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: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\)\5f7f33d6_identity_v1_20230824.csv
54 169e580a SE-ab18b151-1471 9517 NA SE-5f7f33d6-0551 3-9900 02 SLB NA 2016-03-23 NA 02 Nedsatt fruktsamhet 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_20211027.csv;\\storage-ua.slu.se\Gigacow\)\169e580a_culled_v1_20240327.csv
27 a756bc39 SE-5c06d92d-2595 1249 NA NA NA 12 Limousin NA 2016-05-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\5c06d92d\GIGACOW_identity_v1_20211120.csv;\\storage-ua.slu.se\Gigacow\)\5c06d92d_culled_v1_20240129.csv
34 f454e660 SE-ad0a39f5-2538 1432 NA SE-752efd72-0370 9-3880 02 SLB NA 2021-10-26 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\5f7f33d6\GIGACOW_identity_v1_20230824.csv </td> </tr> <tr> <td style="text-align:right;"> 72 </td> <td style="text-align:left;"> 169e580a </td> <td style="text-align:left;"> SE-169e580a-3669 </td> <td style="text-align:right;"> 1037 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> SE-a756bc39-0651 </td> <td style="text-align:left;"> 9-1946 </td> <td style="text-align:left;"> 02 SLB </td> <td style="text-align:right;"> NA </td> <td style="text-align:left;"> 2017-12-26 </td> <td style="text-align:left;"> 2021-06-29 </td> <td style="text-align:left;"> 32 Slakt </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\)0a39f5_identity_v1_20220514.csv;\storage-ua.slu.se$0a39f5_culled_v1_20231107.csv

The Gigacow database currently contain 24628 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: 12 × 3
##    FarmName_Pseudo nrMilkings nrAnimals
##    <chr>                <int>     <int>
##  1 540275a1            315778       232
##  2 5b581702            151896       140
##  3 5c06d92d           1009928       588
##  4 5f7f33d6            491896       382
##  5 6d38bc90            158287       396
##  6 752efd72            893448       606
##  7 a624fb9a            456463       243
##  8 a756bc39            316703       266
##  9 ab18b151            308466       201
## 10 ad0a39f5           1029071       482
## 11 afdd9a78             46301        68
## 12 f454e660            466171       336
Del_Cow_Id FarmName_Pseudo SE_Number AnimalNumber StartDate StartTime LactationNumber DaysInMilk LactationInfoSource SessionNumber TotalYield OriginalFileSource dwh_factCowMilk_Id dwh_factCowMilkOther_Id
6586 5f7f33d6 SE-6d38bc90-2711 970 2023-10-02 14:48:00 4 360 Estimate 1 18.66 a624fb9a_milking_v2_20230514.csv 16201 NA
2008 5b581702 SE-a624fb9a-1405 2738 2023-12-13 04:14:00 1 260 EventFile 3 13.94 a624fb9a_milking_v2_20231202.csv 16007 NA
7589 f454e660 SE-f454e660-291 1486 2024-01-22 17:27:00 9 106 EventFile 4 18.54 5f7f33d6_milking_v2_20230719.csv 14468 NA
11325 f454e660 SE-5b581702-1802 1282 2023-06-17 11:45:00 1 99 Estimate 4 7.60 5f7f33d6_milking_v2_20240105.csv 16335 NA
2443 5f7f33d6 SE-5f7f33d6-1008 1183 2023-12-27 08:16:00 4 76 EventFile 2 13.12 a624fb9a_milking_v2_20230421.csv 14123 NA
6833 a624fb9a SE-a624fb9a-1486 494 2023-10-10 21:11:00 NA 3 Estimate 2 9.46 a624fb9a_milking_v2_20231104.csv 14261 NA
12769 5b581702 SE-a624fb9a-1477 -1 2023-11-05 20:31:00 3 1 EventFile 1 12.37 5f7f33d6_milking_v2_20230617.csv 14185 NA
1526 5f7f33d6 SE-a624fb9a-1394 794 2023-07-03 22:46:00 NA 353 Unknown 1 9.75 f454e660_milking_v2_20231002.csv 16447 NA
3711 5b581702 SE-f454e660-685 842 2023-07-19 19:23:00 3 217 EventFile 1 14.04 5f7f33d6_milking_v2_20230716.csv 16273 NA
10104 5f7f33d6 SE-5f7f33d6-1346 797 2023-07-07 16:02:00 4 240 Estimate 2 12.42 5f7f33d6_milking_v2_20230807.csv 14860 NA

The Gigacow database currently contain 5644408 milking events from 3940 animals.

Robot milkings

## # A tibble: 7 × 3
##   FarmName_Pseudo nrMilkings nrAnimals
##   <chr>                <int>     <int>
## 1 afdd9a78             46301        68
## 2 a624fb9a            456463       243
## 3 ab18b151            308466       201
## 4 5b581702            151896       140
## 5 540275a1            315778       232
## 6 5f7f33d6            491896       382
## 7 f454e660            466171       336
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-592 1212 13542 Vmskor 2023-06-20 01:51:00 1 MS2 5.44 2.59 3.22 3.43 6.22 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.96 0.90 0.60 1.08 1.44 0.96 1.86 1.50 0 0 0 0 0.00 4.42 4.56 3.83 NA NA MS1 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20231010.csv 15530
a624fb9a SE-5b581702-1912 1346 1079 Vms kor (144 platser) 2023-11-19 14:48:00 3 MS1 4.47 2.92 5.40 5.64 10.65 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.90 1.38 0.96 1.14 1.62 1.02 1.56 1.08 0 0 518 0 4.02 3.74 4.92 4.18 725 NA MS2 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20230517.csv 14344
5f7f33d6 SE-a624fb9a-1405 2004 6772 Vmskor 2023-07-12 07:09:00 3 MS1 4.68 2.04 2.54 3.00 12.87 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA Y 0.66 0.66 0.72 1.26 1.68 1.38 1.02 1.56 413 0 0 581 4.74 4.07 0.00 4.68 54 NA Vms 1 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20231228.csv 15643
5f7f33d6 SE-5b581702-1851 1436 8385 Vmskor 2023-07-28 01:14:00 1 MS4 2.63 1.61 2.65 3.08 8.78 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 1.38 1.44 1.62 1.32 1.32 0.96 1.62 2.04 0 0 0 0 4.13 4.86 4.65 4.61 820 NA MS1 Mjölkning NA Mjölktank NA f454e660_milking_v2_20230930.csv 16447
a624fb9a SE-a624fb9a-1477 2103 3507 VMS 1 2023-07-07 12:15:00 2 MS1 3.04 1.66 3.96 1.63 7.60 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.36 1.02 0.90 0.96 1.26 1.62 1.32 1.62 0 0 0 1217 0.00 3.59 4.67 4.84 NA NA MS2 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20230627.csv 14460
5b581702 SE-f454e660-0494 1500 9495 Vmskor 2023-07-16 10:28:00 2 MS1 6.51 2.67 3.95 2.73 11.43 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.42 1.26 0.96 1.56 1.20 1.44 1.74 1.08 NA 0 0 0 5.39 4.59 3.98 4.36 NA NA MS1 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20230514.csv 15249
f454e660 SE-5b581702-2004 1341 4036 VMS 1 2023-09-25 03:37:00 2 Vms 1 2.50 3.30 1.55 2.18 20.66 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.90 1.62 1.26 1.20 1.74 2.28 1.08 1.44 0 NA 0 0 0.00 4.43 4.51 4.92 NA NA Vms 1 Mjölkning NA Mjölktank NA f454e660_milking_v2_20231002.csv 15856
a624fb9a SE-5f7f33d6-0629 701 1623 Vmskor 2023-12-28 16:48:00 4 MS1 2.33 3.42 5.65 3.78 10.91 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.72 0.96 1.62 1.44 1.26 0.96 1.20 1.38 413 0 0 0 4.18 4.43 3.45 4.01 NA NA MS1 Mjölkning NA Mjölktank NA f454e660_milking_v2_20230711.csv 14511
f454e660 SE-5f7f33d6-1183 407 2078 Vms kor 2024-01-13 10:51:00 2 MS3 3.13 3.82 3.04 3.65 16.66 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.84 0.96 0.78 0.96 1.62 1.08 1.38 1.44 0 589 0 0 4.86 4.03 4.67 4.45 NA NA vms 2 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20230429.csv 14860
5f7f33d6 SE-5f7f33d6-1237 1332 11817 VMS 1 2023-11-22 04:14:00 1 MS4 3.14 2.24 2.20 1.95 13.94 NA NA NA NA NA NA NA NA NA NA NA NA 0 NA NA NA NA 0.84 0.66 0.84 0.24 1.68 1.44 0.60 1.74 0 0 510 0 4.10 5.22 4.45 3.85 NA NA MS2 Mjölkning NA Mjölktank NA 5f7f33d6_milking_v2_20240105.csv 14414

The Gigacow database currently contain 2236971 milkings from 1602 animals in farms with milking robots.

Parlour milkings

## # A tibble: 5 × 3
##   FarmName_Pseudo nrMilkings nrAnimals
##   <chr>                <int>     <int>
## 1 a756bc39            316703       266
## 2 752efd72            893448       606
## 3 ad0a39f5           1029071       482
## 4 6d38bc90            158287       396
## 5 5c06d92d           1009928       588
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-2055 2055 9905 AVENA 4 7 339 2023-08-02 1 357 3.4 NA 4.1 NA NA 301 3.4 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20240126.csv 858
5c06d92d SE-5c06d92d-2055 2055 9905 LEA 4 8 317 2023-04-22 1 399 3.0 NA 3.8 NA NA 363 2.2 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20240127.csv 1239
5c06d92d SE-5c06d92d-2055 2055 9905 LEA 4 7 18 2023-12-14 1 656 2.5 NA 5.2 NA NA 285 2.4 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20240125.csv 840
5c06d92d SE-5c06d92d-2055 2058 9905 LEA 4 8 64 2023-12-21 1 382 3.3 NA 5.5 NA NA 275 2.3 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20230818.csv 1234
5c06d92d SE-5c06d92d-2055 2055 9905 LEA 4 8 57 2023-05-30 1 554 2.3 NA 4.3 NA NA 351 2.5 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20230806.csv 893
5c06d92d SE-5c06d92d-2055 2055 9905 LEA 4 7 314 2023-08-22 1 310 3.1 NA 3.8 NA NA 321 2.5 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20230722.csv 1121
5c06d92d SE-5c06d92d-2058 2055 9905 LEA 4 7 318 2023-12-07 1 314 3.5 NA 4.5 NA NA 342 2.9 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20230909.csv 866
5c06d92d SE-5c06d92d-2058 2055 9905 LEA 4 8 36 2023-07-11 1 403 2.8 NA 5.3 NA NA 598 3.6 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20230823.csv 1255
5c06d92d SE-5c06d92d-2058 2058 9905 LEA 4 7 361 2023-07-13 1 246 3.6 NA 3.2 NA NA 609 3.9 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20230723.csv 836
5c06d92d SE-5c06d92d-2058 2055 9905 LEA 4 8 326 2023-07-15 1 304 2.7 NA 5.8 NA NA 287 3.3 NA NA NA NA NA NA NA NA NA NA MilkFile 5c06d92d_milking_v5_20230530.csv 1075

The Gigacow database currently contain 3407437 milkings from 2338 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: 8 × 3
##   FarmName_Pseudo nrActivity nrAnimals
##   <chr>                <int>     <int>
## 1 a756bc39               995         1
## 2 540275a1              1008       168
## 3 ad0a39f5            177803       485
## 4 a624fb9a            184099       321
## 5 752efd72            114757       619
## 6 ab18b151             25658       161
## 7 f454e660             45973       332
## 8 169e580a            114574       783
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
752efd72 SE-169e580a-6156 6164 13448 2023-12-13 49 118 NA ++ 65 NA 2 NA Unchecked Unchecked Unchecked 34 a624fb9a_activity_v1_20231102.csv 541
169e580a SE-169e580a-6312 571 11198 2023-08-30 58 103 23 Unknown 62 NA 2 43 Unchecked Unchecked Unchecked 75 f454e660_activity_20230830.csv 581
169e580a SE-f454e660-0874 6376 9430 2023-10-27 66 115 NA Unknown 27 NA 1 39 Unchecked Unchecked Unchecked 71 752efd72_activity_v1_20231230.csv 236
752efd72 SE-a624fb9a-1321 6421 1050 2023-08-20 76 97 NA Unknown 50 2023-08-02 11:00:00 2 NA Unchecked Unchecked Unchecked 44 169e580a_activity_v1_20231031.csv 84
a624fb9a SE-169e580a-6333 6333 5289 2024-01-06 14 88 NA Unknown 37 NA 2 NA Unchecked Unchecked Unchecked 42 169e580a_activity_v1_20231008.csv 105
169e580a SE-752efd72-0399 6360 5145 2023-07-31 11 106 NA Unknown 43 2023-12-10 10:00:00 NA NA Unchecked Unchecked Unchecked 90 169e580a_activity_v1_20230510.csv 426
a624fb9a SE-a624fb9a-1456 581 4381 2023-09-09 36 102 NA
50 NA 2 16 Unchecked Unchecked Unchecked 34 f454e660_activity_20230827.csv 461
a624fb9a SE-752efd72-0561 1508 7368 2023-11-30 86 115 NA ++ 46 NA 1 NA Unchecked Unchecked Unchecked 46 752efd72_activity_v1_20231212.csv 293
752efd72 SE-169e580a-6396 1426 2415 2023-12-17 81 103 NA Unknown 46 NA 1 NA Unchecked Unchecked Unchecked 50 a624fb9a_activity_v1_20231228.csv 280
169e580a SE-a624fb9a-1322 1482 2856 2023-08-27 34 92 14 Unknown 27 NA 2 19 Unchecked Unchecked Unchecked 38 a624fb9a_activity_v1_20230523.csv 493

The Gigacow database currently contain 664867 activity measurements from 2870 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: 10 × 3
##    FarmName_Pseudo  nrFeed nrAnimals
##    <chr>             <int>     <int>
##  1 afdd9a78          25741        69
##  2 a624fb9a         614873       261
##  3 5f7f33d6         551529       887
##  4 a756bc39        1859834      1218
##  5 f454e660         584465       556
##  6 169e580a          67500       686
##  7 ab18b151         269083       203
##  8 ad0a39f5        1179808      1170
##  9 6d38bc90         348438       867
## 10 5b581702         256765       148
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id FeedDate FeedName FeedRation FeedConsumedPercent OriginalFileSource dwh_factCowFeed_Id
a624fb9a SE-f454e660-508 1287 4870 2023-04-20 Feed5 6.00 94 a624fb9a_feed_v1_20230421.csv 3048479
f454e660 SE-f454e660-702 1491 5128 2023-04-20 Feed5 3.52 19 f454e660_feed_20230421.csv 3047960
f454e660 SE-f454e660-282 5680 484 2023-04-20 Feed5 2.33 99 a624fb9a_feed_v1_20230421.csv 3047941
f454e660 SE-a624fb9a-1287 306 11732 2023-04-20 Feed5 1.72 104 a624fb9a_feed_v1_20230421.csv 3047923
a624fb9a SE-a624fb9a-1351 740 7884 2023-04-20 Feed5 5.50 101 a624fb9a_feed_v1_20230421.csv 3048502
f454e660 SE-f454e660-610 712 11094 2023-04-20 Feed5 0.00 70 f454e660_feed_20230421.csv 3048505
a624fb9a SE-f454e660-749 459 9652 2023-04-20 Feed4 3.00 113 a624fb9a_feed_v1_20230421.csv 3047917
f454e660 SE-a624fb9a-1456 742 9903 2023-04-20 Feed5 2.50 91 f454e660_feed_20230421.csv 3047953
f454e660 SE-a624fb9a-1466 610 7476 2023-04-20 Feed5 2.00 35 f454e660_feed_20230421.csv 3047961
a624fb9a SE-30dc5787-1396 451 1254 2023-04-20 Feed5 6.00 92 f454e660_feed_20230421.csv 3047915

The Gigacow database currently contain 5758036 Feed day records from 6065 animals in farms participating in Gigacow.

Body Conditions Score data

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

## # A tibble: 3 × 3
##   FarmName_Pseudo  nrBCS nrAnimals
##   <chr>            <int>     <int>
## 1 540275a1            26        26
## 2 afdd9a78            50        49
## 3 5c06d92d        282673       600
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id BCSEventDate BCSValue OriginalFileSource dwh_factCowHealth_Id
5c06d92d SE-5c06d92d-3242 2778 3283 2023-08-24 3.17 5c06d92d_events_v1_20240120.csv 263
5c06d92d SE-5c06d92d-3107 3379 2157 2023-09-12 3.05 5c06d92d_events_v1_20230714.csv 162
5c06d92d SE-5c06d92d-2757 3371 11433 2023-07-02 3.36 5c06d92d_events_v1_20230711.csv 8
5c06d92d SE-5c06d92d-3065 2630 1823 2023-11-03 3.12 5c06d92d_events_v1_20230927.csv 20
5c06d92d SE-5c06d92d-2457 3129 7496 2023-10-03 3.24 5c06d92d_events_v1_20230718.csv 57
5c06d92d SE-5c06d92d-2831 3048 11175 2023-12-28 3.33 5c06d92d_events_v1_20230819.csv 102
5c06d92d SE-5c06d92d-2798 3416 7268 2023-12-24 2.98 5c06d92d_events_v1_20230529.csv 274
5c06d92d SE-5c06d92d-3265 2780 468 2023-06-19 3.54 5c06d92d_events_v1_20230711.csv 211
5c06d92d SE-5c06d92d-3076 3434 5468 2023-09-06 3.02 5c06d92d_events_v1_20230717.csv 233
5c06d92d SE-5c06d92d-3150 3373 2212 2023-06-19 2.44 5c06d92d_events_v1_20230529.csv 245

The Gigacow database currently contain 282749 BCS day records from 675 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                                254       254
##  5 5b581702                                 56        41
##  6 f454e660                               1476       697
##  7 169e580a                              27541      4511
##  8 ad0a39f5                                  1         1
##  9 afdd9a78                                 68        57
## 10 5c06d92d                               6785       639
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id HealthEventDate DiagnosisName TreatmentName OriginalFileSource dwh_factCowHealth_Id
5c06d92d SE-169e580a-4230 2913 7880 2022-05-30 Avmaskning NA f454e660_events_20220305.csv 5080
169e580a SE-169e580a-6080 4585 10735 2020-07-27 NA Noromectin 169e580a_events_v1_20220719.csv 5055
169e580a SE-169e580a-4712 2713 9579 2023-05-06 Retained placenta NSAID 5c06d92d_events_v1_20231121.csv 5009
169e580a SE-169e580a-4841 6665 8977 2021-04-22 Boviseal Dectomax 5f7f33d6_events_v1_20230428.csv 5107
5c06d92d SE-169e580a-4682 3059 1894 2023-12-19 Avhorning 1:a vacc. 5c06d92d_events_v1_20220315.csv 5026
5c06d92d SE-ab18b151-1342 4172 2157 2021-08-30 Navelinfektion NA 169e580a_events_v1_20220305.csv 5041
169e580a SE-169e580a-4852 2582 6178 2021-04-26 Avmaskningskaps Ethacillin 169e580a_events_v1_20210416.csv 5090
5c06d92d SE-540275a1-1955 514 9820 2023-12-11 Boviseal 2:a vacc. 169e580a_events_v1_20220603.csv 5072
169e580a SE-169e580a-0738 4682 8604 2022-03-08 Avmaskning Ringvac2 169e580a_events_v1_20220309.csv 5076
169e580a SE-169e580a-4172 4621 84 2021-06-21 1:a vacc. Ringorm Juvertuber Benestermycin 5c06d92d_events_v1_20211223.csv 5035

The Gigacow database currently contain 37364 entries of health events in Gigacow from 6993 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 afdd9a78                              3         2
##  2 5f7f33d6                             26        25
##  3 ab18b151                             26        25
##  4 a756bc39                             13        12
##  5 540275a1                              7         7
##  6 ad0a39f5                             18        18
##  7 752efd72                             23        22
##  8 a624fb9a                             16        14
##  9 5b581702                              8         8
## 10 5c06d92d                             57        55
## 11 169e580a                            223       212
## 12 f454e660                             28        28
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id AbortionDate OriginalFileSource dwh_factCowReproduction_Id
169e580a SE-5c06d92d-3044 661 3509 2023-09-01 169e580a_events_v1_20240105.csv 11091112
a756bc39 SE-5f7f33d6-1324 3216 11425 2023-12-11 169e580a_events_v1_20221007.csv 11090977
169e580a SE-a756bc39-1212 5565 10061 2022-09-18 5f7f33d6_events_v1_20230428.csv 11090969
5f7f33d6 SE-d29a722f-1497 943 1390 2022-12-03 5f7f33d6_events_v1_20231004.csv 11091105
169e580a SE-a756bc39-1026 671 13123 2022-12-19 5c06d92d_events_v1_20221201.csv 11091164
5f7f33d6 SE-f454e660-489 4502 8277 2022-08-11 169e580a_events_v1_20220621.csv 11091155
169e580a SE-752efd72-0235 4625 3647 2022-09-20 5c06d92d_events_v1_20230711.csv 11091172
169e580a SE-a624fb9a-1258 1311 13484 2023-07-15 752efd72_events_v1_20220923.csv 11091116
ad0a39f5 SE-f454e660-0465 5691 8438 2022-07-11 5c06d92d_events_v1_20230107.csv 11090982
169e580a SE-5c06d92d-2572 5178 6738 2023-06-19 169e580a_events_v1_20221018.csv 11091135

The Gigacow database currently contain 448 abortions from 428 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 afdd9a78                            83        66
##  2 ab18b151                           346       200
##  3 540275a1                           146       143
##  4 5f7f33d6                           618       394
##  5 a756bc39                           503       255
##  6 ad0a39f5                           852       576
##  7 5b581702                           356       144
##  8 5c06d92d                          1252       588
##  9 752efd72                           940       494
## 10 a624fb9a                           614       209
## 11 169e580a                          3872      1889
## 12 f454e660                           812       449
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id CalvingDate CalvingEase CalvingSireBullID OriginalFileSource dwh_factCowReproduction_Id
752efd72 SE-169e580a-4064 4847 9676 2023-08-27 11 Easy, without assistance 9-8469 Maximus a624fb9a_events_v1_20221218.csv 11096865
ad0a39f5 SE-5c06d92d-3216 1372 8487 2024-01-16 11 Easy, without assistance 7-1870 ELITE 169e580a_events_v1_20230707.csv 11097076
5c06d92d SE-169e580a-4847 4994 10051 2023-04-11 11 Easy, without assistance 03-9939 169e580a_events_v1_20230503.csv 11097697
5c06d92d SE-752efd72-0430 6321 9239 2022-10-25 11 Easy, without assistance 3-5177 BRUTUZ a624fb9a_events_v1_20230816.csv 11097314
752efd72 SE-a624fb9a-1343 4980 12881 2022-10-07 11 Easy, without assistance 9-4795x 752efd72_events_v1_20221109.csv 11096909
f454e660 SE-f454e660-0762 5394 1930 2022-04-28 11 Easy, without assistance 9-8560 Hashtag 169e580a_events_v1_20221126.csv 11096970
5f7f33d6 SE-5f7f33d6-0922 1321 38 2023-10-31 11 Easy, without assistance 9-5008 169e580a_events_v1_20230130.csv 11097794
5c06d92d SE-5c06d92d-3313 5254 5696 2023-05-02 11 Easy, without assistance 7-1883 RANCHER 5c06d92d_events_v1_20230224.csv 11096735
169e580a SE-5b581702-1816 2624 12493 2022-08-11 11 Easy, without assistance 9-8467 No Limits 169e580a_events_v1_20230908.csv 11096947
5f7f33d6 SE-a624fb9a-1443 699 6492 2023-03-15 11 Easy, without assistance 9-8821 Vesty 5c06d92d_events_v1_20220527.csv 11096829

The Gigacow database currently contain 10394 Reproduction_Calving records from 5407 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 540275a1                           19        19
##  3 ab18b151                          160       118
##  4 5f7f33d6                          282       220
##  5 a756bc39                          266       161
##  6 ad0a39f5                          315       269
##  7 752efd72                          501       308
##  8 a624fb9a                          318       154
##  9 5b581702                          175        98
## 10 5c06d92d                          744       418
## 11 169e580a                         2114      1285
## 12 f454e660                          403       276
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id DryOffDate OriginalFileSource dwh_factCowReproduction_Id
f454e660 SE-f454e660-269 2685 4386 2023-08-30 ab18b151_events_v1_20220530.csv 11086378
a756bc39 SE-5c06d92d-2870 5967 11056 2023-09-15 169e580a_events_v1_20230825.csv 11086456
ab18b151 SE-a624fb9a-1393 1188 4320 2023-06-13 169e580a_events_v1_20230210.csv 11086516
169e580a SE-169e580a-4826 5551 181 2023-08-10 169e580a_events_v1_20230707.csv 11086467
169e580a SE-169e580a-4841 4801 10807 2022-06-02 169e580a_events_v1_20230811.csv 11086521
169e580a SE-169e580a-4811 1238 1798 2023-06-30 ad0a39f5_events_v1_20220910.csv 11086513
5c06d92d SE-169e580a-5237 3352 1769 2023-06-08 5c06d92d_events_v1_20230711.csv 11086443
afdd9a78 SE-5f7f33d6-0886 5169 8319 2023-10-05 169e580a_events_v1_20221008.csv 11086407
5c06d92d SE-5c06d92d-3176 5070 1972 2022-10-07 5f7f33d6_events_v1_20230428.csv 11086463
5c06d92d SE-169e580a-4871 5756 1514 2023-09-20 5c06d92d_events_v1_20221110.csv 11086416

The Gigacow database currently contain 5324 Reproduction_DryOff records from 3353 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 afdd9a78                                121        87
##  2 540275a1                                146       146
##  3 ad0a39f5                               1041       512
##  4 ab18b151                                623       280
##  5 a624fb9a                                964       240
##  6 752efd72                               1761       531
##  7 a756bc39                                801       242
##  8 5f7f33d6                               1251       462
##  9 f454e660                               1397       517
## 10 169e580a                               8719      2231
## 11 5b581702                                699       173
## 12 5c06d92d                               2157       688
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id InseminationDate Breeder OriginalFileSource dwh_factCowReproduction_Id
169e580a SE-5c06d92d-3321 4825 4363 2022-12-16 1241 169e580a_events_v1_20221207.csv 11069038
a624fb9a SE-a624fb9a-1373 753 12311 2023-07-06 4489 5b581702_events_v1_20220713.csv 11069096
5b581702 SE-ad0a39f5-2677 1394 4112 2023-12-20 8531 5f7f33d6_events_v1_20230520.csv 11069138
a756bc39 SE-752efd72-0438 4926 1872 2022-05-19 8948 169e580a_events_v1_20220615.csv 11069073
afdd9a78 SE-169e580a-4213 2677 10551 2022-07-16 4408 169e580a_events_v1_20220830.csv 11069107
169e580a SE-5f7f33d6-1394 3062 461 2023-09-25 8536 5f7f33d6_events_v1_20231115.csv 11069145
5c06d92d SE-5c06d92d-3437 2504 12456 2024-01-19 4409 f454e660_events_20230812.csv 11069008
169e580a SE-169e580a-4889 3224 12165 2022-10-17 4325 169e580a_events_v1_20221130.csv 11069000
169e580a SE-169e580a-5734 4867 2268 2023-02-03 1412 169e580a_events_v1_20221122.csv 11068993
5f7f33d6 SE-169e580a-4984 5847 10319 2022-08-14 1412 169e580a_events_v1_20230207.csv 11069097

The Gigacow database currently contain 19680 insemination records from 6109 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 5f7f33d6                          125700       394
##  3 ab18b151                           73246       201
##  4 a756bc39                          137568       255
##  5 540275a1                             858       143
##  6 ad0a39f5                          252222       576
##  7 a624fb9a                          138292       209
##  8 752efd72                          238696       494
##  9 5b581702                           89303       146
## 10 5c06d92d                          305414       588
## 11 f454e660                          197242       451
## 12 169e580a                         1014154      1889
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id LactationInfoDate LactationNumber DaysInMilk OriginalFileSource dwh_factCowReproduction_Id
169e580a SE-169e580a-5428 1810 12906 2023-11-18 4 99 169e580a_events_v1_20230623.csv 8851668
a756bc39 SE-752efd72-0079 2651 4833 2023-12-30 2 50 ad0a39f5_events_v1_20230116.csv 8851761
ab18b151 SE-5c06d92d-2689 1381 9535 2022-05-06 2 24 169e580a_events_v1_20220521.csv 8851769
5c06d92d SE-6d38bc90-2590 2862 6203 2023-07-12 2 240 5c06d92d_events_v1_20230403.csv 8851733
169e580a SE-a756bc39-1258 3046 8702 2023-02-14 4 305 5f7f33d6_events_v1_20231128.csv 8851623
ad0a39f5 SE-5c06d92d-3251 719 11993 2023-07-14 1 53 5c06d92d_events_v1_20221203.csv 8851664
169e580a SE-a756bc39-1204 2758 12396 2022-06-18 1 306 5c06d92d_events_v1_20221202.csv 8851637
ad0a39f5 SE-169e580a-4306 4782 8806 2022-08-11 4 190 ad0a39f5_events_v1_20230211.csv 8851652
169e580a SE-5c06d92d-2673 5546 12551 2022-05-27 5 276 169e580a_events_v1_20231227.csv 8851627
a624fb9a SE-a756bc39-0975 1426 13623 2023-05-07 2 268 5c06d92d_events_v1_20231229.csv 8851626

The Gigacow database currently contain 2581254 lactation days with associated lactation numbers from 5412 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 afdd9a78                                   74        74
##  2 ad0a39f5                                  625       453
##  3 a756bc39                                  458       224
##  4 ab18b151                                  417       274
##  5 540275a1                                   96        96
##  6 f454e660                                  933       499
##  7 169e580a                                 7222      2159
##  8 5b581702                                  506       162
##  9 5c06d92d                                 1507       675
## 10 5f7f33d6                                  665       439
## 11 a624fb9a                                  611       236
## 12 752efd72                                 1072       512
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id PregnancyCheckDate PregnancyCheckResult OriginalFileSource dwh_factCowReproduction_Id
169e580a SE-169e580a-5310 1175 1429 2022-09-14 Positive afdd9a78_events_v1_20221230.csv 11100727
169e580a SE-169e580a-5918 492 13673 2023-06-26 Positive 752efd72_events_v1_20230316.csv 11100799
169e580a SE-169e580a-6138 5640 4336 2022-09-16 Negative 5c06d92d_events_v1_20240116.csv 11100823
169e580a SE-5c06d92d-3095 426 3109 2023-10-18 Positive 752efd72_events_v1_20221222.csv 11100701
5f7f33d6 SE-5f7f33d6-1307 1212 12983 2022-09-16 Positive 169e580a_events_v1_20240120.csv 11100725
169e580a SE-169e580a-5134 488 11744 2022-07-01 Positive ad0a39f5_events_v1_20230117.csv 11100836
169e580a SE-169e580a-5283 378 3657 2023-02-08 Positive 169e580a_events_v1_20230211.csv 11100772
169e580a SE-f454e660-768 6138 2423 2022-05-18 Negative ad0a39f5_events_v1_20221110.csv 11100824
752efd72 SE-5f7f33d6-1212 6391 6456 2022-04-29 Negative 169e580a_events_v1_20221213.csv 11100741
5b581702 SE-5c06d92d-2796 402 5051 2023-02-10 Positive 5c06d92d_events_v1_20230921.csv 11100789

The Gigacow database currently contain 14186 Pregnancy Check records from 5803 animals in farms participating in Gigacow.

ReproductionStatus data

These are the ReproductionStatus events recorded in Gigacow

## # A tibble: 13 × 3
##    FarmName_Pseudo nrReproduction_ReproductionStatus nrAnimals
##    <chr>                                       <int>     <int>
##  1 afdd9a78                                    33640       243
##  2 a756bc39                                   790151      1054
##  3 5f7f33d6                                   461535      1149
##  4 540275a1                                     3131       523
##  5 a624fb9a                                  1105289       794
##  6 752efd72                                  1285330      1472
##  7 f454e660                                   803177      1238
##  8 169e580a                                  3551599      4021
##  9 6d38bc90                                   217534      1263
## 10 5b581702                                   269284       281
## 11 5c06d92d                                  1018150      1599
## 12 ad0a39f5                                   896894      1613
## 13 ab18b151                                   303755       613
FarmName_Pseudo SE_Number AnimalNumber Del_Cow_Id RepoductionStatusDate ReproductionStatusCode OriginalFileSource dwh_factCowReproduction_Id
169e580a NA NA 21718 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202835
169e580a SE-064c0cec-1189 4588 21800 2022-04-20 Culled ad0a39f5_culled_v1_20220420.csv 3202778
169e580a NA 4335 21794 2022-04-20 Culled a624fb9a_culled_v1_20220420.csv 3202803
169e580a NA 5179 4607 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202773
a624fb9a SE-06949c73-0776 4457 21375 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202841
169e580a SE-06949c73-0778 NA 21355 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202799
169e580a NA 4443 21513 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202832
169e580a NA 4610 14075 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202809
169e580a NA 7578 21383 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3203491
169e580a NA 4565 16455 2022-04-20 Culled 169e580a_culled_v1_20220420.csv 3202811

The Gigacow database currently contain 10739469 Reproductions status records from 15863 animals in farms participating in Gigacow.

Stillborn data

These are the Stillborn events recorded in Gigacow

## # A tibble: 13 × 2
##    FarmName_Pseudo nrStillborn
##    <chr>                 <int>
##  1 169e580a                250
##  2 540275a1                 59
##  3 5b581702                 11
##  4 5c06d92d                 80
##  5 5f7f33d6                 58
##  6 6d38bc90                 66
##  7 752efd72                 71
##  8 a624fb9a                 70
##  9 a756bc39                 41
## 10 ab18b151                 19
## 11 ad0a39f5                 86
## 12 afdd9a78                 12
## 13 f454e660                 55
FarmName_Pseudo SillbornCalfReference SourceFileDate OriginalFileSource dwh_factCowStillborn_Id
169e580a Dödfödd - {04558054-e366-4b12-bceb-d79879b884f6} 2021-02-05 ab18b151_culled_v1_20210720.csv 87
540275a1 Dödfödd - {1072dd20-37bc-42c9-88a1-da111533402e} 2021-09-14 169e580a_culled_v1_20210205.csv 19
f454e660 Dödfödd - {00b1bb51-5c1b-45c3-b7e5-d04904774850} 2021-11-20 5f7f33d6_culled_v1_20230428.csv 40
ad0a39f5 Dödfödd - {04039c17-5e9b-4ce5-a101-7ec1c59c0c5f} 2022-08-11 169e580a_culled_v1_20210205.csv 29
ad0a39f5 Dödfödd - {0e0920eb-b73b-4517-9a27-2435af310a7f} 2022-06-03 a624fb9a_culled_20200131.csv 42
5c06d92d Dödfödd - {0ac0091d-c5b0-4db0-af3a-f6e89a25c98a} 2020-10-20 5f7f33d6_culled_v1_20230428.csv 99
5f7f33d6 Dödfödd - {2225e50a-262d-4a03-82f0-321dbfb911f1} 2022-08-19 f454e660_culled_20220709.csv 51
169e580a Dödfödd - {0b4fce2b-e482-48f7-a7cb-3ebacaddaa4e} 2023-02-18 5c06d92d_culled_v1_20211120.csv 54
169e580a Dödfödd - {137b4ebd-f925-4dc8-8a2a-74b1abc7fbe0} 2021-02-05 752efd72_culled_v1_20201127.csv 45
540275a1 Dödfödd - {1c21acd9-0db1-4ab9-a1c1-2c3f0e4539e0} 2023-08-29 169e580a_culled_v1_20231001.csv 70

The Gigacow database currently contain 878 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: 5 × 3
##   FarmName_Pseudo nrTraffic nrAnimals
##   <chr>               <int>     <int>
## 1 afdd9a78            56745        55
## 2 5b581702          4424117       145
## 3 5f7f33d6            17556       214
## 4 a624fb9a          3466839       250
## 5 f454e660         17960630       350
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-0675 469 556 Vms kor (144 platser) 2023-02-01 06:29:39 Korridor 00:10 720 Utgångsgrind Har inte passerat, fortfarande inne Korridor NA NA NA NA 5b581702_traffic_20230319.csv 85
5b581702 SE-f454e660-0588 460 8475 Vms kor 2021-12-06 19:57:58 Liggavdelning 00:52 3120 Utgångsgrind Avskild Vänster till Mjölkfålla NA NA NA NA a624fb9a_traffic_20231214.csv 12
f454e660 SE-f454e660-2405 509 674 Vms kor (144 platser) 2022-09-24 12:51:41 Korridor 00:00 120 MS1 Endast passering till MS1 NA NA NA NA f454e660_traffic_20220607.csv 11
5b581702 SE-f454e660-0444 407 8287 VMS 1 2023-04-30 09:53:16 Foderbord 00:03 600 Utgångsgrind Avvisad Obs kor NA NA NA f454e660_traffic_20230510.csv 18
f454e660 SE-f454e660-0465 650 12724 Vms kor (144 platser) 2023-08-09 17:16:25 Koridor till Sorteringsgrind 2 05:13 420 Utgångsgrind Har inte passerat, fortfarande inne Korridor Alla kor NA NA NA 5b581702_traffic_20220123.csv 1
f454e660 SE-f454e660-459 799 13563 VMS 1 2022-06-17 23:30:19 MS2 00:05 300 Ingångsgrind Avskild Höger till Liggavdelning Utfodringskor NA NA NA f454e660_traffic_20220514.csv 9
5b581702 SE-f454e660-0503 686 5746 Vms kor 2022-04-13 06:00:58 Korridor 01:53 180 MS1 Avskild Mitten till Obs grupp Kor utan mjölktillstånd NA NA NA f454e660_traffic_20221104.csv 99
f454e660 SE-f454e660-559 573 5013 Vms kor 2020-12-02 16:08:56 Foderbord 00:09 3420 Vms 1 Endast passering till MS1 Kraftfoder NA NA NA f454e660_traffic_20221026.csv 89
f454e660 SE-f454e660-663 490 7851 Vms kor (144 platser) 2022-04-17 19:15:23 Korridor 00:07 780 Utgångsgrind Släpp igenom till Korridor NA NA NA NA f454e660_traffic_20220108.csv 86
f454e660 SE-f454e660-407 629 8562 Vmskor 2022-06-05 08:14:34 Foderbord 00:04 60 MS1 Har inte passerat, fortfarande inne Korridor Alla kor NA NA NA f454e660_traffic_20220830.csv 26

The Gigacow database currently contain 25925887 gate passages by 1014 animals in farms participating in Gigacow.