Project

General

Profile

MO issues

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