accident_injury
where occ_code = 8
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55055 | 55055 | 14303978 14303978 | 18685701 18685701 | 60 | F | 21 21 | 31 31 | 16 16 | 14 14 | 7 7 | 4 4 | 8 8 | 3 3 | 1 1 | 8880 | 0 0 | 0 0 | 0 0 | 45 | 2019-07-22 00:18:39 EDT | ||
| 111669 | 111669 | 200710051 200710051 | 300510674 300510674 | 63 | M | 2 2 | 4 4 | 16 16 | 8 8 | 7 7 | 1 1 | 8 8 | 1 1 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 118304 | 118304 | 201020765 201020765 | 125535161 125535161 | 30 | F | 18 18 | 18 18 | 30 30 | 1 1 | 2 2 | 12 12 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 119848 | 119848 | 201041530 201041530 | 306789496 306789496 | 45 | M | 7 7 | 19 19 | 34 34 | 14 14 | 18 18 | 14 14 | 8 8 | 1 1 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 121252 | 121252 | 201059722 201059722 | 307164764 307164764 | 48 | M | 12 12 | 11 11 | 28 28 | 1 1 | 18 18 | 6 6 | 8 8 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 124640 | 124640 | 201094257 201094257 | 126147248 126147248 | 53 | M | 6 6 | 13 13 | 42 42 | 4 4 | 13 13 | 15 15 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 124680 | 124680 | 201094661 201094661 | 126147933 126147933 | 21 | M | 12 12 | 16 16 | 24 24 | 5 5 | 13 13 | 9 9 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 124830 | 124830 | 201096146 201096146 | 300813979 300813979 | 19 | F | 5 5 | 9 9 | 9 9 | 14 14 | 10 10 | 4 4 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 127812 | 127812 | 201128444 201128444 | 310100490 310100490 | 38 | M | 7 7 | 11 11 | 26 26 | 2 2 | 1 1 | 14 14 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 132968 | 132968 | 201203478 201203478 | 309427060 309427060 | 49 | F | 12 12 | 3 3 | 42 42 | 5 5 | 13 13 | 14 14 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:40 EDT | |||
| 140882 | 140882 | 201508546 201508546 | 310063730 310063730 | 50 | M | 12 12 | 14 14 | 27 27 | 5 5 | 8 8 | 1 1 | 8 8 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 144584 | 144584 | 201681129 201681129 | 303702765 303702765 | 44 | M | 12 12 | 16 16 | 8 8 | 5 5 | 13 13 | 1 1 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 150744 | 150744 | 202005625 202005625 | 315817569 315817569 | 45 | M | 12 12 | 4 4 | 7 7 | 1 1 | 6 6 | 11 11 | 8 8 | 1 1 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 153591 | 153591 | 202312773 202312773 | 119688554 119688554 | 29 | F | 1 1 | 10 10 | 26 26 | 6 6 | 3 3 | 1 1 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 157124 | 157124 | 202446910 202446910 | 310600960 310600960 | 46 | M | 1 1 | 23 23 | 43 43 | 2 2 | 8 8 | 5 5 | 8 8 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 157826 | 157826 | 202454989 202454989 | 310492426 310492426 | 43 | M | 21 21 | 13 13 | 25 25 | 5 5 | 13 13 | 14 14 | 8 8 | 2 2 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 158262 | 158262 | 202459293 202459293 | 316982552 316982552 | 53 | M | 5 5 | 19 19 | 16 16 | 14 14 | 10 10 | 8 8 | 8 8 | 2 2 | 2 2 | 0070 | 0 0 | 0 0 | 0 0 | 1 | 2017-03-20 01:00:11 EDT | ||
| 159289 | 159289 | 202471603 202471603 | 314828575 314828575 | 30 | M | 1 1 | 10 10 | 21 21 | 2 2 | 3 3 | 9 9 | 8 8 | 3 3 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 163449 | 163449 | 202531711 202531711 | 313647612 313647612 | 59 | M | 12 12 | 19 19 | 27 27 | 1 1 | 2 2 | 14 14 | 8 8 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 165336 | 165336 | 202558169 202558169 | 317387124 317387124 | 42 | M | 1 1 | 10 10 | 43 43 | 2 2 | 18 18 | 14 14 | 8 8 | 3 3 | 1 1 | 0 0 | 0 0 | 0 0 | 1 | 2017-03-20 01:00:11 EDT | |||
| 166794 | 166794 | 202608014 202608014 | 314068537 314068537 | 68 | M | 12 12 | 19 19 | 43 43 | 5 5 | 13 13 | 1 1 | 8 8 | 2 2 | 1 1 | 8880 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | ||
| 168334 | 168334 | 202658795 202658795 | 316672781 316672781 | 55 | M | 12 12 | 11 11 | 30 30 | 2 2 | 18 18 | 1 1 | 8 8 | 2 2 | 2 2 | 0 0 | 0 0 | 0 0 | 1 | 2019-07-22 00:18:41 EDT | |||
| 170564 | 170564 | 220382568 220382568 | 338244213 338244213 | 0 | 8 8 | 8 8 | 1 1 | 2 2 | 1 | 2023-03-31 00:19:15 EDT | ||||||||||||
| 176044 | 176044 | 220893879 220893879 | 341821296 341821296 | 0 | 1 1 | 8 8 | 1 1 | 1 1 | 1 | 2023-03-31 00:19:15 EDT | ||||||||||||
| 176486 | 176486 | 220916522 220916522 | 341996486 341996486 | 0 | 5 5 | 8 8 | 1 1 | 1 1 | 1 | 2023-03-31 00:19:15 EDT | ||||||||||||
| 190782 | 190782 | 221078652 221078652 | 343346516 343346516 | 0 | 5 5 | 8 8 | 2 2 | 2 2 | 50 50 | 6 | 7 | 1 | 2023-03-31 00:19:14 EDT | |||||||||
| 205562 | 205562 | 221282858 221282858 | 344865332 344865332 | 0 | 14 14 | 8 8 | 1 1 | 2 2 | 1 | 2023-03-31 00:19:13 EDT | ||||||||||||
| 206576 | 206576 | 221299449 221299449 | 344951777 344951777 | 0 | 14 14 | 8 8 | 1 1 | 2 2 | 1 | 2023-03-31 00:19:13 EDT | ||||||||||||
| 208592 | 208592 | 221339211 221339211 | 345189468 345189468 | 0 | 14 14 | 8 8 | 1 1 | 1 | 2023-03-31 00:19:14 EDT | |||||||||||||
| 210835 | 210835 | 221399033 221399033 | 345515423 345515423 | 0 | 14 14 | 8 8 | 1 1 | 1 | 2023-03-31 00:19:14 EDT | |||||||||||||
| 211586 | 211586 | 221413107 221413107 | 345529036 345529036 | 0 | 14 14 | 8 8 | 1 1 | 1 | 2023-03-31 00:19:13 EDT | |||||||||||||
| 211817 | 211817 | 221416910 221416910 | 345672810 345672810 | 0 | 2 2 | 8 8 | 2 2 | 1 | 2023-03-31 00:19:13 EDT | |||||||||||||
| 214744 | 214744 | 221468028 221468028 | 345987382 345987382 | 0 | 14 14 | 8 8 | 1 1 | 1 | 2023-03-31 00:19:15 EDT | |||||||||||||
| 215328 | 215328 | 221487994 221487994 | 346144181 346144181 | 0 | 1 1 | 8 8 | 1 1 | 1 | 2023-03-31 00:19:15 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]) );