{
  "id" : "cmnw-duhh",
  "name" : "Certificats d’eficiència energètica d’edificis: instal·lacions",
  "assetType" : "dataset",
  "attribution" : "Institut Català d’Energia (ICAEN)",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Energia",
  "createdAt" : 1644833183,
  "description" : "Dades corresponents a la informació de les instal·lacions dels certificats d’eficiència energètica dels edificis d’acord amb el Reial Decret 290/2021.\n\nA Catalunya des de l'1 de juny de 2013 és obligatori disposar del certificat energètic per als edificis i habitatges ja existents que es lloguin o es venguin, i per als edificis o parts d'edificis que una autoritat pública ocupi més de 250 m2 i siguin freqüentats habitualment pel públic.\n\nDes del 3 de juny de 2021 també és obligatori per edificis que s’amplien o reformin i per edificis terciaris de superfície útil superior a 500m2 d’usos com administratiu, sanitat, comercial, residencial públic, docent, cultural, restauració, transport, esportiu o llocs de culte.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1168,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2252592,
  "provenance" : "official",
  "publicationAppendEnabled" : true,
  "publicationDate" : 1644836592,
  "publicationGroup" : 1532811,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1779638092,
  "rowsUpdatedBy" : "a4b5-gx6v",
  "tableId" : 1532811,
  "totalTimesRated" : 0,
  "viewCount" : 2734,
  "viewLastModified" : 1779636010,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1644837008,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1083182,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1644837008,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1644837008,
      "failureCount" : 0,
      "startedAt" : 1644837008,
      "status" : "success"
    },
    "submitter" : {
      "id" : "7yiu-nmxh",
      "displayName" : "M. Montserrat Moliné Salvat"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 20921404,
    "name" : "NUM_CAS",
    "dataTypeName" : "text",
    "description" : "Identificador del tràmit del certificat d’eficiència energètica",
    "fieldName" : "num_cas",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 13874352,
    "cachedContents" : {
      "non_null" : "4072659",
      "largest" : "ZZZWYQ9QF",
      "null" : "0",
      "top" : [ {
        "item" : "LBWNK9QCB",
        "count" : "21000"
      }, {
        "item" : "TTKTXWLY8",
        "count" : "11484"
      }, {
        "item" : "9D4LBX26W",
        "count" : "10368"
      }, {
        "item" : "4KNBVX6Q9",
        "count" : "10050"
      }, {
        "item" : "7QNDTNQSX",
        "count" : "9576"
      }, {
        "item" : "X53Q28QD9",
        "count" : "8844"
      }, {
        "item" : "35GBNSSY5",
        "count" : "8256"
      }, {
        "item" : "YNYNMQLWY",
        "count" : "7260"
      }, {
        "item" : "TRFZHXHXQ",
        "count" : "6144"
      }, {
        "item" : "M65Z2RZ8Z",
        "count" : "5928"
      }, {
        "item" : "QCPHCCSPD",
        "count" : "4347"
      }, {
        "item" : "GYW3X2T37",
        "count" : "3880"
      }, {
        "item" : "Z6QJ12Y3J",
        "count" : "3472"
      }, {
        "item" : "X5D6BNX4N",
        "count" : "3472"
      }, {
        "item" : "LD92K9B4M",
        "count" : "3380"
      }, {
        "item" : "J80LZZ36L",
        "count" : "3276"
      }, {
        "item" : "JYT7SMKN2",
        "count" : "3128"
      }, {
        "item" : "LNVH8J4K",
        "count" : "3120"
      }, {
        "item" : "0SVQS13QY",
        "count" : "3072"
      }, {
        "item" : "QJ7LW5W75",
        "count" : "3060"
      } ],
      "smallest" : "00000BXZ6",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921387,
    "name" : "US_EDIFICI",
    "dataTypeName" : "text",
    "description" : "Ús de l’edifici (habitatge, terciari)",
    "fieldName" : "us_edifici",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 13874335,
    "cachedContents" : {
      "non_null" : "4072659",
      "largest" : "Vivienda unifamiliar",
      "null" : "0",
      "top" : [ {
        "item" : "Habitatge individual en bloc d'habitatges",
        "count" : "1758250"
      }, {
        "item" : "Habitatge unifamiliar",
        "count" : "765438"
      }, {
        "item" : "Terciari",
        "count" : "656342"
      }, {
        "item" : "Vivienda individual en bloque de viviendas",
        "count" : "240798"
      }, {
        "item" : "Bloc d'habitatges",
        "count" : "199812"
      }, {
        "item" : "Bloc d'habitatges plurifamiliar",
        "count" : "156424"
      }, {
        "item" : "Terciario",
        "count" : "137491"
      }, {
        "item" : "Vivienda unifamiliar",
        "count" : "118732"
      }, {
        "item" : "Bloque de viviendas",
        "count" : "25283"
      }, {
        "item" : "Bloque de viviendas plurifamiliar",
        "count" : "14087"
      }, {
        "item" : "Bomba de Calor",
        "count" : "2"
      } ],
      "smallest" : "Bloc d'habitatges",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921407,
    "name" : "TIPUS_TERCIARI",
    "dataTypeName" : "text",
    "description" : "Tipologia d’ús terciari",
    "fieldName" : "tipus_terciari",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 13874355,
    "cachedContents" : {
      "non_null" : "793832",
      "largest" : "Terciari",
      "null" : "3278827",
      "top" : [ {
        "item" : "Oficines",
        "count" : "180757"
      }, {
        "item" : "Hotel",
        "count" : "87770"
      }, {
        "item" : "Educació",
        "count" : "85432"
      }, {
        "item" : "Sanitat",
        "count" : "70440"
      }, {
        "item" : "Comerç",
        "count" : "59334"
      }, {
        "item" : "Local",
        "count" : "57683"
      }, {
        "item" : "Altres",
        "count" : "53449"
      }, {
        "item" : "Oficinas",
        "count" : "31935"
      }, {
        "item" : "Oficines en edifici industrial",
        "count" : "28021"
      }, {
        "item" : "Cultural",
        "count" : "24979"
      }, {
        "item" : "Restauració",
        "count" : "21360"
      }, {
        "item" : "Esportiu",
        "count" : "19446"
      }, {
        "item" : "Comercio",
        "count" : "17416"
      }, {
        "item" : "Sanidad",
        "count" : "14926"
      }, {
        "item" : "Otros",
        "count" : "11753"
      }, {
        "item" : "Educación",
        "count" : "10601"
      }, {
        "item" : "Oficinas en edificio industrial",
        "count" : "9094"
      }, {
        "item" : "Deportivo",
        "count" : "6507"
      }, {
        "item" : "Restauración",
        "count" : "2923"
      }, {
        "item" : "Gran terciari",
        "count" : "2"
      } ],
      "smallest" : "Altres",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921415,
    "name" : "MOTIU_CERTIFICACIO",
    "dataTypeName" : "text",
    "description" : "Motiu per fer la certificació",
    "fieldName" : "motiu_certificacio",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 13874363,
    "cachedContents" : {
      "non_null" : "4072655",
      "largest" : "Sol·licitut d'ajuts",
      "null" : "4",
      "top" : [ {
        "item" : "Compravenda",
        "count" : "1207167"
      }, {
        "item" : "Lloguer",
        "count" : "857085"
      }, {
        "item" : "Certificació voluntària",
        "count" : "401519"
      }, {
        "item" : "Sol·licitud d'ajuts",
        "count" : "267887"
      }, {
        "item" : "Compra o Venta",
        "count" : "230635"
      }, {
        "item" : "Nova construcció",
        "count" : "174053"
      }, {
        "item" : "Nova construcció o gran rehabilitació",
        "count" : "168204"
      }, {
        "item" : "Compra o Venda",
        "count" : "160443"
      }, {
        "item" : "Edifici existent de l’administració pública",
        "count" : "94787"
      }, {
        "item" : "Alquiler",
        "count" : "88358"
      }, {
        "item" : "Certificación voluntaria",
        "count" : "75498"
      }, {
        "item" : "Renovació (en cas de caducitat de l'antic certificat energètic)",
        "count" : "45551"
      }, {
        "item" : "Solicitud de ayudas",
        "count" : "38948"
      }, {
        "item" : "Edificis o parts d¿edificis (+500 m2) amb ús administratiu, sanitari, comercial, docent, restauració",
        "count" : "36627"
      }, {
        "item" : "Edificio existente de la administración pública",
        "count" : "24741"
      }, {
        "item" : "Edifici existent de l¿administració pública",
        "count" : "21720"
      }, {
        "item" : "Edificis o parts d’edificis (+500 m2) amb ús administratiu, sanitari, comercial, docent, restauració",
        "count" : "21448"
      }, {
        "item" : "Edificios o partes de edificios (+500 m2) de uso administrativo, sanitario, comercial, docente, restauración...",
        "count" : "19548"
      }, {
        "item" : "Edificis o parts d¿edificis on es realitzin reformes o ampliacions",
        "count" : "19537"
      }, {
        "item" : "Complement a informe d¿avaluació de l¿edifici (IEE) o a inspecció tècnica de l¿edifici (ITE)",
        "count" : "18767"
      } ],
      "smallest" : "Alquiler",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921421,
    "name" : "QUALIFICACIO_EMISSIONS",
    "dataTypeName" : "text",
    "description" : "Lletra de qualificació d’emissions de CO2 (A-G)",
    "fieldName" : "qualificacio_emissions",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 13874369,
    "cachedContents" : {
      "non_null" : "4072659",
      "largest" : "G",
      "null" : "0",
      "top" : [ {
        "item" : "E",
        "count" : "1871606"
      }, {
        "item" : "D",
        "count" : "586974"
      }, {
        "item" : "A",
        "count" : "404989"
      }, {
        "item" : "C",
        "count" : "366502"
      }, {
        "item" : "F",
        "count" : "334509"
      }, {
        "item" : "B",
        "count" : "262928"
      }, {
        "item" : "G",
        "count" : "245149"
      }, {
        "item" : "99999999,99",
        "count" : "2"
      } ],
      "smallest" : "99999999,99",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921416,
    "name" : "QUALIFICACIO_ENERGIA",
    "dataTypeName" : "text",
    "description" : "Lletra de qualificació d’energia primària no renovable (A-G)",
    "fieldName" : "qualificacio_energia",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 13874364,
    "cachedContents" : {
      "non_null" : "4072659",
      "largest" : "G",
      "null" : "0",
      "top" : [ {
        "item" : "E",
        "count" : "1705766"
      }, {
        "item" : "G",
        "count" : "573377"
      }, {
        "item" : "D",
        "count" : "464935"
      }, {
        "item" : "F",
        "count" : "416216"
      }, {
        "item" : "C",
        "count" : "320259"
      }, {
        "item" : "A",
        "count" : "305907"
      }, {
        "item" : "B",
        "count" : "286197"
      }, {
        "item" : "3,21",
        "count" : "1"
      }, {
        "item" : "3,61",
        "count" : "1"
      } ],
      "smallest" : "3,21",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921388,
    "name" : "NOM_POBLACIO",
    "dataTypeName" : "text",
    "description" : "Municipi (d’acord amb la taula de municipis de Catalunya de l’Idescat)",
    "fieldName" : "nom_poblacio",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 13874336,
    "cachedContents" : {
      "non_null" : "4072659",
      "largest" : "Xerta",
      "null" : "0",
      "top" : [ {
        "item" : "Barcelona",
        "count" : "972009"
      }, {
        "item" : "Hospitalet de Llobregat (L')",
        "count" : "109576"
      }, {
        "item" : "Sabadell",
        "count" : "107923"
      }, {
        "item" : "Terrassa",
        "count" : "100483"
      }, {
        "item" : "Badalona",
        "count" : "95398"
      }, {
        "item" : "Sant Cugat del Vallès",
        "count" : "69213"
      }, {
        "item" : "Tarragona",
        "count" : "65870"
      }, {
        "item" : "Cerdanyola del Vallès",
        "count" : "64739"
      }, {
        "item" : "Lleida",
        "count" : "62967"
      }, {
        "item" : "Girona",
        "count" : "59498"
      }, {
        "item" : "Mataró",
        "count" : "55696"
      }, {
        "item" : "Reus",
        "count" : "43024"
      }, {
        "item" : "Vilanova i la Geltrú",
        "count" : "40320"
      }, {
        "item" : "Santa Coloma de Gramenet",
        "count" : "38723"
      }, {
        "item" : "Sant Boi de Llobregat",
        "count" : "37283"
      }, {
        "item" : "Viladecans",
        "count" : "37048"
      }, {
        "item" : "Manresa",
        "count" : "36040"
      }, {
        "item" : "Cornellà de Llobregat",
        "count" : "35150"
      }, {
        "item" : "Rubí",
        "count" : "34369"
      }, {
        "item" : "Salou",
        "count" : "34226"
      } ],
      "smallest" : "08019",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921398,
    "name" : "CODI_POBLACIO",
    "dataTypeName" : "text",
    "description" : "Codi del municipi (d’acord amb la taula de municipis de Catalunya de l’Idescat)",
    "fieldName" : "codi_poblacio",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 13874346,
    "cachedContents" : {
      "non_null" : "4072659",
      "largest" : "ElectricidadPeninsular",
      "null" : "0",
      "top" : [ {
        "item" : "08019",
        "count" : "971699"
      }, {
        "item" : "08101",
        "count" : "111804"
      }, {
        "item" : "08187",
        "count" : "107959"
      }, {
        "item" : "08279",
        "count" : "100514"
      }, {
        "item" : "08015",
        "count" : "95760"
      }, {
        "item" : "08205",
        "count" : "69338"
      }, {
        "item" : "43148",
        "count" : "65864"
      }, {
        "item" : "08266",
        "count" : "64772"
      }, {
        "item" : "25120",
        "count" : "62992"
      }, {
        "item" : "17079",
        "count" : "59493"
      }, {
        "item" : "08121",
        "count" : "55737"
      }, {
        "item" : "43123",
        "count" : "43033"
      }, {
        "item" : "08307",
        "count" : "40359"
      }, {
        "item" : "08245",
        "count" : "38717"
      }, {
        "item" : "08200",
        "count" : "37280"
      }, {
        "item" : "08301",
        "count" : "37034"
      }, {
        "item" : "08113",
        "count" : "36064"
      }, {
        "item" : "08073",
        "count" : "35195"
      }, {
        "item" : "08184",
        "count" : "34412"
      }, {
        "item" : "43905",
        "count" : "34228"
      } ],
      "smallest" : "08001",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921400,
    "name" : "NOM_COMARCA",
    "dataTypeName" : "text",
    "description" : "Comarca (d’acord amb la taula de comarques de Catalunya i de l’entitat territorial singular de l’Aran de l’Idescat) ",
    "fieldName" : "nom_comarca",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 13874348,
    "cachedContents" : {
      "non_null" : "4072657",
      "largest" : "Vall�s Oriental",
      "null" : "2",
      "top" : [ {
        "item" : "Barcelonès",
        "count" : "1232484"
      }, {
        "item" : "Vallès Occidental",
        "count" : "502029"
      }, {
        "item" : "Baix Llobregat",
        "count" : "399897"
      }, {
        "item" : "Maresme",
        "count" : "226446"
      }, {
        "item" : "Vallès Oriental",
        "count" : "201824"
      }, {
        "item" : "Tarragonès",
        "count" : "166595"
      }, {
        "item" : "Garraf",
        "count" : "114426"
      }, {
        "item" : "Baix Camp",
        "count" : "110764"
      }, {
        "item" : "Alt Empordà",
        "count" : "110668"
      }, {
        "item" : "Baix Empordà",
        "count" : "106239"
      }, {
        "item" : "Gironès",
        "count" : "99736"
      }, {
        "item" : "Selva",
        "count" : "95581"
      }, {
        "item" : "Segrià",
        "count" : "89032"
      }, {
        "item" : "Baix Penedès",
        "count" : "81535"
      }, {
        "item" : "Bages",
        "count" : "80872"
      }, {
        "item" : "Osona",
        "count" : "63291"
      }, {
        "item" : "Anoia",
        "count" : "53878"
      }, {
        "item" : "Alt Penedès",
        "count" : "51593"
      }, {
        "item" : "Baix Ebre",
        "count" : "37221"
      }, {
        "item" : "Montsià",
        "count" : "27966"
      } ],
      "smallest" : "Alta Ribagor?a",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921408,
    "name" : "CODI_COMARCA",
    "dataTypeName" : "text",
    "description" : "Codi de la comarca (d’acord amb la taula de comarques de Catalunya i de l’entitat territorial singular de l’Aran de l’Idescat) ",
    "fieldName" : "codi_comarca",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 13874356,
    "cachedContents" : {
      "non_null" : "4072645",
      "largest" : "43",
      "null" : "14",
      "top" : [ {
        "item" : "13",
        "count" : "1233951"
      }, {
        "item" : "40",
        "count" : "502656"
      }, {
        "item" : "11",
        "count" : "399903"
      }, {
        "item" : "21",
        "count" : "226441"
      }, {
        "item" : "41",
        "count" : "202052"
      }, {
        "item" : "36",
        "count" : "166772"
      }, {
        "item" : "17",
        "count" : "114418"
      }, {
        "item" : "02",
        "count" : "110807"
      }, {
        "item" : "08",
        "count" : "110761"
      }, {
        "item" : "10",
        "count" : "106386"
      }, {
        "item" : "20",
        "count" : "99877"
      }, {
        "item" : "34",
        "count" : "95578"
      }, {
        "item" : "33",
        "count" : "89511"
      }, {
        "item" : "12",
        "count" : "81756"
      }, {
        "item" : "07",
        "count" : "80864"
      }, {
        "item" : "24",
        "count" : "63287"
      }, {
        "item" : "06",
        "count" : "53877"
      }, {
        "item" : "03",
        "count" : "51662"
      }, {
        "item" : "09",
        "count" : "37223"
      }, {
        "item" : "22",
        "count" : "28267"
      } ],
      "smallest" : "01",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921419,
    "name" : "NOM_PROVINCIA",
    "dataTypeName" : "text",
    "description" : "Província (d’acord amb la taula de províncies de l’INE)",
    "fieldName" : "nom_provincia",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 13874367,
    "cachedContents" : {
      "non_null" : "4072657",
      "largest" : "Tarragona",
      "null" : "2",
      "top" : [ {
        "item" : "Barcelona",
        "count" : "2950839"
      }, {
        "item" : "Girona",
        "count" : "476701"
      }, {
        "item" : "Tarragona",
        "count" : "463213"
      }, {
        "item" : "Lleida",
        "count" : "181904"
      } ],
      "smallest" : "Barcelona",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921423,
    "name" : "CODI_PROVINCIA",
    "dataTypeName" : "text",
    "description" : "Codi de la província (d’acord amb la taula de províncies de l’INE)",
    "fieldName" : "codi_provincia",
    "position" : 12,
    "renderTypeName" : "text",
    "tableColumnId" : 13874371,
    "cachedContents" : {
      "non_null" : "4072657",
      "largest" : "43",
      "null" : "2",
      "top" : [ {
        "item" : "08",
        "count" : "2950814"
      }, {
        "item" : "17",
        "count" : "476715"
      }, {
        "item" : "43",
        "count" : "463222"
      }, {
        "item" : "25",
        "count" : "181906"
      } ],
      "smallest" : "08",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921397,
    "name" : "IT_GEN_NOM",
    "dataTypeName" : "text",
    "description" : "Nom de la instal·lació",
    "fieldName" : "it_gen_nom",
    "position" : 13,
    "renderTypeName" : "text",
    "tableColumnId" : 13874345,
    "cachedContents" : {
      "non_null" : "4051250",
      "largest" : "ZZCC - (2x) HITECSA modelo AXCBZ-442",
      "null" : "21409",
      "top" : [ {
        "item" : "Calefacción y ACS",
        "count" : "669243"
      }, {
        "item" : "Equipo ACS",
        "count" : "461305"
      }, {
        "item" : "Calefacción y refrigeración",
        "count" : "436452"
      }, {
        "item" : "Calefacció i ACS",
        "count" : "156726"
      }, {
        "item" : "Sólo refrigeración",
        "count" : "92216"
      }, {
        "item" : "Equip ACS",
        "count" : "84818"
      }, {
        "item" : "Calefacció i Refrigeració",
        "count" : "76859"
      }, {
        "item" : "Sólo calefacción",
        "count" : "60740"
      }, {
        "item" : "Sistema de sustitución",
        "count" : "38331"
      }, {
        "item" : "Equipo Generacion ACS",
        "count" : "24121"
      }, {
        "item" : "Calefacción,  refrigeración y ACS",
        "count" : "22563"
      }, {
        "item" : "ACS",
        "count" : "18575"
      }, {
        "item" : "Sistema primario ACS",
        "count" : "16305"
      }, {
        "item" : "Només refrigeració",
        "count" : "14653"
      }, {
        "item" : "Només calefacció",
        "count" : "14566"
      }, {
        "item" : "Caldera - 1",
        "count" : "14330"
      }, {
        "item" : "SISTEMA_SUSTITUCION-Ficticio",
        "count" : "13130"
      }, {
        "item" : "CALDERA",
        "count" : "11524"
      }, {
        "item" : "Bomba de calor",
        "count" : "10676"
      }, {
        "item" : "Caldera",
        "count" : "10668"
      } ],
      "smallest" : "--",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921413,
    "name" : "IT_GEN_TIPUS",
    "dataTypeName" : "text",
    "description" : "Tipus de la instal·lacio (caldera estándar, bomba de calor,...)",
    "fieldName" : "it_gen_tipus",
    "position" : 14,
    "renderTypeName" : "text",
    "tableColumnId" : 13874361,
    "cachedContents" : {
      "non_null" : "4050102",
      "largest" : "ZRUN060GSS0+ARNH30GK1A4",
      "null" : "22557",
      "top" : [ {
        "item" : "Caldera Estándar",
        "count" : "1378579"
      }, {
        "item" : "Bomba de Calor",
        "count" : "988360"
      }, {
        "item" : "Efecto Joule",
        "count" : "449555"
      }, {
        "item" : "Caldera Condensación",
        "count" : "218213"
      }, {
        "item" : "Maquina frigorífica",
        "count" : "189178"
      }, {
        "item" : "Bomba de Calor - Caudal Ref. Variable",
        "count" : "185826"
      }, {
        "item" : "Sistema de rendimiento estacional constante",
        "count" : "51739"
      }, {
        "item" : "Compresor eléctrico",
        "count" : "40010"
      }, {
        "item" : "Bomba de calor",
        "count" : "35502"
      }, {
        "item" : "Expansión directa aire-aire bomba de calor",
        "count" : "35322"
      }, {
        "item" : "Rendimiento Constante",
        "count" : "31443"
      }, {
        "item" : "Combustion",
        "count" : "29250"
      }, {
        "item" : "Expansión directa bomba de calor aire-agua",
        "count" : "27543"
      }, {
        "item" : "Caldera eléctrica o de combustible",
        "count" : "25588"
      }, {
        "item" : "Equipo de Rendimiento Constante",
        "count" : "24840"
      }, {
        "item" : "Combustible",
        "count" : "23387"
      }, {
        "item" : "Rendimiento constante",
        "count" : "20816"
      }, {
        "item" : "Máquina frigorífica - Caudal Ref. Variable",
        "count" : "20798"
      }, {
        "item" : "Condensación",
        "count" : "16758"
      }, {
        "item" : "Unidad exterior en expansión directa",
        "count" : "15702"
      } ],
      "smallest" : "-",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921391,
    "name" : "IT_GEN_CATEGORIA",
    "dataTypeName" : "text",
    "description" : "Categoria de la instal·lació (calefacció, refrigeració, ACS)",
    "fieldName" : "it_gen_categoria",
    "position" : 15,
    "renderTypeName" : "text",
    "tableColumnId" : 13874339,
    "cachedContents" : {
      "non_null" : "4051286",
      "largest" : "InstalacionesACS",
      "null" : "21373",
      "top" : [ {
        "item" : "GeneradoresDeCalefaccion",
        "count" : "1542937"
      }, {
        "item" : "InstalacionesACS",
        "count" : "1513835"
      }, {
        "item" : "GeneradoresDeRefrigeracion",
        "count" : "994514"
      } ],
      "smallest" : "GeneradoresDeCalefaccion",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921389,
    "name" : "IT_GEN_MODE_OBTECIO",
    "dataTypeName" : "text",
    "description" : "Mode d’obtenció de la inforamció (usuari, valors estimats)",
    "fieldName" : "it_gen_mode_obtecio",
    "position" : 16,
    "renderTypeName" : "text",
    "tableColumnId" : 13874337,
    "cachedContents" : {
      "non_null" : "4051286",
      "largest" : "Usuario",
      "null" : "21373",
      "top" : [ {
        "item" : "Estimado",
        "count" : "3308717"
      }, {
        "item" : "Usuario",
        "count" : "685219"
      }, {
        "item" : "PorDefecto",
        "count" : "57350"
      } ],
      "smallest" : "Estimado",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921412,
    "name" : "IT_GEN_POTENCIA_NOMINAL",
    "dataTypeName" : "text",
    "description" : "Potència nominal de la instal·lació [kW]",
    "fieldName" : "it_gen_potencia_nominal",
    "position" : 17,
    "renderTypeName" : "text",
    "tableColumnId" : 13874360,
    "cachedContents" : {
      "non_null" : "4051286",
      "largest" : "9999999999.99",
      "null" : "21373",
      "top" : [ {
        "item" : "99999999.99",
        "count" : "2119346"
      }, {
        "item" : "24.00",
        "count" : "1225364"
      }, {
        "item" : "20.00",
        "count" : "20996"
      }, {
        "item" : "25.00",
        "count" : "20405"
      }, {
        "item" : "0.00",
        "count" : "20299"
      }, {
        "item" : "28.00",
        "count" : "20043"
      }, {
        "item" : "30.00",
        "count" : "18719"
      }, {
        "item" : "8.00",
        "count" : "16432"
      }, {
        "item" : "10.00",
        "count" : "12304"
      }, {
        "item" : "19.20",
        "count" : "12112"
      }, {
        "item" : "7.10",
        "count" : "12042"
      }, {
        "item" : "12.00",
        "count" : "11903"
      }, {
        "item" : "5.00",
        "count" : "11769"
      }, {
        "item" : "9.00",
        "count" : "9436"
      }, {
        "item" : "2.00",
        "count" : "8912"
      }, {
        "item" : "11.00",
        "count" : "8076"
      }, {
        "item" : "22.00",
        "count" : "7960"
      }, {
        "item" : "7.00",
        "count" : "7901"
      }, {
        "item" : "18.00",
        "count" : "7618"
      }, {
        "item" : "19.00",
        "count" : "7155"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921392,
    "name" : "IT_GEN_RENDIM_NOMINAL",
    "dataTypeName" : "text",
    "description" : "Rendiment nominal de la instal·lació",
    "fieldName" : "it_gen_rendim_nominal",
    "position" : 18,
    "renderTypeName" : "text",
    "tableColumnId" : 13874340,
    "cachedContents" : {
      "non_null" : "4051286",
      "largest" : "99999999.99",
      "null" : "21373",
      "top" : [ {
        "item" : "99999999.99",
        "count" : "1776000"
      }, {
        "item" : "1.00",
        "count" : "497869"
      }, {
        "item" : "2.00",
        "count" : "335284"
      }, {
        "item" : "2.20",
        "count" : "198923"
      }, {
        "item" : "2.50",
        "count" : "178726"
      }, {
        "item" : "2.70",
        "count" : "141301"
      }, {
        "item" : "1.80",
        "count" : "63124"
      }, {
        "item" : "0.00",
        "count" : "45285"
      }, {
        "item" : "0.92",
        "count" : "36230"
      }, {
        "item" : "3.00",
        "count" : "21843"
      }, {
        "item" : "0.95",
        "count" : "21165"
      }, {
        "item" : "0.90",
        "count" : "18067"
      }, {
        "item" : "3.50",
        "count" : "17586"
      }, {
        "item" : "0.98",
        "count" : "17174"
      }, {
        "item" : "0.85",
        "count" : "14911"
      }, {
        "item" : "3.20",
        "count" : "13628"
      }, {
        "item" : "1.50",
        "count" : "13160"
      }, {
        "item" : "4.00",
        "count" : "10902"
      }, {
        "item" : "3.30",
        "count" : "9753"
      }, {
        "item" : "2.80",
        "count" : "9475"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921395,
    "name" : "IT_GEN_RENDIM_ESTACIO",
    "dataTypeName" : "text",
    "description" : "Rendiment estacinal de la instal·lació",
    "fieldName" : "it_gen_rendim_estacio",
    "position" : 19,
    "renderTypeName" : "text",
    "tableColumnId" : 13874343,
    "cachedContents" : {
      "non_null" : "4051263",
      "largest" : "99999999.99",
      "null" : "21396",
      "top" : [ {
        "item" : "0.77",
        "count" : "501037"
      }, {
        "item" : "1.00",
        "count" : "480303"
      }, {
        "item" : "0.62",
        "count" : "196026"
      }, {
        "item" : "0.66",
        "count" : "183979"
      }, {
        "item" : "1.38",
        "count" : "155126"
      }, {
        "item" : "0.83",
        "count" : "121273"
      }, {
        "item" : "1.44",
        "count" : "102660"
      }, {
        "item" : "1.72",
        "count" : "98717"
      }, {
        "item" : "1.76",
        "count" : "86270"
      }, {
        "item" : "77.20",
        "count" : "66153"
      }, {
        "item" : "100.00",
        "count" : "50483"
      }, {
        "item" : "99999999.99",
        "count" : "41590"
      }, {
        "item" : "1.24",
        "count" : "37274"
      }, {
        "item" : "0.78",
        "count" : "33317"
      }, {
        "item" : "0.55",
        "count" : "28145"
      }, {
        "item" : "1.21",
        "count" : "24915"
      }, {
        "item" : "61.80",
        "count" : "24788"
      }, {
        "item" : "0.00",
        "count" : "24592"
      }, {
        "item" : "1.31",
        "count" : "24049"
      }, {
        "item" : "66.00",
        "count" : "22657"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921401,
    "name" : "IT_GEN_VECTOR_ENERGETICO",
    "dataTypeName" : "text",
    "description" : "Combustible de la instal·lació (gas natural, electricitat,...)",
    "fieldName" : "it_gen_vector_energetico",
    "position" : 20,
    "renderTypeName" : "text",
    "tableColumnId" : 13874349,
    "cachedContents" : {
      "non_null" : "4051284",
      "largest" : "GLP",
      "null" : "21375",
      "top" : [ {
        "item" : "ElectricidadPeninsular",
        "count" : "2343459"
      }, {
        "item" : "GasNatural",
        "count" : "1450258"
      }, {
        "item" : "GasoleoC",
        "count" : "134067"
      }, {
        "item" : "GLP",
        "count" : "74462"
      }, {
        "item" : "BiomasaOtros",
        "count" : "33766"
      }, {
        "item" : "BiomasaPellet",
        "count" : "11214"
      }, {
        "item" : "Biocarburante",
        "count" : "1694"
      }, {
        "item" : "Biomasa",
        "count" : "916"
      }, {
        "item" : "BiomasaÍdensificada",
        "count" : "840"
      }, {
        "item" : "Carbon",
        "count" : "553"
      }, {
        "item" : "Fuel-oil",
        "count" : "32"
      }, {
        "item" : "ElectricidadBaleares",
        "count" : "15"
      }, {
        "item" : "ElectricidadPeninsula",
        "count" : "6"
      }, {
        "item" : "ElectricidadCanarias",
        "count" : "2"
      } ],
      "smallest" : "Biocarburante",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921411,
    "name" : "IT_SS_NOM",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: nom de la instal·lació",
    "fieldName" : "it_ss_nom",
    "position" : 21,
    "renderTypeName" : "text",
    "tableColumnId" : 13874359,
    "cachedContents" : {
      "non_null" : "267265",
      "largest" : "ZR1",
      "null" : "3805394",
      "top" : [ {
        "item" : "Sistema de sustitucion",
        "count" : "6286"
      }, {
        "item" : "REC",
        "count" : "960"
      }, {
        "item" : "Subsistema secundario 4",
        "count" : "617"
      }, {
        "item" : "Subsistema secundario 5",
        "count" : "616"
      }, {
        "item" : "Subsistema secundario 2",
        "count" : "616"
      }, {
        "item" : "Subsistema secundario 3",
        "count" : "616"
      }, {
        "item" : "Subsistema secundario 1",
        "count" : "616"
      }, {
        "item" : "1",
        "count" : "611"
      }, {
        "item" : "Recuperador calor",
        "count" : "575"
      }, {
        "item" : "FC_P05_E04",
        "count" : "484"
      }, {
        "item" : "CL2",
        "count" : "481"
      }, {
        "item" : "FC_P04_E03",
        "count" : "466"
      }, {
        "item" : "FC_P04_E04",
        "count" : "450"
      }, {
        "item" : "CL1",
        "count" : "430"
      }, {
        "item" : "CLAP-01",
        "count" : "403"
      }, {
        "item" : "CL10",
        "count" : "402"
      }, {
        "item" : "P2_2_Heating_PURY_M250YNW_A1 - P2_2_Cooling_PURY_P250YNW_A1 - Planta-2.2_PEFY - Thermal Zone: P2_OFFICINAS2 - FCU",
        "count" : "396"
      }, {
        "item" : "P4 - Thermal Zone: P4_OFFICINAS2 - Air Terminal",
        "count" : "396"
      }, {
        "item" : "P5_1_Heating_PURY_P250YNW_A1 - P5_1_Cooling_PURY_P250YNW_A1 - Planta-5.3_PEFY - Thermal Zone: P5_PASILLO - FCU",
        "count" : "396"
      }, {
        "item" : "P3_2_Cooling_PURY_P250YNW_A1 - P3_2_Cooling_PURY_P250YNW_A1 - Planta-3.2_PEFY - Thermal Zone: P3_OFFICINAS2 - FCU",
        "count" : "396"
      } ],
      "smallest" : "-",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921399,
    "name" : "IT_SS_TIPUS",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: tipus de la instal·lació (ventilació, calefacció per aigua, climatització d’aire primari,...)",
    "fieldName" : "it_ss_tipus",
    "position" : 22,
    "renderTypeName" : "text",
    "tableColumnId" : 13874347,
    "cachedContents" : {
      "non_null" : "267265",
      "largest" : "Ventiloconvectores (Fan-coil)",
      "null" : "3805394",
      "top" : [ {
        "item" : "Ventiloconvectores (Fan-coil)",
        "count" : "68216"
      }, {
        "item" : "Recuperador de calor",
        "count" : "28923"
      }, {
        "item" : "Todo aire caudal variable",
        "count" : "25185"
      }, {
        "item" : "OpenStudio::Model::AirTerminalSingleDuctConstantVolumeNoReheat",
        "count" : "21604"
      }, {
        "item" : "OpenStudio::Model::ZoneHVACFourPipeFanCoil",
        "count" : "19625"
      }, {
        "item" : "Todo aire caudal constante",
        "count" : "12472"
      }, {
        "item" : "Sólo calefacción por agua",
        "count" : "12347"
      }, {
        "item" : "OpenStudio::Model::ZoneHVACBaseboardConvectiveWater",
        "count" : "9510"
      }, {
        "item" : "OpenStudio::Model::ZoneHVACPackagedTerminalHeatPump",
        "count" : "9207"
      }, {
        "item" : "OpenStudio::Model::ZoneHVACTerminalUnitVariableRefrigerantFlow",
        "count" : "7964"
      }, {
        "item" : "Climatitzador d'aire primari",
        "count" : "7212"
      }, {
        "item" : "Sistema de sustitucion",
        "count" : "6286"
      }, {
        "item" : "Climatizadora de aire primario",
        "count" : "6058"
      }, {
        "item" : "Aut. mediante unidades terminales",
        "count" : "5225"
      }, {
        "item" : "Termoventilación",
        "count" : "4950"
      }, {
        "item" : "Climatizador de aire primario",
        "count" : "4942"
      }, {
        "item" : "Unitat climatitzadora, sistema tot aire de cabal constant",
        "count" : "2721"
      }, {
        "item" : "Sistema de caudal de aire constante",
        "count" : "2021"
      }, {
        "item" : "Unidad climatizadora, sistema todo aire de caudal constante",
        "count" : "1558"
      }, {
        "item" : "Sólo ventilación",
        "count" : "1475"
      } ],
      "smallest" : "-",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921422,
    "name" : "IT_SS_ENFRIAM_EVAPOR",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: disposa d’enfriament evaporatiu",
    "fieldName" : "it_ss_enfriam_evapor",
    "position" : 23,
    "renderTypeName" : "text",
    "tableColumnId" : 13874370,
    "cachedContents" : {
      "non_null" : "222135",
      "largest" : "No",
      "null" : "3850524",
      "top" : [ {
        "item" : "No",
        "count" : "222135"
      } ],
      "smallest" : "No",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921418,
    "name" : "IT_SS_ENFRIAM_GRATUIT",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: disposa d’enfriament gratuït",
    "fieldName" : "it_ss_enfriam_gratuit",
    "position" : 24,
    "renderTypeName" : "text",
    "tableColumnId" : 13874366,
    "cachedContents" : {
      "non_null" : "222135",
      "largest" : "Si",
      "null" : "3850524",
      "top" : [ {
        "item" : "No",
        "count" : "193792"
      }, {
        "item" : "Si",
        "count" : "28343"
      } ],
      "smallest" : "No",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921390,
    "name" : "IT_SS_POTENCIA_CALOR",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: potència calefacció",
    "fieldName" : "it_ss_potencia_calor",
    "position" : 25,
    "renderTypeName" : "text",
    "tableColumnId" : 13874338,
    "cachedContents" : {
      "non_null" : "209015",
      "largest" : "99999999.99",
      "null" : "3863644",
      "top" : [ {
        "item" : "0.00",
        "count" : "112799"
      }, {
        "item" : "99999999.99",
        "count" : "16516"
      }, {
        "item" : "8.00",
        "count" : "8439"
      }, {
        "item" : "3.20",
        "count" : "3260"
      }, {
        "item" : "10.80",
        "count" : "3047"
      }, {
        "item" : "-77777.00",
        "count" : "1415"
      }, {
        "item" : "2.50",
        "count" : "1377"
      }, {
        "item" : "0.70",
        "count" : "884"
      }, {
        "item" : "1.98",
        "count" : "648"
      }, {
        "item" : "22.00",
        "count" : "565"
      }, {
        "item" : "20.00",
        "count" : "453"
      }, {
        "item" : "2.83",
        "count" : "432"
      }, {
        "item" : "4.81",
        "count" : "432"
      }, {
        "item" : "8.96",
        "count" : "432"
      }, {
        "item" : "9.66",
        "count" : "432"
      }, {
        "item" : "12.32",
        "count" : "420"
      }, {
        "item" : "36.00",
        "count" : "395"
      }, {
        "item" : "1.54",
        "count" : "378"
      }, {
        "item" : "1.70",
        "count" : "352"
      }, {
        "item" : "29.00",
        "count" : "330"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921394,
    "name" : "IT_SS_RENDIM_CALOR",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: rendiment nominal de calefacció",
    "fieldName" : "it_ss_rendim_calor",
    "position" : 26,
    "renderTypeName" : "text",
    "tableColumnId" : 13874342,
    "cachedContents" : {
      "non_null" : "206111",
      "largest" : "7.50",
      "null" : "3866548",
      "top" : [ {
        "item" : "0.00",
        "count" : "175148"
      }, {
        "item" : "300.00",
        "count" : "6843"
      }, {
        "item" : "2.80",
        "count" : "1979"
      }, {
        "item" : "4.25",
        "count" : "1923"
      }, {
        "item" : "4.42",
        "count" : "1030"
      }, {
        "item" : "4.82",
        "count" : "852"
      }, {
        "item" : "4.55",
        "count" : "778"
      }, {
        "item" : "4.77",
        "count" : "604"
      }, {
        "item" : "3.84",
        "count" : "559"
      }, {
        "item" : "3.20",
        "count" : "553"
      }, {
        "item" : "2.43",
        "count" : "495"
      }, {
        "item" : "3.73",
        "count" : "484"
      }, {
        "item" : "3.00",
        "count" : "482"
      }, {
        "item" : "3.05",
        "count" : "468"
      }, {
        "item" : "4.00",
        "count" : "417"
      }, {
        "item" : "3.93",
        "count" : "416"
      }, {
        "item" : "3.50",
        "count" : "412"
      }, {
        "item" : "4.10",
        "count" : "407"
      }, {
        "item" : "379.00",
        "count" : "396"
      }, {
        "item" : "4.85",
        "count" : "385"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921396,
    "name" : "IT_SS_RENDIM_ESTACIO_CALOR",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: rendiment estacional de calefacció",
    "fieldName" : "it_ss_rendim_estacio_calor",
    "position" : 27,
    "renderTypeName" : "text",
    "tableColumnId" : 13874344,
    "cachedContents" : {
      "non_null" : "190081",
      "largest" : "9.71",
      "null" : "3882578",
      "top" : [ {
        "item" : "0.00",
        "count" : "41172"
      }, {
        "item" : "0.55",
        "count" : "13824"
      }, {
        "item" : "0.54",
        "count" : "6144"
      }, {
        "item" : "1.76",
        "count" : "4423"
      }, {
        "item" : "1.16",
        "count" : "3356"
      }, {
        "item" : "2.09",
        "count" : "3124"
      }, {
        "item" : "3.19",
        "count" : "3060"
      }, {
        "item" : "2.66",
        "count" : "2856"
      }, {
        "item" : "0.59",
        "count" : "2821"
      }, {
        "item" : "0.45",
        "count" : "2637"
      }, {
        "item" : "1.92",
        "count" : "2164"
      }, {
        "item" : "0.21",
        "count" : "2016"
      }, {
        "item" : "1.19",
        "count" : "2000"
      }, {
        "item" : "6.98",
        "count" : "1984"
      }, {
        "item" : "0.10",
        "count" : "1858"
      }, {
        "item" : "0.76",
        "count" : "1810"
      }, {
        "item" : "3.42",
        "count" : "1770"
      }, {
        "item" : "0.17",
        "count" : "1760"
      }, {
        "item" : "0.52",
        "count" : "1734"
      }, {
        "item" : "0.11",
        "count" : "1694"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921414,
    "name" : "IT_SS_POTENCIA_FRIO",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: potència de refrigeració",
    "fieldName" : "it_ss_potencia_frio",
    "position" : 28,
    "renderTypeName" : "text",
    "tableColumnId" : 13874362,
    "cachedContents" : {
      "non_null" : "198179",
      "largest" : "99999999.99",
      "null" : "3874480",
      "top" : [ {
        "item" : "0.00",
        "count" : "116869"
      }, {
        "item" : "99999999.99",
        "count" : "15852"
      }, {
        "item" : "2.80",
        "count" : "3204"
      }, {
        "item" : "12.90",
        "count" : "3128"
      }, {
        "item" : "2.20",
        "count" : "1360"
      }, {
        "item" : "0.91",
        "count" : "864"
      }, {
        "item" : "0.01",
        "count" : "800"
      }, {
        "item" : "3.28",
        "count" : "660"
      }, {
        "item" : "120.00",
        "count" : "615"
      }, {
        "item" : "7.00",
        "count" : "604"
      }, {
        "item" : "7.10",
        "count" : "558"
      }, {
        "item" : "0.10",
        "count" : "483"
      }, {
        "item" : "4.26",
        "count" : "438"
      }, {
        "item" : "13.52",
        "count" : "432"
      }, {
        "item" : "7.54",
        "count" : "432"
      }, {
        "item" : "14.43",
        "count" : "432"
      }, {
        "item" : "16.28",
        "count" : "420"
      }, {
        "item" : "45.00",
        "count" : "418"
      }, {
        "item" : "70.00",
        "count" : "348"
      }, {
        "item" : "46.00",
        "count" : "339"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921410,
    "name" : "IT_SS_RENDIM_FRIO",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: rendiment nominal de refrigeració",
    "fieldName" : "it_ss_rendim_frio",
    "position" : 29,
    "renderTypeName" : "text",
    "tableColumnId" : 13874358,
    "cachedContents" : {
      "non_null" : "206052",
      "largest" : "7.50",
      "null" : "3866607",
      "top" : [ {
        "item" : "0.00",
        "count" : "176824"
      }, {
        "item" : "300.00",
        "count" : "6842"
      }, {
        "item" : "3.63",
        "count" : "1901"
      }, {
        "item" : "4.04",
        "count" : "1036"
      }, {
        "item" : "4.10",
        "count" : "931"
      }, {
        "item" : "3.22",
        "count" : "906"
      }, {
        "item" : "4.50",
        "count" : "732"
      }, {
        "item" : "2.95",
        "count" : "675"
      }, {
        "item" : "3.00",
        "count" : "625"
      }, {
        "item" : "3.53",
        "count" : "609"
      }, {
        "item" : "2.70",
        "count" : "585"
      }, {
        "item" : "4.27",
        "count" : "464"
      }, {
        "item" : "2.91",
        "count" : "412"
      }, {
        "item" : "355.00",
        "count" : "396"
      }, {
        "item" : "3.49",
        "count" : "394"
      }, {
        "item" : "5.52",
        "count" : "385"
      }, {
        "item" : "3.23",
        "count" : "384"
      }, {
        "item" : "3.40",
        "count" : "330"
      }, {
        "item" : "333.00",
        "count" : "329"
      }, {
        "item" : "3.50",
        "count" : "321"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921405,
    "name" : "IT_SS_RENDIM_ESTACIO_FRIO",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: rendiment estacional de refrigeració",
    "fieldName" : "it_ss_rendim_estacio_frio",
    "position" : 30,
    "renderTypeName" : "text",
    "tableColumnId" : 13874353,
    "cachedContents" : {
      "non_null" : "190081",
      "largest" : "9.71",
      "null" : "3882578",
      "top" : [ {
        "item" : "0.00",
        "count" : "41470"
      }, {
        "item" : "0.55",
        "count" : "13824"
      }, {
        "item" : "0.54",
        "count" : "6144"
      }, {
        "item" : "1.76",
        "count" : "4347"
      }, {
        "item" : "1.16",
        "count" : "3334"
      }, {
        "item" : "3.19",
        "count" : "3149"
      }, {
        "item" : "2.09",
        "count" : "3124"
      }, {
        "item" : "2.66",
        "count" : "2864"
      }, {
        "item" : "0.59",
        "count" : "2821"
      }, {
        "item" : "0.45",
        "count" : "2637"
      }, {
        "item" : "1.92",
        "count" : "2157"
      }, {
        "item" : "0.21",
        "count" : "2016"
      }, {
        "item" : "1.19",
        "count" : "2000"
      }, {
        "item" : "6.98",
        "count" : "1984"
      }, {
        "item" : "0.10",
        "count" : "1858"
      }, {
        "item" : "0.76",
        "count" : "1810"
      }, {
        "item" : "3.42",
        "count" : "1770"
      }, {
        "item" : "0.17",
        "count" : "1760"
      }, {
        "item" : "0.52",
        "count" : "1722"
      }, {
        "item" : "0.53",
        "count" : "1687"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921406,
    "name" : "IT_SS_RECUPERA_ENERGIA",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: disposa de recuperador d’energia",
    "fieldName" : "it_ss_recupera_energia",
    "position" : 31,
    "renderTypeName" : "text",
    "tableColumnId" : 13874354,
    "cachedContents" : {
      "non_null" : "222135",
      "largest" : "Si",
      "null" : "3850524",
      "top" : [ {
        "item" : "No",
        "count" : "168716"
      }, {
        "item" : "Si",
        "count" : "53419"
      } ],
      "smallest" : "No",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921417,
    "name" : "IT_SS_TIPO_CONTROL",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: tipus de control (per temperatura, per entalpia)",
    "fieldName" : "it_ss_tipo_control",
    "position" : 32,
    "renderTypeName" : "text",
    "tableColumnId" : 13874365,
    "cachedContents" : {
      "non_null" : "88",
      "largest" : "No",
      "null" : "4072571",
      "top" : [ {
        "item" : "No",
        "count" : "88"
      } ],
      "smallest" : "No",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921402,
    "name" : "IT_SS_ZONES_ASOCIADES",
    "dataTypeName" : "text",
    "description" : "Sistemes secundaris: zones asociades",
    "fieldName" : "it_ss_zones_asociades",
    "position" : 33,
    "renderTypeName" : "text",
    "tableColumnId" : 13874350,
    "cachedContents" : {
      "non_null" : "252566",
      "largest" : "ZZCC, ZZCC P2aP6, ZONA HABITACIONES",
      "null" : "3820093",
      "top" : [ {
        "item" : "Z_P03_E03",
        "count" : "1130"
      }, {
        "item" : "Z_P03_E01",
        "count" : "1025"
      }, {
        "item" : "Z_P03_E04",
        "count" : "1001"
      }, {
        "item" : "Z_P04_E06",
        "count" : "951"
      }, {
        "item" : "Z_P02_E03",
        "count" : "949"
      }, {
        "item" : "Z_P04_E01",
        "count" : "893"
      }, {
        "item" : "Z_P05_E02",
        "count" : "879"
      }, {
        "item" : "Z_P04_E03",
        "count" : "865"
      }, {
        "item" : "Z_P02_E07",
        "count" : "832"
      }, {
        "item" : "Z_P05_E01",
        "count" : "830"
      }, {
        "item" : "Thermal Zone: P5_OFFICINAS1",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P3_OFFICINAS2",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P4_OFFICINAS2",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P5_PASILLO",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P6_OFFICINAS1",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P5_OFFICINAS2",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P4_PASILLO",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P2_OFFICINAS2",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P6_OFFICINAS2",
        "count" : "792"
      }, {
        "item" : "Thermal Zone: P2_OFFICINAS1",
        "count" : "792"
      } ],
      "smallest" : "-",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921393,
    "name" : "IT_ALT_NOM",
    "dataTypeName" : "text",
    "description" : "Altres sistemes: nom de la instal·lació",
    "fieldName" : "it_alt_nom",
    "position" : 34,
    "renderTypeName" : "text",
    "tableColumnId" : 13874341,
    "cachedContents" : {
      "non_null" : "521323",
      "largest" : "Zona Nova - B7 (x1)",
      "null" : "3551336",
      "top" : [ {
        "item" : "Ventiladores",
        "count" : "34917"
      }, {
        "item" : "Ventiladors",
        "count" : "7475"
      }, {
        "item" : "Bombas",
        "count" : "6656"
      }, {
        "item" : "BF-01",
        "count" : "3197"
      }, {
        "item" : "Bombes",
        "count" : "3128"
      }, {
        "item" : "BC-01",
        "count" : "3007"
      }, {
        "item" : "Bomba AF",
        "count" : "2952"
      }, {
        "item" : "Bomba ACS",
        "count" : "2185"
      }, {
        "item" : "Pump Variable Speed 1",
        "count" : "1932"
      }, {
        "item" : "BC",
        "count" : "1889"
      }, {
        "item" : "BF",
        "count" : "1756"
      }, {
        "item" : "Sistemes de condensació per aigua",
        "count" : "1734"
      }, {
        "item" : "Bomba AC",
        "count" : "1623"
      }, {
        "item" : "Fan Variable Volume 1",
        "count" : "1515"
      }, {
        "item" : "Pump Variable Speed 2",
        "count" : "1440"
      }, {
        "item" : "Bombeo ACS",
        "count" : "1375"
      }, {
        "item" : "Ventilador",
        "count" : "1079"
      }, {
        "item" : "Bombas ACS",
        "count" : "763"
      }, {
        "item" : "A_Izq - UTA - Air Loop Exhaust Fan",
        "count" : "741"
      }, {
        "item" : "A_Drch - UTA - Air Loop Exhaust Fan",
        "count" : "741"
      } ],
      "smallest" : "07. Fancoils TERMOVEN modelo FL-450 (173)",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921409,
    "name" : "IT_ALT_TIPUS",
    "dataTypeName" : "text",
    "description" : "Altres sistemes: tipus de la instal·lació (bombes, torre de refrigeració, ventilador,...)",
    "fieldName" : "it_alt_tipus",
    "position" : 35,
    "renderTypeName" : "text",
    "tableColumnId" : 13874357,
    "cachedContents" : {
      "non_null" : "521323",
      "largest" : "Ventilador/Recuperador de calor",
      "null" : "3551336",
      "top" : [ {
        "item" : "Bomba",
        "count" : "147832"
      }, {
        "item" : "Ventilador de caudal constante",
        "count" : "133526"
      }, {
        "item" : "Bomba de caudal constante",
        "count" : "89846"
      }, {
        "item" : "Ventilador",
        "count" : "44485"
      }, {
        "item" : "OpenStudio::Model::HVACComponent",
        "count" : "31469"
      }, {
        "item" : "Ventilador de varias velocidades",
        "count" : "31138"
      }, {
        "item" : "Bomba de varias velocidades",
        "count" : "17667"
      }, {
        "item" : "OpenStudio::Model::PumpVariableSpeed",
        "count" : "13054"
      }, {
        "item" : "OpenStudio::Model::PumpConstantSpeed",
        "count" : "3464"
      }, {
        "item" : "Ventilador/Recuperador de calor",
        "count" : "2439"
      }, {
        "item" : "Torres de refrigeració",
        "count" : "1734"
      }, {
        "item" : "Torre de refrigeración: velocidad variable",
        "count" : "1467"
      }, {
        "item" : "Torre de refrigeración: 1 velocidad",
        "count" : "1097"
      }, {
        "item" : "OpenStudio::Model::HVAC",
        "count" : "984"
      }, {
        "item" : "Torre circuito cerrado",
        "count" : "425"
      }, {
        "item" : "Torres de refrigeración",
        "count" : "360"
      }, {
        "item" : "Torre circuito abierto",
        "count" : "336"
      } ],
      "smallest" : "Bomba",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921420,
    "name" : "IT_ALT_CATEGORIA",
    "dataTypeName" : "text",
    "description" : "Altres sistemes: categoria de la instal·lació (ventilació i bombeig, torres i refrigeració)",
    "fieldName" : "it_alt_categoria",
    "position" : 36,
    "renderTypeName" : "text",
    "tableColumnId" : 13874368,
    "cachedContents" : {
      "non_null" : "521338",
      "largest" : "VentilacionyBombeo",
      "null" : "3551321",
      "top" : [ {
        "item" : "VentilacionyBombeo",
        "count" : "515919"
      }, {
        "item" : "TorresyRefrigeracion",
        "count" : "5419"
      } ],
      "smallest" : "TorresyRefrigeracion",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921424,
    "name" : "IT_ALT_SERVEI_ASOCIAT",
    "dataTypeName" : "text",
    "description" : "Altres sistemes: servei asociat (calefacció, refrigeració, ACS, ventilació, climatització)",
    "fieldName" : "it_alt_servei_asociat",
    "position" : 37,
    "renderTypeName" : "text",
    "tableColumnId" : 13874372,
    "cachedContents" : {
      "non_null" : "521323",
      "largest" : "Ventilación",
      "null" : "3551336",
      "top" : [ {
        "item" : "Calefacción",
        "count" : "142223"
      }, {
        "item" : "Calefaccion,Refrigeracion",
        "count" : "109302"
      }, {
        "item" : "Refrigeración",
        "count" : "104256"
      }, {
        "item" : "ACS",
        "count" : "30245"
      }, {
        "item" : "Climatización",
        "count" : "26168"
      }, {
        "item" : "Refrigeracion",
        "count" : "24291"
      }, {
        "item" : "Ventilacion",
        "count" : "21671"
      }, {
        "item" : "Calefaccion",
        "count" : "20125"
      }, {
        "item" : "Climatización, Ventilación",
        "count" : "15277"
      }, {
        "item" : "-",
        "count" : "10782"
      }, {
        "item" : "Climatització, Ventilació",
        "count" : "7342"
      }, {
        "item" : "Ventilación",
        "count" : "4655"
      }, {
        "item" : "Climatització",
        "count" : "3110"
      }, {
        "item" : "Refrigeració",
        "count" : "1734"
      }, {
        "item" : "Ventilació",
        "count" : "130"
      }, {
        "item" : "CalefacciC3n",
        "count" : "10"
      }, {
        "item" : "RefrigeraciC3n",
        "count" : "2"
      } ],
      "smallest" : "-",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "format" : { }
  }, {
    "id" : 20921403,
    "name" : "IT_ALT_CONSUM_ENERGIA",
    "dataTypeName" : "text",
    "description" : "Altres sistemes: consum d’energia [kWh]",
    "fieldName" : "it_alt_consum_energia",
    "position" : 38,
    "renderTypeName" : "text",
    "tableColumnId" : 13874351,
    "cachedContents" : {
      "non_null" : "521323",
      "largest" : "9998.90",
      "null" : "3551336",
      "top" : [ {
        "item" : "0.00",
        "count" : "33703"
      }, {
        "item" : "654.41",
        "count" : "8256"
      }, {
        "item" : "3168.00",
        "count" : "3973"
      }, {
        "item" : "16537.70",
        "count" : "3880"
      }, {
        "item" : "651.04",
        "count" : "3828"
      }, {
        "item" : "198.00",
        "count" : "2862"
      }, {
        "item" : "4040.73",
        "count" : "2380"
      }, {
        "item" : "6336.00",
        "count" : "2210"
      }, {
        "item" : "79.20",
        "count" : "2119"
      }, {
        "item" : "5940.00",
        "count" : "2113"
      }, {
        "item" : "7920.00",
        "count" : "1930"
      }, {
        "item" : "4752.00",
        "count" : "1821"
      }, {
        "item" : "165722.00",
        "count" : "1672"
      }, {
        "item" : "158.40",
        "count" : "1463"
      }, {
        "item" : "10560.00",
        "count" : "1447"
      }, {
        "item" : "27506.00",
        "count" : "1420"
      }, {
        "item" : "554.40",
        "count" : "1410"
      }, {
        "item" : "5808.00",
        "count" : "1212"
      }, {
        "item" : "1241.33",
        "count" : "1130"
      }, {
        "item" : "1407.72",
        "count" : "1120"
      } ],
      "smallest" : "0.00",
      "count" : "4072659",
      "cardinality" : "4072659"
    },
    "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ó" : "Setmanal"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Energy performance certificates (EPC): installations",
        "Nombre del conjunto de datos (ES)" : "Certificación de eficiencia energética de edificios: instalaciones"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Actors" : {
        "Departament" : "Territori, Habitatge i Transició Ecològica",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Codi 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" : [ "certificació", "energia", "eficiència", "estalvi", "qualificació", "emissions", "energia primària no renovable", "energia final", "transmitància", "fotovoltaica", "geotèrmica", "aerotèrmia", "solar tèrmica", "vehicle elèctric", "cte", "eina de certificació", "ods7_energia assequible i no contaminant" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}