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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16090000016011 | L16/questions_ecrites | 16 | 16090000016006 | 16090000016006 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016021 | L16/questions_ecrites | 16 | 16090000016016 | 16090000016016 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016069 | L16/questions_ecrites | 16 | 16090000016063 | 16090000016063 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016074 | L16/questions_ecrites | 16 | 16090000016070 | 16090000016070 | 1 | JO_QUESTION | 2024-04-16 | 20240016 | |||
| 16090000016095 | L16/questions_ecrites | 16 | 16090000016091 | 16090000016091 | 1 | JO_QUESTION | 2023-01-17 | 20230003 | |||
| 16090000016096 | L16/questions_ecrites | 16 | 16090000016091 | 16090000016091 | 2 | JO_QUESTION | 2023-05-02 | 20230018 | |||
| 16090000016119 | L16/questions_ecrites | 16 | 16090000016115 | 16090000016115 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016150 | L16/questions_ecrites | 16 | 16090000016144 | 16090000016144 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016201 | L16/questions_ecrites | 16 | 16090000016197 | 16090000016197 | 1 | JO_QUESTION | 2024-04-09 | 20240015 | |||
| 16090000016229 | L16/questions_ecrites | 16 | 16090000016225 | 16090000016225 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000016258 | L16/questions_ecrites | 16 | 16090000016251 | 16090000016251 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016295 | L16/questions_ecrites | 16 | 16090000016291 | 16090000016291 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016296 | L16/questions_ecrites | 16 | 16090000016291 | 16090000016291 | 2 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000016317 | L16/questions_ecrites | 16 | 16090000016313 | 16090000016313 | 1 | JO_QUESTION | 2024-04-09 | 20240015 | |||
| 16090000016340 | L16/questions_ecrites | 16 | 16090000016336 | 16090000016336 | 1 | JO_QUESTION | 2024-02-27 | 20240009 | |||
| 16090000016354 | L16/questions_ecrites | 16 | 16090000016350 | 16090000016350 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016355 | L16/questions_ecrites | 16 | 16090000016350 | 16090000016350 | 2 | JO_QUESTION | 2024-05-28 | 20240022 | |||
| 16090000016366 | L16/questions_ecrites | 16 | 16090000016361 | 16090000016361 | 1 | JO_QUESTION | 2024-03-19 | 20240012 | |||
| 16090000016405 | L16/questions_ecrites | 16 | 16090000016399 | 16090000016399 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016411 | L16/questions_ecrites | 16 | 16090000016406 | 16090000016406 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016418 | L16/questions_ecrites | 16 | 16090000016412 | 16090000016412 | 1 | JO_QUESTION | 2024-06-11 | 20240024 | |||
| 16090000016435 | L16/questions_ecrites | 16 | 16090000016429 | 16090000016429 | 1 | JO_QUESTION | 2024-06-11 | 20240024 | |||
| 16090000016451 | L16/questions_ecrites | 16 | 16090000016445 | 16090000016445 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016465 | L16/questions_ecrites | 16 | 16090000016461 | 16090000016461 | 1 | JO_QUESTION | 2024-03-19 | 20240012 | |||
| 16090000016509 | L16/questions_ecrites | 16 | 16090000016502 | 16090000016502 | 1 | JO_QUESTION | 2024-02-20 | 20240008 | |||
| 16090000016535 | L16/questions_ecrites | 16 | 16090000016530 | 16090000016530 | 1 | JO_QUESTION | 2024-02-27 | 20240009 | |||
| 16090000016699 | L16/questions_ecrites | 16 | 16090000016695 | 16090000016695 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016724 | L16/questions_ecrites | 16 | 16090000016720 | 16090000016720 | 1 | JO_QUESTION | 2023-04-18 | 20230016 | |||
| 16090000016740 | L16/questions_ecrites | 16 | 16090000016735 | 16090000016735 | 1 | JO_QUESTION | 2024-04-30 | 20240018 | |||
| 16090000016789 | L16/questions_ecrites | 16 | 16090000016784 | 16090000016784 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016836 | L16/questions_ecrites | 16 | 16090000016831 | 16090000016831 | 1 | JO_QUESTION | 2023-04-04 | 20230014 | |||
| 16090000016859 | L16/questions_ecrites | 16 | 16090000016855 | 16090000016855 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016864 | L16/questions_ecrites | 16 | 16090000016860 | 16090000016860 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000016889 | L16/questions_ecrites | 16 | 16090000016885 | 16090000016885 | 1 | JO_QUESTION | 2024-05-14 | 20240020 | |||
| 16090000016947 | L16/questions_ecrites | 16 | 16090000016942 | 16090000016942 | 1 | JO_QUESTION | 2024-03-19 | 20240012 | |||
| 16090000016975 | L16/questions_ecrites | 16 | 16090000016969 | 16090000016969 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017031 | L16/questions_ecrites | 16 | 16090000017026 | 16090000017026 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017090 | L16/questions_ecrites | 16 | 16090000017086 | 16090000017086 | 1 | JO_QUESTION | 2024-05-28 | 20240022 | |||
| 16090000017234 | L16/questions_ecrites | 16 | 16090000017229 | 16090000017229 | 1 | JO_QUESTION | 2024-03-26 | 20240013 | |||
| 16090000017258 | L16/questions_ecrites | 16 | 16090000017251 | 16090000017251 | 1 | JO_QUESTION | 2024-02-27 | 20240009 | |||
| 16090000017275 | L16/questions_ecrites | 16 | 16090000017270 | 16090000017270 | 1 | JO_QUESTION | 2024-02-27 | 20240009 | |||
| 16090000017276 | L16/questions_ecrites | 16 | 16090000017270 | 16090000017270 | 2 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000017311 | L16/questions_ecrites | 16 | 16090000017305 | 16090000017305 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017360 | L16/questions_ecrites | 16 | 16090000017355 | 16090000017355 | 1 | JO_QUESTION | 2023-01-10 | 20230002 | |||
| 16090000017383 | L16/questions_ecrites | 16 | 16090000017378 | 16090000017378 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017404 | L16/questions_ecrites | 16 | 16090000017398 | 16090000017398 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017422 | L16/questions_ecrites | 16 | 16090000017417 | 16090000017417 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017505 | L16/questions_ecrites | 16 | 16090000017499 | 16090000017499 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017512 | L16/questions_ecrites | 16 | 16090000017506 | 16090000017506 | 1 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000017529 | L16/questions_ecrites | 16 | 16090000017523 | 16090000017523 | 1 | JO_QUESTION | 2024-04-16 | 20240016 |