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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 14090000183740 | L14/questions_ecrites | 14 | 14090000183736 | 14090000183736 | 1 | JO_QUESTION | 2015-10-06 | ||||
| 14090000183759 | L14/questions_ecrites | 14 | 14090000183753 | 14090000183753 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183760 | L14/questions_ecrites | 14 | 14090000183753 | 14090000183753 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183761 | L14/questions_ecrites | 14 | 14090000183753 | 14090000183753 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183762 | L14/questions_ecrites | 14 | 14090000183753 | 14090000183753 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000183763 | L14/questions_ecrites | 14 | 14090000183753 | 14090000183753 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000183775 | L14/questions_ecrites | 14 | 14090000183770 | 14090000183770 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183776 | L14/questions_ecrites | 14 | 14090000183770 | 14090000183770 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183777 | L14/questions_ecrites | 14 | 14090000183770 | 14090000183770 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183788 | L14/questions_ecrites | 14 | 14090000183783 | 14090000183783 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183793 | L14/questions_ecrites | 14 | 14090000183789 | 14090000183789 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183794 | L14/questions_ecrites | 14 | 14090000183789 | 14090000183789 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183795 | L14/questions_ecrites | 14 | 14090000183789 | 14090000183789 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183796 | L14/questions_ecrites | 14 | 14090000183789 | 14090000183789 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000183801 | L14/questions_ecrites | 14 | 14090000183797 | 14090000183797 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183802 | L14/questions_ecrites | 14 | 14090000183797 | 14090000183797 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183803 | L14/questions_ecrites | 14 | 14090000183797 | 14090000183797 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183817 | L14/questions_ecrites | 14 | 14090000183813 | 14090000183813 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183828 | L14/questions_ecrites | 14 | 14090000183822 | 14090000183822 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183829 | L14/questions_ecrites | 14 | 14090000183822 | 14090000183822 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183830 | L14/questions_ecrites | 14 | 14090000183822 | 14090000183822 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183831 | L14/questions_ecrites | 14 | 14090000183822 | 14090000183822 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000183854 | L14/questions_ecrites | 14 | 14090000183848 | 14090000183848 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183855 | L14/questions_ecrites | 14 | 14090000183848 | 14090000183848 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183856 | L14/questions_ecrites | 14 | 14090000183848 | 14090000183848 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183857 | L14/questions_ecrites | 14 | 14090000183848 | 14090000183848 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000183858 | L14/questions_ecrites | 14 | 14090000183848 | 14090000183848 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000183859 | L14/questions_ecrites | 14 | 14090000183848 | 14090000183848 | 6 | JO_QUESTION | 2017-05-23 | ||||
| 14090000183865 | L14/questions_ecrites | 14 | 14090000183860 | 14090000183860 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183866 | L14/questions_ecrites | 14 | 14090000183860 | 14090000183860 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183876 | L14/questions_ecrites | 14 | 14090000183871 | 14090000183871 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183877 | L14/questions_ecrites | 14 | 14090000183871 | 14090000183871 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183884 | L14/questions_ecrites | 14 | 14090000183878 | 14090000183878 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183885 | L14/questions_ecrites | 14 | 14090000183878 | 14090000183878 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183886 | L14/questions_ecrites | 14 | 14090000183878 | 14090000183878 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183887 | L14/questions_ecrites | 14 | 14090000183878 | 14090000183878 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000183888 | L14/questions_ecrites | 14 | 14090000183878 | 14090000183878 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000183893 | L14/questions_ecrites | 14 | 14090000183889 | 14090000183889 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183914 | L14/questions_ecrites | 14 | 14090000183910 | 14090000183910 | 1 | JO_QUESTION | 2015-10-06 | ||||
| 14090000183919 | L14/questions_ecrites | 14 | 14090000183915 | 14090000183915 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183926 | L14/questions_ecrites | 14 | 14090000183920 | 14090000183920 | 1 | JO_QUESTION | 2015-11-10 | ||||
| 14090000183927 | L14/questions_ecrites | 14 | 14090000183920 | 14090000183920 | 2 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183928 | L14/questions_ecrites | 14 | 14090000183920 | 14090000183920 | 3 | JO_QUESTION | 2016-06-14 | ||||
| 14090000183929 | L14/questions_ecrites | 14 | 14090000183920 | 14090000183920 | 4 | JO_QUESTION | 2016-09-20 | ||||
| 14090000183930 | L14/questions_ecrites | 14 | 14090000183920 | 14090000183920 | 5 | JO_QUESTION | 2017-01-24 | ||||
| 14090000183931 | L14/questions_ecrites | 14 | 14090000183920 | 14090000183920 | 6 | JO_QUESTION | 2017-05-23 | ||||
| 14090000183938 | L14/questions_ecrites | 14 | 14090000183932 | 14090000183932 | 1 | JO_QUESTION | 2016-02-23 | ||||
| 14090000183939 | L14/questions_ecrites | 14 | 14090000183932 | 14090000183932 | 2 | JO_QUESTION | 2016-06-21 | ||||
| 14090000183940 | L14/questions_ecrites | 14 | 14090000183932 | 14090000183932 | 3 | JO_QUESTION | 2016-09-27 | ||||
| 14090000183941 | L14/questions_ecrites | 14 | 14090000183932 | 14090000183932 | 4 | JO_QUESTION | 2017-01-10 |