The rural depopulation in the province of Valladolid: press analysis

<br>The Excel database is part of a study that addresses the treatment of rural generalist journalism on the abandonment of the countryside in a Spanish province (Valladolid). Based on the global data presented here, a content analysis of 226 journalistic pieces from two digital newspapers was carried out: El Norte de Castilla digital (the only regional newspaper in the autonomous community to which Valladolid belongs) and El Día de Valladolid digital (the strictly local newspaper) in order to detect causes, consequences and solutions provided in journalism on the rural exodus from economic, political, socio-cultural and environmental parameters. The main objectives of the study were twofold. On the one hand, to find out how rural journalism deals with the abandonment of the countryside for Valladolid's readers. Two secondary objectives were derived from this objective: (1) To find out what are the causes, consequences and solutions provided by rural journalism on the exodus from the countryside to the citizens of the province of Valladolid; and (2) To find out what is the professional practice of rural journalism on the abandonment of the countryside. On the other hand, the second main objective was to establish proposals for improvement in rural journalism in order to facilitate its professional practice and contribute in some way to solving the problem of rural depopulation. The data were collected between 1 February and 30 November 2023. In addition to the two aforementioned digital newspapers, the data include those of four specialised digital agricultural magazines: ‘Empresa agraria’, ‘Campo.es’, ‘Tierras.Agricultura’ and ‘Agronews Castilla y León’. It should be noted that, once all the data had been incorporated, several transformations were carried out with the PowerQuery Editor tool, which allowed the data to be positioned in an appropriate way in order to subsequently generate dynamic tables in Excel.