For a full list of BASHing data blog posts, see the index page.     RSS

How to enter nothing in a database

For an update on this topic, see this BASHing data post.

I call them NITS, which is short for Nothing Interesting To Say. They're the filler items that appear in spreadsheets and databases when the person entering the data has no information for a particular field. Here are some real-world examples from the databases I've audited:


Besides these all-purpose NITS, I've also seen filler items tailored to specific fields. Sometimes these almost have information content. Examples:

NITS are a nuisance in data cleaning. Like blank records and blank fields, they contribute nothing useful to a database and muck up the tally of a field's contents.





If you have nothing to enter in a field for a particular record, there's nothing wrong with leaving the data item blank. Please?

Last update: 2021-12-24
The blog posts on this website are licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License