Skip to contents

Code here written by Erica Krimmel.

Here, we explore a situation where data from the provider were modified by iDigBio during ingestion as part of its data quality processing. Understanding how data were modified can help collections staff identify updates that need to be made on their specimen records as well as issues that the aggregator may need to remedy in their data quality processing.

General Overview

In this demo we will cover how to:

  1. Write a query to search for specimens using idig_search_records
  2. Compare the difference between the data providers and aggregators data
  3. Identify specimen records that need to be reviewed

Load Packages

# Load core libraries; install these packages if you have not already
library(ridigbio)
library(tidyverse)

# Load library for making nice HTML output
library(kableExtra)

Write a query to search for specimen records

First, let’s find all the specimen records from a given recordset, e.g. all of the records published by a single collection. Do this using the idig_search_records function from the ridigbio package. You can learn more about this function from the iDigBio API documentation and ridigbio documentation. In this example, we want to start by searching for specimens from the Invertebrate Paleontology collection at the Natural History Museum of Los Angeles.

# Edit the value after `recordset` to search for data from a different collection
# and the fields (e.g. `uuid`) in `fields` to adjust the columns returned in
# your results
df_names <- idig_search_records(rq = list(recordset = "5082e6c8-8f5b-4bf6-a930-e3e6de7bf6fb"),
                    fields = c("uuid",
                               "data.dwc:occurrenceID",
                               "data.dwc:catalogNumber",
                               "family",
                               "data.dwc:family",
                               "genus",
                               "data.dwc:genus",
                               "specificepithet",
                               "data.dwc:specificEpithet",
                               "infraspecificepithet",
                               "data.dwc:infraspecificEpithet",                             
                               "data.dwc:scientificName",
                               "flags"),
                    # Set the limit for how many records are returned by the
                    # search to a low number for the purposes of this demo
                    limit = 1000) %>% 
  # Rename fields to more easily reflect their provenance (either from the
  # data provider directly or modified by the data aggregator)
  rename(occurrenceID = `data.dwc:occurrenceID`,
         catalogNumber = `data.dwc:catalogNumber`,
         provider_family = `data.dwc:family`,
         provider_genus = `data.dwc:genus`,
         provider_species = `data.dwc:specificEpithet`,
         provider_subspecies = `data.dwc:infraspecificEpithet`,
         provider_scientificName = `data.dwc:scientificName`,
         aggregator_family = `family`,
         aggregator_genus = `genus`,
         aggregator_species = `specificepithet`,
         aggregator_subspecies = `infraspecificepithet`) %>% 
  # Reorder columns for easier viewing
  select(uuid, occurrenceID, catalogNumber, aggregator_family, provider_family,
         aggregator_genus, aggregator_species, aggregator_subspecies, 
         provider_genus, provider_species, provider_subspecies,
         provider_scientificName, flags)

Here is what our query result data looks like, with the data from the aggregator’s processing highlighted in red text:

