yeah - it started as “haphazard” – then I wrote an Sqlite script to reorder them by consanguinity to get that – you can see the grouping. the “others” are basically in the order I found them on various census (Farm Helper, servant and so on)
That is not a beginner script as it involves using CTEs and/or temp tables then updating multiple tables. The my first attempt was not quite right so I had restore from backup. AI is getting close enough now I would have used it to double checked my work before running . You do need to provide AI good table definition and articulate what needs to be done – often I built the framework then let AI improve it if I was doing today. (NOTE: that using update scripts is not recommended by RM)