Countering Public Grant Fraud in Spain

Annex B. Full list of variables in the uncleaned dataset

 

Variable	Short description	Additional variable description, if needed	Type
ADMINISTRACION_ANTE	Administration unit	What is the administration unit is providing the call	character
DEPARTAMENTO_ANT	Department	Which department is providing the call	character
ORGANO_ANTE	Body	Which official body is providing the call	character
ADMINISTRACION	Administration unit	Which administration unit is providing the call	character
DEPARTAMENTO	Department	Which department is providing the call	character
ORGANO	Body	Which official body is providing the call	character
DIR3_CON710	Granting body	Identification of one or more competent bodies to resolve concessions of the call.	character
DIR3_ANTE_CON705	Organising body	Identification of the body opening the call	character
CON100	Call ID	Unique identifier of each call, automatically assigned by the computer system when registering the call in the BDNS	character
REF_EXTERNA	Call manager	Who is the manager of the call	character
DESC_CONV	Description of the call in Spanish	What is the description of call in Spanish	character
BASEDESC_CON250	Description of the regulatory bases	Text of the title of the regulation that contains the regulatory bases for managing the call	character
BASEURL_CON260	Regulation URL	Link to the website that contains the full text in Spanish of the regulatory bases	character
ABIERTO_CON420	Open admission period	Indicates if the call keeps the application admission period open permanently	factor
INISOLICITUD_CON440	Application period start date	Starting date of the period enabled to admit requests	date
FINSOLICITUD_CON460	End date of the application period	End date of the period enabled to admit requests	date
AUDAESTADO_CON490	Condition of State Aid	Indicates if the aid of the call should be classified as ADE	factor
TIPOAYUDA_CON495	Type of ADE authorisation	Aid authorisation mechanism	factor
REGLAMENTO_CON502_50	Regulation of exemption by category of aid + Regulation of exemption by amount	EU Regulation exemption from the obligation of prior notification to the Commission by category of aid	factor
REFERENCIA_CON515	EU aid reference	Reference assigned by the EU as the aid identifier	character
FINALIDAD_CON540	Purpose	Public utility or social interest or promotion of a public purpose pursued with the granting of the subsidy	factor
FINJUSTIFICACION_CON600	Justification final date	Absolute end date of the deadline for submitting justifications for any concession	date
NOMINATIVA_CON610	Nominative grant	Nominative grant condition	factor
PUBLICABLE_CON620	Publication	Condition of publicity of the concessions	factor
IMPACTOGENERO_CON630	Gender impact	It rates the expected results in relation to the elimination of inequalities between women and men and the fulfilment of the equality policy objectives	factor
FECHA_ACTUALIZACION	Time at which a third party was updated in the database	What is the time at which a third party was updated in the database	date
PAIS_TER100	Third party country	Country that generates the identification of the third party	character
ID_TER110	Third party ID	Third party identifier	character
NOMBRE_TER210_240.x	Lastname + Business name	According to the information provided to the body obligated by the third party	character
PAISDOM_TER250	Country of third party	What is the country of the third party	factor
DOMICILIO_TER252	Address of the third party	What is the address of the third party	character
CODPOSTAL_TER254	Postal code of the third party	What is the postal code of the third party	character
PROVINCIA_TER258	Province of the third party	What is the province of the third party	character
MUNICIPIO_TER256	Municipality of the third party	What is the municipality of the third party	character
NATURALEZA_TER280	Legal nature of the third party	What is the legal nature of the third party	factor
TIPOBEN_TER290	Third party type	Cataloguing of third parties based on their legal nature and economic activity	factor
REGION_TER310	Region	Region in which the third party is established	character
ID_COS	Award ID	What is the unique identifier of award	character
TIPO_CONC_CSU204	Instrument	One of the legal or economic figures on the basis of which the grants and aid are awarded	factor
DISCRIMINADOR_CSU130	Discriminator	Grant award discriminator	character
OBJETIVOS_CSU205	Objective	Objective of the Aid Category Exemption Regulation	factor
DAT_COS_CSU210	Grant award date	Date of the resolution of the grant award	date
COSTE_ACT_CSU240	Costs	Amount of the fundable budget of the activity to which the grant award applies	numeric
IMPORTE_CONCE_CSU220	Amount awarded (grant)	Total amount committed in the grant award	numeric
AYUDA_EQUI_CSU250	Equivalent aid (grant)	Equivalent aid from grant award	numeric
REGION_CSU260	Region	Geographical location of the material application of the grant award	character
Year	Year of the award	Which year the award took place	date
CSU110	Announcement	Call identification	character
PAIS_CSU120	Beneficiary country	What is the country of beneficiary	factor
ID_CSU120	Beneficiary	Identification of the beneficiary	character
CSU130	Discriminator	Own reference of the granting body, free content, used to discriminate each grant award to the same beneficiary in the same call	character
DISCRIMINADOR_PAG110	Payment discriminator	Own reference of the granting body, free content, used to discriminate each payment of the same concession	character
FECHAPAGO_PAG210	Payment date (grant)	When the grant was paid	date
IMPORTE_PAG220	Amount paid (grant)	What is the amount of award	numeric
RETENCION_PAG230	Retention	Condition of tax withholding carried out	factor
PROYECTO_PRO130	Project ID	Project identification	character
DESCRIPCION_PRO210	Description	Project description	character
IMPORTEPROY220	Grant amount	Grant award amount allocated to the project	numeric
IMPORTEPROY230	Loan amount	Amount of the loan granted to the project	numeric
COSTE_PRO240	Project costs	Fundable cost of the project	numeric
AYUDA_PRO250	Equivalent aid (project)	Support equivalent to the project	numeric
REGION_PROY260	Region	Geographical location of the project	character
ANIO_EJE130	Year	Project execution year	date
EJE210	Grant amount	Amount of the grant award assigned to the executing agency in the year.	numeric
EJE220	Loan amount	Amount of the loan concession assigned to the executing agency in the year.	numeric
COSTE_EJE240	Costs	Aid equivalent to the project executor in the year	numeric
AYUDA_EJE250	Equivalent help (executor)	What is the amount of the help provided to executor	numeric
IDENTIFICADOR_EJE120	Executor ID	Identification of the executor	character
DISCRIMINADOR_REI110_1...8	Reimbursement discriminator	Own reference of the granting body, free content, used to discriminate each reimbursement procedure of the same beneficiary derived from the same grant	character
FECHADEV_REI210_1...8	Refund resolution date	Date of the resolution of the proceeding refund procedure	date
PRINCIPAL_REI230_1...8	Principal	Amount of refund	numeric
CAUSA_REI220_1...7	Causes	One or more of the causes that support the origin of the refund	factor
DISCRIMINADOR_DEV110	Return discriminator	Own reference of the granting body, free content, used to discriminate each voluntary return of one or more payments of the same concession	character
FECHADEV_DEV210	Return date	Date of the administrative resolution of acceptance of the return.	date
PRINCIPAL_DEV220	Amount of the principal of the return	Amount of the principal that the beneficiary returns without any resolution of repayment.	numeric
INTEERESES_DEV230	Amount of interest on the return	Amount of default interest calculated	numeric
CON550	Economic activities	One or more of the sectors of the economy foreseen in the call	factor
STRDESCRIPCION.x	Description of CON550	Description of variable CON550	character
DIARIO_CON310	Official journal of publication	Reference to the Official Gazette to which the extract of the call must be sent for publication	character
DESCRIPCION_CON335	Title in Spanish of the call	What is the Spanish title of the call	character
FECHA_CON351	Date of the signature of the call	When the call was signed	date
LOCALIDAD_CON352	Location of the signature footer of the call	Where the call was signed	character
PUBLI_CON390	Date of publication in the official gazette	When the call was published in the official gazette	date
URL_CON400	Reference in the official gazette of the extract in Spanish	What is the extract in official gazette in Spanish	character
CON560	Help instrument	One or more of the legal or economic figures on the basis of which the subsidies and aid are awarded	factor
STRDESCRIPCION.y	Description of CON560	The description of variable CON560	character
CON503	Objectives of the Aid Category Exemption Regulation	What are the objectives of the Aid Category Exemption Regulation	factor
STRDESCRIPCION_CON503	Description of CON503	Description of variable CON503	character
CON580	Types of beneficiary	One or more of the types of beneficiary foreseen in the call	factor
STRDESCRIPCION_CON580	Description of CON580	Description of variable CON580	character
CON570	Geographic regions	One or more geographical locations of the material application of the subsidy or aid provided for in the call	factor
STRDESCRIPCION_CON570	Description of CON570	Description of variable CON570	character
CON690	EU Fund financing amount	The amount of EU funds financial support	numeric
STRDESCRIPCION_CON690	Description of CON690	Description of variable CON560	character
STRVALOR	Type of EU financing institution	The EU financing institution	factor
DATSANC_1...3x	Date of sanction	When the sanction was imposed	date
STRDISCRIMINADOR_1...3x	Discriminator of the sanction	The organisation that is the discriminator of the sanction	character
MULTALEVE_SAN250_1...3x	Fine for minor infractions	The fine amount for minor infractions	numeric
MULTAGRAVE_SAN280_1...3x	Fine for serious infractions	The fine amount for serious infractions	numeric
MULTAMUYGRAVE_1...3x	Fine for very serious infractions	The fine amount for very serious infractions	numeric
PUBLICABLE_SAN440_1...3x	Condition of publicity of the sanction	Indicates whether the sanction should be public, according to art. 20.9 LGS	factor
LIMITE_SAN450_1...3x	Advertising deadline	What is the deadline for advertising	character
STRDESCRIPCION_SANC_1...3x	the description of STRVALOR value	Description of STRVALOR variable value	character
STRVALOR2_1...3x	Type of violation	Mild behaviours + Serious behaviours + Very serious behaviours	factor
ACTIVIDADES_TER320	Third party economic activities	What are the third party economic activity types	factor
DESC_ACTIVIDAD	Description of TER320	Description of values of TER320 variable	character