QNA - Compensation of employees - QNA_D1

Data - OECD

~/data/oecd/QNA.html

Info

LAST_DOWNLOAD

LAST_DOWNLOAD
2022-10-19

LAST_COMPILE

LAST_COMPILE
2024-04-16

Last

obsTime	Nobs
2022-Q2	2182

LOCATION

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

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

MEASURE

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

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

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