accident_injury
where occ_code = 68
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50191 | 50191 | 14211858 14211858 | 14842975 14842975 | 20 | M | 21 21 | 1 1 | 27 27 | 2 2 | 8 8 | 1 1 | 68 68 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:39 EDT |
CREATE TABLE "accident_injury" ( [summary_nr] INTEGER REFERENCES [accident]([summary_nr]), [rel_insp_nr] INTEGER REFERENCES [inspection]([activity_nr]), [age] INTEGER, [sex] TEXT, [nature_of_inj] INTEGER REFERENCES [injury]([accident_number]), [part_of_body] INTEGER REFERENCES [body_part]([accident_number]), [src_of_injury] INTEGER REFERENCES [injury_source]([accident_number]), [event_type] INTEGER REFERENCES [event_type]([accident_number]), [evn_factor] INTEGER REFERENCES [environmental]([accident_number]), [hum_factor] INTEGER REFERENCES [human]([accident_number]), [occ_code] INTEGER REFERENCES [occupation]([accident_number]), [degree_of_inj] INTEGER REFERENCES [degree_injury]([accident_number]), [task_assigned] INTEGER REFERENCES [task]([accident_number]), [hazsub] TEXT, [const_op] INTEGER REFERENCES [operator]([accident_number]), [const_op_cause] INTEGER REFERENCES [operator]([accident_number]), [fat_cause] INTEGER REFERENCES [fatality]([accident_number]), [fall_distance] INTEGER, [fall_ht] INTEGER, [injury_line_nr] INTEGER, [load_dt] TEXT );