accident_injury

where occ_code = 26

✎ 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
39816 39816 780544 780544 104344551 104344551 53 F 2 2 13 13 16 16 8 8 9 9 11 11 26 26 3 3 1 1 2582 0 0 0 0 0 0     22 2019-07-22 00:18:38 EDT
39817 39817 780544 780544 104344551 104344551 58 F 2 2 13 13 16 16 8 8 9 9 11 11 26 26 3 3 1 1 2582 0 0 0 0 0 0     23 2019-07-22 00:18:38 EDT
39818 39818 780544 780544 104344551 104344551 34 M 2 2 13 13 16 16 8 8 9 9 11 11 26 26 3 3 1 1 2582 0 0 0 0 0 0     24 2019-07-22 00:18:38 EDT
55135 55135 14304257 14304257 18713008 18713008 40 M 21 21 31 31 9 9 14 14 9 9 18 18 26 26 3 3 1 1 2290 0 0 0 0 0 0     32 2017-03-20 01:00:11 EDT
55137 55137 14304257 14304257 18713008 18713008 47 F 21 21 31 31 9 9 14 14 9 9 18 18 26 26 3 3 1 1 2290 0 0 0 0 0 0     34 2017-03-20 01:00:11 EDT
55139 55139 14304257 14304257 18713008 18713008 37 M 21 21 31 31 9 9 14 14 9 9 18 18 26 26 3 3 1 1 2290 0 0 0 0 0 0     36 2017-03-20 01:00:11 EDT
55141 55141 14304257 14304257 18713008 18713008 40 F 21 21 31 31 9 9 14 14 9 9 18 18 26 26 3 3 1 1 2290 0 0 0 0 0 0     38 2017-03-20 01:00:11 EDT
128312 128312 201143047 201143047 305347866 305347866 32 M 21 21 19 19 43 43 11 11 18 18 17 17 26 26 2 2 1 1 8302 0 0 0 0 0 0     2 2019-07-22 00:18:40 EDT
170471 170471 220356364 220356364 337654818 337654818 0         5 5     26 26 1 1 2 2             1 2023-03-31 00:19:15 EDT
179195 179195 220955793 220955793 342328010 342328010 0         5 5     26 26 2 2 2 2             1 2023-03-31 00:19:15 EDT
188718 188718 221056930 221056930 343170262 343170262 0         2 2     26 26 2 2 2 2             1 2023-03-31 00:19:14 EDT
197168 197168 221146616 221146616 343868881 343868881 0         1 1     26 26 2 2 2 2             1 2023-03-31 00:19:14 EDT
212724 212724 221429103 221429103 345735815 345735815 0         14 14     26 26 1 1               1 2023-03-31 00:19:13 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])
);