osha_enforcement: accident_injury: where occ

where occ_code = 14

descending

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	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])
);