{
  "id" : "nkkp-u92f",
  "name" : "Controls d’alcoholèmia i de substàncies estupefaents",
  "assetType" : "dataset",
  "attribution" : "Departament d'Interior",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Seguretat",
  "createdAt" : 1635939394,
  "description" : "Controls d'alcoholèmia i de substàncies estupefaents; resultats positius o negatius, ja sigui en controls preventius, en el lloc d’accident, quan s’ha produït una infraccions o requeriments de símptomes.\nLa Policia de la Generalitat - Mossos d'Esquadra té la competència del control i vigilància del trànsit a Catalunya. En aquells municipis en què hi ha Policia local, aquesta s'ocupa de l'ordenació del trànsit urbà.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1158,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2889326,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1709545803,
  "publicationGroup" : 1490094,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1777276064,
  "rowsUpdatedBy" : "7i4k-xfx8",
  "tableId" : 1934082,
  "totalTimesRated" : 0,
  "viewCount" : 2608,
  "viewLastModified" : 1777276063,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1635943809,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1426521,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1635943809,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1635943809,
      "failureCount" : 0,
      "startedAt" : 1635943809,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 25694427,
    "name" : "Mes",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "mes_",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 15672095,
    "cachedContents" : {
      "non_null" : "9879",
      "largest" : "9",
      "null" : "0",
      "top" : [ {
        "item" : "12",
        "count" : "942"
      }, {
        "item" : "4",
        "count" : "840"
      }, {
        "item" : "5",
        "count" : "840"
      }, {
        "item" : "6",
        "count" : "836"
      }, {
        "item" : "10",
        "count" : "836"
      }, {
        "item" : "11",
        "count" : "834"
      }, {
        "item" : "1",
        "count" : "792"
      }, {
        "item" : "3",
        "count" : "792"
      }, {
        "item" : "9",
        "count" : "792"
      }, {
        "item" : "2",
        "count" : "792"
      }, {
        "item" : "8",
        "count" : "792"
      }, {
        "item" : "7",
        "count" : "790"
      }, {
        "item" : "]",
        "count" : "1"
      } ],
      "smallest" : "]",
      "count" : "9879",
      "cardinality" : "9879"
    },
    "format" : { }
  }, {
    "id" : 25694421,
    "name" : "Nom mes",
    "dataTypeName" : "text",
    "description" : "Nom del mes de les dades",
    "fieldName" : "nom_mes",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 14558995,
    "cachedContents" : {
      "non_null" : "9878",
      "largest" : "Setembre",
      "null" : "1",
      "top" : [ {
        "item" : "Desembre",
        "count" : "942"
      }, {
        "item" : "Abril",
        "count" : "840"
      }, {
        "item" : "Maig",
        "count" : "840"
      }, {
        "item" : "Juny",
        "count" : "836"
      }, {
        "item" : "Octubre",
        "count" : "836"
      }, {
        "item" : "Novembre",
        "count" : "834"
      }, {
        "item" : "Gener",
        "count" : "792"
      }, {
        "item" : "Febrer",
        "count" : "792"
      }, {
        "item" : "Setembre",
        "count" : "792"
      }, {
        "item" : "Agost",
        "count" : "792"
      }, {
        "item" : "Març",
        "count" : "792"
      }, {
        "item" : "Juliol",
        "count" : "790"
      } ],
      "smallest" : "Abril",
      "count" : "9879",
      "cardinality" : "9879"
    },
    "format" : { }
  }, {
    "id" : 25694422,
    "name" : "Any",
    "dataTypeName" : "number",
    "description" : "Número de l’any de les dades",
    "fieldName" : "any",
    "position" : 3,
    "renderTypeName" : "number",
    "tableColumnId" : 13548940,
    "cachedContents" : {
      "non_null" : "9878",
      "largest" : "2026",
      "null" : "1",
      "top" : [ {
        "item" : "2022",
        "count" : "884"
      }, {
        "item" : "2021",
        "count" : "648"
      }, {
        "item" : "2014",
        "count" : "648"
      }, {
        "item" : "2013",
        "count" : "648"
      }, {
        "item" : "2017",
        "count" : "648"
      }, {
        "item" : "2020",
        "count" : "648"
      }, {
        "item" : "2018",
        "count" : "648"
      }, {
        "item" : "2012",
        "count" : "648"
      }, {
        "item" : "2011",
        "count" : "648"
      }, {
        "item" : "2016",
        "count" : "648"
      }, {
        "item" : "2015",
        "count" : "648"
      }, {
        "item" : "2019",
        "count" : "648"
      }, {
        "item" : "2024",
        "count" : "576"
      }, {
        "item" : "2025",
        "count" : "574"
      }, {
        "item" : "2023",
        "count" : "572"
      }, {
        "item" : "2026",
        "count" : "144"
      } ],
      "smallest" : "2011",
      "count" : "9879",
      "cardinality" : "9879"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 25694423,
    "name" : "Regió Policial (RP)",
    "dataTypeName" : "text",
    "description" : "Nom de la Regió policial on s’han produït els fets",
    "fieldName" : "regi_policial_rp",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 13548944,
    "cachedContents" : {
      "non_null" : "9878",
      "largest" : "RP Terres de l'Ebre",
      "null" : "1",
      "top" : [ {
        "item" : "RP Central",
        "count" : "1128"
      }, {
        "item" : "RP Metropolitana Sud",
        "count" : "1128"
      }, {
        "item" : "RP Ponent",
        "count" : "1128"
      }, {
        "item" : "RP Girona",
        "count" : "1128"
      }, {
        "item" : "RP Metropolitana Nord",
        "count" : "1128"
      }, {
        "item" : "RP Terres de l'Ebre",
        "count" : "1124"
      }, {
        "item" : "RP Camp de Tarragona",
        "count" : "1082"
      }, {
        "item" : "RP Pirineu Occidental",
        "count" : "1050"
      }, {
        "item" : "RP Metropolitana Barcelona",
        "count" : "862"
      }, {
        "item" : "RP Alt Pirineu i Aran",
        "count" : "48"
      }, {
        "item" : "RP Camp de Taragona",
        "count" : "30"
      }, {
        "item" : "RP Prineu Occidental",
        "count" : "30"
      }, {
        "item" : "PR Camp de Tarragona",
        "count" : "12"
      } ],
      "smallest" : "PR Camp de Tarragona",
      "count" : "9879",
      "cardinality" : "9879"
    },
    "format" : { }
  }, {
    "id" : 25694424,
    "name" : "Àrea Regional de Transport (ART)",
    "dataTypeName" : "text",
    "description" : "Nom de l'Àrea Bàsica Policial (ABP) o de l’Àrea Regional de Trànsit (ART)",
    "fieldName" : "rea_regional_de_transport",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 13548943,
    "cachedContents" : {
      "non_null" : "9878",
      "largest" : "ART Terres de l'Ebre",
      "null" : "1",
      "top" : [ {
        "item" : "ART Metropolitana Nord",
        "count" : "1990"
      }, {
        "item" : "ART Girona",
        "count" : "1128"
      }, {
        "item" : "ART Metropolitana Sud",
        "count" : "1128"
      }, {
        "item" : "ART Ponent",
        "count" : "1128"
      }, {
        "item" : "ART Central",
        "count" : "1128"
      }, {
        "item" : "ART Terres de l'Ebre",
        "count" : "1124"
      }, {
        "item" : "ART Camp de Tarragona",
        "count" : "1124"
      }, {
        "item" : "ART Pirineu Occidental",
        "count" : "1080"
      }, {
        "item" : "ART Alt Pirineu i Aran",
        "count" : "48"
      } ],
      "smallest" : "ART Alt Pirineu i Aran",
      "count" : "9879",
      "cardinality" : "9879"
    },
    "format" : { }
  }, {
    "id" : 25694425,
    "name" : "Tipus",
    "dataTypeName" : "text",
    "description" : "Tipus de control realitzat i resultat",
    "fieldName" : "tipus",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 13548942,
    "cachedContents" : {
      "non_null" : "9878",
      "largest" : "Positius en preventiu",
      "null" : "1",
      "top" : [ {
        "item" : "Positius alcohol en accident",
        "count" : "1305"
      }, {
        "item" : "Lectures alcohol en accident",
        "count" : "1305"
      }, {
        "item" : "Positius alcohol en preventiu",
        "count" : "1303"
      }, {
        "item" : "Lectures alcohol en preventiu",
        "count" : "1303"
      }, {
        "item" : "Positius alcohol en infracció/requeriment",
        "count" : "1301"
      }, {
        "item" : "Lectures alcohol en infracció/requeriment",
        "count" : "1301"
      }, {
        "item" : "Positius en preventiu",
        "count" : "160"
      }, {
        "item" : "Lectures en preventiu",
        "count" : "160"
      }, {
        "item" : "Lectures en accident",
        "count" : "160"
      }, {
        "item" : "Positius en accident",
        "count" : "160"
      }, {
        "item" : "Positius en infracció/requeriment",
        "count" : "158"
      }, {
        "item" : "Lectures en infracció/requeriment",
        "count" : "158"
      }, {
        "item" : "Núm. Positius Accident",
        "count" : "152"
      }, {
        "item" : "Núm. Lectures Accident",
        "count" : "152"
      }, {
        "item" : "Núm. Lectures en control preventiu",
        "count" : "152"
      }, {
        "item" : "Núm. Lectures Inf-Req.",
        "count" : "151"
      }, {
        "item" : "Núm. Positius Inf-Req.",
        "count" : "151"
      }, {
        "item" : "Núm. Positius totals control preventiu",
        "count" : "88"
      }, {
        "item" : "Núm. Positius Preventiu",
        "count" : "64"
      }, {
        "item" : "Lectures drogues en accident",
        "count" : "34"
      } ],
      "smallest" : "Lectures alcohol en accident",
      "count" : "9879",
      "cardinality" : "9879"
    },
    "format" : { }
  }, {
    "id" : 25694426,
    "name" : "Nombre",
    "dataTypeName" : "number",
    "description" : "Nombre de controls realitzats",
    "fieldName" : "nombre",
    "position" : 7,
    "renderTypeName" : "number",
    "tableColumnId" : 13548941,
    "cachedContents" : {
      "non_null" : "9874",
      "largest" : "8404",
      "null" : "5",
      "top" : [ {
        "item" : "2",
        "count" : "440"
      }, {
        "item" : "3",
        "count" : "425"
      }, {
        "item" : "1",
        "count" : "406"
      }, {
        "item" : "4",
        "count" : "385"
      }, {
        "item" : "5",
        "count" : "321"
      }, {
        "item" : "6",
        "count" : "293"
      }, {
        "item" : "7",
        "count" : "245"
      }, {
        "item" : "0",
        "count" : "225"
      }, {
        "item" : "9",
        "count" : "209"
      }, {
        "item" : "8",
        "count" : "192"
      }, {
        "item" : "10",
        "count" : "187"
      }, {
        "item" : "13",
        "count" : "156"
      }, {
        "item" : "11",
        "count" : "149"
      }, {
        "item" : "14",
        "count" : "147"
      }, {
        "item" : "12",
        "count" : "133"
      }, {
        "item" : "15",
        "count" : "131"
      }, {
        "item" : "16",
        "count" : "102"
      }, {
        "item" : "17",
        "count" : "96"
      }, {
        "item" : "19",
        "count" : "94"
      }, {
        "item" : "18",
        "count" : "90"
      } ],
      "smallest" : "0",
      "count" : "9879",
      "cardinality" : "9879"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "any",
        "ascending" : false
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Trimestral"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Alcohol and drug tests on roads",
        "Nombre del conjunto de datos (ES)" : "Controles de alcoholemia y de sustancias estupefacientes"
      },
      "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" : {
    "orderBys" : [ {
      "ascending" : false,
      "expression" : {
        "columnId" : 25694422,
        "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" : [ "policia", "mossos d'esquadra", "persones", "vehicle", "mobilitat", "trànsit", "accidents", "investigació", "intervenció", "serveis policials", "controls alcoholèmia", "controls de substàncies estupefaents", "ods3_salut i benestar" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}