uuid occurrenceID catalogNumber aggregator_family provider_family aggregator_genus aggregator_species aggregator_subspecies provider_genus provider_species provider_subspecies provider_scientificName
000153f6-4861-4219-ac9e-f0d0f62fe60b 0b6e2924-4b1a-4a18-a532-6c2d95962e95 LACMIP 42500.14 NA NA NA NA NA NA NA NA Clypeasteroida indet.
000249c8-5c27-4292-94a7-1802f4d1ca4b 37ae5d77-073e-4713-aa54-92d7e0616fcf LACMIP 16817.200 borsoniidae Borsoniidae ophiodermella NA NA Ophiodermella NA NA Ophiodermella sp.
00028446-c91d-47f2-b036-2134f011e282 2933a74c-faeb-4519-9117-6000c9f43926 LACMIP 2657.24 mactridae Mactridae tresus nuttallii NA Tresus nuttallii NA Tresus nuttallii (Conrad, 1837)
00034f81-997b-499f-a176-ac2949facbb9 aecc92f1-1994-41bf-988c-e095ce1ce030 LACMIP 1195.4 fissurellidae Fissurellidae puncturella cooperi NA Puncturella cooperi NA Puncturella cooperi Carpenter, 1864
00038886-e0ca-4893-b454-e90d75f1eaa7 07cfa54b-1f25-4ea2-a0f2-a812f4e0523c LACMIP 16408.1 cirolanidae Cirolanidae palaega goedertorum NA Palaega goedertorum NA Palaega goedertorum Wieder & Feldmann, 2016
0003949f-4780-4283-bab1-8e8fb7a71841 be239c5f-fbdc-4062-b0d5-1a7f6074665e LACMIP 351.105 ceratopogonidae Ceratopogonidae NA NA NA NA NA NA Ceratopogonidae indet.
0004af95-d2bf-4247-9522-440662c2788f d29d432a-d390-4479-8bf7-552399a5eb0c LACMIP 20651.58 epitoniidae Epitoniidae hirtoscala tinctum NA Hirtoscala tinctum NA Hirtoscala tinctum (Carpenter, 1864)
000587e5-d012-4f50-bc04-52f44e0182d3 b5dc4eb7-6f1a-44b5-a4aa-2d8dd7608293 LACMIP 10099.9 turritellidae Turritellidae turritella hearni NA Turritella hearni NA Turritella hearni Merriam, 1941
00058f4c-855d-423b-a9b5-aaec1b1bd25f 727c3b93-52e8-403c-9e73-2232ac01a37e LACMIP 22382.118 calyptraeidae Calyptraeidae crepidula onyx NA Crepidula NA NA Crepidula sp.
0006606e-53aa-4264-8af3-d55ff9951759 240d0a7f-b29e-45ea-8394-c115ee56e8fd LACMIP 5060.45 pectinidae Pectinidae leptopecten latiauratus NA Leptopecten latiauratus NA Leptopecten latiauratus (Conrad, 1837)
00067a2d-5d0f-47d7-9072-4b9b7b89bd88 e5e3733b-c1d8-4e8c-a435-9a8ac0bbcde4 LACMIP 7290.22 potamididae Potamididae cerithidea californica NA Cerithideopsis californica NA Cerithideopsis californica (Haldeman, 1840)
00077744-a544-453a-b1bf-ad634d94eacf 6ab4f80d-0d1a-4ae2-aabf-acc155320a1d LACMIP 31257.62 nassariidae Nassariidae hima mendica NA Hima mendica NA Hima mendica (Gould, 1849)
0007cf26-5306-4f2f-a585-94a319069820 2fe4c7be-6ca2-4b06-846a-d6869a032b82 LACMIP 42484.30 olividae Olividae callianax alectona NA Callianax alectona NA Callianax alectona (Duclos, 1835)
0007d63a-b15e-4cd5-9154-53a6204c0e41 e87ad9af-e536-4303-a622-048892bf4dae LACMIP 2533.3708 NA NA NA NA NA NA NA NA Coleoptera indet.
0007f380-2797-40fe-8071-a836be493f5b 22d202d2-ce38-467c-aa2e-778070a37c3f LACMIP 22848.1 gaudryceratidae Gaudryceratidae eogaudryceras hertleini NA Eogaudryceras hertleini NA Eogaudryceras hertleini (Wiedmann, 1962)
0009b3cf-ba45-4631-ad9f-b8e84b690bdf 341ca08b-892f-40bf-8ad0-00a9a1aa8208 LACMIP 260.336 NA NA NA NA NA NA NA NA Diptera indet.
000ae0be-f613-43cf-a2bf-0eaefe5eedb8 c3f51eee-ecc6-4d35-b05e-7b1dac915e7e LACMIP 42035.31 conidae Conidae conus californicus NA Californiconus californicus NA Californiconus californicus (Reeve, 1844)
000ba35c-8bea-4528-b1cf-bbbb15d9a68d 17750fa4-8422-4fd7-8167-9a31c00e0096 LACMIP 5090.6 tellinidae Tellinidae macoma astori NA Macoma astori NA Macoma (Rexithaerus) astori Dall, 1909
000bb3a9-7161-4c90-ad21-f28b0aac7f15 911b1326-38b2-4946-9eb4-61aaa3ca812a LACMIP 23225.88 littorinidae Littorinidae lacuna unifasciata NA Lacuna unifasciata NA Lacuna (Epheria) unifasciata Carpenter, 1857
000d25fe-9b7c-4a8a-b200-23b8643adee1 5d3319d4-a595-4f10-a897-e82d29eb5032 LACMIP 2533.1396 incertae sedis Incertae sedis NA NA NA NA NA NA Anisoptera indet.
000d50ee-faa7-4cf7-a276-cded9bc2b92d 2d4ec77f-c893-4595-bb3c-299f23ef09be LACMIP 22404.62 lucinidae Lucinidae lucinoma annulata NA Lucinoma annulatum NA Lucinoma annulatum (Reeve, 1850)
000ea1d1-128a-4963-b1e2-2a142d91a32b 9824ec2c-4122-4196-a1df-4763e78450f8 LACMIP 2533.1797 notonectidae Notonectidae notonecta glauca NA Notonecta NA NA Notonecta sp.
000eb38d-2ae0-4475-814e-c9ca812be6b1 d158b0eb-bb73-4afe-95fc-5d220dd2be0c LACMIP 17898.333 NA NA NA NA NA NA NA NA Insecta indet.
000fa3fc-5311-475a-80d5-30b638db3db3 a65ffe73-68d1-457a-a4c7-4bce55bd81f5 LACMIP 10101.2 nuculidae Nuculidae acila demessa NA Acila demessa NA Acila (Truncacila) demessa Finlay, 1927
000fec10-9144-4b0d-b88c-a06a27b9f380 e26c1d53-ecb6-41b0-aedb-944306bafd29 LACMIP 29180.20 NA NA NA NA NA NA NA NA Bivalvia indet.
000ffcfb-9ea0-44ad-a1d3-a000b180d400 e0d808f9-77fb-4321-80eb-b86b4733e2b1 LACMIP 17095.4 inoceramidae Inoceramidae cataceramus subundatus NA Cataceramus subundatus NA Cataceramus subundatus (Meek, 1861)
00105f0e-4f02-4cf6-924d-24334aa36168 27f4bacb-b697-49a0-896d-883356825c69 LACMIP 21589.7 turritellidae Turritellidae turritella peninsularis quaylei Turritella peninsularis quaylei Turritella peninsularis quaylei Saul, 1983
0010a364-e56e-41a0-80da-bc7ec0f580f0 aa2aa1a1-c6cb-47d7-9254-10a87f05a014 LACMIP 23153.5 turritellidae Turritellidae mesalia martinezensis NA Mesalia martinezensis NA Mesalia martinezensis (Gabb, 1869)
00112f80-1f0f-4cce-9f58-fb58142b4cea 5b9c0097-95d3-457c-9a12-69d5a6b3c0ec LACMIP 29233.34 nuculidae Nuculidae acila haidana NA Acila haidana NA Acila (Truncacila) haidana Packard in Schenck, 1936
00113821-2386-425a-bfe7-b86b30c3571a 4df5ade2-6242-402c-b44e-4f74a0f263af LACMIP 8226.206 naticidae Naticidae neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839)
0011e9dc-aea8-4909-b277-671f660572b0 c8a22b89-070a-4101-b1fe-6bd3558ae098 LACMIP 20187.59 naticidae Naticidae neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839)
00121bbf-0162-47aa-9d66-70825c61853f 3b4e0b4a-0529-42e9-8ca8-a31f1b18746c LACMIP 129.10 veneridae Veneridae leukoma laciniata NA Leukoma laciniata NA Leukoma laciniata (Carpenter, 1864)
0012598c-c37c-4d8c-a03f-26f4910b04df 8db53592-bad0-4142-a4ac-3e73109c9a9e LACMIP 25446.101 buccinidae Buccinidae neptunea tabulata NA Neptunea tabulata NA Neptunea (Sulcosipho) tabulata (Baird, 1863)
0012ce1c-6297-4854-9a89-a4ea3627b960 8b13250e-5e43-48c2-a4ec-e77352a7c0dc LACMIP 20341.1 hiatellidae Hiatellidae panopea whitfieldi NA Panopea NA NA Panopea sp.
00130464-1faf-4526-be44-a8595f829352 b61872a5-b278-446f-8834-99e070792e72 LACMIP 421.73 pectinidae Pectinidae spathochlamys vestalis NA Spathochlamys vestalis NA Spathochlamys vestalis (Reeve, 1853)
00139f82-3cb1-491f-a95a-c90207af164d 989f4361-d944-4ff8-ac01-3c4ebb538265 LACMIP 23637.185 buccinidae Buccinidae “cominella” lecontei NA “Cominella” lecontei NA “Cominella” lecontei White, 1889
0013c23e-b64b-4737-9c7b-b8d8149934b8 e7c33bee-f096-47d9-9ee0-b699eada698d LACMIP 21054.29 ostreidae Ostreidae ostrea conchaphila NA Ostrea conchaphila NA Ostrea conchaphila Carpenter, 1857
00141151-babc-484d-b904-02aced161e7a 5f5e0c91-7158-4cac-9932-e1f5a5855d46 LACMIP 7205.93 calyptraeidae Calyptraeidae crepidula dorsata NA Crepipatella dorsata NA Crepipatella dorsata (Broderip, 1834)
0014b73a-4ca3-4937-8e99-c5cbb35ca431 220b3f78-5957-43c8-97c4-8154b3619b74 LACMIP 2533.2188 incertae sedis Incertae sedis NA NA NA NA NA NA Nematocera indet.
00150998-6357-44f4-9ffc-b8dd6b2fe00a 825e53ba-6813-48ff-9fee-cc04e380f011 LACMIP 6953.58 ostreidae Ostreidae ostrea conchaphila NA Ostrea conchaphila NA Ostrea conchaphila Carpenter, 1857
0015396f-d1f6-48de-b015-6ebc1ea073cd 7955b9a4-ad58-4547-92f7-73714bdf8781 LACMIP 5848.2 cancridae Cancridae romaleon wahkiakumensis NA Romaleon wahkiakumensis NA Romaleon wahkiakumensis (Berglund & Goedert, 1992)
00156735-151c-40ec-af32-e95b70c7abe5 d19de809-af30-4ff7-b5a6-db4c552a3d24 LACMIP 23225.542 pseudomelatomidae Pseudomelatomidae rectiplanes voyi NA Rectiplanes voyi NA Rectiplanes voyi (Gabb, 1866)
0015acac-ae8e-4fef-89fd-3b142bbc33da 9a6ca880-b352-4465-b01e-cda524b881ba LACMIP 10843.10 glycymerididae Glycymerididae glycymerita huttoni NA Glycymerita veatchii NA Glycymerita veatchii (Gabb, 1864)
0015fe85-ea75-4ac5-9c85-c1d33f6e7fa3 b796ab8d-3911-41f9-a64d-2b0290c3b6f9 LACMIP 41662.37 NA NA NA NA NA NA NA NA Bryozoa indet.
00166dc8-789f-4fb1-95c7-e41f745fe098 d24bfa37-2ab7-4bb9-b3cf-f2bfafe6a2ce LACMIP 2056.4 tegulidae Tegulidae tegula funebralis NA Chlorostoma funebralis NA Chlorostoma funebralis (A. Adams, 1855)
001714ef-e925-4325-9e53-cd936c8f6568 b6c81107-63a8-4733-bac0-c3434524b7df LACMIP 5868.196 lucinidae Lucinidae lucinoma annulata NA Lucinoma annulatum NA Lucinoma annulatum (Reeve, 1850)
00173dc6-2ae1-4cfa-a04c-64f312920bfe 472a09f7-dc72-496a-b55e-22bed92acd26 LACMIP 31276.115 mactridae Mactridae mactrotoma californica NA Mactrotoma californica NA Mactrotoma californica (Conrad, 1837)
00176285-ecef-4407-9105-3b16b92c9145 591250af-2ac8-4511-b86e-7d74e2fbf19d LACMIP 41688.16 arcidae Arcidae arca sisquocensis NA Arca sisquocensis NA Arca sisquocensis Reinhart, 1937
0017c563-b6a4-4d5f-8552-814d6d5bf31e 19cddaa9-752a-482c-a95a-1d8106c4bbfc LACMIP 2533.757 hydrophilidae Hydrophilidae berosus morticinus NA Berosus morticinus NA Berosus (Berosus) morticinus (Heyden & Heyden, 1866)
00183af0-7b5a-4d2d-8ceb-90b50dbd375c 77f1f34a-8f65-48fb-b9e5-c81416e640b1 LACMIP 42035.85 naticidae Naticidae neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839)

