QNA - Compensation of employees - QNA_D1

Data - OECD

Author

Info

LAST_DOWNLOAD

LAST_DOWNLOAD
2022-10-19

LAST_COMPILE

LAST_COMPILE
2026-07-26

Last

obsTime	Nobs
2022-Q2	2182

LOCATION

Code

QNA %>%
  left_join(QNA_var$LOCATION, by = "LOCATION") %>%
  group_by(LOCATION, Location) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(Location)),
         Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) %>%
  select(Flag, everything()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

SUBJECT

Code

QNA %>%
  left_join(QNA_var$SUBJECT, by = "SUBJECT") %>%
  group_by(SUBJECT, Subject) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

MEASURE

Code

QNA %>%
  filter(FREQUENCY == "A") %>%
  left_join(QNA_var$MEASURE, by = "MEASURE") %>%
  group_by(MEASURE, Measure) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

MEASURE	Measure	Nobs
CQR	National currency, current prices, quarterly levels	33650
CQRSA	National currency, current prices, quarterly levels, seasonally adjusted	31490
CARSA	National currency, current prices, annual levels, seasonally adjusted	798
LNBQRSA	National currency, chained volume estimates, national reference year, quarterly levels, seasonally adjusted	208
CAR	National currency, current prices, annual levels	179
LNBARSA	National currency, chained volume estimates, national reference year, annual levels, seasonally adjusted	146
LNBQR	National currency, chained volume estimates, national reference year, quarterly levels	146

FREQUENCY

Code

QNA %>%
  left_join(QNA_var$FREQUENCY, by = "FREQUENCY") %>%
  group_by(FREQUENCY, Frequency) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

FREQUENCY	Frequency	Nobs
Q	Quarterly	270215
A	Annual	66617

obsTime

Code

QNA %>%
  group_by(obsTime) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(obsTime)) %>%
  print_table_conditional()