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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 14090000187373 | L14/questions_ecrites | 14 | 14090000187365 | 14090000187365 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000187374 | L14/questions_ecrites | 14 | 14090000187365 | 14090000187365 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000187375 | L14/questions_ecrites | 14 | 14090000187365 | 14090000187365 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000187376 | L14/questions_ecrites | 14 | 14090000187365 | 14090000187365 | 6 | JO_QUESTION | 2017-05-23 | ||||
| 14090000187386 | L14/questions_ecrites | 14 | 14090000187381 | 14090000187381 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187387 | L14/questions_ecrites | 14 | 14090000187381 | 14090000187381 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187393 | L14/questions_ecrites | 14 | 14090000187388 | 14090000187388 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187394 | L14/questions_ecrites | 14 | 14090000187388 | 14090000187388 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187399 | L14/questions_ecrites | 14 | 14090000187395 | 14090000187395 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187412 | L14/questions_ecrites | 14 | 14090000187408 | 14090000187408 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187423 | L14/questions_ecrites | 14 | 14090000187417 | 14090000187417 | 1 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187424 | L14/questions_ecrites | 14 | 14090000187417 | 14090000187417 | 2 | JO_QUESTION | 2016-06-21 | ||||
| 14090000187425 | L14/questions_ecrites | 14 | 14090000187417 | 14090000187417 | 3 | JO_QUESTION | 2016-09-27 | ||||
| 14090000187426 | L14/questions_ecrites | 14 | 14090000187417 | 14090000187417 | 4 | JO_QUESTION | 2017-01-10 | ||||
| 14090000187427 | L14/questions_ecrites | 14 | 14090000187417 | 14090000187417 | 5 | JO_QUESTION | 2017-05-02 | ||||
| 14090000187433 | L14/questions_ecrites | 14 | 14090000187428 | 14090000187428 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187434 | L14/questions_ecrites | 14 | 14090000187428 | 14090000187428 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187443 | L14/questions_ecrites | 14 | 14090000187435 | 14090000187435 | 1 | JO_QUESTION | 2014-01-14 | ||||
| 14090000187444 | L14/questions_ecrites | 14 | 14090000187435 | 14090000187435 | 2 | JO_QUESTION | 2014-09-09 | ||||
| 14090000187452 | L14/questions_ecrites | 14 | 14090000187445 | 14090000187445 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187453 | L14/questions_ecrites | 14 | 14090000187445 | 14090000187445 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187454 | L14/questions_ecrites | 14 | 14090000187445 | 14090000187445 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000187455 | L14/questions_ecrites | 14 | 14090000187445 | 14090000187445 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000187456 | L14/questions_ecrites | 14 | 14090000187445 | 14090000187445 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000187463 | L14/questions_ecrites | 14 | 14090000187457 | 14090000187457 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187464 | L14/questions_ecrites | 14 | 14090000187457 | 14090000187457 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187465 | L14/questions_ecrites | 14 | 14090000187457 | 14090000187457 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000187466 | L14/questions_ecrites | 14 | 14090000187457 | 14090000187457 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000187467 | L14/questions_ecrites | 14 | 14090000187457 | 14090000187457 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000187473 | L14/questions_ecrites | 14 | 14090000187468 | 14090000187468 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187474 | L14/questions_ecrites | 14 | 14090000187468 | 14090000187468 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187475 | L14/questions_ecrites | 14 | 14090000187468 | 14090000187468 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000187480 | L14/questions_ecrites | 14 | 14090000187476 | 14090000187476 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187485 | L14/questions_ecrites | 14 | 14090000187481 | 14090000187481 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187486 | L14/questions_ecrites | 14 | 14090000187481 | 14090000187481 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187487 | L14/questions_ecrites | 14 | 14090000187481 | 14090000187481 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000187488 | L14/questions_ecrites | 14 | 14090000187481 | 14090000187481 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000187497 | L14/questions_ecrites | 14 | 14090000187489 | 14090000187489 | 1 | JO_QUESTION | 2016-07-05 | ||||
| 14090000187506 | L14/questions_ecrites | 14 | 14090000187502 | 14090000187502 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187525 | L14/questions_ecrites | 14 | 14090000187519 | 14090000187519 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187526 | L14/questions_ecrites | 14 | 14090000187519 | 14090000187519 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187527 | L14/questions_ecrites | 14 | 14090000187519 | 14090000187519 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000187528 | L14/questions_ecrites | 14 | 14090000187519 | 14090000187519 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000187529 | L14/questions_ecrites | 14 | 14090000187519 | 14090000187519 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000187530 | L14/questions_ecrites | 14 | 14090000187519 | 14090000187519 | 6 | JO_QUESTION | 2017-05-23 | ||||
| 14090000187540 | L14/questions_ecrites | 14 | 14090000187535 | 14090000187535 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187541 | L14/questions_ecrites | 14 | 14090000187535 | 14090000187535 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000187546 | L14/questions_ecrites | 14 | 14090000187542 | 14090000187542 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187560 | L14/questions_ecrites | 14 | 14090000187555 | 14090000187555 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000187561 | L14/questions_ecrites | 14 | 14090000187555 | 14090000187555 | 2 | JO_QUESTION | 2016-02-23 |