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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 14090000115363 | L14/questions_ecrites | 14 | 14090000115354 | 14090000115354 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000115369 | L14/questions_ecrites | 14 | 14090000115364 | 14090000115364 | 1 | JO_QUESTION | 2017-05-23 | ||||
| 14090000115411 | L14/questions_ecrites | 14 | 14090000115407 | 14090000115407 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115461 | L14/questions_ecrites | 14 | 14090000115457 | 14090000115457 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115462 | L14/questions_ecrites | 14 | 14090000115457 | 14090000115457 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000115481 | L14/questions_ecrites | 14 | 14090000115476 | 14090000115476 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115482 | L14/questions_ecrites | 14 | 14090000115476 | 14090000115476 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000115483 | L14/questions_ecrites | 14 | 14090000115476 | 14090000115476 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000115484 | L14/questions_ecrites | 14 | 14090000115476 | 14090000115476 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000115485 | L14/questions_ecrites | 14 | 14090000115476 | 14090000115476 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000115486 | L14/questions_ecrites | 14 | 14090000115476 | 14090000115476 | 6 | JO_QUESTION | 2017-05-23 | ||||
| 14090000115496 | L14/questions_ecrites | 14 | 14090000115491 | 14090000115491 | 1 | JO_QUESTION | 2016-04-26 | ||||
| 14090000115514 | L14/questions_ecrites | 14 | 14090000115509 | 14090000115509 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000115525 | L14/questions_ecrites | 14 | 14090000115521 | 14090000115521 | 1 | JO_QUESTION | 2015-11-24 | ||||
| 14090000115535 | L14/questions_ecrites | 14 | 14090000115530 | 14090000115530 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115592 | L14/questions_ecrites | 14 | 14090000115586 | 14090000115586 | 1 | JO_QUESTION | 2014-09-23 | ||||
| 14090000115603 | L14/questions_ecrites | 14 | 14090000115597 | 14090000115597 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000115604 | L14/questions_ecrites | 14 | 14090000115597 | 14090000115597 | 2 | JO_QUESTION | 2017-05-23 | ||||
| 14090000115634 | L14/questions_ecrites | 14 | 14090000115629 | 14090000115629 | 1 | JO_QUESTION | 2013-06-25 | ||||
| 14090000115671 | L14/questions_ecrites | 14 | 14090000115664 | 14090000115664 | 1 | JO_QUESTION | 2016-02-23 | ||||
| 14090000115672 | L14/questions_ecrites | 14 | 14090000115664 | 14090000115664 | 2 | JO_QUESTION | 2016-06-21 | ||||
| 14090000115673 | L14/questions_ecrites | 14 | 14090000115664 | 14090000115664 | 3 | JO_QUESTION | 2016-09-27 | ||||
| 14090000115674 | L14/questions_ecrites | 14 | 14090000115664 | 14090000115664 | 4 | JO_QUESTION | 2017-01-10 | ||||
| 14090000115675 | L14/questions_ecrites | 14 | 14090000115664 | 14090000115664 | 5 | JO_QUESTION | 2017-05-02 | ||||
| 14090000115692 | L14/questions_ecrites | 14 | 14090000115686 | 14090000115686 | 1 | JO_QUESTION | 2016-07-26 | ||||
| 14090000115701 | L14/questions_ecrites | 14 | 14090000115693 | 14090000115693 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000115719 | L14/questions_ecrites | 14 | 14090000115715 | 14090000115715 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115767 | L14/questions_ecrites | 14 | 14090000115763 | 14090000115763 | 1 | JO_QUESTION | 2016-06-14 | ||||
| 14090000115768 | L14/questions_ecrites | 14 | 14090000115763 | 14090000115763 | 2 | JO_QUESTION | 2016-09-20 | ||||
| 14090000115776 | L14/questions_ecrites | 14 | 14090000115769 | 14090000115769 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000115777 | L14/questions_ecrites | 14 | 14090000115769 | 14090000115769 | 2 | JO_QUESTION | 2017-05-23 | ||||
| 14090000115786 | L14/questions_ecrites | 14 | 14090000115778 | 14090000115778 | 1 | JO_QUESTION | 2015-12-08 | ||||
| 14090000115795 | L14/questions_ecrites | 14 | 14090000115787 | 14090000115787 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115796 | L14/questions_ecrites | 14 | 14090000115787 | 14090000115787 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000115797 | L14/questions_ecrites | 14 | 14090000115787 | 14090000115787 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000115805 | L14/questions_ecrites | 14 | 14090000115798 | 14090000115798 | 1 | JO_QUESTION | 2016-02-23 | ||||
| 14090000115806 | L14/questions_ecrites | 14 | 14090000115798 | 14090000115798 | 2 | JO_QUESTION | 2016-06-21 | ||||
| 14090000115807 | L14/questions_ecrites | 14 | 14090000115798 | 14090000115798 | 3 | JO_QUESTION | 2016-09-27 | ||||
| 14090000115808 | L14/questions_ecrites | 14 | 14090000115798 | 14090000115798 | 4 | JO_QUESTION | 2017-01-10 | ||||
| 14090000115809 | L14/questions_ecrites | 14 | 14090000115798 | 14090000115798 | 5 | JO_QUESTION | 2017-05-02 | ||||
| 14090000115821 | L14/questions_ecrites | 14 | 14090000115815 | 14090000115815 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000115822 | L14/questions_ecrites | 14 | 14090000115815 | 14090000115815 | 2 | JO_QUESTION | 2017-05-23 | ||||
| 14090000115832 | L14/questions_ecrites | 14 | 14090000115827 | 14090000115827 | 1 | JO_QUESTION | 2015-12-15 | ||||
| 14090000115833 | L14/questions_ecrites | 14 | 14090000115827 | 14090000115827 | 2 | JO_QUESTION | 2016-05-03 | ||||
| 14090000115834 | L14/questions_ecrites | 14 | 14090000115827 | 14090000115827 | 3 | JO_QUESTION | 2016-08-09 | ||||
| 14090000115851 | L14/questions_ecrites | 14 | 14090000115846 | 14090000115846 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000115903 | L14/questions_ecrites | 14 | 14090000115895 | 14090000115895 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115904 | L14/questions_ecrites | 14 | 14090000115895 | 14090000115895 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000115933 | L14/questions_ecrites | 14 | 14090000115925 | 14090000115925 | 1 | JO_QUESTION | 2015-11-17 | ||||
| 14090000115934 | L14/questions_ecrites | 14 | 14090000115925 | 14090000115925 | 2 | JO_QUESTION | 2016-02-23 |