Explore differences in the data

We can already see that there are some formatting differences between the data from the provider and that modified by the aggregator. For example, iDigBio converts all data to lowercase, which was historically useful for standardizing and indexing data across all of the recordsets represented in the iDigBio database. Family and genus names are capitalized by convention, so we will reformat those fields here:

# Reformat aggregator fields to title case
df_names <- df_names %>% 
  mutate(aggregator_family = str_to_title(aggregator_family)) %>% 
  mutate(aggregator_genus = str_to_title(aggregator_genus))

# Subset `df_names` to show example
df_names[1:5,] %>% 
  select(-flags) %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed"),
                font_size = 12,
                fixed_thead = T) %>% 
  column_spec(c(4,6,7,8), color = "red") %>% 
  scroll_box(width = "100%", height = "400px")
uuid occurrenceID catalogNumber aggregator_family provider_family aggregator_genus aggregator_species aggregator_subspecies provider_genus provider_species provider_subspecies provider_scientificName
000153f6-4861-4219-ac9e-f0d0f62fe60b 0b6e2924-4b1a-4a18-a532-6c2d95962e95 LACMIP 42500.14 NA NA NA NA NA NA NA NA Clypeasteroida indet.
000249c8-5c27-4292-94a7-1802f4d1ca4b 37ae5d77-073e-4713-aa54-92d7e0616fcf LACMIP 16817.200 Borsoniidae Borsoniidae Ophiodermella NA NA Ophiodermella NA NA Ophiodermella sp.
00028446-c91d-47f2-b036-2134f011e282 2933a74c-faeb-4519-9117-6000c9f43926 LACMIP 2657.24 Mactridae Mactridae Tresus nuttallii NA Tresus nuttallii NA Tresus nuttallii (Conrad, 1837)
00034f81-997b-499f-a176-ac2949facbb9 aecc92f1-1994-41bf-988c-e095ce1ce030 LACMIP 1195.4 Fissurellidae Fissurellidae Puncturella cooperi NA Puncturella cooperi NA Puncturella cooperi Carpenter, 1864
00038886-e0ca-4893-b454-e90d75f1eaa7 07cfa54b-1f25-4ea2-a0f2-a812f4e0523c LACMIP 16408.1 Cirolanidae Cirolanidae Palaega goedertorum NA Palaega goedertorum NA Palaega goedertorum Wieder & Feldmann, 2016

