Existing council files

Three old council files in real government formats, with the faults that old files have: unclear code lists, an old severity scale, a column used for the wrong thing, a duplicate row and a wrong value. Each column becomes a dictionary entry once, and the records become shared records. Choose a file, then press Load the file. The platform accepts or refuses each record.

Damp and mould, recorded three ways

The same question, how bad the damp is in a home, is recorded in three ways in these files. Each way is kept as it is. None is converted into another.

A codeA job code PLA110 is a plastering job for a damp wall. The code is linked once to the meaning Damp and mould.
A rankingA hazard band HHSRS band C is a place on the scale A to J. Bands A to C are Category 1.
A resident's wordsFree text "Black spots on the bedroom wall again and the baby coughs at night." The resident's words are kept as they are, beside the codes and the bands.
Technology DNA keeps a ranking apart from a quantity. The platform refuses a sum or an average of hazard bands. The scale is part of the dictionary entry:
Loading the entry Hazard band

Back to all four systems