{
  "id" : "3idm-msiy",
  "name" : "Expedients disciplinaris a agents dels Mossos d’Esquadra i de les policies locals",
  "assetType" : "dataset",
  "attribution" : "Direcció General de la Policia",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Seguretat",
  "createdAt" : 1721808654,
  "description" : "Expedients disciplinaris (ED) incoats pels Mossos d’Esquadra als seus agents i a agents de les policies locals, d’acord amb la Llei 10/1994, de la Policia de la Generalitat -- Mossos d’Esquadra (PG-ME).",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 530,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2934758,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1721810443,
  "publicationGroup" : 1963067,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1754474941,
  "rowsUpdatedBy" : "itig-nafy",
  "tableId" : 1963067,
  "totalTimesRated" : 0,
  "viewCount" : 762,
  "viewLastModified" : 1754474941,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1723025669,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1454850,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1723025669,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1723025669,
      "failureCount" : 0,
      "startedAt" : 1723025669,
      "status" : "success"
    },
    "submitter" : {
      "id" : "ae67-24a3",
      "displayName" : "SGOID"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 26139152,
    "name" : "Any",
    "dataTypeName" : "text",
    "description" : "Any en què es va obrir l’expedient disciplinari",
    "fieldName" : "any",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 15846605,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "2024",
      "null" : "0",
      "top" : [ {
        "item" : "2023",
        "count" : "120"
      }, {
        "item" : "2022",
        "count" : "113"
      }, {
        "item" : "2021",
        "count" : "95"
      }, {
        "item" : "2020",
        "count" : "80"
      }, {
        "item" : "2024",
        "count" : "77"
      }, {
        "item" : "2019",
        "count" : "64"
      } ],
      "smallest" : "2019",
      "count" : "549",
      "cardinality" : "6"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26139151,
    "name" : "Cos policial",
    "dataTypeName" : "text",
    "description" : "Cos policial al qual pertany la persona funcionària de l’expedient disciplinari incoat",
    "fieldName" : "cos_policial",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 15846604,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "Policia Local",
      "null" : "0",
      "top" : [ {
        "item" : "Mossos d'Esquadra",
        "count" : "525"
      }, {
        "item" : "Policia Local",
        "count" : "24"
      } ],
      "smallest" : "Mossos d'Esquadra",
      "count" : "549",
      "cardinality" : "2"
    },
    "format" : { }
  }, {
    "id" : 26139150,
    "name" : "Codi destinació",
    "dataTypeName" : "text",
    "description" : "Codi de la destinació (de la Regió Policial, si aplica)",
    "fieldName" : "codi_destinaci",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 15846603,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "Tarragona",
      "null" : "0",
      "top" : [ {
        "item" : "NA",
        "count" : "105"
      }, {
        "item" : "Metropolitana Nord",
        "count" : "104"
      }, {
        "item" : "Metro Barcelona",
        "count" : "103"
      }, {
        "item" : "Girona",
        "count" : "73"
      }, {
        "item" : "Metropolitana",
        "count" : "46"
      }, {
        "item" : "Tarragona",
        "count" : "33"
      }, {
        "item" : "No territorialitzat",
        "count" : "24"
      }, {
        "item" : "Central",
        "count" : "22"
      }, {
        "item" : "Ponent",
        "count" : "22"
      }, {
        "item" : "Ebre",
        "count" : "9"
      }, {
        "item" : "Pirineu",
        "count" : "8"
      } ],
      "smallest" : "Central",
      "count" : "549",
      "cardinality" : "11"
    },
    "format" : { }
  }, {
    "id" : 26139149,
    "name" : "Destinació",
    "dataTypeName" : "text",
    "description" : "Pel cas dels Mossos d’Esquadra, és la Regió policial de la Policia de la Generalitat – Mossos d’Esquadra. Pel cas de la policia local, no es disposa d’aquesta informació.",
    "fieldName" : "destinaci",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 15846602,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "Serveis Centrals",
      "null" : "0",
      "top" : [ {
        "item" : "Serveis Centrals",
        "count" : "105"
      }, {
        "item" : "RP Metropolitana Nord",
        "count" : "92"
      }, {
        "item" : "RP Metropolitana Barcelona",
        "count" : "86"
      }, {
        "item" : "RP Girona",
        "count" : "68"
      }, {
        "item" : "RP Metropolitana Sud",
        "count" : "40"
      }, {
        "item" : "RP Camp de Tarragona",
        "count" : "27"
      }, {
        "item" : "No territorialitzat",
        "count" : "24"
      }, {
        "item" : "RP Central",
        "count" : "20"
      }, {
        "item" : "Regió Policial Metropolitana Barcelona",
        "count" : "17"
      }, {
        "item" : "RP Ponent",
        "count" : "16"
      }, {
        "item" : "Regió Policial Metropolitana Nord",
        "count" : "12"
      }, {
        "item" : "RP Terres de l'Ebre",
        "count" : "7"
      }, {
        "item" : "Regió Policial Camp de Tarragona",
        "count" : "6"
      }, {
        "item" : "Regió Policial Metropolitana Sud",
        "count" : "6"
      }, {
        "item" : "Regió Policial Ponent",
        "count" : "6"
      }, {
        "item" : "RP Pirineu Occidental",
        "count" : "6"
      }, {
        "item" : "Regió Policial Girona",
        "count" : "5"
      }, {
        "item" : "Regió Policial Alt Pirineu i Aran",
        "count" : "2"
      }, {
        "item" : "Regió Policial Central",
        "count" : "2"
      }, {
        "item" : "Regió Policial Terres de l’Ebre",
        "count" : "2"
      } ],
      "smallest" : "No territorialitzat",
      "count" : "549",
      "cardinality" : "20"
    },
    "format" : { }
  }, {
    "id" : 26139148,
    "name" : "Nombre de persones funcionàries",
    "dataTypeName" : "number",
    "description" : "Nombre de persones funcionàries",
    "fieldName" : "nombre_de_persones_funcion",
    "position" : 5,
    "renderTypeName" : "number",
    "tableColumnId" : 15846601,
    "cachedContents" : {
      "non_null" : "548",
      "largest" : "2",
      "null" : "1",
      "top" : [ {
        "item" : "1",
        "count" : "546"
      }, {
        "item" : "2",
        "count" : "2"
      } ],
      "smallest" : "1",
      "count" : "549",
      "cardinality" : "2"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26139147,
    "name" : "Sexe",
    "dataTypeName" : "text",
    "description" : "Sexe de la persona funcionària (Home, Dona)",
    "fieldName" : "sexe",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 15846600,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "Home | Dona",
      "null" : "0",
      "top" : [ {
        "item" : "Home",
        "count" : "472"
      }, {
        "item" : "Dona",
        "count" : "74"
      }, {
        "item" : "Home | Dona",
        "count" : "1"
      }, {
        "item" : "Home | Desconegut",
        "count" : "1"
      }, {
        "item" : "Desconegut",
        "count" : "1"
      } ],
      "smallest" : "Desconegut",
      "count" : "549",
      "cardinality" : "5"
    },
    "format" : { }
  }, {
    "id" : 26139146,
    "name" : "Tipus de falta",
    "dataTypeName" : "text",
    "description" : "Tipificació de la falta (Lleu, Greu, Molt greu)",
    "fieldName" : "tipus_de_falta",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 15846599,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "NA",
      "null" : "0",
      "top" : [ {
        "item" : "Greu",
        "count" : "223"
      }, {
        "item" : "NA",
        "count" : "221"
      }, {
        "item" : "-",
        "count" : "60"
      }, {
        "item" : "Lleu",
        "count" : "21"
      }, {
        "item" : "Molt greu",
        "count" : "20"
      }, {
        "item" : "Molt greu | Greu",
        "count" : "3"
      }, {
        "item" : "Molt Greu",
        "count" : "1"
      } ],
      "smallest" : "-",
      "count" : "549",
      "cardinality" : "7"
    },
    "format" : { }
  }, {
    "id" : 26139145,
    "name" : "Infracció",
    "dataTypeName" : "text",
    "description" : "Són articles del Règim Disciplinari de la PG-ME.",
    "fieldName" : "infracci",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 15846598,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "NA",
      "null" : "0",
      "top" : [ {
        "item" : "NA",
        "count" : "221"
      }, {
        "item" : "-",
        "count" : "60"
      }, {
        "item" : "69.a",
        "count" : "54"
      }, {
        "item" : "69.p",
        "count" : "40"
      }, {
        "item" : "69.b",
        "count" : "23"
      }, {
        "item" : "69.c",
        "count" : "15"
      }, {
        "item" : "69.q",
        "count" : "14"
      }, {
        "item" : "70.b",
        "count" : "11"
      }, {
        "item" : "69.p | 69.a",
        "count" : "9"
      }, {
        "item" : "69.t",
        "count" : "9"
      }, {
        "item" : "68.1.e",
        "count" : "7"
      }, {
        "item" : "69.l",
        "count" : "6"
      }, {
        "item" : "70.d",
        "count" : "6"
      }, {
        "item" : "69.i",
        "count" : "5"
      }, {
        "item" : "69.o",
        "count" : "5"
      }, {
        "item" : "69.g",
        "count" : "5"
      }, {
        "item" : "70.a",
        "count" : "4"
      }, {
        "item" : "68.1.g",
        "count" : "3"
      }, {
        "item" : "68.1.o",
        "count" : "3"
      }, {
        "item" : "69.k",
        "count" : "3"
      } ],
      "smallest" : "-",
      "count" : "549",
      "cardinality" : "59"
    },
    "format" : { }
  }, {
    "id" : 26139144,
    "name" : "Sanció",
    "dataTypeName" : "text",
    "description" : "Mesura imposada pel Règim Disciplinari",
    "fieldName" : "sanci",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 15846597,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "Trasllat | 2 mesos",
      "null" : "0",
      "top" : [ {
        "item" : "NA",
        "count" : "221"
      }, {
        "item" : "-",
        "count" : "60"
      }, {
        "item" : "16 dies",
        "count" : "56"
      }, {
        "item" : "1 mes",
        "count" : "43"
      }, {
        "item" : "2 mesos",
        "count" : "38"
      }, {
        "item" : "4 mesos",
        "count" : "14"
      }, {
        "item" : "1 any i 1 dia",
        "count" : "14"
      }, {
        "item" : "Trasllat",
        "count" : "13"
      }, {
        "item" : "3 mesos",
        "count" : "10"
      }, {
        "item" : "1 mes | 16 dies",
        "count" : "9"
      }, {
        "item" : "Amonestació per escrit",
        "count" : "8"
      }, {
        "item" : "2 dies",
        "count" : "8"
      }, {
        "item" : "1 mes i Trasllat",
        "count" : "6"
      }, {
        "item" : "5 dies",
        "count" : "5"
      }, {
        "item" : "4 mesos i Trasllat",
        "count" : "3"
      }, {
        "item" : "Separació del servei",
        "count" : "3"
      }, {
        "item" : "2 mesos | 2 mesos",
        "count" : "2"
      }, {
        "item" : "16 dies | 2 mesos",
        "count" : "2"
      }, {
        "item" : "1 any i 1 dia | 1 mes",
        "count" : "2"
      }, {
        "item" : "1 any i 6 mesos",
        "count" : "2"
      } ],
      "smallest" : "-",
      "count" : "549",
      "cardinality" : "45"
    },
    "format" : { }
  }, {
    "id" : 26139143,
    "name" : "Estat",
    "dataTypeName" : "text",
    "description" : "Estat en què es troba l’expedient disciplinari (En tràmit, Finalitzat amb sanció, Sobreseïment i Arxiu)",
    "fieldName" : "estat",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 15846596,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "Sobreseïment i Arxiu",
      "null" : "0",
      "top" : [ {
        "item" : "Finalitzat amb sanció",
        "count" : "268"
      }, {
        "item" : "En tràmit",
        "count" : "239"
      }, {
        "item" : "Sobreseïment i Arxiu",
        "count" : "42"
      } ],
      "smallest" : "En tràmit",
      "count" : "549",
      "cardinality" : "3"
    },
    "format" : { }
  }, {
    "id" : 26139142,
    "name" : "Connotacions d'odi i discriminació",
    "dataTypeName" : "text",
    "description" : "El fet sancionat té connotacions d’odi i discriminació (Sí/No)",
    "fieldName" : "connotacions_d_odi_i",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 15846595,
    "cachedContents" : {
      "non_null" : "549",
      "largest" : "x",
      "null" : "0",
      "top" : [ {
        "item" : "No",
        "count" : "454"
      }, {
        "item" : "-",
        "count" : "76"
      }, {
        "item" : "Sí",
        "count" : "18"
      }, {
        "item" : "x",
        "count" : "1"
      } ],
      "smallest" : "-",
      "count" : "549",
      "cardinality" : "4"
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Anual"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Disciplinary files to PG-ME officers and local police officers",
        "Nombre del conjunto de datos (ES)" : "Expedientes disciplinarios a agentes de la PG-ME y de las policies locales"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "Sí"
      },
      "Actors" : {
        "Departament" : "Interior i Seguretat Pública",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Nom d'element",
        "À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" : [ "afers interns", "investigació interna", "afers disciplinaris", "expedients disciplinaris", "mossos d'esquadra", "policies locals", "ods5_igualtat de gènere", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}