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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000070280 | L15/questions_ecrites | 15 | 15090000070275 | 15090000070275 | 1 | JO_QUESTION | 09/06/2020 | ||||
| 15090000070293 | L15/questions_ecrites | 15 | 15090000070289 | 15090000070289 | 1 | JO_QUESTION | 01/05/2018 | ||||
| 15090000070312 | L15/questions_ecrites | 15 | 15090000070307 | 15090000070307 | 1 | JO_QUESTION | 04/02/2020 | ||||
| 15090000070313 | L15/questions_ecrites | 15 | 15090000070307 | 15090000070307 | 2 | JO_QUESTION | 07/07/2020 | ||||
| 15090000070314 | L15/questions_ecrites | 15 | 15090000070307 | 15090000070307 | 3 | JO_QUESTION | 20/10/2020 | ||||
| 15090000070339 | L15/questions_ecrites | 15 | 15090000070333 | 15090000070333 | 1 | JO_QUESTION | 14/01/2020 | ||||
| 15090000070340 | L15/questions_ecrites | 15 | 15090000070333 | 15090000070333 | 2 | JO_QUESTION | 26/05/2020 | ||||
| 15090000070341 | L15/questions_ecrites | 15 | 15090000070333 | 15090000070333 | 3 | JO_QUESTION | 08/09/2020 | ||||
| 15090000070347 | L15/questions_ecrites | 15 | 15090000070342 | 15090000070342 | 1 | JO_QUESTION | 21/01/2020 | ||||
| 15090000070348 | L15/questions_ecrites | 15 | 15090000070342 | 15090000070342 | 2 | JO_QUESTION | 09/06/2020 | ||||
| 15090000070353 | L15/questions_ecrites | 15 | 15090000070349 | 15090000070349 | 1 | JO_QUESTION | 30/01/2018 | ||||
| 15090000070366 | L15/questions_ecrites | 15 | 15090000070360 | 15090000070360 | 1 | JO_QUESTION | 14/01/2020 | ||||
| 15090000070367 | L15/questions_ecrites | 15 | 15090000070360 | 15090000070360 | 2 | JO_QUESTION | 26/05/2020 | ||||
| 15090000070368 | L15/questions_ecrites | 15 | 15090000070360 | 15090000070360 | 3 | JO_QUESTION | 06/10/2020 | ||||
| 15090000070369 | L15/questions_ecrites | 15 | 15090000070360 | 15090000070360 | 4 | JO_QUESTION | 02/02/2021 | ||||
| 15090000070380 | L15/questions_ecrites | 15 | 15090000070375 | 15090000070375 | 1 | JO_QUESTION | 13/10/2020 | ||||
| 15090000070404 | L15/questions_ecrites | 15 | 15090000070399 | 15090000070399 | 1 | JO_QUESTION | 04/02/2020 | ||||
| 15090000070405 | L15/questions_ecrites | 15 | 15090000070399 | 15090000070399 | 2 | JO_QUESTION | 26/05/2020 | ||||
| 15090000070455 | L15/questions_ecrites | 15 | 15090000070450 | 15090000070450 | 1 | JO_QUESTION | 10/03/2020 | ||||
| 15090000070456 | L15/questions_ecrites | 15 | 15090000070450 | 15090000070450 | 2 | JO_QUESTION | 16/06/2020 | ||||
| 15090000070500 | L15/questions_ecrites | 15 | 15090000070495 | 15090000070495 | 1 | JO_QUESTION | 01/12/2020 | ||||
| 15090000070501 | L15/questions_ecrites | 15 | 15090000070495 | 15090000070495 | 2 | JO_QUESTION | 03/08/2021 | ||||
| 15090000070502 | L15/questions_ecrites | 15 | 15090000070495 | 15090000070495 | 3 | JO_QUESTION | 16/11/2021 | ||||
| 15090000070516 | L15/questions_ecrites | 15 | 15090000070512 | 15090000070512 | 1 | JO_QUESTION | 07/01/2020 | ||||
| 15090000070517 | L15/questions_ecrites | 15 | 15090000070512 | 15090000070512 | 2 | JO_QUESTION | 09/06/2020 | ||||
| 15090000070542 | L15/questions_ecrites | 15 | 15090000070537 | 15090000070537 | 1 | JO_QUESTION | 21/01/2020 | ||||
| 15090000070639 | L15/questions_ecrites | 15 | 15090000070633 | 15090000070633 | 1 | JO_QUESTION | 07/01/2020 | ||||
| 15090000070640 | L15/questions_ecrites | 15 | 15090000070633 | 15090000070633 | 2 | JO_QUESTION | 21/04/2020 | ||||
| 15090000070641 | L15/questions_ecrites | 15 | 15090000070633 | 15090000070633 | 3 | JO_QUESTION | 28/07/2020 | ||||
| 15090000070642 | L15/questions_ecrites | 15 | 15090000070633 | 15090000070633 | 4 | JO_QUESTION | 03/11/2020 | ||||
| 15090000070643 | L15/questions_ecrites | 15 | 15090000070633 | 15090000070633 | 5 | JO_QUESTION | 16/02/2021 | ||||
| 15090000070661 | L15/questions_ecrites | 15 | 15090000070656 | 15090000070656 | 1 | JO_QUESTION | 13/10/2020 | ||||
| 15090000070694 | L15/questions_ecrites | 15 | 15090000070689 | 15090000070689 | 1 | JO_QUESTION | 26/05/2020 | ||||
| 15090000070734 | L15/questions_ecrites | 15 | 15090000070727 | 15090000070727 | 1 | JO_QUESTION | 27/04/2021 | ||||
| 15090000070748 | L15/questions_ecrites | 15 | 15090000070743 | 15090000070743 | 1 | JO_QUESTION | 01/12/2020 | ||||
| 15090000070799 | L15/questions_ecrites | 15 | 15090000070795 | 15090000070795 | 1 | JO_QUESTION | 07/01/2020 | ||||
| 15090000070836 | L15/questions_ecrites | 15 | 15090000070831 | 15090000070831 | 1 | JO_QUESTION | 17/03/2020 | ||||
| 15090000070876 | L15/questions_ecrites | 15 | 15090000070872 | 15090000070872 | 1 | JO_QUESTION | 28/04/2020 | ||||
| 15090000070877 | L15/questions_ecrites | 15 | 15090000070872 | 15090000070872 | 2 | JO_QUESTION | 04/08/2020 | ||||
| 15090000070878 | L15/questions_ecrites | 15 | 15090000070872 | 15090000070872 | 3 | JO_QUESTION | 15/12/2020 | ||||
| 15090000070884 | L15/questions_ecrites | 15 | 15090000070879 | 15090000070879 | 1 | JO_QUESTION | 23/06/2020 | ||||
| 15090000070902 | L15/questions_ecrites | 15 | 15090000070898 | 15090000070898 | 1 | JO_QUESTION | 20/03/2018 | ||||
| 15090000070908 | L15/questions_ecrites | 15 | 15090000070903 | 15090000070903 | 1 | JO_QUESTION | 03/03/2020 | ||||
| 15090000070909 | L15/questions_ecrites | 15 | 15090000070903 | 15090000070903 | 2 | JO_QUESTION | 14/07/2020 | ||||
| 15090000070930 | L15/questions_ecrites | 15 | 15090000070924 | 15090000070924 | 1 | JO_QUESTION | 04/02/2020 | ||||
| 15090000070931 | L15/questions_ecrites | 15 | 15090000070924 | 15090000070924 | 2 | JO_QUESTION | 26/05/2020 | ||||
| 15090000070932 | L15/questions_ecrites | 15 | 15090000070924 | 15090000070924 | 3 | JO_QUESTION | 22/09/2020 | ||||
| 15090000070947 | L15/questions_ecrites | 15 | 15090000070941 | 15090000070941 | 1 | JO_QUESTION | 04/02/2020 | ||||
| 15090000070963 | L15/questions_ecrites | 15 | 15090000070959 | 15090000070959 | 1 | JO_QUESTION | 06/02/2018 | ||||
| 15090000070981 | L15/questions_ecrites | 15 | 15090000070976 | 15090000070976 | 1 | JO_QUESTION | 21/01/2020 |