A data journey pt 2: from collecting to publishing

In the second part of the journey we are taking with our data, we will look at the efforts to make the data ready for publication.

Collect data from IHHD

After the initial contact from the team in the Institute for Health and Human Development (IHHD), we met them in person to collect the data on a CD.

We were talked through the data, shown it open in SPSS, and given information on how to get the documentation. What struck us was how useful the documentation could be. We were eager to get access to the field manual, as it sounded like it could be useful as a stand alone document.

Examine data and check for identifiers

Once we had the data files back in the office, we opened each one in SPSS to check it was valid. We also checked to make sure we were not publishing any identifiers which would compromise the anonymity of the participants.

This can be a complicated process with SPSS files. The data was split into many different files for different types of processing. Printing off a check sheet for every file in the collection (data and documentation) helps.

At this stage we created a record in our test EPrints repository. This allowed us to show the project team what was needed and how it would be arranged.

Translate/Get access to correct documentation

The documentation we were given, while being very full, was written in two local Indian languages (both spoken by many millions of people). These languages do no use the Latin alphabet that English uses, so additional font files were needed to read them in word format.

As our PCs are locked down by IT (and installing fonts requires admin privileges) this was not a trivial task. It was something we did not think of at all when planning how the ingest process would work. If others are going to be working with international data, language documentation/data issues could be a real problem.

Confirm metadata and other details are correct with all contributors

We had to contact all of the contributors to confirm that they were happy with the metadata, the files uploaded, the wording or various parts of the abstract/metadata. This was again not something we had planned for. While the PI might be happy with when they’ve given us, there were many people to go through to make sure we were doing everything correctly. This could be the case for all larger teams, different members have different responsibilities and will need to be contacted to make sure we are describing their contribution correctly.

This took time as they are not all in the same time zone, or working on the project anymore.

Publish and mint DOI

Once everyone in the project team was happy with the data, we could move the record from our test server, to our live server.