Let’s use the power of R to filter out data that have not been modified so that we can focus on rows where the aggregator has made changes. As an example, we will look at rows where the genus name does not match between the provider and the aggregator:

# Filter for rows where genus does not match
df_names %>% 
  filter(provider_genus != aggregator_genus) %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed"),
                font_size = 12,
                fixed_thead = T) %>% 
  column_spec(c(4,6,7,8), color = "red") %>% 
  scroll_box(width = "100%", height = "400px")
uuid occurrenceID catalogNumber aggregator_family provider_family aggregator_genus aggregator_species aggregator_subspecies provider_genus provider_species provider_subspecies provider_scientificName flags
00067a2d-5d0f-47d7-9072-4b9b7b89bd88 e5e3733b-c1d8-4e8c-a435-9a8ac0bbcde4 LACMIP 7290.22 Potamididae Potamididae Cerithidea californica NA Cerithideopsis californica NA Cerithideopsis californica (Haldeman, 1840) rev_geocode_eez , geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
000ae0be-f613-43cf-a2bf-0eaefe5eedb8 c3f51eee-ecc6-4d35-b05e-7b1dac915e7e LACMIP 42035.31 Conidae Conidae Conus californicus NA Californiconus californicus NA Californiconus californicus (Reeve, 1844) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added
00113821-2386-425a-bfe7-b86b30c3571a 4df5ade2-6242-402c-b44e-4f74a0f263af LACMIP 8226.206 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0011e9dc-aea8-4909-b277-671f660572b0 c8a22b89-070a-4101-b1fe-6bd3558ae098 LACMIP 20187.59 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00141151-babc-484d-b904-02aced161e7a 5f5e0c91-7158-4cac-9932-e1f5a5855d46 LACMIP 7205.93 Calyptraeidae Calyptraeidae Crepidula dorsata NA Crepipatella dorsata NA Crepipatella dorsata (Broderip, 1834) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00166dc8-789f-4fb1-95c7-e41f745fe098 d24bfa37-2ab7-4bb9-b3cf-f2bfafe6a2ce LACMIP 2056.4 Tegulidae Tegulidae Tegula funebralis NA Chlorostoma funebralis NA Chlorostoma funebralis (A. Adams, 1855) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_taxonomicstatus_added , dwc_originalnameusageid_added , gbif_canonicalname_added , gbif_taxon_corrected , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonid_added , dwc_parentnameusageid_added
00183af0-7b5a-4d2d-8ceb-90b50dbd375c 77f1f34a-8f65-48fb-b9e5-c81416e640b1 LACMIP 42035.85 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
001eb465-05cb-4ff1-9c7d-3b0217d1a03c 00cc7a85-a440-40dd-955b-0e13a2a8ef98 LACMIP 41678.50 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
002122b5-714f-4c17-8718-c8ff1d250c7b 3e6695d5-5747-4c40-b562-05a2684d79da LACMIP 21055.13 Tegulidae Tegulidae Tegula montereyi NA Chlorostoma montereyi NA Chlorostoma montereyi (Kiener, 1850) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
002440ab-2a15-46db-aa8f-c043b4e143dc 37b0e696-1328-4c5d-9884-def9b9026df9 LACMIP 16521.17 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0025fcb8-8f8d-48af-9662-a579cf631b99 6c739c75-5c26-4fd1-8520-55a1523614a9 LACMIP 3936.94 Epitoniidae Epitoniidae Epitonium indianorum NA Hirtoscala indianorum NA Hirtoscala indianorum (Carpenter, 1864) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00317c86-c463-4c45-8c23-f9fdcd363a25 d9d6e433-73e9-4e96-937c-fd381e329855 LACMIP 66.873 Naticidae Naticidae Glossaulax draconis NA Euspira draconis NA Euspira draconis (Dall, 1903) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_originalnameusageid_added , gbif_canonicalname_added , gbif_taxon_corrected , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_parentnameusageid_added
0040542c-ed12-4dba-9246-325ab81cf27e 99fad840-f82e-4e63-bb97-72acd55a2d8a LACMIP 23393.9 Chamidae Chamidae Pseudochama exogyra NA Chama exogyra NA Chama exogyra Conrad, 1837 rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_order_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_originalnameusageid_added , gbif_canonicalname_added , gbif_taxon_corrected , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_parentnameusageid_added
00420e9a-1b9d-4638-93e4-a14f20b23103 bd22b32b-ab88-40ad-afe6-6b7310209185 LACMIP 77.139 Cardiidae Cardiidae Americardia media NA Mexicardia procerum NA Mexicardia procerum (Sowerby I, 1833) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_order_replaced , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0049f8e1-ed87-4c0e-81df-f03cd5012fb6 2db62d06-4c59-47d4-8a59-2ac19a5be256 LACMIP 41838.8 Ostreidae Ostreidae Ostrea vespertina NA Dendostrea vespertina NA Dendostrea vespertina (Conrad, 1854) dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_order_replaced , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
004b9842-0e3c-463b-b7c6-da0259f63c88 c68ca582-6b7c-4493-bb7b-dde68e5de18e LACMIP 16815.14 Columbellidae Columbellidae Alia gausapata NA Mitrella gausapata NA Mitrella gausapata (Gould, 1850) geopoint_low_precision , rev_geocode_mismatch , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_parentnameusageid_added , taxon_match_failed , dwc_genus_replaced
00503f61-af2f-4882-ad6a-e59a9d9857a2 b70b1004-32d6-4aff-a533-b17532db1c77 LACMIP 25446.87 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00584135-2041-44b5-896d-6e2eeac20295 28bd8af1-17c0-4b0a-8756-e3ae91ee48e8 LACMIP 17848.45 Cardiidae Cardiidae Cardium brewerii NA Acanthocardia brewerii NA Acanthocardia (Schedocardia) brewerii (Gabb, 1864) geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_order_replaced , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
0058566e-f0f5-4917-81b9-e717953b6d11 e779e326-8582-4b57-98a2-210c9aafc60b LACMIP 23386.27 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00591879-55a9-48df-afa5-32a637f47d5a abdac336-68aa-4e5e-b4e1-73e44bb29c40 LACMIP 229.44 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_vernacularname_added , gbif_canonicalname_added , dwc_originalnameusageid_added, dwc_genus_replaced
005bfaf1-a68a-4734-9d40-7826ce51f35d 298e665b-66a1-423b-be7a-ec6b3dab277b LACMIP 22413.169 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
006495be-7f3d-4180-8940-2200c4f812e1 e3532b29-4b90-41a5-9371-5aabd1acba10 LACMIP 305.1256 Pectinidae Pectinidae Pecten healeyi NA Patinopecten healeyi NA Patinopecten healeyi (Arnold, 1906) geopoint_low_precision , rev_geocode_mismatch , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
006cad27-7f96-4a91-ac9d-e2e2f7be09f3 138071e2-b4a8-4624-8281-e2e2405f91ca LACMIP 18090.4 Ostreidae Ostreidae Ostrea vespertina NA Dendostrea vespertina NA Dendostrea vespertina (Conrad, 1854) geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
006fe4fa-483c-4d4f-a114-2b82e175b2e3 c266471b-54e6-475d-973b-2e23b4253c49 LACMIP 5574.68 Muricidae Muricidae Pteropurpura festiva NA Shaskyus festivus NA Shaskyus festivus (Hinds, 1844) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0072ebfc-76a0-4ac0-ac09-750e611ce0e0 e1a5e47c-bd29-41dd-9126-cf40d604f847 LACMIP 40054.17 Pectinidae Pectinidae Pecten healeyi NA Patinopecten healeyi NA Patinopecten healeyi (Arnold, 1906) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_order_replaced , idigbio_isocountrycode_added , dwc_parentnameusageid_added , dwc_genus_replaced
007da931-eba7-459b-81d0-88018a478a38 d99553e3-67e9-4fd1-82df-09ddd9ac4317 LACMIP 1215.25 Pachydiscidae Pachydiscidae Eupachydiscus catarinae NA Pachydiscus catarinae NA Pachydiscus (Neodesmoceras) catarinae (Anderson & Hanna, 1928) geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , taxon_match_failed , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added
007f0bfc-7829-4507-b94a-61b48c2aaf57 193ad913-1629-4afa-a1de-c3ca4d379054 LACMIP 7002.10 Columbellidae Columbellidae Alia gausapata NA Mitrella gausapata NA Mitrella gausapata (Gould, 1850) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_taxonid_added , dwc_parentnameusageid_added , taxon_match_failed , dwc_genus_replaced
007f4e47-f6da-4749-8b92-8001b85d1581 65bc1734-d437-4ca8-a22c-38d3e44b3853 LACMIP 10328.80 Serpulidae Serpulidae Pyrgopolon onyx NA Hamulus onyx NA Hamulus onyx Morton, 1834 geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
0087bd4a-f55f-497b-9e22-33483a88bfec 7153ae1c-75bd-4f8a-bf68-c90e452c0835 LACMIP 76.18 Lasaeidae Lasaeidae Aligena trigonalis NA Isorobitella trigonalis NA Isorobitella trigonalis (Carpenter, 1857) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00886c2e-99cf-4793-bf03-7560789fbc7e f21cb736-d86a-4752-846a-70a705b19d05 LACMIP 10105.210 Mactridae Mactridae Mactra stantoni NA Cymbophora stantoni NA Cymbophora stantoni (Arnold, 1908) geopoint_low_precision , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
008924fa-cb1e-4353-81e4-743fc73b6fb8 7e313c7f-c58d-4bdb-9589-4cdae5a3cb45 LACMIP 5041.29 Vermetidae Vermetidae Thylacodes squamigerus NA Serpulorbis squamigerus NA Serpulorbis squamigerus (Carpenter, 1857) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
008d249e-a9b8-4654-b15f-bb7354e537aa 280c5795-9370-4bbe-8d71-9af1441bd93a LACMIP 25992.45 Columbellidae Columbellidae Alia gausapata NA Mitrella gausapata NA Mitrella gausapata (Gould, 1850) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added, dwc_genus_replaced , taxon_match_failed , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
0093696a-2330-4a86-8913-7ed35a2281d5 60b6851e-5919-49c2-88e3-081085400880 LACMIP 5868.5 Conidae Conidae Conus californicus NA Californiconus californicus NA Californiconus californicus (Reeve, 1844) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added
009e4a6e-9283-44f8-bd89-8ffe76475fac 1b024d38-1f0c-47a1-832c-46a5fda6c00e LACMIP 4804.14 Epitoniidae Epitoniidae Epitonium hindsii NA Hirtoscala hindsii NA Hirtoscala hindsii (Carpenter, 1856) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_parentnameusageid_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_taxonid_added , dwc_originalnameusageid_added, dwc_genus_replaced
00a58d86-9cf9-4b88-9bf2-4f428ec4f6ba 18215210-6352-4476-856f-40470062f081 LACMIP 22387.54 Glycymerididae Glycymerididae Glycymeris major NA Glycymerita major NA Glycymerita major (Stanton, 1896) geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
00a9677e-0262-4f78-b470-6541bb12dde0 51751506-dc91-4bc9-b113-e6460b9577b2 LACMIP 22413.218 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00b912fc-a225-4fbd-9b11-2ba629abcbfd 9563b851-14e6-4f38-ab3c-972612d81b37 LACMIP 64.264 Vermetidae Vermetidae Thylacodes squamigerus NA Serpulorbis squamigerus NA Serpulorbis squamigerus (Carpenter, 1857) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
00bcb521-f6b3-4ec7-9b2e-b75770a795d5 dad42ef7-f184-4d46-97f7-3ee288ff25fb LACMIP 30123.64 Cardiidae Cardiidae Cardium coronaensis NA Pachycardium coronaense NA Pachycardium coronaense (Packard, 1922) geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
00bdf59a-c045-4302-80d6-525196c13c48 6618fa60-ce0a-4a5a-b6e1-30db73c0f0f7 LACMIP 59.51 Epitoniidae Epitoniidae Epitonium indianorum NA Hirtoscala indianorum NA Hirtoscala indianorum (Carpenter, 1864) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00cde2a9-08f6-467d-9358-996bc7ce69c5 c281817d-2aa6-4fb9-8b69-59e32a0e1506 LACMIP 2685.9 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_vernacularname_added , gbif_canonicalname_added , dwc_originalnameusageid_added, dwc_genus_replaced
00dbae3f-9973-4ec4-9c8b-7d04d6f36783 d264258b-f47f-481d-a26a-7964ae1923d1 LACMIP 4396.20 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
00e15c79-866d-458b-b1a3-00c8288e6adb b188a191-fb4e-406a-972e-7b2a4e51226e LACMIP 7290.1 Conidae Conidae Conus californicus NA Californiconus californicus NA Californiconus californicus (Reeve, 1844) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added
01119912-24c7-4405-9c1a-d0bf723dbbc0 0769dc81-1085-49b7-b008-1f0ff48f9f34 LACMIP 466.63 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0118a4fb-46f3-4356-ad3b-26af888a937d 6de8d7cc-242d-423e-ac04-f44f97ecefd0 LACMIP 10908.1 Trigoniidae Trigoniidae Protrigonia NA NA Pterotrigonia NA NA Pterotrigonia sp. geopoint_low_precision , idigbio_isocountrycode_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , gbif_canonicalname_added , dwc_scientificnameauthorship_added, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
0135d386-8226-4907-92e5-04ed3ea51ef4 81af9fb2-45e1-4a0c-b8d9-a747756b3e85 LACMIP 409.3 Potamididae Potamididae Cerithidea californica NA Cerithideopsis californica NA Cerithideopsis californica (Haldeman, 1840) geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
013f124a-2b35-465d-affa-bcfbb27b879e 1b3968bb-d69f-41e1-b4eb-1169b266c0a0 LACMIP 23225.599 Muricidae Muricidae Pteropurpura festiva NA Shaskyus festivus NA Shaskyus festivus (Hinds, 1844) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added , dwc_originalnameusageid_added, idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonid_added , dwc_parentnameusageid_added
013fd299-9bc2-4076-a3d1-444cd4cc1706 5cb1861c-621f-452c-9cba-c6bf0c8d8202 LACMIP 10611.17 Tegulidae Tegulidae Tegula funebralis NA Chlorostoma funebralis NA Chlorostoma funebralis (A. Adams, 1855) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
0147e4c3-d7e4-4f23-924d-ce441d6589b9 39a94132-37b4-4e6d-b1f6-04499a9eaefb LACMIP 21801.26 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0157b790-e96e-423b-a055-ff53537f1bc1 f7602217-605f-4571-be3c-46dfa05269dc LACMIP 97.40 Muricidae Muricidae Pteropurpura festiva NA Shaskyus festivus NA Shaskyus festivus (Hinds, 1844) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0167d93a-186b-4c11-91b6-c245ebf384ea 9d138c51-a4dc-4adc-96a5-70c828acba4a LACMIP 18605.1 Pectinidae Pectinidae Pecten healeyi NA Patinopecten healeyi NA Patinopecten healeyi (Arnold, 1906) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
01696b3f-28e9-4312-b042-ae44fc1d149b 36e386c3-105e-4151-9ccc-3c9d87594746 LACMIP 2533.475 Chironomidae Chironomidae Paracladius NA NA Procladius NA NA Procladius sp. geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , idigbio_isocountrycode_added , dwc_scientificnameauthorship_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
01774058-6b93-4f15-ae70-9e5c634af68d 6e2d319f-f3a8-4a1a-b155-2242ef940c85 LACMIP 1499.5 Pterotrigoniidae Trigoniidae Notoscabrotrigonia klamathonia NA Pterotrigonia klamathonia NA Pterotrigonia klamathonia (Anderson, 1958) geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_family_replaced , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
017cac70-9c5e-4189-9770-ecf7a82caf17 a9e7efe1-92a2-4d19-9616-af3b260c681e LACMIP 16204.2 Ostreidae Ostreidae Ostrea vespertina NA Dendostrea vespertina NA Dendostrea vespertina (Conrad, 1854) geopoint_low_precision , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
017d2baa-43b7-4cab-9fd2-4e2169edced6 ca9e6925-b74d-49b6-9e4e-65fd138233af LACMIP 10781.7 Acteonellidae Acteonellidae Actaeonella oviformis NA Acteonella oviformis NA Acteonella oviformis Gabb, 1869 geopoint_low_precision , dwc_taxonrank_replaced , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced
018dfa07-1327-49aa-8116-bdd6baac81aa c5de5a63-9876-418a-a13a-3af22382938a LACMIP 40054.16 Epitoniidae Epitoniidae Epitonium indianorum NA Hirtoscala indianorum NA Hirtoscala indianorum (Carpenter, 1864) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_originalnameusageid_added , dwc_genus_replaced
018eec44-bdca-432a-9144-9cb389f316d6 191b7400-5bef-4b56-8fc6-6c7c2d38b07f LACMIP 7290.29 Fasciolariidae Fasciolariidae Fusinus luteopictus NA Hesperaptyxis luteopictus NA Hesperaptyxis luteopictus (Dall, 1877) rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0195789f-94e0-4d52-84ae-5d0390035d84 2c3a785c-13d6-4430-8268-0a325eb965b3 LACMIP 20259.1 Pectinidae Pectinidae Pecten opuntia NA Chlamys opuntia NA Chlamys opuntia (Dall, 1898) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added
019b6cfc-1525-4c0c-bfc3-40e5ba219ef0 1be3302f-e0b1-4703-a305-b045a4bcd079 LACMIP 5062.114 Vermetidae Vermetidae Thylacodes squamigerus NA Serpulorbis squamigerus NA Serpulorbis squamigerus (Carpenter, 1857) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
01b6d44b-1bb0-4a41-afcf-e266d991ccf1 fad75362-a905-4985-b590-a42a7fc98d16 LACMIP 226.65 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
01b7ba89-5c9b-4c5e-8567-c6ec269ede31 26784e25-70f4-4d75-8a7b-2967dee7178a LACMIP 21940.9 Epitoniidae Epitoniidae Epitonium indianorum NA Hirtoscala indianorum NA Hirtoscala indianorum (Carpenter, 1864) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
01bb2dd9-2e1d-49a9-ae2d-4cc369d726ed c99f4a65-b6f3-434d-9196-603969edef04 LACMIP 10326.26 Serpulidae Serpulidae Pyrgopolon onyx NA Hamulus onyx NA Hamulus onyx Morton, 1834 geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
01c171e8-dbb6-4d11-95f7-c267c1080553 7fc4e114-e3be-4874-9ff4-b33b3e5cbff6 LACMIP 23647.17 Pachydiscidae Pachydiscidae Eupachydiscus grossouvrei NA Pachydiscus buckhami NA Pachydiscus buckhami Usher, 1952 geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added
01c194f0-6b5b-4161-8746-00965a6423ca 90632594-92b8-4116-8b9f-19387ba4d014 LACMIP 23165.10 Glycymerididae Glycymerididae Glycymeris major NA Glycymerita major NA Glycymerita major (Stanton, 1896) geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
01d096ec-c783-4605-b49e-0609205532e1 41f39393-6a7f-4be7-94e2-03ce30ea195c LACMIP 31263.78 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
01d3ad81-682f-4d15-8265-7bc5b1693259 30fc1ed1-b44a-4f8d-b1cc-14c09fceb8f6 LACMIP 26980.18 Bakevelliidae Bakevelliidae Gervillaria alifera NA Gervillia NA NA Gervillia sp. geopoint_low_precision , dwc_taxonrank_replaced , dwc_specificepithet_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_scientificnameauthorship_added, dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
0205cc71-a358-49e3-9b94-c15e92d16db4 f1d27794-ef56-4c7d-8294-29743e2caf03 LACMIP 23633.23 Trigoniidae Trigoniidae Pleurotrigonia jacobseni NA Pterotrigonia evansana NA Pterotrigonia evansana (Meek, 1858) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
020ed019-afc2-45a9-bf36-6a38c306cd51 e2e2f1a5-31a3-4b77-ab32-e6d897ccf046 LACMIP 18601.4 Pectinidae Pectinidae Pecten healeyi NA Patinopecten healeyi NA Patinopecten healeyi (Arnold, 1906) geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
0210ef77-9139-4602-8984-9d0ca01bd9ed d172a61e-c537-4029-8563-59ffb4f62611 LACMIP 8194.6 Pterotrigoniidae Trigoniidae Notoscabrotrigonia klamathonia NA Pterotrigonia klamathonia NA Pterotrigonia klamathonia (Anderson, 1958) geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_family_replaced , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
02183e26-5f4b-4b2c-93a3-ce4af35a6c2a 9e8c52db-31fd-4d71-8d81-877864cc46f3 LACMIP 11921.12 Cerithiidae Cerithiidae Stylidium eschrichtii NA Neostylidium eschrichtii NA Neostylidium eschrichtii (Middendorff, 1849) rev_geocode_eez , geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
02190def-2a96-4aea-8efb-7e8ed39c2ccb 1b669af4-3c97-4165-924d-a8f2e7eba839 LACMIP 16862.121 Pectinidae Pectinidae Pecten healeyi NA Patinopecten healeyi NA Patinopecten healeyi (Arnold, 1906) geopoint_low_precision , rev_geocode_mismatch , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added
021b33b4-7fd7-4109-814a-735b5c14781e 750fb2ec-7706-408b-be72-f57bef291e0c LACMIP 6953.184 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
0226d059-bb79-4f8d-8ae9-ef2b3280c19b 0b01930b-c3ff-4052-8034-bfcc8ee3c00f LACMIP 16520.155 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
023336f3-59a6-44c4-bfae-6bf009c5444c 2e6952d9-ae1b-4ac8-b76b-293ee19ada30 LACMIP 421.18 Nassariidae Nassariidae Nassarius perpinguis NA Caesia perpinguis NA Caesia perpinguis (Hinds, 1844) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
023d255e-3614-4765-8b5f-75580f0b72b1 60318c6a-b4e8-420a-a320-ab34190a87aa LACMIP 137.1 Myidae Myidae Platydon cancellatus NA Platyodon cancellatus NA Platyodon cancellatus (Conrad, 1837) geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced
023de46a-ebc1-4ed8-b870-893174e283f7 4a90361d-e784-459a-868e-bc15ba99eee2 LACMIP 17650.56 Naticidae Naticidae Neverita reclusiana NA Glossaulax reclusiana NA Glossaulax reclusiana (Deshayes, 1839) geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added
02458ba3-ae85-4fd3-ad6b-f4e7fddd0910 52105c17-8d1e-49ca-8a10-fc40d5ffa040 LACMIP 29181.44 Pterotrigoniidae Trigoniidae Notoscabrotrigonia klamathonia NA Pterotrigonia klamathonia NA Pterotrigonia klamathonia (Anderson, 1958) geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_family_replaced , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added
0258072d-5307-4d14-becd-9da6c164dc3d 0e7fee00-1ffc-41ee-aa58-04f4e07070dd LACMIP 129.13 Calyptraeidae Calyptraeidae Crepidula dorsata NA Crepipatella dorsata NA Crepipatella dorsata (Broderip, 1834) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_parentnameusageid_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_taxonid_added , dwc_originalnameusageid_added, dwc_genus_replaced
026635d9-39c2-47d8-8a8e-3be6767f6c2a b07122cd-dc9d-4a24-bdd2-c4f12358433c LACMIP 228.37 Conidae Conidae Conus californicus NA Californiconus californicus NA Californiconus californicus (Reeve, 1844) geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added

