violation

abate_complete

Date abatement was verified, or status code.

abate_date

Date by which the employer was required to abate the violation.

activity_nr

Foreign key to inspection.activity_nr.

citation_id

Citation identifier within the inspection (one inspection can have many citations).

contest_date

Date the employer formally contested the citation, if applicable.

current_penalty

Current penalty amount in dollars (post-settlement, after reductions or increases).

delete_flag

Flag indicating the citation was deleted or superseded.

emphasis

Whether the inspection was part of an emphasis program (NEP/SEP).

final_order_date

Date the citation became a final order.

fta_contest_date

Contest date for the failure-to-abate citation.

fta_final_order_date

Final-order date for the failure-to-abate citation.

fta_insp_nr

Inspection number of the prior inspection on which the failure-to-abate is based.

fta_issuance_date

Issuance date of the failure-to-abate citation.

fta_penalty

Failure-to-abate penalty amount in dollars.

gravity

Gravity-based penalty severity, an integer rating used by OSHA penalty-calculation guidelines.

hazcat

Hazard category code.

hazsub1

First hazardous-substance code associated with the violation.

hazsub2

Second hazardous-substance code.

hazsub3

Third hazardous-substance code.

hazsub4

Fourth hazardous-substance code.

hazsub5

Fifth hazardous-substance code.

initial_penalty

Initial penalty proposed when the citation was issued, in dollars.

issuance_date

Date the citation was issued.

load_dt

Timestamp when this row was loaded.

nr_exposed

Number of employees exposed to the cited hazard.

nr_instances

Number of instances of the violation cited.

rec

Recordkeeping flag.

standard

OSHA standard cited (e.g., "19260451" for scaffold standard 29 CFR 1926.451).

viol_type

Violation type — "S" (serious), "W" (willful), "R" (repeat), "O" (other-than-serious), "U" (unclassified), "FTA" (failure to abate), etc.

13,227,024 rows

✎ View and edit SQL

Suggested facets: delete_flag, viol_type, abate_complete, contest_date, final_order_date, nr_instances, rec, gravity, emphasis, hazcat, fta_insp_nr, fta_issuance_date, fta_penalty, fta_contest_date, fta_final_order_date, hazsub1, hazsub2, hazsub3, hazsub4, hazsub5, load_dt, issuance_date (date), abate_date (date), contest_date (date), final_order_date (date), fta_issuance_date (date), fta_contest_date (date), fta_final_order_date (date), load_dt (date)

Next page

CREATE TABLE violation(activity_nr BIGINT, citation_id VARCHAR, delete_flag VARCHAR, standard VARCHAR, viol_type VARCHAR, issuance_date VARCHAR, abate_date VARCHAR, abate_complete VARCHAR, current_penalty DOUBLE, initial_penalty DOUBLE, contest_date VARCHAR, final_order_date VARCHAR, nr_instances BIGINT, nr_exposed BIGINT, rec VARCHAR, gravity BIGINT, emphasis VARCHAR, hazcat VARCHAR, fta_insp_nr BIGINT, fta_issuance_date VARCHAR, fta_penalty DOUBLE, fta_contest_date VARCHAR, fta_final_order_date VARCHAR, hazsub1 VARCHAR, hazsub2 VARCHAR, hazsub3 VARCHAR, hazsub4 VARCHAR, hazsub5 VARCHAR, load_dt VARCHAR);