accident_injury

where occ_code = 103

✎ 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
99552 99552 200122414 200122414 122421456 122421456 64 M 2 2 4 4 19 19 8 8 7 7 1 1 103 103 2 2 1 1 0560 0 0 0 0 0 0     2 2019-07-22 00:18:40 EDT
167860 167860 202652202 202652202 316207315 316207315 58 F 20 20 3 3 5 5 14 14 18 18 14 14 103 103 2 2 1 1   0 0 0 0 0 0     1 2017-03-20 01:00:11 EDT
195583 195583 221129125 221129125 343654943 343654943 0         8 8     103 103 2 2 2 2             1 2023-06-03 02:39:18 EDT
195584 195584 221129125 221129125 343654943 343654943 0         8 8     103 103 2 2 2 2             2 2023-06-03 02:39:18 EDT
195585 195585 221129125 221129125 343654943 343654943 0         8 8     103 103 2 2 2 2             3 2023-06-03 02:39:18 EDT
205381 205381 221271737 221271737 344794730 344794730 0         14 14     103 103 2 2 2 2             1 2023-06-03 02:39:19 EDT
205480 205480 221273345 221273345 344810205 344810205 0         14 14     103 103 1 1 2 2             1 2023-06-03 02:39:19 EDT
206254 206254 221284763 221284763 344874722 344874722 0         12 12     103 103 1 1 2 2             1 2023-06-03 02:39:19 EDT
207408 207408 221306376 221306376 344992656 344992656 0         14 14     103 103 2 2 2 2             1 2023-06-03 02:39:19 EDT
207825 207825 221314842 221314842 345048797 345048797 0         8 8     103 103 2 2               1 2023-06-03 02:39:19 EDT
207881 207881 221315765 221315765 345057681 345057681 0         14 14     103 103 1 1               1 2023-06-03 02:39:19 EDT
208503 208503 221324981 221324981 344762489 344762489 0         14 14     103 103 1 1               1 2023-06-03 02:39:19 EDT
208627 208627 221327190 221327190 345117253 345117253 0         14 14     103 103 1 1               1 2023-06-03 02:39:19 EDT
210021 210021 221360308 221360308 344861133 344861133 0         8 8     103 103 2 2               1 2023-06-03 02:39:19 EDT
210860 210860 221382955 221382955 345156772 345156772 0         14 14     103 103 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])
);