{
  "id" : "tgns-3xuy",
  "name" : "Processos electorals - Convocatòries",
  "assetType" : "dataset",
  "attribution" : "Subdirecció General de Processos Electorals i Democràcia Directa",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Sector Públic",
  "createdAt" : 1573034378,
  "description" : "Llistat dels processos electorals disponibles a la plataforma.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1196,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2589041,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1677155647,
  "publicationGroup" : 1035632,
  "publicationStage" : "published",
  "rowIdentifierColumnId" : 23668151,
  "rowsUpdatedAt" : 1769771387,
  "rowsUpdatedBy" : "d96r-ezpq",
  "tableId" : 1751078,
  "totalTimesRated" : 0,
  "viewCount" : 5060,
  "viewLastModified" : 1769771386,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1610616346,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1296094,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1610616346,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1610616346,
      "failureCount" : 0,
      "startedAt" : 1610616346,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 23668151,
    "name" : "ID_ELECCIO",
    "dataTypeName" : "text",
    "description" : "Identificador de l'elecció (Tipus+Any+Seqüencial)",
    "fieldName" : "id_eleccio",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 8104573,
    "cachedContents" : {
      "non_null" : "109",
      "largest" : "V20231",
      "null" : "0",
      "top" : [ {
        "item" : "A20121",
        "count" : "1"
      }, {
        "item" : "M20151",
        "count" : "1"
      }, {
        "item" : "S20192",
        "count" : "1"
      }, {
        "item" : "A19991",
        "count" : "1"
      }, {
        "item" : "G20081",
        "count" : "1"
      }, {
        "item" : "D19791",
        "count" : "1"
      }, {
        "item" : "A20211",
        "count" : "1"
      }, {
        "item" : "R19791",
        "count" : "1"
      }, {
        "item" : "E19991",
        "count" : "1"
      }, {
        "item" : "D20151",
        "count" : "1"
      }, {
        "item" : "M20191",
        "count" : "1"
      }, {
        "item" : "G20231",
        "count" : "1"
      }, {
        "item" : "A19881",
        "count" : "1"
      }, {
        "item" : "V19911",
        "count" : "1"
      }, {
        "item" : "V19951",
        "count" : "1"
      }, {
        "item" : "D20231",
        "count" : "1"
      }, {
        "item" : "D19991",
        "count" : "1"
      }, {
        "item" : "G20192",
        "count" : "1"
      }, {
        "item" : "S20041",
        "count" : "1"
      }, {
        "item" : "R19761",
        "count" : "1"
      } ],
      "smallest" : "A19801",
      "count" : "109",
      "cardinality" : "109"
    },
    "format" : { }
  }, {
    "id" : 23668152,
    "name" : "NOM_ELECCIO",
    "dataTypeName" : "text",
    "description" : "Nom del procés electoral",
    "fieldName" : "nom_eleccio",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 8104574,
    "cachedContents" : {
      "non_null" : "109",
      "largest" : "Referèndum sobre l'OTAN 1986",
      "null" : "0",
      "top" : [ {
        "item" : "Eleccions al Parlament Europeu 1987",
        "count" : "1"
      }, {
        "item" : "Eleccions al Consell General d'Aran 1999",
        "count" : "1"
      }, {
        "item" : "Eleccions als vocals de les juntes de veïns de les Entitats Municipals Descentralitzades 2023",
        "count" : "1"
      }, {
        "item" : "Eleccions Municipals 2007",
        "count" : "1"
      }, {
        "item" : "Eleccions al Congrés 2008",
        "count" : "1"
      }, {
        "item" : "Eleccions a Consells Comarcals 1987",
        "count" : "1"
      }, {
        "item" : "Eleccions a Consells Comarcals 1995",
        "count" : "1"
      }, {
        "item" : "Eleccions al Parlament de Catalunya 2021",
        "count" : "1"
      }, {
        "item" : "Referèndum Estatut Catalunya 1979",
        "count" : "1"
      }, {
        "item" : "Eleccions a Consells Comarcals 1988",
        "count" : "1"
      }, {
        "item" : "Eleccions al Congrés 1979",
        "count" : "1"
      }, {
        "item" : "Eleccions a Diputacions Provincials 2011",
        "count" : "1"
      }, {
        "item" : "Eleccions al Congrés 1982",
        "count" : "1"
      }, {
        "item" : "Eleccions Municipals 1995",
        "count" : "1"
      }, {
        "item" : "Referèndum Estatut Autonomia Catalunya 2006",
        "count" : "1"
      }, {
        "item" : "Eleccions Municipals 1987",
        "count" : "1"
      }, {
        "item" : "Eleccions al Consell General d'Aran 2007",
        "count" : "1"
      }, {
        "item" : "Eleccions al Parlament de Catalunya 1995",
        "count" : "1"
      }, {
        "item" : "Eleccions al Consell General d'Aran 2019",
        "count" : "1"
      }, {
        "item" : "Referèndum Reforma Política 1976",
        "count" : "1"
      } ],
      "smallest" : "Eleccions a Consells Comarcals 1987",
      "count" : "109",
      "cardinality" : "109"
    },
    "format" : { }
  }, {
    "id" : 23668153,
    "name" : "CODI_TIPUS_ELECCIO",
    "dataTypeName" : "text",
    "description" : "Tipus de procés (Parlament, Municipals, Congrés...)",
    "fieldName" : "codi_tipus_eleccio",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 8104575,
    "cachedContents" : {
      "non_null" : "109",
      "largest" : "V",
      "null" : "0",
      "top" : [ {
        "item" : "G",
        "count" : "16"
      }, {
        "item" : "S",
        "count" : "16"
      }, {
        "item" : "A",
        "count" : "14"
      }, {
        "item" : "D",
        "count" : "12"
      }, {
        "item" : "M",
        "count" : "12"
      }, {
        "item" : "C",
        "count" : "11"
      }, {
        "item" : "V",
        "count" : "9"
      }, {
        "item" : "E",
        "count" : "9"
      }, {
        "item" : "R",
        "count" : "6"
      }, {
        "item" : "T",
        "count" : "2"
      }, {
        "item" : "J",
        "count" : "2"
      } ],
      "smallest" : "A",
      "count" : "109",
      "cardinality" : "109"
    },
    "format" : { }
  }, {
    "id" : 23668154,
    "name" : "NOM_TIPUS_ELECCIO",
    "dataTypeName" : "text",
    "description" : "Nom del tipus de procés",
    "fieldName" : "nom_tipus_eleccio",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 8104576,
    "cachedContents" : {
      "non_null" : "109",
      "largest" : "Referèndum",
      "null" : "0",
      "top" : [ {
        "item" : "Eleccions al Congrés",
        "count" : "16"
      }, {
        "item" : "Eleccions al Senat",
        "count" : "16"
      }, {
        "item" : "Eleccions al Parlament de Catalunya",
        "count" : "14"
      }, {
        "item" : "Eleccions a Diputacions Provincials",
        "count" : "12"
      }, {
        "item" : "Eleccions Municipals",
        "count" : "12"
      }, {
        "item" : "Eleccions a Consells Comarcals",
        "count" : "11"
      }, {
        "item" : "Eleccions al Parlament Europeu",
        "count" : "9"
      }, {
        "item" : "Eleccions al Consell General d'Aran",
        "count" : "9"
      }, {
        "item" : "Referèndum",
        "count" : "6"
      }, {
        "item" : "Eleccions a la Presidència de les Entitats Municipals Descentralitzades",
        "count" : "2"
      }, {
        "item" : "Eleccions als vocals de les juntes de veïns de les Entitats Municipals Descentralitzades",
        "count" : "2"
      } ],
      "smallest" : "Eleccions a Consells Comarcals",
      "count" : "109",
      "cardinality" : "109"
    },
    "format" : { }
  }, {
    "id" : 23668155,
    "name" : "DATA_ELECCIO",
    "dataTypeName" : "calendar_date",
    "description" : "Data del próces electoral",
    "fieldName" : "data_eleccio",
    "position" : 5,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 8104578,
    "cachedContents" : {
      "non_null" : "109",
      "largest" : "2024-06-09T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2019-05-26T00:00:00.000",
        "count" : "7"
      }, {
        "item" : "2023-05-28T00:00:00.000",
        "count" : "6"
      }, {
        "item" : "1999-06-13T00:00:00.000",
        "count" : "5"
      }, {
        "item" : "1987-06-10T00:00:00.000",
        "count" : "4"
      }, {
        "item" : "2003-05-25T00:00:00.000",
        "count" : "4"
      }, {
        "item" : "1991-05-26T00:00:00.000",
        "count" : "4"
      }, {
        "item" : "2015-05-24T00:00:00.000",
        "count" : "4"
      }, {
        "item" : "2007-05-27T00:00:00.000",
        "count" : "4"
      }, {
        "item" : "1995-05-28T00:00:00.000",
        "count" : "4"
      }, {
        "item" : "2011-05-22T00:00:00.000",
        "count" : "4"
      }, {
        "item" : "2019-04-28T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2004-03-14T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "1979-04-03T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2015-12-20T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2000-03-12T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2011-11-20T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "1989-10-29T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-11-10T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "1983-05-08T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "1979-03-01T00:00:00.000",
        "count" : "2"
      } ],
      "smallest" : "1976-12-15T00:00:00.000",
      "count" : "109",
      "cardinality" : "109"
    },
    "format" : {
      "view" : "date_dmy"
    }
  }, {
    "id" : 23668156,
    "name" : "NIVELL_CIRCUMSCRIPCIO",
    "dataTypeName" : "text",
    "description" : "Nivell territorial de la circumscripció electoral",
    "fieldName" : "nivell_circumscripcio",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 8104577,
    "cachedContents" : {
      "non_null" : "94",
      "largest" : "TR",
      "null" : "15",
      "top" : [ {
        "item" : "PR",
        "count" : "58"
      }, {
        "item" : "MU",
        "count" : "12"
      }, {
        "item" : "CO",
        "count" : "11"
      }, {
        "item" : "TR",
        "count" : "9"
      }, {
        "item" : "EMD",
        "count" : "4"
      } ],
      "smallest" : "CO",
      "count" : "109",
      "cardinality" : "109"
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "data_eleccio",
        "ascending" : false
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Variable"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Elections - Electoral calls",
        "Nombre del conjunto de datos (ES)" : "Procesos electorales - Convocatorias"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Dades d'Alt Valor" : {
        "Categoria" : "No són dades d’alt valor"
      },
      "Actors" : {
        "Departament" : "Justícia i Qualitat Democràtica",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Codi d'element",
        "Àmbit geogràfic" : "Catalunya"
      }
    },
    "rowIdentifier" : 23668151,
    "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" : 23668155,
        "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" : [ "eleccions", "procés electoral", "processos", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}