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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000180354 | L15/questions_ecrites | 15 | 15090000180349 | 15090000180349 | 1 | JO_QUESTION | 10/05/2022 | ||||
| 15090000180465 | L15/questions_ecrites | 15 | 15090000180461 | 15090000180461 | 1 | JO_QUESTION | 10/05/2022 | ||||
| 15090000180479 | L15/questions_ecrites | 15 | 15090000180475 | 15090000180475 | 1 | JO_QUESTION | 10/04/2018 | ||||
| 15090000180492 | L15/questions_ecrites | 15 | 15090000180488 | 15090000180488 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000180509 | L15/questions_ecrites | 15 | 15090000180505 | 15090000180505 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000180543 | L15/questions_ecrites | 15 | 15090000180539 | 15090000180539 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000180623 | L15/questions_ecrites | 15 | 15090000180619 | 15090000180619 | 1 | JO_QUESTION | 01/05/2018 | ||||
| 15090000180655 | L15/questions_ecrites | 15 | 15090000180651 | 15090000180651 | 1 | JO_QUESTION | 10/05/2022 | ||||
| 15090000180675 | L15/questions_ecrites | 15 | 15090000180668 | 15090000180668 | 1 | JO_QUESTION | 10/07/2018 | ||||
| 15090000180763 | L15/questions_ecrites | 15 | 15090000180759 | 15090000180759 | 1 | JO_QUESTION | 17/05/2022 | ||||
| 15090000180776 | L15/questions_ecrites | 15 | 15090000180772 | 15090000180772 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000180789 | L15/questions_ecrites | 15 | 15090000180785 | 15090000180785 | 1 | JO_QUESTION | 21/06/2022 | ||||
| 15090000180822 | L15/questions_ecrites | 15 | 15090000180818 | 15090000180818 | 1 | JO_QUESTION | 10/05/2022 | ||||
| 15090000180851 | L15/questions_ecrites | 15 | 15090000180847 | 15090000180847 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000181047 | L15/questions_ecrites | 15 | 15090000181043 | 15090000181043 | 1 | JO_QUESTION | 08/05/2018 | ||||
| 15090000181052 | L15/questions_ecrites | 15 | 15090000181048 | 15090000181048 | 1 | JO_QUESTION | 17/05/2022 | ||||
| 15090000181251 | L15/questions_ecrites | 15 | 15090000181247 | 15090000181247 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000181355 | L15/questions_ecrites | 15 | 15090000181351 | 15090000181351 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000181376 | L15/questions_ecrites | 15 | 15090000181372 | 15090000181372 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000181414 | L15/questions_ecrites | 15 | 15090000181410 | 15090000181410 | 1 | JO_QUESTION | 01/05/2018 | ||||
| 15090000181451 | L15/questions_ecrites | 15 | 15090000181447 | 15090000181447 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000181472 | L15/questions_ecrites | 15 | 15090000181468 | 15090000181468 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000181530 | L15/questions_ecrites | 15 | 15090000181526 | 15090000181526 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000181559 | L15/questions_ecrites | 15 | 15090000181555 | 15090000181555 | 1 | JO_QUESTION | 01/05/2018 | ||||
| 15090000181612 | L15/questions_ecrites | 15 | 15090000181608 | 15090000181608 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000181617 | L15/questions_ecrites | 15 | 15090000181613 | 15090000181613 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000181651 | L15/questions_ecrites | 15 | 15090000181647 | 15090000181647 | 1 | JO_QUESTION | 01/05/2018 | ||||
| 15090000181675 | L15/questions_ecrites | 15 | 15090000181671 | 15090000181671 | 1 | JO_QUESTION | 21/06/2022 | ||||
| 15090000181701 | L15/questions_ecrites | 15 | 15090000181697 | 15090000181697 | 1 | JO_QUESTION | 01/05/2018 | ||||
| 15090000181749 | L15/questions_ecrites | 15 | 15090000181745 | 15090000181745 | 1 | JO_QUESTION | 01/05/2018 | ||||
| 15090000182000 | L15/questions_ecrites | 15 | 15090000181996 | 15090000181996 | 1 | JO_QUESTION | 21/06/2022 | ||||
| 15090000182077 | L15/questions_ecrites | 15 | 15090000182073 | 15090000182073 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000182240 | L15/questions_ecrites | 15 | 15090000182236 | 15090000182236 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000182316 | L15/questions_ecrites | 15 | 15090000182312 | 15090000182312 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000182350 | L15/questions_ecrites | 15 | 15090000182345 | 15090000182345 | 1 | JO_QUESTION | 19/06/2018 | ||||
| 15090000182351 | L15/questions_ecrites | 15 | 15090000182345 | 15090000182345 | 2 | JO_QUESTION | 30/10/2018 | ||||
| 15090000182360 | L15/questions_ecrites | 15 | 15090000182356 | 15090000182356 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000182365 | L15/questions_ecrites | 15 | 15090000182361 | 15090000182361 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000182406 | L15/questions_ecrites | 15 | 15090000182401 | 15090000182401 | 1 | JO_QUESTION | 22/05/2018 | ||||
| 15090000182423 | L15/questions_ecrites | 15 | 15090000182419 | 15090000182419 | 1 | JO_QUESTION | 21/06/2022 | ||||
| 15090000182761 | L15/questions_ecrites | 15 | 15090000182757 | 15090000182757 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000182783 | L15/questions_ecrites | 15 | 15090000182778 | 15090000182778 | 1 | JO_QUESTION | 15/05/2018 | ||||
| 15090000182879 | L15/questions_ecrites | 15 | 15090000182875 | 15090000182875 | 1 | JO_QUESTION | 12/12/2017 | ||||
| 15090000182888 | L15/questions_ecrites | 15 | 15090000182884 | 15090000182884 | 1 | JO_QUESTION | 31/05/2022 | ||||
| 15090000182898 | L15/questions_ecrites | 15 | 15090000182894 | 15090000182894 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000182969 | L15/questions_ecrites | 15 | 15090000182965 | 15090000182965 | 1 | JO_QUESTION | 07/06/2022 | ||||
| 15090000183301 | L15/questions_ecrites | 15 | 15090000183297 | 15090000183297 | 1 | JO_QUESTION | 21/06/2022 | ||||
| 15090000183434 | L15/questions_ecrites | 15 | 15090000183430 | 15090000183430 | 1 | JO_QUESTION | 22/05/2018 | ||||
| 15090000183435 | L15/questions_ecrites | 15 | 15090000183430 | 15090000183430 | 2 | JO_QUESTION | 13/11/2018 | ||||
| 15090000183436 | L15/questions_ecrites | 15 | 15090000183430 | 15090000183430 | 3 | JO_QUESTION | 16/04/2019 |