{
  "id" : "ndxf-5hmc",
  "name" : "Artefactes explosius sense explotar (Unexploded ordnance, UXO)",
  "assetType" : "dataset",
  "attribution" : "Departament d'Interior",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Seguretat",
  "createdAt" : 1626254655,
  "description" : "Artefactes explosius sense explotar localitzats a Catalunya, el trasllat, custòdia i/o desactivació dels quals és responsabilitat de l’Àrea de Desactivació d’Artefactes Explosius TEDAX-NRBQ de la Policia de la Generalitat – Mossos d’Esquadra.\n\nLa munició de guerra sense explotar també coneguda com UXO (Unexploded Ordnance) és tot aquell explosiu que es va disparar, deixar caure, llençat o projectat, però que no ha explotat degut a un mal funcionament, al seu disseny o per qualsevol altre motiu.\nDurant la Guerra Civil Espanyola, Catalunya va patir bombardejos aeris i atacs amb artilleria molt durs. En el conflicte van intervenir diferents països que van aprofitar la Guerra Civil Espanyola com a camp de proves de noves armes que més endavant van utilitzar a la II Guerra Mundial.\n79 anys després de la Guerra Civil apareixen a Catalunya cada any una mitjana de 1.000 d'aquests artefactes que no han explotat. Es calcula que caldrien entre 20 i 25 anys més per netejar de tots els artefactes emprats a Catalunya.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 886,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2118638,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1626255157,
  "publicationGroup" : 1440155,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1776160501,
  "rowsUpdatedBy" : "7i4k-xfx8",
  "tableId" : 1440155,
  "totalTimesRated" : 0,
  "viewCount" : 1671,
  "viewLastModified" : 1776160501,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1635150034,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1016962,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1635150034,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1635150034,
      "failureCount" : 0,
      "startedAt" : 1635150034,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 19771468,
    "name" : "Dia",
    "dataTypeName" : "number",
    "description" : "Dia del mes",
    "fieldName" : "dia",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 13145569,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "31",
      "null" : "0",
      "top" : [ {
        "item" : "3",
        "count" : "140"
      }, {
        "item" : "4",
        "count" : "134"
      }, {
        "item" : "5",
        "count" : "132"
      }, {
        "item" : "8",
        "count" : "130"
      }, {
        "item" : "18",
        "count" : "128"
      }, {
        "item" : "16",
        "count" : "127"
      }, {
        "item" : "17",
        "count" : "122"
      }, {
        "item" : "12",
        "count" : "119"
      }, {
        "item" : "19",
        "count" : "117"
      }, {
        "item" : "13",
        "count" : "115"
      }, {
        "item" : "11",
        "count" : "114"
      }, {
        "item" : "22",
        "count" : "114"
      }, {
        "item" : "9",
        "count" : "113"
      }, {
        "item" : "7",
        "count" : "111"
      }, {
        "item" : "27",
        "count" : "111"
      }, {
        "item" : "14",
        "count" : "109"
      }, {
        "item" : "29",
        "count" : "106"
      }, {
        "item" : "10",
        "count" : "105"
      }, {
        "item" : "24",
        "count" : "103"
      }, {
        "item" : "20",
        "count" : "101"
      } ],
      "smallest" : "1",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771467,
    "name" : "Mes",
    "dataTypeName" : "number",
    "description" : "Número del mes",
    "fieldName" : "mes",
    "position" : 2,
    "renderTypeName" : "number",
    "tableColumnId" : 13145568,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "12",
      "null" : "0",
      "top" : [ {
        "item" : "10",
        "count" : "327"
      }, {
        "item" : "2",
        "count" : "322"
      }, {
        "item" : "3",
        "count" : "322"
      }, {
        "item" : "8",
        "count" : "313"
      }, {
        "item" : "5",
        "count" : "310"
      }, {
        "item" : "4",
        "count" : "300"
      }, {
        "item" : "7",
        "count" : "289"
      }, {
        "item" : "1",
        "count" : "255"
      }, {
        "item" : "9",
        "count" : "246"
      }, {
        "item" : "11",
        "count" : "243"
      }, {
        "item" : "6",
        "count" : "238"
      }, {
        "item" : "12",
        "count" : "189"
      } ],
      "smallest" : "1",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771466,
    "name" : "Nom mes",
    "dataTypeName" : "text",
    "description" : "Nom del mes",
    "fieldName" : "nom_mes",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 13145567,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "setembre",
      "null" : "0",
      "top" : [ {
        "item" : "octubre",
        "count" : "327"
      }, {
        "item" : "agost",
        "count" : "313"
      }, {
        "item" : "maig",
        "count" : "310"
      }, {
        "item" : "abril",
        "count" : "300"
      }, {
        "item" : "febrer",
        "count" : "298"
      }, {
        "item" : "març",
        "count" : "295"
      }, {
        "item" : "juliol",
        "count" : "289"
      }, {
        "item" : "setembre",
        "count" : "246"
      }, {
        "item" : "juny",
        "count" : "238"
      }, {
        "item" : "gener",
        "count" : "230"
      }, {
        "item" : "novembre",
        "count" : "228"
      }, {
        "item" : "desembre",
        "count" : "182"
      }, {
        "item" : "marzo",
        "count" : "27"
      }, {
        "item" : "enero",
        "count" : "25"
      }, {
        "item" : "febrero",
        "count" : "24"
      }, {
        "item" : "noviembre",
        "count" : "15"
      }, {
        "item" : "diciembre",
        "count" : "7"
      } ],
      "smallest" : "abril",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771458,
    "name" : "Any",
    "dataTypeName" : "number",
    "description" : "Any",
    "fieldName" : "any",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 13145559,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "2026",
      "null" : "0",
      "top" : [ {
        "item" : "2024",
        "count" : "289"
      }, {
        "item" : "2022",
        "count" : "269"
      }, {
        "item" : "2025",
        "count" : "264"
      }, {
        "item" : "2015",
        "count" : "259"
      }, {
        "item" : "2023",
        "count" : "249"
      }, {
        "item" : "2014",
        "count" : "245"
      }, {
        "item" : "2020",
        "count" : "232"
      }, {
        "item" : "2013",
        "count" : "231"
      }, {
        "item" : "2016",
        "count" : "226"
      }, {
        "item" : "2019",
        "count" : "210"
      }, {
        "item" : "2018",
        "count" : "210"
      }, {
        "item" : "2021",
        "count" : "208"
      }, {
        "item" : "2012",
        "count" : "205"
      }, {
        "item" : "2017",
        "count" : "205"
      }, {
        "item" : "2026",
        "count" : "52"
      } ],
      "smallest" : "2012",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 19771465,
    "name" : "Municipi",
    "dataTypeName" : "text",
    "description" : "Municipi on s’ha localitzat l’artefacte",
    "fieldName" : "municipi",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 13145566,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "Xerta",
      "null" : "0",
      "top" : [ {
        "item" : "Barcelona",
        "count" : "195"
      }, {
        "item" : "Lleida",
        "count" : "70"
      }, {
        "item" : "Corbera d'Ebre",
        "count" : "53"
      }, {
        "item" : "Seu d'Urgell, la",
        "count" : "53"
      }, {
        "item" : "Gandesa",
        "count" : "52"
      }, {
        "item" : "Vilalba dels Arcs",
        "count" : "44"
      }, {
        "item" : "Artesa de Segre",
        "count" : "43"
      }, {
        "item" : "Pinell de Brai, el",
        "count" : "39"
      }, {
        "item" : "Vilanova de Meià",
        "count" : "39"
      }, {
        "item" : "Camarasa",
        "count" : "36"
      }, {
        "item" : "Seròs",
        "count" : "36"
      }, {
        "item" : "Aitona",
        "count" : "35"
      }, {
        "item" : "Tarragona",
        "count" : "34"
      }, {
        "item" : "Tremp",
        "count" : "33"
      }, {
        "item" : "Castelldans",
        "count" : "32"
      }, {
        "item" : "Balaguer",
        "count" : "30"
      }, {
        "item" : "Montblanc",
        "count" : "28"
      }, {
        "item" : "Tortosa",
        "count" : "28"
      }, {
        "item" : "Girona",
        "count" : "27"
      }, {
        "item" : "Capmany",
        "count" : "27"
      } ],
      "smallest" : "Abella de la Conca",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771464,
    "name" : "Comarca",
    "dataTypeName" : "text",
    "description" : "Comarca on s’ha localitzat l’artefacte",
    "fieldName" : "comarca",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 13145565,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "Vallès Oriental",
      "null" : "0",
      "top" : [ {
        "item" : "Segrià",
        "count" : "330"
      }, {
        "item" : "Noguera",
        "count" : "302"
      }, {
        "item" : "Terra Alta",
        "count" : "232"
      }, {
        "item" : "Barcelonès",
        "count" : "230"
      }, {
        "item" : "Garrigues",
        "count" : "177"
      }, {
        "item" : "Alt Empordà",
        "count" : "162"
      }, {
        "item" : "Vallès Occidental",
        "count" : "135"
      }, {
        "item" : "Ribera d'Ebre",
        "count" : "124"
      }, {
        "item" : "Pallars Jussà",
        "count" : "98"
      }, {
        "item" : "Anoia",
        "count" : "95"
      }, {
        "item" : "Baix Ebre",
        "count" : "87"
      }, {
        "item" : "Conca de Barberà",
        "count" : "84"
      }, {
        "item" : "Alt Urgell",
        "count" : "80"
      }, {
        "item" : "Baix Llobregat",
        "count" : "77"
      }, {
        "item" : "Maresme",
        "count" : "75"
      }, {
        "item" : "Gironès",
        "count" : "70"
      }, {
        "item" : "Osona",
        "count" : "68"
      }, {
        "item" : "Urgell",
        "count" : "64"
      }, {
        "item" : "Baix Camp",
        "count" : "62"
      }, {
        "item" : "Tarragonès",
        "count" : "62"
      } ],
      "smallest" : "Alta Ribagorça",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771463,
    "name" : "ABP",
    "dataTypeName" : "text",
    "description" : "Àrea Bàsica Policial (ABP) on s’ha localitzat l’artefacte",
    "fieldName" : "abp",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 13145564,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "RPMB",
      "null" : "0",
      "top" : [ {
        "item" : "ABP Segrià-Garrigues-Pla d'Urgell",
        "count" : "530"
      }, {
        "item" : "ABP Terra Alta - Ribera d'Ebre",
        "count" : "356"
      }, {
        "item" : "ABP Noguera",
        "count" : "302"
      }, {
        "item" : "NA",
        "count" : "180"
      }, {
        "item" : "ABP Pallars Jussà-Pallars Sobirà",
        "count" : "157"
      }, {
        "item" : "ABP Alt Empordà - Figueres",
        "count" : "139"
      }, {
        "item" : "ABP Alt Camp - Conca de Barberà",
        "count" : "118"
      }, {
        "item" : "ABP Baix Camp - Priorat",
        "count" : "109"
      }, {
        "item" : "ABP Segarra-Urgell",
        "count" : "98"
      }, {
        "item" : "ABP Anoia",
        "count" : "95"
      }, {
        "item" : "ABP Baix Ebre",
        "count" : "87"
      }, {
        "item" : "ABP Gironès - Pla de l'Estany",
        "count" : "84"
      }, {
        "item" : "ABP Bages",
        "count" : "81"
      }, {
        "item" : "ABP Alt Urgell",
        "count" : "80"
      }, {
        "item" : "ABP Osona",
        "count" : "69"
      }, {
        "item" : "ABP Tarragonès",
        "count" : "62"
      }, {
        "item" : "ABP Berguedà",
        "count" : "61"
      }, {
        "item" : "ABP Alt Penedès",
        "count" : "55"
      }, {
        "item" : "ABP Granollers",
        "count" : "50"
      }, {
        "item" : "ABP Garrotxa",
        "count" : "49"
      } ],
      "smallest" : "ABP Alt Camp - Conca de Barberà",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771462,
    "name" : "Regió Policial (RP)",
    "dataTypeName" : "text",
    "description" : "Regió Policial (RP) on s’ha localitzat l’artefacte",
    "fieldName" : "regi_policial_rp",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 13145563,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "RP Terres de l'Ebre",
      "null" : "0",
      "top" : [ {
        "item" : "RP Ponent",
        "count" : "847"
      }, {
        "item" : "RP Terres de l'Ebre",
        "count" : "404"
      }, {
        "item" : "RP Girona",
        "count" : "370"
      }, {
        "item" : "RP Central",
        "count" : "290"
      }, {
        "item" : "RP Camp de Tarragona",
        "count" : "269"
      }, {
        "item" : "RP Metropolitana Nord",
        "count" : "260"
      }, {
        "item" : "RP Pirineu Occidental",
        "count" : "207"
      }, {
        "item" : "RP Metropolitana Barcelona",
        "count" : "180"
      }, {
        "item" : "RP Metropolitana Sud",
        "count" : "144"
      }, {
        "item" : "RPP",
        "count" : "83"
      }, {
        "item" : "RPTE",
        "count" : "63"
      }, {
        "item" : "RPCT",
        "count" : "50"
      }, {
        "item" : "RPC",
        "count" : "38"
      }, {
        "item" : "RPMN",
        "count" : "33"
      }, {
        "item" : "RPG",
        "count" : "33"
      }, {
        "item" : "RPPO",
        "count" : "27"
      }, {
        "item" : "RP Alt Pirineu i Aran",
        "count" : "25"
      }, {
        "item" : "RPMS",
        "count" : "16"
      }, {
        "item" : "RPMB",
        "count" : "15"
      } ],
      "smallest" : "RP Alt Pirineu i Aran",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771461,
    "name" : "Tipus artefacte",
    "dataTypeName" : "text",
    "description" : "Tipus d’artefacte localitzat",
    "fieldName" : "tipus_artefacte",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 13145562,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "Projectils artilleria",
      "null" : "0",
      "top" : [ {
        "item" : "Projectils artilleria",
        "count" : "1174"
      }, {
        "item" : "Granades de mà",
        "count" : "1034"
      }, {
        "item" : "Granades de morter",
        "count" : "836"
      }, {
        "item" : "Espoletes",
        "count" : "86"
      }, {
        "item" : "Projectils antiaeris",
        "count" : "64"
      }, {
        "item" : "Projectils anticarro",
        "count" : "48"
      }, {
        "item" : "Bombes aviació",
        "count" : "32"
      }, {
        "item" : "Granades de fusell",
        "count" : "32"
      }, {
        "item" : "Boles de Bombarda",
        "count" : "18"
      }, {
        "item" : "Coet",
        "count" : "17"
      }, {
        "item" : "Mina",
        "count" : "6"
      }, {
        "item" : "Morter Pirotècnic",
        "count" : "5"
      }, {
        "item" : "projectils artilleria",
        "count" : "1"
      }, {
        "item" : "Càrrega militar",
        "count" : "1"
      } ],
      "smallest" : "Boles de Bombarda",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771460,
    "name" : "Model o calibre",
    "dataTypeName" : "text",
    "description" : "Model o calibre de la munició, artefacte",
    "fieldName" : "model_o_calibre",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 13145561,
    "cachedContents" : {
      "non_null" : "3330",
      "largest" : "Zeitzünderhand granate",
      "null" : "24",
      "top" : [ {
        "item" : "NA",
        "count" : "506"
      }, {
        "item" : "75 mm",
        "count" : "351"
      }, {
        "item" : "105 mm",
        "count" : "320"
      }, {
        "item" : "Universal",
        "count" : "265"
      }, {
        "item" : "81 mm",
        "count" : "234"
      }, {
        "item" : "Pinya",
        "count" : "134"
      }, {
        "item" : "65 mm",
        "count" : "117"
      }, {
        "item" : "155 mm",
        "count" : "79"
      }, {
        "item" : "45 mm",
        "count" : "61"
      }, {
        "item" : "50 mm",
        "count" : "57"
      }, {
        "item" : "Valero 81 mm",
        "count" : "50"
      }, {
        "item" : "Tipus pinya",
        "count" : "47"
      }, {
        "item" : "Bola de cama",
        "count" : "46"
      }, {
        "item" : "Valero 50 mm",
        "count" : "45"
      }, {
        "item" : "Brixia",
        "count" : "44"
      }, {
        "item" : "Polaca",
        "count" : "42"
      }, {
        "item" : "40 mm",
        "count" : "30"
      }, {
        "item" : "Breda",
        "count" : "23"
      }, {
        "item" : "60 mm",
        "count" : "23"
      }, {
        "item" : "105mm",
        "count" : "23"
      } ],
      "smallest" : "100mm",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "format" : { }
  }, {
    "id" : 19771459,
    "name" : "Nombre",
    "dataTypeName" : "number",
    "description" : "Nombre d’artefactes localitzats",
    "fieldName" : "nombre",
    "position" : 11,
    "renderTypeName" : "number",
    "tableColumnId" : 13145560,
    "cachedContents" : {
      "non_null" : "3354",
      "largest" : "891",
      "null" : "0",
      "top" : [ {
        "item" : "1",
        "count" : "2875"
      }, {
        "item" : "2",
        "count" : "232"
      }, {
        "item" : "3",
        "count" : "74"
      }, {
        "item" : "4",
        "count" : "33"
      }, {
        "item" : "5",
        "count" : "29"
      }, {
        "item" : "6",
        "count" : "15"
      }, {
        "item" : "8",
        "count" : "9"
      }, {
        "item" : "7",
        "count" : "9"
      }, {
        "item" : "11",
        "count" : "6"
      }, {
        "item" : "10",
        "count" : "6"
      }, {
        "item" : "9",
        "count" : "6"
      }, {
        "item" : "15",
        "count" : "4"
      }, {
        "item" : "12",
        "count" : "4"
      }, {
        "item" : "17",
        "count" : "3"
      }, {
        "item" : "14",
        "count" : "2"
      }, {
        "item" : "35",
        "count" : "2"
      }, {
        "item" : "116",
        "count" : "2"
      }, {
        "item" : "13",
        "count" : "2"
      }, {
        "item" : "115",
        "count" : "2"
      }, {
        "item" : "66",
        "count" : "2"
      } ],
      "smallest" : "1",
      "count" : "3354",
      "cardinality" : "3354"
    },
    "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ó" : "Trimestral"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Unexploded ordnance, UXO",
        "Nombre del conjunto de datos (ES)" : "Artefactos explosivos sin explotar (Unexploded ordnance, UXO)"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "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 operativa policial", "artefactes explosius", "tedax-nrbq", "uxo", "policia", "mossos d'esquadra", "ods3_salut i benestar", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}