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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000108264 | L15/questions_ecrites | 15 | 15090000108258 | 15090000108258 | 2 | JO_QUESTION | 15/03/2022 | ||||
| 15090000108293 | L15/questions_ecrites | 15 | 15090000108288 | 15090000108288 | 1 | JO_QUESTION | 20/10/2020 | ||||
| 15090000108310 | L15/questions_ecrites | 15 | 15090000108305 | 15090000108305 | 1 | JO_QUESTION | 01/12/2020 | ||||
| 15090000108311 | L15/questions_ecrites | 15 | 15090000108305 | 15090000108305 | 2 | JO_QUESTION | 03/08/2021 | ||||
| 15090000108312 | L15/questions_ecrites | 15 | 15090000108305 | 15090000108305 | 3 | JO_QUESTION | 16/11/2021 | ||||
| 15090000108355 | L15/questions_ecrites | 15 | 15090000108350 | 15090000108350 | 1 | JO_QUESTION | 22/09/2020 | ||||
| 15090000108356 | L15/questions_ecrites | 15 | 15090000108350 | 15090000108350 | 2 | JO_QUESTION | 12/01/2021 | ||||
| 15090000108357 | L15/questions_ecrites | 15 | 15090000108350 | 15090000108350 | 3 | JO_QUESTION | 11/05/2021 | ||||
| 15090000108358 | L15/questions_ecrites | 15 | 15090000108350 | 15090000108350 | 4 | JO_QUESTION | 28/09/2021 | ||||
| 15090000108359 | L15/questions_ecrites | 15 | 15090000108350 | 15090000108350 | 5 | JO_QUESTION | 11/01/2022 | ||||
| 15090000108360 | L15/questions_ecrites | 15 | 15090000108350 | 15090000108350 | 6 | JO_QUESTION | 10/05/2022 | ||||
| 15090000108401 | L15/questions_ecrites | 15 | 15090000108396 | 15090000108396 | 1 | JO_QUESTION | 27/10/2020 | ||||
| 15090000108440 | L15/questions_ecrites | 15 | 15090000108435 | 15090000108435 | 1 | JO_QUESTION | 19/10/2021 | ||||
| 15090000108458 | L15/questions_ecrites | 15 | 15090000108453 | 15090000108453 | 1 | JO_QUESTION | 20/10/2020 | ||||
| 15090000108459 | L15/questions_ecrites | 15 | 15090000108453 | 15090000108453 | 2 | JO_QUESTION | 26/01/2021 | ||||
| 15090000108465 | L15/questions_ecrites | 15 | 15090000108460 | 15090000108460 | 1 | JO_QUESTION | 20/10/2020 | ||||
| 15090000108543 | L15/questions_ecrites | 15 | 15090000108538 | 15090000108538 | 1 | JO_QUESTION | 20/10/2020 | ||||
| 15090000108544 | L15/questions_ecrites | 15 | 15090000108538 | 15090000108538 | 2 | JO_QUESTION | 26/01/2021 | ||||
| 15090000108545 | L15/questions_ecrites | 15 | 15090000108538 | 15090000108538 | 3 | JO_QUESTION | 18/05/2021 | ||||
| 15090000108592 | L15/questions_ecrites | 15 | 15090000108587 | 15090000108587 | 1 | JO_QUESTION | 17/11/2020 | ||||
| 15090000108593 | L15/questions_ecrites | 15 | 15090000108587 | 15090000108587 | 2 | JO_QUESTION | 15/02/2022 | ||||
| 15090000108599 | L15/questions_ecrites | 15 | 15090000108594 | 15090000108594 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000108600 | L15/questions_ecrites | 15 | 15090000108594 | 15090000108594 | 2 | JO_QUESTION | 12/01/2021 | ||||
| 15090000108650 | L15/questions_ecrites | 15 | 15090000108645 | 15090000108645 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000108651 | L15/questions_ecrites | 15 | 15090000108645 | 15090000108645 | 2 | JO_QUESTION | 13/04/2021 | ||||
| 15090000108652 | L15/questions_ecrites | 15 | 15090000108645 | 15090000108645 | 3 | JO_QUESTION | 05/10/2021 | ||||
| 15090000108653 | L15/questions_ecrites | 15 | 15090000108645 | 15090000108645 | 4 | JO_QUESTION | 18/01/2022 | ||||
| 15090000108654 | L15/questions_ecrites | 15 | 15090000108645 | 15090000108645 | 5 | JO_QUESTION | 26/04/2022 | ||||
| 15090000108678 | L15/questions_ecrites | 15 | 15090000108673 | 15090000108673 | 1 | JO_QUESTION | 15/09/2020 | ||||
| 15090000108679 | L15/questions_ecrites | 15 | 15090000108673 | 15090000108673 | 2 | JO_QUESTION | 22/12/2020 | ||||
| 15090000108716 | L15/questions_ecrites | 15 | 15090000108710 | 15090000108710 | 1 | JO_QUESTION | 13/10/2020 | ||||
| 15090000108722 | L15/questions_ecrites | 15 | 15090000108717 | 15090000108717 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000108723 | L15/questions_ecrites | 15 | 15090000108717 | 15090000108717 | 2 | JO_QUESTION | 15/12/2020 | ||||
| 15090000108733 | L15/questions_ecrites | 15 | 15090000108728 | 15090000108728 | 1 | JO_QUESTION | 06/10/2020 | ||||
| 15090000108734 | L15/questions_ecrites | 15 | 15090000108728 | 15090000108728 | 2 | JO_QUESTION | 02/02/2021 | ||||
| 15090000108735 | L15/questions_ecrites | 15 | 15090000108728 | 15090000108728 | 3 | JO_QUESTION | 02/02/2021 | ||||
| 15090000108736 | L15/questions_ecrites | 15 | 15090000108728 | 15090000108728 | 4 | JO_QUESTION | 22/06/2021 | ||||
| 15090000108737 | L15/questions_ecrites | 15 | 15090000108728 | 15090000108728 | 5 | JO_QUESTION | 18/01/2022 | ||||
| 15090000108738 | L15/questions_ecrites | 15 | 15090000108728 | 15090000108728 | 6 | JO_QUESTION | 26/04/2022 | ||||
| 15090000108782 | L15/questions_ecrites | 15 | 15090000108777 | 15090000108777 | 1 | JO_QUESTION | 01/12/2020 | ||||
| 15090000108801 | L15/questions_ecrites | 15 | 15090000108796 | 15090000108796 | 1 | JO_QUESTION | 08/09/2020 | ||||
| 15090000108869 | L15/questions_ecrites | 15 | 15090000108862 | 15090000108862 | 1 | JO_QUESTION | 20/10/2020 | ||||
| 15090000108876 | L15/questions_ecrites | 15 | 15090000108870 | 15090000108870 | 1 | JO_QUESTION | 30/03/2021 | ||||
| 15090000108877 | L15/questions_ecrites | 15 | 15090000108870 | 15090000108870 | 2 | JO_QUESTION | 23/11/2021 | ||||
| 15090000108909 | L15/questions_ecrites | 15 | 15090000108904 | 15090000108904 | 1 | JO_QUESTION | 01/12/2020 | ||||
| 15090000108910 | L15/questions_ecrites | 15 | 15090000108904 | 15090000108904 | 2 | JO_QUESTION | 03/08/2021 | ||||
| 15090000108911 | L15/questions_ecrites | 15 | 15090000108904 | 15090000108904 | 3 | JO_QUESTION | 16/11/2021 | ||||
| 15090000109094 | L15/questions_ecrites | 15 | 15090000109089 | 15090000109089 | 1 | JO_QUESTION | 22/09/2020 | ||||
| 15090000109144 | L15/questions_ecrites | 15 | 15090000109139 | 15090000109139 | 1 | JO_QUESTION | 26/10/2021 | ||||
| 15090000109262 | L15/questions_ecrites | 15 | 15090000109257 | 15090000109257 | 1 | JO_QUESTION | 20/10/2020 |