accident_injury
where occ_code = 144
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118841 | 118841 | 201031242 201031242 | 300755642 300755642 | 59 | F | 12 12 | 16 16 | 8 8 | 4 4 | 13 13 | 10 10 | 144 144 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 162657 | 162657 | 202521043 202521043 | 314990896 314990896 | 43 | M | 12 12 | 21 21 | 25 25 | 5 5 | 8 8 | 10 10 | 144 144 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 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]) );