We made the record live on the 23rd of March 2015 and minted a DOI at the time (http://dx.doi.org/10.15123/DATA.4). 

Summary 

When depositing data like this in a repository there are bound to be issues you can’t predict as you go along. We’ve learned from this experience, and will use it in future as an example for others within UEL.

Our experience also highlights in need for good relationships with the researchers, and how much self depositing could smooth the process.

Advertisements

A data journey pt 1: from conception to completion

We’re delighted to make available our first research data collection on data.uel. It involved a major survey to demonstrate the take up of healthcare services in one Indian state, compared to another state and to the situation several years earlier. The dataset and associated documentation is available at http://dx.doi.org/10.15123/DATA.4. The project was led by Mala Rao OBE, until recently Professor of International Health in the Institute of Health and Human Development (IHHD) at UEL.

The project was a major international collaboration with contributors from the Administrative Staff College of India (Hyderabad), ACCESS Health International (Hyderabad), SughaVazhvu Healthcare (Thanjavur), Indian School of Business (Hyderabad) and the Development Research Group (DECRG) of The World Bank, Washington, DC as well as colleagues in IHHD. Funding came from Canada (International Development Research Centre), UK (Wellcome Trust and Department for International Development), USA (Rockefeller Foundation) and from the World Bank. Professor Rao wrote a detailed guide to the contributions made to the study in a BMJ Open article reporting on the results:

[Mala Rao] conceived and designed the study, applied for funding, and was responsible for the supervision and management of all aspects of the study as well as the dissemination of its results. She is the guarantor. [Sofi Bergkvist] shared responsibility for the conception of the study, applications for funding, study design and data collation and analysis, contributed to the questionnaire design and commented on drafts of the report. [Prabal V Singh] contributed to the conception of the study and study design, led the questionnaire design and survey implementation, including training of survey staff, monitoring survey progress and data collation and verification, commented on drafts of the report and helped prepare the references. [Anuradha Katyal] undertook the data collation, verification and analysis, assisted with the survey and questionnaire design and survey implementation and prepared the tables for the report. [Amit Samarth] led the literature review, assisted with the study and questionnaire design, survey implementation and preparation and analysis of baseline data, and commented on drafts of the report. [Manjusha Kancharla] helped with the data analysis. [Adam Wagstaff] devised the methodology for the estimation of the programme impacts, advised during the data-collection and data-preparation stages, wrote and implemented the computer code for the model estimation, helped to oversee the production of the results, and contributed text to the report. [Gopalakrishnan Netuveli] provided technical advice on accounting for the complex survey structure in the analysis, developed a STATA equation, helped to compute an asset index, advised on the output tables, verified the analysis and commented on drafts of the report. [Adrian Renton] helped develop a conceptual framework for the evaluation, advised on funding proposals, the study design, analytical methodology and presentation of results and contributed text to the report. [Mala Rao] wrote the first draft of the paper and its redrafts in accordance with the comments of all other authors and reviewers.

It must have been a major undertaking to organise and coordinate research activity on three continents, with concurrent surveys in two Indian states. The data in http://dx.doi.org/10.15123/DATA.4 is available as an SPSS zip file in .SAV format. It comes with extensive documentation: for each of the two states (Andhra Pradesh and Maharashtra) there is

  • Field training manual (detailing how to conduct household surveys in rural areas)
  • Bilingual household listing schedule
  • Household survey tool (the questions asked in the survey)
  • Code book of values encoded in SPSS

In addition, we have linked the data to several publications based on it, as well as to the baseline data from an earlier government survey:

  1. Rao, Mala and Katyal, Anuradha and Singh, Prabal V. and Samarth, Amit and Bergkvist, Sofi and Kancharla, Manjusha and Wagstaff, Adam and Netuveli, Gopalakrishnan and Renton, Adrian (2014) ‘Changes in addressing inequalities in access to hospital care in Andhra Pradesh and Maharashtra states of India: a difference-in-differences study using repeated cross-sectional surveys’, BMJ Open, 4(6), e004471. (10.1136/bmjopen-2013-004471).
  2. Narasimhan, H. and Boddu, V. and Singh, Prabal V. and Katyal, Anuradha and Bergkvist, Sofi and Rao, Mala (2014) ‘The Best Laid Plans: Access to the Rajiv Aarogyasri community health insurance scheme of Andhra Pradesh’, Health, Culture and Society, 6(1) (10.5195/hcs.2014.163).
  3. Bergkvist, Sofi and Wagstaff, Adam and Katyal, Anuradha and Singh, Prabal V. and Samarth, Amit and Rao, Mala (2014) What a difference a state makes: health reform in Andhra Pradesh. Working Paper. New York: World Bank. Available at http://documents.worldbank.org/curated/en/2014/05/19546767/difference-state-makes-health-reform-andhra-pradesh.
  4. Katyal, A., Singh, P. V., Samarth, A., Bergkvist, S., & Rao, M. (2013) ‘Using the Indian National Sample Survey data in public health research’, National Medical Journal of India, 26(5), pp. 291-294. Available at http://www.nmji.in/Volume-26-Issue-5.asp.
  5. Rao, M., Ramachandra, S. S., Bandyopadhyay, S., Chandran, A., Shidhaye, R., Tamisettynarayana, S., Thippaiah, A.,  Sitamma M., Sunil George, M., Singh, V. Sivasakaran, S. and Bangdiwala, S. I. (2011) ‘Addressing healthcare needs of people living below the poverty line: A rapid assessment of the Andhra Pradesh Health Insurance Scheme’, National Medical Journal of India, 24(6), pp. 335-341. Available at http://www.nmji.in/Volume-24-Issue-6.asp.
  6. National Sample Survey Office (2004) ‘Survey on MORBIDITY AND HEALTH CARE: NSS 60th Round : January 2004 – June 2004’, [dataset] New Delhi: MOSPI, 2004. Available at http://mail.mospi.gov.in/index.php/catalog/138.

In the next part of this Data Journey, David will talk about the work involved in archiving and publishing this data collection.