{
  "id" : "88am-kun5",
  "name" : "Empreses participades per Avançsa",
  "assetType" : "dataset",
  "attribution" : "Avançsa",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Indústria",
  "createdAt" : 1616590417,
  "description" : "Relació de les empreses en les quals té participació l’empresa de Promoció i Localització Industrial de Catalunya, SA (Avançsa). Avançsa és una societat mercantil, íntegrament participada per la Generalitat de Catalunya, que s'adscriu al Departament d'Empresa i Coneixement.\nAvançsa és l'entitat de la Generalitat de Catalunya encarregada d'impulsar la reconversió industrial del país i donar suport tècnic, administratiu i econòmic a les empreses.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1039,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2023530,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1616590620,
  "publicationGroup" : 1372308,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1767011927,
  "rowsUpdatedBy" : "7jt5-3aar",
  "tableId" : 1372308,
  "totalTimesRated" : 0,
  "viewCount" : 4540,
  "viewLastModified" : 1767011926,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1616595729,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 868256,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1616595729,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1616595729,
      "failureCount" : 0,
      "startedAt" : 1616595729,
      "status" : "success"
    },
    "submitter" : {
      "id" : "8qes-nydi",
      "displayName" : "Empresa i Treball"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 18871707,
    "name" : "Any",
    "dataTypeName" : "number",
    "description" : "Any en què es va formalitzar la participació d’Avançsa",
    "fieldName" : "any",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 12500705,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "2025",
      "null" : "0",
      "top" : [ {
        "item" : "2015",
        "count" : "5"
      }, {
        "item" : "2025",
        "count" : "1"
      }, {
        "item" : "2021",
        "count" : "1"
      }, {
        "item" : "2012",
        "count" : "1"
      }, {
        "item" : "1998",
        "count" : "1"
      }, {
        "item" : "2024",
        "count" : "1"
      }, {
        "item" : "2020",
        "count" : "1"
      } ],
      "smallest" : "1998",
      "count" : "11",
      "cardinality" : "11"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 18871713,
    "name" : "Nom de l'empresa",
    "dataTypeName" : "text",
    "description" : "Raó social de l’empresa participada",
    "fieldName" : "nom_de_l_empresa",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 12500711,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "SA de valoritzacions Agroramaderes SA",
      "null" : "0",
      "top" : [ {
        "item" : "Combustibles ecologics catalans SA",
        "count" : "1"
      }, {
        "item" : "Neos Surgery SL",
        "count" : "1"
      }, {
        "item" : "Devicare SL",
        "count" : "1"
      }, {
        "item" : "Inbrain Neuroelectronics SL",
        "count" : "1"
      }, {
        "item" : "SA de valoritzacions Agroramaderes SA",
        "count" : "1"
      }, {
        "item" : "Circuits de Catalunya SL",
        "count" : "1"
      }, {
        "item" : "Comercial de la Forja SA",
        "count" : "1"
      }, {
        "item" : "Biomassa de les terres de l'Ebre SA",
        "count" : "1"
      }, {
        "item" : "Mercados de Abastecimientos de Barcelona, SA",
        "count" : "1"
      }, {
        "item" : "Megafram AIE",
        "count" : "1"
      }, {
        "item" : "IDIADA AT",
        "count" : "1"
      } ],
      "smallest" : "Biomassa de les terres de l'Ebre SA",
      "count" : "11",
      "cardinality" : "11"
    },
    "format" : { }
  }, {
    "id" : 18871712,
    "name" : "Estat",
    "dataTypeName" : "text",
    "description" : "Estat en què es troba l’empresa: Activa, Imactiva o en liquidació",
    "fieldName" : "estat",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 12500710,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "Inactiva",
      "null" : "0",
      "top" : [ {
        "item" : "Activa",
        "count" : "7"
      }, {
        "item" : "Inactiva",
        "count" : "2"
      }, {
        "item" : "En liquidació",
        "count" : "2"
      } ],
      "smallest" : "Activa",
      "count" : "11",
      "cardinality" : "11"
    },
    "format" : { }
  }, {
    "id" : 18871711,
    "name" : "NIF",
    "dataTypeName" : "text",
    "description" : "Número d’Identificació Fiscal de l’Empresa",
    "fieldName" : "nif",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 12500709,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "G60764917",
      "null" : "0",
      "top" : [ {
        "item" : "B65663122",
        "count" : "1"
      }, {
        "item" : "A08210403",
        "count" : "1"
      }, {
        "item" : "G60764917",
        "count" : "1"
      }, {
        "item" : "A60978897",
        "count" : "1"
      }, {
        "item" : "A58402165",
        "count" : "1"
      }, {
        "item" : "B67556670",
        "count" : "1"
      }, {
        "item" : "A62508601",
        "count" : "1"
      }, {
        "item" : "A43581610",
        "count" : "1"
      }, {
        "item" : "B08282626",
        "count" : "1"
      }, {
        "item" : "A43722057",
        "count" : "1"
      }, {
        "item" : "B20822334",
        "count" : "1"
      } ],
      "smallest" : "A08210403",
      "count" : "11",
      "cardinality" : "11"
    },
    "format" : { }
  }, {
    "id" : 18871710,
    "name" : "Municipi",
    "dataTypeName" : "text",
    "description" : "Municipi on té la seu social l’empresa participada",
    "fieldName" : "municipi",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 12500708,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "Tarragona",
      "null" : "0",
      "top" : [ {
        "item" : "Barcelona",
        "count" : "3"
      }, {
        "item" : "Cerdanyola del Vallès",
        "count" : "2"
      }, {
        "item" : "Santa Oliva",
        "count" : "1"
      }, {
        "item" : "Miralcamp",
        "count" : "1"
      }, {
        "item" : "Navarcles",
        "count" : "1"
      }, {
        "item" : "Tarragona",
        "count" : "1"
      }, {
        "item" : "Montmeló",
        "count" : "1"
      }, {
        "item" : "Ripollès",
        "count" : "1"
      } ],
      "smallest" : "Barcelona",
      "count" : "11",
      "cardinality" : "11"
    },
    "format" : { }
  }, {
    "id" : 18871709,
    "name" : "% de participació",
    "dataTypeName" : "number",
    "description" : "Percentatge del capital social que és propietat d'Avançsa",
    "fieldName" : "de_participaci",
    "position" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 12500707,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "1.00",
      "null" : "0",
      "top" : [ {
        "item" : "0.10",
        "count" : "2"
      }, {
        "item" : "0.20",
        "count" : "1"
      }, {
        "item" : "0.0357",
        "count" : "1"
      }, {
        "item" : "0.2689",
        "count" : "1"
      }, {
        "item" : "0.1692",
        "count" : "1"
      }, {
        "item" : "0.25",
        "count" : "1"
      }, {
        "item" : "1.00",
        "count" : "1"
      }, {
        "item" : "0.1125",
        "count" : "1"
      }, {
        "item" : "0.15",
        "count" : "1"
      }, {
        "item" : "0.05",
        "count" : "1"
      } ],
      "smallest" : "0.0357",
      "count" : "11",
      "cardinality" : "11"
    },
    "format" : {
      "precisionStyle" : "percentage",
      "percentScale" : "1"
    }
  }, {
    "id" : 18871708,
    "name" : "Sector de l'activitat",
    "dataTypeName" : "text",
    "description" : "Descripció de l’àmbit en el què l’empresa realitza la seva activitat empresarial (no sectors normalitzats)",
    "fieldName" : "sector_de_l_activitat",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 12500706,
    "cachedContents" : {
      "non_null" : "11",
      "largest" : "Salut, biotecnologia i indústria farmacèutica",
      "null" : "0",
      "top" : [ {
        "item" : "Energia i recursos",
        "count" : "4"
      }, {
        "item" : "Salut, biotecnologia i indústria farmacèutica",
        "count" : "3"
      }, {
        "item" : "Mobilitat",
        "count" : "2"
      }, {
        "item" : "Comerç",
        "count" : "1"
      }, {
        "item" : "Matèries primeres i transformació del metall i altres materials",
        "count" : "1"
      } ],
      "smallest" : "Comerç",
      "count" : "11",
      "cardinality" : "11"
    },
    "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ó" : "Anual"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Invested companyies by AVANÇSA",
        "Nombre del conjunto de datos (ES)" : "Empresas participadas por AVANÇSA"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Actors" : {
        "Departament" : "Empresa i Treball",
        "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" : [ "empresa", "avançsa", "indústria", "inversió", "finançament", "capital", "ods9_indústria innovació i infraestructures" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}