accident_injury
where occ_code = 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42113 | 42113 | 825422 825422 | 104379698 104379698 | 43 | M | 1 1 | 10 10 | 26 26 | 1 1 | 13 13 | 1 1 | 14 14 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:38 EDT | |||
66317 | 66317 | 14492870 14492870 | 1594795 1594795 | 37 | M | 21 21 | 13 13 | 27 27 | 1 1 | 6 6 | 4 4 | 14 14 | 1 1 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:39 EDT | |||
66329 | 66329 | 14492961 14492961 | 1368356 1368356 | 30 | M | 6 6 | 4 4 | 27 27 | 1 1 | 6 6 | 1 1 | 14 14 | 1 1 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:39 EDT | |||
71745 | 71745 | 14557060 14557060 | 14961361 14961361 | 25 | M | 12 12 | 19 19 | 24 24 | 2 2 | 1 1 | 4 4 | 14 14 | 1 1 | 1 1 | 8880 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:39 EDT | ||
71759 | 71759 | 14557243 14557243 | 14960413 14960413 | 44 | M | 5 5 | 4 4 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 9 | 2019-07-22 00:18:39 EDT | |||
71760 | 71760 | 14557243 14557243 | 14960421 14960421 | 32 | M | 5 5 | 4 4 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 10 | 2019-07-22 00:18:39 EDT | |||
71761 | 71761 | 14557243 14557243 | 14960439 14960439 | 21 | M | 5 5 | 4 4 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:39 EDT | |||
71762 | 71762 | 14557243 14557243 | 14960439 14960439 | 40 | M | 5 5 | 9 9 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 2 | 2019-07-22 00:18:39 EDT | |||
71763 | 71763 | 14557243 14557243 | 14960439 14960439 | 20 | M | 5 5 | 2 2 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 3 | 2019-07-22 00:18:39 EDT | |||
71764 | 71764 | 14557243 14557243 | 14960439 14960439 | 28 | M | 5 5 | 2 2 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 4 | 2019-07-22 00:18:39 EDT | |||
71765 | 71765 | 14557243 14557243 | 14960439 14960439 | 39 | M | 5 5 | 4 4 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 5 | 2019-07-22 00:18:39 EDT | |||
71766 | 71766 | 14557243 14557243 | 14960447 14960447 | 57 | M | 5 5 | 4 4 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 8 | 2019-07-22 00:18:39 EDT | |||
71767 | 71767 | 14557243 14557243 | 14964050 14964050 | 25 | M | 5 5 | 4 4 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 6 | 2019-07-22 00:18:39 EDT | |||
71768 | 71768 | 14557243 14557243 | 14964050 14964050 | 52 | M | 5 5 | 4 4 | 16 16 | 14 14 | 7 7 | 9 9 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 7 | 2019-07-22 00:18:39 EDT | |||
132395 | 132395 | 201185113 201185113 | 312688211 312688211 | 63 | F | 12 12 | 16 16 | 43 43 | 4 4 | 18 18 | 14 14 | 14 14 | 2 2 | 1 1 | 8880 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | ||
140754 | 140754 | 201507258 201507258 | 310057591 310057591 | 64 | F | 21 21 | 11 11 | 43 43 | 4 4 | 18 18 | 14 14 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
154257 | 154257 | 202334173 202334173 | 315038695 315038695 | 31 | F | 21 21 | 19 19 | 29 29 | 1 1 | 18 18 | 14 14 | 14 14 | 1 1 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
164231 | 164231 | 202545398 202545398 | 314865148 314865148 | 58 | F | 12 12 | 22 22 | 42 42 | 4 4 | 18 18 | 14 14 | 14 14 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
173214 | 173214 | 220758098 220758098 | 340530989 340530989 | 0 | 14 14 | 14 14 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:18 EDT | ||||||||||||
173215 | 173215 | 220758098 220758098 | 340530989 340530989 | 0 | 5 5 | 14 14 | 1 1 | 2 2 | 2 | 2023-06-03 02:39:18 EDT | ||||||||||||
175714 | 175714 | 220876742 220876742 | 341691525 341691525 | 0 | 1 1 | 14 14 | 2 2 | 2 2 | 1 | 2023-06-03 02:39:18 EDT | ||||||||||||
176812 | 176812 | 220924492 220924492 | 342051240 342051240 | 0 | 8 8 | 14 14 | 2 2 | 1 1 | 1 | 2023-06-03 02:39:18 EDT | ||||||||||||
189614 | 189614 | 221066137 221066137 | 343238549 343238549 | 0 | 2 2 | 14 14 | 2 2 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
196819 | 196819 | 221142672 221142672 | 343674917 343674917 | 0 | 5 5 | 14 14 | 2 2 | 2 2 | 1 | 2023-06-03 02:39:18 EDT | ||||||||||||
203563 | 203563 | 221232523 221232523 | 344566633 344566633 | 0 | 1 1 | 14 14 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
204424 | 204424 | 221253396 221253396 | 344722848 344722848 | 0 | 14 14 | 14 14 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
204487 | 204487 | 221254683 221254683 | 344727110 344727110 | 0 | 12 12 | 14 14 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
205078 | 205078 | 221265697 221265697 | 344769674 344769674 | 0 | 14 14 | 14 14 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
207099 | 207099 | 221298656 221298656 | 344740345 344740345 | 0 | 12 12 | 14 14 | 1 1 | 2 2 | 1 | 2023-06-03 02:39:19 EDT | ||||||||||||
210383 | 210383 | 221369762 221369762 | 345026272 345026272 | 0 | 14 14 | 14 14 | 1 1 | 1 | 2023-06-03 02:39:19 EDT | |||||||||||||
211741 | 211741 | 221403231 221403231 | 345164263 345164263 | 0 | 12 12 | 14 14 | 1 1 | 1 | 2023-06-03 02:39:19 EDT | |||||||||||||
215384 | 215384 | 221462385 221462385 | 345712046 345712046 | 0 | 4 4 | 14 14 | 3 3 | 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]) );