DOI: 10.34894/xf7iad
title: Municipality-level geographical colleague connectivity in the Netherlands (2019-2022)

description: This record contains datasets (.csv files) on counts of colleague pairs per municipality triplet (two home municipalities for two colleagues, and one shared workplace municipality) in the Netherlands for the years 2019 to 2022, and corresponding R scripts (.R files) for reproduction within the CBS Microdata environment. Three types of micro-level administrative data files are required to be loaded within CBS, which are: (1) job relationships (i.e., SPOLISBUS), (2) individuals’ home municipalities (i.e., GBAADRESOBJECT, VSLGTAB and GIN), and (3) information on local branches (i.e., GEMEENTESTPLTAB and ABR_REGIO). For each year of concern, all employees with valid home registrations in the Netherlands are paired with their colleagues who are identified as working for the same company. Individuals working for companies with more than one local branch are assigned to the most probable branch and paired with people working in the same branch. A cap is imposed to limit the maximum number of colleagues an individual is allowed to have. NA values in the CSV files indicate censored values, this is related to CBS rules requiring a minimum of 10 observations to avoid potential risks of group disclosure. The total counts suppressed to NA each year (and by different choices of the cap) is reported as a supplement (in PDF file). In the supplement, there is an overview of the labour size each year, based on which the municipality-level colleague connectivity is constructed. The geographical connectivity presented here is further used to inform regional public health interventions during pandemics.
description: R, version 4.4.1
description: Each CSV file presents the counts of colleague pairs per year per cap choice, files are named as:

 work_3layer_2019
 work_3layer_2020
 work_3layer_2021
 work_3layer_2022


For the year 2019 and 2022, a sensitivity analysis was conducted on the maximum number of colleagues an individual is allowed to have. The datasets are stored separately as the following, taking year 2019 as an example: 

 work_3layer_2019_cap50 (Maximum 50 colleagues allowed per individual)
 work_3layer_2019_cap100 (Maximum 100 colleagues allowed per individual)
 work_3layer_2019_cap200 (Maximum 200 colleagues allowed per individual) 


Each CSV file contains a four-column data table representing workplace connections between municipalities:

 vrgem_ego: A 6-digit character indicating the safety region and municipality where the ego (the focal individuals) reside. The first two digits indicate the safety region code, and the last 4 indicate the municipality code for the corresponding year. 
 vrgem_alter: A 6-digit character indicating the safety region and municipality where the alter (colleagues of the ego) reside. The format is the same as previous.
 vrgem_meet: A 6-digit character indicating the safety region and municipality where the ego and alter meet for work-related connections. The format is the same as previous.
 pairs: The total number of colleague pairs between vrgem_ego and vrgem_alter, meeting in vrgem_meet. To mitigate group disclosure, any value below 10 is coded as NA.
description: The data source is only availble upon request to CBS Microdata team.