accident_injury

where occ_code = 83

✎ 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
50186 50186 14211551 14211551 14835540 14835540 29 F 1 1 10 10 26 26 2 2 2 2 20 20 83 83 2 2 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:39 EDT
64090 64090 14460596 14460596 14839682 14839682 39 M 21 21 2 2 25 25 5 5 18 18 1 1 83 83 3 3 2 2   0 0 0 0 0 0     1 2019-07-22 00:18:39 EDT
77768 77768 170152847 170152847 120068499 120068499 37 M 3 3 13 13 27 27 5 5 8 8 1 1 83 83 3 3 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:39 EDT
97507 97507 200033504 200033504 312599582 312599582 60 M 21 21 4 4 43 43 14 14 18 18 14 14 83 83 1 1 1 1 B418 0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
109281 109281 200623791 200623791 309928224 309928224 33 M 21 21 28 28 4 4 9 9 18 18 1 1 83 83 1 1 1 1 P445 0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
119139 119139 201034378 201034378 120226170 120226170 67 F 12 12 16 16 5 5 4 4 18 18 14 14 83 83 2 2 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
167887 167887 202652475 202652475 313514820 313514820 68 F 12 12 15 15 8 8 4 4 13 13 8 8 83 83 2 2 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:41 EDT
186694 186694 221035546 221035546 342806890 342806890 0         5 5     83 83 2 2 2 2             1 2023-06-03 02:39:19 EDT
204592 204592 221256613 221256613 344726039 344726039 0         14 14     83 83 1 1 2 2             1 2023-06-03 02:39:19 EDT
204934 204934 221262967 221262967 344757323 344757323 0         14 14     83 83 1 1 2 2             1 2023-06-03 02:39:19 EDT
205525 205525 221274335 221274335 344816814 344816814 0         12 12     83 83 1 1 2 2             1 2023-06-03 02:39:19 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])
);