Codebook

knitr::opts_chunk$set(
  warning = FALSE, # show warnings during codebook generation
  message = FALSE, # show messages during codebook generation
  error = TRUE, # do not interrupt codebook generation in case of errors,
                # usually better for debugging
  echo = TRUE  # show R code
)
ggplot2::theme_set(ggplot2::theme_bw())

# set base directory
basedir = "/home/ecco_rais/data/clean/RAIS-homogenized/output/"
# adjust as necessary
startyear = 2003
endyear = 2004

# libraries
library(codebook)
library(rio)

## The following rio suggested packages are not installed: 'arrow', 'hexView', 'pzfx', 'rmatio', 'readODS', 'qs'
## Use 'install_formats()' to install them

# Start the codebook loop

#for ( year in startyear:endyear) {
year = "2016"
    # for CSV
    codebook_data <- fread(file.path(basedir, paste0("harmo_", year, ".csv")))

    # omit the following lines, if your missing values are already properly labelled
    codebook_data <- detect_missing(codebook_data,
        only_labelled = TRUE, # only labelled values are autodetected as
                              # missing
        negative_values_are_missing = FALSE, # negative values are missing values
        ninety_nine_problems = TRUE,   # 99/999 are missing values, if they
                                      # are more than 5 MAD from the median
    )

    # If you are not using formr, the codebook package needs to guess which items
    # form a scale. The following line finds item aggregates with names like this:
    # scale = scale_1 + scale_2R + scale_3R
    # identifying these aggregates allows the codebook function to
    # automatically compute reliabilities.
    # However, it will not reverse items automatically.
    codebook_data <- detect_scales(codebook_data)

## Warning in detect_scales(codebook_data): cbo items found, but no aggregate

## Warning in detect_scales(codebook_data): cnae items found, but no aggregate

## Warning in detect_scales(codebook_data): active items found, but no aggregate

    codebook_data <- as.data.table(codebook_data)
    codebook(codebook_data)

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning in grepl("^\\s+$", x): input string 2 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 3 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 4 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 5 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 6 is invalid in this locale

## Warning in max(f): no non-missing arguments to max; returning -Inf

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning in max(f): no non-missing arguments to max; returning -Inf

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning in grepl("^\\s+$", x): input string 2 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 3 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 4 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 5 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 6 is invalid in this locale

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning: Couldn't find skimmers for class: integer64; No user-defined `sfl` provided. Falling
## back to `character`.

## Warning in grepl("^\\s+$", x): input string 2 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 3 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 4 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 5 is invalid in this locale

## Warning in grepl("^\\s+$", x): input string 6 is invalid in this locale

Metadata

Description

Dataset name: codebook_data

The dataset has N=67144598 rows and 64 columns. 0 rows have no missing values on any column.

Metadata for search engines

• Date published: 2024-06-05

x adm_date cbo94 cbo02 cei zip_establishment cnae20 cnae20sub cnae95 firmID cnpj_root cpf dob termination_day schooling ibge_subsetor age cei_avail pat disabled simples alvara_ind termination_month separation_cause muni_job muni nationality legal_form name ctps pis hired_hours race_color estab_name sex establishment_size tenure adm_type disability_type firmID_type wage_type contract_type active1231 earn_april earn_august earn_feb earn_jan earn_july earn_june earn_may earn_march earn_nov earn_oct earn_sept earn_dec_mw earn_dec mean_earn_mw mean_earn hired_wage last_wage yr termination_year adm_day adm_month adm_year

#Variables

adm_date

Distribution

Distribution of values for adm_date

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
adm_date	numeric	0	1	1e+06	5052007	3.1e+07	8709273	8489734	▇▂▂▂▁	NA

cbo94

Distribution

## Error in if (stats::median(table(x)) == 1) {: missing value where TRUE/FALSE needed

## No non-missing values to show.

67144598 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	count	label
cbo94	logical	67144598	0	:	NA

cbo02

Distribution

Distribution of values for cbo02

71376 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
cbo02	numeric	71376	0.998937	10105	513505	992225	496754.7	205644	▁▃▇▅▁	NA

cei

Distribution

