MO issues¶

• Table of contents
• MO issues
  • for refreshed data:
    • query
  • for pre-refresh data:
  • Some dates contain 2/29 for a non-leap year
  • Some dates have a year of 0

for refreshed data:¶

see *MO_data_issues.xls*

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