{ "id" : "nrh4-jwrt", "name" : "Centres de promoció turística a l'exterior", "assetType" : "dataset", "attribution" : "Agència Catalana de Turisme", "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/", "averageRating" : 0, "category" : "Turisme", "createdAt" : 1576742582, "description" : "Informació i localització dels centres de promoció turística a l'exterior.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 1566, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "ODC_BY", "locked" : false, "newBackend" : true, "numberOfComments" : 0, "oid" : 1713753, "provenance" : "official", "publicationAppendEnabled" : false, "publicationDate" : 1588603191, "publicationGroup" : 1057071, "publicationStage" : "published", "rowsUpdatedAt" : 1588669620, "rowsUpdatedBy" : "a4b5-gx6v", "tableId" : 1152565, "totalTimesRated" : 0, "viewCount" : 3916, "viewLastModified" : 1758534571, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1576742895, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 618672, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1576742895, "targetAudience" : "public", "workflowId" : 182, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "endedAt" : 1576742895, "failureCount" : 0, "startedAt" : 1576742895, "status" : "success" }, "submitter" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 14856680, "name" : "Departament", "dataTypeName" : "text", "description" : "Departament responsable del centre", "fieldName" : "departament", "position" : 1, "renderTypeName" : "text", "tableColumnId" : 8313590, "cachedContents" : { "non_null" : "12", "largest" : "Empresa i Coneixement", "null" : "0", "top" : [ { "item" : "Empresa i Coneixement", "count" : "12" } ], "smallest" : "Empresa i Coneixement", "count" : "12", "cardinality" : "1" }, "format" : { } }, { "id" : 14856681, "name" : "Unitat", "dataTypeName" : "text", "description" : "Nom del centre", "fieldName" : "unitat", "position" : 2, "renderTypeName" : "text", "tableColumnId" : 8313591, "cachedContents" : { "non_null" : "12", "largest" : "Catalan Tourist Board-Xina", "null" : "0", "top" : [ { "item" : "Catalan Tourist Board- Regne Unit i Irlanda", "count" : "1" }, { "item" : "Catalan Tourist Board-Nord-Amèrica", "count" : "1" }, { "item" : "Catalan Tourist Board- Europa Central", "count" : "1" }, { "item" : "Catalan Tourist Board-Xina", "count" : "1" }, { "item" : "Catalan Tourist Board- França", "count" : "1" }, { "item" : "Catalan Tourist Board-Sud-Amèrica", "count" : "1" }, { "item" : "Catalan Tourist Board- Itàlia i Israel", "count" : "1" }, { "item" : "Catalan Tourist Board-Rússia i Països de l'Est", "count" : "1" }, { "item" : "Catalan Tourist Board- Països nòrdics", "count" : "1" }, { "item" : "Catalan Tourist Board-Àsia-Pacífic", "count" : "1" }, { "item" : "Catalan Tourist Board-Benelux", "count" : "1" }, { "item" : "Catalan Tourist Board- Espanya i Portugal", "count" : "1" } ], "smallest" : "Catalan Tourist Board-Àsia-Pacífic", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856682, "name" : "Ciutat", "dataTypeName" : "text", "description" : "Ciutat on es troba el centre", "fieldName" : "ciutat", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 8313669, "cachedContents" : { "non_null" : "12", "largest" : "Singapur", "null" : "0", "top" : [ { "item" : "Madrid", "count" : "1" }, { "item" : "Paris", "count" : "1" }, { "item" : "Helsinki", "count" : "1" }, { "item" : "Sao Paulo", "count" : "1" }, { "item" : "Milà", "count" : "1" }, { "item" : "Beijing", "count" : "1" }, { "item" : "Londres", "count" : "1" }, { "item" : "New York", "count" : "1" }, { "item" : "Frankfurt", "count" : "1" }, { "item" : "Singapur", "count" : "1" }, { "item" : "Moscou", "count" : "1" }, { "item" : "Brussel·les", "count" : "1" } ], "smallest" : "Beijing", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856695, "name" : "Codi ISO país", "dataTypeName" : "text", "description" : "Codi ISO del país on es troba el centre", "fieldName" : "codi_iso_pa_s", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 8663677, "cachedContents" : { "non_null" : "12", "largest" : "USA", "null" : "0", "top" : [ { "item" : "BEL", "count" : "1" }, { "item" : "BRA", "count" : "1" }, { "item" : "RUS", "count" : "1" }, { "item" : "FRA", "count" : "1" }, { "item" : "GBR", "count" : "1" }, { "item" : "ITA", "count" : "1" }, { "item" : "CHN", "count" : "1" }, { "item" : "DEU", "count" : "1" }, { "item" : "ESP", "count" : "1" }, { "item" : "FIN", "count" : "1" }, { "item" : "USA", "count" : "1" }, { "item" : "SGP", "count" : "1" } ], "smallest" : "BEL", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856691, "name" : "Codi país", "dataTypeName" : "text", "description" : "Identificador INE del país", "fieldName" : "codi_pa_s", "position" : 5, "renderTypeName" : "text", "tableColumnId" : 8313600, "cachedContents" : { "non_null" : "12", "largest" : "432", "null" : "0", "top" : [ { "item" : "108", "count" : "1" }, { "item" : "115", "count" : "1" }, { "item" : "432", "count" : "1" }, { "item" : "126", "count" : "1" }, { "item" : "407", "count" : "1" }, { "item" : "125", "count" : "1" }, { "item" : "302", "count" : "1" }, { "item" : "110", "count" : "1" }, { "item" : "109", "count" : "1" }, { "item" : "342", "count" : "1" }, { "item" : "103", "count" : "1" }, { "item" : "154", "count" : "1" } ], "smallest" : "103", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856683, "name" : "País", "dataTypeName" : "text", "description" : "País on es troba el centre", "fieldName" : "pa_s", "position" : 6, "renderTypeName" : "text", "tableColumnId" : 8313592, "cachedContents" : { "non_null" : "12", "largest" : "Xina", "null" : "0", "top" : [ { "item" : "Finlàndia", "count" : "1" }, { "item" : "Bèlgica", "count" : "1" }, { "item" : "Rússia", "count" : "1" }, { "item" : "Brasil", "count" : "1" }, { "item" : "Estats Units d'Amèrica", "count" : "1" }, { "item" : "Espanya", "count" : "1" }, { "item" : "Xina", "count" : "1" }, { "item" : "Itàlia", "count" : "1" }, { "item" : "Singapur", "count" : "1" }, { "item" : "Regne Unit", "count" : "1" }, { "item" : "França", "count" : "1" }, { "item" : "Alemanya", "count" : "1" } ], "smallest" : "Alemanya", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856684, "name" : "Zona geogràfica", "dataTypeName" : "text", "description" : "Zona geogràfica on es troba el centre", "fieldName" : "zona_geogr_fica", "position" : 7, "renderTypeName" : "text", "tableColumnId" : 8313593, "cachedContents" : { "non_null" : "12", "largest" : "Sud-est asiàtic", "null" : "0", "top" : [ { "item" : "Europa", "count" : "5" }, { "item" : "Europa de l'Est", "count" : "1" }, { "item" : "Sudamèrica", "count" : "1" }, { "item" : "Nordamèrica", "count" : "1" }, { "item" : "Europa Central", "count" : "1" }, { "item" : "Sud-est asiàtic", "count" : "1" }, { "item" : "Àsia", "count" : "1" }, { "item" : "Països nòrdics", "count" : "1" } ], "smallest" : "Àsia", "count" : "12", "cardinality" : "8" }, "format" : { } }, { "id" : 14856685, "name" : "ADREÇA", "dataTypeName" : "text", "description" : "Adreça del centre", "fieldName" : "adre_a", "position" : 8, "renderTypeName" : "text", "tableColumnId" : 8313594, "cachedContents" : { "non_null" : "12", "largest" : "Wetstraat 227 Rue de la Loi, - 3ème étage", "null" : "0", "top" : [ { "item" : "Ludviginkatu 2-10", "count" : "1" }, { "item" : "Prospekt Vernadskogo, 97, korpus 3, office 64", "count" : "1" }, { "item" : "Capital Mansion, Room 1906 nº6, Xin Yuan Nan Rd. Chaoyang District", "count" : "1" }, { "item" : "655, Third Avenue - Suite 1830", "count" : "1" }, { "item" : "Palmengartenstrasse, 6", "count" : "1" }, { "item" : "133 Cecil Street – Keck Seng Tower Unit #08-02 / 02A", "count" : "1" }, { "item" : "50, Rue Saint Ferdinand", "count" : "1" }, { "item" : "Avda. Juscelino Kubitschek, 1726, 11° andar, conj. 111/112", "count" : "1" }, { "item" : "Via Montebello, 27", "count" : "1" }, { "item" : "17, Fleet Street - 3rd floor", "count" : "1" }, { "item" : "Wetstraat 227 Rue de la Loi, - 3ème étage", "count" : "1" }, { "item" : "Centre Cultural Blanquerna Alcalá, 44 - 4a planta", "count" : "1" } ], "smallest" : "133 Cecil Street – Keck Seng Tower Unit #08-02 / 02A", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856686, "name" : "CODI POSTAL", "dataTypeName" : "text", "description" : "Codi Postal de l'adreça", "fieldName" : "codi_postal", "position" : 9, "renderTypeName" : "text", "tableColumnId" : 8313595, "cachedContents" : { "non_null" : "12", "largest" : "SINGAPORE 069535", "null" : "0", "top" : [ { "item" : "60325 FRANKFURT AM MAIN", "count" : "1" }, { "item" : "LONDON EC4Y 1AA", "count" : "1" }, { "item" : "BRUSSEL·LES 1040", "count" : "1" }, { "item" : "28014 MADRID", "count" : "1" }, { "item" : "HÈLSINKI FIN-00130", "count" : "1" }, { "item" : "20121 MILÀ", "count" : "1" }, { "item" : "BEIJING 100004 XINA", "count" : "1" }, { "item" : "PARIS F-75017", "count" : "1" }, { "item" : "NEW YORK, NY 10017", "count" : "1" }, { "item" : "SAO PAULO 04543-000", "count" : "1" }, { "item" : "MOSCOU 119526", "count" : "1" }, { "item" : "SINGAPORE 069535", "count" : "1" } ], "smallest" : "20121 MILÀ", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856687, "name" : "Latitud", "dataTypeName" : "number", "description" : "Latitud expressada en graus decimals. Sistema de referència WGS84", "fieldName" : "lat", "position" : 10, "renderTypeName" : "number", "tableColumnId" : 8313596, "cachedContents" : { "non_null" : "0", "null" : "12", "count" : "12", "cardinality" : "0" }, "format" : { } }, { "id" : 14856688, "name" : "Longitud", "dataTypeName" : "number", "description" : "Longitud expressada en graus decimals. Sistema de referència WGS84", "fieldName" : "long", "position" : 11, "renderTypeName" : "number", "tableColumnId" : 8313597, "cachedContents" : { "non_null" : "3", "largest" : "918.854", "null" : "9", "top" : [ { "item" : "-370.379", "count" : "1" }, { "item" : "-0.118092", "count" : "1" }, { "item" : "918.854", "count" : "1" } ], "smallest" : "-370.379", "count" : "12", "cardinality" : "3" }, "format" : { } }, { "id" : 14856689, "name" : "TELÈFON", "dataTypeName" : "text", "description" : "Telèfon de contacte", "fieldName" : "tel_fon", "position" : 12, "renderTypeName" : "text", "tableColumnId" : 8313598, "cachedContents" : { "non_null" : "12", "largest" : "91 524 18 92", "null" : "0", "top" : [ { "item" : "44 2075 838 855", "count" : "1" }, { "item" : "0086 10 84 86 82 84", "count" : "1" }, { "item" : "39 02 87393573", "count" : "1" }, { "item" : "32 26 406 151", "count" : "1" }, { "item" : "7 499 749 7482", "count" : "1" }, { "item" : "+65 62204022", "count" : "1" }, { "item" : "+1 212 7823332", "count" : "1" }, { "item" : "91 524 18 92", "count" : "1" }, { "item" : "358 407 177 295", "count" : "1" }, { "item" : "+55 11 30530477", "count" : "1" }, { "item" : "49 69 7422 4873", "count" : "1" }, { "item" : "33 1 40 46 88 77", "count" : "1" } ], "smallest" : "0086 10 84 86 82 84", "count" : "12", "cardinality" : "12" }, "format" : { } }, { "id" : 14856690, "name" : "E-MAIL", "dataTypeName" : "text", "description" : "Correu electrònic de contacte", "fieldName" : "e_mail", "position" : 13, "renderTypeName" : "text", "tableColumnId" : 8313599, "cachedContents" : { "non_null" : "9", "largest" : "promotion.act.fr@gencat.cat", "null" : "3", "top" : [ { "item" : "info.act.usa@gencat.cat", "count" : "1" }, { "item" : "promotion.act.de@gencat.cat", "count" : "1" }, { "item" : "info.act.it@gencat.cat", "count" : "1" }, { "item" : "promotion.act.fr@gencat.cat", "count" : "1" }, { "item" : "info.act.saopaulo@gencat.cat", "count" : "1" }, { "item" : "promotion.act.bnl@gencat.cat", "count" : "1" }, { "item" : "info.act.esp@gencat.cat", "count" : "1" }, { "item" : "info.act.ru@gencat.cat", "count" : "1" }, { "item" : "ctb1.act.uk@gencat.cat", "count" : "1" } ], "smallest" : "ctb1.act.uk@gencat.cat", "count" : "12", "cardinality" : "9" }, "format" : { "displayStyle" : "email" } }, { "id" : 14856692, "name" : "Georeferència", "dataTypeName" : "point", "description" : "Columna de georeferència", "fieldName" : "geocoded_column", "position" : 14, "renderTypeName" : "point", "tableColumnId" : 8313601, "cachedContents" : { "non_null" : "0", "null" : "12", "count" : "12", "cardinality" : "0" }, "format" : { } }, { "id" : 14856693, "name" : "LIMADM_MUNICIPI", "dataTypeName" : "number", "description" : "", "fieldName" : ":@computed_region_bh64_c7uy", "position" : 15, "renderTypeName" : "number", "tableColumnId" : 8313602, "computationStrategy" : { "source_columns" : [ "geocoded_column" ], "type" : "georegion_match_on_point", "parameters" : { "region" : "_bh64-c7uy", "primary_key" : "_feature_id" } }, "format" : { } }, { "id" : 14856694, "name" : "LIMADM COMARCA", "dataTypeName" : "number", "description" : "", "fieldName" : ":@computed_region_wvic_k925", "position" : 16, "renderTypeName" : "number", "tableColumnId" : 8313603, "computationStrategy" : { "source_columns" : [ "geocoded_column" ], "type" : "georegion_match_on_point", "parameters" : { "region" : "_wvic-k925", "primary_key" : "_feature_id" } }, "format" : { } } ], "grants" : [ { "inherited" : false, "type" : "viewer", "flags" : [ "public" ] } ], "license" : { "name" : "Open Data Commons Attribution License", "termsLink" : "http://opendatacommons.org/licenses/by/1.0/" }, "metadata" : { "custom_fields" : { "Freqüència d'actualització" : { "Freqüència d'actualització" : "Variable" }, "Idioma" : { "Idioma" : "Català", "Dataset name (EN)" : "Tourist promotion centers abroad", "Nombre del conjunto de datos (ES)" : "Centros de promoción turística en el exterior" }, "Informació de gènere o sexe" : { "Informació de gènere o sexe" : "No aplicable" }, "Actors" : { "Departament" : "Empresa i Treball", "Tipus actor" : "Generalitat de Catalunya" }, "Àmbit geogràfic" : { "Informació geogràfica" : "Coordenades", "À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" : [ "centre", "delegació", "exterior", "turisme", "catalunya global", "ods8_treball decent i creixement econòmic" ], "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ] }