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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16090000066220 | L16/questions_ecrites | 16 | 16090000066213 | 16090000066213 | 1 | JO_QUESTION | 2023-09-05 | 20230036 | |||
| 16090000066418 | L16/questions_ecrites | 16 | 16090000066414 | 16090000066414 | 1 | JO_QUESTION | 2022-12-13 | 20220049 | |||
| 16090000066443 | L16/questions_ecrites | 16 | 16090000066437 | 16090000066437 | 1 | JO_QUESTION | 2023-11-28 | 20230048 | |||
| 16090000066444 | L16/questions_ecrites | 16 | 16090000066437 | 16090000066437 | 2 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000066459 | L16/questions_ecrites | 16 | 16090000066453 | 16090000066453 | 1 | JO_QUESTION | 2023-11-28 | 20230048 | |||
| 16090000066477 | L16/questions_ecrites | 16 | 16090000066472 | 16090000066472 | 1 | JO_QUESTION | 2023-07-18 | 20230029 | |||
| 16090000066492 | L16/questions_ecrites | 16 | 16090000066487 | 16090000066487 | 1 | JO_QUESTION | 2024-02-27 | 20240009 | |||
| 16090000066500 | L16/questions_ecrites | 16 | 16090000066497 | 16090000066497 | 1 | JO_QUESTION | 2023-06-27 | 20230026 | |||
| 16090000066501 | L16/questions_ecrites | 16 | 16090000066497 | 16090000066497 | 2 | JO_QUESTION | 2023-10-03 | 20230040 | |||
| 16090000066515 | L16/questions_ecrites | 16 | 16090000066511 | 16090000066511 | 1 | JO_QUESTION | 2023-11-28 | 20230048 | |||
| 16090000066516 | L16/questions_ecrites | 16 | 16090000066511 | 16090000066511 | 2 | JO_QUESTION | 2024-03-12 | 20240011 | |||
| 16090000066597 | L16/questions_ecrites | 16 | 16090000066591 | 16090000066591 | 1 | JO_QUESTION | 2023-09-26 | 20230039 | |||
| 16090000066622 | L16/questions_ecrites | 16 | 16090000066618 | 16090000066618 | 1 | JO_QUESTION | 2023-07-11 | 20230028 | |||
| 16090000066649 | L16/questions_ecrites | 16 | 16090000066644 | 16090000066644 | 1 | JO_QUESTION | 2023-12-12 | 20230050 | |||
| 16090000066654 | L16/questions_ecrites | 16 | 16090000066650 | 16090000066650 | 1 | JO_QUESTION | 2024-04-02 | 20240014 | |||
| 16090000066706 | L16/questions_ecrites | 16 | 16090000066702 | 16090000066702 | 1 | JO_QUESTION | 2023-07-04 | 20230027 | |||
| 16090000066707 | L16/questions_ecrites | 16 | 16090000066702 | 16090000066702 | 2 | JO_QUESTION | 2023-10-24 | 20230043 | |||
| 16090000066744 | L16/questions_ecrites | 16 | 16090000066740 | 16090000066740 | 1 | JO_QUESTION | 2023-07-11 | 20230028 | |||
| 16090000066903 | L16/questions_ecrites | 16 | 16090000066898 | 16090000066898 | 1 | JO_QUESTION | 2023-11-14 | 20230046 | |||
| 16090000066921 | L16/questions_ecrites | 16 | 16090000066916 | 16090000066916 | 1 | JO_QUESTION | 2023-09-19 | 20230038 | |||
| 16090000066934 | L16/questions_ecrites | 16 | 16090000066930 | 16090000066930 | 1 | JO_QUESTION | 2023-07-18 | 20230029 | |||
| 16090000066942 | L16/questions_ecrites | 16 | 16090000066935 | 16090000066935 | 1 | JO_QUESTION | 2022-11-22 | 20220046 | |||
| 16090000066943 | L16/questions_ecrites | 16 | 16090000066935 | 16090000066935 | 2 | JO_QUESTION | 2023-05-02 | 20230018 | |||
| 16090000066944 | L16/questions_ecrites | 16 | 16090000066935 | 16090000066935 | 3 | JO_QUESTION | 2023-08-08 | 20230032 | |||
| 16090000066945 | L16/questions_ecrites | 16 | 16090000066935 | 16090000066935 | 4 | JO_QUESTION | 2024-01-23 | 20240004 | |||
| 16090000066967 | L16/questions_ecrites | 16 | 16090000066963 | 16090000066963 | 1 | JO_QUESTION | 2023-07-11 | 20230028 | |||
| 16090000067011 | L16/questions_ecrites | 16 | 16090000067007 | 16090000067007 | 1 | JO_QUESTION | 2023-10-17 | 20230042 | |||
| 16090000067012 | L16/questions_ecrites | 16 | 16090000067007 | 16090000067007 | 2 | JO_QUESTION | 2024-05-14 | 20240020 | |||
| 16090000067040 | L16/questions_ecrites | 16 | 16090000067033 | 16090000067033 | 1 | JO_QUESTION | 2024-02-27 | 20240009 | |||
| 16090000067074 | L16/questions_ecrites | 16 | 16090000067067 | 16090000067067 | 1 | JO_QUESTION | 2024-04-23 | 20240017 | |||
| 16090000067102 | L16/questions_ecrites | 16 | 16090000067098 | 16090000067098 | 1 | JO_QUESTION | 2023-12-12 | 20230050 | |||
| 16090000067142 | L16/questions_ecrites | 16 | 16090000067138 | 16090000067138 | 1 | JO_QUESTION | 2023-07-04 | 20230027 | |||
| 16090000067157 | L16/questions_ecrites | 16 | 16090000067151 | 16090000067151 | 1 | JO_QUESTION | 2023-11-14 | 20230046 | |||
| 16090000067174 | L16/questions_ecrites | 16 | 16090000067167 | 16090000067167 | 1 | JO_QUESTION | 2023-07-04 | 20230027 | |||
| 16090000067256 | L16/questions_ecrites | 16 | 16090000067252 | 16090000067252 | 1 | JO_QUESTION | 2023-07-11 | 20230028 | |||
| 16090000067257 | L16/questions_ecrites | 16 | 16090000067252 | 16090000067252 | 2 | JO_QUESTION | 2023-10-31 | 20230044 | |||
| 16090000067300 | L16/questions_ecrites | 16 | 16090000067296 | 16090000067296 | 1 | JO_QUESTION | 2023-10-24 | 20230043 | |||
| 16090000067301 | L16/questions_ecrites | 16 | 16090000067296 | 16090000067296 | 2 | JO_QUESTION | 2024-02-13 | 20240007 | |||
| 16090000067324 | L16/questions_ecrites | 16 | 16090000067319 | 16090000067319 | 1 | JO_QUESTION | 2023-07-18 | 20230029 | |||
| 16090000067486 | L16/questions_ecrites | 16 | 16090000067482 | 16090000067482 | 1 | JO_QUESTION | 2023-07-18 | 20230029 | |||
| 16090000067498 | L16/questions_ecrites | 16 | 16090000067491 | 16090000067491 | 1 | JO_QUESTION | 2023-08-29 | 20230035 | |||
| 16090000067499 | L16/questions_ecrites | 16 | 16090000067491 | 16090000067491 | 2 | JO_QUESTION | 2023-12-05 | 20230049 | |||
| 16090000067500 | L16/questions_ecrites | 16 | 16090000067491 | 16090000067491 | 3 | JO_QUESTION | 2024-04-23 | 20240017 | |||
| 16090000067524 | L16/questions_ecrites | 16 | 16090000067518 | 16090000067518 | 1 | JO_QUESTION | 2023-10-03 | 20230040 | |||
| 16090000067536 | L16/questions_ecrites | 16 | 16090000067532 | 16090000067532 | 1 | JO_QUESTION | 2023-10-03 | 20230040 | |||
| 16090000067717 | L16/questions_ecrites | 16 | 16090000067713 | 16090000067713 | 1 | JO_QUESTION | 2023-07-11 | 20230028 | |||
| 16090000067793 | L16/questions_ecrites | 16 | 16090000067789 | 16090000067789 | 1 | JO_QUESTION | 2023-07-18 | 20230029 | |||
| 16090000067893 | L16/questions_ecrites | 16 | 16090000067889 | 16090000067889 | 1 | JO_QUESTION | 2023-07-11 | 20230028 | |||
| 16090000067935 | L16/questions_ecrites | 16 | 16090000067931 | 16090000067931 | 1 | JO_QUESTION | 2023-07-11 | 20230028 | |||
| 16090000067954 | L16/questions_ecrites | 16 | 16090000067950 | 16090000067950 | 1 | JO_QUESTION | 2023-08-08 | 20230032 |