{
  "id" : "3jdt-62ht",
  "name" : "Enquesta de Seguretat Pública de Catalunya (Mòdul victimització)",
  "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" : 1715689798,
  "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 victimització (preguntes sobre victimització de la població, fets experimentats en els darrers dotze mesos), les dades sociodemogràfiques i pesos, des de 2003 fins a l’actualitat.  \n\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" : 600,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2910407,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1716303010,
  "publicationGroup" : 1948009,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1771498137,
  "rowsUpdatedBy" : "imph-7aws",
  "tableId" : 1948992,
  "totalTimesRated" : 0,
  "viewCount" : 2707,
  "viewLastModified" : 1771497703,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1716969193,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1438568,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1716969193,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1716969193,
      "failureCount" : 0,
      "startedAt" : 1716969193,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 25819031,
    "name" : "Any_edicio",
    "dataTypeName" : "text",
    "description" : "Any de l’edició de l’enquesta",
    "fieldName" : "any_edicio",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 15753658,
    "cachedContents" : {
      "non_null" : "10497097",
      "largest" : "2022",
      "null" : "0",
      "top" : [ {
        "item" : "2003",
        "count" : "1405758"
      }, {
        "item" : "2004",
        "count" : "1190406"
      }, {
        "item" : "2007",
        "count" : "876559"
      }, {
        "item" : "2006",
        "count" : "798125"
      }, {
        "item" : "2009",
        "count" : "743872"
      }, {
        "item" : "2008",
        "count" : "724089"
      }, {
        "item" : "2012",
        "count" : "721524"
      }, {
        "item" : "2011",
        "count" : "705712"
      }, {
        "item" : "2010",
        "count" : "694074"
      }, {
        "item" : "2005",
        "count" : "668483"
      }, {
        "item" : "2020",
        "count" : "526450"
      }, {
        "item" : "2022",
        "count" : "497511"
      }, {
        "item" : "2017",
        "count" : "411433"
      }, {
        "item" : "2015",
        "count" : "330125"
      }, {
        "item" : "2013",
        "count" : "202976"
      } ],
      "smallest" : "2003",
      "count" : "10497097",
      "cardinality" : "10497097"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819032,
    "name" : "Id_enquestat",
    "dataTypeName" : "text",
    "description" : "Identificador únic de la persona enquestada",
    "fieldName" : "id_enquestat",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 15753657,
    "cachedContents" : {
      "non_null" : "10497097",
      "largest" : "2022000019403",
      "null" : "0",
      "top" : [ {
        "item" : "2003007373935",
        "count" : "140"
      }, {
        "item" : "2003007494346",
        "count" : "140"
      }, {
        "item" : "2003007478679",
        "count" : "140"
      }, {
        "item" : "2003007574083",
        "count" : "139"
      }, {
        "item" : "2003007559926",
        "count" : "137"
      }, {
        "item" : "2003007579076",
        "count" : "136"
      }, {
        "item" : "2003007574665",
        "count" : "136"
      }, {
        "item" : "2003007491955",
        "count" : "134"
      }, {
        "item" : "2003007362547",
        "count" : "133"
      }, {
        "item" : "2003007360576",
        "count" : "133"
      }, {
        "item" : "2003007332789",
        "count" : "133"
      }, {
        "item" : "2003007356986",
        "count" : "132"
      }, {
        "item" : "2003007481124",
        "count" : "132"
      }, {
        "item" : "2003007530303",
        "count" : "132"
      }, {
        "item" : "2003007420550",
        "count" : "131"
      }, {
        "item" : "2003007587224",
        "count" : "131"
      }, {
        "item" : "2003007503406",
        "count" : "131"
      }, {
        "item" : "2003007525814",
        "count" : "131"
      }, {
        "item" : "2003007605678",
        "count" : "130"
      }, {
        "item" : "2003007621165",
        "count" : "130"
      } ],
      "smallest" : "2003007306957",
      "count" : "10497097",
      "cardinality" : "10497097"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819033,
    "name" : "Variable",
    "dataTypeName" : "text",
    "description" : "Nom de la variable",
    "fieldName" : "variable",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 15753656,
    "cachedContents" : {
      "non_null" : "10497097",
      "largest" : "zzv12",
      "null" : "0",
      "top" : [ {
        "item" : "sexe",
        "count" : "186509"
      }, {
        "item" : "pp31",
        "count" : "186509"
      }, {
        "item" : "record",
        "count" : "186509"
      }, {
        "item" : "pp32",
        "count" : "186509"
      }, {
        "item" : "pp22",
        "count" : "186509"
      }, {
        "item" : "pe41",
        "count" : "186509"
      }, {
        "item" : "pp12",
        "count" : "186509"
      }, {
        "item" : "pesAixecament",
        "count" : "186509"
      }, {
        "item" : "pp21",
        "count" : "186509"
      }, {
        "item" : "pp11",
        "count" : "186509"
      }, {
        "item" : "edatTrams",
        "count" : "186509"
      }, {
        "item" : "dyy",
        "count" : "186509"
      }, {
        "item" : "ideologia",
        "count" : "186509"
      }, {
        "item" : "comarca",
        "count" : "186509"
      }, {
        "item" : "llocNaixement",
        "count" : "186509"
      }, {
        "item" : "pe43",
        "count" : "186509"
      }, {
        "item" : "entrevista",
        "count" : "186509"
      }, {
        "item" : "pe42",
        "count" : "186509"
      }, {
        "item" : "pesMostral",
        "count" : "186509"
      }, {
        "item" : "situacioProfessional",
        "count" : "186509"
      } ],
      "smallest" : "acces2aRes1",
      "count" : "10497097",
      "cardinality" : "10497097"
    },
    "format" : { }
  }, {
    "id" : 25819038,
    "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" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 15761288,
    "cachedContents" : {
      "non_null" : "10497097",
      "largest" : "190",
      "null" : "0",
      "top" : [ {
        "item" : "5",
        "count" : "186509"
      }, {
        "item" : "9",
        "count" : "186509"
      }, {
        "item" : "3",
        "count" : "186509"
      }, {
        "item" : "8",
        "count" : "186509"
      }, {
        "item" : "4",
        "count" : "186509"
      }, {
        "item" : "2",
        "count" : "186509"
      }, {
        "item" : "7",
        "count" : "186507"
      }, {
        "item" : "6",
        "count" : "186507"
      }, {
        "item" : "64",
        "count" : "178884"
      }, {
        "item" : "29",
        "count" : "178614"
      }, {
        "item" : "25",
        "count" : "165893"
      }, {
        "item" : "62",
        "count" : "165368"
      }, {
        "item" : "63",
        "count" : "165368"
      }, {
        "item" : "27",
        "count" : "164749"
      }, {
        "item" : "79",
        "count" : "161479"
      }, {
        "item" : "81",
        "count" : "161040"
      }, {
        "item" : "28",
        "count" : "160752"
      }, {
        "item" : "78",
        "count" : "160709"
      }, {
        "item" : "82",
        "count" : "155655"
      }, {
        "item" : "23",
        "count" : "155579"
      } ],
      "smallest" : "2",
      "count" : "10497097",
      "cardinality" : "10497097"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819035,
    "name" : "Descripcio_variable",
    "dataTypeName" : "text",
    "description" : "Descripció de la variable | Pregunta corresponent del qüestionari",
    "fieldName" : "descripcio_variable",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 15753654,
    "cachedContents" : {
      "non_null" : "10497097",
      "largest" : "Zona desplegament dels Mossos d'Esquadra?",
      "null" : "0",
      "top" : [ {
        "item" : "Secció mostral: Trams d'edat",
        "count" : "186509"
      }, {
        "item" : "Modalitat de l'entrevista",
        "count" : "186509"
      }, {
        "item" : "Secció mostral: Regió policial",
        "count" : "186507"
      }, {
        "item" : "Pes poblacional - Tots els individus",
        "count" : "180295"
      }, {
        "item" : "Pes mostral - Tots els individus",
        "count" : "180295"
      }, {
        "item" : "Com és el seu domicili?",
        "count" : "151938"
      }, {
        "item" : "Domicili: Quin tipus d’accés hi ha?",
        "count" : "151938"
      }, {
        "item" : "Secció mostral: Sexe persona seleccionada",
        "count" : "142279"
      }, {
        "item" : "Aproximadament, quins són els ingressos familiars nets que entren cada mes a casa seva?",
        "count" : "137386"
      }, {
        "item" : "Quina és la seva situació professional?",
        "count" : "136269"
      }, {
        "item" : "Comarca",
        "count" : "123659"
      }, {
        "item" : "Si li demanem per la seva ideologia, on es situaria vostè en una escala de 0 (extrema esquerra) a 10 (extrema dreta)?",
        "count" : "113481"
      }, {
        "item" : "És vostè propietari d'una botiga?",
        "count" : "108989"
      }, {
        "item" : "És vostè propietari d’un taller o d’un altre negoci?",
        "count" : "108989"
      }, {
        "item" : "Grandària del municipi on viu",
        "count" : "106786"
      }, {
        "item" : "Llengua en la que s'ha realitzat l'entrevista",
        "count" : "104627"
      }, {
        "item" : "Nivell d'estudis assolit",
        "count" : "92658"
      }, {
        "item" : "Domicili: A quina part del municipi es troba?",
        "count" : "83559"
      }, {
        "item" : "Em pot dir si vostè va néixer...",
        "count" : "73028"
      }, {
        "item" : "Si li demanem per la seva ideologia política, on es situaria vostè en una escala de 0 (extrema esquerra) a 10 (extrema dreta)?",
        "count" : "73028"
      } ],
      "smallest" : "Algun frau, estafa o engany dels que ara ha esmentat guarda relació amb fets que ens ha detallat prèviament en aquesta enquesta?",
      "count" : "10497097",
      "cardinality" : "10497097"
    },
    "format" : { }
  }, {
    "id" : 25819036,
    "name" : "Codi_valor",
    "dataTypeName" : "text",
    "description" : "Valor codificat de la variable",
    "fieldName" : "codi_valor",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 15753653,
    "cachedContents" : {
      "non_null" : "10497097",
      "largest" : "nan",
      "null" : "0",
      "top" : [ {
        "item" : "0",
        "count" : "5900508"
      }, {
        "item" : "1",
        "count" : "1618155"
      }, {
        "item" : "2",
        "count" : "676531"
      }, {
        "item" : "3",
        "count" : "465625"
      }, {
        "item" : "4",
        "count" : "286091"
      }, {
        "item" : "5",
        "count" : "231114"
      }, {
        "item" : "7",
        "count" : "152292"
      }, {
        "item" : "6",
        "count" : "135331"
      }, {
        "item" : "50",
        "count" : "83163"
      }, {
        "item" : "13",
        "count" : "77826"
      }, {
        "item" : "8",
        "count" : "59687"
      }, {
        "item" : "99",
        "count" : "55705"
      }, {
        "item" : "9",
        "count" : "47350"
      }, {
        "item" : "10",
        "count" : "37713"
      }, {
        "item" : "41",
        "count" : "32504"
      }, {
        "item" : "11",
        "count" : "28299"
      }, {
        "item" : "31",
        "count" : "24279"
      }, {
        "item" : "80",
        "count" : "22343"
      }, {
        "item" : "40",
        "count" : "19270"
      }, {
        "item" : "52",
        "count" : "15096"
      } ],
      "smallest" : "0",
      "count" : "10497097",
      "cardinality" : "10497097"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25819037,
    "name" : "Descriptor_valor",
    "dataTypeName" : "text",
    "description" : "Descriptor del valor codificat de la variable ",
    "fieldName" : "descriptor_valor",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 15753652,
    "cachedContents" : {
      "non_null" : "10497097",
      "largest" : "Viu sol/a",
      "null" : "0",
      "top" : [ {
        "item" : "0",
        "count" : "4253695"
      }, {
        "item" : "No",
        "count" : "1517444"
      }, {
        "item" : "Sí",
        "count" : "424587"
      }, {
        "item" : "1",
        "count" : "201443"
      }, {
        "item" : "CATI",
        "count" : "184551"
      }, {
        "item" : "Un pis o apartament",
        "count" : "136606"
      }, {
        "item" : "A Catalunya",
        "count" : "131164"
      }, {
        "item" : "Porter automàtic o intèrfon",
        "count" : "119030"
      }, {
        "item" : "Català",
        "count" : "113253"
      }, {
        "item" : "Dona",
        "count" : "95982"
      }, {
        "item" : "Home",
        "count" : "90887"
      }, {
        "item" : "5",
        "count" : "83959"
      }, {
        "item" : "Actiu ocupat",
        "count" : "80299"
      }, {
        "item" : "Barcelonès",
        "count" : "73975"
      }, {
        "item" : "Tant català/ana com espanyol/a",
        "count" : "64923"
      }, {
        "item" : "41-64",
        "count" : "62189"
      }, {
        "item" : "Més de 250.000 habitants",
        "count" : "61182"
      }, {
        "item" : "2",
        "count" : "61082"
      }, {
        "item" : "Castellà",
        "count" : "58590"
      }, {
        "item" : "De 10.001 a 50.000 habitants",
        "count" : "58103"
      } ],
      "smallest" : "0",
      "count" : "10497097",
      "cardinality" : "10497097"
    },
    "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" : "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. (victimization)",
        "Nombre del conjunto de datos (ES)" : "Encuesta de seguridad pública de Cataluña. Años 2003 – actualidad. (Módulo victimizació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" : 25819031,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 25819032,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 25819038,
        "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" ]
}