Programmatic access to open statistical data for population studies: The SDMX standard

Frans Willekens
Additional contact information
Frans Willekens: Nederlands Interdisciplinair Demografisch Instituut (NIDI)

Demographic Research, 2023, vol. 49, issue 40, 1117-1162

Abstract: Background: The public sector publishes vast amounts of open data and metadata. APIs (application programming interfaces) are transforming the way data are collected, documented, and disseminated. The transformation is slow, however, due to differences in communication protocol, data definition, and data format. The development is of particular relevance to demography, being a data-intensive science. It paves the way to the automation of data acquisition and the integration of data acquisition and data analysis. Together with the parallel development of literate programming, which allows the integration of text and computer code in a single document, programmatic access to data makes workflows transparent, verifiable, and easy to replicate by others. The Statistical Data and Metadata Exchange (SDMX) standard, which has emerged as a popular option for data and metadata exchange, makes finding and retrieving data and metadata easy and swift. Query strings form URLs with a standardised syntax. Objective: The aim of this paper is to describe the SDMX standard and demonstrate its benefits to our profession by retrieving demographic data and the associated metadata from online databases disseminated by a variety of data providers. The software environment used is R. Contribution: This is the first review of the SDMX standard aimed at the study of population. The paper includes the R code to access databases and download data and metadata. The paper includes several hyperlinks to relevant documents issued by data providers, giving readers immediate access to the referenced material.

Keywords: dataset search; URL query builder; R code; open data; programmatic access; SDMX (search for similar items in EconPapers)
JEL-codes: J1 Z0 (search for similar items in EconPapers)
Date: 2023
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://www.demographic-research.org/volumes/vol49/40/49-40.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:dem:demres:v:49:y:2023:i:40

DOI: 10.4054/DemRes.2023.49.40

Access Statistics for this article

More articles in Demographic Research from Max Planck Institute for Demographic Research, Rostock, Germany
Bibliographic data for series maintained by Editorial Office ().