strategic_codes

Emphasis-program codes attached to inspections. OSHA targets inspections through National Emphasis Programs (NEPs) and Local Emphasis Programs (LEPs). Each row tags an inspection with one such program. Join via activity_nr.
activity_nr
Foreign key to inspection.activity_nr.
load_dt
Timestamp when this row was loaded.
prog_type
Program-type identifier (e.g., NEP, LEP, SEP).
prog_value
Specific program code or name (e.g., the NEP for amputations, trenching, combustible dust).

2,930,585 rows

✎ View and edit SQL

Suggested facets: prog_type, load_dt, load_dt (date)

activity_nr prog_type prog_value load_dt
544213 L LOCAL3 2011-10-14 16:42:09
544254 L LOCAL4 2011-10-14 16:42:09
544288 L LOCAL2 2011-10-14 16:42:09
544296 L LOCAL4 2011-10-14 16:42:09
544338 L LOCAL4 2011-10-14 16:42:09
544361 L LOCAL2 2011-10-14 16:42:09
544379 L LOCAL4 2011-10-14 16:42:09
544411 L LOCAL4 2011-10-14 16:42:09
544452 L LOCAL4 2011-10-14 16:42:09
544486 L LOCAL2 2011-10-14 16:42:09
544536 L LOCAL4 2011-10-14 16:42:09
544577 L LOCAL4 2011-10-14 16:42:09
544601 L LOCAL4 2011-10-14 16:42:09
544619 L LOCAL4 2011-10-14 16:42:09
544726 L LOCAL2 2011-10-14 16:42:09
544775 L LOCAL1 2011-10-14 16:42:09
544817 L LOCAL4 2011-10-14 16:42:09
544882 L LOCAL 2011-10-14 16:42:09
544890 L LOCAL3 2011-10-14 16:42:09
544932 L LOCAL3 2011-10-14 16:42:09
544965 L LOCAL 2011-10-14 16:42:09
544973 L LOCAL3 2011-10-14 16:42:09
545004 L LOCAL4 2011-10-14 16:42:09
545012 L LOCAL3 2011-10-14 16:42:09
545046 L LOCAL 2011-10-14 16:42:09
545129 L LOCAL4 2011-10-14 16:42:09
545400 L LOCAL4 2011-10-14 16:42:09
545483 L LOCAL1 2011-10-14 16:42:09
545566 L LOCAL4 2011-10-14 16:42:09
545608 L LOCAL4 2011-10-14 16:42:09
545731 L LOCAL4 2011-10-14 16:42:09
552992 L LOCAL3 2011-10-14 16:42:09
553172 L LOCAL3 2011-10-14 16:42:09
556043 L LOCAL3 2011-10-14 16:42:09
556696 L LOCAL1 2011-10-14 16:42:09
579623 N ASBESTOS 2011-10-14 16:42:09
594606 N ASBESTOS 2011-10-14 16:42:09
598185 N SWINGSCAF 2011-10-14 16:42:09
599936 N SWINGSCAF 2011-10-14 16:42:09
601310 N HAZCOMM 2011-10-14 16:42:09
601468 N ASBESTOS 2011-10-14 16:42:09
601930 N ASBESTOS 2011-10-14 16:42:09
602151 N ASBESTOS 2011-10-14 16:42:09
602169 N ASBESTOS 2011-10-14 16:42:09
602425 N ASBESTOS 2011-10-14 16:42:09
605253 N TRENCH 2011-10-14 16:42:09
605444 N FIREWORKS 2011-10-14 16:42:09
605451 N FIREWORKS 2011-10-14 16:42:09
609552 N ASBESTOS 2011-10-14 16:42:09
610519 N ASBESTOS 2011-10-14 16:42:09
610527 N ASBESTOS 2011-10-14 16:42:09
610535 N ASBESTOS 2011-10-14 16:42:09
610543 N ASBESTOS 2011-10-14 16:42:09
610550 N ASBESTOS 2011-10-14 16:42:09
610568 N ASBESTOS 2011-10-14 16:42:09
610576 N ASBESTOS 2011-10-14 16:42:09
610584 N ASBESTOS 2011-10-14 16:42:09
610592 N ASBESTOS 2011-10-14 16:42:09
610600 N ASBESTOS 2011-10-14 16:42:09
610618 N ASBESTOS 2011-10-14 16:42:09
610626 N ASBESTOS 2011-10-14 16:42:09
610634 N ASBESTOS 2011-10-14 16:42:09
610642 N ASBESTOS 2011-10-14 16:42:09
610659 N ASBESTOS 2011-10-14 16:42:09
610667 N ASBESTOS 2011-10-14 16:42:09
610675 N ASBESTOS 2011-10-14 16:42:09
610683 N ASBESTOS 2011-10-14 16:42:09
610691 N ASBESTOS 2011-10-14 16:42:09
610709 N ASBESTOS 2011-10-14 16:42:09
610717 N ASBESTOS 2011-10-14 16:42:09
610725 N ASBESTOS 2011-10-14 16:42:09
610733 N ASBESTOS 2011-10-14 16:42:09
610741 N ASBESTOS 2011-10-14 16:42:09
610758 N ASBESTOS 2011-10-14 16:42:09
610766 N ASBESTOS 2011-10-14 16:42:09
610782 N ASBESTOS 2011-10-14 16:42:09
610790 N ASBESTOS 2011-10-14 16:42:09
610881 N ASBESTOS 2011-10-14 16:42:09
610907 N ASBESTOS 2011-10-14 16:42:09
610915 N ASBESTOS 2011-10-14 16:42:09
611004 N ASBESTOS 2011-10-14 16:42:09
614503 N ASBESTOS 2011-10-14 16:42:09
614552 N ASBESTOS 2011-10-14 16:42:09
614602 N ASBESTOS 2011-10-14 16:42:09
614610 N ASBESTOS 2011-10-14 16:42:09
614636 N ASBESTOS 2011-10-14 16:42:09
614719 N ASBESTOS 2011-10-14 16:42:09
614727 N ASBESTOS 2011-10-14 16:42:09
614735 N ASBESTOS 2011-10-14 16:42:09
616623 N HAZCOMM 2011-10-14 16:42:09
616649 N HAZCOMM 2011-10-14 16:42:09
618587 N SWINGSCAF 2011-10-14 16:42:09
619775 N TRENCH 2011-10-14 16:42:09
619817 N TRENCH 2011-10-14 16:42:09
619825 N TRENCH 2011-10-14 16:42:09
619833 N TRENCH 2011-10-14 16:42:09
623058 N SWINGSCAF 2011-10-14 16:42:09
623496 N SWINGSCAF 2011-10-14 16:42:09
623777 N HAZCOMM 2011-10-14 16:42:09
623785 N HAZCOMM 2011-10-14 16:42:09

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE strategic_codes(activity_nr BIGINT, prog_type VARCHAR, prog_value VARCHAR, load_dt TIMESTAMP);