Code
`TCRED-EMPLOI-31-DECEMBRE` %>%
group_by(LAST_UPDATE) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()| LAST_UPDATE | Nobs |
|---|---|
| 2021-12-03 | 65040 |
| 2022-05-24 | 100 |
Data - INSEE
`TCRED-EMPLOI-31-DECEMBRE` %>%
group_by(LAST_UPDATE) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()| LAST_UPDATE | Nobs |
|---|---|
| 2021-12-03 | 65040 |
| 2022-05-24 | 100 |
| LAST_DOWNLOAD |
|---|
| 2025-12-27 |
| LAST_COMPILE |
|---|
| 2025-12-27 |
1989-2019. T201.html
A38
Départements
`TCRED-EMPLOI-31-DECEMBRE` %>%
group_by(IDBANK, TITLE_FR) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()`TCRED-EMPLOI-31-DECEMBRE` %>%
left_join(CAT_POP_ACT, by = "CAT_POP_ACT") %>%
group_by(CAT_POP_ACT, Cat_pop_act) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()| CAT_POP_ACT | Cat_pop_act | Nobs |
|---|---|---|
| SAL | Salariés | 22080 |
| NSAL | Non salariés | 21530 |
| TOT | Ensemble | 21530 |
`TCRED-EMPLOI-31-DECEMBRE` %>%
group_by(REF_AREA) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()`TCRED-EMPLOI-31-DECEMBRE` %>%
left_join(NAF2_RGP, by = "NAF2_RGP") %>%
group_by(NAF2_RGP, Naf2_rgp) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()| NAF2_RGP | Naf2_rgp | Nobs |
|---|---|---|
| TOT | Ensemble des secteurs | 11040 |
| AZ | Agriculture | 10820 |
| BE | Industrie | 10820 |
| FZ | Construction | 10820 |
| GU | Tertiaire marchand | 10820 |
| OQ | Tertiaire non marchand | 10820 |
`TCRED-EMPLOI-31-DECEMBRE` %>%
group_by(TIME_PERIOD) %>%
summarise(Nobs = n()) %>%
arrange(desc(TIME_PERIOD)) %>%
print_table_conditional()`TCRED-EMPLOI-31-DECEMBRE` %>%
filter(NAF2_RGP %in% c("BE", "TOT"),
REF_AREA %in% c("D92", "D93", "D75"),
CAT_POP_ACT == "TOT") %>%
year_to_date %>%
select(date, REF_AREA, NAF2_RGP, OBS_VALUE) %>%
spread(NAF2_RGP, OBS_VALUE) %>%
ggplot + geom_line(aes(x = date, y = BE/TOT, color = REF_AREA, linetype = REF_AREA)) +
xlab("") + ylab("Part emploi industriel (% BE-FZ-GU)") + theme_minimal() +
scale_x_date(breaks = seq(1960, 2020, 1) %>% paste0("-01-01") %>% as.Date,
labels = date_format("%y")) +
scale_y_continuous(breaks = 0.01*seq(0, 120, 1),
labels = percent_format(accuracy = 1)) +
scale_color_manual(values = viridis(5)[1:4]) +
theme(legend.position = c(0.8, 0.9),
legend.title = element_blank())