{
  "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" : "La llista de les campanyes i accions de publicitat i promoció institucional de la Generalitat de Catalunya inclou informació sobre l’òrgan promotor, el cost de cada campanya o acció, els mitjans de comunicació emprats, la inversió destinada a cadascun d’ells i el període d’execució.\n\nLes dades dels mitjans de comunicació s’ofereixen desglossades per tipologia de mitjà i per empresa o grup empresarial de comunicació.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 931,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 3151746,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1784877449,
  "publicationGroup" : 1838105,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1785323983,
  "rowsUpdatedBy" : "a3rg-xd5j",
  "tableId" : 2126269,
  "totalTimesRated" : 0,
  "viewCount" : 7146,
  "viewLastModified" : 1786957199,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1692178494,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1568984,
    "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" : 27420505,
    "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" : "83960",
      "largest" : "2025",
      "null" : "0",
      "top" : [ {
        "item" : "2025",
        "count" : "30824"
      }, {
        "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" : "83960",
      "cardinality" : "83960"
    },
    "format" : {
      "decimalSeparator" : ",",
      "noCommas" : "true",
      "groupSeparator" : "."
    }
  }, {
    "id" : 27420506,
    "name" : "Òrgan o unitat",
    "dataTypeName" : "text",
    "description" : "Òrgan o unitat promotora",
    "fieldName" : "rgan_o_unitat",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 15263847,
    "cachedContents" : {
      "non_null" : "83960",
      "largest" : "VICEPRESIDÈNCIA, POLÍTIQUES DIGITALS I TERR.",
      "null" : "0",
      "top" : [ {
        "item" : "PRESIDÈNCIA - Direcció General de Difusió",
        "count" : "26740"
      }, {
        "item" : "Direcció General de Difusió",
        "count" : "15604"
      }, {
        "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" : "TERRITORI - Ferrocarrils de la Generalitat de Catalunya (FGC)",
        "count" : "1566"
      }, {
        "item" : "INTERIOR - Servei Català de Trànsit",
        "count" : "1534"
      }, {
        "item" : "INTERIOR - Departament",
        "count" : "1527"
      }, {
        "item" : "Departament de la Presidència",
        "count" : "1473"
      }, {
        "item" : "EMPRESA I TREBALL - Agència Catalana de Turisme (ACT)",
        "count" : "1294"
      }, {
        "item" : "Servei Català de Trànsit",
        "count" : "1216"
      }, {
        "item" : "TERRITORI - Agència de Residus de Catalunya (ARC)",
        "count" : "1175"
      }, {
        "item" : "TERRITORI - Departament",
        "count" : "932"
      }, {
        "item" : "CULTURA -  Departament",
        "count" : "889"
      }, {
        "item" : "ACCIÓ CLIMÀTICA, ALIMENTACIÓ I AGENDA RURAL -  Departament",
        "count" : "888"
      }, {
        "item" : "EMPRESA I TREBALL - Departament",
        "count" : "884"
      }, {
        "item" : "ECONOMIA I HISENDA - Loteries de Catalunya, SAU",
        "count" : "878"
      }, {
        "item" : "PRESIDÈNCIA - Agència de Ciberseguretat de Catalunya",
        "count" : "826"
      }, {
        "item" : "Servei Català de la Salut",
        "count" : "823"
      }, {
        "item" : "Ferrocarrils de la Generalitat de Catalunya (FGC)",
        "count" : "738"
      } ],
      "smallest" : "ACCIÓ CLIMÀTICA, ALIMENTACIÓ I AGENDA RURAL - Agència Catalana de l'Aigua (ACA)",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : { }
  }, {
    "id" : 27420507,
    "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" : "83960",
      "largest" : "ZONA BAIXES EMISSIONS",
      "null" : "0",
      "top" : [ {
        "item" : "INCENDIS",
        "count" : "3130"
      }, {
        "item" : "CALOR ESTIU",
        "count" : "1634"
      }, {
        "item" : "GOVERN DE TOTHOM 2aF",
        "count" : "1506"
      }, {
        "item" : "ESPAIS NATURALS",
        "count" : "1451"
      }, {
        "item" : "FGC TURISME",
        "count" : "1423"
      }, {
        "item" : "RECOLLIDA SELECTIVA",
        "count" : "1248"
      }, {
        "item" : "CONVOCATÒRIA MOSSOS",
        "count" : "1054"
      }, {
        "item" : "RENDA",
        "count" : "913"
      }, {
        "item" : "Ciberseguretat",
        "count" : "907"
      }, {
        "item" : "TUR-TURISME DE CATALUNYA",
        "count" : "903"
      }, {
        "item" : "RESIDUS",
        "count" : "839"
      }, {
        "item" : "28J",
        "count" : "804"
      }, {
        "item" : "HABITATGE",
        "count" : "795"
      }, {
        "item" : "SANT JORDI",
        "count" : "794"
      }, {
        "item" : "anuncis de publicitat institucional i redaccionals informatius al mitjà imprès",
        "count" : "778"
      }, {
        "item" : "LIDERATGE ECONÒMIC",
        "count" : "758"
      }, {
        "item" : "VACUNACIÓ",
        "count" : "736"
      }, {
        "item" : "GROSSA SANT JORDI",
        "count" : "720"
      }, {
        "item" : "CULT-TNC",
        "count" : "677"
      }, {
        "item" : "GROSSA CAP D'ANY",
        "count" : "669"
      } ],
      "smallest" : "012 Catalunya Exterior",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : { }
  }, {
    "id" : 27420508,
    "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" : "83960",
      "largest" : "Mitjans de comunicació",
      "null" : "0",
      "top" : [ {
        "item" : "Mitjans de comunicació",
        "count" : "83129"
      }, {
        "item" : "Creativitat",
        "count" : "831"
      } ],
      "smallest" : "Creativitat",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : { }
  }, {
    "id" : 27420509,
    "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" : "83960",
      "largest" : "Zeba Produccions SL",
      "null" : "0",
      "top" : [ {
        "item" : "CARAT",
        "count" : "44183"
      }, {
        "item" : "HAVAS",
        "count" : "11066"
      }, {
        "item" : "WAVEMAKER",
        "count" : "10130"
      }, {
        "item" : "NOTHINGAD",
        "count" : "5867"
      }, {
        "item" : "PROXIMIA",
        "count" : "2341"
      }, {
        "item" : "MEDIAPLANNING",
        "count" : "2043"
      }, {
        "item" : "NETTHINK",
        "count" : "1668"
      }, {
        "item" : "ITAN-GESMEDIA",
        "count" : "1339"
      }, {
        "item" : "FOCUS",
        "count" : "1307"
      }, {
        "item" : "REBOLD",
        "count" : "913"
      }, {
        "item" : "ARENA",
        "count" : "743"
      }, {
        "item" : "DIGITAL GROUP",
        "count" : "350"
      }, {
        "item" : "PROXIMIA HAVAS",
        "count" : "247"
      }, {
        "item" : "MEDIALOG",
        "count" : "203"
      }, {
        "item" : "Directa",
        "count" : "189"
      }, {
        "item" : "UTE KARDUMEN-NOTHINGAD",
        "count" : "165"
      }, {
        "item" : "UTE ITAN-GESMEDIA",
        "count" : "98"
      }, {
        "item" : "PUBLICIS PERFORMICS",
        "count" : "95"
      }, {
        "item" : "directe",
        "count" : "56"
      }, {
        "item" : "ADSMURAI",
        "count" : "23"
      } ],
      "smallest" : "10 finalistes del concurs (2.541€ per persona)",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : { }
  }, {
    "id" : 27420510,
    "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" : "83129",
      "largest" : "TV CONNECTADA",
      "null" : "831",
      "top" : [ {
        "item" : "INTERNET",
        "count" : "28897"
      }, {
        "item" : "M.IMPRESOS",
        "count" : "28453"
      }, {
        "item" : "RÀDIO",
        "count" : "18374"
      }, {
        "item" : "TELEVISIÓ",
        "count" : "2556"
      }, {
        "item" : "PRODUCCIÓ",
        "count" : "1402"
      }, {
        "item" : "EXTERIOR",
        "count" : "1216"
      }, {
        "item" : "TECNOLOGIA ONLINE",
        "count" : "1027"
      }, {
        "item" : "TV CONNECTADA",
        "count" : "976"
      }, {
        "item" : "ALTRES",
        "count" : "228"
      } ],
      "smallest" : "ALTRES",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : { }
  }, {
    "id" : 27420511,
    "name" : "Suport",
    "dataTypeName" : "text",
    "description" : "Nom del mitjà de comunicació",
    "fieldName" : "nom_mitj_de_comunicaci",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 15263852,
    "cachedContents" : {
      "non_null" : "83129",
      "largest" : "ZOOPA PRODUCCIÓ",
      "null" : "831",
      "top" : [ {
        "item" : "FLAIXBAC",
        "count" : "1706"
      }, {
        "item" : "CATALUNYA RÀDIO",
        "count" : "1634"
      }, {
        "item" : "RAC 1",
        "count" : "1551"
      }, {
        "item" : "FLAIX FM",
        "count" : "1475"
      }, {
        "item" : "SER",
        "count" : "1283"
      }, {
        "item" : "FACEBOOK + INSTAGRAM",
        "count" : "1181"
      }, {
        "item" : "EUROPA FM",
        "count" : "1073"
      }, {
        "item" : "PERIÓDICO, EL",
        "count" : "992"
      }, {
        "item" : "ARA.",
        "count" : "947"
      }, {
        "item" : "servidor INTERNET",
        "count" : "921"
      }, {
        "item" : "ONDA CERO",
        "count" : "902"
      }, {
        "item" : "VANGUARDIA, LA",
        "count" : "856"
      }, {
        "item" : "ELNACIONAL.",
        "count" : "805"
      }, {
        "item" : "NACIODIGITAL.",
        "count" : "801"
      }, {
        "item" : "RAC 105",
        "count" : "770"
      }, {
        "item" : "ARA",
        "count" : "744"
      }, {
        "item" : "TVC",
        "count" : "737"
      }, {
        "item" : "LOS 40",
        "count" : "646"
      }, {
        "item" : "CADENA 100",
        "count" : "606"
      }, {
        "item" : "YOUTUBE",
        "count" : "582"
      } ],
      "smallest" : "014 DS MEDIA",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : { }
  }, {
    "id" : 27420517,
    "name" : "Import Net",
    "dataTypeName" : "text",
    "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" : "text",
    "tableColumnId" : 16629904,
    "cachedContents" : {
      "non_null" : "83960",
      "largest" : "9999,98",
      "null" : "0",
      "top" : [ {
        "item" : "1000",
        "count" : "561"
      }, {
        "item" : "500",
        "count" : "493"
      }, {
        "item" : "4000",
        "count" : "488"
      }, {
        "item" : "2000",
        "count" : "454"
      }, {
        "item" : "3000",
        "count" : "440"
      }, {
        "item" : "1500",
        "count" : "361"
      }, {
        "item" : "900",
        "count" : "346"
      }, {
        "item" : "725,47",
        "count" : "330"
      }, {
        "item" : "1200",
        "count" : "315"
      }, {
        "item" : "600",
        "count" : "297"
      }, {
        "item" : "271,15",
        "count" : "290"
      }, {
        "item" : "106,25",
        "count" : "284"
      }, {
        "item" : "5000",
        "count" : "284"
      }, {
        "item" : "12000",
        "count" : "279"
      }, {
        "item" : "348",
        "count" : "271"
      }, {
        "item" : "1800",
        "count" : "266"
      }, {
        "item" : "143",
        "count" : "240"
      }, {
        "item" : "700",
        "count" : "214"
      }, {
        "item" : "2500",
        "count" : "213"
      }, {
        "item" : "753,02",
        "count" : "209"
      } ],
      "smallest" : "0",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 27420513,
    "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" : "83309",
      "largest" : "1.7300",
      "null" : "651",
      "top" : [ {
        "item" : "0",
        "count" : "70946"
      }, {
        "item" : "0.2500",
        "count" : "5635"
      }, {
        "item" : "0.0100",
        "count" : "3099"
      }, {
        "item" : "0.0500",
        "count" : "1534"
      }, {
        "item" : "0.0300",
        "count" : "825"
      }, {
        "item" : "0.0200",
        "count" : "797"
      }, {
        "item" : "0.1500",
        "count" : "426"
      }, {
        "item" : "0.4900",
        "count" : "12"
      }, {
        "item" : "0.4100",
        "count" : "12"
      }, {
        "item" : "1.7300",
        "count" : "8"
      }, {
        "item" : "0.4300",
        "count" : "6"
      }, {
        "item" : "0.1100",
        "count" : "4"
      }, {
        "item" : "0.0900",
        "count" : "2"
      }, {
        "item" : "0.3100",
        "count" : "1"
      }, {
        "item" : "0.4700",
        "count" : "1"
      }, {
        "item" : "0.9500",
        "count" : "1"
      } ],
      "smallest" : "0",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : {
      "precisionStyle" : "percentage",
      "percentScale" : "1",
      "decimalSeparator" : ",",
      "precision" : "2",
      "groupSeparator" : ".",
      "align" : "left"
    }
  }, {
    "id" : 27420514,
    "name" : "IVA",
    "dataTypeName" : "number",
    "description" : "Percentatge d’IVA",
    "fieldName" : "iva",
    "position" : 10,
    "renderTypeName" : "number",
    "tableColumnId" : 15263854,
    "cachedContents" : {
      "non_null" : "83960",
      "largest" : "0.0021",
      "null" : "0",
      "top" : [ {
        "item" : "0.0021",
        "count" : "83960"
      } ],
      "smallest" : "0.0021",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : {
      "precisionStyle" : "percentage",
      "percentScale" : "1",
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 27420515,
    "name" : "Informació complementària",
    "dataTypeName" : "text",
    "description" : "Informació complementària",
    "fieldName" : "informaci_complement_ria",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 15263855,
    "cachedContents" : {
      "non_null" : "12",
      "largest" : "Total facturat a data de 21/02/2024 8.887,45 €",
      "null" : "83948",
      "top" : [ {
        "item" : "import adjudicat",
        "count" : "7"
      }, {
        "item" : "Total facturat a data de 21/02/2024 8.887,45 €",
        "count" : "2"
      }, {
        "item" : "Import passat a Euros",
        "count" : "1"
      }, {
        "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 7.795,27 €",
        "count" : "1"
      } ],
      "smallest" : "import adjudicat",
      "count" : "83960",
      "cardinality" : "83960"
    },
    "format" : { }
  }, {
    "id" : 27420516,
    "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" : {
    "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" : { },
  "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" ]
}