percepcion_social.encuesta_violencia_genero_juventud_2013

Microdata from the CIS barometer on perceptions of gender-based violence among adolescents and young people (study 2992). Each interview from the June 2013 fieldwork is preserved as JSON while aligning the territorial identifiers with the provinces catalogue. 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: 17 June 2013
• Regional breakdown: Provincias

Columns

Name	Data Type	Is Nullable	Description
encuesta_violencia_genero_juventud_2013_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 labels

Table definition

CREATE TABLE
  percepcion_social.encuesta_violencia_genero_juventud_2013 (
    encuesta_violencia_genero_juventud_2013_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 barometer on perceptions of gender-based violence among youth (study 2992). Consulted on 10 June 2025.