percepcion_social.encuesta_igualdad_2023

Microdata from the CIS (Centro de Investigaciones Sociológicas) special barometer on perceptions of equality between men and women (study 3428). Each row captures a single interview and preserves the full questionnaire content inside a JSON document while harmonizing the territorial identifiers used by the CIS. Analysts need to unnest or map those attributes to work with individual questions, and categorical labels remain in Spanish as provided by the CIS. A complete variable dictionary can be found at the source url.

• Time period: 6 November 2023
• Regional breakdown: Provincias

Columns

Name	Data Type	Is Nullable	Description
encuesta_igualdad_2023_id	serial	NO	Primary key
codigo_estudio	varchar(4)	NO	Four-digit CIS study code
fecha	date	NO	Date of the study
cuestionario	int	NO	Questionnaire number within the study
comunidad_autonoma_id	int	YES	Foreign key to geo.comunidades_autonomas
provincia_id	int	YES	Foreign key to geo.provincias
variables_json	jsonb	NO	Complete survey record serialized as JSON, including all original columns and value labels

Table definition

CREATE TABLE
  percepcion_social.encuesta_igualdad_2023 (
    encuesta_igualdad_2023_id serial PRIMARY KEY,
    codigo_estudio varchar(4) NOT NULL CHECK (codigo_estudio ~ '^\d{4}$'),
    fecha date NOT NULL CHECK (fecha <= CURRENT_DATE),
    cuestionario int NOT NULL,
    comunidad_autonoma_id int REFERENCES geo.comunidades_autonomas (comunidad_autonoma_id),
    provincia_id int REFERENCES geo.provincias (provincia_id),
    variables_json jsonb NOT NULL
  );

Notable transformations

• The transformation script reads the original .sav file, converts categorical responses to strings, and serializes every interview as JSON to preserve all questionnaire variables.
• Territorial identifiers for autonomous communities and provinces are standardized through the shared normalization utilities before loading into the database.

Source

Data extracted from the CIS special barometer on equality between men and women (study 3428). Consulted on 10 June 2025.