{
  "id" : "8idm-becu",
  "name" : "Consum d’energia elèctrica per municipis i sectors de Catalunya",
  "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" : 1612523858,
  "description" : "Consum d’energia elèctrica per municipis i sectors d’activitat econòmica de tota Catalunya.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 6030,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 1976998,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1612524797,
  "publicationGroup" : 1339031,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1765992369,
  "rowsUpdatedBy" : "neh8-y96i",
  "tableId" : 1339031,
  "totalTimesRated" : 0,
  "viewCount" : 36599,
  "viewLastModified" : 1789638885,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1612773555,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 833477,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1612773555,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1612773555,
      "failureCount" : 0,
      "startedAt" : 1612773555,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 18305871,
    "name" : "Any",
    "dataTypeName" : "number",
    "description" : "Any del període de consum",
    "fieldName" : "any",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 12056919,
    "cachedContents" : {
      "non_null" : "54611",
      "largest" : "2024",
      "null" : "0",
      "top" : [ {
        "item" : "2024",
        "count" : "4700"
      }, {
        "item" : "2023",
        "count" : "4676"
      }, {
        "item" : "2022",
        "count" : "4633"
      }, {
        "item" : "2021",
        "count" : "4591"
      }, {
        "item" : "2020",
        "count" : "4543"
      }, {
        "item" : "2013",
        "count" : "4527"
      }, {
        "item" : "2015",
        "count" : "4508"
      }, {
        "item" : "2019",
        "count" : "4503"
      }, {
        "item" : "2014",
        "count" : "4497"
      }, {
        "item" : "2018",
        "count" : "4488"
      }, {
        "item" : "2016",
        "count" : "4473"
      }, {
        "item" : "2017",
        "count" : "4472"
      } ],
      "smallest" : "2013",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 18305876,
    "name" : "Provincia",
    "dataTypeName" : "text",
    "description" : "Província de Catalunya",
    "fieldName" : "provincia",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 12056924,
    "cachedContents" : {
      "non_null" : "54611",
      "largest" : "TARRAGONA",
      "null" : "0",
      "top" : [ {
        "item" : "BARCELONA",
        "count" : "18632"
      }, {
        "item" : "GIRONA",
        "count" : "12803"
      }, {
        "item" : "LLEIDA",
        "count" : "12638"
      }, {
        "item" : "TARRAGONA",
        "count" : "10538"
      } ],
      "smallest" : "BARCELONA",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : { }
  }, {
    "id" : 18305875,
    "name" : "Comarca",
    "dataTypeName" : "text",
    "description" : "Comarca de Catalunya",
    "fieldName" : "comarca",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 12056923,
    "cachedContents" : {
      "non_null" : "54611",
      "largest" : "VALLES ORIENTAL",
      "null" : "0",
      "top" : [ {
        "item" : "ALT EMPORDA",
        "count" : "3859"
      }, {
        "item" : "OSONA",
        "count" : "2872"
      }, {
        "item" : "VALLES ORIENTAL",
        "count" : "2377"
      }, {
        "item" : "SEGRIA",
        "count" : "2236"
      }, {
        "item" : "BAIX EMPORDA",
        "count" : "2084"
      }, {
        "item" : "ANOIA",
        "count" : "1943"
      }, {
        "item" : "BAIX LLOBREGAT",
        "count" : "1929"
      }, {
        "item" : "MARESME",
        "count" : "1883"
      }, {
        "item" : "BAGES",
        "count" : "1814"
      }, {
        "item" : "NOGUERA",
        "count" : "1643"
      }, {
        "item" : "ALT PENEDES",
        "count" : "1638"
      }, {
        "item" : "GIRONES",
        "count" : "1594"
      }, {
        "item" : "BERGUEDA",
        "count" : "1559"
      }, {
        "item" : "BAIX CAMP",
        "count" : "1547"
      }, {
        "item" : "SELVA",
        "count" : "1538"
      }, {
        "item" : "VALLES OCCIDENTAL",
        "count" : "1445"
      }, {
        "item" : "TARRAGONES",
        "count" : "1324"
      }, {
        "item" : "GARRIGUES",
        "count" : "1310"
      }, {
        "item" : "ALT CAMP",
        "count" : "1284"
      }, {
        "item" : "PRIORAT",
        "count" : "1255"
      } ],
      "smallest" : "ALTA RIBAGORCA",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : { }
  }, {
    "id" : 18305870,
    "name" : "CDMUN",
    "dataTypeName" : "text",
    "description" : "Codi municipal (INE 5 dígits)",
    "fieldName" : "cdmun",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 12056918,
    "cachedContents" : {
      "non_null" : "54611",
      "largest" : "43907",
      "null" : "0",
      "top" : [ {
        "item" : "08205",
        "count" : "72"
      }, {
        "item" : "08015",
        "count" : "72"
      }, {
        "item" : "08067",
        "count" : "72"
      }, {
        "item" : "08006",
        "count" : "72"
      }, {
        "item" : "17006",
        "count" : "72"
      }, {
        "item" : "43163",
        "count" : "72"
      }, {
        "item" : "08019",
        "count" : "72"
      }, {
        "item" : "08115",
        "count" : "72"
      }, {
        "item" : "17147",
        "count" : "72"
      }, {
        "item" : "25137",
        "count" : "72"
      }, {
        "item" : "43115",
        "count" : "72"
      }, {
        "item" : "25058",
        "count" : "72"
      }, {
        "item" : "43092",
        "count" : "72"
      }, {
        "item" : "43162",
        "count" : "72"
      }, {
        "item" : "08270",
        "count" : "72"
      }, {
        "item" : "43156",
        "count" : "72"
      }, {
        "item" : "08291",
        "count" : "72"
      }, {
        "item" : "25072",
        "count" : "72"
      }, {
        "item" : "43054",
        "count" : "72"
      }, {
        "item" : "17103",
        "count" : "72"
      } ],
      "smallest" : "08001",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : { }
  }, {
    "id" : 18305874,
    "name" : "Municipi",
    "dataTypeName" : "text",
    "description" : "Nom municipi indexat",
    "fieldName" : "municipi",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 12056922,
    "cachedContents" : {
      "non_null" : "54611",
      "largest" : "XERTA",
      "null" : "0",
      "top" : [ {
        "item" : "AMETLLA DE MAR, L'",
        "count" : "72"
      }, {
        "item" : "CASTELLDEFELS",
        "count" : "72"
      }, {
        "item" : "VIC",
        "count" : "72"
      }, {
        "item" : "RUBI",
        "count" : "72"
      }, {
        "item" : "AMPOLLA, L'",
        "count" : "72"
      }, {
        "item" : "ULLDECONA",
        "count" : "72"
      }, {
        "item" : "ALP",
        "count" : "72"
      }, {
        "item" : "MAÇANET DE LA SELVA",
        "count" : "72"
      }, {
        "item" : "SANTA MARGARIDA I ELS MONJOS",
        "count" : "72"
      }, {
        "item" : "VILANOVA I LA GELTRU",
        "count" : "72"
      }, {
        "item" : "CASTELLET I LA GORNAL",
        "count" : "72"
      }, {
        "item" : "SANT ESTEVE SESROVIRES",
        "count" : "72"
      }, {
        "item" : "POBLA DE MASSALUCA, LA",
        "count" : "72"
      }, {
        "item" : "TORREDEMBARRA",
        "count" : "72"
      }, {
        "item" : "SALT",
        "count" : "72"
      }, {
        "item" : "TORRES DE SEGRE",
        "count" : "72"
      }, {
        "item" : "REUS",
        "count" : "72"
      }, {
        "item" : "VALLS",
        "count" : "72"
      }, {
        "item" : "PLANOLES",
        "count" : "72"
      }, {
        "item" : "TERRASSA",
        "count" : "72"
      } ],
      "smallest" : "ABELLA DE LA CONCA",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : { }
  }, {
    "id" : 18305869,
    "name" : "Codi_Sector",
    "dataTypeName" : "text",
    "description" : "Codi del sector d’activitat econòmica",
    "fieldName" : "codi_sector",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 12056917,
    "cachedContents" : {
      "non_null" : "54611",
      "largest" : "7",
      "null" : "0",
      "top" : [ {
        "item" : "7",
        "count" : "11364"
      }, {
        "item" : "6",
        "count" : "11364"
      }, {
        "item" : "1",
        "count" : "10590"
      }, {
        "item" : "3",
        "count" : "10215"
      }, {
        "item" : "4",
        "count" : "9437"
      }, {
        "item" : "5",
        "count" : "1641"
      } ],
      "smallest" : "1",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : { }
  }, {
    "id" : 18305873,
    "name" : "Descripcio_Sector",
    "dataTypeName" : "text",
    "description" : "Sector d’activitat on es dedica el consum",
    "fieldName" : "descripcio_sector",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 12056921,
    "cachedContents" : {
      "non_null" : "54611",
      "largest" : "USOS DOMESTICS",
      "null" : "0",
      "top" : [ {
        "item" : "SERVEIS",
        "count" : "11364"
      }, {
        "item" : "USOS DOMESTICS",
        "count" : "11364"
      }, {
        "item" : "PRIMARI",
        "count" : "10590"
      }, {
        "item" : "INDUSTRIAL",
        "count" : "10215"
      }, {
        "item" : "CONSTRUCCIO I OBRES PUBLIQUES",
        "count" : "9437"
      }, {
        "item" : "TRANSPORT",
        "count" : "1641"
      } ],
      "smallest" : "CONSTRUCCIO I OBRES PUBLIQUES",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : { }
  }, {
    "id" : 18305868,
    "name" : "Consum [kWh]",
    "dataTypeName" : "number",
    "description" : "Consum d’energia elèctrica en kWh",
    "fieldName" : "consum_kwh",
    "position" : 8,
    "renderTypeName" : "number",
    "tableColumnId" : 12056916,
    "cachedContents" : {
      "non_null" : "44512",
      "largest" : "3986196192",
      "null" : "10099",
      "top" : [ {
        "item" : "7420",
        "count" : "4"
      }, {
        "item" : "84161",
        "count" : "3"
      }, {
        "item" : "39621",
        "count" : "3"
      }, {
        "item" : "23569",
        "count" : "3"
      }, {
        "item" : "15195",
        "count" : "3"
      }, {
        "item" : "8482",
        "count" : "3"
      }, {
        "item" : "31391",
        "count" : "3"
      }, {
        "item" : "11404",
        "count" : "3"
      }, {
        "item" : "339151",
        "count" : "3"
      }, {
        "item" : "55183",
        "count" : "3"
      }, {
        "item" : "10123",
        "count" : "3"
      }, {
        "item" : "8561",
        "count" : "3"
      }, {
        "item" : "34648",
        "count" : "3"
      }, {
        "item" : "11387",
        "count" : "3"
      }, {
        "item" : "10304",
        "count" : "3"
      }, {
        "item" : "14591",
        "count" : "3"
      }, {
        "item" : "11687",
        "count" : "2"
      }, {
        "item" : "54790",
        "count" : "2"
      }, {
        "item" : "451133",
        "count" : "2"
      }, {
        "item" : "264774",
        "count" : "2"
      } ],
      "smallest" : "45",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 18305872,
    "name" : "Observacions",
    "dataTypeName" : "text",
    "description" : "Indica si la dada en concret està subjecta a secret estadístic, o si s’ha realitzat l’agregació de sectors",
    "fieldName" : "observacions",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 12056920,
    "cachedContents" : {
      "non_null" : "10815",
      "largest" : "Inclou el consum del sector energètic",
      "null" : "43796",
      "top" : [ {
        "item" : "Dada subjecta a secret estadístic",
        "count" : "9827"
      }, {
        "item" : "Inclou el consum del sector energètic",
        "count" : "716"
      }, {
        "item" : "Dada subjecta a secret estadístic. Inclou el consum del sector energètic",
        "count" : "272"
      } ],
      "smallest" : "Dada subjecta a secret estadístic",
      "count" : "54611",
      "cardinality" : "54611"
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "attachments" : [ {
      "filename" : "Metodologia_Consum_EE_Municipi_sector_ICAEN.docx",
      "assetId" : "ac763a0d-b7e9-409d-a720-d29611fa9ed9",
      "name" : "Metodologia_Consum_EE_Municipi_sector_ICAEN.docx"
    } ],
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Anual"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Electricity consumption in municipialities and sectors of Catalonia",
        "Nombre del conjunto de datos (ES)" : "Consumo municipal de energia eléctrica por municipios y sectores de Catalunya"
      },
      "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" : [ "icaen", "consum energètic", "energia elèctrica", "municipi", "smartcatalonia", "ods7_energia assequible i no contaminant" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}