I downloaded this and loaded into MySQL database.
I noticed the following problems.
It has lots of taxa missing EOLid
Even records with taxonomicStatus=valid have EOLid missing.
Same taxonRank appears twice in a hierarchy
taxon such as Mammalia(class) comes after Therapsida(order),
which is after Sarcopterygii(class) and Mammalia has 4 orders as children.
class and order are repeated in a tree.
Too many Synonym records
taxonomicStatus=synonym records are unnecessary in my opinion.
They do not have parentTaxonID so you can not place them in a hierarchy.
I think you can delete them entirely from this dataset if you don’t bother to place them in the heirarchy.
Canonical names sometimes have " and " at the end of it.
What is the reason for it?