Format for Reporting UK Census Data

Date: [unknown] [unknown]
Location: [unknown]

I am working on updating my wikitree ancestors biographies based on UK census data. I find having the census data reported is useful in trying to trace relatives through time. As such, I have 4 issues I'd like to discuss. I'd appreciate any feedback and suggestions.

1. The census reporting headings changed with time. See attached image #2. My preference is to display the same fields regardless of census year to reduce the complexity of generating the reporting. As such, my approach is to display just the following fields, and add any missing data (e.g. Infirmity, which is often blank) in the Notes column. See attached image #3

2. As noted above, I have produced a common format table, which displays the census data, and allows the person within whose biography this appears to be listed in bold. See attached image #4. As an aside, because writing the HTML code to produce this table is time-consuming and error prone, I've written an Excel workbook that allows me to enter the data and produce the HTML code that I can paste directly into the wikitree Biography section, including the reference.

3. The original census hand-written data is sometimes hard to decipher and has shorthand (e.g. Notts for Nottinghamshire, dau for daughter). When working from transcriptions, there are sometimes errors. Correcting the errors by referring to the original seems like a no-brainer, but I also have been replacing abbreviations with the original value.

4. For references, I've been including most of the fields at the top of the page, but the district/ward/parish/borough/town/village don't seem to be consistently filled in, so I've just combined them into one field. Here's a sample of the generated reference for the example above. See attached image #5