Generating Contextual Variables From Web-Based Data for Health Research: Tutorial on Web Scraping, Text Mining, and Spatial Overlay Analysis.

BACKGROUND: Contextual variables that capture the characteristics of delimited geographic or jurisdictional areas are vital for health and social research. However, obtaining data sets with contextual-level data can be challenging in the absence of monitoring systems or public census data. OBJECTIVE: We describe and implement an 8-step method that combines web scraping, text mining, and spatial overlay analysis (WeTMS) to transform extensive text data from government websites into analyzable data sets containing contextual data for jurisdictional areas. METHODS: This tutorial describes the method and provides resources for its application by health and social researchers. We used this method to create data sets of health assets aimed at enhancing older adults' social connections (eg, activities and resources such as walking groups and senior clubs) across the 374 health jurisdictions in Catalonia from 2015 to 2022. These assets are registered on a web-based government platform by local stakeholders from various health and nonhealth organizations as part of a national public health program. Steps 1 to 3 involved defining the variables of interest, identifying data sources, and using Python to extract information from 50,000 websites linked to the platform. Steps 4 to 6 comprised preprocessing the scraped text, defining new variables to classify health assets based on social connection constructs, analyzing word frequencies in titles and descriptions of the assets, creating topic-specific dictionaries, implementing a rule-based classifier in R, and verifying the results. Steps 7 and 8 integrate the spatial overlay analysis to determine the geographic location of each asset. We conducted a descriptive analysis of the data sets to report the characteristics of the assets identified and the patterns of asset registrations across areas. RESULTS: We identified and extracted data from 17,305 websites describing health assets. The titles and descriptions of the activities and resources contained 12,560 and 7301 unique words, respectively. After applying our classifier and spatial analysis algorithm, we generated 2 data sets containing 9546 health assets (5022 activities and 4524 resources) with the potential to enhance social connections among older adults. Stakeholders from 318 health jurisdictions registered identified assets on the platform between July 2015 and December 2022. The agreement rate between the classification algorithm and verified data sets ranged from 62.02% to 99.47% across variables. Leisure and skill development activities were the most prevalent (1844/5022, 36.72%). Leisure and cultural associations, such as social clubs for older adults, were the most common resources (878/4524, 19.41%). Health asset registration varied across areas, ranging between 0 and 263 activities and 0 and 265 resources. CONCLUSIONS: The sequential use of WeTMS offers a robust method for generating data sets containing contextual-level variables from internet text data. This study can guide health and social researchers in efficiently generating ready-to-analyze data sets containing contextual variables.

Primary care-based interventions addressing social isolation and loneliness in older people: a scoping review.

OBJECTIVES: Primary care is well positioned to identify and address loneliness and social isolation in older adults, given its gatekeeper function in many healthcare systems. We aimed to identify and characterise loneliness and social isolation interventions and detect factors influencing implementation in primary care. DESIGN: Scoping review using the five-step Arksey and O'Malley Framework. DATA SOURCES: MEDLINE, CINAHL, EMBASE, COCHRANE databases and grey literature were searched from inception to June 2021. ELIGIBILITY CRITERIA: Empirical studies in English and Spanish focusing on interventions addressing social isolation and loneliness in older adults involving primary care services or professionals. DATA EXTRACTION AND SYNTHESIS: We extracted data on loneliness and social isolation identification strategies and the professionals involved, networks and characteristics of the interventions and barriers to and facilitators of implementation. We conducted a thematic content analysis to integrate the information extracted. RESULTS: 32 documents were included in the review. Only seven articles (22%) reported primary care professionals screening of older adults' loneliness or social isolation, mainly through questionnaires. Several interventions showed networks between primary care, health and non-healthcare sectors, with a dominance of referral pathways (n=17). Two-thirds of reports did not provide clear theoretical frameworks, and one-third described lengths under 6 months. Workload, lack of interest and ageing-related barriers affected implementation outcomes. In contrast, well-defined pathways, collaborative designs, long-lasting and accessible interventions acted as facilitators. CONCLUSIONS: There is an apparent lack of consistency in strategies to identify lonely and socially isolated older adults. This might lead to conflicts between intervention content and participant needs. We also identified a predominance of schemes linking primary care and non-healthcare sectors. However, although professionals and participants reported the need for long-lasting interventions to create meaningful social networks, durable interventions were scarce. Sustainability should be a core outcome when implementing loneliness and social isolation interventions in primary care.

