{
  "id" : "nrmq-ytje",
  "name" : "Establiments sanitaris autoritzats a Catalunya",
  "assetType" : "dataset",
  "attribution" : "Departament de Salut",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Salut",
  "createdAt" : 1616410547,
  "description" : "Aquest conjunt de dades ofereix les dades identificatives, de localització i d'altres dades bàsiques dels establiments sanitaris autoritzats a Catalunya.\n\nUn establiment sanitari és un conjunt organitzat de mitjans tècnics i instal·lacions on els professionals capacitats, per la seva titulació oficial o habilitació professional, realitzen bàsicament activitats sanitàries de dispensació de medicaments o d’adaptació individual de productes sanitaris, segons el tipus d'establiment. Els tipus d'establiments són: audiopròtesi, farmàcia, farmaciola, òptica i ortopèdia.\n\nAquests establiments necessiten d’una autorització administrativa que atorga el Departament de Salut abans de la seva posada en funcionament o bé per a qualsevol modificació que vulguin realitzar, prèvia sol·licitud de l’entitat titular, per garantir que disposen dels requisits tecnicosanitaris comuns per a la seguretat i qualitat de l'assistència sanitària prestada, així com que reuneixen les condicions per a la protecció adequada dels drets dels pacients i per a l'efectiva i permanent disposició dels mitjans necessaris per desenvolupar, en condicions de seguretat i qualitat, la seva activitat.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1462,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 3032704,
  "provenance" : "official",
  "publicationAppendEnabled" : true,
  "publicationDate" : 1748334178,
  "publicationGroup" : 1370977,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1779845712,
  "rowsUpdatedBy" : "a4b5-gx6v",
  "tableId" : 2035428,
  "totalTimesRated" : 0,
  "viewCount" : 4975,
  "viewLastModified" : 1779845705,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1696489625,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1506600,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1696489625,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1696489625,
      "failureCount" : 0,
      "startedAt" : 1696489625,
      "status" : "success"
    },
    "submitter" : {
      "id" : "76mf-34jr",
      "displayName" : "Álex Artigas"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 26799350,
    "name" : "Número registre",
    "dataTypeName" : "text",
    "description" : "Codi de l’establiment",
    "fieldName" : "establiment_codi",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 12482840,
    "format" : { }
  }, {
    "id" : 26799351,
    "name" : "Nom establiment",
    "dataTypeName" : "text",
    "description" : "Nom de l’establiment",
    "fieldName" : "establiment_nom",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 12482847,
    "format" : { }
  }, {
    "id" : 26799352,
    "name" : "Codi tipus establiment",
    "dataTypeName" : "text",
    "description" : "Codi del tipus d’establiment",
    "fieldName" : "tipus_establiment_codi",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 12482866,
    "format" : { }
  }, {
    "id" : 26799353,
    "name" : "Tipus establiment",
    "dataTypeName" : "text",
    "description" : "Tipus d’establiment",
    "fieldName" : "tipus_establiment_nom",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 12482869,
    "format" : { }
  }, {
    "id" : 26799354,
    "name" : "Codi establiment pare",
    "dataTypeName" : "text",
    "description" : "Codi de l’establiment del qual aquest establiment depèn",
    "fieldName" : "establiment_pare_codi",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 12482859,
    "format" : { }
  }, {
    "id" : 26799355,
    "name" : "Titular",
    "dataTypeName" : "text",
    "description" : "Nom de la persona titular de l'establiment",
    "fieldName" : "titular_nom",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 12482838,
    "format" : { }
  }, {
    "id" : 26799356,
    "name" : "Telèfon",
    "dataTypeName" : "text",
    "description" : "Número de telèfon de l'establiment",
    "fieldName" : "telefon",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 12482871,
    "format" : { }
  }, {
    "id" : 26799357,
    "name" : "Codi tipus de via",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "tipus_via_codi",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 12482852,
    "format" : { }
  }, {
    "id" : 26799358,
    "name" : "Tipus de via",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "tipus_via_nom",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 12482844,
    "format" : { }
  }, {
    "id" : 26799359,
    "name" : "Nom de la via",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "via_nom",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 15423213,
    "format" : { }
  }, {
    "id" : 26799360,
    "name" : "Número de la via",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "numero_via",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 12482873,
    "format" : { }
  }, {
    "id" : 26799361,
    "name" : "Quilòmetre",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "quilometre",
    "position" : 12,
    "renderTypeName" : "text",
    "tableColumnId" : 12482863,
    "format" : { }
  }, {
    "id" : 26799362,
    "name" : "Bloc",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "bloc",
    "position" : 13,
    "renderTypeName" : "text",
    "tableColumnId" : 12482843,
    "format" : { }
  }, {
    "id" : 26799363,
    "name" : "Portal",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "portal",
    "position" : 14,
    "renderTypeName" : "text",
    "tableColumnId" : 12482842,
    "format" : { }
  }, {
    "id" : 26799364,
    "name" : "Escala",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "escala",
    "position" : 15,
    "renderTypeName" : "text",
    "tableColumnId" : 12482841,
    "format" : { }
  }, {
    "id" : 26799365,
    "name" : "Pis",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "pis",
    "position" : 16,
    "renderTypeName" : "text",
    "tableColumnId" : 12482862,
    "format" : { }
  }, {
    "id" : 26799366,
    "name" : "Porta",
    "dataTypeName" : "text",
    "description" : "Component de l'adreça de l'establiment",
    "fieldName" : "porta",
    "position" : 17,
    "renderTypeName" : "text",
    "tableColumnId" : 12482848,
    "format" : { }
  }, {
    "id" : 26799367,
    "name" : "Codi postal",
    "dataTypeName" : "text",
    "description" : "Codi postal corresponent a l’adreça de l'establiment",
    "fieldName" : "codi_postal",
    "position" : 18,
    "renderTypeName" : "text",
    "tableColumnId" : 12482846,
    "format" : { }
  }, {
    "id" : 26799368,
    "name" : "Codi municipi",
    "dataTypeName" : "text",
    "description" : "Codi del municipi on és l'establiment",
    "fieldName" : "municipi_codi",
    "position" : 19,
    "renderTypeName" : "text",
    "tableColumnId" : 12482872,
    "format" : { }
  }, {
    "id" : 26799369,
    "name" : "Municipi",
    "dataTypeName" : "text",
    "description" : "Nom del municipi on és l'establiment",
    "fieldName" : "municipi_nom",
    "position" : 20,
    "renderTypeName" : "text",
    "tableColumnId" : 12482858,
    "format" : { }
  }, {
    "id" : 26799370,
    "name" : "Article municipi",
    "dataTypeName" : "text",
    "description" : "Article del nom del municipi on és l'establiment",
    "fieldName" : "municipi_article",
    "position" : 21,
    "renderTypeName" : "text",
    "tableColumnId" : 12482855,
    "format" : { }
  }, {
    "id" : 26799371,
    "name" : "Codi comarca",
    "dataTypeName" : "text",
    "description" : "Codi de la comarca on és l'establiment",
    "fieldName" : "comarca_codi",
    "position" : 22,
    "renderTypeName" : "text",
    "tableColumnId" : 12482865,
    "format" : { }
  }, {
    "id" : 26799372,
    "name" : "Comarca",
    "dataTypeName" : "text",
    "description" : "Nom de la comarca on és l'establiment",
    "fieldName" : "comarca_nom",
    "position" : 23,
    "renderTypeName" : "text",
    "tableColumnId" : 12482860,
    "format" : { }
  }, {
    "id" : 26799373,
    "name" : "Codi província",
    "dataTypeName" : "text",
    "description" : "Codi de la província on és l'establiment",
    "fieldName" : "provincia_codi",
    "position" : 24,
    "renderTypeName" : "text",
    "tableColumnId" : 12482845,
    "format" : { }
  }, {
    "id" : 26799374,
    "name" : "Província",
    "dataTypeName" : "text",
    "description" : "Nom de la província on és l'establiment",
    "fieldName" : "provincia_nom",
    "position" : 25,
    "renderTypeName" : "text",
    "tableColumnId" : 12482867,
    "format" : { }
  }, {
    "id" : 26799375,
    "name" : "Codi ABS",
    "dataTypeName" : "text",
    "description" : "Codi de l’àrea bàsica de salut on és l’establiment",
    "fieldName" : "abs_codi",
    "position" : 26,
    "renderTypeName" : "text",
    "tableColumnId" : 12482857,
    "format" : { }
  }, {
    "id" : 26799377,
    "name" : "ABS",
    "dataTypeName" : "text",
    "description" : "Nom de l’àrea bàsica de salut on és l’establiment",
    "fieldName" : "abs_nom",
    "position" : 28,
    "renderTypeName" : "text",
    "tableColumnId" : 12482856,
    "format" : { }
  }, {
    "id" : 26799379,
    "name" : "Codi sector sanitari",
    "dataTypeName" : "text",
    "description" : "Codi del sector sanitari on és l'establiment",
    "fieldName" : "sector_sanitari_codi",
    "position" : 30,
    "renderTypeName" : "text",
    "tableColumnId" : 15149167,
    "format" : { }
  }, {
    "id" : 26799380,
    "name" : "Sector sanitari",
    "dataTypeName" : "text",
    "description" : "Nom del sector sanitari on és l’establiment",
    "fieldName" : "sector_sanitari_nom",
    "position" : 31,
    "renderTypeName" : "text",
    "tableColumnId" : 12482870,
    "format" : { }
  }, {
    "id" : 26799381,
    "name" : "Codi regió sanitària",
    "dataTypeName" : "text",
    "description" : "Codi de la regió sanitària on és l'establiment",
    "fieldName" : "regio_sanitaria_codi",
    "position" : 32,
    "renderTypeName" : "text",
    "tableColumnId" : 12482861,
    "format" : { }
  }, {
    "id" : 26799382,
    "name" : "Regió sanitària",
    "dataTypeName" : "text",
    "description" : "Nom de la regió sanitària on és l'establiment",
    "fieldName" : "regio_sanitaria_nom",
    "position" : 33,
    "renderTypeName" : "text",
    "tableColumnId" : 12482851,
    "format" : { }
  }, {
    "id" : 26799383,
    "name" : "Longitud",
    "dataTypeName" : "number",
    "description" : "Coordenada geogràfica",
    "fieldName" : "longitud",
    "position" : 34,
    "renderTypeName" : "number",
    "tableColumnId" : 12482868,
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 26799384,
    "name" : "Latitud",
    "dataTypeName" : "number",
    "description" : "Coordenada geogràfica",
    "fieldName" : "latitud",
    "position" : 35,
    "renderTypeName" : "number",
    "tableColumnId" : 12482874,
    "format" : {
      "noCommas" : "true"
    }
  }, {
    "id" : 26799385,
    "name" : "Georeferència",
    "dataTypeName" : "point",
    "description" : "Coordenades geogràfiques",
    "fieldName" : "georeferencia",
    "position" : 36,
    "renderTypeName" : "point",
    "tableColumnId" : 15716267,
    "format" : { }
  }, {
    "id" : 26799391,
    "name" : "Servei SPD",
    "dataTypeName" : "checkbox",
    "description" : "Identifica les farmàcies que presten el servei “Seguiment farmacoterapèutic amb sistemes personalitzats de dosificació (SPD)”",
    "fieldName" : "servei_spd",
    "position" : 37,
    "renderTypeName" : "checkbox",
    "tableColumnId" : 16233050,
    "format" : { }
  }, {
    "id" : 26799388,
    "name" : "Comarques SHP 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Comarques SHP' (rv9j-wcg6) the point in column 'georefer_ncia' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_rv9j_wcg6",
    "position" : 41,
    "renderTypeName" : "number",
    "tableColumnId" : 15716268,
    "computationStrategy" : {
      "source_columns" : [ "georeferencia" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_rv9j-wcg6",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 26799389,
    "name" : "LIMADM_MUNICIPI 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'LIMADM_MUNICIPI' (bh64-c7uy) the point in column 'georefer_ncia' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_bh64_c7uy",
    "position" : 42,
    "renderTypeName" : "number",
    "tableColumnId" : 15716269,
    "computationStrategy" : {
      "source_columns" : [ "georeferencia" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_bh64-c7uy",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 26799390,
    "name" : "LIMADM COMARCA 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'LIMADM COMARCA' (wvic-k925) the point in column 'georefer_ncia' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_wvic_k925",
    "position" : 43,
    "renderTypeName" : "number",
    "tableColumnId" : 15716270,
    "computationStrategy" : {
      "source_columns" : [ "georeferencia" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_wvic-k925",
        "primary_key" : "_feature_id"
      }
    },
    "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)" : "Authorized health establishments in Catalonia",
        "Nombre del conjunto de datos (ES)" : "Establecimientos sanitarios autorizados en Cataluña"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Actors" : {
        "Departament" : "Salut",
        "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" : [ "salut", "establiment sanitari" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}