percepcion_social.encuesta_violencia_sexual_2017

Microdata from the CIS barometer on social perceptions of sexual violence (study 3182). Interviews conducted in July 2017 are consolidated into JSON documents to retain the full questionnaire while linking territories to 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: 5 July 2017
• Regional breakdown: Provincias

Columns

Name	Data Type	Is Nullable	Description
encuesta_violencia_sexual_2017_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_sexual_2017 (
    encuesta_violencia_sexual_2017_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 social perceptions of sexual violence (study 3182). Consulted on 11 June 2025.