## Error in `ggplot2::geom_histogram()`:
## ! Problem while computing position.
## ℹ Error occurred in the 1st layer.
## Caused by error in `if (...) NULL`:
## ! missing value where TRUE/FALSE needed

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	n_unique	empty	min	max	whitespace	label
cei	character	0	1	52257	0	1	21	0	NA

zip_establishment

Distribution

Distribution of values for zip_establishment

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
zip_establishment	numeric	0	1	1e+06	4.3e+07	1e+08	47242415	31584823	▇▅▃▅▆	NA

cnae20

Distribution

Distribution of values for cnae20

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
cnae20	numeric	0	1	1113	49302	99008	56583.68	25858.98	▂▂▇▂▇	NA

cnae20sub

Distribution

Distribution of values for cnae20sub

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
cnae20sub	numeric	0	1	111301	4930202	9900800	5658376	2585896	▂▂▇▂▇	NA

cnae95

Distribution

Distribution of values for cnae95

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
cnae95	numeric	0	1	1112	55220	99007	56796.98	22465.61	▂▂▇▇▂	NA

firmID

Distribution

## Error in `ggplot2::geom_histogram()`:
## ! Problem while computing stat.
## ℹ Error occurred in the 1st layer.
## Caused by error in `seq_len()`:
## ! argument must be coercible to non-negative integer

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	n_unique	empty	min	max	whitespace	label
firmID	character	0	1	3872884	0	15	21	0	NA

cnpj_root

Distribution

Distribution of values for cnpj_root

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
cnpj_root	numeric	0	1	0	1.3e+07	9.9e+07	24147303	26009292	▇▂▁▁▁	NA

cpf

Distribution

## Error in `ggplot2::geom_histogram()`:
## ! Problem while computing position.
## ℹ Error occurred in the 1st layer.
## Caused by error in `if (...) NULL`:
## ! missing value where TRUE/FALSE needed

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	n_unique	empty	min	max	whitespace	label
cpf	character	0	1	56784289	0	1	21	0	NA

dob

Distribution

Distribution of values for dob

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
dob	numeric	0	1	1e+06	1.6e+07	3.1e+07	15670961	8784154	▇▇▇▇▇	NA

termination_day

Distribution

Distribution of values for termination_day

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	n_unique	empty	min	max	whitespace	label
termination_day	character	0	1	32	0	2	2	0	NA

schooling

Distribution

Distribution of values for schooling

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
schooling	numeric	0	1	1	7	11	6.718655	1.725449	▁▂▇▃▁	NA

ibge_subsetor

Distribution

Distribution of values for ibge_subsetor

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
ibge_subsetor	numeric	0	1	1	19	25	18.02316	5.304703	▁▁▃▇▇	NA

age

Distribution

Distribution of values for age

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
age	numeric	0	1	0	35	100	36.36763	11.71907	▁▇▅▁▁	NA

cei_avail

Distribution

Distribution of values for cei_avail

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
cei_avail	numeric	0	1	0	0	1	0.0162303	0.1263599	▇▁▁▁▁	NA

pat

Distribution

Distribution of values for pat

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
pat	numeric	0	1	0	0	1	0.2915652	0.4544831	▇▁▁▁▃	NA

disabled

Distribution

Distribution of values for disabled

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
disabled	numeric	0	1	0	0	1	0.0081443	0.0898778	▇▁▁▁▁	NA

simples

Distribution

Distribution of values for simples

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
simples	numeric	0	1	0	0	1	0.2424239	0.4285493	▇▁▁▁▂	NA

alvara_ind

Distribution

Distribution of values for alvara_ind

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
alvara_ind	numeric	0	1	0	0	1	5.61e-05	0.007492	▇▁▁▁▁	NA

termination_month

Distribution

Distribution of values for termination_month

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
termination_month	numeric	0	1	0	0	12	2.092036	3.677219	▇▁▁▁▁	NA

separation_cause

Distribution

Distribution of values for separation_cause

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
separation_cause	numeric	0	1	0	0	80	4.849921	8.779175	▇▁▁▁▁	NA

muni_job

Distribution

