accident_injury

One row per injured person per accident. Identifies the victim's age and sex, the nature and degree of the injury, the body part affected, the source of the injury, the human/environmental contributing factors, and (for falls) the fall height and distance. Joins to accident via the rel_insp_nr field (which is the inspection number, FK to inspection.activity_nr) and to the lookup tables for the coded fields.
age
Age of the injured person.
const_op
Construction operation code, if applicable (FK to operator).
const_op_cause
Construction operation cause code (FK to operator).
degree_of_inj
Degree-of-injury code (FK to degree_injury — fatal, hospitalized, non-hospitalized, etc.).
event_type
Event-type code (FK to event_type).
evn_factor
Environmental-factor code (FK to environmental).
fall_distance
For falls, distance fallen in feet.
fall_ht
For falls, height of the fall in feet.
fat_cause
For fatalities, the cause code (FK to fatality).
hazsub
Hazardous-substance code, if a substance was involved.
hum_factor
Human-factor code (FK to human).
injury_line_nr
Line number within the accident's injury list.
load_dt
Timestamp when this row was loaded.
nature_of_inj
Nature-of-injury code (FK to injury).
occ_code
Occupation code (FK to occupation).
part_of_body
Body-part-affected code (FK to body_part).
rel_insp_nr
Foreign key to inspection.activity_nr — the inspection associated with this injury.
sex
Sex of the injured person — "M", "F", or unknown.
src_of_injury
Source-of-injury code (FK to injury_source).
summary_nr
Foreign key to accident.summary_nr.
task_assigned
Task-assigned code (FK to task — what the worker was assigned to do).

231,809 rows

✎ View and edit SQL

