{
  "id" : "p49q-hirr",
  "name" : "Policies que han realitzat cursos formatius de promoció",
  "assetType" : "dataset",
  "attribution" : "Departament d'Interior i Seguretat Pública",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Seguretat",
  "createdAt" : 1662449312,
  "description" : "Nombre total d’agents de policia que han realitzat cursos formatius per a la promoció interna, classificats segons el nom del curs de capacitació i segons el cos policial al qual pertanyen: Mossos d’Esquadra, Policia Local o Policia Portuària.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 448,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2424108,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1662449923,
  "publicationGroup" : 1643482,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1788351567,
  "rowsUpdatedBy" : "8j6v-u3ey",
  "tableId" : 1643482,
  "totalTimesRated" : 0,
  "viewCount" : 1086,
  "viewLastModified" : 1789569983,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1662456066,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1214631,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1662456066,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1662456066,
      "failureCount" : 0,
      "startedAt" : 1662456066,
      "status" : "success"
    },
    "submitter" : {
      "id" : "3h7c-pnc7",
      "displayName" : "ignasicabilla@gencat.cat"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 22393691,
    "name" : "Any",
    "dataTypeName" : "number",
    "description" : "Any de la informació",
    "fieldName" : "any",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 14451588,
    "cachedContents" : {
      "non_null" : "63",
      "largest" : "2025",
      "null" : "0",
      "top" : [ {
        "item" : "2024",
        "count" : "7"
      }, {
        "item" : "2021",
        "count" : "7"
      }, {
        "item" : "2022",
        "count" : "7"
      }, {
        "item" : "2019",
        "count" : "7"
      }, {
        "item" : "2018",
        "count" : "7"
      }, {
        "item" : "2023",
        "count" : "7"
      }, {
        "item" : "2017",
        "count" : "7"
      }, {
        "item" : "2025",
        "count" : "7"
      }, {
        "item" : "2020",
        "count" : "7"
      } ],
      "smallest" : "2017",
      "count" : "63",
      "cardinality" : "63"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 22393690,
    "name" : "Curs",
    "dataTypeName" : "text",
    "description" : "Nom del curs de capacitació per a la promoció",
    "fieldName" : "curs",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 14451587,
    "cachedContents" : {
      "non_null" : "63",
      "largest" : "Sotsinspector/a",
      "null" : "0",
      "top" : [ {
        "item" : "Intendent/a",
        "count" : "9"
      }, {
        "item" : "Inspector/a",
        "count" : "9"
      }, {
        "item" : "Sotsinspector/a",
        "count" : "9"
      }, {
        "item" : "Caporal/a",
        "count" : "9"
      }, {
        "item" : "Major - superintendent/a",
        "count" : "9"
      }, {
        "item" : "Sergent/a",
        "count" : "9"
      }, {
        "item" : "Comissari/a - intendent/a major",
        "count" : "9"
      } ],
      "smallest" : "Caporal/a",
      "count" : "63",
      "cardinality" : "63"
    },
    "format" : { }
  }, {
    "id" : 22393689,
    "name" : "Mossos",
    "dataTypeName" : "number",
    "description" : "Nombre total de mossos",
    "fieldName" : "mossos",
    "position" : 3,
    "renderTypeName" : "number",
    "tableColumnId" : 14451586,
    "cachedContents" : {
      "non_null" : "63",
      "largest" : "368",
      "null" : "0",
      "top" : [ {
        "item" : "0",
        "count" : "42"
      }, {
        "item" : "1",
        "count" : "2"
      }, {
        "item" : "10",
        "count" : "2"
      }, {
        "item" : "18",
        "count" : "2"
      }, {
        "item" : "8",
        "count" : "2"
      }, {
        "item" : "24",
        "count" : "1"
      }, {
        "item" : "218",
        "count" : "1"
      }, {
        "item" : "368",
        "count" : "1"
      }, {
        "item" : "6",
        "count" : "1"
      }, {
        "item" : "96",
        "count" : "1"
      }, {
        "item" : "67",
        "count" : "1"
      }, {
        "item" : "25",
        "count" : "1"
      }, {
        "item" : "4",
        "count" : "1"
      }, {
        "item" : "12",
        "count" : "1"
      }, {
        "item" : "134",
        "count" : "1"
      }, {
        "item" : "2",
        "count" : "1"
      }, {
        "item" : "171",
        "count" : "1"
      }, {
        "item" : "44",
        "count" : "1"
      } ],
      "smallest" : "0",
      "count" : "63",
      "cardinality" : "63"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 22393688,
    "name" : "Policia local",
    "dataTypeName" : "number",
    "description" : "Nombre total d'agents de policies locals",
    "fieldName" : "policia_local",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 14451585,
    "cachedContents" : {
      "non_null" : "63",
      "largest" : "245",
      "null" : "0",
      "top" : [ {
        "item" : "0",
        "count" : "25"
      }, {
        "item" : "3",
        "count" : "3"
      }, {
        "item" : "1",
        "count" : "3"
      }, {
        "item" : "2",
        "count" : "2"
      }, {
        "item" : "96",
        "count" : "2"
      }, {
        "item" : "12",
        "count" : "2"
      }, {
        "item" : "11",
        "count" : "2"
      }, {
        "item" : "128",
        "count" : "1"
      }, {
        "item" : "91",
        "count" : "1"
      }, {
        "item" : "245",
        "count" : "1"
      }, {
        "item" : "52",
        "count" : "1"
      }, {
        "item" : "18",
        "count" : "1"
      }, {
        "item" : "20",
        "count" : "1"
      }, {
        "item" : "4",
        "count" : "1"
      }, {
        "item" : "21",
        "count" : "1"
      }, {
        "item" : "93",
        "count" : "1"
      }, {
        "item" : "213",
        "count" : "1"
      }, {
        "item" : "26",
        "count" : "1"
      }, {
        "item" : "24",
        "count" : "1"
      }, {
        "item" : "50",
        "count" : "1"
      } ],
      "smallest" : "0",
      "count" : "63",
      "cardinality" : "63"
    },
    "format" : {
      "decimalSeparator" : ",",
      "noCommas" : "false",
      "groupSeparator" : "."
    }
  }, {
    "id" : 22393687,
    "name" : "Policia portuària",
    "dataTypeName" : "number",
    "description" : "Nombre total d’agents de la Policia Portuària",
    "fieldName" : "policia_portu_ria",
    "position" : 5,
    "renderTypeName" : "number",
    "tableColumnId" : 14451584,
    "cachedContents" : {
      "non_null" : "63",
      "largest" : "9",
      "null" : "0",
      "top" : [ {
        "item" : "0",
        "count" : "49"
      }, {
        "item" : "3",
        "count" : "4"
      }, {
        "item" : "1",
        "count" : "3"
      }, {
        "item" : "4",
        "count" : "3"
      }, {
        "item" : "2",
        "count" : "2"
      }, {
        "item" : "6",
        "count" : "1"
      }, {
        "item" : "9",
        "count" : "1"
      } ],
      "smallest" : "0",
      "count" : "63",
      "cardinality" : "63"
    },
    "format" : {
      "decimalSeparator" : ",",
      "noCommas" : "false",
      "groupSeparator" : "."
    }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Variable"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Police officers who have completed training courses for internal promotion",
        "Nombre del conjunto de datos (ES)" : "Policías que han realizado cursos formativos de promoción interna"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No"
      },
      "Actors" : {
        "Departament" : "Interior i Seguretat Pública",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Sense informació geogràfica",
        "Àmbit geogràfic" : "Catalunya"
      }
    },
    "availableDisplayTypes" : [ "table", "fatrow", "page" ]
  },
  "owner" : {
    "id" : "a4b5-gx6v",
    "displayName" : "Dades Obertes Catalunya",
    "profileImageUrlLarge" : "/api/users/a4b5-gx6v/profile_images/LARGE",
    "profileImageUrlMedium" : "/api/users/a4b5-gx6v/profile_images/THUMB",
    "profileImageUrlSmall" : "/api/users/a4b5-gx6v/profile_images/TINY",
    "screenName" : "Dades Obertes Catalunya",
    "type" : "interactive",
    "flags" : [ "acceptedEula" ]
  },
  "query" : { },
  "rights" : [ "read" ],
  "tableAuthor" : {
    "id" : "a4b5-gx6v",
    "displayName" : "Dades Obertes Catalunya",
    "profileImageUrlLarge" : "/api/users/a4b5-gx6v/profile_images/LARGE",
    "profileImageUrlMedium" : "/api/users/a4b5-gx6v/profile_images/THUMB",
    "profileImageUrlSmall" : "/api/users/a4b5-gx6v/profile_images/TINY",
    "screenName" : "Dades Obertes Catalunya",
    "type" : "interactive",
    "flags" : [ "acceptedEula" ]
  },
  "tags" : [ "alumnes", "promoció", "categoria", "policia local", "policia portuària", "memòria", "memòria interior", "mossos d'esquadra", "ods16_pau justícies i institucions sòlides", "ods4_educació de qualitat" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}