Distribution of values for muni_job

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
muni_job	numeric	0	1	110001	351870	530010	345295.1	87870.39	▁▂▇▂▁	NA

muni

Distribution

Distribution of values for muni

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
muni	numeric	0	1	110001	351860	530010	345292.9	87867.64	▁▂▇▂▁	NA

nationality

Distribution

Distribution of values for nationality

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
nationality	numeric	0	1	10	10	80	10.09091	1.84549	▇▁▁▁▁	NA

legal_form

Distribution

Distribution of values for legal_form

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
legal_form	numeric	0	1	1015	2062	5037	2050.419	672.9368	▂▇▁▁▁	NA

name

Distribution

Distribution of values for name

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	n_unique	empty	min	max	whitespace	label
name	character	0	1	41466463	0	2	52	0	NA

ctps

Distribution

Distribution of values for ctps

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
ctps	numeric	0	1	0	66451	1e+08	1342991	3672727	▇▁▁▁▁	NA

pis

Distribution

## Error in `ggplot2::geom_histogram()`:
## ! Problem while computing stat.
## ℹ Error occurred in the 1st layer.
## Caused by error in `seq_len()`:
## ! argument must be coercible to non-negative integer

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	n_unique	empty	min	max	whitespace	label
pis	character	0	1	56906493	0	13	21	0	NA

hired_hours

Distribution

Distribution of values for hired_hours

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
hired_hours	numeric	0	1	1	44	44	40.91285	6.66365	▁▁▁▁▇	NA

race_color

Distribution

Distribution of values for race_color

10150099 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
race_color	numeric	10150099	0.8488322	1	2	9	4.84608	3.035033	▇▁▁▁▇	NA

estab_name

Distribution

Distribution of values for estab_name

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	n_unique	empty	min	max	whitespace	label
estab_name	character	0	1	3533388	0	3	54	0	NA

sex

Distribution

Distribution of values for sex

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
sex	numeric	0	1	0	0	1	0.4286266	0.4948796	▇▁▁▁▆	NA

establishment_size

Distribution

Distribution of values for establishment_size

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
establishment_size	numeric	0	1	1	6	10	6.237625	2.851774	▃▅▆▅▇	NA

tenure

Distribution

Distribution of values for tenure

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
tenure	numeric	0	1	0	23	600	53.74033	78.45779	▇▁▁▁▁	NA

adm_type

Distribution

Distribution of values for adm_type

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
adm_type	numeric	0	1	0	0	14	0.6040368	1.016922	▇▁▁▁▁	NA

disability_type

Distribution

Distribution of values for disability_type

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
disability_type	numeric	0	1	0	0	6	0.0180107	0.2446829	▇▁▁▁▁	NA

firmID_type

Distribution

Distribution of values for firmID_type

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
firmID_type	numeric	0	1	0	1	1	0.9718749	0.1653303	▁▁▁▁▇	NA

wage_type

Distribution

Distribution of values for wage_type

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
wage_type	numeric	0	1	1	1	7	1.31417	1.112902	▇▁▁▁▁	NA

contract_type

Distribution

Distribution of values for contract_type

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
contract_type	numeric	0	1	10	10	97	16.41979	14.45252	▇▂▁▁▁	NA

active1231

Distribution

Distribution of values for active1231

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
active1231	numeric	0	1	0	1	1	0.6859852	0.4641223	▃▁▁▁▇	NA

earn_april

Distribution

Distribution of values for earn_april

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_april	numeric	0	1	0	995	131875	1577.918	3073.215	▇▁▁▁▁	NA

earn_august

Distribution

Distribution of values for earn_august

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_august	numeric	0	1	0	1033	132000	1623.48	3098.537	▇▁▁▁▁	NA

earn_feb

Distribution

Distribution of values for earn_feb

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_feb	numeric	0	1	0	979	131995	1573.019	3119.974	▇▁▁▁▁	NA

earn_jan

Distribution

Distribution of values for earn_jan

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_jan	numeric	0	1	0	998	131972	1636.781	3241.811	▇▁▁▁▁	NA

earn_july

Distribution

Distribution of values for earn_july

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_july	numeric	0	1	0	1034	131992	1635.053	3128.322	▇▁▁▁▁	NA

