The ingestion process I ran yesterday was flawed (my fault; at the end of a long day I wasn't checking my CSV contents completely, just doing validation). As a result I've had to delete all those records from the db, which can only really be done one by one, resulting in a really tedious process, but I have learned quite a bit about the structure. It would probably be possible to figure out how all the tables relate to each other and write a deletion script for multiple records, but there are a lot of relations, and they're not managed by triggers as I believe they should be. I'll push the now-fixed data in tomorrow.