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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15090000124993 | L15/questions_ecrites | 15 | 15090000124988 | 15090000124988 | 2 | JO_QUESTION | 11/05/2021 | ||||
| 15090000124994 | L15/questions_ecrites | 15 | 15090000124988 | 15090000124988 | 3 | JO_QUESTION | 28/09/2021 | ||||
| 15090000124995 | L15/questions_ecrites | 15 | 15090000124988 | 15090000124988 | 4 | JO_QUESTION | 11/01/2022 | ||||
| 15090000124996 | L15/questions_ecrites | 15 | 15090000124988 | 15090000124988 | 5 | JO_QUESTION | 10/05/2022 | ||||
| 15090000125001 | L15/questions_ecrites | 15 | 15090000124997 | 15090000124997 | 1 | JO_QUESTION | 20/04/2021 | ||||
| 15090000125023 | L15/questions_ecrites | 15 | 15090000125019 | 15090000125019 | 1 | JO_QUESTION | 04/05/2021 | ||||
| 15090000125024 | L15/questions_ecrites | 15 | 15090000125019 | 15090000125019 | 2 | JO_QUESTION | 26/10/2021 | ||||
| 15090000125025 | L15/questions_ecrites | 15 | 15090000125019 | 15090000125019 | 3 | JO_QUESTION | 01/02/2022 | ||||
| 15090000125034 | L15/questions_ecrites | 15 | 15090000125030 | 15090000125030 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000125052 | L15/questions_ecrites | 15 | 15090000125048 | 15090000125048 | 1 | JO_QUESTION | 16/03/2021 | ||||
| 15090000125094 | L15/questions_ecrites | 15 | 15090000125090 | 15090000125090 | 1 | JO_QUESTION | 09/03/2021 | ||||
| 15090000125095 | L15/questions_ecrites | 15 | 15090000125090 | 15090000125090 | 2 | JO_QUESTION | 19/10/2021 | ||||
| 15090000125104 | L15/questions_ecrites | 15 | 15090000125100 | 15090000125100 | 1 | JO_QUESTION | 24/08/2021 | ||||
| 15090000125124 | L15/questions_ecrites | 15 | 15090000125120 | 15090000125120 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000125138 | L15/questions_ecrites | 15 | 15090000125134 | 15090000125134 | 1 | JO_QUESTION | 30/03/2021 | ||||
| 15090000125147 | L15/questions_ecrites | 15 | 15090000125143 | 15090000125143 | 1 | JO_QUESTION | 30/03/2021 | ||||
| 15090000125148 | L15/questions_ecrites | 15 | 15090000125143 | 15090000125143 | 2 | JO_QUESTION | 24/08/2021 | ||||
| 15090000125157 | L15/questions_ecrites | 15 | 15090000125153 | 15090000125153 | 1 | JO_QUESTION | 23/02/2021 | ||||
| 15090000125158 | L15/questions_ecrites | 15 | 15090000125153 | 15090000125153 | 2 | JO_QUESTION | 21/09/2021 | ||||
| 15090000125159 | L15/questions_ecrites | 15 | 15090000125153 | 15090000125153 | 3 | JO_QUESTION | 18/01/2022 | ||||
| 15090000125173 | L15/questions_ecrites | 15 | 15090000125169 | 15090000125169 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000125174 | L15/questions_ecrites | 15 | 15090000125169 | 15090000125169 | 2 | JO_QUESTION | 07/09/2021 | ||||
| 15090000125175 | L15/questions_ecrites | 15 | 15090000125169 | 15090000125169 | 3 | JO_QUESTION | 01/02/2022 | ||||
| 15090000125192 | L15/questions_ecrites | 15 | 15090000125188 | 15090000125188 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000125197 | L15/questions_ecrites | 15 | 15090000125193 | 15090000125193 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000125198 | L15/questions_ecrites | 15 | 15090000125193 | 15090000125193 | 2 | JO_QUESTION | 25/05/2021 | ||||
| 15090000125199 | L15/questions_ecrites | 15 | 15090000125193 | 15090000125193 | 3 | JO_QUESTION | 26/10/2021 | ||||
| 15090000125200 | L15/questions_ecrites | 15 | 15090000125193 | 15090000125193 | 4 | JO_QUESTION | 25/01/2022 | ||||
| 15090000125221 | L15/questions_ecrites | 15 | 15090000125217 | 15090000125217 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000125222 | L15/questions_ecrites | 15 | 15090000125217 | 15090000125217 | 2 | JO_QUESTION | 13/04/2021 | ||||
| 15090000125223 | L15/questions_ecrites | 15 | 15090000125217 | 15090000125217 | 3 | JO_QUESTION | 21/09/2021 | ||||
| 15090000125224 | L15/questions_ecrites | 15 | 15090000125217 | 15090000125217 | 4 | JO_QUESTION | 18/01/2022 | ||||
| 15090000125230 | L15/questions_ecrites | 15 | 15090000125225 | 15090000125225 | 1 | JO_QUESTION | 16/02/2021 | ||||
| 15090000125231 | L15/questions_ecrites | 15 | 15090000125225 | 15090000125225 | 2 | JO_QUESTION | 07/09/2021 | ||||
| 15090000125232 | L15/questions_ecrites | 15 | 15090000125225 | 15090000125225 | 3 | JO_QUESTION | 01/02/2022 | ||||
| 15090000125310 | L15/questions_ecrites | 15 | 15090000125306 | 15090000125306 | 1 | JO_QUESTION | 30/03/2021 | ||||
| 15090000125319 | L15/questions_ecrites | 15 | 15090000125315 | 15090000125315 | 1 | JO_QUESTION | 26/01/2021 | ||||
| 15090000125328 | L15/questions_ecrites | 15 | 15090000125324 | 15090000125324 | 1 | JO_QUESTION | 12/01/2021 | ||||
| 15090000125329 | L15/questions_ecrites | 15 | 15090000125324 | 15090000125324 | 2 | JO_QUESTION | 01/06/2021 | ||||
| 15090000125330 | L15/questions_ecrites | 15 | 15090000125324 | 15090000125324 | 3 | JO_QUESTION | 21/09/2021 | ||||
| 15090000125331 | L15/questions_ecrites | 15 | 15090000125324 | 15090000125324 | 4 | JO_QUESTION | 18/01/2022 | ||||
| 15090000125344 | L15/questions_ecrites | 15 | 15090000125340 | 15090000125340 | 1 | JO_QUESTION | 20/03/2018 | ||||
| 15090000125350 | L15/questions_ecrites | 15 | 15090000125345 | 15090000125345 | 1 | JO_QUESTION | 02/02/2021 | ||||
| 15090000125351 | L15/questions_ecrites | 15 | 15090000125345 | 15090000125345 | 2 | JO_QUESTION | 08/06/2021 | ||||
| 15090000125368 | L15/questions_ecrites | 15 | 15090000125364 | 15090000125364 | 1 | JO_QUESTION | 19/01/2021 | ||||
| 15090000125373 | L15/questions_ecrites | 15 | 15090000125369 | 15090000125369 | 1 | JO_QUESTION | 30/03/2021 | ||||
| 15090000125395 | L15/questions_ecrites | 15 | 15090000125391 | 15090000125391 | 1 | JO_QUESTION | 22/05/2018 | ||||
| 15090000125435 | L15/questions_ecrites | 15 | 15090000125431 | 15090000125431 | 1 | JO_QUESTION | 19/01/2021 | ||||
| 15090000125455 | L15/questions_ecrites | 15 | 15090000125451 | 15090000125451 | 1 | JO_QUESTION | 15/03/2022 | ||||
| 15090000125472 | L15/questions_ecrites | 15 | 15090000125468 | 15090000125468 | 1 | JO_QUESTION | 26/10/2021 |