{
  "id" : "4w8y-gf8x",
  "name" : "Obligacions reconegudes pendents de pagament als ens locals en relació amb les subvencions de la Secretaria de Governs Locals i Relacions amb Aran",
  "assetType" : "dataset",
  "attribution" : "Secretaria de Governs Locals i de Relacions amb l'Aran",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Economia",
  "createdAt" : 1590136918,
  "description" : "Obligacions reconegudes pendents de pagament als ens locals en relació amb els ajuts i les subvencions de la Secretaria de Governs Locals i Relacions amb Aran (Fons de Cooperació Local, Pla únic d’Obres i Serveis, compensació a càrrecs electes i d’altres) en la data que s’informa al fitxer.\n\nEl ens que tenen pendent trametre la documentació economicofinancera obligatòria al Departament de la Presidència, al Departament d’Economia i Finances i a la Sindicatura de Comptes tenen aquests pagaments retinguts fins que completin la tramesa (Decret 80/2023, de 18 d'abril, pel qual es regula l'Inventari de control del compliment de les obligacions de tramesa de la documentació economicofinancera en l'àmbit local i el procediment de suspensió de pagament de subvencions i de transferències davant l'incompliment)",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1605,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 1729901,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1590137591,
  "publicationGroup" : 1164114,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1783325340,
  "rowsUpdatedBy" : "a3rg-xd5j",
  "tableId" : 1164114,
  "totalTimesRated" : 0,
  "viewCount" : 4357,
  "viewLastModified" : 1783325340,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1590160526,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 631686,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1590160526,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1590160527,
      "failureCount" : 0,
      "startedAt" : 1590160526,
      "status" : "success"
    },
    "submitter" : {
      "id" : "f79v-x7kr",
      "displayName" : "Dades obertes Presidència"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 15081075,
    "name" : "Data",
    "dataTypeName" : "calendar_date",
    "description" : "Data de referència d’obligacions reconegudes",
    "fieldName" : "data",
    "position" : 1,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 9595740,
    "cachedContents" : {
      "non_null" : "28544",
      "largest" : "2026-07-01T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2026-01-02T00:00:00.000",
        "count" : "2192"
      }, {
        "item" : "2021-07-06T00:00:00.000",
        "count" : "1396"
      }, {
        "item" : "2021-04-06T00:00:00.000",
        "count" : "1289"
      }, {
        "item" : "2026-02-02T00:00:00.000",
        "count" : "1289"
      }, {
        "item" : "2020-05-04T00:00:00.000",
        "count" : "1230"
      }, {
        "item" : "2020-06-02T00:00:00.000",
        "count" : "1124"
      }, {
        "item" : "2020-08-31T00:00:00.000",
        "count" : "1112"
      }, {
        "item" : "2021-02-01T00:00:00.000",
        "count" : "1084"
      }, {
        "item" : "2021-06-01T00:00:00.000",
        "count" : "1079"
      }, {
        "item" : "2023-07-05T00:00:00.000",
        "count" : "1046"
      }, {
        "item" : "2021-11-02T00:00:00.000",
        "count" : "1032"
      }, {
        "item" : "2021-09-06T00:00:00.000",
        "count" : "1011"
      }, {
        "item" : "2021-05-03T00:00:00.000",
        "count" : "1008"
      }, {
        "item" : "2022-05-03T00:00:00.000",
        "count" : "888"
      }, {
        "item" : "2026-03-02T00:00:00.000",
        "count" : "654"
      }, {
        "item" : "2024-02-06T00:00:00.000",
        "count" : "635"
      }, {
        "item" : "2021-03-01T00:00:00.000",
        "count" : "569"
      }, {
        "item" : "2021-01-04T00:00:00.000",
        "count" : "563"
      }, {
        "item" : "2022-12-01T00:00:00.000",
        "count" : "542"
      }, {
        "item" : "2022-06-02T00:00:00.000",
        "count" : "540"
      } ],
      "smallest" : "2020-05-04T00:00:00.000",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : {
      "view" : "date_dmy"
    }
  }, {
    "id" : 15081082,
    "name" : "Provincia",
    "dataTypeName" : "text",
    "description" : "Província a la que pertany el creditor",
    "fieldName" : "provincia",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 9595747,
    "cachedContents" : {
      "non_null" : "28543",
      "largest" : "Tarragona",
      "null" : "1",
      "top" : [ {
        "item" : "Barcelona",
        "count" : "9063"
      }, {
        "item" : "Lleida",
        "count" : "8688"
      }, {
        "item" : "Girona",
        "count" : "5554"
      }, {
        "item" : "Tarragona",
        "count" : "5234"
      }, {
        "item" : "0",
        "count" : "4"
      } ],
      "smallest" : "0",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : { }
  }, {
    "id" : 15081081,
    "name" : "Comarca",
    "dataTypeName" : "text",
    "description" : "Comarca a la que pertany el creditor",
    "fieldName" : "comarca",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 9595746,
    "cachedContents" : {
      "non_null" : "28543",
      "largest" : "Vallès Oriental",
      "null" : "1",
      "top" : [ {
        "item" : "Alt Empordà",
        "count" : "1714"
      }, {
        "item" : "Berguedà",
        "count" : "1632"
      }, {
        "item" : "Anoia",
        "count" : "1322"
      }, {
        "item" : "Osona",
        "count" : "1125"
      }, {
        "item" : "Segrià",
        "count" : "1076"
      }, {
        "item" : "Vallès Oriental",
        "count" : "1035"
      }, {
        "item" : "Priorat",
        "count" : "985"
      }, {
        "item" : "Noguera",
        "count" : "965"
      }, {
        "item" : "Alt Urgell",
        "count" : "950"
      }, {
        "item" : "Aran",
        "count" : "902"
      }, {
        "item" : "Baix Empordà",
        "count" : "894"
      }, {
        "item" : "Cerdanya",
        "count" : "866"
      }, {
        "item" : "Bages",
        "count" : "766"
      }, {
        "item" : "Garrigues",
        "count" : "736"
      }, {
        "item" : "Alt Penedès",
        "count" : "730"
      }, {
        "item" : "Pallars Sobirà",
        "count" : "702"
      }, {
        "item" : "Baix Camp",
        "count" : "686"
      }, {
        "item" : "Maresme",
        "count" : "664"
      }, {
        "item" : "Urgell",
        "count" : "663"
      }, {
        "item" : "Gironès",
        "count" : "635"
      } ],
      "smallest" : "0",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : { }
  }, {
    "id" : 15081080,
    "name" : "TipusEns",
    "dataTypeName" : "text",
    "description" : "Tipus d’ens local",
    "fieldName" : "tipusens",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 9595745,
    "cachedContents" : {
      "non_null" : "28544",
      "largest" : "Mancomunitats",
      "null" : "0",
      "top" : [ {
        "item" : "Ajuntaments",
        "count" : "25952"
      }, {
        "item" : "EMD",
        "count" : "1743"
      }, {
        "item" : "Consells comarcals",
        "count" : "761"
      }, {
        "item" : "Diputacions",
        "count" : "46"
      }, {
        "item" : "Mancomunitats",
        "count" : "30"
      }, {
        "item" : "AMB",
        "count" : "11"
      }, {
        "item" : "Altres ens",
        "count" : "1"
      } ],
      "smallest" : "Ajuntaments",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : { }
  }, {
    "id" : 15081079,
    "name" : "NIFCreditor",
    "dataTypeName" : "text",
    "description" : "NIF de l’ens local creditor",
    "fieldName" : "nifcreditor",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 9595744,
    "cachedContents" : {
      "non_null" : "28544",
      "largest" : "P9359001F",
      "null" : "0",
      "top" : [ {
        "item" : "P2505400H",
        "count" : "425"
      }, {
        "item" : "P4317500I",
        "count" : "248"
      }, {
        "item" : "P0816100B",
        "count" : "212"
      }, {
        "item" : "P0821500F",
        "count" : "155"
      }, {
        "item" : "P0809100A",
        "count" : "150"
      }, {
        "item" : "P2500015I",
        "count" : "148"
      }, {
        "item" : "P1715000D",
        "count" : "144"
      }, {
        "item" : "P2531500C",
        "count" : "141"
      }, {
        "item" : "P0828000J",
        "count" : "125"
      }, {
        "item" : "P2500100I",
        "count" : "116"
      }, {
        "item" : "P2505500E",
        "count" : "112"
      }, {
        "item" : "P0827700F",
        "count" : "106"
      }, {
        "item" : "P0811400A",
        "count" : "102"
      }, {
        "item" : "P0815200A",
        "count" : "101"
      }, {
        "item" : "P0825500B",
        "count" : "98"
      }, {
        "item" : "P2516600J",
        "count" : "94"
      }, {
        "item" : "P0830500E",
        "count" : "91"
      }, {
        "item" : "P0813100E",
        "count" : "89"
      }, {
        "item" : "P1721600C",
        "count" : "87"
      }, {
        "item" : "P2521500E",
        "count" : "87"
      } ],
      "smallest" : "G64105083",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : { }
  }, {
    "id" : 15081078,
    "name" : "NomCreditor",
    "dataTypeName" : "text",
    "description" : "Nom de l’ens local creditor",
    "fieldName" : "nomcreditor",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 9595743,
    "cachedContents" : {
      "non_null" : "28544",
      "largest" : "Mancomunitat de Serveis Oristà-Sant Feliu Sasserra",
      "null" : "0",
      "top" : [ {
        "item" : "Ajuntament de Bausen",
        "count" : "425"
      }, {
        "item" : "Ajuntament de la Vilella Alta",
        "count" : "248"
      }, {
        "item" : "Ajuntament dels Hostalets de Pierola",
        "count" : "212"
      }, {
        "item" : "Ajuntament de Sant Jaume de Frontanyà",
        "count" : "155"
      }, {
        "item" : "Ajuntament de Gironella",
        "count" : "150"
      }, {
        "item" : "Entitat Municipal Descentralitzada de Pi",
        "count" : "148"
      }, {
        "item" : "Ajuntament de Puigcerdà",
        "count" : "144"
      }, {
        "item" : "Entitat Municipal Descentralitzada de Víllec i Estana",
        "count" : "141"
      }, {
        "item" : "Ajuntament de Tavertet",
        "count" : "125"
      }, {
        "item" : "Ajuntament d'Abella de la Conca",
        "count" : "116"
      }, {
        "item" : "Ajuntament de Belianes",
        "count" : "112"
      }, {
        "item" : "Ajuntament de Talamanca",
        "count" : "106"
      }, {
        "item" : "Ajuntament de Martorelles",
        "count" : "102"
      }, {
        "item" : "Ajuntament d'Òrrius",
        "count" : "101"
      }, {
        "item" : "Ajuntament de Santa Maria de Merlès",
        "count" : "98"
      }, {
        "item" : "Ajuntament de Massalcoreig",
        "count" : "94"
      }, {
        "item" : "Ajuntament de Vilobí del Penedès",
        "count" : "91"
      }, {
        "item" : "Ajuntament de Montmajor",
        "count" : "89"
      }, {
        "item" : "Ajuntament d'Ultramort",
        "count" : "87"
      }, {
        "item" : "Ajuntament de Ponts",
        "count" : "87"
      } ],
      "smallest" : "Ajuntament d'Abella de la Conca",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : { }
  }, {
    "id" : 15081077,
    "name" : "TipusAjut",
    "dataTypeName" : "text",
    "description" : "Tipus d’ajut o subvenció",
    "fieldName" : "tipusajut",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 9595742,
    "cachedContents" : {
      "non_null" : "28544",
      "largest" : "PUOSC",
      "null" : "0",
      "top" : [ {
        "item" : "FCL",
        "count" : "13430"
      }, {
        "item" : "PUOSC",
        "count" : "6315"
      }, {
        "item" : "Càrrecs electes",
        "count" : "3428"
      }, {
        "item" : "Assistència tècnica",
        "count" : "1829"
      }, {
        "item" : "Dinamització esports",
        "count" : "924"
      }, {
        "item" : "Fons ex. COVID",
        "count" : "787"
      }, {
        "item" : "Ajuts extraordinaris",
        "count" : "751"
      }, {
        "item" : "Camins",
        "count" : "497"
      }, {
        "item" : "PECT",
        "count" : "192"
      }, {
        "item" : "Dinamització territorial",
        "count" : "160"
      }, {
        "item" : "Digitalització gestió aigua",
        "count" : "81"
      }, {
        "item" : "FEDER",
        "count" : "72"
      }, {
        "item" : "Aigüa Next Generation",
        "count" : "57"
      }, {
        "item" : "MRR",
        "count" : "17"
      }, {
        "item" : "Fons europeus",
        "count" : "3"
      }, {
        "item" : "Altres",
        "count" : "1"
      } ],
      "smallest" : "Aigüa Next Generation",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : { }
  }, {
    "id" : 15081074,
    "name" : "Exercici",
    "dataTypeName" : "number",
    "description" : "Exercici de referència",
    "fieldName" : "exercici",
    "position" : 8,
    "renderTypeName" : "number",
    "tableColumnId" : 9595739,
    "cachedContents" : {
      "non_null" : "28544",
      "largest" : "2026",
      "null" : "0",
      "top" : [ {
        "item" : "2021",
        "count" : "7009"
      }, {
        "item" : "2020",
        "count" : "6381"
      }, {
        "item" : "2025",
        "count" : "4882"
      }, {
        "item" : "2023",
        "count" : "3975"
      }, {
        "item" : "2022",
        "count" : "2834"
      }, {
        "item" : "2024",
        "count" : "1917"
      }, {
        "item" : "2019",
        "count" : "439"
      }, {
        "item" : "2018",
        "count" : "344"
      }, {
        "item" : "2017",
        "count" : "257"
      }, {
        "item" : "2015",
        "count" : "189"
      }, {
        "item" : "2016",
        "count" : "122"
      }, {
        "item" : "2026",
        "count" : "91"
      }, {
        "item" : "2014",
        "count" : "52"
      }, {
        "item" : "2012",
        "count" : "52"
      } ],
      "smallest" : "2012",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 15081073,
    "name" : "ImportNet",
    "dataTypeName" : "number",
    "description" : "Import net acumulat per ens, exercici i tipus d’ajut",
    "fieldName" : "importnet",
    "position" : 9,
    "renderTypeName" : "number",
    "tableColumnId" : 9595738,
    "cachedContents" : {
      "non_null" : "28544",
      "largest" : "3394873.62",
      "null" : "0",
      "top" : [ {
        "item" : "15000",
        "count" : "1629"
      }, {
        "item" : "72000",
        "count" : "821"
      }, {
        "item" : "9996.48",
        "count" : "604"
      }, {
        "item" : "9299.07",
        "count" : "581"
      }, {
        "item" : "150000",
        "count" : "513"
      }, {
        "item" : "13785.75",
        "count" : "359"
      }, {
        "item" : "13129.29",
        "count" : "355"
      }, {
        "item" : "35000",
        "count" : "316"
      }, {
        "item" : "48000",
        "count" : "201"
      }, {
        "item" : "222000",
        "count" : "172"
      }, {
        "item" : "100000",
        "count" : "156"
      }, {
        "item" : "18381",
        "count" : "133"
      }, {
        "item" : "17505.72",
        "count" : "130"
      }, {
        "item" : "7754.58",
        "count" : "129"
      }, {
        "item" : "9190.50",
        "count" : "65"
      }, {
        "item" : "8752.86",
        "count" : "65"
      }, {
        "item" : "6664.32",
        "count" : "63"
      }, {
        "item" : "23373.02",
        "count" : "62"
      }, {
        "item" : "6199.38",
        "count" : "61"
      }, {
        "item" : "478.9",
        "count" : "61"
      } ],
      "smallest" : "0",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 15081076,
    "name" : "Retenció",
    "dataTypeName" : "text",
    "description" : "Estat de retenció dels pagaments ",
    "fieldName" : "retenci",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 9595741,
    "cachedContents" : {
      "non_null" : "6262",
      "largest" : "Pagament retingut",
      "null" : "22282",
      "top" : [ {
        "item" : "Pagament retingut",
        "count" : "6262"
      } ],
      "smallest" : "Pagament retingut",
      "count" : "28544",
      "cardinality" : "28544"
    },
    "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ó" : "Mensual"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Obligations recognized pending payment to local authorities in relation to subsidies from the Secretariat of Local Administrations and Relations with Aran",
        "Nombre del conjunto de datos (ES)" : "Obligaciones reconocidas pendientes de pago a los entes locales en relación con las subvenciones de la Secretaría de Administraciones Locales y Relaciones con Aran"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Actors" : {
        "Departament" : "Presidència",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Nom 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" : [ "ens locals", "deute pendent", "subvencions", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}