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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000112057 | L14/dossiers | 14 | 14060000112010 | 14060000112056 | 1 | 2 | BTA | PIONSNR5S239BTA0091 | |
| 14060000112102 | L14/dossiers | 14 | 14060000112087 | 14060000112101 | 1 | 2 | BTA | RIONANR5L14BTA0349 | |
| 14060000112123 | L14/dossiers | 14 | 14060000112110 | 14060000112122 | 1 | 2 | BTA | PIONSNR5S299BTA0055 | |
| 14060000112154 | L14/dossiers | 14 | 14060000112139 | 14060000112153 | 1 | 2 | BTA | PRJLSNR5S199BTA0024 | |
| 14060000112169 | L14/dossiers | 14 | 14060000112139 | 14060000112168 | 1 | 2 | BTA | PRJLANR5L14BTA0061 | |
| 14060000112183 | L14/dossiers | 14 | 14060000112139 | 14060000112182 | 1 | 2 | BTA | PRJLANR5L14BTA0069 | |
| 14060000112187 | L14/dossiers | 14 | 14060000112139 | 14060000112186 | 1 | 2 | BTA | PRJLSNR5S199BTA0066 | |
| 14060000112341 | L14/dossiers | 14 | 14060000112324 | 14060000112340 | 1 | 2 | BTA | PIONANR5L14BTA0044 | |
| 14060000112466 | L14/dossiers | 14 | 14060000112452 | 14060000112465 | 1 | 2 | BTA | PIONSNR5S199BTA0102 | |
| 14060000112520 | L14/dossiers | 14 | 14060000112504 | 14060000112519 | 1 | 2 | BTA | PIONANR5L14BTA0023 | |
| 14060000112619 | L14/dossiers | 14 | 14060000112604 | 14060000112618 | 1 | 2 | BTA | PIONANR5L14BTA0657 | |
| 14060000112680 | L14/dossiers | 14 | 14060000112667 | 14060000112679 | 1 | 2 | BTA | PRJLSNR5S259BTA0157 | |
| 14060000112693 | L14/dossiers | 14 | 14060000112667 | 14060000112692 | 1 | 2 | BTA | PRJLANR5L14BTA0796 | |
| 14060000112734 | L14/dossiers | 14 | 14060000112717 | 14060000112733 | 1 | 2 | BTA | PIONANR5L14BTA0133 | |
| 14060000112746 | L14/dossiers | 14 | 14060000112717 | 14060000112745 | 1 | 2 | BTA | PIONSNR5S199BTA0155 | |
| 14060000112757 | L14/dossiers | 14 | 14060000112717 | 14060000112756 | 1 | 2 | BTA | PIONANR5L14BTA0158 | |
| 14060000112807 | L14/dossiers | 14 | 14060000112795 | 14060000112806 | 1 | 2 | BTA | RIONANR5L14BTA0130 | |
| 14060000112829 | L14/dossiers | 14 | 14060000112815 | 14060000112828 | 1 | 2 | BTA | PIONSNR5S259BTA0165 | |
| 14060000112843 | L14/dossiers | 14 | 14060000112815 | 14060000112842 | 1 | 2 | BTA | PIONANR5L14BTA0793 | |
| 14060000112914 | L14/dossiers | 14 | 14060000112894 | 14060000112913 | 1 | 2 | BTA | RIONANR5L14BTA0906 | |
| 14060000112929 | L14/dossiers | 14 | 14060000112915 | 14060000112928 | 1 | 2 | BTA | PRJLSNR5S259BTA0060 | |
| 14060000112943 | L14/dossiers | 14 | 14060000112915 | 14060000112942 | 1 | 2 | BTA | PRJLANR5L14BTA0732 | |
| 14060000113012 | L14/dossiers | 14 | 14060000112994 | 14060000113011 | 1 | 2 | BTA | PRJLANR5L14BTA0594 | |
| 14060000113025 | L14/dossiers | 14 | 14060000112994 | 14060000113024 | 1 | 2 | BTA | PRJLSNR5S259BTA0073 | |
| 14060000113040 | L14/dossiers | 14 | 14060000112994 | 14060000113039 | 1 | 2 | BTA | PRJLANR5L14BTA0715 | |
| 14060000113044 | L14/dossiers | 14 | 14060000112994 | 14060000113043 | 1 | 2 | BTA | PRJLSNR5S259BTA0123 | |
| 14060000113101 | L14/dossiers | 14 | 14060000113084 | 14060000113100 | 1 | 2 | BTA | PIONANR5L14BTA0596 | |
| 14060000113140 | L14/dossiers | 14 | 14060000113122 | 14060000113139 | 1 | 2 | BTA | PIONANR5L14BTA0897 | |
| 14060000113194 | L14/dossiers | 14 | 14060000113149 | 14060000113193 | 1 | 2 | BTA | PRJLANR5L14BTA0414 | |
| 14060000113218 | L14/dossiers | 14 | 14060000113149 | 14060000113217 | 1 | 2 | BTA | PRJLSNR5S239BTA0024 | |
| 14060000113241 | L14/dossiers | 14 | 14060000113149 | 14060000113240 | 1 | 2 | BTA | PRJLANR5L14BTA0430 | |
| 14060000113251 | L14/dossiers | 14 | 14060000113149 | 14060000113250 | 1 | 2 | BTA | PRJLSNR5S239BTA0028 | |
| 14060000113261 | L14/dossiers | 14 | 14060000113149 | 14060000113260 | 1 | 2 | BTA | PRJLANR5L14BTA0438 | |
| 14060000113313 | L14/dossiers | 14 | 14060000113299 | 14060000113312 | 1 | 2 | BTA | PRJLSNR5S239BTA0062 | |
| 14060000113329 | L14/dossiers | 14 | 14060000113299 | 14060000113328 | 1 | 2 | BTA | PRJLANR5L14BTA0496 | |
| 14060000113375 | L14/dossiers | 14 | 14060000113362 | 14060000113374 | 1 | 2 | BTA | PRJLSNR5S199BTA0158 | |
| 14060000113389 | L14/dossiers | 14 | 14060000113362 | 14060000113388 | 1 | 2 | BTA | PRJLANR5L14BTA0365 | |
| 14060000113416 | L14/dossiers | 14 | 14060000113401 | 14060000113415 | 1 | 2 | BTA | PIONANR5L14BTA0303 | |
| 14060000113428 | L14/dossiers | 14 | 14060000113401 | 14060000113427 | 1 | 2 | BTA | PIONSNR5S219BTA0110 | |
| 14060000113442 | L14/dossiers | 14 | 14060000113401 | 14060000113441 | 1 | 2 | BTA | PIONANR5L14BTA0343 | |
| 14060000113446 | L14/dossiers | 14 | 14060000113401 | 14060000113445 | 1 | 2 | BTA | PIONSNR5S219BTA0129 | |
| 14060000113475 | L14/dossiers | 14 | 14060000113462 | 14060000113474 | 1 | 2 | BTA | PIONSNR5S199BTA0184 | |
| 14060000113530 | L14/dossiers | 14 | 14060000113520 | 14060000113529 | 1 | 2 | BTA | RIONANR5L14BTA0809 | |
| 14060000113540 | L14/dossiers | 14 | 14060000113531 | 14060000113539 | 1 | 2 | BTA | MIONSNR5S219BTA0149 | |
| 14060000113551 | L14/dossiers | 14 | 14060000113531 | 14060000113550 | 1 | 2 | BTA | MIONANR5L14BTA0373 | |
| 14060000113600 | L14/dossiers | 14 | 14060000113559 | 14060000113599 | 1 | 2 | BTA | PRJLANR5L14BTA0600 | |
| 14060000113625 | L14/dossiers | 14 | 14060000113559 | 14060000113624 | 1 | 2 | BTA | PRJLSNR5S259BTA0037 | |
| 14060000113648 | L14/dossiers | 14 | 14060000113559 | 14060000113647 | 1 | 2 | BTA | PRJLANR5L14BTA0610 | |
| 14060000113658 | L14/dossiers | 14 | 14060000113559 | 14060000113657 | 1 | 2 | BTA | PRJLSNR5S259BTA0045 | |
| 14060000113667 | L14/dossiers | 14 | 14060000113559 | 14060000113666 | 1 | 2 | BTA | PRJLANR5L14BTA0617 |