earn_june

Distribution

Distribution of values for earn_june

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_june	numeric	0	1	0	1012	131999	1609.205	3091.357	▇▁▁▁▁	NA

earn_may

Distribution

Distribution of values for earn_may

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_may	numeric	0	1	0	1022	131943	1605.951	3056.678	▇▁▁▁▁	NA

earn_march

Distribution

Distribution of values for earn_march

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_march	numeric	0	1	0	1006	131994	1592.452	3136.504	▇▁▁▁▁	NA

earn_nov

Distribution

Distribution of values for earn_nov

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_nov	numeric	0	1	0	1045	131982	1649.136	3141.116	▇▁▁▁▁	NA

earn_oct

Distribution

Distribution of values for earn_oct

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_oct	numeric	0	1	0	1055	132004	1653.004	3129.668	▇▁▁▁▁	NA

earn_sept

Distribution

Distribution of values for earn_sept

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_sept	numeric	0	1	0	1033	131978	1626.88	3095.436	▇▁▁▁▁	NA

earn_dec_mw

Distribution

Distribution of values for earn_dec_mw

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_dec_mw	numeric	0	1	0	1.4	150	2.204156	3.919335	▇▁▁▁▁	NA

earn_dec

Distribution

Distribution of values for earn_dec

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
earn_dec	numeric	0	1	0	1230	132007	1942.527	3449.822	▇▁▁▁▁	NA

mean_earn_mw

Distribution

Distribution of values for mean_earn_mw

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
mean_earn_mw	numeric	0	1	0	1.7	150	2.713075	3.811038	▇▁▁▁▁	NA

mean_earn

Distribution

Distribution of values for mean_earn

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
mean_earn	numeric	0	1	0	1473	131965	2394.672	3354.079	▇▁▁▁▁	NA

hired_wage

Distribution

Distribution of values for hired_wage

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
hired_wage	numeric	0	1	0	944	9053527	1304.331	4012.593	▇▁▁▁▁	NA

last_wage

Distribution

Distribution of values for last_wage

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
last_wage	numeric	0	1	0	1361	9260700	2282.783	6923.176	▇▁▁▁▁	NA

yr

Distribution

Distribution of values for yr

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
yr	numeric	0	1	2016	2016	2016	2016	0	▁▁▇▁▁	NA

termination_year

Distribution

Distribution of values for termination_year

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
termination_year	numeric	0	1	2016	2016	2016	2016	0	▁▁▇▁▁	NA

adm_day

Distribution

Distribution of values for adm_day

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
adm_day	numeric	0	1	1	5	31	8.644663	8.48997	▇▂▂▂▁	NA

adm_month

Distribution

Distribution of values for adm_month

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
adm_month	numeric	0	1	1	6	12	6.259822	3.412859	▇▅▅▅▆	NA

adm_year

Distribution

Distribution of values for adm_year

0 missing values.

Summary statistics

name	data_type	n_missing	complete_rate	min	median	max	mean	sd	hist	label
adm_year	numeric	0	1	1938	2014	2016	2011.902	6.477878	▁▁▁▁▇	NA

Missingness report

Codebook table

JSON-LD metadata

The following JSON-LD can be found by search engines, if you share this codebook publicly on the web.

