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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000101666 | L14/dossiers | 14 | 14060000101624 | 14060000101665 | 1 | 2 | BTA | PIONANR5L14BTA0471 | |
| 14060000101670 | L14/dossiers | 14 | 14060000101624 | 14060000101669 | 1 | 2 | BTA | PIONSNR5S239BTA0070 | |
| 14060000101688 | L14/dossiers | 14 | 14060000101674 | 14060000101687 | 1 | 2 | BTA | RIONANR5L14BTA0153 | |
| 14060000101711 | L14/dossiers | 14 | 14060000101696 | 14060000101710 | 1 | 2 | BTA | RIONANR5L14BTA0652 | |
| 14060000101753 | L14/dossiers | 14 | 14060000101734 | 14060000101752 | 1 | 2 | BTA | PIONANR5L14BTA0283 | |
| 14060000101774 | L14/dossiers | 14 | 14060000101767 | 14060000101773 | 1 | 2 | BTA | RIONANR5L14BTA0926 | |
| 14060000101795 | L14/dossiers | 14 | 14060000101778 | 14060000101794 | 1 | 2 | BTA | PRJLANR5L14BTA0922 | |
| 14060000101807 | L14/dossiers | 14 | 14060000101778 | 14060000101806 | 1 | 2 | BTA | PRJLSNR5S279BTA0112 | |
| 14060000101820 | L14/dossiers | 14 | 14060000101778 | 14060000101819 | 1 | 2 | BTA | PRJLANR5L15BTA0015 | |
| 14060000101868 | L14/dossiers | 14 | 14060000101851 | 14060000101867 | 1 | 2 | BTA | PRJLANR5L14BTA0007 | |
| 14060000101878 | L14/dossiers | 14 | 14060000101851 | 14060000101877 | 1 | 2 | BTA | PRJLSNR5S199BTA0058 | |
| 14060000101936 | L14/dossiers | 14 | 14060000101912 | 14060000101935 | 1 | 2 | BTA | PIONANR5L14BTA0631 | |
| 14060000101948 | L14/dossiers | 14 | 14060000101912 | 14060000101947 | 1 | 2 | BTA | PIONSNR5S259BTA0066 | |
| 14060000101962 | L14/dossiers | 14 | 14060000101912 | 14060000101961 | 1 | 2 | BTA | PIONANR5L14BTA0679 | |
| 14060000101966 | L14/dossiers | 14 | 14060000101912 | 14060000101965 | 1 | 2 | BTA | PIONSNR5S259BTA0098 | |
| 14060000102127 | L14/dossiers | 14 | 14060000102113 | 14060000102126 | 1 | 2 | BTA | PRJLSNR5S259BTA0088 | |
| 14060000102148 | L14/dossiers | 14 | 14060000102113 | 14060000102147 | 1 | 2 | BTA | PRJLANR5L14BTA0771 | |
| 14060000102177 | L14/dossiers | 14 | 14060000102158 | 14060000102176 | 1 | 2 | BTA | PIONANR5L14BTA0744 | |
| 14060000102189 | L14/dossiers | 14 | 14060000102158 | 14060000102188 | 1 | 2 | BTA | PIONSNR5S259BTA0163 | |
| 14060000102204 | L14/dossiers | 14 | 14060000102158 | 14060000102203 | 1 | 2 | BTA | PIONANR5L14BTA0799 | |
| 14060000102208 | L14/dossiers | 14 | 14060000102158 | 14060000102207 | 1 | 2 | BTA | PIONSNR5S259BTA0181 | |
| 14060000102244 | L14/dossiers | 14 | 14060000102231 | 14060000102243 | 1 | 2 | BTA | RIONANR5L14BTA0509 | |
| 14060000102278 | L14/dossiers | 14 | 14060000102269 | 14060000102277 | 1 | 2 | BTA | RIONANR5L14BTA0128 | |
| 14060000102372 | L14/dossiers | 14 | 14060000102356 | 14060000102371 | 1 | 2 | BTA | PIONANR5L14BTA0484 | |
| 14060000102412 | L14/dossiers | 14 | 14060000102397 | 14060000102411 | 1 | 2 | BTA | PRJLANR5L14BTA0491 | |
| 14060000102424 | L14/dossiers | 14 | 14060000102397 | 14060000102423 | 1 | 2 | BTA | PRJLSNR5S239BTA0093 | |
| 14060000102446 | L14/dossiers | 14 | 14060000102431 | 14060000102445 | 1 | 2 | BTA | RIONANR5L14BTA0076 | |
| 14060000102510 | L14/dossiers | 14 | 14060000102491 | 14060000102509 | 1 | 2 | BTA | PRJLANR5L14BTA0817 | |
| 14060000102522 | L14/dossiers | 14 | 14060000102491 | 14060000102521 | 1 | 2 | BTA | PRJLSNR5S279BTA0009 | |
| 14060000102537 | L14/dossiers | 14 | 14060000102491 | 14060000102536 | 1 | 2 | BTA | PRJLANR5L14BTA0895 | |
| 14060000102541 | L14/dossiers | 14 | 14060000102491 | 14060000102540 | 1 | 2 | BTA | PRJLSNR5S279BTA0085 | |
| 14060000102562 | L14/dossiers | 14 | 14060000102548 | 14060000102561 | 1 | 2 | BTA | RIONANR5L14BTA0095 | |
| 14060000102589 | L14/dossiers | 14 | 14060000102567 | 14060000102588 | 1 | 2 | BTA | PRJLANR5L14BTA0388 | |
| 14060000102622 | L14/dossiers | 14 | 14060000102567 | 14060000102621 | 1 | 2 | BTA | PRJLSNR5S239BTA0016 | |
| 14060000102636 | L14/dossiers | 14 | 14060000102567 | 14060000102635 | 1 | 2 | BTA | PRJLANR5L14BTA0449 | |
| 14060000102640 | L14/dossiers | 14 | 14060000102567 | 14060000102639 | 1 | 2 | BTA | PRJLSNR5S239BTA0047 | |
| 14060000102691 | L14/dossiers | 14 | 14060000102662 | 14060000102690 | 1 | 2 | BTA | PIONANR5L14BTA0501 | |
| 14060000102704 | L14/dossiers | 14 | 14060000102662 | 14060000102703 | 1 | 2 | BTA | PIONSNR5S259BTA0040 | |
| 14060000102716 | L14/dossiers | 14 | 14060000102662 | 14060000102715 | 1 | 2 | BTA | PIONANR5L14BTA0708 | |
| 14060000102726 | L14/dossiers | 14 | 14060000102662 | 14060000102725 | 1 | 2 | BTA | PIONSNR5S279BTA0001 | |
| 14060000102749 | L14/dossiers | 14 | 14060000102662 | 14060000102748 | 1 | 2 | BTA | PIONANR5L14BTA0843 | |
| 14060000102759 | L14/dossiers | 14 | 14060000102662 | 14060000102758 | 1 | 2 | BTA | PIONSNR5S279BTA0074 | |
| 14060000102768 | L14/dossiers | 14 | 14060000102662 | 14060000102767 | 1 | 2 | BTA | PIONANR5L14BTA0924 | |
| 14060000102800 | L14/dossiers | 14 | 14060000102786 | 14060000102799 | 1 | 2 | BTA | PRJLSNR5S239BTA0056 | |
| 14060000102815 | L14/dossiers | 14 | 14060000102786 | 14060000102814 | 1 | 2 | BTA | PRJLANR5L14BTA0472 | |
| 14060000102846 | L14/dossiers | 14 | 14060000102786 | 14060000102845 | 1 | 2 | BTA | PRJLANR5L14BTA0518 | |
| 14060000102856 | L14/dossiers | 14 | 14060000102786 | 14060000102855 | 1 | 2 | BTA | PRJLSNR5S239BTA0113 | |
| 14060000102866 | L14/dossiers | 14 | 14060000102786 | 14060000102865 | 1 | 2 | BTA | PRJLANR5L14BTA0534 | |
| 14060000102885 | L14/dossiers | 14 | 14060000102869 | 14060000102884 | 1 | 2 | BTA | RIONANR5L14BTA0880 | |
| 14060000102989 | L14/dossiers | 14 | 14060000102972 | 14060000102988 | 1 | 2 | BTA | PIONANR5L14BTA0616 |