{
  "id" : "nvkj-dz8r",
  "name" : "Indicadors de presència de rastres genètics del virus SARS-CoV-2 a les aigües residuals",
  "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" : "Salut",
  "createdAt" : 1606402438,
  "description" : "Conjunt de dades que conté les traces del virus de la COVID 19 a les aigües residuals a diferents depurades de Catalunya. Dades disponibles fins desembre de 2023.\nNombrosos estudis científics posen en evidència el fet que les aigües residuals no tractades són un bon indicador de la circulació de virus en una població. Per aquest motiu, l’Agència de Salut Pública de Catalunya i l’Agència Catalana de l’Aigua (ACA) han impulsat la Xarxa de monitorització del SARS-Cov_2 en aigües residuals.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1233,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 1915008,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1606402612,
  "publicationGroup" : 1294419,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1792630804,
  "rowsUpdatedBy" : "a4b5-gx6v",
  "tableId" : 1294419,
  "totalTimesRated" : 0,
  "viewCount" : 4433,
  "viewLastModified" : 1792630803,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1606729805,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 781972,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1606729805,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1606729806,
      "failureCount" : 0,
      "startedAt" : 1606729805,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 17520307,
    "name" : "id mostra",
    "dataTypeName" : "text",
    "description" : "Identificador de la mostra (XXXX-aaaa-mm-dd)",
    "fieldName" : "id_mostra",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 11435483,
    "cachedContents" : {
      "non_null" : "6718",
      "largest" : "DVLG-2025-11-10",
      "null" : "0",
      "top" : [ {
        "item" : "DGIR-2025-07-21",
        "count" : "3"
      }, {
        "item" : "DPDL-2025-07-21",
        "count" : "3"
      }, {
        "item" : "DPDL-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DABR-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DVEN-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DBSS-2025-07-21",
        "count" : "2"
      }, {
        "item" : "DSRS-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DBSS-2025-04-28",
        "count" : "2"
      }, {
        "item" : "DGIR-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DFIG-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DRUB-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DMIR-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DGRA-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DBAY-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DPDL-2025-02-24",
        "count" : "2"
      }, {
        "item" : "DBER-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DTAR-2022-05-23",
        "count" : "2"
      }, {
        "item" : "DGIR-2025-02-24",
        "count" : "2"
      }, {
        "item" : "DMRT-2021-04-05",
        "count" : "2"
      }, {
        "item" : "DBSS-2025-03-17",
        "count" : "2"
      } ],
      "smallest" : "DABR-2020-07-06",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : { }
  }, {
    "id" : 17520308,
    "name" : "depuradora",
    "dataTypeName" : "text",
    "description" : "Nom de la depuradora",
    "fieldName" : "depuradora",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 11435484,
    "cachedContents" : {
      "non_null" : "6718",
      "largest" : "VILA-SECA/SALOU",
      "null" : "0",
      "top" : [ {
        "item" : "GIRONA",
        "count" : "158"
      }, {
        "item" : "PRAT_DE_LLOBREGAT_EL",
        "count" : "157"
      }, {
        "item" : "PUIGCERDÀ",
        "count" : "154"
      }, {
        "item" : "MONTCADA",
        "count" : "154"
      }, {
        "item" : "REUS",
        "count" : "153"
      }, {
        "item" : "SOLSONA",
        "count" : "153"
      }, {
        "item" : "TARRAGONA",
        "count" : "153"
      }, {
        "item" : "LLEIDA",
        "count" : "153"
      }, {
        "item" : "MONTFERRER",
        "count" : "153"
      }, {
        "item" : "TORTOSA-ROQUETES",
        "count" : "152"
      }, {
        "item" : "BALAGUER",
        "count" : "152"
      }, {
        "item" : "AMPOSTA",
        "count" : "150"
      }, {
        "item" : "BESÒS",
        "count" : "149"
      }, {
        "item" : "MANRESA",
        "count" : "149"
      }, {
        "item" : "GAVÀ/VILADECANS",
        "count" : "149"
      }, {
        "item" : "VILANOVA_I_LA_GELTRÚ",
        "count" : "149"
      }, {
        "item" : "RIERA_DE_LA_BISBAL",
        "count" : "149"
      }, {
        "item" : "SANT_FELIU_DE_LLOBREGAT",
        "count" : "148"
      }, {
        "item" : "VIC",
        "count" : "147"
      }, {
        "item" : "TERRASSA",
        "count" : "147"
      } ],
      "smallest" : "ABRERA",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : { }
  }, {
    "id" : 17520304,
    "name" : "N1(CG/L)",
    "dataTypeName" : "number",
    "description" : "Còpia genòmiques de la diana N1 (fragment de la Nucleocapsida) per litre d’aigua residual",
    "fieldName" : "n1_cg_l",
    "position" : 3,
    "renderTypeName" : "number",
    "tableColumnId" : 11435480,
    "cachedContents" : {
      "non_null" : "6703",
      "largest" : "54234265",
      "null" : "15",
      "top" : [ {
        "item" : "375",
        "count" : "69"
      }, {
        "item" : "450",
        "count" : "50"
      }, {
        "item" : "148",
        "count" : "41"
      }, {
        "item" : "200",
        "count" : "38"
      }, {
        "item" : "300",
        "count" : "25"
      }, {
        "item" : "171",
        "count" : "14"
      }, {
        "item" : "143",
        "count" : "13"
      }, {
        "item" : "500",
        "count" : "11"
      }, {
        "item" : "360",
        "count" : "11"
      }, {
        "item" : "100",
        "count" : "8"
      }, {
        "item" : "400",
        "count" : "7"
      }, {
        "item" : "480",
        "count" : "6"
      }, {
        "item" : "214",
        "count" : "5"
      }, {
        "item" : "420",
        "count" : "5"
      }, {
        "item" : "352",
        "count" : "5"
      }, {
        "item" : "280",
        "count" : "4"
      }, {
        "item" : "438",
        "count" : "4"
      }, {
        "item" : "320",
        "count" : "4"
      }, {
        "item" : "392",
        "count" : "4"
      }, {
        "item" : "413",
        "count" : "4"
      } ],
      "smallest" : "30",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 17520305,
    "name" : "N2(CG/L)",
    "dataTypeName" : "number",
    "description" : "Còpia genòmiques de la diana N2 (fragment de la Nucleocapsida) per litre d’aigua residual",
    "fieldName" : "n2_cg_l",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 11435481,
    "cachedContents" : {
      "non_null" : "4347",
      "largest" : "9558942",
      "null" : "2371",
      "top" : [ {
        "item" : "375",
        "count" : "80"
      }, {
        "item" : "171",
        "count" : "50"
      }, {
        "item" : "143",
        "count" : "39"
      }, {
        "item" : "200",
        "count" : "35"
      }, {
        "item" : "300",
        "count" : "33"
      }, {
        "item" : "360",
        "count" : "19"
      }, {
        "item" : "450",
        "count" : "18"
      }, {
        "item" : "214",
        "count" : "10"
      }, {
        "item" : "352",
        "count" : "9"
      }, {
        "item" : "500",
        "count" : "8"
      }, {
        "item" : "480",
        "count" : "8"
      }, {
        "item" : "400",
        "count" : "8"
      }, {
        "item" : "320",
        "count" : "7"
      }, {
        "item" : "257",
        "count" : "6"
      }, {
        "item" : "392",
        "count" : "6"
      }, {
        "item" : "312",
        "count" : "6"
      }, {
        "item" : "240",
        "count" : "6"
      }, {
        "item" : "280",
        "count" : "5"
      }, {
        "item" : "408",
        "count" : "5"
      }, {
        "item" : "368",
        "count" : "4"
      } ],
      "smallest" : "30",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 17520303,
    "name" : "IP4(CG/L)",
    "dataTypeName" : "number",
    "description" : "Còpia genòmiques de la diana IP4 (fragment de la Polimerasa Viral) per litre d’aigua residual",
    "fieldName" : "ip4_cg_l",
    "position" : 5,
    "renderTypeName" : "number",
    "tableColumnId" : 11435479,
    "cachedContents" : {
      "non_null" : "2221",
      "largest" : "10087708",
      "null" : "4497",
      "top" : [ {
        "item" : "148",
        "count" : "37"
      }, {
        "item" : "100",
        "count" : "6"
      }, {
        "item" : "1400",
        "count" : "5"
      }, {
        "item" : "833",
        "count" : "4"
      }, {
        "item" : "800",
        "count" : "4"
      }, {
        "item" : "1800",
        "count" : "3"
      }, {
        "item" : "1600",
        "count" : "3"
      }, {
        "item" : "14701",
        "count" : "2"
      }, {
        "item" : "8333",
        "count" : "2"
      }, {
        "item" : "98219",
        "count" : "2"
      }, {
        "item" : "1667",
        "count" : "2"
      }, {
        "item" : "8000",
        "count" : "2"
      }, {
        "item" : "11333",
        "count" : "2"
      }, {
        "item" : "14667",
        "count" : "2"
      }, {
        "item" : "891",
        "count" : "2"
      }, {
        "item" : "733",
        "count" : "2"
      }, {
        "item" : "967",
        "count" : "2"
      }, {
        "item" : "633",
        "count" : "2"
      }, {
        "item" : "2502",
        "count" : "2"
      }, {
        "item" : "453",
        "count" : "1"
      } ],
      "smallest" : "100",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 17520302,
    "name" : "E(CG/L)",
    "dataTypeName" : "number",
    "description" : "Còpia genòmiques de la diana E (fragment de la Proteïna d’envolcall) per litre d’aigua residual",
    "fieldName" : "e_cg_l",
    "position" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 11435478,
    "cachedContents" : {
      "non_null" : "183",
      "largest" : "115031",
      "null" : "6535",
      "top" : [ {
        "item" : "450",
        "count" : "61"
      }, {
        "item" : "148",
        "count" : "52"
      }, {
        "item" : "360",
        "count" : "8"
      }, {
        "item" : "420",
        "count" : "8"
      }, {
        "item" : "100",
        "count" : "8"
      }, {
        "item" : "300",
        "count" : "5"
      }, {
        "item" : "714",
        "count" : "3"
      }, {
        "item" : "400",
        "count" : "3"
      }, {
        "item" : "457",
        "count" : "3"
      }, {
        "item" : "600",
        "count" : "2"
      }, {
        "item" : "343",
        "count" : "2"
      }, {
        "item" : "490",
        "count" : "2"
      }, {
        "item" : "500",
        "count" : "2"
      }, {
        "item" : "540",
        "count" : "2"
      }, {
        "item" : "610",
        "count" : "2"
      }, {
        "item" : "653",
        "count" : "2"
      }, {
        "item" : "686",
        "count" : "2"
      }, {
        "item" : "762",
        "count" : "2"
      }, {
        "item" : "62244",
        "count" : "1"
      }, {
        "item" : "111736",
        "count" : "1"
      } ],
      "smallest" : "100",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 17520306,
    "name" : "Cabal últimes 24h(m3)",
    "dataTypeName" : "number",
    "description" : "Cabal mesurat en m3",
    "fieldName" : "cabal_ltimes_24h_m3",
    "position" : 7,
    "renderTypeName" : "number",
    "tableColumnId" : 11435482,
    "cachedContents" : {
      "non_null" : "6204",
      "largest" : "3312488",
      "null" : "514",
      "top" : [ {
        "item" : "4000",
        "count" : "9"
      }, {
        "item" : "320",
        "count" : "8"
      }, {
        "item" : "325",
        "count" : "5"
      }, {
        "item" : "15333",
        "count" : "5"
      }, {
        "item" : "25000",
        "count" : "4"
      }, {
        "item" : "23700",
        "count" : "4"
      }, {
        "item" : "323",
        "count" : "4"
      }, {
        "item" : "25100",
        "count" : "4"
      }, {
        "item" : "343",
        "count" : "4"
      }, {
        "item" : "22370",
        "count" : "4"
      }, {
        "item" : "415",
        "count" : "4"
      }, {
        "item" : "352",
        "count" : "4"
      }, {
        "item" : "24300",
        "count" : "4"
      }, {
        "item" : "3630",
        "count" : "3"
      }, {
        "item" : "2389",
        "count" : "3"
      }, {
        "item" : "1327",
        "count" : "3"
      }, {
        "item" : "49562",
        "count" : "3"
      }, {
        "item" : "6796",
        "count" : "3"
      }, {
        "item" : "472",
        "count" : "3"
      }, {
        "item" : "15652",
        "count" : "3"
      } ],
      "smallest" : "1.295",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 17520309,
    "name" : "Pluja(mm)",
    "dataTypeName" : "number",
    "description" : "Pluja en mm",
    "fieldName" : "pluja_mm",
    "position" : 8,
    "renderTypeName" : "number",
    "tableColumnId" : 11435485,
    "cachedContents" : {
      "non_null" : "5813",
      "largest" : "300000",
      "null" : "905",
      "top" : [ {
        "item" : "0",
        "count" : "5158"
      }, {
        "item" : "1",
        "count" : "34"
      }, {
        "item" : "0.1",
        "count" : "28"
      }, {
        "item" : "10",
        "count" : "26"
      }, {
        "item" : "0.2",
        "count" : "25"
      }, {
        "item" : "3",
        "count" : "23"
      }, {
        "item" : "2",
        "count" : "23"
      }, {
        "item" : "5",
        "count" : "20"
      }, {
        "item" : "6",
        "count" : "15"
      }, {
        "item" : "0.5",
        "count" : "15"
      }, {
        "item" : "0.6",
        "count" : "15"
      }, {
        "item" : "4",
        "count" : "13"
      }, {
        "item" : "0.4",
        "count" : "11"
      }, {
        "item" : "8",
        "count" : "10"
      }, {
        "item" : "2.6",
        "count" : "10"
      }, {
        "item" : "2.4",
        "count" : "10"
      }, {
        "item" : "7",
        "count" : "9"
      }, {
        "item" : "0.8",
        "count" : "9"
      }, {
        "item" : "1.6",
        "count" : "9"
      }, {
        "item" : "9",
        "count" : "9"
      } ],
      "smallest" : "0",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : { }
  }, {
    "id" : 17520310,
    "name" : "Observacions",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "observacions",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 11435486,
    "cachedContents" : {
      "non_null" : "195",
      "largest" : "Valors corresponents a la repetició.",
      "null" : "6523",
      "top" : [ {
        "item" : "Molt material en suspensió",
        "count" : "43"
      }, {
        "item" : "Canvi metodològic",
        "count" : "37"
      }, {
        "item" : "Valor Puntual",
        "count" : "15"
      }, {
        "item" : "Canvi Metodològic",
        "count" : "11"
      }, {
        "item" : "Molta materia suspensió en conseqüència molta inhibició particularment IP4",
        "count" : "7"
      }, {
        "item" : "Molta materia en suspensió",
        "count" : "7"
      }, {
        "item" : "Repetició IP4",
        "count" : "5"
      }, {
        "item" : "Diana IP4 detecció <LQ",
        "count" : "4"
      }, {
        "item" : "Hem tingut problemes per concentrar. Es va obturar el filtre i vam haver de fer tres tandes de centrifugació",
        "count" : "4"
      }, {
        "item" : "Molta materia suspensió en conseqüència molta inhibició particularment N1",
        "count" : "4"
      }, {
        "item" : "Es va obturar el centricon i vam haver de centrifugar més estona",
        "count" : "4"
      }, {
        "item" : "No s'ha afegit el control intern TGEV",
        "count" : "3"
      }, {
        "item" : "Repetición IP4",
        "count" : "3"
      }, {
        "item" : "Molt material en suspensió. IP4 repetida i continua inhibició.",
        "count" : "3"
      }, {
        "item" : "Mostra puntual",
        "count" : "2"
      }, {
        "item" : "No detectat confirmat (dues analítiques)",
        "count" : "2"
      }, {
        "item" : "La mostra està dopada amb un stock de MS2 diferent (8.07E 08 CG/ML)",
        "count" : "2"
      }, {
        "item" : "Mostra molt neta. Possible dilució?",
        "count" : "2"
      }, {
        "item" : "Analítica confirmada per repetició",
        "count" : "2"
      }, {
        "item" : "Mostra amb molta materia en suspensió que fa pujar la inhibició",
        "count" : "2"
      } ],
      "smallest" : "Aigua cristal.lina",
      "count" : "6718",
      "cardinality" : "6718"
    },
    "format" : { }
  }, {
    "id" : 17520311,
    "name" : "Valor puntual",
    "dataTypeName" : "checkbox",
    "description" : "Valor calculat per la senyal d'una única rèplica d'una sola diana genètica.",
    "fieldName" : "valor_puntual",
    "position" : 10,
    "renderTypeName" : "checkbox",
    "tableColumnId" : 11435487,
    "cachedContents" : {
      "non_null" : "6718",
      "null" : "0",
      "top" : [ {
        "item" : false,
        "count" : "6587"
      }, {
        "item" : true,
        "count" : "131"
      } ],
      "count" : "6718",
      "cardinality" : "6718"
    },
    "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)" : "Indicators of the presence of genetic traces of the SARS-CoV-2 virus in wastewater",
        "Nombre del conjunto de datos (ES)" : "Indicadores de presencia de rastros genéticos del virus SARS-CoV-2 a las aguas residuales"
      },
      "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" : "Sense informació geogràfica",
        "À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" : [ "aigües residuals", "covid19", "depuradora", "aca", "sars-cov-2", "sarsaigua", "ods6_aigua neta i sanejament" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}