accident_injury

where occ_code = 126

✎ View and edit SQL

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
);