{ "id" : "c9ag-cye6", "name" : "Endeutament ens local", "assetType" : "dataset", "attribution" : "Consorci AOC via Ministeri d'Hisenda", "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/", "averageRating" : 0, "category" : "Sector Públic", "createdAt" : 1575979051, "description" : "Conjunt de dades que mostra l'evolució de l'endeutament de l'ens local, entenent-se per endeutament financer qualsevol quantitat determinada de diners, o la creació de disponibilitat creditícia, lliurada per un tercer (normalment una entitat financera), a l'entitat local, amb el compromís de retornar‐la en un termini establert mitjançant pagaments periòdics del principal més una retribució amb un tipus d’interès pactat.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 1353, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "SEE_TERMS_OF_USE", "locked" : false, "newBackend" : true, "numberOfComments" : 0, "oid" : 1574064, "provenance" : "official", "publicationAppendEnabled" : true, "publicationDate" : 1575979216, "publicationGroup" : 1052950, "publicationStage" : "published", "rowsUpdatedAt" : 1776739210, "rowsUpdatedBy" : "a4b5-gx6v", "tableId" : 1052950, "totalTimesRated" : 0, "viewCount" : 3879, "viewLastModified" : 1779590404, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1584347257, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 581733, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1584347257, "targetAudience" : "public", "workflowId" : 182, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "endedAt" : 1584347257, "failureCount" : 0, "startedAt" : 1584347257, "status" : "success" }, "submitter" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 13183181, "name" : "ANY", "dataTypeName" : "text", "description" : "", "fieldName" : "any", "position" : 1, "renderTypeName" : "text", "tableColumnId" : 8272082, "cachedContents" : { "non_null" : "14930", "largest" : "2024", "null" : "0", "top" : [ { "item" : "2019", "count" : "1002" }, { "item" : "2020", "count" : "1001" }, { "item" : "2018", "count" : "1001" }, { "item" : "2017", "count" : "1000" }, { "item" : "2016", "count" : "998" }, { "item" : "2023", "count" : "998" }, { "item" : "2024", "count" : "996" }, { "item" : "2013", "count" : "996" }, { "item" : "2021", "count" : "996" }, { "item" : "2014", "count" : "994" }, { "item" : "2010", "count" : "994" }, { "item" : "2011", "count" : "994" }, { "item" : "2012", "count" : "991" }, { "item" : "2022", "count" : "987" }, { "item" : "2015", "count" : "982" } ], "smallest" : "2010", "count" : "14930", "cardinality" : "14930" }, "format" : { } }, { "id" : 13183182, "name" : "DEUTE_VIU", "dataTypeName" : "number", "description" : "", "fieldName" : "deute_viu", "position" : 2, "renderTypeName" : "number", "tableColumnId" : 8272083, "cachedContents" : { "non_null" : "14930", "largest" : "1389567987.07", "null" : "0", "top" : [ { "item" : "0", "count" : "3972" }, { "item" : "200000", "count" : "18" }, { "item" : "300000", "count" : "16" }, { "item" : "40000", "count" : "16" }, { "item" : "16000", "count" : "16" }, { "item" : "60000", "count" : "15" }, { "item" : "75000", "count" : "15" }, { "item" : "50000", "count" : "15" }, { "item" : "98000", "count" : "14" }, { "item" : "9000", "count" : "14" }, { "item" : "17000", "count" : "14" }, { "item" : "150000", "count" : "14" }, { "item" : "7000", "count" : "14" }, { "item" : "220000", "count" : "13" }, { "item" : "71000", "count" : "13" }, { "item" : "100000", "count" : "13" }, { "item" : "85000", "count" : "13" }, { "item" : "102000", "count" : "13" }, { "item" : "54000", "count" : "12" }, { "item" : "13000", "count" : "12" } ], "smallest" : "0", "count" : "14930", "cardinality" : "14930" }, "format" : { "decimalSeparator" : ",", "noCommas" : "true", "precision" : "3", "groupSeparator" : "." } }, { "id" : 13183185, "name" : "CODI_ENS", "dataTypeName" : "text", "description" : "", "fieldName" : "codi_ens", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 8272086, "cachedContents" : { "non_null" : "14930", "largest" : "9013260009", "null" : "0", "top" : [ { "item" : "1700250006", "count" : "15" }, { "item" : "1700310007", "count" : "15" }, { "item" : "1700460009", "count" : "15" }, { "item" : "1700590004", "count" : "15" }, { "item" : "1700620002", "count" : "15" }, { "item" : "1700780001", "count" : "15" }, { "item" : "1700840003", "count" : "15" }, { "item" : "1700970005", "count" : "15" }, { "item" : "1701010007", "count" : "15" }, { "item" : "1701180001", "count" : "15" }, { "item" : "1701230008", "count" : "15" }, { "item" : "1701390004", "count" : "15" }, { "item" : "1701440003", "count" : "15" }, { "item" : "1701570005", "count" : "15" }, { "item" : "1701600000", "count" : "15" }, { "item" : "1701820002", "count" : "15" }, { "item" : "1701950006", "count" : "15" }, { "item" : "1702090004", "count" : "15" }, { "item" : "1702160009", "count" : "15" }, { "item" : "1700100000", "count" : "15" } ], "smallest" : "1700100000", "count" : "14930", "cardinality" : "14930" }, "format" : { } }, { "id" : 13183183, "name" : "NOM ENS", "dataTypeName" : "text", "description" : "", "fieldName" : "nom_ens", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 8272084, "cachedContents" : { "non_null" : "14930", "largest" : "Mancomunitat Tegar del Garraf", "null" : "0", "top" : [ { "item" : "Ajuntament d'Abrera", "count" : "15" }, { "item" : "Ajuntament d'Àger", "count" : "15" }, { "item" : "Ajuntament d'Agramunt", "count" : "15" }, { "item" : "Ajuntament d'Aguilar de Segarra", "count" : "15" }, { "item" : "Ajuntament d'Agullana", "count" : "15" }, { "item" : "Ajuntament d'Aiguafreda", "count" : "15" }, { "item" : "Ajuntament d'Aiguamúrcia", "count" : "15" }, { "item" : "Ajuntament d'Aiguaviva", "count" : "15" }, { "item" : "Ajuntament d'Aitona", "count" : "15" }, { "item" : "Ajuntament d'Alàs i Cerc", "count" : "15" }, { "item" : "Ajuntament d'Albanyà", "count" : "15" }, { "item" : "Ajuntament d'Albatàrrec", "count" : "15" }, { "item" : "Ajuntament d'Albesa", "count" : "15" }, { "item" : "Ajuntament d'Albinyana", "count" : "15" }, { "item" : "Ajuntament d'Albons", "count" : "15" }, { "item" : "Ajuntament d'Alcanar", "count" : "15" }, { "item" : "Ajuntament d'Alcanó", "count" : "15" }, { "item" : "Ajuntament d'Alcarràs", "count" : "15" }, { "item" : "Ajuntament d'Alcoletge", "count" : "15" }, { "item" : "Ajuntament d'Abella de la Conca", "count" : "15" } ], "smallest" : "Ajuntament d'Abella de la Conca", "count" : "14930", "cardinality" : "14930" }, "format" : { } }, { "id" : 13183184, "name" : "CENS", "dataTypeName" : "number", "description" : "", "fieldName" : "cens", "position" : 5, "renderTypeName" : "number", "tableColumnId" : 8272085, "cachedContents" : { "non_null" : "14929", "largest" : "5899063", "null" : "1", "top" : [ { "item" : "162", "count" : "29" }, { "item" : "167", "count" : "28" }, { "item" : "170", "count" : "27" }, { "item" : "188", "count" : "26" }, { "item" : "159", "count" : "26" }, { "item" : "178", "count" : "25" }, { "item" : "158", "count" : "25" }, { "item" : "173", "count" : "25" }, { "item" : "176", "count" : "25" }, { "item" : "202", "count" : "25" }, { "item" : "181", "count" : "24" }, { "item" : "187", "count" : "24" }, { "item" : "183", "count" : "24" }, { "item" : "175", "count" : "24" }, { "item" : "210", "count" : "23" }, { "item" : "155", "count" : "23" }, { "item" : "164", "count" : "23" }, { "item" : "171", "count" : "22" }, { "item" : "140", "count" : "22" }, { "item" : "168", "count" : "21" } ], "smallest" : "19", "count" : "14930", "cardinality" : "14930" }, "format" : { "decimalSeparator" : ",", "noCommas" : "true", "groupSeparator" : "." } } ], "grants" : [ { "inherited" : false, "type" : "viewer", "flags" : [ "public" ] } ], "license" : { "name" : "See Terms of Use" }, "metadata" : { "custom_fields" : { "Freqüència d'actualització" : { "Freqüència d'actualització" : "Anual" }, "Idioma" : { "Idioma" : "Català", "Dataset name (EN)" : "Local entity indebtedness", "Nombre del conjunto de datos (ES)" : "Endeudamiento ente local" }, "Informació de gènere o sexe" : { "Informació de gènere o sexe" : "No aplicable" }, "Actors" : { "Departament" : "Presidència", "Organisme o institució" : "Consorci AOC", "Tipus actor" : "Administració local" }, "Àmbit geogràfic" : { "À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" : [ "endeutament", "deute", "ens", "consorci aoc", "ods16_pau justícies i institucions sòlides" ], "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ] }