Interactive Demo

{
   "rows" : "https://services.onetcenter.org/ws/database/rows/knowledge",
   "table_id" : "knowledge",
   "title" : "Knowledge",
   "description" : "Provide a mapping of O*NET-SOC codes (occupations) to Knowledge ratings.",
   "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)"
      }
   ]
}