dossiers.dossier_parlementaire_acte_legislatif_texte_associe
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %
5 606 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 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | type_texte | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.typeTexte · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 % |
| 10 | ref_texte_associe | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.refTexteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | type_texte | ref_texte_associe |
|---|---|---|---|---|---|---|---|---|---|
| 14060000104455 | L14/dossiers | 14 | 14060000104442 | 14060000104454 | 1 | 2 | BTA | PIONSNR5S219BTA0123 | |
| 14060000104505 | L14/dossiers | 14 | 14060000104488 | 14060000104504 | 1 | 2 | BTA | PRJLSNR5S259BTA0035 | |
| 14060000104529 | L14/dossiers | 14 | 14060000104488 | 14060000104528 | 1 | 2 | BTA | PRJLANR5L14BTA0738 | |
| 14060000104560 | L14/dossiers | 14 | 14060000104488 | 14060000104559 | 1 | 2 | BTA | PRJLANR5L14BTA0792 | |
| 14060000104571 | L14/dossiers | 14 | 14060000104488 | 14060000104570 | 1 | 2 | BTA | PRJLSNR5S259BTA0186 | |
| 14060000104581 | L14/dossiers | 14 | 14060000104488 | 14060000104580 | 1 | 2 | BTA | PRJLANR5L14BTA0824 | |
| 14060000104785 | L14/dossiers | 14 | 14060000104764 | 14060000104784 | 1 | 2 | BTA | PRJLANR5L14BTA0561 | |
| 14060000104797 | L14/dossiers | 14 | 14060000104764 | 14060000104796 | 1 | 2 | BTA | PRJLSNR5S239BTA0129 | |
| 14060000104818 | L14/dossiers | 14 | 14060000104764 | 14060000104817 | 1 | 2 | BTA | PRJLANR5L14BTA0569 | |
| 14060000104828 | L14/dossiers | 14 | 14060000104764 | 14060000104827 | 1 | 2 | BTA | PRJLSNR5S239BTA0139 | |
| 14060000104839 | L14/dossiers | 14 | 14060000104764 | 14060000104838 | 1 | 2 | BTA | PRJLANR5L14BTA0576 | |
| 14060000104880 | L14/dossiers | 14 | 14060000104863 | 14060000104879 | 1 | 2 | BTA | PIONANR5L14BTA0435 | |
| 14060000104895 | L14/dossiers | 14 | 14060000104881 | 14060000104894 | 1 | 2 | BTA | PRJLSNR5S279BTA0122 | |
| 14060000104909 | L14/dossiers | 14 | 14060000104881 | 14060000104908 | 1 | 2 | BTA | PRJLANR5L15BTA0034 | |
| 14060000104910 | L14/dossiers | 14 | 14060000104881 | 14060000104908 | 2 | 2 | TAP | PRJLANR5L15TAP0034 | |
| 14060000104924 | L14/dossiers | 14 | 14060000104881 | 14060000104923 | 1 | 2 | BTA | PRJLANR5L15BTA0048 | |
| 14060000104925 | L14/dossiers | 14 | 14060000104881 | 14060000104923 | 2 | 2 | TAP | PRJLANR5L15TAP0048 | |
| 14060000104929 | L14/dossiers | 14 | 14060000104881 | 14060000104928 | 1 | 2 | BTA | PRJLSNR5S299BTA0029 | |
| 14060000104957 | L14/dossiers | 14 | 14060000104943 | 14060000104956 | 1 | 2 | BTA | PRJLSNR5S239BTA0121 | |
| 14060000104972 | L14/dossiers | 14 | 14060000104943 | 14060000104971 | 1 | 2 | BTA | PRJLANR5L14BTA0567 | |
| 14060000105000 | L14/dossiers | 14 | 14060000104985 | 14060000104999 | 1 | 2 | BTA | PRJLSNR5S219BTA0064 | |
| 14060000105014 | L14/dossiers | 14 | 14060000104985 | 14060000105013 | 1 | 2 | BTA | PRJLANR5L14BTA0290 | |
| 14060000105028 | L14/dossiers | 14 | 14060000104985 | 14060000105027 | 1 | 2 | BTA | PRJLANR5L14BTA0308 | |
| 14060000105032 | L14/dossiers | 14 | 14060000104985 | 14060000105031 | 1 | 2 | BTA | PRJLSNR5S219BTA0088 | |
| 14060000105054 | L14/dossiers | 14 | 14060000105039 | 14060000105053 | 1 | 2 | BTA | PIONANR5L14BTA0043 | |
| 14060000105069 | L14/dossiers | 14 | 14060000105055 | 14060000105068 | 1 | 2 | BTA | PIONSNR5S199BTA0122 | |
| 14060000105084 | L14/dossiers | 14 | 14060000105055 | 14060000105083 | 1 | 2 | BTA | PIONANR5L14BTA0354 | |
| 14060000105163 | L14/dossiers | 14 | 14060000105149 | 14060000105162 | 1 | 2 | BTA | PRJLSNR5S259BTA0090 | |
| 14060000105183 | L14/dossiers | 14 | 14060000105149 | 14060000105182 | 1 | 2 | BTA | PRJLANR5L14BTA0772 | |
| 14060000105263 | L14/dossiers | 14 | 14060000105217 | 14060000105262 | 1 | 2 | BTA | PRJLANR5L14BTA0728 | |
| 14060000105287 | L14/dossiers | 14 | 14060000105217 | 14060000105286 | 1 | 2 | BTA | PRJLSNR5S259BTA0161 | |
| 14060000105312 | L14/dossiers | 14 | 14060000105217 | 14060000105311 | 1 | 2 | BTA | PRJLANR5L14BTA0786 | |
| 14060000105322 | L14/dossiers | 14 | 14060000105217 | 14060000105321 | 1 | 2 | BTA | PRJLSNR5S259BTA0179 | |
| 14060000105333 | L14/dossiers | 14 | 14060000105217 | 14060000105332 | 1 | 2 | BTA | PRJLANR5L14BTA0807 | |
| 14060000105356 | L14/dossiers | 14 | 14060000105341 | 14060000105355 | 1 | 2 | BTA | PIONANR5L14BTA0445 | |
| 14060000105457 | L14/dossiers | 14 | 14060000105445 | 14060000105456 | 1 | 2 | BTA | RIONANR5L14BTA0131 | |
| 14060000105536 | L14/dossiers | 14 | 14060000105522 | 14060000105535 | 1 | 2 | BTA | RIONANR5L14BTA0272 | |
| 14060000105567 | L14/dossiers | 14 | 14060000105548 | 14060000105566 | 1 | 2 | BTA | RIONANR5L14BTA0285 | |
| 14060000105584 | L14/dossiers | 14 | 14060000105571 | 14060000105583 | 1 | 2 | BTA | RIONANR5L14BTA0307 | |
| 14060000105621 | L14/dossiers | 14 | 14060000105599 | 14060000105620 | 1 | 2 | BTA | PRJLANR5L14BTA0032 | |
| 14060000105633 | L14/dossiers | 14 | 14060000105599 | 14060000105632 | 1 | 2 | BTA | PRJLSNR5S199BTA0037 | |
| 14060000105671 | L14/dossiers | 14 | 14060000105661 | 14060000105670 | 1 | 2 | BTA | RIONANR5L14BTA0284 | |
| 14060000105816 | L14/dossiers | 14 | 14060000105801 | 14060000105815 | 1 | 2 | BTA | PIONANR5L14BTA0912 | |
| 14060000105828 | L14/dossiers | 14 | 14060000105801 | 14060000105827 | 1 | 2 | BTA | PIONSNR5S279BTA0094 | |
| 14060000105858 | L14/dossiers | 14 | 14060000105845 | 14060000105857 | 1 | 2 | BTA | PIONSNR5S219BTA0066 | |
| 14060000105874 | L14/dossiers | 14 | 14060000105845 | 14060000105873 | 1 | 2 | BTA | PIONANR5L14BTA0328 | |
| 14060000105884 | L14/dossiers | 14 | 14060000105845 | 14060000105883 | 1 | 2 | BTA | PIONSNR5S219BTA0119 | |
| 14060000105901 | L14/dossiers | 14 | 14060000105887 | 14060000105900 | 1 | 2 | BTA | RIONANR5L14BTA0165 | |
| 14060000105918 | L14/dossiers | 14 | 14060000105902 | 14060000105917 | 1 | 2 | BTA | PIONANR5L14BTA0841 | |
| 14060000105942 | L14/dossiers | 14 | 14060000105924 | 14060000105941 | 1 | 2 | BTA | PRJLANR5L14BTA0108 |