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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 14090000219638 | L14/questions_ecrites | 14 | 14090000219631 | 14090000219631 | 3 | JO_QUESTION | 2017-02-14 | ||||
| 14090000219777 | L14/questions_ecrites | 14 | 14090000219772 | 14090000219772 | 1 | JO_QUESTION | 2016-10-04 | ||||
| 14090000219783 | L14/questions_ecrites | 14 | 14090000219778 | 14090000219778 | 1 | JO_QUESTION | 2016-08-16 | ||||
| 14090000219784 | L14/questions_ecrites | 14 | 14090000219778 | 14090000219778 | 2 | JO_QUESTION | 2016-12-20 | ||||
| 14090000219789 | L14/questions_ecrites | 14 | 14090000219785 | 14090000219785 | 1 | JO_QUESTION | 2016-08-30 | ||||
| 14090000219840 | L14/questions_ecrites | 14 | 14090000219835 | 14090000219835 | 1 | JO_QUESTION | 2017-04-11 | ||||
| 14090000219897 | L14/questions_ecrites | 14 | 14090000219892 | 14090000219892 | 1 | JO_QUESTION | 2016-07-26 | ||||
| 14090000219898 | L14/questions_ecrites | 14 | 14090000219892 | 14090000219892 | 2 | JO_QUESTION | 2016-11-01 | ||||
| 14090000219899 | L14/questions_ecrites | 14 | 14090000219892 | 14090000219892 | 3 | JO_QUESTION | 2017-02-14 | ||||
| 14090000219919 | L14/questions_ecrites | 14 | 14090000219912 | 14090000219912 | 1 | JO_QUESTION | 2016-08-23 | ||||
| 14090000219933 | L14/questions_ecrites | 14 | 14090000219928 | 14090000219928 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000219934 | L14/questions_ecrites | 14 | 14090000219928 | 14090000219928 | 2 | JO_QUESTION | 2016-12-06 | ||||
| 14090000219935 | L14/questions_ecrites | 14 | 14090000219928 | 14090000219928 | 3 | JO_QUESTION | 2017-04-04 | ||||
| 14090000219976 | L14/questions_ecrites | 14 | 14090000219969 | 14090000219969 | 1 | JO_QUESTION | 2016-10-18 | ||||
| 14090000219977 | L14/questions_ecrites | 14 | 14090000219969 | 14090000219969 | 2 | JO_QUESTION | 2017-02-28 | ||||
| 14090000219995 | L14/questions_ecrites | 14 | 14090000219991 | 14090000219991 | 1 | JO_QUESTION | 2016-08-30 | ||||
| 14090000220016 | L14/questions_ecrites | 14 | 14090000220010 | 14090000220010 | 1 | JO_QUESTION | 2016-08-16 | ||||
| 14090000220053 | L14/questions_ecrites | 14 | 14090000220048 | 14090000220048 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000220054 | L14/questions_ecrites | 14 | 14090000220048 | 14090000220048 | 2 | JO_QUESTION | 2016-11-08 | ||||
| 14090000220055 | L14/questions_ecrites | 14 | 14090000220048 | 14090000220048 | 3 | JO_QUESTION | 2017-02-21 | ||||
| 14090000220083 | L14/questions_ecrites | 14 | 14090000220077 | 14090000220077 | 1 | JO_QUESTION | 2015-12-15 | ||||
| 14090000220089 | L14/questions_ecrites | 14 | 14090000220084 | 14090000220084 | 1 | JO_QUESTION | 2016-11-15 | ||||
| 14090000220090 | L14/questions_ecrites | 14 | 14090000220084 | 14090000220084 | 2 | JO_QUESTION | 2017-02-21 | ||||
| 14090000220091 | L14/questions_ecrites | 14 | 14090000220084 | 14090000220084 | 3 | JO_QUESTION | 2017-06-13 | ||||
| 14090000220097 | L14/questions_ecrites | 14 | 14090000220092 | 14090000220092 | 1 | JO_QUESTION | 2016-12-13 | ||||
| 14090000220118 | L14/questions_ecrites | 14 | 14090000220112 | 14090000220112 | 1 | JO_QUESTION | 2015-10-06 | ||||
| 14090000220119 | L14/questions_ecrites | 14 | 14090000220112 | 14090000220112 | 2 | JO_QUESTION | 2016-08-02 | ||||
| 14090000220120 | L14/questions_ecrites | 14 | 14090000220112 | 14090000220112 | 3 | JO_QUESTION | 2017-05-23 | ||||
| 14090000220163 | L14/questions_ecrites | 14 | 14090000220158 | 14090000220158 | 1 | JO_QUESTION | 2017-04-11 | ||||
| 14090000220182 | L14/questions_ecrites | 14 | 14090000220176 | 14090000220176 | 1 | JO_QUESTION | 2016-08-16 | ||||
| 14090000220183 | L14/questions_ecrites | 14 | 14090000220176 | 14090000220176 | 2 | JO_QUESTION | 2016-12-20 | ||||
| 14090000220250 | L14/questions_ecrites | 14 | 14090000220243 | 14090000220243 | 1 | JO_QUESTION | 2016-09-13 | ||||
| 14090000220257 | L14/questions_ecrites | 14 | 14090000220251 | 14090000220251 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000220327 | L14/questions_ecrites | 14 | 14090000220322 | 14090000220322 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000220328 | L14/questions_ecrites | 14 | 14090000220322 | 14090000220322 | 2 | JO_QUESTION | 2016-11-15 | ||||
| 14090000220419 | L14/questions_ecrites | 14 | 14090000220411 | 14090000220411 | 1 | JO_QUESTION | 2016-08-16 | ||||
| 14090000220420 | L14/questions_ecrites | 14 | 14090000220411 | 14090000220411 | 2 | JO_QUESTION | 2016-12-20 | ||||
| 14090000220490 | L14/questions_ecrites | 14 | 14090000220484 | 14090000220484 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000220491 | L14/questions_ecrites | 14 | 14090000220484 | 14090000220484 | 2 | JO_QUESTION | 2016-11-08 | ||||
| 14090000220492 | L14/questions_ecrites | 14 | 14090000220484 | 14090000220484 | 3 | JO_QUESTION | 2017-02-14 | ||||
| 14090000220493 | L14/questions_ecrites | 14 | 14090000220484 | 14090000220484 | 4 | JO_QUESTION | 2017-06-13 | ||||
| 14090000220499 | L14/questions_ecrites | 14 | 14090000220494 | 14090000220494 | 1 | JO_QUESTION | 2016-08-09 | ||||
| 14090000220500 | L14/questions_ecrites | 14 | 14090000220494 | 14090000220494 | 2 | JO_QUESTION | 2016-11-15 | ||||
| 14090000220511 | L14/questions_ecrites | 14 | 14090000220506 | 14090000220506 | 1 | JO_QUESTION | 2016-09-13 | ||||
| 14090000220512 | L14/questions_ecrites | 14 | 14090000220506 | 14090000220506 | 2 | JO_QUESTION | 2017-01-17 | ||||
| 14090000220518 | L14/questions_ecrites | 14 | 14090000220513 | 14090000220513 | 1 | JO_QUESTION | 2016-09-27 | ||||
| 14090000220529 | L14/questions_ecrites | 14 | 14090000220525 | 14090000220525 | 1 | JO_QUESTION | 2016-08-02 | ||||
| 14090000220553 | L14/questions_ecrites | 14 | 14090000220548 | 14090000220548 | 1 | JO_QUESTION | 2016-08-16 | ||||
| 14090000220554 | L14/questions_ecrites | 14 | 14090000220548 | 14090000220548 | 2 | JO_QUESTION | 2016-12-20 | ||||
| 14090000220559 | L14/questions_ecrites | 14 | 14090000220555 | 14090000220555 | 1 | JO_QUESTION | 2016-08-02 |