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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 14090000174225 | L14/questions_ecrites | 14 | 14090000174218 | 14090000174218 | 3 | JO_QUESTION | 2016-09-13 | ||||
| 14090000174233 | L14/questions_ecrites | 14 | 14090000174226 | 14090000174226 | 1 | JO_QUESTION | 2017-02-14 | ||||
| 14090000174288 | L14/questions_ecrites | 14 | 14090000174283 | 14090000174283 | 1 | JO_QUESTION | 2016-03-08 | ||||
| 14090000174289 | L14/questions_ecrites | 14 | 14090000174283 | 14090000174283 | 2 | JO_QUESTION | 2016-06-21 | ||||
| 14090000174290 | L14/questions_ecrites | 14 | 14090000174283 | 14090000174283 | 3 | JO_QUESTION | 2016-10-04 | ||||
| 14090000174291 | L14/questions_ecrites | 14 | 14090000174283 | 14090000174283 | 4 | JO_QUESTION | 2017-01-24 | ||||
| 14090000174326 | L14/questions_ecrites | 14 | 14090000174321 | 14090000174321 | 1 | JO_QUESTION | 2016-07-19 | ||||
| 14090000174339 | L14/questions_ecrites | 14 | 14090000174335 | 14090000174335 | 1 | JO_QUESTION | 2016-03-15 | ||||
| 14090000174345 | L14/questions_ecrites | 14 | 14090000174340 | 14090000174340 | 1 | JO_QUESTION | 2016-03-08 | ||||
| 14090000174346 | L14/questions_ecrites | 14 | 14090000174340 | 14090000174340 | 2 | JO_QUESTION | 2016-07-19 | ||||
| 14090000174365 | L14/questions_ecrites | 14 | 14090000174356 | 14090000174356 | 1 | JO_QUESTION | 2016-03-15 | ||||
| 14090000174379 | L14/questions_ecrites | 14 | 14090000174374 | 14090000174374 | 1 | JO_QUESTION | 2016-03-08 | ||||
| 14090000174396 | L14/questions_ecrites | 14 | 14090000174389 | 14090000174389 | 1 | JO_QUESTION | 2016-03-29 | ||||
| 14090000174412 | L14/questions_ecrites | 14 | 14090000174406 | 14090000174406 | 1 | JO_QUESTION | 2016-12-06 | ||||
| 14090000174413 | L14/questions_ecrites | 14 | 14090000174406 | 14090000174406 | 2 | JO_QUESTION | 2017-03-21 | ||||
| 14090000174433 | L14/questions_ecrites | 14 | 14090000174427 | 14090000174427 | 1 | JO_QUESTION | 2016-04-26 | ||||
| 14090000174448 | L14/questions_ecrites | 14 | 14090000174443 | 14090000174443 | 1 | JO_QUESTION | 2016-03-22 | ||||
| 14090000174449 | L14/questions_ecrites | 14 | 14090000174443 | 14090000174443 | 2 | JO_QUESTION | 2016-09-06 | ||||
| 14090000174455 | L14/questions_ecrites | 14 | 14090000174450 | 14090000174450 | 1 | JO_QUESTION | 2016-03-08 | ||||
| 14090000174456 | L14/questions_ecrites | 14 | 14090000174450 | 14090000174450 | 2 | JO_QUESTION | 2016-06-14 | ||||
| 14090000174457 | L14/questions_ecrites | 14 | 14090000174450 | 14090000174450 | 3 | JO_QUESTION | 2017-01-03 | ||||
| 14090000174494 | L14/questions_ecrites | 14 | 14090000174488 | 14090000174488 | 1 | JO_QUESTION | 2016-06-07 | ||||
| 14090000174499 | L14/questions_ecrites | 14 | 14090000174495 | 14090000174495 | 1 | JO_QUESTION | 2016-03-08 | ||||
| 14090000174500 | L14/questions_ecrites | 14 | 14090000174495 | 14090000174495 | 2 | JO_QUESTION | 2016-06-21 | ||||
| 14090000174560 | L14/questions_ecrites | 14 | 14090000174554 | 14090000174554 | 1 | JO_QUESTION | 2016-03-08 | ||||
| 14090000174561 | L14/questions_ecrites | 14 | 14090000174554 | 14090000174554 | 2 | JO_QUESTION | 2016-07-12 | ||||
| 14090000174562 | L14/questions_ecrites | 14 | 14090000174554 | 14090000174554 | 3 | JO_QUESTION | 2016-10-18 | ||||
| 14090000174574 | L14/questions_ecrites | 14 | 14090000174567 | 14090000174567 | 1 | JO_QUESTION | 2016-12-06 | ||||
| 14090000174599 | L14/questions_ecrites | 14 | 14090000174595 | 14090000174595 | 1 | JO_QUESTION | 2016-05-24 | ||||
| 14090000174618 | L14/questions_ecrites | 14 | 14090000174614 | 14090000174614 | 1 | JO_QUESTION | 2016-04-26 | ||||
| 14090000174628 | L14/questions_ecrites | 14 | 14090000174623 | 14090000174623 | 1 | JO_QUESTION | 2016-03-22 | ||||
| 14090000174662 | L14/questions_ecrites | 14 | 14090000174656 | 14090000174656 | 1 | JO_QUESTION | 2016-03-01 | ||||
| 14090000174663 | L14/questions_ecrites | 14 | 14090000174656 | 14090000174656 | 2 | JO_QUESTION | 2016-06-07 | ||||
| 14090000174664 | L14/questions_ecrites | 14 | 14090000174656 | 14090000174656 | 3 | JO_QUESTION | 2016-09-13 | ||||
| 14090000174665 | L14/questions_ecrites | 14 | 14090000174656 | 14090000174656 | 4 | JO_QUESTION | 2016-12-20 | ||||
| 14090000174666 | L14/questions_ecrites | 14 | 14090000174656 | 14090000174656 | 5 | JO_QUESTION | 2017-03-28 | ||||
| 14090000174680 | L14/questions_ecrites | 14 | 14090000174676 | 14090000174676 | 1 | JO_QUESTION | 2016-03-15 | ||||
| 14090000174686 | L14/questions_ecrites | 14 | 14090000174681 | 14090000174681 | 1 | JO_QUESTION | 2016-03-15 | ||||
| 14090000174687 | L14/questions_ecrites | 14 | 14090000174681 | 14090000174681 | 2 | JO_QUESTION | 2016-06-28 | ||||
| 14090000174688 | L14/questions_ecrites | 14 | 14090000174681 | 14090000174681 | 3 | JO_QUESTION | 2016-11-01 | ||||
| 14090000174761 | L14/questions_ecrites | 14 | 14090000174755 | 14090000174755 | 1 | JO_QUESTION | 2014-11-18 | ||||
| 14090000174762 | L14/questions_ecrites | 14 | 14090000174755 | 14090000174755 | 2 | JO_QUESTION | 2015-03-10 | ||||
| 14090000174763 | L14/questions_ecrites | 14 | 14090000174755 | 14090000174755 | 3 | JO_QUESTION | 2015-06-23 | ||||
| 14090000174769 | L14/questions_ecrites | 14 | 14090000174764 | 14090000174764 | 1 | JO_QUESTION | 2016-03-29 | ||||
| 14090000174770 | L14/questions_ecrites | 14 | 14090000174764 | 14090000174764 | 2 | JO_QUESTION | 2016-07-12 | ||||
| 14090000174780 | L14/questions_ecrites | 14 | 14090000174775 | 14090000174775 | 1 | JO_QUESTION | 2016-03-15 | ||||
| 14090000174781 | L14/questions_ecrites | 14 | 14090000174775 | 14090000174775 | 2 | JO_QUESTION | 2016-07-05 | ||||
| 14090000174805 | L14/questions_ecrites | 14 | 14090000174802 | 14090000174802 | 1 | JO_QUESTION | 2016-06-28 | ||||
| 14090000174828 | L14/questions_ecrites | 14 | 14090000174822 | 14090000174822 | 1 | JO_QUESTION | 2016-03-01 | ||||
| 14090000174829 | L14/questions_ecrites | 14 | 14090000174822 | 14090000174822 | 2 | JO_QUESTION | 2016-06-07 |