occupation
- accident_code
- OSHA-170 form code group.
- accident_letter
- Sub-letter within the code group.
- accident_number
- Code key (referenced by accident_injury.occ_code).
- accident_value
- Human-readable occupation description.
- load_dt
- Timestamp when this row was loaded.
573 rows
Suggested facets: load_dt, load_dt (date)
| accident_number ▼ | accident_code | accident_value | accident_letter | load_dt |
|---|---|---|---|---|
| 0 | OCC | Occupation Not Listed | 2018-11-09 20:56:00 | |
| 3 | OCC | Legislators | 2018-11-09 20:56:00 | |
| 4 | OCC | Chief exec's & gen'l administrators, public admin. | 2018-11-09 20:56:00 | |
| 5 | OCC | Administrators & officials, public administration | 2018-11-09 20:56:00 | |
| 6 | OCC | Administrators, protective services | 2018-11-09 20:56:00 | |
| 7 | OCC | Financial managers | 2018-11-09 20:56:00 | |
| 8 | OCC | Personnel and labor relations managers | 2018-11-09 20:56:00 | |
| 9 | OCC | Purchasing managers | 2018-11-09 20:56:00 | |
| 13 | OCC | Managers, marketing, advertising, & public rela. | 2018-11-09 20:56:00 | |
| 14 | OCC | Administrators, education and related fields | 2018-11-09 20:56:00 | |
| 15 | OCC | Managers, medicine and health | 2018-11-09 20:56:00 | |
| 16 | OCC | Managers, properties and real estate | 2018-11-09 20:56:00 | |
| 17 | OCC | Postmasters and mail superintendents | 2018-11-09 20:56:00 | |
| 18 | OCC | Funeral directors | 2018-11-09 20:56:00 | |
| 19 | OCC | Managers and administrators, n.e.c | 2018-11-09 20:56:01 | |
| 22 | OCC | Managers And Administrators, N.E.C | 2018-11-09 20:56:01 | |
| 23 | OCC | Accountants and auditors | 2018-11-09 20:56:01 | |
| 24 | OCC | Underwriters | 2018-11-09 20:56:01 | |
| 25 | OCC | Other financial officers | 2018-11-09 20:56:01 | |
| 26 | OCC | Management Analysts | 2018-11-09 20:56:01 | |
| 27 | OCC | Personnel, training & labor relations specialists | 2018-11-09 20:56:01 | |
| 28 | OCC | Purchasing agents and buyers, farm products | 2018-11-09 20:56:01 | |
| 29 | OCC | Buyers, wholesale & retail trade except farm prod. | 2018-11-09 20:56:01 | |
| 33 | OCC | Purchasing agents and buyers n.e.c. | 2018-11-09 20:56:01 | |
| 34 | OCC | Business and promotion agents | 2018-11-09 20:56:01 | |
| 35 | OCC | Construction inspectors | 2018-11-09 20:56:01 | |
| 36 | OCC | Inspectors and compliance officers except constr. | 2018-11-09 20:56:01 | |
| 37 | OCC | Management related occupations, n.e.c. | 2018-11-09 20:56:01 | |
| 43 | OCC | Architects | 2018-11-09 20:56:01 | |
| 44 | OCC | Aerospace engineers | 2018-11-09 20:56:01 | |
| 45 | OCC | Metallurgical and materials engineers | 2018-11-09 20:56:01 | |
| 46 | OCC | Mining engineers | 2018-11-09 20:56:01 | |
| 47 | OCC | Petroleum engineers | 2018-11-09 20:56:01 | |
| 48 | OCC | Chemical engineers | 2018-11-09 20:56:01 | |
| 49 | OCC | Nuclear engineers | 2018-11-09 20:56:01 | |
| 53 | OCC | Civil engineers | 2018-11-09 20:56:01 | |
| 54 | OCC | Agricultural engineers | 2018-11-09 20:56:01 | |
| 55 | OCC | Electrical and electronic engineers | 2018-11-09 20:56:01 | |
| 56 | OCC | Industrial engineers | 2018-11-09 20:56:01 | |
| 57 | OCC | Mechanical engineers | 2018-11-09 20:56:01 | |
| 58 | OCC | Marine engineers and naval architects | 2018-11-09 20:56:01 | |
| 59 | OCC | Engineers, n.e.c. | 2018-11-09 20:56:01 | |
| 63 | OCC | Surveyors and mapping scientists | 2018-11-09 20:56:01 | |
| 64 | OCC | Computer systems analysts and scientists | 2018-11-09 20:56:01 | |
| 65 | OCC | Operations & systems researchers and analysts | 2018-11-09 20:56:01 | |
| 66 | OCC | Actuaries | 2018-11-09 20:56:01 | |
| 67 | OCC | Statisticians | 2018-11-09 20:56:01 | |
| 68 | OCC | Mathematical scientists, n.e.c. | 2018-11-09 20:56:01 | |
| 69 | OCC | Physicists and astronomers | 2018-11-09 20:56:01 | |
| 73 | OCC | Chemists, except biochemists | 2018-11-09 20:56:01 | |
| 74 | OCC | Atmospheric and space scientists | 2018-11-09 20:56:01 | |
| 75 | OCC | Geologists and geodesists | 2018-11-09 20:56:01 | |
| 76 | OCC | Physical scientists, n.e.c. | 2018-11-09 20:56:01 | |
| 77 | OCC | Agricultural and food scientists | 2018-11-09 20:56:01 | |
| 78 | OCC | Biological and life scientists | 2018-11-09 20:56:01 | |
| 79 | OCC | Forestry and conservation scientists | 2018-11-09 20:56:01 | |
| 83 | OCC | Medical scientists | 2018-11-09 20:56:01 | |
| 84 | OCC | Physicians | 2018-11-09 20:56:01 | |
| 85 | OCC | Dentists | 2018-11-09 20:56:01 | |
| 86 | OCC | Veterinarians | 2018-11-09 20:56:01 | |
| 87 | OCC | Optometrists | 2018-11-09 20:56:01 | |
| 88 | OCC | Podiatrists | 2018-11-09 20:56:01 | |
| 89 | OCC | Health diagnosing practitioners, n.e.c. | 2018-11-09 20:56:01 | |
| 95 | OCC | Registered nurses | 2018-11-09 20:56:01 | |
| 96 | OCC | Pharmacists | 2018-11-09 20:56:01 | |
| 97 | OCC | Dieticians | 2018-11-09 20:56:01 | |
| 98 | OCC | Inhalation therapists | 2018-11-09 20:56:01 | |
| 99 | OCC | Occupational therapists | 2018-11-09 20:56:01 | |
| 103 | OCC | Physical therapists | 2018-11-09 20:56:01 | |
| 104 | OCC | Speech therapists | 2018-11-09 20:56:01 | |
| 105 | OCC | Therapists, n.e.c. | 2018-11-09 20:56:01 | |
| 106 | OCC | Physician's assistants | 2018-11-09 20:56:01 | |
| 113 | OCC | Earth, environmental & marine science teachers | 2018-11-09 20:56:01 | |
| 114 | OCC | Biological science teachers | 2018-11-09 20:56:01 | |
| 115 | OCC | Chemistry teachers | 2018-11-09 20:56:01 | |
| 116 | OCC | Physics teachers | 2018-11-09 20:56:01 | |
| 117 | OCC | Natural science teachers, n.e.c. | 2018-11-09 20:56:01 | |
| 118 | OCC | Psychology teachers | 2018-11-09 20:56:01 | |
| 119 | OCC | Economics teachers | 2018-11-09 20:56:01 | |
| 123 | OCC | History teachers | 2018-11-09 20:56:01 | |
| 124 | OCC | Political science teachers | 2018-11-09 20:56:01 | |
| 125 | OCC | Sociology teachers | 2018-11-09 20:56:01 | |
| 126 | OCC | Social science teachers, n.e.c. | 2018-11-09 20:56:01 | |
| 127 | OCC | Engineering teachers | 2018-11-09 20:56:01 | |
| 128 | OCC | Mathematical science teachers | 2018-11-09 20:56:01 | |
| 129 | OCC | Computer science teachers | 2018-11-09 20:56:01 | |
| 133 | OCC | Medical science teachers | 2018-11-09 20:56:01 | |
| 134 | OCC | Health specialties teachers | 2018-11-09 20:56:01 | |
| 135 | OCC | Business, commerce and marketing teachers | 2018-11-09 20:56:01 | |
| 136 | OCC | Agriculture and forestry teachers | 2018-11-09 20:56:01 | |
| 137 | OCC | Art, drama and music teachers | 2018-11-09 20:56:01 | |
| 138 | OCC | Physical education teachers | 2018-11-09 20:56:01 | |
| 139 | OCC | Education teachers | 2018-11-09 20:56:01 | |
| 143 | OCC | English teachers | 2018-11-09 20:56:01 | |
| 144 | OCC | Foreign language teachers | 2018-11-09 20:56:01 | |
| 145 | OCC | Law teachers | 2018-11-09 20:56:01 | |
| 146 | OCC | Social work teachers | 2018-11-09 20:56:01 | |
| 147 | OCC | Theology teachers | 2018-11-09 20:56:01 | |
| 148 | OCC | Trade and industrial teachers | 2018-11-09 20:56:01 | |
| 149 | OCC | Home economics teachers | 2018-11-09 20:56:01 |
Table schema
CREATE TABLE occupation(accident_code VARCHAR, accident_number BIGINT, accident_value VARCHAR, accident_letter BIGINT, load_dt TIMESTAMP, PRIMARY KEY(accident_number));