What goes wrong
On this page10
Joining the fit table on the wrong catalog number
It is keyed on the supplier’s stock number. Joining on ours returns nothing on either side, which looks exactly like a table that does not cover the shelf. It covers 228 of 251 containers.
That mistake was made here and is recorded rather than hidden
Two SKU namespaces in one database, and an empty join that reads as an absence. The check is whether the join fails on every row or on some, because a total failure is usually a key problem.
Reading a recorded fit as a tested fit
The fourteen rows in the whole table that state a basis say the supplier used the same neck notation on both parts. That is a reasonable ground and it is not a trial.
Treating the fit table as independent evidence
For the 216 containers where both can be computed, the table’s count equals the same-notation count exactly, on every one. It is derived from the notation rather than checked against it.
Reading twelve empty neck finishes as missing data
Those twelve are polypropylene round tubs, which take a seated lid rather than a thread. The field is empty because it does not apply, which is a different state from unrecorded.
Quoting the median number of fitting closures
It is 61 across one population and 36 across another twelve rows larger, because 56 containers sit at 67 and 56 more at 61. Six values cover 194 of 228 containers, and quoting those six is shorter and true.
Mixing hook sizes in one jar
The size scale runs one way in numbers and the other way in aughts, nothing is printed on the hook, and sorting is done by eye against a known reference. It is the leaf where one size per container matters most.
Storing soft bait with other soft bait of a different color
Plasticized baits release plasticizer, which can mark some plastics and migrate between baits. Fifty six of the 251 containers are glass, and separate containers per color is the rest of the answer.
And expecting this property to tell you about lead tackle
Whether lead shot or lead sinkers may be sold or used varies by state and by water, and none of that is in this record. The Lacey Act is the spine here because it borrows every standard it applies, not because it says anything about tackle.