When iDigBio makes modifications to data, these actions are recorded with data quality flags, for instance you will notice that all of the rows in the filtered data above have the flag “dwc_genus_replaced.” We could have used values in the flags field, like “dwc_genus_replaced,” to search for records back at the beginning of this demo. You can learn more about the flags that iDigBio uses here.

Summarize differences in the data

If you want to make changes based on the modifications we have discovered here, it may be helpful to summarize the distinct modifications, as opposed to seeing them repeated across many individual specimen records. We can summarize the distinct modifications for genus names using the group_by and tally functions from the dplyr package.

# Summarize modifications made to genus names
df_names %>% 
  filter(provider_genus != aggregator_genus) %>% 
  # Because of the nature of scientific names, it makes sense to group data by
  # all of the primary fields that comprise a scientific name
  group_by(provider_genus, provider_species, provider_subspecies,
           aggregator_genus, aggregator_species, aggregator_subspecies,
           provider_scientificName) %>% 
  # Count how many rows are affected by this modification made to genus name
  tally() %>% 
  # Order by frequency of rows affected
  arrange(desc(n)) %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed"),
                font_size = 12,
                fixed_thead = T) %>% 
  column_spec(c(4,5,6), color = "red") %>% 
  scroll_box(width = "100%", height = "400px")
