Interactive Demo

{
   "rows": "https://api-v2.onetcenter.org/database/rows/task_ratings",
   "table_id": "task_ratings",
   "title": "Task Ratings",
   "description": "Provide a mapping of O*NET-SOC codes (occupations) to the ratings for tasks associated with the occupation.",
   "data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/task_ratings.html",
   "download": {
      "excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Task%20Ratings.xlsx",
      "text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Task%20Ratings.txt",
      "mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/18_task_ratings.sql",
      "sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/18_task_ratings.sql",
      "oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/18_task_ratings.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": "scale_id",
         "optional": false,
         "title": "Scale ID",
         "description": "Scale ID",
         "type": "Text",
         "format": "Character Varying(3)"
      },
      {
         "column_id": "scale_name",
         "optional": false,
         "title": "Scale Name",
         "description": "Scale Name",
         "type": "Text",
         "format": "Character Varying(50)"
      },
      {
         "column_id": "category",
         "optional": true,
         "title": "Category",
         "description": "Percent frequency category",
         "type": "Number",
         "format": "Integer(3)"
      },
      {
         "column_id": "data_value",
         "optional": false,
         "title": "Data Value",
         "description": "Rating associated with the O*NET-SOC occupation",
         "type": "Number",
         "format": "Float(5,2)"
      },
      {
         "column_id": "n",
         "optional": true,
         "title": "N",
         "description": "Sample size",
         "type": "Number",
         "format": "Integer(4)"
      },
      {
         "column_id": "standard_error",
         "optional": true,
         "title": "Standard Error",
         "description": "Standard Error",
         "type": "Number",
         "format": "Float(7,4)"
      },
      {
         "column_id": "lower_ci_bound",
         "optional": true,
         "title": "Lower CI Bound",
         "description": "Lower 95% confidence interval bound",
         "type": "Number",
         "format": "Float(7,4)"
      },
      {
         "column_id": "upper_ci_bound",
         "optional": true,
         "title": "Upper CI Bound",
         "description": "Upper 95% confidence interval bound",
         "type": "Number",
         "format": "Float(7,4)"
      },
      {
         "column_id": "recommend_suppress",
         "optional": true,
         "title": "Recommend Suppress",
         "description": "Low precision indicator (Y=yes, N=no)",
         "type": "Text",
         "format": "Character(1)"
      },
      {
         "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)"
      }
   ]
}