Interactive Demo

{
   "rows": "https://api-v2.onetcenter.org/database/rows/ete_categories",
   "table_id": "ete_categories",
   "title": "Education, Training, and Experience Categories",
   "description": "Provide descriptions of the Education, Training, and Experience percent frequency categories.",
   "data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/ete_categories.html",
   "download": {
      "excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Education,%20Training,%20and%20Experience%20Categories.xlsx",
      "text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Education,%20Training,%20and%20Experience%20Categories.txt",
      "mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/5_ete_categories.sql",
      "sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/5_ete_categories.sql",
      "oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/5_ete_categories.sql"
   },
   "column": [
      {
         "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": "category",
         "optional": false,
         "title": "Category",
         "description": "Category value associated with element",
         "type": "Number",
         "format": "Integer(3)"
      },
      {
         "column_id": "category_description",
         "optional": false,
         "title": "Category Description",
         "description": "Detail description of category associated with element",
         "type": "Text",
         "format": "Character Varying(1000)"
      }
   ]
}