{
  "name": "codebook_data",
  "datePublished": "2024-06-05",
  "description": "The dataset has N=67144598 rows and 64 columns.\n0 rows have no missing values on any column.\n\n\n## Table of variables\nThis table contains variable names, labels, and number of missing values.\nSee the complete codebook for more.\n\n|name               |label | n_missing|\n|:------------------|:-----|---------:|\n|adm_date           |NA    |         0|\n|cbo94              |NA    |  67144598|\n|cbo02              |NA    |     71376|\n|cei                |NA    |         0|\n|zip_establishment  |NA    |         0|\n|cnae20             |NA    |         0|\n|cnae20sub          |NA    |         0|\n|cnae95             |NA    |         0|\n|firmID             |NA    |         0|\n|cnpj_root          |NA    |         0|\n|cpf                |NA    |         0|\n|dob                |NA    |         0|\n|termination_day    |NA    |         0|\n|schooling          |NA    |         0|\n|ibge_subsetor      |NA    |         0|\n|age                |NA    |         0|\n|cei_avail          |NA    |         0|\n|pat                |NA    |         0|\n|disabled           |NA    |         0|\n|simples            |NA    |         0|\n|alvara_ind         |NA    |         0|\n|termination_month  |NA    |         0|\n|separation_cause   |NA    |         0|\n|muni_job           |NA    |         0|\n|muni               |NA    |         0|\n|nationality        |NA    |         0|\n|legal_form         |NA    |         0|\n|name               |NA    |         0|\n|ctps               |NA    |         0|\n|pis                |NA    |         0|\n|hired_hours        |NA    |         0|\n|race_color         |NA    |  10150099|\n|estab_name         |NA    |         0|\n|sex                |NA    |         0|\n|establishment_size |NA    |         0|\n|tenure             |NA    |         0|\n|adm_type           |NA    |         0|\n|disability_type    |NA    |         0|\n|firmID_type        |NA    |         0|\n|wage_type          |NA    |         0|\n|contract_type      |NA    |         0|\n|active1231         |NA    |         0|\n|earn_april         |NA    |         0|\n|earn_august        |NA    |         0|\n|earn_feb           |NA    |         0|\n|earn_jan           |NA    |         0|\n|earn_july          |NA    |         0|\n|earn_june          |NA    |         0|\n|earn_may           |NA    |         0|\n|earn_march         |NA    |         0|\n|earn_nov           |NA    |         0|\n|earn_oct           |NA    |         0|\n|earn_sept          |NA    |         0|\n|earn_dec_mw        |NA    |         0|\n|earn_dec           |NA    |         0|\n|mean_earn_mw       |NA    |         0|\n|mean_earn          |NA    |         0|\n|hired_wage         |NA    |         0|\n|last_wage          |NA    |         0|\n|yr                 |NA    |         0|\n|termination_year   |NA    |         0|\n|adm_day            |NA    |         0|\n|adm_month          |NA    |         0|\n|adm_year           |NA    |         0|\n\n### Note\nThis dataset was automatically described using the [codebook R package](https://rubenarslan.github.io/codebook/) (version 0.9.2).",
  "keywords": ["adm_date", "cbo94", "cbo02", "cei", "zip_establishment", "cnae20", "cnae20sub", "cnae95", "firmID", "cnpj_root", "cpf", "dob", "termination_day", "schooling", "ibge_subsetor", "age", "cei_avail", "pat", "disabled", "simples", "alvara_ind", "termination_month", "separation_cause", "muni_job", "muni", "nationality", "legal_form", "name", "ctps", "pis", "hired_hours", "race_color", "estab_name", "sex", "establishment_size", "tenure", "adm_type", "disability_type", "firmID_type", "wage_type", "contract_type", "active1231", "earn_april", "earn_august", "earn_feb", "earn_jan", "earn_july", "earn_june", "earn_may", "earn_march", "earn_nov", "earn_oct", "earn_sept", "earn_dec_mw", "earn_dec", "mean_earn_mw", "mean_earn", "hired_wage", "last_wage", "yr", "termination_year", "adm_day", "adm_month", "adm_year"],
  "@context": "http://schema.org/",
  "@type": "Dataset",
  "variableMeasured": [
    {
      "name": "adm_date",
      "@type": "propertyValue"
    },
    {
      "name": "cbo94",
      "@type": "propertyValue"
    },
    {
      "name": "cbo02",
      "@type": "propertyValue"
    },
    {
      "name": "cei",
      "@type": "propertyValue"
    },
    {
      "name": "zip_establishment",
      "@type": "propertyValue"
    },
    {
      "name": "cnae20",
      "@type": "propertyValue"
    },
    {
      "name": "cnae20sub",
      "@type": "propertyValue"
    },
    {
      "name": "cnae95",
      "@type": "propertyValue"
    },
    {
      "name": "firmID",
      "@type": "propertyValue"
    },
    {
      "name": "cnpj_root",
      "@type": "propertyValue"
    },
    {
      "name": "cpf",
      "@type": "propertyValue"
    },
    {
      "name": "dob",
      "@type": "propertyValue"
    },
    {
      "name": "termination_day",
      "@type": "propertyValue"
    },
    {
      "name": "schooling",
      "@type": "propertyValue"
    },
    {
      "name": "ibge_subsetor",
      "@type": "propertyValue"
    },
    {
      "name": "age",
      "@type": "propertyValue"
    },
    {
      "name": "cei_avail",
      "@type": "propertyValue"
    },
    {
      "name": "pat",
      "@type": "propertyValue"
    },
    {
      "name": "disabled",
      "@type": "propertyValue"
    },
    {
      "name": "simples",
      "@type": "propertyValue"
    },
    {
      "name": "alvara_ind",
      "@type": "propertyValue"
    },
    {
      "name": "termination_month",
      "@type": "propertyValue"
    },
    {
      "name": "separation_cause",
      "@type": "propertyValue"
    },
    {
      "name": "muni_job",
      "@type": "propertyValue"
    },
    {
      "name": "muni",
      "@type": "propertyValue"
    },
    {
      "name": "nationality",
      "@type": "propertyValue"
    },
    {
      "name": "legal_form",
      "@type": "propertyValue"
    },
    {
      "name": "name",
      "@type": "propertyValue"
    },
    {
      "name": "ctps",
      "@type": "propertyValue"
    },
    {
      "name": "pis",
      "@type": "propertyValue"
    },
    {
      "name": "hired_hours",
      "@type": "propertyValue"
    },
    {
      "name": "race_color",
      "@type": "propertyValue"
    },
    {
      "name": "estab_name",
      "@type": "propertyValue"
    },
    {
      "name": "sex",
      "@type": "propertyValue"
    },
    {
      "name": "establishment_size",
      "@type": "propertyValue"
    },
    {
      "name": "tenure",
      "@type": "propertyValue"
    },
    {
      "name": "adm_type",
      "@type": "propertyValue"
    },
    {
      "name": "disability_type",
      "@type": "propertyValue"
    },
    {
      "name": "firmID_type",
      "@type": "propertyValue"
    },
    {
      "name": "wage_type",
      "@type": "propertyValue"
    },
    {
      "name": "contract_type",
      "@type": "propertyValue"
    },
    {
      "name": "active1231",
      "@type": "propertyValue"
    },
    {
      "name": "earn_april",
      "@type": "propertyValue"
    },
    {
      "name": "earn_august",
      "@type": "propertyValue"
    },
    {
      "name": "earn_feb",
      "@type": "propertyValue"
    },
    {
      "name": "earn_jan",
      "@type": "propertyValue"
    },
    {
      "name": "earn_july",
      "@type": "propertyValue"
    },
    {
      "name": "earn_june",
      "@type": "propertyValue"
    },
    {
      "name": "earn_may",
      "@type": "propertyValue"
    },
    {
      "name": "earn_march",
      "@type": "propertyValue"
    },
    {
      "name": "earn_nov",
      "@type": "propertyValue"
    },
    {
      "name": "earn_oct",
      "@type": "propertyValue"
    },
    {
      "name": "earn_sept",
      "@type": "propertyValue"
    },
    {
      "name": "earn_dec_mw",
      "@type": "propertyValue"
    },
    {
      "name": "earn_dec",
      "@type": "propertyValue"
    },
    {
      "name": "mean_earn_mw",
      "@type": "propertyValue"
    },
    {
      "name": "mean_earn",
      "@type": "propertyValue"
    },
    {
      "name": "hired_wage",
      "@type": "propertyValue"
    },
    {
      "name": "last_wage",
      "@type": "propertyValue"
    },
    {
      "name": "yr",
      "@type": "propertyValue"
    },
    {
      "name": "termination_year",
      "@type": "propertyValue"
    },
    {
      "name": "adm_day",
      "@type": "propertyValue"
    },
    {
      "name": "adm_month",
      "@type": "propertyValue"
    },
    {
      "name": "adm_year",
      "@type": "propertyValue"
    }
  ]
}`

 # } # end year loop