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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000204208 | L15/questions_ecrites | 15 | 15090000204204 | 15090000204204 | 1 | JO_QUESTION | 05/12/2017 | ||||
| 15090000204217 | L15/questions_ecrites | 15 | 15090000204213 | 15090000204213 | 1 | JO_QUESTION | 28/08/2018 | ||||
| 15090000204316 | L15/questions_ecrites | 15 | 15090000204310 | 15090000204310 | 1 | JO_QUESTION | 26/02/2019 | ||||
| 15090000204317 | L15/questions_ecrites | 15 | 15090000204310 | 15090000204310 | 2 | JO_QUESTION | 09/07/2019 | ||||
| 15090000204318 | L15/questions_ecrites | 15 | 15090000204310 | 15090000204310 | 3 | JO_QUESTION | 21/07/2020 | ||||
| 15090000204319 | L15/questions_ecrites | 15 | 15090000204310 | 15090000204310 | 4 | JO_QUESTION | 03/11/2020 | ||||
| 15090000204418 | L15/questions_ecrites | 15 | 15090000204414 | 15090000204414 | 1 | JO_QUESTION | 25/09/2018 | ||||
| 15090000204443 | L15/questions_ecrites | 15 | 15090000204439 | 15090000204439 | 1 | JO_QUESTION | 07/08/2018 | ||||
| 15090000204444 | L15/questions_ecrites | 15 | 15090000204439 | 15090000204439 | 2 | JO_QUESTION | 04/12/2018 | ||||
| 15090000204496 | L15/questions_ecrites | 15 | 15090000204492 | 15090000204492 | 1 | JO_QUESTION | 07/08/2018 | ||||
| 15090000204497 | L15/questions_ecrites | 15 | 15090000204492 | 15090000204492 | 2 | JO_QUESTION | 13/11/2018 | ||||
| 15090000204498 | L15/questions_ecrites | 15 | 15090000204492 | 15090000204492 | 3 | JO_QUESTION | 26/03/2019 | ||||
| 15090000204499 | L15/questions_ecrites | 15 | 15090000204492 | 15090000204492 | 4 | JO_QUESTION | 16/07/2019 | ||||
| 15090000204530 | L15/questions_ecrites | 15 | 15090000204526 | 15090000204526 | 1 | JO_QUESTION | 27/11/2018 | ||||
| 15090000204531 | L15/questions_ecrites | 15 | 15090000204526 | 15090000204526 | 2 | JO_QUESTION | 26/03/2019 | ||||
| 15090000204548 | L15/questions_ecrites | 15 | 15090000204541 | 15090000204541 | 1 | JO_QUESTION | 29/01/2019 | ||||
| 15090000204549 | L15/questions_ecrites | 15 | 15090000204541 | 15090000204541 | 2 | JO_QUESTION | 18/06/2019 | ||||
| 15090000204567 | L15/questions_ecrites | 15 | 15090000204562 | 15090000204562 | 1 | JO_QUESTION | 14/08/2018 | ||||
| 15090000204581 | L15/questions_ecrites | 15 | 15090000204577 | 15090000204577 | 1 | JO_QUESTION | 31/07/2018 | ||||
| 15090000204590 | L15/questions_ecrites | 15 | 15090000204586 | 15090000204586 | 1 | JO_QUESTION | 31/07/2018 | ||||
| 15090000204607 | L15/questions_ecrites | 15 | 15090000204603 | 15090000204603 | 1 | JO_QUESTION | 31/07/2018 | ||||
| 15090000204636 | L15/questions_ecrites | 15 | 15090000204631 | 15090000204631 | 1 | JO_QUESTION | 07/08/2018 | ||||
| 15090000204637 | L15/questions_ecrites | 15 | 15090000204631 | 15090000204631 | 2 | JO_QUESTION | 27/11/2018 | ||||
| 15090000204727 | L15/questions_ecrites | 15 | 15090000204722 | 15090000204722 | 1 | JO_QUESTION | 31/07/2018 | ||||
| 15090000204759 | L15/questions_ecrites | 15 | 15090000204754 | 15090000204754 | 1 | JO_QUESTION | 28/11/2017 | ||||
| 15090000204779 | L15/questions_ecrites | 15 | 15090000204773 | 15090000204773 | 1 | JO_QUESTION | 01/10/2019 | ||||
| 15090000204780 | L15/questions_ecrites | 15 | 15090000204773 | 15090000204773 | 2 | JO_QUESTION | 17/03/2020 | ||||
| 15090000204813 | L15/questions_ecrites | 15 | 15090000204809 | 15090000204809 | 1 | JO_QUESTION | 28/11/2017 | ||||
| 15090000204818 | L15/questions_ecrites | 15 | 15090000204814 | 15090000204814 | 1 | JO_QUESTION | 02/10/2018 | ||||
| 15090000204835 | L15/questions_ecrites | 15 | 15090000204831 | 15090000204831 | 1 | JO_QUESTION | 31/07/2018 | ||||
| 15090000204858 | L15/questions_ecrites | 15 | 15090000204854 | 15090000204854 | 1 | JO_QUESTION | 07/08/2018 | ||||
| 15090000204919 | L15/questions_ecrites | 15 | 15090000204914 | 15090000204914 | 1 | JO_QUESTION | 07/08/2018 | ||||
| 15090000204929 | L15/questions_ecrites | 15 | 15090000204925 | 15090000204925 | 1 | JO_QUESTION | 04/09/2018 | ||||
| 15090000204934 | L15/questions_ecrites | 15 | 15090000204930 | 15090000204930 | 1 | JO_QUESTION | 16/10/2018 | ||||
| 15090000204974 | L15/questions_ecrites | 15 | 15090000204969 | 15090000204969 | 1 | JO_QUESTION | 17/12/2019 | ||||
| 15090000204990 | L15/questions_ecrites | 15 | 15090000204985 | 15090000204985 | 1 | JO_QUESTION | 30/10/2018 | ||||
| 15090000205012 | L15/questions_ecrites | 15 | 15090000205008 | 15090000205008 | 1 | JO_QUESTION | 04/12/2018 | ||||
| 15090000205013 | L15/questions_ecrites | 15 | 15090000205008 | 15090000205008 | 2 | JO_QUESTION | 30/04/2019 | ||||
| 15090000205086 | L15/questions_ecrites | 15 | 15090000205081 | 15090000205081 | 1 | JO_QUESTION | 28/05/2019 | ||||
| 15090000205105 | L15/questions_ecrites | 15 | 15090000205100 | 15090000205100 | 1 | JO_QUESTION | 04/09/2018 | ||||
| 15090000205118 | L15/questions_ecrites | 15 | 15090000205114 | 15090000205114 | 1 | JO_QUESTION | 14/08/2018 | ||||
| 15090000205135 | L15/questions_ecrites | 15 | 15090000205131 | 15090000205131 | 1 | JO_QUESTION | 25/06/2019 | ||||
| 15090000205271 | L15/questions_ecrites | 15 | 15090000205267 | 15090000205267 | 1 | JO_QUESTION | 31/07/2018 | ||||
| 15090000205282 | L15/questions_ecrites | 15 | 15090000205276 | 15090000205276 | 1 | JO_QUESTION | 02/10/2018 | ||||
| 15090000205283 | L15/questions_ecrites | 15 | 15090000205276 | 15090000205276 | 2 | JO_QUESTION | 09/04/2019 | ||||
| 15090000205284 | L15/questions_ecrites | 15 | 15090000205276 | 15090000205276 | 3 | JO_QUESTION | 28/01/2020 | ||||
| 15090000205285 | L15/questions_ecrites | 15 | 15090000205276 | 15090000205276 | 4 | JO_QUESTION | 07/07/2020 | ||||
| 15090000205286 | L15/questions_ecrites | 15 | 15090000205276 | 15090000205276 | 5 | JO_QUESTION | 24/08/2021 | ||||
| 15090000205287 | L15/questions_ecrites | 15 | 15090000205276 | 15090000205276 | 6 | JO_QUESTION | 07/12/2021 | ||||
| 15090000205314 | L15/questions_ecrites | 15 | 15090000205310 | 15090000205310 | 1 | JO_QUESTION | 31/07/2018 |