{
  "id" : "2gws-ubmt",
  "name" : "Consum d’aigua a Catalunya per comarques",
  "assetType" : "dataset",
  "attribution" : "Agència Catalana de l’Aigua (ACA)",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Medi Ambient",
  "createdAt" : 1601553060,
  "description" : "El data set recull el consum d’aigua per comarques, distingint entre el consum domèstic i el de fonts pròpies i per activitats econòmiques. Les dades són elaborades a partir de les declaracions a l’Agència Catalana de l’Aigua de les entitats subministradores, dels usuaris industrials i d’altres activitats econòmiques.  El consum es calcula a partir del consum facturat del cànon de l’aigua, no inclou els mínims de facturació del cànon.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 3582,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 3038892,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1751282853,
  "publicationGroup" : 1255032,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1778669826,
  "rowsUpdatedBy" : "ntmt-apg4",
  "tableId" : 2040406,
  "totalTimesRated" : 0,
  "viewCount" : 19915,
  "viewLastModified" : 1778669825,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1602070726,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1509918,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1602070726,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1602070726,
      "failureCount" : 0,
      "startedAt" : 1602070726,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 26828748,
    "name" : "Any",
    "dataTypeName" : "number",
    "description" : "Any de facturació dels consums al qual fan referència les dades",
    "fieldName" : "any",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 10869290,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "2025",
      "null" : "0",
      "top" : [ {
        "item" : "2025",
        "count" : "43"
      }, {
        "item" : "2024",
        "count" : "43"
      }, {
        "item" : "2023",
        "count" : "43"
      }, {
        "item" : "2016",
        "count" : "42"
      }, {
        "item" : "2015",
        "count" : "42"
      }, {
        "item" : "2019",
        "count" : "42"
      }, {
        "item" : "2020",
        "count" : "42"
      }, {
        "item" : "2022",
        "count" : "42"
      }, {
        "item" : "2018",
        "count" : "42"
      }, {
        "item" : "2017",
        "count" : "42"
      }, {
        "item" : "2021",
        "count" : "42"
      }, {
        "item" : "2013",
        "count" : "41"
      }, {
        "item" : "2012",
        "count" : "41"
      }, {
        "item" : "2014",
        "count" : "41"
      } ],
      "smallest" : "2012",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 26828756,
    "name" : "Codi comarca",
    "dataTypeName" : "number",
    "description" : "Codi de la comarca",
    "fieldName" : "codi_comarca",
    "position" : 2,
    "renderTypeName" : "number",
    "tableColumnId" : 16259257,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "43",
      "null" : "0",
      "top" : [ {
        "item" : "7",
        "count" : "14"
      }, {
        "item" : "12",
        "count" : "14"
      }, {
        "item" : "16",
        "count" : "14"
      }, {
        "item" : "15",
        "count" : "14"
      }, {
        "item" : "36",
        "count" : "14"
      }, {
        "item" : "1",
        "count" : "14"
      }, {
        "item" : "10",
        "count" : "14"
      }, {
        "item" : "4",
        "count" : "14"
      }, {
        "item" : "40",
        "count" : "14"
      }, {
        "item" : "33",
        "count" : "14"
      }, {
        "item" : "19",
        "count" : "14"
      }, {
        "item" : "9",
        "count" : "14"
      }, {
        "item" : "13",
        "count" : "14"
      }, {
        "item" : "29",
        "count" : "14"
      }, {
        "item" : "35",
        "count" : "14"
      }, {
        "item" : "14",
        "count" : "14"
      }, {
        "item" : "3",
        "count" : "14"
      }, {
        "item" : "17",
        "count" : "14"
      }, {
        "item" : "8",
        "count" : "14"
      }, {
        "item" : "37",
        "count" : "14"
      } ],
      "smallest" : "1",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : { }
  }, {
    "id" : 26828750,
    "name" : "Comarca",
    "dataTypeName" : "text",
    "description" : "Comarca a la qual fan referència les dades",
    "fieldName" : "comarca",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 10869291,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "VALLÈS ORIENTAL, EL",
      "null" : "0",
      "top" : [ {
        "item" : "BAGES, EL",
        "count" : "14"
      }, {
        "item" : "BAIX CAMP, EL",
        "count" : "14"
      }, {
        "item" : "URGELL, L'",
        "count" : "14"
      }, {
        "item" : "PLA DE L'ESTANY, EL",
        "count" : "14"
      }, {
        "item" : "OSONA",
        "count" : "14"
      }, {
        "item" : "VAL D'ARAN, LA",
        "count" : "14"
      }, {
        "item" : "MONTSIÀ, EL",
        "count" : "14"
      }, {
        "item" : "ALT URGELL, L'",
        "count" : "14"
      }, {
        "item" : "MARESME, EL",
        "count" : "14"
      }, {
        "item" : "BAIX PENEDÈS, EL",
        "count" : "14"
      }, {
        "item" : "BAIX EBRE, EL",
        "count" : "14"
      }, {
        "item" : "PLA D'URGELL, EL",
        "count" : "14"
      }, {
        "item" : "GARRIGUES, LES",
        "count" : "14"
      }, {
        "item" : "PALLARS SOBIRÀ, EL",
        "count" : "14"
      }, {
        "item" : "ALT PENEDÈS, L'",
        "count" : "14"
      }, {
        "item" : "PRIORAT, EL",
        "count" : "14"
      }, {
        "item" : "ANOIA, L'",
        "count" : "14"
      }, {
        "item" : "RIPOLLÈS, EL",
        "count" : "14"
      }, {
        "item" : "CONCA DE BARBERÀ, LA",
        "count" : "14"
      }, {
        "item" : "BAIX EMPORDÀ, EL",
        "count" : "14"
      } ],
      "smallest" : "ALTA RIBAGORÇA, L'",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : { }
  }, {
    "id" : 26828751,
    "name" : "Població",
    "dataTypeName" : "number",
    "description" : "Nombre d’habitants de la comarca a partir de dades del Padró municipal d’habitants a 1 de gener ",
    "fieldName" : "poblaci",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 10869289,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "2416005",
      "null" : "0",
      "top" : [ {
        "item" : "20482",
        "count" : "2"
      }, {
        "item" : "36693",
        "count" : "2"
      }, {
        "item" : "185085",
        "count" : "2"
      }, {
        "item" : "185973",
        "count" : "1"
      }, {
        "item" : "10500",
        "count" : "1"
      }, {
        "item" : "20878",
        "count" : "1"
      }, {
        "item" : "18063",
        "count" : "1"
      }, {
        "item" : "147504",
        "count" : "1"
      }, {
        "item" : "43995",
        "count" : "1"
      }, {
        "item" : "38726",
        "count" : "1"
      }, {
        "item" : "184993",
        "count" : "1"
      }, {
        "item" : "13603",
        "count" : "1"
      }, {
        "item" : "21482",
        "count" : "1"
      }, {
        "item" : "55855",
        "count" : "1"
      }, {
        "item" : "20231",
        "count" : "1"
      }, {
        "item" : "2227238",
        "count" : "1"
      }, {
        "item" : "145886",
        "count" : "1"
      }, {
        "item" : "44695",
        "count" : "1"
      }, {
        "item" : "210141",
        "count" : "1"
      }, {
        "item" : "249939",
        "count" : "1"
      } ],
      "smallest" : "3774",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26828752,
    "name" : "Domèstic xarxa",
    "dataTypeName" : "number",
    "description" : "Volum consumit  facturat a  les llars connectades a la xarxa de subministrament d’aigua. Mesurat en metres cúbics ",
    "fieldName" : "dom_stic_xarxa",
    "position" : 5,
    "renderTypeName" : "number",
    "tableColumnId" : 10869288,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "93135769",
      "null" : "0",
      "top" : [ {
        "item" : "8207896",
        "count" : "1"
      }, {
        "item" : "7151536",
        "count" : "1"
      }, {
        "item" : "844358",
        "count" : "1"
      }, {
        "item" : "349098",
        "count" : "1"
      }, {
        "item" : "8391792",
        "count" : "1"
      }, {
        "item" : "1636063",
        "count" : "1"
      }, {
        "item" : "9911298",
        "count" : "1"
      }, {
        "item" : "395244",
        "count" : "1"
      }, {
        "item" : "947300",
        "count" : "1"
      }, {
        "item" : "7245892",
        "count" : "1"
      }, {
        "item" : "575385",
        "count" : "1"
      }, {
        "item" : "85811270",
        "count" : "1"
      }, {
        "item" : "396144",
        "count" : "1"
      }, {
        "item" : "1399649",
        "count" : "1"
      }, {
        "item" : "7188027",
        "count" : "1"
      }, {
        "item" : "20595871",
        "count" : "1"
      }, {
        "item" : "6551468",
        "count" : "1"
      }, {
        "item" : "10022321",
        "count" : "1"
      }, {
        "item" : "1237160",
        "count" : "1"
      }, {
        "item" : "652445",
        "count" : "1"
      } ],
      "smallest" : "178336",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26828753,
    "name" : "Activitats econòmiques i fonts pròpies",
    "dataTypeName" : "number",
    "description" : "Volum consumit i facturat als usos industrials i de serveis connectats a la xarxa de subministrament d’aigua  i a tots els usuaris de fonts pròpies . Mesurat en metres cúbics.",
    "fieldName" : "activitats_econ_miques_i",
    "position" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 10869287,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "44488069",
      "null" : "0",
      "top" : [ {
        "item" : "22551325",
        "count" : "1"
      }, {
        "item" : "2944806",
        "count" : "1"
      }, {
        "item" : "7217816",
        "count" : "1"
      }, {
        "item" : "4213288",
        "count" : "1"
      }, {
        "item" : "1377727",
        "count" : "1"
      }, {
        "item" : "25263950",
        "count" : "1"
      }, {
        "item" : "5752687",
        "count" : "1"
      }, {
        "item" : "774696",
        "count" : "1"
      }, {
        "item" : "3728866",
        "count" : "1"
      }, {
        "item" : "738564",
        "count" : "1"
      }, {
        "item" : "2985046",
        "count" : "1"
      }, {
        "item" : "7704087",
        "count" : "1"
      }, {
        "item" : "24124484",
        "count" : "1"
      }, {
        "item" : "2046053",
        "count" : "1"
      }, {
        "item" : "2765098",
        "count" : "1"
      }, {
        "item" : "1101383",
        "count" : "1"
      }, {
        "item" : "585708",
        "count" : "1"
      }, {
        "item" : "3897146",
        "count" : "1"
      }, {
        "item" : "10387245",
        "count" : "1"
      }, {
        "item" : "23363113",
        "count" : "1"
      } ],
      "smallest" : "111138",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26828754,
    "name" : "Total",
    "dataTypeName" : "number",
    "description" : "Suma del volum de Domèstic xarxa i Activitats econòmiques i fonts pròpies. Mesurat en metres cúbics",
    "fieldName" : "total",
    "position" : 7,
    "renderTypeName" : "number",
    "tableColumnId" : 10869286,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "129894446",
      "null" : "0",
      "top" : [ {
        "item" : "14917342",
        "count" : "1"
      }, {
        "item" : "126129556",
        "count" : "1"
      }, {
        "item" : "16491067",
        "count" : "1"
      }, {
        "item" : "1672345",
        "count" : "1"
      }, {
        "item" : "15417175",
        "count" : "1"
      }, {
        "item" : "13709677",
        "count" : "1"
      }, {
        "item" : "55470742",
        "count" : "1"
      }, {
        "item" : "7249759",
        "count" : "1"
      }, {
        "item" : "4370776",
        "count" : "1"
      }, {
        "item" : "57477357",
        "count" : "1"
      }, {
        "item" : "605600",
        "count" : "1"
      }, {
        "item" : "434273",
        "count" : "1"
      }, {
        "item" : "3466649",
        "count" : "1"
      }, {
        "item" : "8070519",
        "count" : "1"
      }, {
        "item" : "128692331",
        "count" : "1"
      }, {
        "item" : "15556611",
        "count" : "1"
      }, {
        "item" : "2604088",
        "count" : "1"
      }, {
        "item" : "31236910",
        "count" : "1"
      }, {
        "item" : "11839910",
        "count" : "1"
      }, {
        "item" : "10431084",
        "count" : "1"
      } ],
      "smallest" : "434273",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 26828755,
    "name" : "Consum domèstic per càpita",
    "dataTypeName" : "number",
    "description" : "Consum domèstic de la xarxa per persona i dia. Es calcula de la següent forma: (Domèstic xarxa*1000)/(Població*365). Mesurat en litres/persona/dia",
    "fieldName" : "consum_dom_stic_per_c_pita",
    "position" : 8,
    "renderTypeName" : "number",
    "tableColumnId" : 10869285,
    "cachedContents" : {
      "non_null" : "588",
      "largest" : "378.16",
      "null" : "0",
      "top" : [ {
        "item" : "101.06",
        "count" : "2"
      }, {
        "item" : "109.88",
        "count" : "2"
      }, {
        "item" : "125.47",
        "count" : "2"
      }, {
        "item" : "111.35",
        "count" : "2"
      }, {
        "item" : "115.89",
        "count" : "2"
      }, {
        "item" : "107.08",
        "count" : "2"
      }, {
        "item" : "115.81",
        "count" : "2"
      }, {
        "item" : "110.24",
        "count" : "2"
      }, {
        "item" : "101.16",
        "count" : "2"
      }, {
        "item" : "106.64",
        "count" : "2"
      }, {
        "item" : "105.86",
        "count" : "2"
      }, {
        "item" : "111.17",
        "count" : "2"
      }, {
        "item" : "118.03",
        "count" : "2"
      }, {
        "item" : "101.11",
        "count" : "2"
      }, {
        "item" : "97.15",
        "count" : "2"
      }, {
        "item" : "116.00",
        "count" : "2"
      }, {
        "item" : "101.08",
        "count" : "2"
      }, {
        "item" : "109.41",
        "count" : "2"
      }, {
        "item" : "364.07",
        "count" : "1"
      }, {
        "item" : "95.37",
        "count" : "1"
      } ],
      "smallest" : "85.57",
      "count" : "588",
      "cardinality" : "588"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "any",
        "ascending" : false
      }, {
        "columnFieldName" : "codi_comarca",
        "ascending" : true
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Anual"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Water consumption in Catalonia by region",
        "Nombre del conjunto de datos (ES)" : "Consumo de agua en Cataluña por comarcas"
      },
      "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" : {
    "orderBys" : [ {
      "ascending" : false,
      "expression" : {
        "columnId" : 26828748,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 26828756,
        "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" : [ "sequera", "sostenibilitat", "litres", "emergència climàtica", "aigües", "aca", "consum", "consum d'aigua", "volum", "smartcatalonia", "ods6_aigua neta i sanejament", "ods13_acció pel clima", "ods12_producció i consum responsable" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}