{ "id" : "jzx6-bqke", "name" : "Població estrangera resident a Catalunya per país de nacionalitat", "assetType" : "dataset", "attribution" : "Institut d'Estadística de Catalunya (IDESCAT)", "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/", "averageRating" : 0, "category" : "Societat-benestar", "createdAt" : 1582705129, "description" : "Llistat dels països i quantitat de residents estrangers a Catalunya, per país. Les dades comencen l'any 200.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 1667, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "SEE_TERMS_OF_USE", "locked" : false, "newBackend" : true, "numberOfComments" : 0, "oid" : 2114678, "provenance" : "official", "publicationAppendEnabled" : false, "publicationDate" : 1625739222, "publicationGroup" : 1111225, "publicationStage" : "published", "rowsUpdatedAt" : 1648044126, "rowsUpdatedBy" : "a4b5-gx6v", "tableId" : 1437303, "totalTimesRated" : 0, "viewCount" : 2848, "viewLastModified" : 1744021132, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1585217352, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 950121, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1585217352, "targetAudience" : "public", "workflowId" : 182, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "endedAt" : 1585217352, "failureCount" : 0, "startedAt" : 1585217352, "status" : "success" }, "submitter" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 19748872, "name" : "Any", "dataTypeName" : "number", "description" : "Anualitat", "fieldName" : "any", "position" : 1, "renderTypeName" : "number", "tableColumnId" : 8873835, "cachedContents" : { "non_null" : "4010", "largest" : "2021", "null" : "0", "top" : [ { "item" : "2021", "count" : "211" }, { "item" : "2020", "count" : "193" }, { "item" : "2019", "count" : "190" }, { "item" : "2018", "count" : "186" }, { "item" : "2006", "count" : "184" }, { "item" : "2005", "count" : "184" }, { "item" : "2016", "count" : "184" }, { "item" : "2017", "count" : "183" }, { "item" : "2015", "count" : "182" }, { "item" : "2011", "count" : "182" }, { "item" : "2004", "count" : "181" }, { "item" : "2003", "count" : "181" }, { "item" : "2013", "count" : "180" }, { "item" : "2009", "count" : "180" }, { "item" : "2014", "count" : "180" }, { "item" : "2012", "count" : "179" }, { "item" : "2008", "count" : "178" }, { "item" : "2007", "count" : "178" }, { "item" : "2010", "count" : "178" }, { "item" : "2002", "count" : "176" } ], "smallest" : "2000", "count" : "4010", "cardinality" : "22" }, "format" : { "noCommas" : "true" } }, { "id" : 19748876, "name" : "Codi País", "dataTypeName" : "text", "description" : "Codi del país d'origen", "fieldName" : "codi_pa_s", "position" : 2, "renderTypeName" : "text", "tableColumnId" : 13127703, "cachedContents" : { "non_null" : "3879", "largest" : "ZWE", "null" : "131", "top" : [ { "item" : "URY", "count" : "22" }, { "item" : "CPV", "count" : "22" }, { "item" : "SOM", "count" : "22" }, { "item" : "TZA", "count" : "22" }, { "item" : "MDG", "count" : "22" }, { "item" : "GMB", "count" : "22" }, { "item" : "VEN", "count" : "22" }, { "item" : "PRY", "count" : "22" }, { "item" : "COG", "count" : "22" }, { "item" : "CUB", "count" : "22" }, { "item" : "HUN", "count" : "22" }, { "item" : "AUT", "count" : "22" }, { "item" : "IRL", "count" : "22" }, { "item" : "NLD", "count" : "22" }, { "item" : "ISR", "count" : "22" }, { "item" : "GBR", "count" : "22" }, { "item" : "CAF", "count" : "22" }, { "item" : "MMR", "count" : "22" }, { "item" : "EST", "count" : "22" }, { "item" : "BEL", "count" : "22" } ], "smallest" : "AFG", "count" : "4010", "cardinality" : "203" }, "format" : { } }, { "id" : 19748874, "name" : "Nacionalitat", "dataTypeName" : "text", "description" : "Nom del país d'origen", "fieldName" : "nacionalitat", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 8873837, "cachedContents" : { "non_null" : "4010", "largest" : "Zimbabwe", "null" : "0", "top" : [ { "item" : "Austràlia", "count" : "25" }, { "item" : "Regne Unit", "count" : "24" }, { "item" : "Estats Units d'Amèrica", "count" : "23" }, { "item" : "Noruega", "count" : "23" }, { "item" : "França", "count" : "23" }, { "item" : "Lituània", "count" : "22" }, { "item" : "Sudan", "count" : "22" }, { "item" : "Armènia", "count" : "22" }, { "item" : "Egipte", "count" : "22" }, { "item" : "Bolívia", "count" : "22" }, { "item" : "Eslovènia", "count" : "22" }, { "item" : "Nicaragua", "count" : "22" }, { "item" : "Suècia", "count" : "22" }, { "item" : "Nigèria", "count" : "22" }, { "item" : "Marroc", "count" : "22" }, { "item" : "Mali", "count" : "22" }, { "item" : "Gàmbia", "count" : "22" }, { "item" : "Etiòpia", "count" : "22" }, { "item" : "Costa Rica", "count" : "22" }, { "item" : "Nepal", "count" : "22" } ], "smallest" : "Afganistan", "count" : "4010", "cardinality" : "229" }, "format" : { } }, { "id" : 19748875, "name" : "Població", "dataTypeName" : "text", "description" : "Quanitat de residents a Catalunya", "fieldName" : "poblaci", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 8873834, "cachedContents" : { "non_null" : "4010", "largest" : "9997", "null" : "0", "top" : [ { "item" : "<4", "count" : "428" }, { "item" : "4", "count" : "84" }, { "item" : "5", "count" : "73" }, { "item" : "7", "count" : "70" }, { "item" : "6", "count" : "57" }, { "item" : "9", "count" : "52" }, { "item" : "8", "count" : "42" }, { "item" : "10", "count" : "40" }, { "item" : "11", "count" : "37" }, { "item" : "13", "count" : "34" }, { "item" : "12", "count" : "31" }, { "item" : "14", "count" : "28" }, { "item" : "16", "count" : "23" }, { "item" : "17", "count" : "21" }, { "item" : "22", "count" : "21" }, { "item" : "18", "count" : "21" }, { "item" : "15", "count" : "19" }, { "item" : "61", "count" : "19" }, { "item" : "19", "count" : "15" }, { "item" : "62", "count" : "14" } ], "smallest" : "0", "count" : "4010", "cardinality" : "1867" }, "format" : { } } ], "grants" : [ { "inherited" : false, "type" : "viewer", "flags" : [ "public" ] } ], "license" : { "name" : "See Terms of Use" }, "metadata" : { "jsonQuery" : { "order" : [ { "columnFieldName" : "any", "ascending" : false }, { "columnFieldName" : "codi_pa_s", "ascending" : true } ] }, "custom_fields" : { "Freqüència d'actualització" : { "Freqüència d'actualització" : "Anual" }, "Idioma" : { "Idioma" : "Català", "Dataset name (EN)" : "Foreign population resident in Catalonia by country of nationality", "Nombre del conjunto de datos (ES)" : "Población extranjera residente en Cataluña por país de nacionalidad" }, "Informació de gènere o sexe" : { "Informació de gènere o sexe" : "No" }, "Actors" : { "Departament" : "Economia i Finances", "Organisme o institució" : "IDESCAT", "Tipus actor" : "Generalitat de Catalunya" }, "Àmbit geogràfic" : { "Informació geogràfica" : "Codi d'element", "Àmbit geogràfic" : "Mundial" } }, "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" : 19748872, "type" : "column" } }, { "ascending" : true, "expression" : { "columnId" : 19748876, "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" : [ "estrangers", "residents", "idescat", "catalunya global", "ods10_reducció de les desigualtats" ], "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ] }