provider_genus provider_species provider_subspecies aggregator_genus aggregator_species aggregator_subspecies provider_scientificName n
Glossaulax reclusiana NA Neverita reclusiana NA Glossaulax reclusiana (Deshayes, 1839) 12
Caesia perpinguis NA Nassarius perpinguis NA Caesia perpinguis (Hinds, 1844) 8
Patinopecten healeyi NA Pecten healeyi NA Patinopecten healeyi (Arnold, 1906) 5
Californiconus californicus NA Conus californicus NA Californiconus californicus (Reeve, 1844) 4
Hirtoscala indianorum NA Epitonium indianorum NA Hirtoscala indianorum (Carpenter, 1864) 4
Dendostrea vespertina NA Ostrea vespertina NA Dendostrea vespertina (Conrad, 1854) 3
Mitrella gausapata NA Alia gausapata NA Mitrella gausapata (Gould, 1850) 3
Pterotrigonia klamathonia NA Notoscabrotrigonia klamathonia NA Pterotrigonia klamathonia (Anderson, 1958) 3
Serpulorbis squamigerus NA Thylacodes squamigerus NA Serpulorbis squamigerus (Carpenter, 1857) 3
Shaskyus festivus NA Pteropurpura festiva NA Shaskyus festivus (Hinds, 1844) 3
Cerithideopsis californica NA Cerithidea californica NA Cerithideopsis californica (Haldeman, 1840) 2
Chlorostoma funebralis NA Tegula funebralis NA Chlorostoma funebralis (A. Adams, 1855) 2
Crepipatella dorsata NA Crepidula dorsata NA Crepipatella dorsata (Broderip, 1834) 2
Glycymerita major NA Glycymeris major NA Glycymerita major (Stanton, 1896) 2
Hamulus onyx NA Pyrgopolon onyx NA Hamulus onyx Morton, 1834 2
Acanthocardia brewerii NA Cardium brewerii NA Acanthocardia (Schedocardia) brewerii (Gabb, 1864) 1
Acteonella oviformis NA Actaeonella oviformis NA Acteonella oviformis Gabb, 1869 1
Chama exogyra NA Pseudochama exogyra NA Chama exogyra Conrad, 1837 1
Chlamys opuntia NA Pecten opuntia NA Chlamys opuntia (Dall, 1898) 1
Chlorostoma montereyi NA Tegula montereyi NA Chlorostoma montereyi (Kiener, 1850) 1
Cymbophora stantoni NA Mactra stantoni NA Cymbophora stantoni (Arnold, 1908) 1
Euspira draconis NA Glossaulax draconis NA Euspira draconis (Dall, 1903) 1
Gervillia NA NA Gervillaria alifera NA Gervillia sp. 1
Hesperaptyxis luteopictus NA Fusinus luteopictus NA Hesperaptyxis luteopictus (Dall, 1877) 1
Hirtoscala hindsii NA Epitonium hindsii NA Hirtoscala hindsii (Carpenter, 1856) 1
Isorobitella trigonalis NA Aligena trigonalis NA Isorobitella trigonalis (Carpenter, 1857) 1
Mexicardia procerum NA Americardia media NA Mexicardia procerum (Sowerby I, 1833) 1
Neostylidium eschrichtii NA Stylidium eschrichtii NA Neostylidium eschrichtii (Middendorff, 1849) 1
Pachycardium coronaense NA Cardium coronaensis NA Pachycardium coronaense (Packard, 1922) 1
Pachydiscus buckhami NA Eupachydiscus grossouvrei NA Pachydiscus buckhami Usher, 1952 1
Pachydiscus catarinae NA Eupachydiscus catarinae NA Pachydiscus (Neodesmoceras) catarinae (Anderson & Hanna, 1928) 1
Platyodon cancellatus NA Platydon cancellatus NA Platyodon cancellatus (Conrad, 1837) 1
Procladius NA NA Paracladius NA NA Procladius sp. 1
Pterotrigonia evansana NA Pleurotrigonia jacobseni NA Pterotrigonia evansana (Meek, 1858) 1
Pterotrigonia NA NA Protrigonia NA NA Pterotrigonia sp. 1

After reviewing the summarized data, you may wish to review individual specimens and possibly update their data. We can use the information from the summary above to search for the catalog numbers of which specimens to review.

# Search for specimen records of an example modified genus name
df_names %>% 
  filter(provider_genus == "Glossaulax" & provider_species == "reclusiana") %>%
  select(catalogNumber)
##       catalogNumber
## 1   LACMIP 8226.206
## 2   LACMIP 20187.59
## 3   LACMIP 42035.85
## 4   LACMIP 41678.50
## 5   LACMIP 25446.87
## 6  LACMIP 22413.169
## 7     LACMIP 2685.9
## 8    LACMIP 4396.20
## 9     LACMIP 466.63
## 10  LACMIP 31263.78
## 11 LACMIP 16520.155
## 12  LACMIP 17650.56