Interactive Demo

{
   "rows": "https://api-v2.onetcenter.org/database/rows/knowledge",
   "table_id": "knowledge",
   "title": "Knowledge",
   "description": "Provide a mapping of O*NET-SOC codes (occupations) to Knowledge ratings.",
   "data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/knowledge.html",
   "download": {
      "excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Knowledge.xlsx",
      "text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Knowledge.txt",
      "mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/15_knowledge.sql",
      "sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/15_knowledge.sql",
      "oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/15_knowledge.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": "element_id",
         "optional": false,
         "title": "Element ID",
         "description": "Content Model Outline Position",
         "type": "Text",
         "format": "Character Varying(20)"
      },
      {
         "column_id": "element_name",
         "optional": false,
         "title": "Element Name",
         "description": "Content Model Element Name",
         "type": "Text",
         "format": "Character Varying(150)"
      },
      {
         "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": "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": "not_relevant",
         "optional": true,
         "title": "Not Relevant",
         "description": "Not relevant for the occupation (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)"
      }
   ]
}