Downloads codelist (registry table) and returns it in a tibble.
Codelists are canonical lists of entities, their names and IDs. See Details.
Codelists are included in catalogue which can be retrieved using czso_get_catalogue()
.
Their IDs start with "cis"
followed by a two- to three-digit number.
czso_get_codelist(
codelist_id,
language = c("cs", "en"),
dest_dir = NULL,
resource_num = NULL,
force_redownload = F
)
character or numeric of length 1 or 2; ID of codelist to download. See Details.
language, either "cs" (the default) or "en", which is available for some codelists.
character. Directory in which downloaded files will be stored.
If left unset, will use the czso.dest_dir
option if the option is set, and tempdir()
otherwise. Will be created if it does not exist.
integer, order of resource. Only override if you need a different format.
whether to download even if a cached local file is available.
a tibble All columns except dates kept as character. See Details for the columns.
Codelists are canonical registries of entities: things, statistical areas and aggregates, concepts, categorisations. A codelist typically contains IDs and names of all the entities fitting into a certain category.
The most commonly used codelists are geographical, e.g. lists of regions or municipalities.
In the world of the CZSO, each codelist has a numeric ID of two to four digits.
You can pass this number to the function (even as a string), or you can pass the dataset ID found
in the catalogue; the latter will have the form of e.g. "cisNN"
.
The CZSO data store also holds tables describing relations between codelists. This is especially useful for spatial hierarchies (e.g. which towns belong to which region), or for converting between categorisations (e.g. two different sets of IDs for regions.)
You can pass a vector of two IDs (numeric or character) and if the relational
table for these two exists, it will be returned. (If it does not work,
try flipping them around). The equivalent dataset ID, as found in the catalogue,
is "cisXXvazYY"
.
For single-codelist files, see below for the most commonly included columns. For relational tables, you will see each column twice, each time with a suffix of 1 or 2.
AKRCIS: codelist abbreviation
KODCIS: codelist ID
CHODNOTA: entity ID
TEXT: entity name
ZKRTEXT: entity name abbreviated
ADMPLOD: valid from
ADMNEPO: invalid after
KOD_RUIAN: for geographical entites, RUIAN code (different master registry run by the geodesists)
CZNUTS: for geographical entities, NUTS code
Other Core workflow:
czso_get_catalogue()
,
czso_get_table()
,
get_table()
# \donttest{
czso_get_codelist("cis100")
#> # A tibble: 15 × 11
#> KODJAZ AKRCIS KODCIS CHODNOTA ZKRTEXT TEXT ADMPLOD ADMNEPO CZNUTS
#> <chr> <chr> <chr> <chr> <chr> <chr> <date> <date> <chr>
#> 1 CS KRAJ_NUTS 100 3000 Extra-Re… Extr… 2004-05-01 9999-09-09 CZZZZ
#> 2 CS KRAJ_NUTS 100 3018 Hl. m. P… Hlav… 2001-03-01 9999-09-09 CZ010
#> 3 CS KRAJ_NUTS 100 3026 Středoče… Stře… 2001-03-01 9999-09-09 CZ020
#> 4 CS KRAJ_NUTS 100 3034 Jihočesk… Jiho… 2001-03-01 9999-09-09 CZ031
#> 5 CS KRAJ_NUTS 100 3042 Plzeňský… Plze… 2001-03-01 9999-09-09 CZ032
#> 6 CS KRAJ_NUTS 100 3051 Karlovar… Karl… 2001-03-01 9999-09-09 CZ041
#> 7 CS KRAJ_NUTS 100 3069 Ústecký … Úste… 2001-03-01 9999-09-09 CZ042
#> 8 CS KRAJ_NUTS 100 3077 Libereck… Libe… 2001-03-01 9999-09-09 CZ051
#> 9 CS KRAJ_NUTS 100 3085 Královéh… Král… 2001-03-01 9999-09-09 CZ052
#> 10 CS KRAJ_NUTS 100 3093 Pardubic… Pard… 2001-03-01 9999-09-09 CZ053
#> 11 CS KRAJ_NUTS 100 3107 Kraj Vys… Kraj… 2001-03-01 9999-09-09 CZ063
#> 12 CS KRAJ_NUTS 100 3115 Jihomora… Jiho… 2001-03-01 9999-09-09 CZ064
#> 13 CS KRAJ_NUTS 100 3123 Olomouck… Olom… 2001-03-01 9999-09-09 CZ071
#> 14 CS KRAJ_NUTS 100 3131 Zlínský … Zlín… 2001-03-01 9999-09-09 CZ072
#> 15 CS KRAJ_NUTS 100 3140 Moravsko… Mora… 2001-03-01 9999-09-09 CZ080
#> # … with 2 more variables: KOD_RUIAN <chr>, ZKRKRAJ <chr>
# equivalent
czso_get_codelist(100)
#> ℹ File already in
#> /var/folders/24/8k48jl6d249_n_qfxwsl6xvm0000gn/T//RtmpbLmYvF/cis100, not
#> downloading.
#> Set `force_redownload = TRUE` if needed.
#> # A tibble: 15 × 11
#> KODJAZ AKRCIS KODCIS CHODNOTA ZKRTEXT TEXT ADMPLOD ADMNEPO CZNUTS
#> <chr> <chr> <chr> <chr> <chr> <chr> <date> <date> <chr>
#> 1 CS KRAJ_NUTS 100 3000 Extra-Re… Extr… 2004-05-01 9999-09-09 CZZZZ
#> 2 CS KRAJ_NUTS 100 3018 Hl. m. P… Hlav… 2001-03-01 9999-09-09 CZ010
#> 3 CS KRAJ_NUTS 100 3026 Středoče… Stře… 2001-03-01 9999-09-09 CZ020
#> 4 CS KRAJ_NUTS 100 3034 Jihočesk… Jiho… 2001-03-01 9999-09-09 CZ031
#> 5 CS KRAJ_NUTS 100 3042 Plzeňský… Plze… 2001-03-01 9999-09-09 CZ032
#> 6 CS KRAJ_NUTS 100 3051 Karlovar… Karl… 2001-03-01 9999-09-09 CZ041
#> 7 CS KRAJ_NUTS 100 3069 Ústecký … Úste… 2001-03-01 9999-09-09 CZ042
#> 8 CS KRAJ_NUTS 100 3077 Libereck… Libe… 2001-03-01 9999-09-09 CZ051
#> 9 CS KRAJ_NUTS 100 3085 Královéh… Král… 2001-03-01 9999-09-09 CZ052
#> 10 CS KRAJ_NUTS 100 3093 Pardubic… Pard… 2001-03-01 9999-09-09 CZ053
#> 11 CS KRAJ_NUTS 100 3107 Kraj Vys… Kraj… 2001-03-01 9999-09-09 CZ063
#> 12 CS KRAJ_NUTS 100 3115 Jihomora… Jiho… 2001-03-01 9999-09-09 CZ064
#> 13 CS KRAJ_NUTS 100 3123 Olomouck… Olom… 2001-03-01 9999-09-09 CZ071
#> 14 CS KRAJ_NUTS 100 3131 Zlínský … Zlín… 2001-03-01 9999-09-09 CZ072
#> 15 CS KRAJ_NUTS 100 3140 Moravsko… Mora… 2001-03-01 9999-09-09 CZ080
#> # … with 2 more variables: KOD_RUIAN <chr>, ZKRKRAJ <chr>
# get a table of relations between two codelists
czso_get_codelist(c(100, 43))
#> # A tibble: 6,258 × 10
#> KODJAZ TYPVAZ AKRCIS1 KODCIS1 CHODN…¹ TEXT1 AKRCIS2 KODCIS2 CHODN…² TEXT2
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 CS Odvozená … KRAJ_N… 100 3018 Hlav… CISOB 43 554782 Praha
#> 2 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 503410 Žito…
#> 3 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 505781 Zápy
#> 4 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 512991 Drnek
#> 5 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513032 Kame…
#> 6 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513041 Lhota
#> 7 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513075 Hobš…
#> 8 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513113 Malé…
#> 9 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513130 Dola…
#> 10 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513148 Poln…
#> # … with 6,248 more rows, and abbreviated variable names ¹CHODNOTA1, ²CHODNOTA2
# equivalent
czso_get_codelist("cis100vaz43")
#> ℹ File already in
#> /var/folders/24/8k48jl6d249_n_qfxwsl6xvm0000gn/T//RtmpbLmYvF/cis100vaz43, not
#> downloading.
#> Set `force_redownload = TRUE` if needed.
#> # A tibble: 6,258 × 10
#> KODJAZ TYPVAZ AKRCIS1 KODCIS1 CHODN…¹ TEXT1 AKRCIS2 KODCIS2 CHODN…² TEXT2
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 CS Odvozená … KRAJ_N… 100 3018 Hlav… CISOB 43 554782 Praha
#> 2 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 503410 Žito…
#> 3 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 505781 Zápy
#> 4 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 512991 Drnek
#> 5 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513032 Kame…
#> 6 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513041 Lhota
#> 7 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513075 Hobš…
#> 8 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513113 Malé…
#> 9 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513130 Dola…
#> 10 CS Odvozená … KRAJ_N… 100 3026 Stře… CISOB 43 513148 Poln…
#> # … with 6,248 more rows, and abbreviated variable names ¹CHODNOTA1, ²CHODNOTA2
# }