{
  "id" : "saw4-mdg7",
  "name" : "Enquesta de Seguretat Pública de Catalunya (Mòdul multivictimització)",
  "assetType" : "dataset",
  "attribution" : "Gabinet de Seguretat i Polítiques Transversals",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Seguretat",
  "createdAt" : 1715683274,
  "description" : "L’Enquesta de seguretat pública de Catalunya (ESPC), adreçada a una mostra representativa de residents, recull les experiències de victimització de les persones entrevistades i les seves opinions en matèria de seguretat i policia.   \nS’estructura en tres mòduls: opinió, victimització i multivictimització. Aquest conjunt conté les dades del mòdul de multivictimització (detall dels fets experimentats per les persones entrevistades), des de 2003 fins a l’actualitat.  \nL’ESPC, que forma part del programa estadístic de la Generalitat de Catalunya, és biennal des de l'any 2013.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 424,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2910405,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1716301635,
  "publicationGroup" : 1948007,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1729062143,
  "rowsUpdatedBy" : "imph-7aws",
  "tableId" : 1948990,
  "totalTimesRated" : 0,
  "viewCount" : 1215,
  "viewLastModified" : 1758534833,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1716898474,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1438425,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1716898474,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1716898475,
      "failureCount" : 0,
      "startedAt" : 1716898474,
      "status" : "success"
    },
    "submitter" : {
      "id" : "dr9k-85xc",
      "displayName" : "Mònica Amorós"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 25819014,
    "name" : "Any_edicio",
    "dataTypeName" : "text",
    "description" : "Any de l’edició de l’enquesta",
    "fieldName" : "any_edicio",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 15753644,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "2022",
      "null" : "0",
      "top" : [ {
        "item" : "2004",
        "count" : "187777"
      }, {
        "item" : "2010",
        "count" : "176856"
      }, {
        "item" : "2022",
        "count" : "175814"
      }, {
        "item" : "2009",
        "count" : "157238"
      }, {
        "item" : "2011",
        "count" : "147782"
      }, {
        "item" : "2012",
        "count" : "147598"
      }, {
        "item" : "2006",
        "count" : "147439"
      }, {
        "item" : "2005",
        "count" : "127510"
      }, {
        "item" : "2007",
        "count" : "126954"
      }, {
        "item" : "2017",
        "count" : "124977"
      }, {
        "item" : "2008",
        "count" : "117499"
      }, {
        "item" : "2020",
        "count" : "111600"
      }, {
        "item" : "2003",
        "count" : "107560"
      }, {
        "item" : "2015",
        "count" : "72597"
      }, {
        "item" : "2013",
        "count" : "35160"
      } ],
      "smallest" : "2003",
      "count" : "1964361",
      "cardinality" : "15"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819015,
    "name" : "Id_enquestat",
    "dataTypeName" : "text",
    "description" : "Identificador únic de la persona enquestada",
    "fieldName" : "id_enquestat",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 15753643,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "2022000019403",
      "null" : "0",
      "top" : [ {
        "item" : "2022000008242",
        "count" : "493"
      }, {
        "item" : "2022000006026",
        "count" : "445"
      }, {
        "item" : "2022000016369",
        "count" : "419"
      }, {
        "item" : "2022000006665",
        "count" : "405"
      }, {
        "item" : "2020000000473",
        "count" : "396"
      }, {
        "item" : "2022000006976",
        "count" : "388"
      }, {
        "item" : "2022000013558",
        "count" : "383"
      }, {
        "item" : "2022000015291",
        "count" : "369"
      }, {
        "item" : "2022000011262",
        "count" : "364"
      }, {
        "item" : "2022000001685",
        "count" : "364"
      }, {
        "item" : "2022000004445",
        "count" : "363"
      }, {
        "item" : "2022000004524",
        "count" : "362"
      }, {
        "item" : "2022000011862",
        "count" : "359"
      }, {
        "item" : "2022000011463",
        "count" : "355"
      }, {
        "item" : "2004000033198",
        "count" : "354"
      }, {
        "item" : "2015011131509",
        "count" : "348"
      }, {
        "item" : "2022000009350",
        "count" : "338"
      }, {
        "item" : "2022000004167",
        "count" : "335"
      }, {
        "item" : "2022000011164",
        "count" : "329"
      }, {
        "item" : "2015011035903",
        "count" : "328"
      } ],
      "smallest" : "2003007307053",
      "count" : "1964361",
      "cardinality" : "50265"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819016,
    "name" : "Id_episodi",
    "dataTypeName" : "text",
    "description" : "Identificador de l’episodi del fet sobre el qual es pregunta ",
    "fieldName" : "id_episodi",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 15753642,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "20220000194030231",
      "null" : "0",
      "top" : [ {
        "item" : "20100001188770171",
        "count" : "75"
      }, {
        "item" : "20070900025360021",
        "count" : "50"
      }, {
        "item" : "20170000065090411",
        "count" : "49"
      }, {
        "item" : "20170000051180431",
        "count" : "49"
      }, {
        "item" : "20150110359030421",
        "count" : "46"
      }, {
        "item" : "20150110489350412",
        "count" : "45"
      }, {
        "item" : "20150110489350411",
        "count" : "45"
      }, {
        "item" : "20150108721650431",
        "count" : "45"
      }, {
        "item" : "20150111335980411",
        "count" : "45"
      }, {
        "item" : "20150111134560431",
        "count" : "45"
      }, {
        "item" : "20150110308550431",
        "count" : "45"
      }, {
        "item" : "20150108903620431",
        "count" : "45"
      }, {
        "item" : "20150108903620432",
        "count" : "45"
      }, {
        "item" : "20220000051950431",
        "count" : "45"
      }, {
        "item" : "20200000130580411",
        "count" : "45"
      }, {
        "item" : "20150110772240431",
        "count" : "45"
      }, {
        "item" : "20150110771090431",
        "count" : "45"
      }, {
        "item" : "20150110359030411",
        "count" : "45"
      }, {
        "item" : "20220000016030431",
        "count" : "44"
      }, {
        "item" : "20150109511280431",
        "count" : "44"
      } ],
      "smallest" : "20030073070530011",
      "count" : "1964361",
      "cardinality" : "80853"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819017,
    "name" : "Variable",
    "dataTypeName" : "text",
    "description" : "Nom de la variable",
    "fieldName" : "variable",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 15753641,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "violencia",
      "null" : "0",
      "top" : [ {
        "item" : "fet",
        "count" : "80856"
      }, {
        "item" : "contfet",
        "count" : "80856"
      }, {
        "item" : "afectacions",
        "count" : "80319"
      }, {
        "item" : "molesties",
        "count" : "80319"
      }, {
        "item" : "catalunya",
        "count" : "77733"
      }, {
        "item" : "midaMunicipiFet",
        "count" : "77044"
      }, {
        "item" : "regioPolicialFet",
        "count" : "77044"
      }, {
        "item" : "comarcaFet",
        "count" : "77044"
      }, {
        "item" : "delicte",
        "count" : "76283"
      }, {
        "item" : "denuncia",
        "count" : "72897"
      }, {
        "item" : "mesFet",
        "count" : "60962"
      }, {
        "item" : "noDenunciaImportancia",
        "count" : "51688"
      }, {
        "item" : "noDenunciaConfiaPolicia",
        "count" : "51688"
      }, {
        "item" : "noDenunciaLimitPolicia",
        "count" : "51687"
      }, {
        "item" : "noDenunciaPor",
        "count" : "51687"
      }, {
        "item" : "noDenunciaConfiaJusticia",
        "count" : "51687"
      }, {
        "item" : "noDenunciaMandra",
        "count" : "51687"
      }, {
        "item" : "estacioFet",
        "count" : "51603"
      }, {
        "item" : "costFetEleccioMoneda",
        "count" : "50865"
      }, {
        "item" : "momentDiaFet",
        "count" : "42495"
      } ],
      "smallest" : "afectacions",
      "count" : "1964361",
      "cardinality" : "116"
    },
    "format" : { }
  }, {
    "id" : 25819022,
    "name" : "Ordre_variable",
    "dataTypeName" : "number",
    "description" : "Ordinal que representa la seqüència lògica de les variables en el qüestionari ",
    "fieldName" : "ordre_variable",
    "position" : 5,
    "renderTypeName" : "number",
    "tableColumnId" : 15761272,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "86",
      "null" : "0",
      "top" : [ {
        "item" : "4",
        "count" : "80856"
      }, {
        "item" : "3",
        "count" : "80856"
      }, {
        "item" : "7",
        "count" : "73064"
      }, {
        "item" : "8",
        "count" : "72992"
      }, {
        "item" : "23",
        "count" : "72242"
      }, {
        "item" : "13",
        "count" : "63594"
      }, {
        "item" : "12",
        "count" : "62734"
      }, {
        "item" : "14",
        "count" : "62576"
      }, {
        "item" : "20",
        "count" : "52804"
      }, {
        "item" : "9",
        "count" : "52254"
      }, {
        "item" : "24",
        "count" : "51726"
      }, {
        "item" : "21",
        "count" : "51117"
      }, {
        "item" : "22",
        "count" : "50503"
      }, {
        "item" : "15",
        "count" : "49542"
      }, {
        "item" : "25",
        "count" : "48108"
      }, {
        "item" : "37",
        "count" : "45843"
      }, {
        "item" : "10",
        "count" : "45462"
      }, {
        "item" : "5",
        "count" : "45297"
      }, {
        "item" : "17",
        "count" : "42873"
      }, {
        "item" : "42",
        "count" : "39424"
      } ],
      "smallest" : "3",
      "count" : "1964361",
      "cardinality" : "84"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819019,
    "name" : "Descripcio_variable",
    "dataTypeName" : "text",
    "description" : "Descripció de la variable | Pregunta corresponent del qüestionari",
    "fieldName" : "descripcio_variable",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 15753639,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "Va veure qui ho va fer?",
      "null" : "0",
      "top" : [ {
        "item" : "Número d'episodi per tipus de fet en ordre d'importància",
        "count" : "80856"
      }, {
        "item" : "Va passar a Catalunya?",
        "count" : "77733"
      }, {
        "item" : "Grandària del municipi on va passar el fet",
        "count" : "72994"
      }, {
        "item" : "Comarca del municipi on va passar el fet",
        "count" : "72994"
      }, {
        "item" : "Regió policial del municipi on va passar el fet",
        "count" : "71340"
      }, {
        "item" : "Tipus de fet",
        "count" : "60988"
      }, {
        "item" : "Ho va denunciar firmant un document davant la policia o el jutjat?",
        "count" : "53740"
      }, {
        "item" : "Valori de 0 (gens) a 10 (moltíssim) com li va afectar psicològicament el fet.",
        "count" : "51443"
      }, {
        "item" : "Valori de 0 (gens) a 10 (moltíssim) les molèsties que li va ocasionar aquest fet.",
        "count" : "48550"
      }, {
        "item" : "Quin mes de l'any va passar?",
        "count" : "40348"
      }, {
        "item" : "Ho va considerar un fet delictiu?",
        "count" : "39971"
      }, {
        "item" : "A quina part del municipi va passar?",
        "count" : "33025"
      }, {
        "item" : "A quin vehicle es refereix aquest fet?",
        "count" : "32850"
      }, {
        "item" : "Podria especificar quina època de l'any era o alguna data assenyalada propera al moment en el que va passar el fet?",
        "count" : "30989"
      }, {
        "item" : "Motiu de no denúncia: Confia poc en la policia",
        "count" : "28967"
      }, {
        "item" : "Motiu de no denúncia: Per por, represàlies, empitjorar les coses",
        "count" : "28966"
      }, {
        "item" : "Motiu de no denúncia: Perquè li resultava molt complicat, per mandra, massa tràmits, massa temps...",
        "count" : "28966"
      }, {
        "item" : "Motiu de no denúncia: La policia pot fer poca cosa",
        "count" : "28966"
      }, {
        "item" : "Motiu de no denúncia: Confia poc en la justícia",
        "count" : "28966"
      }, {
        "item" : "Motiu de no denúncia: Perquè era poc important",
        "count" : "28966"
      } ],
      "smallest" : "2 o més fets: El/els va considerar delictius?",
      "count" : "1964361",
      "cardinality" : "205"
    },
    "format" : { }
  }, {
    "id" : 25819020,
    "name" : "Codi_valor",
    "dataTypeName" : "text",
    "description" : "Valor codificat de la variable",
    "fieldName" : "codi_valor",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 15753638,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "999999999",
      "null" : "0",
      "top" : [ {
        "item" : "1",
        "count" : "609101"
      }, {
        "item" : "0",
        "count" : "462686"
      }, {
        "item" : "2",
        "count" : "113455"
      }, {
        "item" : "7",
        "count" : "90347"
      }, {
        "item" : "10",
        "count" : "75571"
      }, {
        "item" : "4",
        "count" : "72947"
      }, {
        "item" : "5",
        "count" : "70706"
      }, {
        "item" : "3",
        "count" : "66672"
      }, {
        "item" : "99",
        "count" : "59447"
      }, {
        "item" : "8",
        "count" : "54313"
      }, {
        "item" : "6",
        "count" : "50287"
      }, {
        "item" : "13",
        "count" : "33707"
      }, {
        "item" : "9",
        "count" : "27521"
      }, {
        "item" : "11",
        "count" : "12398"
      }, {
        "item" : "12",
        "count" : "11089"
      }, {
        "item" : "40",
        "count" : "10617"
      }, {
        "item" : "25",
        "count" : "6169"
      }, {
        "item" : "43",
        "count" : "5801"
      }, {
        "item" : "999999999",
        "count" : "5336"
      }, {
        "item" : "21",
        "count" : "5204"
      } ],
      "smallest" : "0",
      "count" : "1964361",
      "cardinality" : "1010"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819021,
    "name" : "Descriptor_valor",
    "dataTypeName" : "text",
    "description" : "Descriptor del valor codificat de la variable",
    "fieldName" : "descriptor_valor",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 15753637,
    "cachedContents" : {
      "non_null" : "1964361",
      "largest" : "Violació o intent de violació",
      "null" : "0",
      "top" : [ {
        "item" : "No",
        "count" : "401591"
      }, {
        "item" : "Sí",
        "count" : "269937"
      }, {
        "item" : "A Catalunya",
        "count" : "76080"
      }, {
        "item" : "Primer episodi",
        "count" : "67104"
      }, {
        "item" : "NS/NC",
        "count" : "62840"
      }, {
        "item" : "No s'ha signat cap denúncia",
        "count" : "49001"
      }, {
        "item" : "10",
        "count" : "47619"
      }, {
        "item" : "Euro",
        "count" : "33671"
      }, {
        "item" : "Barcelonès",
        "count" : "32641"
      }, {
        "item" : "8",
        "count" : "30034"
      }, {
        "item" : "Més de 250.000 habitants",
        "count" : "28789"
      }, {
        "item" : "0",
        "count" : "28103"
      }, {
        "item" : "RP Metropolitana Barcelona",
        "count" : "26820"
      }, {
        "item" : "Cotxe",
        "count" : "25682"
      }, {
        "item" : "5",
        "count" : "23441"
      }, {
        "item" : "7",
        "count" : "21991"
      }, {
        "item" : "Sí, s'ha signat una denúncia a Catalunya, personalment",
        "count" : "21903"
      }, {
        "item" : "Al carrer",
        "count" : "21372"
      }, {
        "item" : "A la nit o matinada",
        "count" : "18205"
      }, {
        "item" : "De 10.001 a 50.000 habitants",
        "count" : "16480"
      } ],
      "smallest" : "0",
      "count" : "1964361",
      "cardinality" : "1349"
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "any_edicio",
        "ascending" : false
      }, {
        "columnFieldName" : "id_enquestat",
        "ascending" : true
      }, {
        "columnFieldName" : "id_episodi",
        "ascending" : true
      }, {
        "columnFieldName" : "ordre_variable",
        "ascending" : true
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Biennal"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Catalonia Public Safety Survey. Years 2003 – present. (multivictimization)",
        "Nombre del conjunto de datos (ES)" : "Encuesta de seguridad pública de Cataluña. Años 2003 – actualidad. (Módulo multivictimización)"
      },
      "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" : {
    "orderBys" : [ {
      "ascending" : false,
      "expression" : {
        "columnId" : 25819014,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 25819015,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 25819016,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 25819022,
        "type" : "column"
      }
    } ]
  },
  "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" : [ "seguretat pública", "victimització", "denúncia", "policia", "percepció de seguretat", "regió policial", "seguretat viària", "mossos d'esquadra", "policies locals", "ods5_igualtat de gènere", "ods11_ciutats i comunitats sostenibles", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}