accident_injury

where occ_code = 105

✎ 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
64225 64225 14463210 14463210 17455338 17455338 42 M 21 21 4 4 43 43 14 14 18 18 14 14 105 105 1 1 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:39 EDT
84170 84170 170383285 170383285 119995355 119995355 38 F 21 21 31 31 18 18 8 8 18 18 14 14 105 105 2 2 1 1 8400 0 0 0 0 0 0     2 2019-07-22 00:18:39 EDT
94140 94140 170895791 170895791 119827459 119827459 36 F 12 12 18 18 8 8 5 5 18 18 1 1 105 105 2 2 2 2   0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
107052 107052 200542306 200542306 315564765 315564765 25 M 21 21 19 19 33 33 1 1 18 18 14 14 105 105 1 1 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
118532 118532 201023124 201023124 300752722 300752722 59 M 6 6 13 13 34 34 1 1 18 18 14 14 105 105 2 2 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
121299 121299 201060340 201060340 126002161 126002161 42 F 18 18 12 12 3 3 3 3 13 13 14 14 105 105 2 2 1 1 B418 0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
132284 132284 201183951 201183951 307398883 307398883 58 M 21 21 31 31 43 43 12 12 18 18 14 14 105 105 1 1 1 1   0 0 0 0 0 0     1 2019-07-22 00:18:40 EDT
176255 176255 220905954 220905954 341912905 341912905 0         14 14     105 105 2 2 2 2             3 2023-06-03 02:39:18 EDT
182051 182051 220987259 220987259 342325487 342325487 0         8 8     105 105 2 2 1 1             1 2023-06-03 02:39:18 EDT
204219 204219 221246960 221246960 344681762 344681762 0         14 14     105 105 1 1 2 2             3 2023-06-03 02:39:19 EDT
204859 204859 221261704 221261704 344752696 344752696 0         14 14     105 105 2 2 2 2             1 2023-06-03 02:39:19 EDT
205830 205830 221279110 221279110 344843362 344843362 0         14 14     105 105 1 1 2 2             1 2023-06-03 02:39:19 EDT
206272 206272 221285026 221285026 344871413 344871413 0         14 14     105 105 2 2 2 2             1 2023-06-03 02:39:19 EDT
209040 209040 221335052 221335052 344841655 344841655 0         14 14     105 105 2 2               3 2023-06-03 02:39:19 EDT
215221 215221 221457724 221457724 345880041 345880041 0         14 14     105 105 3 3               3 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])
);