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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000129715 | L15/questions_ecrites | 15 | 15090000129700 | 15090000129700 | 10 | JO_QUESTION | 16/02/2021 | ||||
| 15090000129716 | L15/questions_ecrites | 15 | 15090000129700 | 15090000129700 | 11 | JO_QUESTION | 08/06/2021 | ||||
| 15090000129717 | L15/questions_ecrites | 15 | 15090000129700 | 15090000129700 | 12 | JO_QUESTION | 21/09/2021 | ||||
| 15090000129718 | L15/questions_ecrites | 15 | 15090000129700 | 15090000129700 | 13 | JO_QUESTION | 04/01/2022 | ||||
| 15090000129728 | L15/questions_ecrites | 15 | 15090000129723 | 15090000129723 | 1 | JO_QUESTION | 09/03/2021 | ||||
| 15090000129772 | L15/questions_ecrites | 15 | 15090000129768 | 15090000129768 | 1 | JO_QUESTION | 27/04/2021 | ||||
| 15090000129777 | L15/questions_ecrites | 15 | 15090000129773 | 15090000129773 | 1 | JO_QUESTION | 27/04/2021 | ||||
| 15090000129778 | L15/questions_ecrites | 15 | 15090000129773 | 15090000129773 | 2 | JO_QUESTION | 04/01/2022 | ||||
| 15090000129787 | L15/questions_ecrites | 15 | 15090000129783 | 15090000129783 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000129824 | L15/questions_ecrites | 15 | 15090000129820 | 15090000129820 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000129855 | L15/questions_ecrites | 15 | 15090000129851 | 15090000129851 | 1 | JO_QUESTION | 27/04/2021 | ||||
| 15090000129872 | L15/questions_ecrites | 15 | 15090000129868 | 15090000129868 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000129897 | L15/questions_ecrites | 15 | 15090000129893 | 15090000129893 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000129908 | L15/questions_ecrites | 15 | 15090000129904 | 15090000129904 | 1 | JO_QUESTION | 04/01/2022 | ||||
| 15090000129909 | L15/questions_ecrites | 15 | 15090000129904 | 15090000129904 | 2 | JO_QUESTION | 07/06/2022 | ||||
| 15090000129919 | L15/questions_ecrites | 15 | 15090000129914 | 15090000129914 | 1 | JO_QUESTION | 20/03/2018 | ||||
| 15090000129965 | L15/questions_ecrites | 15 | 15090000129961 | 15090000129961 | 1 | JO_QUESTION | 06/03/2018 | ||||
| 15090000129969 | L15/questions_ecrites | 15 | 15090000129966 | 15090000129966 | 1 | JO_QUESTION | 25/05/2021 | ||||
| 15090000129998 | L15/questions_ecrites | 15 | 15090000129993 | 15090000129993 | 1 | JO_QUESTION | 30/03/2021 | ||||
| 15090000129999 | L15/questions_ecrites | 15 | 15090000129993 | 15090000129993 | 2 | JO_QUESTION | 23/11/2021 | ||||
| 15090000130017 | L15/questions_ecrites | 15 | 15090000130012 | 15090000130012 | 1 | JO_QUESTION | 27/03/2018 | ||||
| 15090000130018 | L15/questions_ecrites | 15 | 15090000130012 | 15090000130012 | 2 | JO_QUESTION | 03/07/2018 | ||||
| 15090000130019 | L15/questions_ecrites | 15 | 15090000130012 | 15090000130012 | 3 | JO_QUESTION | 16/10/2018 | ||||
| 15090000130057 | L15/questions_ecrites | 15 | 15090000130053 | 15090000130053 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000130058 | L15/questions_ecrites | 15 | 15090000130053 | 15090000130053 | 2 | JO_QUESTION | 01/06/2021 | ||||
| 15090000130059 | L15/questions_ecrites | 15 | 15090000130053 | 15090000130053 | 3 | JO_QUESTION | 12/10/2021 | ||||
| 15090000130060 | L15/questions_ecrites | 15 | 15090000130053 | 15090000130053 | 4 | JO_QUESTION | 25/01/2022 | ||||
| 15090000130116 | L15/questions_ecrites | 15 | 15090000130113 | 15090000130113 | 1 | JO_QUESTION | 13/04/2021 | ||||
| 15090000130172 | L15/questions_ecrites | 15 | 15090000130165 | 15090000130165 | 1 | JO_QUESTION | 06/03/2018 | ||||
| 15090000130211 | L15/questions_ecrites | 15 | 15090000130207 | 15090000130207 | 1 | JO_QUESTION | 19/10/2021 | ||||
| 15090000130234 | L15/questions_ecrites | 15 | 15090000130230 | 15090000130230 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000130235 | L15/questions_ecrites | 15 | 15090000130230 | 15090000130230 | 2 | JO_QUESTION | 08/06/2021 | ||||
| 15090000130299 | L15/questions_ecrites | 15 | 15090000130294 | 15090000130294 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000130318 | L15/questions_ecrites | 15 | 15090000130314 | 15090000130314 | 1 | JO_QUESTION | 06/03/2018 | ||||
| 15090000130379 | L15/questions_ecrites | 15 | 15090000130375 | 15090000130375 | 1 | JO_QUESTION | 09/03/2021 | ||||
| 15090000130380 | L15/questions_ecrites | 15 | 15090000130375 | 15090000130375 | 2 | JO_QUESTION | 10/08/2021 | ||||
| 15090000130385 | L15/questions_ecrites | 15 | 15090000130381 | 15090000130381 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000130458 | L15/questions_ecrites | 15 | 15090000130454 | 15090000130454 | 1 | JO_QUESTION | 25/05/2021 | ||||
| 15090000130459 | L15/questions_ecrites | 15 | 15090000130454 | 15090000130454 | 2 | JO_QUESTION | 04/01/2022 | ||||
| 15090000130495 | L15/questions_ecrites | 15 | 15090000130491 | 15090000130491 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000130496 | L15/questions_ecrites | 15 | 15090000130491 | 15090000130491 | 2 | JO_QUESTION | 22/06/2021 | ||||
| 15090000130497 | L15/questions_ecrites | 15 | 15090000130491 | 15090000130491 | 3 | JO_QUESTION | 04/01/2022 | ||||
| 15090000130498 | L15/questions_ecrites | 15 | 15090000130491 | 15090000130491 | 4 | JO_QUESTION | 07/06/2022 | ||||
| 15090000130516 | L15/questions_ecrites | 15 | 15090000130511 | 15090000130511 | 1 | JO_QUESTION | 06/04/2021 | ||||
| 15090000130529 | L15/questions_ecrites | 15 | 15090000130525 | 15090000130525 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000130542 | L15/questions_ecrites | 15 | 15090000130538 | 15090000130538 | 1 | JO_QUESTION | 27/04/2021 | ||||
| 15090000130571 | L15/questions_ecrites | 15 | 15090000130567 | 15090000130567 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000130572 | L15/questions_ecrites | 15 | 15090000130567 | 15090000130567 | 2 | JO_QUESTION | 01/06/2021 | ||||
| 15090000130573 | L15/questions_ecrites | 15 | 15090000130567 | 15090000130567 | 3 | JO_QUESTION | 21/09/2021 | ||||
| 15090000130574 | L15/questions_ecrites | 15 | 15090000130567 | 15090000130567 | 4 | JO_QUESTION | 04/01/2022 |