{
  "id" : "n45u-f3pv",
  "name" : "Visites al Palau de la Generalitat",
  "assetType" : "dataset",
  "attribution" : "Departament de la Presidència",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Sector Públic",
  "createdAt" : 1739534877,
  "description" : "El conjunt de dades és un registre de les visites realitzades al Palau de la Generalitat, proporcionant informació sobre l’activitat del lloc institucional.\n\nCada fila equival a una persona que ha realitzat la visita al Palau amb les dades bàsiques: data, hora, tipus de visita, idioma i si és major o menor d’edat.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 190,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 3008279,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1739535173,
  "publicationGroup" : 2015546,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1773923063,
  "rowsUpdatedBy" : "9rf2-9pth",
  "tableId" : 2015546,
  "totalTimesRated" : 0,
  "viewCount" : 435,
  "viewLastModified" : 1773923059,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1739874720,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1492525,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1739874720,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1739874720,
      "failureCount" : 0,
      "startedAt" : 1739874720,
      "status" : "success"
    },
    "submitter" : {
      "id" : "9rf2-9pth",
      "displayName" : "SGOID"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 26676615,
    "name" : "Data",
    "dataTypeName" : "calendar_date",
    "description" : "Data en què es realitza la visita",
    "fieldName" : "data",
    "position" : 1,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 16129147,
    "cachedContents" : {
      "non_null" : "90267",
      "largest" : "2025-12-28T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2024-04-21T00:00:00.000",
        "count" : "10844"
      }, {
        "item" : "2025-04-23T00:00:00.000",
        "count" : "5674"
      }, {
        "item" : "2024-12-15T00:00:00.000",
        "count" : "5585"
      }, {
        "item" : "2025-09-11T00:00:00.000",
        "count" : "5280"
      }, {
        "item" : "2024-12-14T00:00:00.000",
        "count" : "5258"
      }, {
        "item" : "2024-12-19T00:00:00.000",
        "count" : "4754"
      }, {
        "item" : "2024-09-11T00:00:00.000",
        "count" : "4675"
      }, {
        "item" : "2024-12-18T00:00:00.000",
        "count" : "4309"
      }, {
        "item" : "2025-12-14T00:00:00.000",
        "count" : "4095"
      }, {
        "item" : "2025-12-13T00:00:00.000",
        "count" : "3999"
      }, {
        "item" : "2024-12-17T00:00:00.000",
        "count" : "3657"
      }, {
        "item" : "2024-04-20T00:00:00.000",
        "count" : "3648"
      }, {
        "item" : "2024-12-16T00:00:00.000",
        "count" : "3487"
      }, {
        "item" : "2024-09-14T00:00:00.000",
        "count" : "3218"
      }, {
        "item" : "2024-09-15T00:00:00.000",
        "count" : "2930"
      }, {
        "item" : "2024-12-02T00:00:00.000",
        "count" : "311"
      }, {
        "item" : "2025-10-25T00:00:00.000",
        "count" : "308"
      }, {
        "item" : "2025-07-27T00:00:00.000",
        "count" : "275"
      }, {
        "item" : "2024-07-28T00:00:00.000",
        "count" : "246"
      }, {
        "item" : "2025-04-06T00:00:00.000",
        "count" : "244"
      } ],
      "smallest" : "2024-01-07T00:00:00.000",
      "count" : "90267",
      "cardinality" : "90267"
    },
    "format" : {
      "view" : "date_dmy"
    }
  }, {
    "id" : 26676614,
    "name" : "Hora",
    "dataTypeName" : "text",
    "description" : "Hora inicial de la visita",
    "fieldName" : "hora",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 16129146,
    "cachedContents" : {
      "non_null" : "74209",
      "largest" : "9:30:00",
      "null" : "16058",
      "top" : [ {
        "item" : "12:00:00",
        "count" : "11044"
      }, {
        "item" : "13:00:00",
        "count" : "7391"
      }, {
        "item" : "17:00:00",
        "count" : "7117"
      }, {
        "item" : "11:00:00",
        "count" : "5468"
      }, {
        "item" : "18:00:00",
        "count" : "5387"
      }, {
        "item" : "16:00:00",
        "count" : "5058"
      }, {
        "item" : "19:00:00",
        "count" : "4698"
      }, {
        "item" : "14:00:00",
        "count" : "4056"
      }, {
        "item" : "15:00:00",
        "count" : "3974"
      }, {
        "item" : "20:00:00",
        "count" : "3929"
      }, {
        "item" : "21:00:00",
        "count" : "2182"
      }, {
        "item" : "10:00:00",
        "count" : "1383"
      }, {
        "item" : "12:30:00",
        "count" : "1349"
      }, {
        "item" : "12:15:00",
        "count" : "1334"
      }, {
        "item" : "10:45:00",
        "count" : "977"
      }, {
        "item" : "9:30:00",
        "count" : "574"
      }, {
        "item" : "13:30:00",
        "count" : "539"
      }, {
        "item" : "9:15:00",
        "count" : "536"
      }, {
        "item" : "13:15:00",
        "count" : "529"
      }, {
        "item" : "16:30:00",
        "count" : "450"
      } ],
      "smallest" : "09:15:00",
      "count" : "90267",
      "cardinality" : "90267"
    },
    "format" : { }
  }, {
    "id" : 26676613,
    "name" : "Tipus de visita",
    "dataTypeName" : "text",
    "description" : "Tipus de la visita: guiada, protocol·lària, portes obertes, escolar o carilló",
    "fieldName" : "tipus_de_visita",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 16129145,
    "cachedContents" : {
      "non_null" : "90267",
      "largest" : "Presencial",
      "null" : "0",
      "top" : [ {
        "item" : "Portes obertes",
        "count" : "71267"
      }, {
        "item" : "Carilló",
        "count" : "6092"
      }, {
        "item" : "Escolar",
        "count" : "5880"
      }, {
        "item" : "Presencial",
        "count" : "4245"
      }, {
        "item" : "Guiada",
        "count" : "2783"
      } ],
      "smallest" : "Carilló",
      "count" : "90267",
      "cardinality" : "90267"
    },
    "format" : { }
  }, {
    "id" : 26676612,
    "name" : "Idioma",
    "dataTypeName" : "text",
    "description" : "Idioma en què s’ha realitzat la visita guiada",
    "fieldName" : "idioma",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 16129144,
    "cachedContents" : {
      "non_null" : "90267",
      "largest" : "NA",
      "null" : "0",
      "top" : [ {
        "item" : "Català",
        "count" : "72096"
      }, {
        "item" : "NA",
        "count" : "16058"
      }, {
        "item" : "Castellà",
        "count" : "1826"
      }, {
        "item" : "Anglès",
        "count" : "287"
      } ],
      "smallest" : "Anglès",
      "count" : "90267",
      "cardinality" : "90267"
    },
    "format" : { }
  }, {
    "id" : 26676611,
    "name" : "Edat",
    "dataTypeName" : "text",
    "description" : "Si el visitant és major o menor d’edat",
    "fieldName" : "edat",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 16129143,
    "cachedContents" : {
      "non_null" : "90267",
      "largest" : "Menor d'edat",
      "null" : "0",
      "top" : [ {
        "item" : "Major d'edat",
        "count" : "76942"
      }, {
        "item" : "Menor d'edat",
        "count" : "13325"
      } ],
      "smallest" : "Major d'edat",
      "count" : "90267",
      "cardinality" : "90267"
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "data",
        "ascending" : false
      }, {
        "columnFieldName" : "hora",
        "ascending" : true
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Anual"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Visits to Palau de la Generalitat",
        "Nombre del conjunto de datos (ES)" : "Visitas al Palau de la Generalitat"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No"
      },
      "Dades d'Alt Valor" : {
        "Categoria" : "No són dades d’alt valor"
      },
      "Actors" : {
        "Departament" : "Presidència",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Sense informació geogràfica"
      }
    },
    "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" : 26676615,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 26676614,
        "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" : [ "visites", "palau", "palau_generalitat", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}