Reference Manual (API Version 1.9)
List of data tables
https://services.onetcenter.org/v1.9/ws/database/
JSON
XML
{
"table" : [
{
"info" : "https://services.onetcenter.org/v1.9/ws/database/info/content_model_reference",
"rows" : "https://services.onetcenter.org/v1.9/ws/database/rows/content_model_reference",
"table_id" : "content_model_reference",
"title" : "Content Model Reference",
"description" : "Provide O*NET Content Model elements."
},
{
"info" : "https://services.onetcenter.org/v1.9/ws/database/info/job_zone_reference",
"rows" : "https://services.onetcenter.org/v1.9/ws/database/rows/job_zone_reference",
"table_id" : "job_zone_reference",
"title" : "Job Zone Reference",
"description" : "Provide Job Zone data (developed to help transition DOT’s measures of Specific Vocational Preparation (SVP) to O*NET’s measure of experience, education, and job training)."
},
...
]
}
"table" : [
{
"info" : "https://services.onetcenter.org/v1.9/ws/database/info/content_model_reference",
"rows" : "https://services.onetcenter.org/v1.9/ws/database/rows/content_model_reference",
"table_id" : "content_model_reference",
"title" : "Content Model Reference",
"description" : "Provide O*NET Content Model elements."
},
{
"info" : "https://services.onetcenter.org/v1.9/ws/database/info/job_zone_reference",
"rows" : "https://services.onetcenter.org/v1.9/ws/database/rows/job_zone_reference",
"table_id" : "job_zone_reference",
"title" : "Job Zone Reference",
"description" : "Provide Job Zone data (developed to help transition DOT’s measures of Specific Vocational Preparation (SVP) to O*NET’s measure of experience, education, and job training)."
},
...
]
}
JSON
XML
<tables>
<table info="https://services.onetcenter.org/v1.9/ws/database/info/content_model_reference" rows="https://services.onetcenter.org/v1.9/ws/database/rows/content_model_reference">
<table_id>content_model_reference</table_id>
<title>Content Model Reference</title>
<description>Provide O*NET Content Model elements.</description>
</table>
<table info="https://services.onetcenter.org/v1.9/ws/database/info/job_zone_reference" rows="https://services.onetcenter.org/v1.9/ws/database/rows/job_zone_reference">
<table_id>job_zone_reference</table_id>
<title>Job Zone Reference</title>
<description>Provide Job Zone data (developed to help transition DOT’s measures of Specific Vocational Preparation (SVP) to O*NET’s measure of experience, education, and job training).</description>
</table>
...
</tables>
<table info="https://services.onetcenter.org/v1.9/ws/database/info/content_model_reference" rows="https://services.onetcenter.org/v1.9/ws/database/rows/content_model_reference">
<table_id>content_model_reference</table_id>
<title>Content Model Reference</title>
<description>Provide O*NET Content Model elements.</description>
</table>
<table info="https://services.onetcenter.org/v1.9/ws/database/info/job_zone_reference" rows="https://services.onetcenter.org/v1.9/ws/database/rows/job_zone_reference">
<table_id>job_zone_reference</table_id>
<title>Job Zone Reference</title>
<description>Provide Job Zone data (developed to help transition DOT’s measures of Specific Vocational Preparation (SVP) to O*NET’s measure of experience, education, and job training).</description>
</table>
...
</tables>
This response lists the O*NET Database tables available. Each table corresponds to a single file in the downloadable O*NET Database. Each entry includes:
- info - Link to the corresponding Table column information service.
- rows - Link to the corresponding Data rows service.
- table_id - The table name used in the MySQL, SQL Server, and Oracle versions of the Database.
- title - The file name used in the Excel and text versions of the Database.
- description - A short summary of the table's purpose.
For more information about the content in each table, along with links to relevant research and technical reports, see the O*NET Data Dictionary.
In this section
- Database Services
- List of data tables
- Table column information
- Data rows
- Filter and sort examples