Mammal Species & Taxonomic Changes
Taxonomic Changes & Type Specimen Metadata
@kaggle.thedevastator_mdd_v1_10_6615_mammal_species_taxonomic_changes
Taxonomic Changes & Type Specimen Metadata
@kaggle.thedevastator_mdd_v1_10_6615_mammal_species_taxonomic_changes
CREATE TABLE diff_v1_9_v1_10 (
"mddv1_9_name" VARCHAR,
"mddv1_10_name" VARCHAR,
"comment" VARCHAR,
"category" VARCHAR,
"reference" VARCHAR
);
CREATE TABLE mdd_v1_10_6615species (
"sciname" VARCHAR,
"id" BIGINT,
"phylosort" BIGINT,
"maincommonname" VARCHAR,
"othercommonnames" VARCHAR,
"subclass" VARCHAR,
"infraclass" VARCHAR,
"magnorder" VARCHAR,
"superorder" VARCHAR,
"order" VARCHAR,
"suborder" VARCHAR,
"infraorder" VARCHAR,
"parvorder" VARCHAR,
"superfamily" VARCHAR,
"family" VARCHAR,
"subfamily" VARCHAR,
"tribe" VARCHAR,
"genus" VARCHAR,
"subgenus" VARCHAR,
"specificepithet" VARCHAR,
"authorityspeciesauthor" VARCHAR,
"authorityspeciesyear" BIGINT,
"authorityparentheses" BIGINT,
"originalnamecombination" VARCHAR,
"authorityspeciescitation" VARCHAR,
"authorityspecieslink" VARCHAR,
"holotypevoucher" VARCHAR,
"holotypevoucheruris" VARCHAR,
"typelocality" VARCHAR,
"typelocalitylatitude" VARCHAR,
"typelocalitylongitude" VARCHAR,
"nominalnames" VARCHAR,
"taxonomynotes" VARCHAR,
"taxonomynotescitation" VARCHAR,
"distributionnotes" VARCHAR,
"distributionnotescitation" VARCHAR,
"subregiondistribution" VARCHAR,
"countrydistribution" VARCHAR,
"continentdistribution" VARCHAR,
"biogeographicrealm" VARCHAR,
"iucnstatus" VARCHAR,
"extinct" BIGINT,
"domestic" BIGINT,
"flagged" BIGINT,
"cmw_sciname" VARCHAR,
"diffsincecmw" BIGINT,
"msw3_matchtype" VARCHAR,
"msw3_sciname" VARCHAR,
"diffsincemsw3" BIGINT
);
CREATE TABLE meta_v1_10 (
"n" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE typespecimenmetadata_v1_10 (
"abbreviation" VARCHAR,
"full_name" VARCHAR,
"city_and_country" VARCHAR,
"synonyms_notes" VARCHAR,
"online_website_database_if_available" VARCHAR
);
Anyone who has the link will be able to view this.