accident_injury
where occ_code = 103
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | summary_nr | rel_insp_nr | age | sex | nature_of_inj | part_of_body | src_of_injury | event_type | evn_factor | hum_factor | occ_code | degree_of_inj | task_assigned | hazsub | const_op | const_op_cause | fat_cause | fall_distance | fall_ht | injury_line_nr | load_dt |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
99552 | 99552 | 200122414 200122414 | 122421456 122421456 | 64 | M | 2 2 | 4 4 | 19 19 | 8 8 | 7 7 | 1 1 | 103 103 | 2 2 | 1 1 | 0560 | 0 0 | 0 0 | 0 0 | 2 | 2019-07-22 00:18:40 EDT | ||
167860 | 167860 | 202652202 202652202 | 316207315 316207315 | 58 | F | 20 20 | 3 3 | 5 5 | 14 14 | 18 18 | 14 14 | 103 103 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2017-03-20 01:00:11 EDT | |||
195583 | 195583 | 221129125 221129125 | 343654943 343654943 | 0 | 8 8 | 103 103 | 2 2 | 2 2 | 1 | 2023-06-03 02:39:18 EDT | ||||||||||||
195584 | 195584 | 221129125 221129125 | 343654943 343654943 | 0 | 8 8 | 103 103 | 2 2 | 2 2 | 2 | 2023-06-03 02:39:18 EDT | ||||||||||||
195585 | 195585 | 221129125 221129125 | 343654943 343654943 | 0 | 8 8 | 103 103 | 2 2 | 2 2 | 3 | 2023-06-03 02:39:18 EDT | ||||||||||||
205381 | 205381 | 221271737 221271737 | 344794730 344794730 | 0 | 14 14 | 103 103 | 2 2 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
205480 | 205480 | 221273345 221273345 | 344810205 344810205 | 0 | 14 14 | 103 103 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
206254 | 206254 | 221284763 221284763 | 344874722 344874722 | 0 | 12 12 | 103 103 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
207408 | 207408 | 221306376 221306376 | 344992656 344992656 | 0 | 14 14 | 103 103 | 2 2 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
207825 | 207825 | 221314842 221314842 | 345048797 345048797 | 0 | 8 8 | 103 103 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | |||||||||||||
207881 | 207881 | 221315765 221315765 | 345057681 345057681 | 0 | 14 14 | 103 103 | 1 1 | 1 | 2023-06-03 02:39:19 EDT | |||||||||||||
208503 | 208503 | 221324981 221324981 | 344762489 344762489 | 0 | 14 14 | 103 103 | 1 1 | 1 | 2023-06-03 02:39:19 EDT | |||||||||||||
208627 | 208627 | 221327190 221327190 | 345117253 345117253 | 0 | 14 14 | 103 103 | 1 1 | 1 | 2023-06-03 02:39:19 EDT | |||||||||||||
210021 | 210021 | 221360308 221360308 | 344861133 344861133 | 0 | 8 8 | 103 103 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | |||||||||||||
210860 | 210860 | 221382955 221382955 | 345156772 345156772 | 0 | 14 14 | 103 103 | 2 2 | 1 | 2023-06-03 02:39:19 EDT |
CREATE TABLE "accident_injury" ( "summary_nr" INTEGER, "rel_insp_nr" INTEGER, "age" INTEGER, "sex" TEXT, "nature_of_inj" INTEGER, "part_of_body" INTEGER, "src_of_injury" INTEGER, "event_type" INTEGER, "evn_factor" INTEGER, "hum_factor" INTEGER, "occ_code" INTEGER, "degree_of_inj" INTEGER, "task_assigned" INTEGER, "hazsub" TEXT, "const_op" INTEGER, "const_op_cause" INTEGER, "fat_cause" INTEGER, "fall_distance" INTEGER, "fall_ht" INTEGER, "injury_line_nr" INTEGER, "load_dt" TEXT, FOREIGN KEY([summary_nr]) REFERENCES [accident]([summary_nr]), FOREIGN KEY([rel_insp_nr]) REFERENCES [inspection]([activity_nr]), FOREIGN KEY([fat_cause]) REFERENCES [fatality]([accident_number]), FOREIGN KEY([const_op_cause]) REFERENCES [operator]([accident_number]), FOREIGN KEY([const_op]) REFERENCES [operator]([accident_number]), FOREIGN KEY([evn_factor]) REFERENCES [environmental]([accident_number]), FOREIGN KEY([event_type]) REFERENCES [event_type]([accident_number]), FOREIGN KEY([hum_factor]) REFERENCES [human]([accident_number]), FOREIGN KEY([nature_of_inj]) REFERENCES [injury]([accident_number]), FOREIGN KEY([occ_code]) REFERENCES [occupation]([accident_number]), FOREIGN KEY([part_of_body]) REFERENCES [body_part]([accident_number]), FOREIGN KEY([src_of_injury]) REFERENCES [injury_source]([accident_number]), FOREIGN KEY([degree_of_inj]) REFERENCES [degree_injury]([accident_number]), FOREIGN KEY([task_assigned]) REFERENCES [task]([accident_number]) );