MO issues¶
- Table of contents
- MO issues
for refreshed data:¶
query¶
SELECT * FROM "MO"."Specimen.errors"
ORDER BY "column", error_code, value, error
for pre-refresh data:¶
Some dates contain 2/29 for a non-leap year¶
Rows affected: 148
Sample row:
CatalogNumber | DayCollected | MonthCollected | YearCollected |
8986 | 29 | 2 | 1991 |
Error:
ValueError: day is out of range for month
Some dates have a year of 0¶
Rows affected: 14
Sample row:
CatalogNumber | DayCollected | MonthCollected | YearCollected |
21575 | 6 | 12 | 0 |
Error: Invalid year