@matigo Unofficially, half of my studies have something to do with wine, and the other half is mostly fuelled by it :P
I wonder if this is something that could be crowdsourced on Reddit/Wikipedia. Wikipedia already has a 2-deep list of just about every region — it's missing Grand Cru and Premier Cru-level appellations which are essential for Burgundy.
It would be a list that went 4 levels deep into the appellation hierarchy (I think that's the deepest it goes, really), and would also specify appellation type (DOC, DOCg, AOC, AOP, etc.) — the latter might have to be another table.
The hardest decision would be to what extent to normalise the data.
Also, updating current records would take some creative find/replace.