A Co-Design Process to Elaborate Educational Materials to Promote Appropriate Use of Antibiotics for Acute Lower Respiratory Tract Infections in Primary Healthcare in Catalonia (Spain).

PURPOSE: Co-design processes with patients allow developing health education materials, that are adapted to the population's knowledge and use of language, to reduce inappropriate antibiotic use. PATIENTS AND METHODS: This study presents a co-design process of educational material with patients (over 18 years old) with a previous diagnosis of acute lower respiratory tract infection. The co-design was framed within a qualitative study (Phase I, interviews; Phase II, focus group) conducted in Barcelona between April and September 2019. RESULTS: Twenty-nine semi-structured interviews were conducted. Six people participated in the focus group. Based on participants' narratives, educational materials can be useful to support healthcare consultations. Materials should be designed to be accessible in terms of the content and language used. CONCLUSION: The co-design of educational materials is essential for health promotion. This study presents an example of how materials can be co-developed with patients. The material elaborated in this study is being used for the ISAAC-CAT project and may be useful for future research, practice in health services and health policy.

Autonomy, power dynamics and antibiotic use in primary healthcare: A qualitative study.

Antibiotic resistance is a global health concern. Although numerous strategies have tried to reduce inadequate antibiotic prescribing, antibiotics are still prescribed in 60% of acute lower respiratory tract infections (ALRTIs) cases in Catalonia (Spain). This study aims to explore service users' experiences of ALRTIs, the quality and access to healthcare services, and health education. Selective purposive sampling was carried out, based on a prior definition of participant characteristics. These were sex, age, ethnicity, date of the last ALRTI, number of ALRTIs in the last year, and treatments received. Participants with a previous diagnosis of ALRTIs were recruited from three primary health care centres in Barcelona and one in Tarragona. Twenty-nine interviews were conducted between April and June 2019. A content thematic analysis was performed. Three themes were identified: 1) risk perceptions and help-seeking; 2) treatment preferences and antibiotic use; and 3) relationship dynamics and communication with healthcare professionals. Accounts of service users' sense of autonomy towards their health and power dynamics within the healthcare system were apparent. Supporting service users to become reliable, subjective and agentic experts of their health and bodies could help them to voice their healthcare agendas. Power structures embedded within healthcare, political and economic institutions should be challenged so that healthcare services can be co-developed (with service users) and based on service users' autonomy and horizontal relationships. Special consideration should be paid to the intersection of social vulnerabilities. A concordance approach to prescribing could be key to improve the responsible use of antibiotics and to contribute to the prevention of AMR in primary healthcare. The marketisation of health, and the increased demands of private healthcare in Spain due to the financial pressures on public healthcare as a consequence of the financial crisis of 2008 and the COVID-19 pandemic, are a risk for promoting adequate antibiotic prescribing and use. Trial registration The ISAAC-CAT study has been registered in the NCT registry, ID: NCT03931577.

Desarrollo de materiales educativos para pacientes crónicos y familiares / Development of educational materials for chronic patients and families

Un nivel bajo de alfabetización puede dificultar la comprensión de la información necesaria para tomar decisiones apropiadas en relación con la propia salud. Esta situación está relacionada con una peor adherencia a los tratamientos, un peor estado de bienestar y una mortalidad más elevada, sobre todo en personas de edad avanzada. Resulta esencial que la información pueda ser comprendida por el paciente y su familia. Este artículo tiene como objetivo presentar las recomendaciones internacionales existentes para el diseño y la elaboración de materiales o recursos educativos para pacientes crónicos y familiares. Se describen aspectos metodológicos que engloban la inclusión de los pacientes en distintos puntos durante el proceso de desarrollo del material, la adaptación del formato y el contenido al nivel de comprensión del paciente, así como su participación en una prueba piloto antes de la publicación de los mismos. Los materiales educativos que se han elaborado con la colaboración de los pacientes resultan más adaptados a su contexto y promueven cambios positivos en su salud

Low literacy can difficult the use of information needed to take appropriate decisions in healthcare. This situation is associated with poorer treatment adherence, lower health outcomes and higher mortality among the population and, specifically, the elderly. It is essential that information can be understood by patients and families. This article aims to present the existing international recommendations for the design and development of educational materials and resources to chronic patients and families. This process encompasses the involvement of patients at various levels during the development process of the materials, the adaptation of the format and content to the level of understanding of the patient as well as their participation in the evaluation process. Educational materials that have been developed in collaboration with patients are more adapted to their context and promote positive changes in their health