Compact tables
This representation consumes very little space. The source key
mun_id_x may be non-unique, in this case the
year_from and year_to columns must be
consulted.
- 2005–2005: 2’769 rows (csv)
- 2005–2006: 2’776 rows (csv)
- 2005–2007: 2’785 rows (csv)
- 2005–2008: 2’787 rows (csv)
- 2005–2009: 2’806 rows (csv)
- 2005–2010: 2’812 rows (csv)
- 2005–2011: 2’820 rows (csv)
- 2005–2012: 2’829 rows (csv)
- 2005–2013: 2’849 rows (csv)
- 2005–2014: 2’860 rows (csv)
- 2005–2015: 2’869 rows (csv)
- 2005–2016: 2’875 rows (csv)
- 2005–2017: 2’880 rows (csv)
- 2005–2018: 2’885 rows (csv)
- 2005–2019: 2’889 rows (csv)
- 2005–2020: 2’892 rows (csv)
- 2005–2021: 2’901 rows (csv)
- 2005–2022: 2’906 rows (csv)
- 2005–2023: 2’912 rows (csv)
Flat tables
This representation is very explicit. The combination of
mun_id_x and year is guaranteed to be
unique.
- 2005–2005: 2’769 rows (csv)
- 2005–2006: 5’515 rows (csv)
- 2005–2007: 8’242 rows (csv)
- 2005–2008: 10’963 rows (csv)
- 2005–2009: 13’603 rows (csv)
- 2005–2010: 16’203 rows (csv)
- 2005–2011: 18’758 rows (csv)
- 2005–2012: 21’257 rows (csv)
- 2005–2013: 23’669 rows (csv)
- 2005–2014: 26’025 rows (csv)
- 2005–2015: 28’353 rows (csv)
- 2005–2016: 30’651 rows (csv)
- 2005–2017: 32’909 rows (csv)
- 2005–2018: 35’134 rows (csv)
- 2005–2019: 37’349 rows (csv)
- 2005–2020: 39’554 rows (csv)
- 2005–2021: 41’729 rows (csv)
- 2005–2022: 43’880 rows (csv)
- 2005–2023: 46’019 rows (csv)