{
  "id" : "8d5a-6vsk",
  "name" : "Campanyes i promoció institucional de la Generalitat de Catalunya",
  "assetType" : "dataset",
  "attribution" : "Secretaria de Mitjans de Comunicació i Difusió",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Sector Públic",
  "createdAt" : 1691495073,
  "description" : "Llistat de les campanyes i accions de publicitat i de promoció institucional realitzades per la Generalitat de Catalunya.\nEs fa constar l'òrgan promotor, el cost de la campanya o l'acció, els mitjans de comunicació emprats, l'import destinat a cadascun i el període d'execució.\nLa informació relativa als mitjans de comunicació es desglossa per tipologia de mitjà i per identificació nominativa de l'empresa de comunicació o grup empresarial.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 721,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2975527,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1731918003,
  "publicationGroup" : 1838105,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1775027366,
  "rowsUpdatedBy" : "ae67-24a3",
  "tableId" : 1991209,
  "totalTimesRated" : 0,
  "viewCount" : 5341,
  "viewLastModified" : 1775027359,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1692178494,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1474248,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1692178494,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1692178494,
      "failureCount" : 0,
      "startedAt" : 1692178494,
      "status" : "success"
    },
    "submitter" : {
      "id" : "3c3u-s965",
      "displayName" : "SGOID"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 26520375,
    "name" : "Període d'execució",
    "dataTypeName" : "text",
    "description" : "Any de la campanya o acció publicitària",
    "fieldName" : "per_ode_d_execuci",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 16009774,
    "cachedContents" : {
      "non_null" : "53136",
      "largest" : "2024",
      "null" : "0",
      "top" : [ {
        "item" : "2024",
        "count" : "9764"
      }, {
        "item" : "2023",
        "count" : "9409"
      }, {
        "item" : "2022",
        "count" : "8082"
      }, {
        "item" : "2021",
        "count" : "7961"
      }, {
        "item" : "2020",
        "count" : "7421"
      }, {
        "item" : "2019",
        "count" : "2994"
      }, {
        "item" : "2017",
        "count" : "2174"
      }, {
        "item" : "2018",
        "count" : "1951"
      }, {
        "item" : "2015",
        "count" : "1761"
      }, {
        "item" : "2016",
        "count" : "1619"
      } ],
      "smallest" : "2015",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : {
      "decimalSeparator" : ",",
      "noCommas" : "true",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26520365,
    "name" : "Òrgan o unitat",
    "dataTypeName" : "text",
    "description" : "Òrgan o unitat promotora",
    "fieldName" : "rgan_o_unitat",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 15263847,
    "cachedContents" : {
      "non_null" : "53136",
      "largest" : "VICEPRESIDÈNCIA, POLÍTIQUES DIGITALS I TERR.",
      "null" : "0",
      "top" : [ {
        "item" : "Direcció General de Difusió",
        "count" : "15604"
      }, {
        "item" : "PRESIDÈNCIA - Direcció General de Difusió",
        "count" : "10247"
      }, {
        "item" : "Agència Catalana de Turisme",
        "count" : "1945"
      }, {
        "item" : "Agència de Residus de Catalunya (ARC)",
        "count" : "1920"
      }, {
        "item" : "Entitat Autònoma de Jocs i Apostes (EAJA)",
        "count" : "1825"
      }, {
        "item" : "Departament de la Presidència",
        "count" : "1473"
      }, {
        "item" : "Servei Català de Trànsit",
        "count" : "1216"
      }, {
        "item" : "CULTURA -  Departament",
        "count" : "889"
      }, {
        "item" : "ACCIÓ CLIMÀTICA, ALIMENTACIÓ I AGENDA RURAL -  Departament",
        "count" : "888"
      }, {
        "item" : "Servei Català de la Salut",
        "count" : "823"
      }, {
        "item" : "Ferrocarrils de la Generalitat de Catalunya (FGC)",
        "count" : "738"
      }, {
        "item" : "EMPRESA I TREBALL - Agència Catalana de Turisme",
        "count" : "680"
      }, {
        "item" : "Agència Catalana de Patrimoni Cultural",
        "count" : "678"
      }, {
        "item" : "Dept de Cult.",
        "count" : "626"
      }, {
        "item" : "ACCIÓ CLIMÀTICA, ALIMENTACIÓ I AGENDA RURAL - Agència Catalana de l'Aigua (ACA)",
        "count" : "594"
      }, {
        "item" : "Departament de Salut",
        "count" : "590"
      }, {
        "item" : "INTERIOR -  Departament",
        "count" : "576"
      }, {
        "item" : "Agència Catalana de l'Aigua (ACA)",
        "count" : "490"
      }, {
        "item" : "Consorci per la Normalització Lingüística",
        "count" : "478"
      }, {
        "item" : "Dept Agric., Ramad. Pesca i Alimentació",
        "count" : "464"
      } ],
      "smallest" : "ACCIÓ CLIMÀTICA, ALIMENTACIÓ I AGENDA RURAL - Agència Catalana de l'Aigua (ACA)",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : { }
  }, {
    "id" : 26520366,
    "name" : "Campanya \no Acció",
    "dataTypeName" : "text",
    "description" : "Nom de la campanya o acció publicitària",
    "fieldName" : "campanya_o_acci",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 15263848,
    "cachedContents" : {
      "non_null" : "53136",
      "largest" : "ZONA BAIXES EMISSIONS",
      "null" : "0",
      "top" : [ {
        "item" : "INCENDIS",
        "count" : "1472"
      }, {
        "item" : "RESIDUS",
        "count" : "839"
      }, {
        "item" : "anuncis de publicitat institucional i redaccionals informatius al mitjà imprès",
        "count" : "778"
      }, {
        "item" : "GROSSA CAP D'ANY",
        "count" : "669"
      }, {
        "item" : "FOMENT ÚS DEL CATALÀ",
        "count" : "625"
      }, {
        "item" : "RECOLLIDA SELECTIVA",
        "count" : "565"
      }, {
        "item" : "TURISME",
        "count" : "528"
      }, {
        "item" : "ESPAIS NATURALS",
        "count" : "503"
      }, {
        "item" : "ELECCIONS PARLAMENT",
        "count" : "481"
      }, {
        "item" : "CORONAVIRUS -  (diversos)",
        "count" : "414"
      }, {
        "item" : "GROSSA SANT JORDI",
        "count" : "398"
      }, {
        "item" : "PL-Cursos Català",
        "count" : "381"
      }, {
        "item" : "anuncis de diverses campanyes de publicitat institucional i de redaccionals informatius al mitjà imprès i al mitjà ràdio",
        "count" : "375"
      }, {
        "item" : "PREINSCRIPCIONS ESCOLARS",
        "count" : "370"
      }, {
        "item" : "25N VIOLÈNCIES MASCLISTES",
        "count" : "370"
      }, {
        "item" : "SEGURETAT LABORAL",
        "count" : "357"
      }, {
        "item" : "LOTERIA GROSSA",
        "count" : "354"
      }, {
        "item" : "IMPOST CO2",
        "count" : "343"
      }, {
        "item" : "REUTILITZA",
        "count" : "341"
      }, {
        "item" : "CERTIFICATS PROFESSIONALS",
        "count" : "300"
      } ],
      "smallest" : "012 Catalunya Exterior",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : { }
  }, {
    "id" : 26520367,
    "name" : "Tipus despesa",
    "dataTypeName" : "text",
    "description" : "Tipus de despesa de la campanya o acció publicitària: Mitjans de comunicació/creativitat",
    "fieldName" : "tipus_despesa",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 15263849,
    "cachedContents" : {
      "non_null" : "53136",
      "largest" : "Mitjans de comunicació",
      "null" : "0",
      "top" : [ {
        "item" : "Mitjans de comunicació",
        "count" : "52485"
      }, {
        "item" : "Creativitat",
        "count" : "651"
      } ],
      "smallest" : "Creativitat",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : { }
  }, {
    "id" : 26520368,
    "name" : "Adjudicatari",
    "dataTypeName" : "text",
    "description" : "Nom de l’empresa adjudicatària del contracte de la campanya o acció publicitària",
    "fieldName" : "adjudicatari",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 15263850,
    "cachedContents" : {
      "non_null" : "53136",
      "largest" : "Zeba Produccions SL",
      "null" : "0",
      "top" : [ {
        "item" : "CARAT",
        "count" : "22917"
      }, {
        "item" : "WAVEMAKER",
        "count" : "6607"
      }, {
        "item" : "HAVAS",
        "count" : "6295"
      }, {
        "item" : "NOTHINGAD",
        "count" : "5678"
      }, {
        "item" : "PROXIMIA",
        "count" : "2341"
      }, {
        "item" : "MEDIAPLANNING",
        "count" : "2043"
      }, {
        "item" : "NETTHINK",
        "count" : "1668"
      }, {
        "item" : "FOCUS",
        "count" : "1307"
      }, {
        "item" : "ITAN-GESMEDIA",
        "count" : "1073"
      }, {
        "item" : "ARENA",
        "count" : "743"
      }, {
        "item" : "REBOLD",
        "count" : "429"
      }, {
        "item" : "DIGITAL GROUP",
        "count" : "350"
      }, {
        "item" : "PROXIMIA HAVAS",
        "count" : "247"
      }, {
        "item" : "MEDIALOG",
        "count" : "193"
      }, {
        "item" : "Directa",
        "count" : "189"
      }, {
        "item" : "UTE KARDUMEN-NOTHINGAD",
        "count" : "165"
      }, {
        "item" : "UTE ITAN-GESMEDIA",
        "count" : "98"
      }, {
        "item" : "ADSMURAI",
        "count" : "23"
      }, {
        "item" : "PUBLICIS PERFORMICS",
        "count" : "17"
      }, {
        "item" : "Broadcaster Content Agency SL",
        "count" : "11"
      } ],
      "smallest" : "1TO1CLICO",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : { }
  }, {
    "id" : 26520369,
    "name" : "Tipus mitjà de comunicació",
    "dataTypeName" : "text",
    "description" : "Tipus del mitjà de comunicació",
    "fieldName" : "tipus_mitj_de_comunicaci",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 15263851,
    "cachedContents" : {
      "non_null" : "52485",
      "largest" : "TELEVISIÓ",
      "null" : "651",
      "top" : [ {
        "item" : "M.IMPRESOS",
        "count" : "21534"
      }, {
        "item" : "INTERNET",
        "count" : "20012"
      }, {
        "item" : "RÀDIO",
        "count" : "6384"
      }, {
        "item" : "TELEVISIÓ",
        "count" : "1695"
      }, {
        "item" : "PRODUCCIÓ",
        "count" : "979"
      }, {
        "item" : "EXTERIOR",
        "count" : "896"
      }, {
        "item" : "TECNOLOGIA ONLINE",
        "count" : "794"
      }, {
        "item" : "ALTRES",
        "count" : "191"
      } ],
      "smallest" : "ALTRES",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : { }
  }, {
    "id" : 26520370,
    "name" : "Suport",
    "dataTypeName" : "text",
    "description" : "Nom del mitjà de comunicació",
    "fieldName" : "nom_mitj_de_comunicaci",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 15263852,
    "cachedContents" : {
      "non_null" : "52485",
      "largest" : "ZOOPA PRODUCCIÓ",
      "null" : "651",
      "top" : [ {
        "item" : "ARA.",
        "count" : "747"
      }, {
        "item" : "PERIÓDICO, EL",
        "count" : "698"
      }, {
        "item" : "servidor INTERNET",
        "count" : "688"
      }, {
        "item" : "NACIODIGITAL.",
        "count" : "635"
      }, {
        "item" : "ELNACIONAL.",
        "count" : "608"
      }, {
        "item" : "VANGUARDIA, LA",
        "count" : "583"
      }, {
        "item" : "ELPERIODICO.+",
        "count" : "567"
      }, {
        "item" : "GODÓ Online",
        "count" : "550"
      }, {
        "item" : "FACEBOOK + INSTAGRAM",
        "count" : "547"
      }, {
        "item" : "RAC 1",
        "count" : "546"
      }, {
        "item" : "ARA",
        "count" : "500"
      }, {
        "item" : "ELPUNTAVUI.+",
        "count" : "474"
      }, {
        "item" : "CATALUNYA RÀDIO",
        "count" : "465"
      }, {
        "item" : "PUNT AVUI, EL",
        "count" : "444"
      }, {
        "item" : "PUBLICO.",
        "count" : "420"
      }, {
        "item" : "FLAIXBAC",
        "count" : "414"
      }, {
        "item" : "TWITTER",
        "count" : "407"
      }, {
        "item" : "FLAIX FM",
        "count" : "371"
      }, {
        "item" : "SER",
        "count" : "358"
      }, {
        "item" : "CADENA 40",
        "count" : "347"
      } ],
      "smallest" : "014 DS MEDIA",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : { }
  }, {
    "id" : 26520371,
    "name" : "Import Net",
    "dataTypeName" : "number",
    "description" : "Import net sense la comissió de l’agència i l’IVA del contracte de la campanya o acció publicitària",
    "fieldName" : "import_net",
    "position" : 8,
    "renderTypeName" : "number",
    "tableColumnId" : 15263856,
    "cachedContents" : {
      "non_null" : "53136",
      "largest" : "2544031.21",
      "null" : "0",
      "top" : [ {
        "item" : "1000",
        "count" : "453"
      }, {
        "item" : "2000",
        "count" : "408"
      }, {
        "item" : "3000",
        "count" : "335"
      }, {
        "item" : "1500",
        "count" : "296"
      }, {
        "item" : "725.47",
        "count" : "294"
      }, {
        "item" : "106.25",
        "count" : "277"
      }, {
        "item" : "1200",
        "count" : "252"
      }, {
        "item" : "4000",
        "count" : "252"
      }, {
        "item" : "600",
        "count" : "247"
      }, {
        "item" : "900",
        "count" : "242"
      }, {
        "item" : "500",
        "count" : "229"
      }, {
        "item" : "1800",
        "count" : "215"
      }, {
        "item" : "5000",
        "count" : "194"
      }, {
        "item" : "2500",
        "count" : "175"
      }, {
        "item" : "700",
        "count" : "159"
      }, {
        "item" : "800",
        "count" : "157"
      }, {
        "item" : "212.5",
        "count" : "155"
      }, {
        "item" : "765",
        "count" : "153"
      }, {
        "item" : "400",
        "count" : "147"
      }, {
        "item" : "300",
        "count" : "147"
      } ],
      "smallest" : "0.07",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : {
      "decimalSeparator" : ",",
      "precision" : "2",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26520372,
    "name" : "Comissió d'Agència",
    "dataTypeName" : "number",
    "description" : "Percentatge de la comissió de l’agència ",
    "fieldName" : "comissi_d_ag_ncia",
    "position" : 9,
    "renderTypeName" : "number",
    "tableColumnId" : 15858280,
    "cachedContents" : {
      "non_null" : "52485",
      "largest" : "0.017300",
      "null" : "651",
      "top" : [ {
        "item" : "0",
        "count" : "41010"
      }, {
        "item" : "0.002500",
        "count" : "5635"
      }, {
        "item" : "0.000100",
        "count" : "2703"
      }, {
        "item" : "0.000500",
        "count" : "1045"
      }, {
        "item" : "0.000300",
        "count" : "825"
      }, {
        "item" : "0.000200",
        "count" : "797"
      }, {
        "item" : "0.001500",
        "count" : "426"
      }, {
        "item" : "0.004900",
        "count" : "12"
      }, {
        "item" : "0.00413200",
        "count" : "12"
      }, {
        "item" : "0.017300",
        "count" : "8"
      }, {
        "item" : "0.004300",
        "count" : "6"
      }, {
        "item" : "0.001100",
        "count" : "4"
      }, {
        "item" : "0.009500",
        "count" : "1"
      }, {
        "item" : "0.003100",
        "count" : "1"
      } ],
      "smallest" : "0",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : {
      "precisionStyle" : "percentage",
      "percentScale" : "1",
      "decimalSeparator" : ",",
      "precision" : "2",
      "groupSeparator" : ".",
      "align" : "left"
    }
  }, {
    "id" : 26520373,
    "name" : "IVA",
    "dataTypeName" : "number",
    "description" : "Percentatge d’IVA",
    "fieldName" : "iva",
    "position" : 10,
    "renderTypeName" : "number",
    "tableColumnId" : 15263854,
    "cachedContents" : {
      "non_null" : "53136",
      "largest" : "0.21",
      "null" : "0",
      "top" : [ {
        "item" : "0.21",
        "count" : "53136"
      } ],
      "smallest" : "0.21",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : {
      "precisionStyle" : "percentage",
      "percentScale" : "1",
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26520374,
    "name" : "Informació complementària",
    "dataTypeName" : "text",
    "description" : "Informació complementària",
    "fieldName" : "informaci_complement_ria",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 15263855,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "Total facturat a data de 21/02/2024 \n8.887,45 €",
      "null" : "53125",
      "top" : [ {
        "item" : "import adjudicat",
        "count" : "7"
      }, {
        "item" : "Total facturat a data de 21/02/2024 \n8.887,45 €",
        "count" : "2"
      }, {
        "item" : "*L'expedient SA-2023-443 es va adjudicar a l'adjudicatari Wolf Advertising, S.L. per un import total de 203.643€ ( IVA inclòs) per fer 3 campanyes: Prevenció del suïcidi, Reconeixement del Sistema i Vacunació.  La creativitat de la campanya de Vacunació finalment no es va executar.",
        "count" : "1"
      }, {
        "item" : "Total facturat a data de 21/02/2024 \n7.795,27 €",
        "count" : "1"
      } ],
      "smallest" : "import adjudicat",
      "count" : "53136",
      "cardinality" : "53136"
    },
    "format" : { }
  }, {
    "id" : 26520376,
    "name" : "Enllaç pdf memoria",
    "dataTypeName" : "url",
    "description" : "Enllaça a la memòria on es descriu la Campanya o Acció. Només hi ha disponibles les memòries de l’any 2017 a 2023, ambdós inclosos.",
    "fieldName" : "enlla_pdf_memoria",
    "position" : 12,
    "renderTypeName" : "url",
    "tableColumnId" : 16009775,
    "format" : { },
    "subColumnTypes" : [ "url", "description" ]
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "per_ode_d_execuci",
        "ascending" : false
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Variable"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Campaigns and institutional promotion of the Generalitat de Catalunya",
        "Nombre del conjunto de datos (ES)" : "Campañas y promoción institucional de la Generalidad de Cataluña"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Actors" : {
        "Departament" : "Presidència",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Sense informació geogràfica",
        "À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" : 26520375,
        "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" : [ "publicitat institucional", "publicitat", "campanyes", "promoció", "govern", "mitjans de comunicació", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}