{
  "id" : "uqk7-bf9s",
  "name" : "Registre de defuncions per COVID-19 a Catalunya per comarca i sexe",
  "assetType" : "dataset",
  "attribution" : "Departament de Salut",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Salut",
  "createdAt" : 1588154759,
  "description" : "El Departament de Salut ha deixat d'actualitzar aquest conjunt de dades en data 26-7-22. Podeu trobar tota la informació relacionada amb la COVID-19 i la resta d'infeccions respiratòries en els conjunts de dades de SIVIC (Vegeu contingut destacat).\n\n\nAquestes dades provenen del registre RSAcovid19 del Departament de Salut i s'obtenen a partir de les declaracions de les empreses de serveis funeraris.\n\nNomés es tenen en compte les defuncions relacionades amb la COVID-19: que el motiu del certificat de defunció especifiqui que la persona ha mort a causa de la COVID-19, tingui o no un prova diagnòstica PCR o TA amb resultat positiu.\n\nLes defuncions s’imputen a la data de defunció, però apareixen per primera vegada l'endemà del dia de la notificació.\n\nLes dades es mostren per comarques per evitar la identificació de les persones difuntes i garantir-ne la confidencialitat.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 30265,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 1947586,
  "provenance" : "official",
  "publicationAppendEnabled" : true,
  "publicationDate" : 1609771332,
  "publicationGroup" : 1148827,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1658918045,
  "rowsUpdatedBy" : "a4b5-gx6v",
  "tableId" : 1317941,
  "totalTimesRated" : 0,
  "viewCount" : 21650,
  "viewLastModified" : 1744021180,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1588261765,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 806695,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1588261765,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1588261765,
      "failureCount" : 0,
      "startedAt" : 1588261765,
      "status" : "success"
    },
    "submitter" : {
      "id" : "i82a-eakh",
      "displayName" : "Dades Obertes de Salut"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 17938449,
    "name" : "Data defunció",
    "dataTypeName" : "calendar_date",
    "description" : "Data defunció / Fecha defunción / Death date",
    "fieldName" : "exitusdata",
    "position" : 1,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 9377497,
    "cachedContents" : {
      "non_null" : "10899",
      "largest" : "2022-07-24T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2020-04-03T00:00:00.000",
        "count" : "47"
      }, {
        "item" : "2020-04-08T00:00:00.000",
        "count" : "47"
      }, {
        "item" : "2020-03-29T00:00:00.000",
        "count" : "46"
      }, {
        "item" : "2020-04-01T00:00:00.000",
        "count" : "46"
      }, {
        "item" : "2020-03-30T00:00:00.000",
        "count" : "44"
      }, {
        "item" : "2020-04-06T00:00:00.000",
        "count" : "44"
      }, {
        "item" : "2020-04-20T00:00:00.000",
        "count" : "44"
      }, {
        "item" : "2020-04-09T00:00:00.000",
        "count" : "43"
      }, {
        "item" : "2020-03-31T00:00:00.000",
        "count" : "43"
      }, {
        "item" : "2020-04-02T00:00:00.000",
        "count" : "42"
      }, {
        "item" : "2020-03-27T00:00:00.000",
        "count" : "42"
      }, {
        "item" : "2020-04-11T00:00:00.000",
        "count" : "41"
      }, {
        "item" : "2020-03-25T00:00:00.000",
        "count" : "41"
      }, {
        "item" : "2020-04-07T00:00:00.000",
        "count" : "40"
      }, {
        "item" : "2020-03-26T00:00:00.000",
        "count" : "40"
      }, {
        "item" : "2020-04-12T00:00:00.000",
        "count" : "40"
      }, {
        "item" : "2020-04-14T00:00:00.000",
        "count" : "40"
      }, {
        "item" : "2020-04-24T00:00:00.000",
        "count" : "39"
      }, {
        "item" : "2020-04-04T00:00:00.000",
        "count" : "38"
      }, {
        "item" : "2020-04-05T00:00:00.000",
        "count" : "38"
      } ],
      "smallest" : "2020-03-07T00:00:00.000",
      "count" : "10899",
      "cardinality" : "859"
    },
    "format" : {
      "view" : "date_dmy"
    }
  }, {
    "id" : 17938455,
    "name" : "Codi Comarca",
    "dataTypeName" : "text",
    "description" : "Codi Comarca / Código comarca / Region code",
    "fieldName" : "comarcacodi",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 11769259,
    "cachedContents" : {
      "non_null" : "10899",
      "largest" : "42",
      "null" : "0",
      "top" : [ {
        "item" : "13",
        "count" : "1401"
      }, {
        "item" : "40",
        "count" : "969"
      }, {
        "item" : "11",
        "count" : "915"
      }, {
        "item" : "21",
        "count" : "687"
      }, {
        "item" : "41",
        "count" : "666"
      }, {
        "item" : "07",
        "count" : "471"
      }, {
        "item" : "24",
        "count" : "453"
      }, {
        "item" : "33",
        "count" : "431"
      }, {
        "item" : "20",
        "count" : "389"
      }, {
        "item" : "36",
        "count" : "377"
      }, {
        "item" : "34",
        "count" : "374"
      }, {
        "item" : "08",
        "count" : "363"
      }, {
        "item" : "06",
        "count" : "298"
      }, {
        "item" : "02",
        "count" : "296"
      }, {
        "item" : "17",
        "count" : "285"
      }, {
        "item" : "03",
        "count" : "267"
      }, {
        "item" : "10",
        "count" : "261"
      }, {
        "item" : "19",
        "count" : "221"
      }, {
        "item" : "12",
        "count" : "175"
      }, {
        "item" : "28",
        "count" : "158"
      } ],
      "smallest" : "00",
      "count" : "10899",
      "cardinality" : "43"
    },
    "format" : { }
  }, {
    "id" : 17938451,
    "name" : "Comarca",
    "dataTypeName" : "text",
    "description" : "Comarca / Region",
    "fieldName" : "comarcadescripcio",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 9377495,
    "cachedContents" : {
      "non_null" : "10899",
      "largest" : "VALLES ORIENTAL",
      "null" : "0",
      "top" : [ {
        "item" : "BARCELONES",
        "count" : "1401"
      }, {
        "item" : "VALLES OCCIDENTAL",
        "count" : "969"
      }, {
        "item" : "BAIX LLOBREGAT",
        "count" : "915"
      }, {
        "item" : "MARESME",
        "count" : "687"
      }, {
        "item" : "VALLES ORIENTAL",
        "count" : "666"
      }, {
        "item" : "BAGES",
        "count" : "471"
      }, {
        "item" : "OSONA",
        "count" : "453"
      }, {
        "item" : "SEGRIA",
        "count" : "431"
      }, {
        "item" : "GIRONES",
        "count" : "389"
      }, {
        "item" : "TARRAGONES",
        "count" : "377"
      }, {
        "item" : "SELVA",
        "count" : "374"
      }, {
        "item" : "BAIX CAMP",
        "count" : "363"
      }, {
        "item" : "ANOIA",
        "count" : "298"
      }, {
        "item" : "ALT EMPORDA",
        "count" : "296"
      }, {
        "item" : "GARRAF",
        "count" : "285"
      }, {
        "item" : "ALT PENEDES",
        "count" : "267"
      }, {
        "item" : "BAIX EMPORDA",
        "count" : "261"
      }, {
        "item" : "GARROTXA",
        "count" : "221"
      }, {
        "item" : "BAIX PENEDES",
        "count" : "175"
      }, {
        "item" : "PLA DE L'ESTANY",
        "count" : "158"
      } ],
      "smallest" : "ALTA RIBAGORÇA",
      "count" : "10899",
      "cardinality" : "43"
    },
    "format" : { }
  }, {
    "id" : 17938452,
    "name" : "Codi Sexe",
    "dataTypeName" : "number",
    "description" : "Codi Sexe / Código Sexo / Gender code",
    "fieldName" : "sexecodi",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 9377494,
    "cachedContents" : {
      "non_null" : "10753",
      "largest" : "1",
      "null" : "146",
      "top" : [ {
        "item" : "0",
        "count" : "5687"
      }, {
        "item" : "1",
        "count" : "5066"
      } ],
      "smallest" : "0",
      "count" : "10899",
      "cardinality" : "2"
    },
    "format" : { }
  }, {
    "id" : 17938453,
    "name" : "Sexe",
    "dataTypeName" : "text",
    "description" : "Sexe / Sexo / Gender",
    "fieldName" : "sexedescripcio",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 9377493,
    "cachedContents" : {
      "non_null" : "10899",
      "largest" : "No classifcat",
      "null" : "0",
      "top" : [ {
        "item" : "Home",
        "count" : "5687"
      }, {
        "item" : "Dona",
        "count" : "5066"
      }, {
        "item" : "No classifcat",
        "count" : "146"
      } ],
      "smallest" : "Dona",
      "count" : "10899",
      "cardinality" : "3"
    },
    "format" : { }
  }, {
    "id" : 17938454,
    "name" : "Nombre defuncions",
    "dataTypeName" : "number",
    "description" : "Nombre defuncions / Número defunciones / Deaths number",
    "fieldName" : "numexitus",
    "position" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 9377492,
    "cachedContents" : {
      "non_null" : "10899",
      "largest" : "100",
      "null" : "0",
      "top" : [ {
        "item" : "1",
        "count" : "6711"
      }, {
        "item" : "2",
        "count" : "1820"
      }, {
        "item" : "3",
        "count" : "788"
      }, {
        "item" : "4",
        "count" : "430"
      }, {
        "item" : "5",
        "count" : "278"
      }, {
        "item" : "6",
        "count" : "171"
      }, {
        "item" : "7",
        "count" : "130"
      }, {
        "item" : "8",
        "count" : "93"
      }, {
        "item" : "10",
        "count" : "65"
      }, {
        "item" : "9",
        "count" : "64"
      }, {
        "item" : "12",
        "count" : "48"
      }, {
        "item" : "11",
        "count" : "38"
      }, {
        "item" : "13",
        "count" : "34"
      }, {
        "item" : "15",
        "count" : "20"
      }, {
        "item" : "14",
        "count" : "18"
      }, {
        "item" : "16",
        "count" : "18"
      }, {
        "item" : "18",
        "count" : "15"
      }, {
        "item" : "20",
        "count" : "14"
      }, {
        "item" : "19",
        "count" : "13"
      }, {
        "item" : "21",
        "count" : "12"
      } ],
      "smallest" : "1",
      "count" : "10899",
      "cardinality" : "73"
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "exitusdata",
        "ascending" : false
      }, {
        "columnFieldName" : "comarcadescripcio",
        "ascending" : true
      } ]
    },
    "attachments" : [ {
      "filename" : "Notes metodologiques datasets COVID_registre_mortalitat.docx",
      "assetId" : "3b649f5e-d23b-42f5-a3c0-f7debf81d0b7",
      "name" : "Notes metodologiques COVID_registre_mortalitat.docx"
    } ],
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Dades estàtiques"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Death records due to COVID-19 in Catalonia. Segregated by gender and region",
        "Nombre del conjunto de datos (ES)" : "Registro de defunciones por COVID-19 en Catalunya. Segregación por sexo y comarca"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "Sí"
      },
      "Actors" : {
        "Departament" : "Salut",
        "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" : 17938449,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 17938451,
        "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" : [ "covid-19", "covid19", "coronavirus", "morts", "mortalitat", "ods3_salut i benestar" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}
