Research to improve people's health


SIDIAP introduces new tables and search variables

The IDIAPJGol database continues to grow to offer researchers an increasingly wider and more accessible range of resources. The latest update includes new features such as consulting tables on health professionals, patients' family relationships, menopause or laboratory analysis units.


New lookup tables
  • Professionals. Pseudo-anonymized data that includes sex, age group, quota size, % of patients served and annual synthetic EQA and EQPF data for each professional assigned at an individual level since 2014.
  • Link families. Relationships between mothers/fathers and sons/daughters and types of bond that could have been generated (biological or administrative).
  • Menopause. It compacts all the information recorded in ECAP about menopause, establishing a reliable date that allows us to know since when a woman has been menopausal.
  • Laboratory Units. It incorporates the units used for each requested analytical variable (in addition to the information present in the catalog table).
Use the full potential: little-known tables that have been updated

In addition to the new tables, SIDIAP has updated data sets that until now went more unnoticed, but with significant potential for studies and research projects:

  • Frequencies. Summary of annual visits at the individual level. It makes work easier and avoids having to use the "visitors" table.
  • Census section movements. It includes movements between census sections since 2011 at the individual level. To use this table, patients must be grouped by age and sex groups.
  • Obstetric ultrasounds. All the information collected during the different ultrasounds performed during pregnancy is included in tables T1, T2 and T3.
  • Health card. It collects information on the type of patient's card (active, pensioner,...) and the group of guarantees to which their health card belongs.
  • Drug allergies. Collects information related to allergies caused by a medication (ATC).
  • Longitudinality. Includes information on indicators related to continuity of care.
  • Children's Health. They contain specific information about boys and girls (newborns, development, habits...).
The reference database

The SIDIAP (Information System for the development of Research in Primary Care) includes information on the Electronic medical history of Primary Care in Catalonia. It contains pseudo-anonymized longitudinal information from more than 7 million people, making it one of the most complete and up-to-date databases for health research in Europe.