This is a niche that datasette (by simonw on here) could fill very nicely. If you can wrangle it in to a csv, then datasette can publish it as an api with an sql interface.

I'm not sure how this could work with things like photos etc (though there are plugins for some of this)