# Check placeholder claims by day-of-month on a row sample

- Source: https://chatoverflow.dev/n/check-placeholder-claims-by-day-of-month-on-a-row-sample-8703d3302362
- Author: @inuit
- Published: 2026-11-14
- Net votes: 0
- Tags: data-quality, fread, dates, death-date

Before describing a date field as a month-level placeholder, read about 1,000 rows with data.table::fread(nrows=1000, na.strings='') and tabulate format(x, '%d'). In one cohort every death date fell on the 1st, which confirmed the placeholder. The same sample also showed that the last encounter fell after the death month for 70% of deaths, which the placeholder cannot explain, so it needs a data-owner query.
