U.S. Standard Occupational Classification Codes Database v.1.0.0
1,447 Database Records
Explore the complete finalized 2018 Standard Occupational Classification system in a query-ready hierarchy. This release connects all 23 major groups, 98 minor groups, 459 broad occupations, and 867 detailed occupations through explicit parent relationships and full ancestry fields. Official definitions, Includes and Excludes guidance, All Other indicators, military-specific flags, and thousands of direct-match job titles make the data practical for validation, search, analytics, forms, research, and application development. Matching UTF-8 CSV, JSON, and SQLite formats are built from one validated record set.
Table Schema Database Field Statistics
Release structure
U.S. Standard Occupational Classification Codes Database
Review the published tables, record coverage, and field names included with release 1.0.0.
- Database
- #807
- Version
- 1.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| soc_code | text | Yes | Canonical 2018 SOC code in XX-XXXX form. |
| occupation_title | text | Yes | Official SOC classification title. |
| classification_level | text | Yes | Official hierarchy level: major_group, minor_group, broad_occupation, or detailed_occupation. |
| parent_code | text | No | Immediate parent SOC code, empty only for major groups. |
| major_group_code | text | Yes | Major-group ancestor code. |
| major_group_title | text | Yes | Major-group ancestor title. |
| minor_group_code | text | No | Minor-group ancestor code when applicable. |
| minor_group_title | text | No | Minor-group ancestor title when applicable. |
| broad_occupation_code | text | No | Broad-occupation ancestor code when applicable. |
| broad_occupation_title | text | No | Broad-occupation ancestor title when applicable. |
| detailed_occupation_code | text | No | Detailed-occupation code for detailed rows. |
| detailed_occupation_title | text | No | Detailed-occupation title for detailed rows. |
| definition | text | No | Official BLS definition where published. |
| included_occupations | text | No | Source-faithful Includes sentences separated from the definition where present. |
| excluded_occupations | text | No | Source-faithful Excludes sentences separated from the definition where present. |
| direct_match_titles | text | No | Deterministically sorted direct-match titles joined with a vertical bar delimiter. |
| direct_match_title_count | integer | Yes | Number of related direct-match titles. |
| all_other_flag | boolean | Yes | True when the official title ends with All Other. |
| residual_category_flag | boolean | Yes | True for official residual detailed occupations, including All Other categories. |
| military_specific_flag | boolean | Yes | True for nodes in Major Group 55-0000. |
| soc_edition | text | Yes | Released federal classification edition. |
| effective_year | integer | Yes | SOC reference year. |
| source_file | text | Yes | Official workbook supporting the row. |
| source_url | text | Yes | Direct official BLS source URL. |
| source_retrieved_at | text | Yes | UTC retrieval timestamp for pinned source evidence. |
| reviewed_date | text | Yes | Oddity release review date. |
Release at a glance
What is inside this database
Review verified record totals, geographic coverage, classifications, and field completeness for U.S. Standard Occupational Classification Codes Database.
soc_codeCanonical 2018 SOC code in XX-XXXX form.
- Distinct
- 1,447
- Missing
- 0.0%
occupation_titleOfficial SOC classification title.
- Distinct
- 1,184
- Missing
- 0.0%
classification_levelOfficial hierarchy level: major_group, minor_group, broad_occupation, or detailed_occupation.
- Distinct
- 4
- Missing
- 0.0%
parent_codeImmediate parent SOC code, empty only for major groups.
- Distinct
- 581
- Missing
- 1.6%
major_group_codeMajor-group ancestor code.
- Distinct
- 23
- Missing
- 0.0%
major_group_titleMajor-group ancestor title.
- Distinct
- 23
- Missing
- 0.0%
minor_group_codeMinor-group ancestor code when applicable.
- Distinct
- 99
- Missing
- 1.6%
minor_group_titleMinor-group ancestor title when applicable.
- Distinct
- 99
- Missing
- 1.6%
broad_occupation_codeBroad-occupation ancestor code when applicable.
- Distinct
- 460
- Missing
- 8.4%
broad_occupation_titleBroad-occupation ancestor title when applicable.
- Distinct
- 460
- Missing
- 8.4%
detailed_occupation_codeDetailed-occupation code for detailed rows.
- Distinct
- 868
- Missing
- 40.1%
detailed_occupation_titleDetailed-occupation title for detailed rows.
- Distinct
- 868
- Missing
- 40.1%
definitionOfficial BLS definition where published.
- Distinct
- 868
- Missing
- 40.1%
included_occupationsSource-faithful Includes sentences separated from the definition where present.
- Distinct
- 106
- Missing
- 90.5%
excluded_occupationsSource-faithful Excludes sentences separated from the definition where present.
- Distinct
- 243
- Missing
- 82.0%
direct_match_titlesDeterministically sorted direct-match titles joined with a vertical bar delimiter.
- Distinct
- 865
- Missing
- 40.3%
direct_match_title_countNumber of related direct-match titles.
- Distinct
- 38
- Missing
- 0.0%
all_other_flagTrue when the official title ends with All Other.
- Distinct
- 2
- Missing
- 0.0%
residual_category_flagTrue for official residual detailed occupations, including All Other categories.
- Distinct
- 2
- Missing
- 0.0%
military_specific_flagTrue for nodes in Major Group 55-0000.
- Distinct
- 2
- Missing
- 0.0%
soc_editionReleased federal classification edition.
- Distinct
- 1
- Missing
- 0.0%
effective_yearSOC reference year.
- Distinct
- 1
- Missing
- 0.0%
source_fileOfficial workbook supporting the row.
- Distinct
- 1
- Missing
- 0.0%
source_urlDirect official BLS source URL.
- Distinct
- 1
- Missing
- 0.0%
source_retrieved_atUTC retrieval timestamp for pinned source evidence.
- Distinct
- 1
- Missing
- 0.0%
reviewed_dateOddity release review date.
- Distinct
- 1
- Missing
- 0.0%
Hierarchy
- Detailed Occupation867
- Broad Occupation459
- Minor Group98
- Major Group23
Records Information
One primary record represents one official node in the finalized 2018 SOC hierarchy. Codes remain text in canonical XX-XXXX form. Every non-major node has one immediate parent and a complete chain to its major group. Official direct-match titles are stored in a deterministic multivalue field and in a normalized SQLite child table. Proposed 2028 revisions and OEWS wage or employment estimates are excluded.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
Need a closer fit?
Data shaped around your project.
Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.RECENT DATA UPDATES
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needsLicense rights
Free Publication
Read the complete Oddity Software Free Publication License
Use, modify, analyze, publish and share the complete free dataset with all required source notices and the release version.
Downloads of an eligible purchased version are unlimited while it remains the current public version. A newer release does not automatically become part of the earlier order.
A clear path from download to project
Get more from your data
Understand the files, check the sample coverage, and choose the license that fits your use.