questions_ecrites.question_renouvellement
Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
85 044 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | info_jo_type_jo | VARCHAR | question.renouvellements.renouvellement.infoJO.typeJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 % |
| 8 | info_jo_date_jo | VARCHAR | question.renouvellements.renouvellement.infoJO.dateJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 % |
| 9 | info_jo_page_jo | VARCHAR | question.renouvellements.renouvellement.infoJO.pageJO · présence : L17 11 %, L16 10 % |
| 10 | info_jo_num_jo | BIGINT | question.renouvellements.renouvellement.infoJO.numJO · présence : L17 11 %, L16 10 % |
| 11 | info_jo_url_legifrance | VARCHAR | question.renouvellements.renouvellement.infoJO.urlLegifrance · présence : L17 11 %, L16 10 % |
| 12 | info_jo_reference_nor | VARCHAR | question.renouvellements.renouvellement.infoJO.referenceNOR · présence : L17 11 %, L16 10 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | info_jo_type_jo | info_jo_date_jo | info_jo_page_jo | info_jo_num_jo | info_jo_url_legifrance | info_jo_reference_nor |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000208882 | L15/questions_ecrites | 15 | 15090000208877 | 15090000208877 | 1 | JO_QUESTION | 18/09/2018 | ||||
| 15090000208888 | L15/questions_ecrites | 15 | 15090000208883 | 15090000208883 | 1 | JO_QUESTION | 19/02/2019 | ||||
| 15090000208948 | L15/questions_ecrites | 15 | 15090000208943 | 15090000208943 | 1 | JO_QUESTION | 09/10/2018 | ||||
| 15090000208984 | L15/questions_ecrites | 15 | 15090000208980 | 15090000208980 | 1 | JO_QUESTION | 04/09/2018 | ||||
| 15090000208985 | L15/questions_ecrites | 15 | 15090000208980 | 15090000208980 | 2 | JO_QUESTION | 11/12/2018 | ||||
| 15090000208995 | L15/questions_ecrites | 15 | 15090000208990 | 15090000208990 | 1 | JO_QUESTION | 11/09/2018 | ||||
| 15090000209025 | L15/questions_ecrites | 15 | 15090000209021 | 15090000209021 | 1 | JO_QUESTION | 04/09/2018 | ||||
| 15090000209138 | L15/questions_ecrites | 15 | 15090000209131 | 15090000209131 | 1 | JO_QUESTION | 11/09/2018 | ||||
| 15090000209139 | L15/questions_ecrites | 15 | 15090000209131 | 15090000209131 | 2 | JO_QUESTION | 18/12/2018 | ||||
| 15090000209140 | L15/questions_ecrites | 15 | 15090000209131 | 15090000209131 | 3 | JO_QUESTION | 02/04/2019 | ||||
| 15090000209141 | L15/questions_ecrites | 15 | 15090000209131 | 15090000209131 | 4 | JO_QUESTION | 06/08/2019 | ||||
| 15090000209142 | L15/questions_ecrites | 15 | 15090000209131 | 15090000209131 | 5 | JO_QUESTION | 04/08/2020 | ||||
| 15090000209143 | L15/questions_ecrites | 15 | 15090000209131 | 15090000209131 | 6 | JO_QUESTION | 26/01/2021 | ||||
| 15090000209174 | L15/questions_ecrites | 15 | 15090000209170 | 15090000209170 | 1 | JO_QUESTION | 11/09/2018 | ||||
| 15090000209195 | L15/questions_ecrites | 15 | 15090000209189 | 15090000209189 | 1 | JO_QUESTION | 20/11/2018 | ||||
| 15090000209196 | L15/questions_ecrites | 15 | 15090000209189 | 15090000209189 | 2 | JO_QUESTION | 16/04/2019 | ||||
| 15090000209201 | L15/questions_ecrites | 15 | 15090000209197 | 15090000209197 | 1 | JO_QUESTION | 11/09/2018 | ||||
| 15090000209218 | L15/questions_ecrites | 15 | 15090000209214 | 15090000209214 | 1 | JO_QUESTION | 11/12/2018 | ||||
| 15090000209219 | L15/questions_ecrites | 15 | 15090000209214 | 15090000209214 | 2 | JO_QUESTION | 14/05/2019 | ||||
| 15090000209229 | L15/questions_ecrites | 15 | 15090000209224 | 15090000209224 | 1 | JO_QUESTION | 11/09/2018 | ||||
| 15090000209236 | L15/questions_ecrites | 15 | 15090000209230 | 15090000209230 | 1 | JO_QUESTION | 15/03/2022 | ||||
| 15090000209288 | L15/questions_ecrites | 15 | 15090000209284 | 15090000209284 | 1 | JO_QUESTION | 29/01/2019 | ||||
| 15090000209306 | L15/questions_ecrites | 15 | 15090000209301 | 15090000209301 | 1 | JO_QUESTION | 05/02/2019 | ||||
| 15090000209313 | L15/questions_ecrites | 15 | 15090000209307 | 15090000209307 | 1 | JO_QUESTION | 04/09/2018 | ||||
| 15090000209492 | L15/questions_ecrites | 15 | 15090000209487 | 15090000209487 | 1 | JO_QUESTION | 18/02/2020 | ||||
| 15090000209493 | L15/questions_ecrites | 15 | 15090000209487 | 15090000209487 | 2 | JO_QUESTION | 30/06/2020 | ||||
| 15090000209494 | L15/questions_ecrites | 15 | 15090000209487 | 15090000209487 | 3 | JO_QUESTION | 15/12/2020 | ||||
| 15090000209495 | L15/questions_ecrites | 15 | 15090000209487 | 15090000209487 | 4 | JO_QUESTION | 30/03/2021 | ||||
| 15090000209496 | L15/questions_ecrites | 15 | 15090000209487 | 15090000209487 | 5 | JO_QUESTION | 28/09/2021 | ||||
| 15090000209600 | L15/questions_ecrites | 15 | 15090000209594 | 15090000209594 | 1 | JO_QUESTION | 04/12/2018 | ||||
| 15090000209601 | L15/questions_ecrites | 15 | 15090000209594 | 15090000209594 | 2 | JO_QUESTION | 10/09/2019 | ||||
| 15090000209602 | L15/questions_ecrites | 15 | 15090000209594 | 15090000209594 | 3 | JO_QUESTION | 21/01/2020 | ||||
| 15090000209612 | L15/questions_ecrites | 15 | 15090000209608 | 15090000209608 | 1 | JO_QUESTION | 02/01/2018 | ||||
| 15090000209654 | L15/questions_ecrites | 15 | 15090000209649 | 15090000209649 | 1 | JO_QUESTION | 09/10/2018 | ||||
| 15090000209698 | L15/questions_ecrites | 15 | 15090000209692 | 15090000209692 | 1 | JO_QUESTION | 24/12/2019 | ||||
| 15090000209699 | L15/questions_ecrites | 15 | 15090000209692 | 15090000209692 | 2 | JO_QUESTION | 21/07/2020 | ||||
| 15090000209700 | L15/questions_ecrites | 15 | 15090000209692 | 15090000209692 | 3 | JO_QUESTION | 15/12/2020 | ||||
| 15090000209701 | L15/questions_ecrites | 15 | 15090000209692 | 15090000209692 | 4 | JO_QUESTION | 29/06/2021 | ||||
| 15090000209702 | L15/questions_ecrites | 15 | 15090000209692 | 15090000209692 | 5 | JO_QUESTION | 02/11/2021 | ||||
| 15090000209703 | L15/questions_ecrites | 15 | 15090000209692 | 15090000209692 | 6 | JO_QUESTION | 01/03/2022 | ||||
| 15090000209803 | L15/questions_ecrites | 15 | 15090000209797 | 15090000209797 | 1 | JO_QUESTION | 04/12/2018 | ||||
| 15090000209804 | L15/questions_ecrites | 15 | 15090000209797 | 15090000209797 | 2 | JO_QUESTION | 25/06/2019 | ||||
| 15090000209813 | L15/questions_ecrites | 15 | 15090000209809 | 15090000209809 | 1 | JO_QUESTION | 23/10/2018 | ||||
| 15090000209814 | L15/questions_ecrites | 15 | 15090000209809 | 15090000209809 | 2 | JO_QUESTION | 26/03/2019 | ||||
| 15090000209815 | L15/questions_ecrites | 15 | 15090000209809 | 15090000209809 | 3 | JO_QUESTION | 16/07/2019 | ||||
| 15090000209816 | L15/questions_ecrites | 15 | 15090000209809 | 15090000209809 | 4 | JO_QUESTION | 05/11/2019 | ||||
| 15090000209857 | L15/questions_ecrites | 15 | 15090000209852 | 15090000209852 | 1 | JO_QUESTION | 09/10/2018 | ||||
| 15090000209907 | L15/questions_ecrites | 15 | 15090000209902 | 15090000209902 | 1 | JO_QUESTION | 13/11/2018 | ||||
| 15090000209908 | L15/questions_ecrites | 15 | 15090000209902 | 15090000209902 | 2 | JO_QUESTION | 16/04/2019 | ||||
| 15090000209984 | L15/questions_ecrites | 15 | 15090000209980 | 15090000209980 | 1 | JO_QUESTION | 04/09/2018 |