Suggested facets: sex, nature_of_inj, part_of_body, event_type, evn_factor, hum_factor, degree_of_inj, task_assigned, const_op, const_op_cause, fat_cause, load_dt, load_dt (date)

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
84954 14199848 0   12 13 24 2 6 1 0 2 1   0 0 0     1 2017-03-20 01:00:11
88070 14324826 0   12 13 42 4 13 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
88393 14334668 0   10 4 15 12 13 12 0 1 1   0 0 0     1 2017-03-20 01:00:11
88484 14339527 0   12 13 39 1 5 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
88542 14342992 0   10 4 15 13 8 1 0 1 2 0000 0 0 0     1 2017-03-20 01:00:11
88591 14347728 0   6 13 27 1 1 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
85076 14205645 0   6 13 8 5 13 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
85266 14213417 0   21 19 7 1 6 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
85407 14220958 0   12 13 42 5 13 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
85472 14222574 0   12 18 42 5 13 6 0 2 1   0 0 0     1 2017-03-20 01:00:11
85571 14229181 0   6 13 25 5 6 10 0 1 1   0 0 0     1 2017-03-20 01:00:11
85795 14241053 0   12 14 12 2 13 1 0 2 1   0 0 0     2 2017-03-20 01:00:11
86413 14261663 0   5 10 35 13 10 1 0 2 1 2037 0 0 0     2 2017-03-20 01:00:11
86504 14263669 0   12 20 27 1 6 10 0 1 1   0 0 0     1 2017-03-20 01:00:11
86512 14263974 0   10 4 15 13 13 8 0 1 1   0 0 0     1 2017-03-20 01:00:11
86652 14268544 0   21 5 27 2 8 6 0 1 1   0 0 0     1 2017-03-20 01:00:11
86686 14269252 0   21 5 9 8 7 11 0 2 1 0640 0 0 0     7 2017-03-20 01:00:11
86686 14269252 0   21 5 9 8 7 11 0 2 1 0640 0 0 0     14 2017-03-20 01:00:11
86751 14270334 0   5 19 16 1 9 14 0 1 1   0 0 0     2 2017-03-20 01:00:11
86751 14270334 0   5 19 16 2 9 14 0 2 1   0 0 0     3 2017-03-20 01:00:11
86769 14270342 0   5 19 16 1 9 14 0 1 1   0 0 0     2 2017-03-20 01:00:11
86884 14275655 0   21 5 9 8 7 11 0 2 1 0640 0 0 0     6 2017-03-20 01:00:11
86884 14275655 0   21 5 9 8 7 11 0 2 1 0640 0 0 0     8 2017-03-20 01:00:11
86959 14277560 0   12 13 43 1 6 1 0 1 2   0 0 0     1 2017-03-20 01:00:11
87031 14285043 0   6 13 5 5 8 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
87098 14285621 0   2 4 10 8 7 1 0 2 1 5950 0 0 0     13 2017-03-20 01:00:11
87395 14309512 0   5 4 16 14 7 6 0 1 1 1340 0 0 0     1 2017-03-20 01:00:11
82115 14083885 0   20 3 12 1 4 1 0 3 1   0 0 0     2 2017-03-20 01:00:11
82180 14089411 0   12 13 8 5 18 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
82230 14090146 0   5 19 7 6 7 6 0 3 1 5350 0 0 0     2 2017-03-20 01:00:11
82388 14096812 0   21 4 30 2 18 9 0 1 1   0 0 0     1 2017-03-20 01:00:11
82479 14102354 0   21 13 25 5 18 14 0 1 1   0 0 0     1 2017-03-20 01:00:11
83139 14122378 0   21 1 27 1 6 10 0 1 1   0 0 0     1 2017-03-20 01:00:11
90480 14437560 0   4 9 10 14 9 1 0 2 1 2310 0 0 0     5 2017-03-20 01:00:11
90530 14440259 0   2 4 19 8 7 1 0 3 1 0560 0 0 0     1 2017-03-20 01:00:11
90589 14440887 0   5 19 9 1 7 14 0 2 1 1380 0 0 0     1 2017-03-20 01:00:11
90761 14447676 0   2 20 24 4 4 6 0 1 1   0 0 0     1 2017-03-20 01:00:11
90779 14447924 0   17 19 29 13 8 10 0 1 1   0 0 0     1 2017-03-20 01:00:11
90845 14450225 0   12 13 12 1 13 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
90969 14456172 0   2 4 19 8 7 2 0 2 1 0240 0 0 0     1 2017-03-20 01:00:11
91066 14457295 0   12 13 8 5 13 2 0 2 1   0 0 0     1 2017-03-20 01:00:11
91124 14459432 0   21 4 9 8 7 2 0 3 2 0640 0 0 0     4 2017-03-20 01:00:11
91298 14467484 0   12 5 26 2 1 13 0 1 1   0 0 0     1 2017-03-20 01:00:11
91629 14475222 0   17 4 27 8 8 1 0 3 1 0560 0 0 0     7 2017-03-20 01:00:11
91868 14484760 0   6 13 27 1 6 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
94268 214580631 0   21 4 19 8 7 12 0 3 1 0560 0 0 0     22 2017-03-20 01:00:11
94508 214606071 0   17 4 43 2 7 12 0 3 1 0560 0 0 0     2 2017-03-20 01:00:11
94508 214606071 0   17 4 43 2 7 12 0 3 1 0560 0 0 0     3 2017-03-20 01:00:11
94532 214609646 0   21 1 10 8 7 1 0 2 1 5100 0 0 0     16 2017-03-20 01:00:11
92296 14510952 0   21 23 26 2 8 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
92551 14525109 0   5 19 43 1 8 11 0 2 1 8880 0 0 0     3 2017-03-20 01:00:11
92858 14539811 0   3 4 28 1 6 6 0 1 1   0 0 0     1 2017-03-20 01:00:11
92973 14542567 0   21 13 27 2 8 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
93187 14556062 0   12 13 30 5 8 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
93229 14557094 0   5 19 16 1 8 9 0 1 1   0 0 0     1 2017-03-20 01:00:11
93401 14559439 0   21 4 30 1 16 9 0 1 1   0 0 0     1 2017-03-20 01:00:11
93575 14564314 0   5 18 19 6 7 1 0 2 1 0000 0 0 0     1 2017-03-20 01:00:11
93682 14569933 0   3 15 43 1 1 11 0 3 1   0 0 0     2 2017-03-20 01:00:11
93724 14570550 0   10 11 15 13 13 1 0 2 1   0 0 0     1 2017-03-20 01:00:11
93765 14571178 0   3 19 7 1 4 11 0 3 1   0 0 0     2 2017-03-20 01:00:11
93849 214571465 0   21 4 8 5 13 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
93963 214572372 0   6 13 43 5 13 6 0 1 1   0 0 0     1 2017-03-20 01:00:11
94003 214572844 0   21 4 43 14 7 1 0 2 1 0320 0 0 0     1 2017-03-20 01:00:11
94052 214573370 0   12 13 30 1 8 10 0 1 1   0 0 0     1 2017-03-20 01:00:11
94144 214577165 0   21 19 3 3 18 2 0 2 2   0 0 0     1 2017-03-20 01:00:11
94219 214579542 0   17 4 19 8 7 1 0 3 1 0560 0 0 0     2 2017-03-20 01:00:11
94219 214579542 0   17 4 19 8 7 1 0 3 1 0560 0 0 0     5 2017-03-20 01:00:11
88831 14361224 0   12 13 30 2 13 9 0 1 1   0 0 0     1 2017-03-20 01:00:11
88880 14364210 0   12 19 5 5 6 12 0 2 1   0 0 0     1 2017-03-20 01:00:11
89011 14375315 0   12 19 29 1 8 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
89557 14396980 0   12 3 43 1 17 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
89722 14404339 0   10 4 15 13 8 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
90175 14422372 0   21 13 24 5 13 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
90340 14431555 0   10 20 13 12 8 1 0 1 2   0 0 0     1 2017-03-20 01:00:11
90399 14432884 0   2 5 12 12 8 1 0 1 1 0000 0 0 0     1 2017-03-20 01:00:11
95331 214652463 0   21 4 14 8 7 6 0 3 1 9030 0 0 0     7 2017-03-20 01:00:11
95398 214654394 0   21 4 43 12 18 14 0 1 1   0 0 0     1 2017-03-20 01:00:11
95497 214661423 0   5 18 16 14 10 11 0 2 1 1380 0 0 0     1 2017-03-20 01:00:11
95612 214678005 0   21 5 12 1 6 1 0 2 1   0 0 0     1 2017-03-20 01:00:11
95745 214680670 0   21 5 30 2 6 13 0 1 1   0 0 0     1 2017-03-20 01:00:11
95893 214686735 0   12 13 43 5 18 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
128363 16261869 0   10 4 15 13 18 6 0 1 1 0000 0 0 0     1 2017-03-20 01:00:11
128645 16271363 0   12 19 8 5 13 12 0 1 1   0 0 0     1 2017-03-20 01:00:11
128801 16274003 0   5 2 15 14 18 3 0 2 1   0 0 0     2 2017-03-20 01:00:11
128868 16274417 0   21 4 30 8 7 1 0 3 1   0 0 0     1 2017-03-20 01:00:11
128934 16274896 0   6 13 30 1 4 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
128959 16274946 0   3 4 42 5 8 2 0 1 1   0 0 0     1 2017-03-20 01:00:11
96834 214749640 0   12 19 42 5 13 4 0 1 1   0 0 0     1 2017-03-20 01:00:11
96917 214758401 0   12 19 28 1 9 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
96925 214760233 0   21 19 43 2 4 1 0 1 1   0 0 0     1 2017-03-20 01:00:11
97063 214770042 0   12 13 26 2 2 10 0 1 1   0 0 0     1 2017-03-20 01:00:11
97121 214770257 0   21 5 9 14 13 11 0 3 2 2140 0 0 0     2 2017-03-20 01:00:11
97121 214770257 0   21 5 9 14 13 11 0 3 1 2140 0 0 0     3 2017-03-20 01:00:11
97170 214771289 0   5 4 16 1 10 4 0 1 1   0 0 0     1 2017-03-20 01:00:11
97253 214784530 0   12 19 8 5 13 12 0 1 1   0 0 0     1 2017-03-20 01:00:11
97303 214789091 0   2 19 43 5 18 14 0 1 1   0 0 0     1 2017-03-20 01:00:11
97337 214797177 0   7 4 26 1 5 4 0 1 1   0 0 0     1 2017-03-20 01:00:11
97519 214800203 0   12 13 30 1 13 10 0 1 1   0 0 0     1 2017-03-20 01:00:11
97576 214814261 0   5 4 19 14 18 1 0 2 1   0 0 0     3 2017-03-20 01:00:11
107920 15524994 0   12 19 24 5 6 12 0 2 1   0 0 0     1 2017-03-20 01:00:11

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE accident_injury(summary_nr BIGINT, rel_insp_nr BIGINT, age BIGINT, sex VARCHAR, nature_of_inj BIGINT, part_of_body BIGINT, src_of_injury BIGINT, event_type BIGINT, evn_factor BIGINT, hum_factor BIGINT, occ_code BIGINT, degree_of_inj BIGINT, task_assigned BIGINT, hazsub VARCHAR, const_op BIGINT, const_op_cause BIGINT, fat_cause BIGINT, fall_distance BIGINT, fall_ht BIGINT, injury_line_nr BIGINT, load_dt TIMESTAMP);