questions_ecrites.question_renouvellement
Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
85 356 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 14090000458103 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 2 | JO_QUESTION | 2013-07-23 | ||||
| 14090000458104 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 3 | JO_QUESTION | 2013-11-05 | ||||
| 14090000458105 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 4 | JO_QUESTION | 2014-02-25 | ||||
| 14090000458106 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 5 | JO_QUESTION | 2014-06-10 | ||||
| 14090000458107 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 6 | JO_QUESTION | 2014-09-16 | ||||
| 14090000458108 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 7 | JO_QUESTION | 2015-02-10 | ||||
| 14090000458109 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 8 | JO_QUESTION | 2015-05-26 | ||||
| 14090000458110 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 9 | JO_QUESTION | 2015-10-13 | ||||
| 14090000458111 | L14/questions_ecrites | 14 | 14090000458094 | 14090000458094 | 10 | JO_QUESTION | 2016-02-23 | ||||
| 14090000458121 | L14/questions_ecrites | 14 | 14090000458116 | 14090000458116 | 1 | JO_QUESTION | 2014-05-20 | ||||
| 14090000458133 | L14/questions_ecrites | 14 | 14090000458126 | 14090000458126 | 1 | JO_QUESTION | 2014-06-17 | ||||
| 14090000458134 | L14/questions_ecrites | 14 | 14090000458126 | 14090000458126 | 2 | JO_QUESTION | 2014-06-17 | ||||
| 14090000458145 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 1 | JO_QUESTION | 2014-07-01 | ||||
| 14090000458146 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 2 | JO_QUESTION | 2014-10-07 | ||||
| 14090000458147 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 3 | JO_QUESTION | 2015-01-20 | ||||
| 14090000458148 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 4 | JO_QUESTION | 2015-05-12 | ||||
| 14090000458149 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 5 | JO_QUESTION | 2015-09-01 | ||||
| 14090000458150 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 6 | JO_QUESTION | 2015-12-08 | ||||
| 14090000458151 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 7 | JO_QUESTION | 2016-03-15 | ||||
| 14090000458152 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 8 | JO_QUESTION | 2016-06-21 | ||||
| 14090000458153 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 9 | JO_QUESTION | 2016-09-27 | ||||
| 14090000458154 | L14/questions_ecrites | 14 | 14090000458135 | 14090000458135 | 10 | JO_QUESTION | 2017-02-21 | ||||
| 14090000458208 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 1 | JO_QUESTION | 2014-10-14 | ||||
| 14090000458209 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 2 | JO_QUESTION | 2015-01-20 | ||||
| 14090000458210 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 3 | JO_QUESTION | 2015-06-23 | ||||
| 14090000458211 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 4 | JO_QUESTION | 2015-09-29 | ||||
| 14090000458212 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 5 | JO_QUESTION | 2016-01-05 | ||||
| 14090000458213 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 6 | JO_QUESTION | 2016-04-12 | ||||
| 14090000458214 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 7 | JO_QUESTION | 2016-07-12 | ||||
| 14090000458215 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 8 | JO_QUESTION | 2016-11-22 | ||||
| 14090000458216 | L14/questions_ecrites | 14 | 14090000458201 | 14090000458201 | 9 | JO_QUESTION | 2017-02-28 | ||||
| 14090000458222 | L14/questions_ecrites | 14 | 14090000458217 | 14090000458217 | 1 | JO_QUESTION | 2014-09-23 | ||||
| 14090000458283 | L14/questions_ecrites | 14 | 14090000458279 | 14090000458279 | 1 | JO_QUESTION | 2014-01-28 | ||||
| 14090000458296 | L14/questions_ecrites | 14 | 14090000458292 | 14090000458292 | 1 | JO_QUESTION | 2012-11-20 | ||||
| 14090000458356 | L14/questions_ecrites | 14 | 14090000458349 | 14090000458349 | 1 | JO_QUESTION | 2015-03-10 | ||||
| 14090000458357 | L14/questions_ecrites | 14 | 14090000458349 | 14090000458349 | 2 | JO_QUESTION | 2015-06-16 | ||||
| 14090000458358 | L14/questions_ecrites | 14 | 14090000458349 | 14090000458349 | 3 | JO_QUESTION | 2016-04-26 | ||||
| 14090000458377 | L14/questions_ecrites | 14 | 14090000458373 | 14090000458373 | 1 | JO_QUESTION | 2013-03-05 | ||||
| 14090000458378 | L14/questions_ecrites | 14 | 14090000458373 | 14090000458373 | 2 | JO_QUESTION | 2013-06-18 | ||||
| 14090000458405 | L14/questions_ecrites | 14 | 14090000458400 | 14090000458400 | 1 | JO_QUESTION | 2012-12-18 | ||||
| 14090000458414 | L14/questions_ecrites | 14 | 14090000458410 | 14090000458410 | 1 | JO_QUESTION | 2012-12-11 | ||||
| 14090000458415 | L14/questions_ecrites | 14 | 14090000458410 | 14090000458410 | 2 | JO_QUESTION | 2013-03-26 | ||||
| 14090000458416 | L14/questions_ecrites | 14 | 14090000458410 | 14090000458410 | 3 | JO_QUESTION | 2013-07-02 | ||||
| 14090000458423 | L14/questions_ecrites | 14 | 14090000458417 | 14090000458417 | 1 | JO_QUESTION | 2015-07-21 | ||||
| 14090000458424 | L14/questions_ecrites | 14 | 14090000458417 | 14090000458417 | 2 | JO_QUESTION | 2015-11-10 | ||||
| 14090000458442 | L14/questions_ecrites | 14 | 14090000458433 | 14090000458433 | 1 | JO_QUESTION | 2015-09-29 | ||||
| 14090000458447 | L14/questions_ecrites | 14 | 14090000458443 | 14090000458443 | 1 | JO_QUESTION | 2013-01-29 | ||||
| 14090000458448 | L14/questions_ecrites | 14 | 14090000458443 | 14090000458443 | 2 | JO_QUESTION | 2013-06-25 | ||||
| 14090000458455 | L14/questions_ecrites | 14 | 14090000458449 | 14090000458449 | 1 | JO_QUESTION | 2014-01-28 | ||||
| 14090000458456 | L14/questions_ecrites | 14 | 14090000458449 | 14090000458449 | 2 | JO_QUESTION | 2014-06-17 |