Record Linkage in the Cape of Good Hope Panel

Auke Rijpma, Jeanne Cilliers () and Johan Fourie
Additional contact information
Auke Rijpma: Utrecht University

No 172, Lund Papers in Economic History from Lund University, Department of Economic History

Abstract: In this paper we describe the record linkage procedure to create a panel from Cape Colony census returns, or opgaafrolle, for 1787-1828, a dataset of 42,354 household-level observations. Based on a subset of manually linked records, we first evaluate statistical models and deterministic algorithms to best identify and match households over time. By using household-level characteristics in the linking process and near-annual data, we are able to create high-quality links for 84 percent of the dataset. We compare basic analyses on the linked panel dataset to the original cross-sectional data, evaluate the feasibility of the strategy when linking to supplementary sources, and discuss the scalability of our approach to the full Cape panel.

Keywords: census; machine learning; micro-data; record linkage; panel data; South Africa (search for similar items in EconPapers)
JEL-codes: C81 N01 (search for similar items in EconPapers)
Pages: 49 pages
Date: 2018-02-28
New Economics Papers: this item is included in nep-big
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
http://lup.lub.lu.se/record/92061a04-c39f-4ffe-8a02-78146b5059cf Full text (application/pdf)

Related works:
Journal Article: Record linkage in the Cape of Good Hope Panel (2020)
Working Paper: Record linkage in the Cape of Good Hope Panel (2018)
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:hhs:luekhi:0172

Access Statistics for this paper

More papers in Lund Papers in Economic History from Lund University, Department of Economic History Department of Economic History, Lund University, Box 7083, S-220 07 Lund, Sweden. Contact information at EDIRC.
Bibliographic data for series maintained by Tobias Karlsson () and Benny Carlsson ().