Oh thank god. Late night loss of logical reasoning. Navicat was splitting the table view into pages (select *, rowid "NAVICATROWID" from "main"."winenotes_copy" limit 1000) and the page changer button is so small that I didn't see it. I had to go into the console and execute the command manually to see that all my records were indeed all there.