{ "id" : "2v2p-vu4h", "name" : "Historial d’alcaldes/esses", "assetType" : "dataset", "attribution" : "Secretaria de Governs Locals i de Relacions amb l'Aran", "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/", "averageRating" : 0, "category" : "Sector Públic", "createdAt" : 1591284360, "description" : "Dades històriques dels alcaldes/esses dels municipis catalans des de les primeres eleccions democràtiques de 1979.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 1530, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "SEE_TERMS_OF_USE", "locked" : false, "newBackend" : true, "numberOfComments" : 0, "oid" : 1742464, "provenance" : "official", "publicationAppendEnabled" : true, "publicationDate" : 1591284596, "publicationGroup" : 1172773, "publicationStage" : "published", "rowsUpdatedAt" : 1777518067, "rowsUpdatedBy" : "a4b5-gx6v", "tableId" : 1172773, "totalTimesRated" : 0, "viewCount" : 9599, "viewLastModified" : 1778641254, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1605542947, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 770928, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1605542947, "targetAudience" : "public", "workflowId" : 182, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "endedAt" : 1605542947, "failureCount" : 0, "startedAt" : 1605542947, "status" : "success" }, "submitter" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 15245144, "name" : "CODI_10", "dataTypeName" : "text", "description" : "Codi oficial estadístic", "fieldName" : "codi_10", "position" : 1, "renderTypeName" : "text", "tableColumnId" : 9715977, "cachedContents" : { "non_null" : "11873", "largest" : "4390760009", "null" : "0", "top" : [ { "item" : "0820930008", "count" : "19" }, { "item" : "4301200000", "count" : "17" }, { "item" : "0814770005", "count" : "17" }, { "item" : "0809610007", "count" : "17" }, { "item" : "0809190004", "count" : "17" }, { "item" : "0828830008", "count" : "17" }, { "item" : "0823840003", "count" : "16" }, { "item" : "0807520002", "count" : "16" }, { "item" : "1722660009", "count" : "16" }, { "item" : "4313620002", "count" : "16" }, { "item" : "4301670005", "count" : "16" }, { "item" : "0822700000", "count" : "16" }, { "item" : "0826280001", "count" : "16" }, { "item" : "2523260009", "count" : "16" }, { "item" : "0803050006", "count" : "16" }, { "item" : "0830540003", "count" : "16" }, { "item" : "4304770005", "count" : "16" }, { "item" : "4308620002", "count" : "15" }, { "item" : "4315360009", "count" : "15" }, { "item" : "2511930008", "count" : "15" } ], "smallest" : "0800180001", "count" : "11873", "cardinality" : "11873" }, "format" : { } }, { "id" : 15245148, "name" : "NOM_ENS", "dataTypeName" : "text", "description" : "Nom complet de l’Ens local", "fieldName" : "nom_ens", "position" : 2, "renderTypeName" : "text", "tableColumnId" : 9715981, "cachedContents" : { "non_null" : "11873", "largest" : "Ajuntament d'Urús", "null" : "0", "top" : [ { "item" : "Ajuntament de Sant Fost de Campsentelles", "count" : "19" }, { "item" : "Ajuntament de Granollers", "count" : "17" }, { "item" : "Ajuntament d'Altafulla", "count" : "17" }, { "item" : "Ajuntament d'Olesa de Montserrat", "count" : "17" }, { "item" : "Ajuntament de Gelida", "count" : "17" }, { "item" : "Ajuntament de Torrelles de Foix", "count" : "17" }, { "item" : "Ajuntament de Dosrius", "count" : "16" }, { "item" : "Ajuntament de Vilamalla", "count" : "16" }, { "item" : "Ajuntament de Cabrils", "count" : "16" }, { "item" : "Ajuntament de Sant Quirze del Vallès", "count" : "16" }, { "item" : "Ajuntament de l'Arboç", "count" : "16" }, { "item" : "Ajuntament de Torres de Segre", "count" : "16" }, { "item" : "Ajuntament de Vilafranca del Penedès", "count" : "16" }, { "item" : "Ajuntament de Constantí", "count" : "16" }, { "item" : "Ajuntament de Sant Martí Sarroca", "count" : "16" }, { "item" : "Ajuntament de Sant Vicenç de Castellet", "count" : "16" }, { "item" : "Ajuntament de la Ràpita", "count" : "16" }, { "item" : "Ajuntament de Maçanet de la Selva", "count" : "15" }, { "item" : "Ajuntament de Sant Esteve Sesrovires", "count" : "15" }, { "item" : "Ajuntament de Vilallonga del Camp", "count" : "15" } ], "smallest" : "Ajuntament d'Abella de la Conca", "count" : "11873", "cardinality" : "11873" }, "format" : { } }, { "id" : 15245147, "name" : "NOM_ALCALDE", "dataTypeName" : "text", "description" : "Nom de l’Alcalde/essa", "fieldName" : "nom_alcalde", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 9715980, "cachedContents" : { "non_null" : "11873", "largest" : "Yolanda Ruiz Baena", "null" : "0", "top" : [ { "item" : "JOSEP VILÀ CAMPS", "count" : "9" }, { "item" : "RAMON PINTÓ ROSICH", "count" : "8" }, { "item" : "ANTONI DE SOLÀ PERETA", "count" : "8" }, { "item" : "ANDREU ALET ESPUGA", "count" : "8" }, { "item" : "LLUIS COLOME LLAU", "count" : "8" }, { "item" : "JESÚS BRUGUÉS BRUGUÉS", "count" : "8" }, { "item" : "ALFONS PLANAS JUBANY", "count" : "8" }, { "item" : "JOSEP BLANCH DALMAU", "count" : "8" }, { "item" : "JOSEP MARIA MOLAS PLANELLAS", "count" : "8" }, { "item" : "JAUME CODERCH CASANOVAS", "count" : "8" }, { "item" : "JOSEP ORRIOLS COCH", "count" : "8" }, { "item" : "JOSEP VIDAL MIAS", "count" : "8" }, { "item" : "ISIDRE FORGA RUFIANDIS", "count" : "8" }, { "item" : "JOAN CAMPOLIER MONTSANT", "count" : "8" }, { "item" : "JAUME LLOBET MAJA", "count" : "8" }, { "item" : "RAMON ABELLÓ GARCÍA", "count" : "8" }, { "item" : "PERE OLIU CASAMITJANA", "count" : "7" }, { "item" : "FRANCESC DALMAU NOLLA", "count" : "7" }, { "item" : "ENRIC COLOM SANDIUMENGE", "count" : "7" }, { "item" : "JOSEP GARRIGA FONT", "count" : "7" } ], "smallest" : "ABEL BOLDU PERELLÓ", "count" : "11873", "cardinality" : "11873" }, "format" : { } }, { "id" : 15245146, "name" : "PARTIT_ALCALDE", "dataTypeName" : "text", "description" : "Partit polític / Coalició electoral de l’Alcalde/essa", "fieldName" : "partit_alcalde", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 9715979, "cachedContents" : { "non_null" : "11867", "largest" : "xtuxtu", "null" : "6", "top" : [ { "item" : "CIU", "count" : "4153" }, { "item" : "INDEPENDENTS", "count" : "1266" }, { "item" : "PSC-PSOE", "count" : "748" }, { "item" : "Convergència i Unió", "count" : "524" }, { "item" : "ERC-AM", "count" : "492" }, { "item" : "CiU", "count" : "401" }, { "item" : "PSOE", "count" : "344" }, { "item" : "CM", "count" : "306" }, { "item" : "JxCAT", "count" : "251" }, { "item" : "PSC-CP", "count" : "219" }, { "item" : "PSC-PM", "count" : "211" }, { "item" : "(PSC-PSOE)-PM", "count" : "206" }, { "item" : "ALTRES", "count" : "166" }, { "item" : "ESQUERRA-AM", "count" : "145" }, { "item" : "ERC", "count" : "143" }, { "item" : "UCD", "count" : "128" }, { "item" : "ERC - AM", "count" : "89" }, { "item" : "PP", "count" : "72" }, { "item" : "IU", "count" : "70" }, { "item" : "PSUC", "count" : "47" } ], "smallest" : "-", "count" : "11873", "cardinality" : "11873" }, "format" : { } }, { "id" : 15245145, "name" : "LEGISLATURA_ALCALDE", "dataTypeName" : "text", "description" : "Legislatura electoral", "fieldName" : "legislatura_alcalde", "position" : 5, "renderTypeName" : "text", "tableColumnId" : 9715978, "cachedContents" : { "non_null" : "11873", "largest" : "2023-2027", "null" : "0", "top" : [ { "item" : "2003-2007", "count" : "1067" }, { "item" : "2007-2011", "count" : "1053" }, { "item" : "1999-2003", "count" : "1040" }, { "item" : "1991-1995", "count" : "1025" }, { "item" : "1995-1999", "count" : "988" }, { "item" : "1979-1983", "count" : "983" }, { "item" : "1983-1987", "count" : "967" }, { "item" : "1987-1991", "count" : "957" }, { "item" : "2011-2015", "count" : "950" }, { "item" : "2015-2019", "count" : "949" }, { "item" : "2023-2027", "count" : "947" }, { "item" : "2019-2023", "count" : "947" } ], "smallest" : "1979-1983", "count" : "11873", "cardinality" : "11873" }, "format" : { } }, { "id" : 15245143, "name" : "DATA_PRESSA_POSSESSIO", "dataTypeName" : "calendar_date", "description" : "Data de la pressa de possessió", "fieldName" : "data_pressa_possessio", "position" : 7, "renderTypeName" : "calendar_date", "tableColumnId" : 9715976, "cachedContents" : { "non_null" : "9004", "largest" : "2026-04-22T00:00:00.000", "null" : "2869", "top" : [ { "item" : "2007-06-16T00:00:00.000", "count" : "940" }, { "item" : "1999-07-03T00:00:00.000", "count" : "930" }, { "item" : "2003-06-14T00:00:00.000", "count" : "920" }, { "item" : "1991-06-15T00:00:00.000", "count" : "884" }, { "item" : "1995-06-17T00:00:00.000", "count" : "876" }, { "item" : "1979-04-19T00:00:00.000", "count" : "873" }, { "item" : "1987-06-30T00:00:00.000", "count" : "869" }, { "item" : "2023-06-17T00:00:00.000", "count" : "855" }, { "item" : "1983-05-23T00:00:00.000", "count" : "757" }, { "item" : "1983-05-24T00:00:00.000", "count" : "117" }, { "item" : "1983-05-25T00:00:00.000", "count" : "31" }, { "item" : "1979-04-20T00:00:00.000", "count" : "30" }, { "item" : "1983-11-21T00:00:00.000", "count" : "16" }, { "item" : "1992-01-01T00:00:00.000", "count" : "14" }, { "item" : "1987-11-28T00:00:00.000", "count" : "10" }, { "item" : "1987-07-30T00:00:00.000", "count" : "10" }, { "item" : "2003-07-04T00:00:00.000", "count" : "9" }, { "item" : "1991-07-05T00:00:00.000", "count" : "8" }, { "item" : "1979-04-21T00:00:00.000", "count" : "7" }, { "item" : "1991-07-15T00:00:00.000", "count" : "7" } ], "smallest" : "1979-03-19T00:00:00.000", "count" : "11873", "cardinality" : "11873" }, "format" : { "view" : "date_dmy" } }, { "id" : 15245142, "name" : "DATA_BAIXA", "dataTypeName" : "calendar_date", "description" : "Data de la baixa", "fieldName" : "data_baixa", "position" : 8, "renderTypeName" : "calendar_date", "tableColumnId" : 9715975, "cachedContents" : { "non_null" : "8054", "largest" : "2011-06-11T00:00:00.000", "null" : "3819", "top" : [ { "item" : "2003-05-24T00:00:00.000", "count" : "981" }, { "item" : "2011-05-21T00:00:00.000", "count" : "944" }, { "item" : "2007-05-26T00:00:00.000", "count" : "943" }, { "item" : "1995-05-27T00:00:00.000", "count" : "942" }, { "item" : "1983-05-07T00:00:00.000", "count" : "934" }, { "item" : "1987-06-09T00:00:00.000", "count" : "931" }, { "item" : "1991-05-25T00:00:00.000", "count" : "921" }, { "item" : "1999-06-12T00:00:00.000", "count" : "909" }, { "item" : "2005-06-14T00:00:00.000", "count" : "5" }, { "item" : "2009-06-15T00:00:00.000", "count" : "4" }, { "item" : "1981-01-01T00:00:00.000", "count" : "3" }, { "item" : "2009-06-13T00:00:00.000", "count" : "3" }, { "item" : "2005-06-15T00:00:00.000", "count" : "3" }, { "item" : "1996-07-19T00:00:00.000", "count" : "2" }, { "item" : "2004-06-28T00:00:00.000", "count" : "2" }, { "item" : "1996-06-14T00:00:00.000", "count" : "2" }, { "item" : "1996-03-22T00:00:00.000", "count" : "2" }, { "item" : "1994-10-11T00:00:00.000", "count" : "2" }, { "item" : "2004-04-30T00:00:00.000", "count" : "2" }, { "item" : "2001-05-29T00:00:00.000", "count" : "2" } ], "smallest" : "1979-04-19T00:00:00.000", "count" : "11873", "cardinality" : "11873" }, "format" : { "view" : "date_dmy" } } ], "grants" : [ { "inherited" : false, "type" : "viewer", "flags" : [ "public" ] } ], "license" : { "name" : "See Terms of Use" }, "metadata" : { "jsonQuery" : { "order" : [ { "columnFieldName" : "codi_10", "ascending" : true }, { "columnFieldName" : "legislatura_alcalde", "ascending" : false } ] }, "custom_fields" : { "Freqüència d'actualització" : { "Freqüència d'actualització" : "Variable" }, "Idioma" : { "Idioma" : "Català", "Dataset name (EN)" : "Record of mayors", "Nombre del conjunto de datos (ES)" : "Historial de alcaldes/esas" }, "Informació de gènere o sexe" : { "Informació de gènere o sexe" : "No" }, "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" : true, "expression" : { "columnId" : 15245144, "type" : "column" } }, { "ascending" : false, "expression" : { "columnId" : 15245145, "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" : [ "alcaldes", "alcaldesses", "historial d'alcaldes", "historial d'alcaldesses", "municat", "ods16_pau justícies i institucions sòlides" ], "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ] }