The following numbers we will need to report in the paper, once it is subset to Canada/CONUS.
It would be great to have summaries of total counts by each main column, for each unique value in it:
- interaction type
- BOW evidence
- nonbreeding season
- entry changes (how many of them had a change during the checking process; this is just any non-NA row)
- number of unique species1-species2 interactions
- summary table of the count of each species1-species2 interaction type (so, how many sp1-sp2 competition rows there are ... etc.
Most of these numbers are for the database as a data product and perhaps should go into a separate Quarto qmd file that opens the final DB file and reports summaries (is that L2?)
However the count "entry changes" is related to the data cleaning process and definitely is best reported at the end of the L0 to L1 workflow.
However if the files are saved ( the taxonomy edits file with 'raw', 'edits' and 'checklist' columns then that could be read in and summarized also in the L2 report.
Most of these numbers are for the database as a data product and perhaps should go into a separate Quarto qmd file that opens the final DB file and reports summaries (is that L2?)
However the count "entry changes" is related to the data cleaning process and definitely is best reported at the end of the L0 to L1 workflow.
However if the files are saved ( the taxonomy edits file with 'raw', 'edits' and 'checklist' columns then that could be read in and summarized also in the L2 report.