{
  "id" : "tuxj-za9s",
  "name" : "Denúncies per internet",
  "assetType" : "dataset",
  "attribution" : "Departament d'Interior",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Seguretat",
  "createdAt" : 1627465576,
  "description" : "Denúncies presentades per mitjà del web de Mossos. La persona que presenta la denúncia ha de signar una còpia de la denúncia en dependències policials perquè tingui eficàcia jurídica.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 7120,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2127973,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1627466186,
  "publicationGroup" : 1447026,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1778582008,
  "rowsUpdatedBy" : "7i4k-xfx8",
  "tableId" : 1447026,
  "totalTimesRated" : 0,
  "viewCount" : 3488,
  "viewLastModified" : 1778582008,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1635150314,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1016985,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1635150314,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1635150314,
      "failureCount" : 0,
      "startedAt" : 1635150314,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 19826426,
    "name" : "Mes",
    "dataTypeName" : "number",
    "description" : "Número del mes de les dades",
    "fieldName" : "mes",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 13187680,
    "cachedContents" : {
      "non_null" : "1735",
      "largest" : "12",
      "null" : "0",
      "top" : [ {
        "item" : "3",
        "count" : "163"
      }, {
        "item" : "1",
        "count" : "159"
      }, {
        "item" : "2",
        "count" : "156"
      }, {
        "item" : "4",
        "count" : "154"
      }, {
        "item" : "6",
        "count" : "147"
      }, {
        "item" : "5",
        "count" : "145"
      }, {
        "item" : "10",
        "count" : "138"
      }, {
        "item" : "9",
        "count" : "137"
      }, {
        "item" : "7",
        "count" : "135"
      }, {
        "item" : "8",
        "count" : "135"
      }, {
        "item" : "11",
        "count" : "134"
      }, {
        "item" : "12",
        "count" : "132"
      } ],
      "smallest" : "1",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "format" : { }
  }, {
    "id" : 19826425,
    "name" : "Nom mes",
    "dataTypeName" : "text",
    "description" : "Nom del mes de les dades",
    "fieldName" : "nom_mes",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 13187679,
    "cachedContents" : {
      "non_null" : "1735",
      "largest" : "setembre",
      "null" : "0",
      "top" : [ {
        "item" : "març",
        "count" : "163"
      }, {
        "item" : "gener",
        "count" : "159"
      }, {
        "item" : "febrer",
        "count" : "156"
      }, {
        "item" : "abril",
        "count" : "154"
      }, {
        "item" : "juny",
        "count" : "147"
      }, {
        "item" : "maig",
        "count" : "145"
      }, {
        "item" : "octubre",
        "count" : "138"
      }, {
        "item" : "setembre",
        "count" : "137"
      }, {
        "item" : "agost",
        "count" : "135"
      }, {
        "item" : "juliol",
        "count" : "135"
      }, {
        "item" : "novembre",
        "count" : "134"
      }, {
        "item" : "desembre",
        "count" : "132"
      } ],
      "smallest" : "abril",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "format" : { }
  }, {
    "id" : 19826419,
    "name" : "Any",
    "dataTypeName" : "number",
    "description" : "Número de l’any de les dades",
    "fieldName" : "any",
    "position" : 3,
    "renderTypeName" : "number",
    "tableColumnId" : 13187673,
    "cachedContents" : {
      "non_null" : "1735",
      "largest" : "2026",
      "null" : "0",
      "top" : [ {
        "item" : "2023",
        "count" : "178"
      }, {
        "item" : "2017",
        "count" : "119"
      }, {
        "item" : "2021",
        "count" : "118"
      }, {
        "item" : "2020",
        "count" : "115"
      }, {
        "item" : "2016",
        "count" : "112"
      }, {
        "item" : "2019",
        "count" : "111"
      }, {
        "item" : "2018",
        "count" : "110"
      }, {
        "item" : "2015",
        "count" : "110"
      }, {
        "item" : "2011",
        "count" : "109"
      }, {
        "item" : "2013",
        "count" : "109"
      }, {
        "item" : "2014",
        "count" : "109"
      }, {
        "item" : "2012",
        "count" : "107"
      }, {
        "item" : "2022",
        "count" : "103"
      }, {
        "item" : "2024",
        "count" : "98"
      }, {
        "item" : "2025",
        "count" : "96"
      }, {
        "item" : "2026",
        "count" : "31"
      } ],
      "smallest" : "2011",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 19826424,
    "name" : "Motiu de la denúncia",
    "dataTypeName" : "text",
    "description" : "Fet motiu de la denúncia",
    "fieldName" : "motiu_de_la_den_ncia",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 13187678,
    "cachedContents" : {
      "non_null" : "1735",
      "largest" : "Sense especificar",
      "null" : "0",
      "top" : [ {
        "item" : "Furt",
        "count" : "193"
      }, {
        "item" : "Danys",
        "count" : "193"
      }, {
        "item" : "Robatori i furt d'ús de vehicle sense intimidació",
        "count" : "193"
      }, {
        "item" : "Robatori amb força interior vehicle",
        "count" : "193"
      }, {
        "item" : "Sense especificar",
        "count" : "126"
      }, {
        "item" : "Falta de furt",
        "count" : "121"
      }, {
        "item" : "Pèrdues i diversos",
        "count" : "119"
      }, {
        "item" : "Robatori amb violència i/o intimidació",
        "count" : "118"
      }, {
        "item" : "Falta de danys",
        "count" : "115"
      }, {
        "item" : "Pèrdua d'objectes",
        "count" : "81"
      }, {
        "item" : "Robatori amb força",
        "count" : "81"
      }, {
        "item" : "Danys (lleu)",
        "count" : "71"
      }, {
        "item" : "Furt (lleu)",
        "count" : "71"
      }, {
        "item" : "Furt interior vehicle",
        "count" : "60"
      } ],
      "smallest" : "Danys",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "format" : { }
  }, {
    "id" : 19826423,
    "name" : "Àmbit territorial",
    "dataTypeName" : "text",
    "description" : "Àmbit territorial on han tingut lloc els fets",
    "fieldName" : "mbit_territorial",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 13187677,
    "cachedContents" : {
      "non_null" : "1735",
      "largest" : "Catalunya",
      "null" : "0",
      "top" : [ {
        "item" : "Catalunya",
        "count" : "1735"
      } ],
      "smallest" : "Catalunya",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "format" : { }
  }, {
    "id" : 19826422,
    "name" : "No ratificades",
    "dataTypeName" : "number",
    "description" : "Nombre de denúncies que no han estat signades posteriorment en dependència policial (La persona que presenta la denúncia ha de signar una còpia de la denúncia en dependències policials perquè tingui eficàcia jurídica, en un màxim de 72h)",
    "fieldName" : "no_ratificades",
    "position" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 13187676,
    "cachedContents" : {
      "non_null" : "1186",
      "largest" : "846",
      "null" : "549",
      "top" : [ {
        "item" : "21",
        "count" : "21"
      }, {
        "item" : "19",
        "count" : "20"
      }, {
        "item" : "13",
        "count" : "19"
      }, {
        "item" : "16",
        "count" : "19"
      }, {
        "item" : "1",
        "count" : "19"
      }, {
        "item" : "18",
        "count" : "19"
      }, {
        "item" : "35",
        "count" : "18"
      }, {
        "item" : "17",
        "count" : "18"
      }, {
        "item" : "29",
        "count" : "16"
      }, {
        "item" : "37",
        "count" : "15"
      }, {
        "item" : "15",
        "count" : "14"
      }, {
        "item" : "14",
        "count" : "14"
      }, {
        "item" : "23",
        "count" : "14"
      }, {
        "item" : "34",
        "count" : "14"
      }, {
        "item" : "30",
        "count" : "14"
      }, {
        "item" : "25",
        "count" : "13"
      }, {
        "item" : "33",
        "count" : "13"
      }, {
        "item" : "20",
        "count" : "12"
      }, {
        "item" : "22",
        "count" : "11"
      }, {
        "item" : "31",
        "count" : "11"
      } ],
      "smallest" : "1",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "format" : { }
  }, {
    "id" : 19826421,
    "name" : "Ratificades",
    "dataTypeName" : "number",
    "description" : "Nombre de denúncies signades posteriorment en dependència policial (La persona que presenta la denúncia ha de signar una còpia de la denúncia en dependències policials perquè tingui eficàcia jurídica, en un màxim de 72h)",
    "fieldName" : "ratificades",
    "position" : 7,
    "renderTypeName" : "number",
    "tableColumnId" : 13187675,
    "cachedContents" : {
      "non_null" : "1713",
      "largest" : "151",
      "null" : "22",
      "top" : [ {
        "item" : "1",
        "count" : "112"
      }, {
        "item" : "4",
        "count" : "105"
      }, {
        "item" : "2",
        "count" : "103"
      }, {
        "item" : "3",
        "count" : "92"
      }, {
        "item" : "5",
        "count" : "86"
      }, {
        "item" : "6",
        "count" : "74"
      }, {
        "item" : "7",
        "count" : "65"
      }, {
        "item" : "10",
        "count" : "53"
      }, {
        "item" : "9",
        "count" : "49"
      }, {
        "item" : "11",
        "count" : "48"
      }, {
        "item" : "8",
        "count" : "47"
      }, {
        "item" : "13",
        "count" : "47"
      }, {
        "item" : "16",
        "count" : "46"
      }, {
        "item" : "12",
        "count" : "42"
      }, {
        "item" : "14",
        "count" : "34"
      }, {
        "item" : "15",
        "count" : "28"
      }, {
        "item" : "20",
        "count" : "26"
      }, {
        "item" : "24",
        "count" : "24"
      }, {
        "item" : "25",
        "count" : "24"
      }, {
        "item" : "31",
        "count" : "24"
      } ],
      "smallest" : "1",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "format" : { }
  }, {
    "id" : 19826420,
    "name" : "Total",
    "dataTypeName" : "number",
    "description" : "Nombre de denúncies realitzades",
    "fieldName" : "total",
    "position" : 8,
    "renderTypeName" : "number",
    "tableColumnId" : 13187674,
    "cachedContents" : {
      "non_null" : "1735",
      "largest" : "962",
      "null" : "0",
      "top" : [ {
        "item" : "1",
        "count" : "85"
      }, {
        "item" : "2",
        "count" : "66"
      }, {
        "item" : "4",
        "count" : "55"
      }, {
        "item" : "3",
        "count" : "52"
      }, {
        "item" : "5",
        "count" : "33"
      }, {
        "item" : "7",
        "count" : "32"
      }, {
        "item" : "22",
        "count" : "27"
      }, {
        "item" : "6",
        "count" : "26"
      }, {
        "item" : "26",
        "count" : "25"
      }, {
        "item" : "13",
        "count" : "24"
      }, {
        "item" : "8",
        "count" : "24"
      }, {
        "item" : "25",
        "count" : "24"
      }, {
        "item" : "12",
        "count" : "22"
      }, {
        "item" : "21",
        "count" : "22"
      }, {
        "item" : "15",
        "count" : "21"
      }, {
        "item" : "20",
        "count" : "21"
      }, {
        "item" : "24",
        "count" : "20"
      }, {
        "item" : "23",
        "count" : "20"
      }, {
        "item" : "16",
        "count" : "20"
      }, {
        "item" : "29",
        "count" : "19"
      } ],
      "smallest" : "1",
      "count" : "1735",
      "cardinality" : "1735"
    },
    "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)" : "Internet crime reports (Autonomous Police - Mossos d'Esquadra)",
        "Nombre del conjunto de datos (ES)" : "Denuncias por internet (Policia de la Generalitat de Catalunya - Mossos d'Esquadra)"
      },
      "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" : "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" : [ "activitat delinqüencial", "denúncia", "denúncies", "policia", "mossos d'esquadra", "incidents", "ods16_pau justícies i institucions sòlides", "ods11_ciutats i comunitats sostenibles" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}