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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000122003 | L15/questions_ecrites | 15 | 15090000121996 | 15090000121996 | 4 | JO_QUESTION | 07/06/2022 | ||||
| 15090000122021 | L15/questions_ecrites | 15 | 15090000122016 | 15090000122016 | 1 | JO_QUESTION | 06/03/2018 | ||||
| 15090000122022 | L15/questions_ecrites | 15 | 15090000122016 | 15090000122016 | 2 | JO_QUESTION | 12/06/2018 | ||||
| 15090000122046 | L15/questions_ecrites | 15 | 15090000122042 | 15090000122042 | 1 | JO_QUESTION | 19/01/2021 | ||||
| 15090000122056 | L15/questions_ecrites | 15 | 15090000122052 | 15090000122052 | 1 | JO_QUESTION | 19/01/2021 | ||||
| 15090000122057 | L15/questions_ecrites | 15 | 15090000122052 | 15090000122052 | 2 | JO_QUESTION | 10/08/2021 | ||||
| 15090000122079 | L15/questions_ecrites | 15 | 15090000122075 | 15090000122075 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000122080 | L15/questions_ecrites | 15 | 15090000122075 | 15090000122075 | 2 | JO_QUESTION | 01/06/2021 | ||||
| 15090000122081 | L15/questions_ecrites | 15 | 15090000122075 | 15090000122075 | 3 | JO_QUESTION | 12/10/2021 | ||||
| 15090000122082 | L15/questions_ecrites | 15 | 15090000122075 | 15090000122075 | 4 | JO_QUESTION | 25/01/2022 | ||||
| 15090000122083 | L15/questions_ecrites | 15 | 15090000122075 | 15090000122075 | 5 | JO_QUESTION | 17/05/2022 | ||||
| 15090000122128 | L15/questions_ecrites | 15 | 15090000122124 | 15090000122124 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000122188 | L15/questions_ecrites | 15 | 15090000122183 | 15090000122183 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000122189 | L15/questions_ecrites | 15 | 15090000122183 | 15090000122183 | 2 | JO_QUESTION | 22/06/2021 | ||||
| 15090000122190 | L15/questions_ecrites | 15 | 15090000122183 | 15090000122183 | 3 | JO_QUESTION | 04/01/2022 | ||||
| 15090000122191 | L15/questions_ecrites | 15 | 15090000122183 | 15090000122183 | 4 | JO_QUESTION | 07/06/2022 | ||||
| 15090000122210 | L15/questions_ecrites | 15 | 15090000122205 | 15090000122205 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000122221 | L15/questions_ecrites | 15 | 15090000122215 | 15090000122215 | 1 | JO_QUESTION | 01/06/2021 | ||||
| 15090000122245 | L15/questions_ecrites | 15 | 15090000122240 | 15090000122240 | 1 | JO_QUESTION | 23/03/2021 | ||||
| 15090000122246 | L15/questions_ecrites | 15 | 15090000122240 | 15090000122240 | 2 | JO_QUESTION | 26/10/2021 | ||||
| 15090000122260 | L15/questions_ecrites | 15 | 15090000122256 | 15090000122256 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000122261 | L15/questions_ecrites | 15 | 15090000122256 | 15090000122256 | 2 | JO_QUESTION | 20/04/2021 | ||||
| 15090000122262 | L15/questions_ecrites | 15 | 15090000122256 | 15090000122256 | 3 | JO_QUESTION | 03/08/2021 | ||||
| 15090000122263 | L15/questions_ecrites | 15 | 15090000122256 | 15090000122256 | 4 | JO_QUESTION | 04/01/2022 | ||||
| 15090000122264 | L15/questions_ecrites | 15 | 15090000122256 | 15090000122256 | 5 | JO_QUESTION | 26/04/2022 | ||||
| 15090000122281 | L15/questions_ecrites | 15 | 15090000122277 | 15090000122277 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000122308 | L15/questions_ecrites | 15 | 15090000122304 | 15090000122304 | 1 | JO_QUESTION | 26/01/2021 | ||||
| 15090000122309 | L15/questions_ecrites | 15 | 15090000122304 | 15090000122304 | 2 | JO_QUESTION | 02/11/2021 | ||||
| 15090000122344 | L15/questions_ecrites | 15 | 15090000122340 | 15090000122340 | 1 | JO_QUESTION | 26/01/2021 | ||||
| 15090000122385 | L15/questions_ecrites | 15 | 15090000122381 | 15090000122381 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000122402 | L15/questions_ecrites | 15 | 15090000122398 | 15090000122398 | 1 | JO_QUESTION | 22/12/2020 | ||||
| 15090000122503 | L15/questions_ecrites | 15 | 15090000122499 | 15090000122499 | 1 | JO_QUESTION | 09/03/2021 | ||||
| 15090000122540 | L15/questions_ecrites | 15 | 15090000122536 | 15090000122536 | 1 | JO_QUESTION | 22/12/2020 | ||||
| 15090000122541 | L15/questions_ecrites | 15 | 15090000122536 | 15090000122536 | 2 | JO_QUESTION | 30/03/2021 | ||||
| 15090000122542 | L15/questions_ecrites | 15 | 15090000122536 | 15090000122536 | 3 | JO_QUESTION | 06/07/2021 | ||||
| 15090000122543 | L15/questions_ecrites | 15 | 15090000122536 | 15090000122536 | 4 | JO_QUESTION | 12/10/2021 | ||||
| 15090000122544 | L15/questions_ecrites | 15 | 15090000122536 | 15090000122536 | 5 | JO_QUESTION | 18/01/2022 | ||||
| 15090000122545 | L15/questions_ecrites | 15 | 15090000122536 | 15090000122536 | 6 | JO_QUESTION | 03/05/2022 | ||||
| 15090000122555 | L15/questions_ecrites | 15 | 15090000122550 | 15090000122550 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000122638 | L15/questions_ecrites | 15 | 15090000122633 | 15090000122633 | 1 | JO_QUESTION | 22/12/2020 | ||||
| 15090000122655 | L15/questions_ecrites | 15 | 15090000122651 | 15090000122651 | 1 | JO_QUESTION | 22/12/2020 | ||||
| 15090000122685 | L15/questions_ecrites | 15 | 15090000122681 | 15090000122681 | 1 | JO_QUESTION | 04/05/2021 | ||||
| 15090000122686 | L15/questions_ecrites | 15 | 15090000122681 | 15090000122681 | 2 | JO_QUESTION | 26/10/2021 | ||||
| 15090000122687 | L15/questions_ecrites | 15 | 15090000122681 | 15090000122681 | 3 | JO_QUESTION | 01/02/2022 | ||||
| 15090000122701 | L15/questions_ecrites | 15 | 15090000122697 | 15090000122697 | 1 | JO_QUESTION | 22/12/2020 | ||||
| 15090000122733 | L15/questions_ecrites | 15 | 15090000122728 | 15090000122728 | 1 | JO_QUESTION | 22/12/2020 | ||||
| 15090000122739 | L15/questions_ecrites | 15 | 15090000122734 | 15090000122734 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000122740 | L15/questions_ecrites | 15 | 15090000122734 | 15090000122734 | 2 | JO_QUESTION | 20/04/2021 | ||||
| 15090000122741 | L15/questions_ecrites | 15 | 15090000122734 | 15090000122734 | 3 | JO_QUESTION | 03/08/2021 | ||||
| 15090000122742 | L15/questions_ecrites | 15 | 15090000122734 | 15090000122734 | 4 | JO_QUESTION | 04/01/2022 |