Interactive Demo

{
   "rows": "https://api-v2.onetcenter.org/database/rows/task_statements",
   "table_id": "task_statements",
   "title": "Task Statements",
   "description": "Provide a mapping of O*NET-SOC codes (occupations) to tasks associated with the occupation.",
   "data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/task_statements.html",
   "download": {
      "excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Task%20Statements.xlsx",
      "text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Task%20Statements.txt",
      "mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/17_task_statements.sql",
      "sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/17_task_statements.sql",
      "oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/17_task_statements.sql"
   },
   "column": [
      {
         "column_id": "onetsoc_code",
         "optional": false,
         "title": "O*NET-SOC Code",
         "description": "O*NET-SOC Code",
         "type": "Text",
         "format": "Character(10)"
      },
      {
         "column_id": "title",
         "optional": false,
         "title": "Title",
         "description": "O*NET-SOC Title",
         "type": "Text",
         "format": "Character Varying(150)"
      },
      {
         "column_id": "task_id",
         "optional": false,
         "title": "Task ID",
         "description": "Identifies each task",
         "type": "Number",
         "format": "Integer(8)"
      },
      {
         "column_id": "task",
         "optional": false,
         "title": "Task",
         "description": "Task statement associated with an occupation",
         "type": "Text",
         "format": "Character Varying(1000)"
      },
      {
         "column_id": "task_type",
         "optional": true,
         "title": "Task Type",
         "description": "<quote>Core</quote> or <quote>Supplemental</quote>",
         "type": "Text",
         "format": "Character Varying(12)"
      },
      {
         "column_id": "incumbents_responding",
         "optional": true,
         "title": "Incumbents Responding",
         "description": "Number of incumbents providing task information",
         "type": "Number",
         "format": "Integer(4)"
      },
      {
         "column_id": "date_updated",
         "optional": false,
         "title": "Date",
         "description": "Date when data was updated",
         "type": "Date",
         "format": "Date"
      },
      {
         "column_id": "domain_source",
         "optional": false,
         "title": "Domain Source",
         "description": "Source of the data",
         "type": "Text",
         "format": "Character Varying(30)"
      }
   ]
}