Route 1: Documented inspection, enforcement, and correction

Every link in this example is documented. This is what a traceable record would look like.

1. Complaint record opened
2. Assigned to an inspector (process step)
3. Inspection date and result shown
4. Notice of Violation issued as a separate record
5. Correction documented
6. Compliance verification shown
7. Case closed

Even here, a Notice of Violation alone would not establish a completed repair. The correction and verification steps carry that weight.

Route 2: Closed or completed, no publicly visible inspection documentation

The status says the case ended. The published fields do not show how.

1. Complaint record opened
2. Inspection date not shown
3. Inspection result not shown
4. Correction and verification not shown
5. Status reads Closed or Completed

This does not establish that no inspection or repair occurred. It establishes that the published record alone cannot answer the question.

Route 3: Remains open or under investigation

The file stays in an open status and may move between desks.

1. Complaint record opened
2. Pending, then assigned (process step)
3. Interim steps not visible in the published fields
4. Status reads Under Investigation or similar

No elapsed time is shown or implied. An open status does not by itself show that nothing is happening.

Route 4: Administrative or no-violation outcome

An outcome appears, but the public record does not explain every underlying step.

1. Complaint record opened
2. Routed for administrative handling or inspected (process step)
3. Outcome value shown, such as ADMIN CLOSURE or NO VIOLATION
4. Underlying basis not explained in the published fields

An administrative closure does not imply wrongdoing or a lack of repair, and a no-violation result may be entirely correct.

Violation / Enforcement action

Does establish: an enforcement record, such as a Notice of Violation or citation, exists.

Does not establish: that the condition was repaired, or which complaint led to it. A notice is not a verified completed repair.

In the data: 9,960 Notice of Violation rows and 1,394 citation rows. These are separately counted records, and the ratio to complaints is not a conversion rate.

Closed

Does establish: the record carries a Closed status.

Does not establish: why it closed, whether an inspection took place, or whether a problem was corrected.

In the data: 10,912 rows have the current status CLOSED.

Completed

Does establish: the record carries a Completed status.

Does not establish: a confirmed correction. A completed record does not prove the condition was fixed, or that it was not.

In the data: 39,809 rows have the current status COMPLETED.

Administrative closure

Does establish: the record shows an administrative closure value.

Does not establish: wrongdoing, a lack of repair, or the reason for the closure.

In the data: 113 rows show ADMIN CLOSURE, in the last inspection result field rather than the status field.

No contact

Does establish: this is an illustrative label for a case where someone could not be reached or a condition could not be observed.

Does not establish: that the condition did not exist, or that no further effort was made.

In the data: "No contact" is not a published value. The closest is NO ACCESS/UNABLE TO OBSERVE, with 154 rows in the last inspection result field.

No violation observed

Does establish: the record shows a no-violation result.

Does not establish: what was examined, or the condition at any other time. This result may be entirely correct.

In the data: 60 rows show NO VIOLATION in the last inspection result field.

Remains open

Does establish: the record has not reached a closing status in this snapshot.

Does not establish: that nothing is happening, or how long any particular case will take.

In the data: 3,749 rows show UNDER INVESTIGATION and 507 show INITIATED, among other open-type values.