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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000105883 | L15/questions_ecrites | 15 | 15090000105878 | 15090000105878 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000105884 | L15/questions_ecrites | 15 | 15090000105878 | 15090000105878 | 2 | JO_QUESTION | 15/12/2020 | ||||
| 15090000105885 | L15/questions_ecrites | 15 | 15090000105878 | 15090000105878 | 3 | JO_QUESTION | 23/03/2021 | ||||
| 15090000105886 | L15/questions_ecrites | 15 | 15090000105878 | 15090000105878 | 4 | JO_QUESTION | 29/06/2021 | ||||
| 15090000105887 | L15/questions_ecrites | 15 | 15090000105878 | 15090000105878 | 5 | JO_QUESTION | 05/10/2021 | ||||
| 15090000105888 | L15/questions_ecrites | 15 | 15090000105878 | 15090000105878 | 6 | JO_QUESTION | 11/01/2022 | ||||
| 15090000105889 | L15/questions_ecrites | 15 | 15090000105878 | 15090000105878 | 7 | JO_QUESTION | 03/05/2022 | ||||
| 15090000105910 | L15/questions_ecrites | 15 | 15090000105905 | 15090000105905 | 1 | JO_QUESTION | 01/12/2020 | ||||
| 15090000105921 | L15/questions_ecrites | 15 | 15090000105916 | 15090000105916 | 1 | JO_QUESTION | 19/10/2021 | ||||
| 15090000105935 | L15/questions_ecrites | 15 | 15090000105930 | 15090000105930 | 1 | JO_QUESTION | 17/11/2020 | ||||
| 15090000106044 | L15/questions_ecrites | 15 | 15090000106038 | 15090000106038 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106049 | L15/questions_ecrites | 15 | 15090000106045 | 15090000106045 | 1 | JO_QUESTION | 11/09/2018 | ||||
| 15090000106066 | L15/questions_ecrites | 15 | 15090000106061 | 15090000106061 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106111 | L15/questions_ecrites | 15 | 15090000106105 | 15090000106105 | 1 | JO_QUESTION | 27/02/2018 | ||||
| 15090000106145 | L15/questions_ecrites | 15 | 15090000106140 | 15090000106140 | 1 | JO_QUESTION | 17/11/2020 | ||||
| 15090000106156 | L15/questions_ecrites | 15 | 15090000106151 | 15090000106151 | 1 | JO_QUESTION | 15/09/2020 | ||||
| 15090000106157 | L15/questions_ecrites | 15 | 15090000106151 | 15090000106151 | 2 | JO_QUESTION | 29/12/2020 | ||||
| 15090000106158 | L15/questions_ecrites | 15 | 15090000106151 | 15090000106151 | 3 | JO_QUESTION | 20/04/2021 | ||||
| 15090000106159 | L15/questions_ecrites | 15 | 15090000106151 | 15090000106151 | 4 | JO_QUESTION | 12/04/2022 | ||||
| 15090000106165 | L15/questions_ecrites | 15 | 15090000106160 | 15090000106160 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106166 | L15/questions_ecrites | 15 | 15090000106160 | 15090000106160 | 2 | JO_QUESTION | 15/12/2020 | ||||
| 15090000106182 | L15/questions_ecrites | 15 | 15090000106176 | 15090000106176 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106188 | L15/questions_ecrites | 15 | 15090000106183 | 15090000106183 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106242 | L15/questions_ecrites | 15 | 15090000106236 | 15090000106236 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106243 | L15/questions_ecrites | 15 | 15090000106236 | 15090000106236 | 2 | JO_QUESTION | 15/12/2020 | ||||
| 15090000106265 | L15/questions_ecrites | 15 | 15090000106259 | 15090000106259 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106266 | L15/questions_ecrites | 15 | 15090000106259 | 15090000106259 | 2 | JO_QUESTION | 22/12/2020 | ||||
| 15090000106267 | L15/questions_ecrites | 15 | 15090000106259 | 15090000106259 | 3 | JO_QUESTION | 30/03/2021 | ||||
| 15090000106268 | L15/questions_ecrites | 15 | 15090000106259 | 15090000106259 | 4 | JO_QUESTION | 06/07/2021 | ||||
| 15090000106269 | L15/questions_ecrites | 15 | 15090000106259 | 15090000106259 | 5 | JO_QUESTION | 07/12/2021 | ||||
| 15090000106306 | L15/questions_ecrites | 15 | 15090000106299 | 15090000106299 | 1 | JO_QUESTION | 01/12/2020 | ||||
| 15090000106343 | L15/questions_ecrites | 15 | 15090000106338 | 15090000106338 | 1 | JO_QUESTION | 22/09/2020 | ||||
| 15090000106354 | L15/questions_ecrites | 15 | 15090000106349 | 15090000106349 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106373 | L15/questions_ecrites | 15 | 15090000106368 | 15090000106368 | 1 | JO_QUESTION | 22/09/2020 | ||||
| 15090000106395 | L15/questions_ecrites | 15 | 15090000106390 | 15090000106390 | 1 | JO_QUESTION | 06/10/2020 | ||||
| 15090000106407 | L15/questions_ecrites | 15 | 15090000106402 | 15090000106402 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106408 | L15/questions_ecrites | 15 | 15090000106402 | 15090000106402 | 2 | JO_QUESTION | 15/12/2020 | ||||
| 15090000106497 | L15/questions_ecrites | 15 | 15090000106492 | 15090000106492 | 1 | JO_QUESTION | 22/09/2020 | ||||
| 15090000106533 | L15/questions_ecrites | 15 | 15090000106528 | 15090000106528 | 1 | JO_QUESTION | 03/11/2020 | ||||
| 15090000106565 | L15/questions_ecrites | 15 | 15090000106560 | 15090000106560 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106571 | L15/questions_ecrites | 15 | 15090000106566 | 15090000106566 | 1 | JO_QUESTION | 20/10/2020 | ||||
| 15090000106586 | L15/questions_ecrites | 15 | 15090000106582 | 15090000106582 | 1 | JO_QUESTION | 06/10/2020 | ||||
| 15090000106587 | L15/questions_ecrites | 15 | 15090000106582 | 15090000106582 | 2 | JO_QUESTION | 02/02/2021 | ||||
| 15090000106588 | L15/questions_ecrites | 15 | 15090000106582 | 15090000106582 | 3 | JO_QUESTION | 08/06/2021 | ||||
| 15090000106589 | L15/questions_ecrites | 15 | 15090000106582 | 15090000106582 | 4 | JO_QUESTION | 28/09/2021 | ||||
| 15090000106590 | L15/questions_ecrites | 15 | 15090000106582 | 15090000106582 | 5 | JO_QUESTION | 18/01/2022 | ||||
| 15090000106669 | L15/questions_ecrites | 15 | 15090000106664 | 15090000106664 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106670 | L15/questions_ecrites | 15 | 15090000106664 | 15090000106664 | 2 | JO_QUESTION | 15/12/2020 | ||||
| 15090000106676 | L15/questions_ecrites | 15 | 15090000106671 | 15090000106671 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000106720 | L15/questions_ecrites | 15 | 15090000106715 | 15090000106715 | 1 | JO_QUESTION | 08/09/2020 |