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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16090000025752 | L16/questions_ecrites | 16 | 16090000025749 | 16090000025749 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000025824 | L16/questions_ecrites | 16 | 16090000025821 | 16090000025821 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000025955 | L16/questions_ecrites | 16 | 16090000025952 | 16090000025952 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000025968 | L16/questions_ecrites | 16 | 16090000025965 | 16090000025965 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000025992 | L16/questions_ecrites | 16 | 16090000025989 | 16090000025989 | 1 | JO_QUESTION | 2024-05-14 | 20240020 | |||
| 16090000026024 | L16/questions_ecrites | 16 | 16090000026021 | 16090000026021 | 1 | JO_QUESTION | 2024-05-07 | 20240019 | |||
| 16090000026032 | L16/questions_ecrites | 16 | 16090000026028 | 16090000026028 | 1 | JO_QUESTION | 2024-05-07 | 20240019 | |||
| 16090000026038 | L16/questions_ecrites | 16 | 16090000026033 | 16090000026033 | 1 | JO_QUESTION | 2024-05-07 | 20240019 | |||
| 16090000026053 | L16/questions_ecrites | 16 | 16090000026049 | 16090000026049 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026075 | L16/questions_ecrites | 16 | 16090000026072 | 16090000026072 | 1 | JO_QUESTION | 2024-06-11 | 20240024 | |||
| 16090000026106 | L16/questions_ecrites | 16 | 16090000026102 | 16090000026102 | 1 | JO_QUESTION | 2024-05-07 | 20240019 | |||
| 16090000026185 | L16/questions_ecrites | 16 | 16090000026182 | 16090000026182 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026201 | L16/questions_ecrites | 16 | 16090000026198 | 16090000026198 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000026212 | L16/questions_ecrites | 16 | 16090000026208 | 16090000026208 | 1 | JO_QUESTION | 2024-06-11 | 20240024 | |||
| 16090000026221 | L16/questions_ecrites | 16 | 16090000026217 | 16090000026217 | 1 | JO_QUESTION | 2024-05-07 | 20240019 | |||
| 16090000026248 | L16/questions_ecrites | 16 | 16090000026245 | 16090000026245 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000026308 | L16/questions_ecrites | 16 | 16090000026303 | 16090000026303 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000026336 | L16/questions_ecrites | 16 | 16090000026332 | 16090000026332 | 1 | JO_QUESTION | 2024-06-11 | 20240024 | |||
| 16090000026372 | L16/questions_ecrites | 16 | 16090000026367 | 16090000026367 | 1 | JO_QUESTION | 2023-01-10 | 20230002 | |||
| 16090000026412 | L16/questions_ecrites | 16 | 16090000026408 | 16090000026408 | 1 | JO_QUESTION | 2022-11-15 | 20220045 | |||
| 16090000026444 | L16/questions_ecrites | 16 | 16090000026441 | 16090000026441 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000026498 | L16/questions_ecrites | 16 | 16090000026494 | 16090000026494 | 1 | JO_QUESTION | 2024-05-14 | 20240020 | |||
| 16090000026508 | L16/questions_ecrites | 16 | 16090000026505 | 16090000026505 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026512 | L16/questions_ecrites | 16 | 16090000026509 | 16090000026509 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026527 | L16/questions_ecrites | 16 | 16090000026524 | 16090000026524 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026532 | L16/questions_ecrites | 16 | 16090000026528 | 16090000026528 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026561 | L16/questions_ecrites | 16 | 16090000026557 | 16090000026557 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026587 | L16/questions_ecrites | 16 | 16090000026583 | 16090000026583 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026605 | L16/questions_ecrites | 16 | 16090000026602 | 16090000026602 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026623 | L16/questions_ecrites | 16 | 16090000026619 | 16090000026619 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000026638 | L16/questions_ecrites | 16 | 16090000026635 | 16090000026635 | 1 | JO_QUESTION | 2024-06-11 | 20240024 | |||
| 16090000026712 | L16/questions_ecrites | 16 | 16090000026709 | 16090000026709 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026775 | L16/questions_ecrites | 16 | 16090000026772 | 16090000026772 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000026779 | L16/questions_ecrites | 16 | 16090000026776 | 16090000026776 | 1 | JO_QUESTION | 2024-05-14 | 20240020 | |||
| 16090000026793 | L16/questions_ecrites | 16 | 16090000026790 | 16090000026790 | 1 | JO_QUESTION | 2024-05-14 | 20240020 | |||
| 16090000026884 | L16/questions_ecrites | 16 | 16090000026881 | 16090000026881 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000026973 | L16/questions_ecrites | 16 | 16090000026969 | 16090000026969 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000027041 | L16/questions_ecrites | 16 | 16090000027038 | 16090000027038 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000027048 | L16/questions_ecrites | 16 | 16090000027045 | 16090000027045 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000027065 | L16/questions_ecrites | 16 | 16090000027062 | 16090000027062 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000027075 | L16/questions_ecrites | 16 | 16090000027072 | 16090000027072 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000027079 | L16/questions_ecrites | 16 | 16090000027076 | 16090000027076 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000027135 | L16/questions_ecrites | 16 | 16090000027132 | 16090000027132 | 1 | JO_QUESTION | 2024-06-04 | 20240023 | |||
| 16090000027146 | L16/questions_ecrites | 16 | 16090000027143 | 16090000027143 | 1 | JO_QUESTION | 2024-06-11 | 20240024 | |||
| 16090000027156 | L16/questions_ecrites | 16 | 16090000027153 | 16090000027153 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000027239 | L16/questions_ecrites | 16 | 16090000027236 | 16090000027236 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000027275 | L16/questions_ecrites | 16 | 16090000027271 | 16090000027271 | 1 | JO_QUESTION | 2023-06-20 | 20230025 | |||
| 16090000027338 | L16/questions_ecrites | 16 | 16090000027335 | 16090000027335 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000027390 | L16/questions_ecrites | 16 | 16090000027386 | 16090000027386 | 1 | JO_QUESTION | 2024-05-21 | 20240021 | |||
| 16090000027432 | L16/questions_ecrites | 16 | 16090000027429 | 16090000027429 | 1 | JO_QUESTION | 2024-06-04 | 20240023 |