TCRED - Emploi au 31 décembre (1989-2020) - TCRED-EMPLOI-31-DECEMBRE

Data - INSEE

Author

Info

LAST_UPDATE

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

LAST_DOWNLOAD

LAST_DOWNLOAD
2025-10-11

LAST_COMPILE

LAST_COMPILE
2025-10-11

Champ

1989-2019. T201.html
A38
Départements

TITLE_FR

Code

`TCRED-EMPLOI-31-DECEMBRE` %>%
  group_by(IDBANK, TITLE_FR) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

CAT_POP_ACT

Code

`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

REF_AREA

Code

`TCRED-EMPLOI-31-DECEMBRE` %>%
  group_by(REF_AREA) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

NAF2_RGP

Code

`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

TIME_PERIOD / date

Code

`TCRED-EMPLOI-31-DECEMBRE` %>%
  group_by(TIME_PERIOD) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(TIME_PERIOD)) %>%
  print_table_conditional()

Sectoriel par département (2011)

Paris, Seine-Saint-Denis, Hauts-de-Seine

Code

`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())