=============== DARES =============== Provider ======== :provider_name: DARES :provider_longname: :provider URL: :approximate number of datasets: Data accessibility ================== :SDMX: (If yes, links and SDMX releases implemented: ML 2.0, ML 2.1, JSON 2.1) else No :REST API: (If yes, links doc and base URL api) else NO :Bulk Download: (if yes, links and formats: csv, xls, sdmx, also indicate wheter they are zipped) else No :Account: Yes if account (login/password) are requires for access to SDMX/REST API or Bulk Download Desired datasets ================ :Description: See under Datasets Data tree ========= :Existence of a hierachy of datasets on web site: yes see below under Datasets :How to recover the information: to be entered by hand Datasets ======== :datasetCode: (provided or to be made up, suggest scheme if necessary) :how to get release date: :dataset docHref: yes/no :dataset notes: yes/no :dimension_list: (provided or to be made up from the series) :use of attributes: yes/no :attribute_list: (provided or to be made up from the series) :available frequencies: (across all datasets) :availability of previous updates: if yes, provide URL :existence of real time datasets: L’activité partielle -------------------- Priority: SHOULD ['IMG/xls/tdb_ap_t12017.xls'] - Treat each sheet as a different dataset. Dataset names are liste on first sheet lines 21-41 - Use first sheet as hdoc of category - Use first lines of other sheet as hdoc of dataset - Form series name by combining column headers - When appropriate use headers to form dimensions Les demandeurs d’emploi inscrits à Pôle emploi : données nationales ------------------------------------------------------------------- Priority: MUST [ 'IMG/xls/ser_nat_cvs-lala39bim59_.xls', (MUST) 'IMG/xls/ser_nat_brut-lala39bim59_.xls', (MUST) 'IMG/xls/defm_age_detaille-lala39bim59_.xls'] (COULD) - Treat each file as a distinct category - Treat each sheet as a dataset Les demandeurs d’emploi inscrits à Pôle emploi : données régionales, départementales et par zone d’emploi --------------------------------------------------------------------------------------------------------- Priority: WON'T [ 'IMG/xlsx/ser_reg_dep-lala39bim59_.xlsx', 'IMG/xlsx/ser_reg_dep_cvs-lala39bim59_.xlsx', 'IMG/xlsx/ze_internet-lala39bim59_.xlsx'] - Treat each file as a distinct category - Treat each sheet as a dataset La durée collective hebdomadaire -------------------------------- Priority: SHOULD [ 'IMG/xlsx/series_detailles_duree_20172_diffuse.xlsx' (SHOULD), 'IMG/xls/Series_detaillees_duree_diffusion_081223__v2-2.xls'] (WON'T) - Treat each file as a distinct category - Treat each sheet as a dataset - For secteur d'activité, use two dimensions: sector code and sector name La durée individuelle du travail -------------------------------- Priority: SHOULD ['IMG/xlsx/duree_individuelle_de_travail_062017.xlsx'] - Treat each sheet as a dataset L’emploi salarié ---------------- Priority: MUST ['IMG/xls/donnees_trimestrielles_emploi_salarie_2017t1.xls'] - Treat each sheet as a dataset - sector dimensions: - A17 must be completed by repeating the previous code - A38 must be completed when A88 is provided: - CL 29 - CL 30 - FZ 41 - FZ 42 - FZ 43 - GZ 45 - GZ 46 - GZ 47 - IZ 55 - IZ 56 Les emplois vacants ------------------- Priority: MUST ['IMG/xls/emplois_vacants_2017t2_prov-2.xls'] - Treat each sheet as a dataset - put Attribute 'p': provisoire on last observation (label 1917T2(p) in the file) L’emploi intérimaire -------------------- Priority: SHOULD [ 'IMG/xls/donnees_mensuelles_juin_2017_sur_l_interim.xls', (MUST) 'IMG/xls/donnees_trimestrielles_au_4_trimestre_2016_sur_l_interim.xls', (SHOULD) 'IMG/xls/donnees_annuelles_sur_l_interim_2015.xls'] (WON'T) - Treat each file as a distinct category - Treat each sheet as a dataset Les journées individuelles non travaillées (JINT) ------------------------------------------------- Priority: COULD ['IMG/xls/donnees_annuelles_jint_jusqu_en_2014.xls'] - Treat each sheet as a dataset Les heures supplémentaires -------------------------- Priority: MUST ['IMG/xls/les_heures_supplementaires_au_1er_trimestre_2017.xls'] - Treat each sheet as a dataset - Skip first sheet "Synthèse" Les heures supplémentaires rémunérées ------------------------------------- Priority: COULD ['IMG/xls/les_donnees_annuelles_sur_les_heures_supplementaires_remunerees_maj2014-2.xls'] - Treat each sheet as a dataset Les offres collectées et satisfaites par Pôle emploi ---------------------------------------------------- Priority: COULD ['IMG/xlsx/ser_offres-lala39bim59_.xlsx'] - Treat each sheet as a dataset La participation, l’intéressement et l’épargne salariale -------------------------------------------------------- Priority: COULD ['IMG/xls/participation_interessement_et_epargne_salariale_de_2006_a_2015.xls'] - Treat each sheet as a dataset - Skip first sheet "Synthèse" Les dispositifs publics d’accompagnement des restructurations ------------------------------------------------------------- Priority: COULD [ 'IMG/xls/series_lic_eco_cvs_2017.t1.xls', 'IMG/xls/series_lic_eco_brut_2017.t1.xls'] - Treat each file as a category - Treat each sheet as a dataset Les ruptures conventionnelles ----------------------------- Priority: COULD [ 'IMG/xls/donnees_mensuelles_ruptures_conventionnelles_juillet2017.xls', 'IMG/xls/les_donnees_mensuelles_a_mars_2017_inscriptions_des_de_a_la_suite_de_rupture_conv.xls'] - Treat each file as a category - Treat each sheet as a dataset Les indices de salaire de base ------------------------------ Priority: MUST [ 'IMG/xlsm/series_salaires_2017t2_diffuse.xlsm', (MUST) 'IMG/xls/Series_detaillees_salaires_diffusion_081223__v2.xls', (COULD) 'IMG/xls/Series_longues_1945_2008-4.xls'] (WON'T) - Treat each file as a category - Treat each sheet as a dataset - Ignore last columns with label "Variation sur" Les sortants des listes de demandeurs d’emploi inscrits à Pôle emploi --------------------------------------------------------------------- Priority: COULD [ 'IMG/xls/series_enquetesortants_cvscjo_afm_decembre16.xls', 'IMG/xls/series_enquete_sortants_brut_afm_decembre16.xls'] - Treat each file as a category - Treat each sheet as a dataset - For "Caractéristiques des RE", use Notes on row 7 as series notes Le temps partiel ---------------- Priority: MUST ['IMG/xlsx/le_temps_partiel_1982-2016_072017.xlsx'] - Treat "France" and "Metro" as a "geo" dimension Les tensions sur le marché du travail par métier ------------------------------------------------ Priority: COULD [ 'IMG/xls/donnees_cvs_tensions_n17t2.xls', 'IMG/xls/donnees_brutes_tensions_n17t2.xls'] - Treat the two files as a dimension "Ajustement": "Brut", "CVS" - Treat each sheet as a dataset - Treat separately as dimensions - FAP code, FAP grand domaine professionnel - FAP code, FAP domaine professionnel - FAP code, FAP famille professionnelle Series ====== :Series key: rarely provided :Series name: Provided (row or column header) :Series docHref: no :Series notes: sometimes :missing values: use DBnomics code for missing values and attributes to differentiate between statistical secret and not available (n.d) :date format: yyyy, yyyy't'q, month - yy, for quarters, sometimes month-yy is used, :mixed frequencies in the same dataset: no Updates ======= :calendar of future updates: http://dares.travail-emploi.gouv.fr/IMG/pdf/calendrier_2017_de_publication_des_statistiques_sur_les_demandeurs_d_emploi__dec_2016_.pdf :summary of previous updates: http://dares.travail-emploi.gouv.fr/dares-etudes-et-statistiques/ :regular updates: no :RSS flow: no :best way to monitor updates: read http://dares.travail-emploi.gouv.fr/dares-etudes-et-statistiques/ after 18:00 Special problems ================ Excel files may have extension .xls, .xlsx, .xslm Other remarks ============= Data samples ============ :location: non :description: non :snipet: dares.py can be developped to get all selected files