accident_injury
where occ_code = 126
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83300 | 83300 | 170358691 170358691 | 120119151 120119151 | 66 | F | 12 12 | 14 14 | 43 43 | 4 4 | 18 18 | 14 14 | 126 126 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:39 EDT | |||
164908 | 164908 | 202553863 202553863 | 315526657 315526657 | 55 | F | 12 12 | 11 11 | 43 43 | 4 4 | 18 18 | 14 14 | 126 126 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
165677 | 165677 | 202563243 202563243 | 312350929 312350929 | 62 | F | 21 21 | 16 16 | 43 43 | 4 4 | 13 13 | 8 8 | 126 126 | 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 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 );