User contributions
Jump to navigation
Jump to search
- 18:49, 3 July 2026 diff hist +55 Conversion Data Issues →* (#95) There is at least one food_bout rows where the start or stop time has a seconds value.
- 18:46, 3 July 2026 diff hist +15 Conversion Data Issues →* (#94) There are food_bout rows where the start or end of the observation is outside of allowable bounds.
- 18:46, 3 July 2026 diff hist +28 Conversion Data Issues →* (#94) There are food_bout rows where the start or end of the observation is outside of allowable bounds.
- 18:45, 3 July 2026 diff hist +53 Conversion Data Issues →* (#93) Need to address how we treat behaviours for the second value of food parts AND how they are derived.
- 18:44, 3 July 2026 diff hist +104 Conversion Data Issues →* (#92) There are food_bout rows that do not have a corresponding follow.
- 18:43, 3 July 2026 diff hist -1 Conversion Data Issues →* (#92) There are food_bout rows that do not have a corresponding follow.
- 18:42, 3 July 2026 diff hist +38 Conversion Data Issues →* (#91) There are food_bout rows that have fb_begin_feed_time > fb_end_feed_time.
- 18:41, 3 July 2026 diff hist +75 Conversion Data Issues →* (#90) There are food_bout rows for which the fb_fpl_local_food_part or fb_fpl_local_food_part2 does not have a matching value in codes.food_parts.
- 18:40, 3 July 2026 diff hist +36 Conversion Data Issues →* (#89) There is a food_bout row that has both a compound fb_fpl_local_food_part value and where fb_fpl_local_food_part2 is not null.
- 18:38, 3 July 2026 diff hist +112 Conversion Data Issues →* (#88) There are food_bout rows for which there is not a corresponding food name.
- 18:37, 3 July 2026 diff hist +54 Conversion Data Issues →* (#87) There are numerous duplicate fl_sci_food_name_gen values in food_lookup.
- 18:34, 3 July 2026 diff hist +68 Conversion Data Issues →* (#86) There are numerous instances in the food_part_lookup that that conflate name, initial, and/or the english translation.
- 18:31, 3 July 2026 diff hist +72 Conversion Data Issues →* (#85) There are numerous instances of local food names that translate to multiple scientific food names.
- 18:29, 3 July 2026 diff hist +31 Conversion Data Issues →* (#84) Some follows have a community with trailing spaces
- 18:28, 3 July 2026 diff hist +74 Conversion Data Issues →* (#83) There are AGGRESSION_EVENT rows where the Actor and Actee have the same animal ID.
- 18:27, 3 July 2026 diff hist +80 Conversion Data Issues →* (#82) There are AGGRESSION_EVENT rows where severity (ae_fight_category) is not an allowable value.
- 18:20, 3 July 2026 diff hist +65 Conversion Data Issues →* (#81) There are AGGRESSION_EVENT rows where ae_time is NULL or outside the allowable window ('04:00:00', '20:00:00').
- 18:19, 3 July 2026 diff hist +104 Conversion Data Issues →* (#80) There are AGGRESSION_EVENT rows where ae_aggressor_behavior is NULL or an empty string.
- 18:17, 3 July 2026 diff hist +44 Conversion Data Issues →* (#79) There are AGGRESSION_EVENT participants outside their valid study participation window in the biography data.
- 18:15, 3 July 2026 diff hist +34 Conversion Data Issues →* (#78) There are AGGRESSION_EVENT rows where ae_full_description is NULL or an empty string.
- 18:14, 3 July 2026 diff hist +33 Conversion Data Issues →* (#77) There are AGGRESSION_EVENT rows where ae_recipient_behavior is NULL or an empty string.
- 18:14, 3 July 2026 diff hist +2 Conversion Data Issues →* (#76) There are AGGRESSION_EVENT rows where the Actor/Actee are not in the biography table.
- 18:13, 3 July 2026 diff hist +112 Conversion Data Issues →* (#76) There are AGGRESSION_EVENT rows where the Actor/Actee are not in the biography table.
- 18:10, 3 July 2026 diff hist +81 Conversion Data Issues →* (#75) There are AGGRESSION_EVENT records where ae_extracted_by values are not in the people table.
- 18:09, 3 July 2026 diff hist +28 Conversion Data Issues →* (#74) There are AGGRESSION_EVENT event flags (multiple columns) that have values other than X or NULL.
- 18:06, 3 July 2026 diff hist +123 Conversion Data Issues →* (#73) There are AGGRESSION_EVENT aggression_event.ae_b_recipient_id values that are NULL.
- 18:00, 3 July 2026 diff hist +35 Conversion Data Issues →* (#72) There are AGGRESSION_EVENT recipient certainty flags other than `Y` or `N` (required).
- 17:53, 3 July 2026 diff hist +23 Conversion Data Issues →* (#71) There are AGGRESSION_EVENT animal ids that are not reflected in among FOLLOW animal ids.
- 17:52, 3 July 2026 diff hist +53 Conversion Data Issues →* (#70) There are AGGRESSION_EVENT rows that do not have a matching FOLLOW for the same focal ID and date.
- 17:51, 3 July 2026 diff hist +30 Conversion Data Issues →* (#69) There are duplicate year*community records in AGGRESSION_EVENT_LOG
- 17:49, 3 July 2026 diff hist +6 Conversion Data Issues →Solution
- 17:48, 3 July 2026 diff hist +6 Conversion Data Issues →Solution
- 17:46, 3 July 2026 diff hist +20 Conversion Data Issues →Solution
- 17:43, 3 July 2026 diff hist -2 Conversion Data Issues →* (#53) There are follow_arrivals where the arriving chimp does not exist
- 17:43, 3 July 2026 diff hist +57 Conversion Data Issues →Solution
- 17:33, 3 July 2026 diff hist +28 Conversion Data Issues →Solution
- 17:30, 3 July 2026 diff hist +38 Conversion Data Issues →Solution
- 17:28, 3 July 2026 diff hist -3 Conversion Data Issues →* (#44) There are follow arrivals where the arriving chimp arrives before being under study
- 17:28, 3 July 2026 diff hist +16 Conversion Data Issues →Solution
- 17:26, 3 July 2026 diff hist +124 Conversion Data Issues →Solution
- 19:27, 19 May 2026 diff hist -2 Conversion Data Issues →* (#49) There are follow_arrivals where females that are too old have a cycle code of U
- 19:27, 19 May 2026 diff hist +136 Conversion Data Issues →Solution
- 19:16, 19 May 2026 diff hist +38 Conversion Data Issues →Solution
- 19:14, 19 May 2026 diff hist +35 Conversion Data Issues →Solution
- 19:13, 19 May 2026 diff hist +64 Conversion Data Issues →Solution
- 23:19, 7 May 2026 diff hist +230 Conversion Data Issues →Solution
- 21:48, 6 May 2026 diff hist -269 Conversion Data Issues →Solution
- 23:09, 5 May 2026 diff hist +375 Conversion Data Issues →Solution
- 22:51, 25 March 2026 diff hist +17 Conversion Data Issues →* (#64) There are follow_arrival rows with NULL fa_type_of_certainty values
- 22:46, 25 March 2026 diff hist +23 Conversion Data Issues →* (#60) Invalid biography_update_log.made_by values