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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000092499 | L14/dossiers | 14 | 14060000092362 | 14060000092498 | 1 | 2 | BTA | PRJLANR5L14BTA0270 | |
| 14060000092572 | L14/dossiers | 14 | 14060000092563 | 14060000092571 | 1 | 2 | BTA | PNREANR5L14BTA0186 | |
| 14060000092589 | L14/dossiers | 14 | 14060000092573 | 14060000092588 | 1 | 2 | BTA | PIONANR5L14BTA0675 | |
| 14060000092611 | L14/dossiers | 14 | 14060000092597 | 14060000092610 | 1 | 2 | BTA | PRJLSNR5S279BTA0020 | |
| 14060000092625 | L14/dossiers | 14 | 14060000092597 | 14060000092624 | 1 | 2 | BTA | PRJLANR5L14BTA0873 | |
| 14060000092655 | L14/dossiers | 14 | 14060000092642 | 14060000092654 | 1 | 2 | BTA | PIONSNR5S239BTA0105 | |
| 14060000092692 | L14/dossiers | 14 | 14060000092676 | 14060000092691 | 1 | 2 | BTA | PRJLANR5L14BTA0546 | |
| 14060000092704 | L14/dossiers | 14 | 14060000092676 | 14060000092703 | 1 | 2 | BTA | PRJLSNR5S239BTA0125 | |
| 14060000092736 | L14/dossiers | 14 | 14060000092714 | 14060000092735 | 1 | 2 | BTA | PRJLANR5L14BTA0773 | |
| 14060000092748 | L14/dossiers | 14 | 14060000092714 | 14060000092747 | 1 | 2 | BTA | PRJLSNR5S259BTA0171 | |
| 14060000092792 | L14/dossiers | 14 | 14060000092774 | 14060000092791 | 1 | 2 | BTA | PIONANR5L14BTA0311 | |
| 14060000092804 | L14/dossiers | 14 | 14060000092774 | 14060000092803 | 1 | 2 | BTA | PIONSNR5S219BTA0109 | |
| 14060000092818 | L14/dossiers | 14 | 14060000092774 | 14060000092817 | 1 | 2 | BTA | PIONSNR5S219BTA0133 | |
| 14060000092822 | L14/dossiers | 14 | 14060000092774 | 14060000092821 | 1 | 2 | BTA | PIONANR5L14BTA0367 | |
| 14060000092873 | L14/dossiers | 14 | 14060000092857 | 14060000092872 | 1 | 2 | BTA | PRJLSNR5S199BTA0074 | |
| 14060000092897 | L14/dossiers | 14 | 14060000092857 | 14060000092896 | 1 | 2 | BTA | PRJLANR5L14BTA0090 | |
| 14060000092908 | L14/dossiers | 14 | 14060000092857 | 14060000092907 | 1 | 2 | BTA | PRJLSNR5S199BTA0117 | |
| 14060000092924 | L14/dossiers | 14 | 14060000092857 | 14060000092923 | 1 | 2 | BTA | PRJLANR5L14BTA0100 | |
| 14060000092952 | L14/dossiers | 14 | 14060000092857 | 14060000092951 | 1 | 2 | BTA | PRJLANR5L14BTA0104 | |
| 14060000092962 | L14/dossiers | 14 | 14060000092857 | 14060000092961 | 1 | 2 | BTA | PRJLSNR5S199BTA0130 | |
| 14060000092973 | L14/dossiers | 14 | 14060000092857 | 14060000092972 | 1 | 2 | BTA | PRJLANR5L14BTA0118 | |
| 14060000092993 | L14/dossiers | 14 | 14060000092980 | 14060000092992 | 1 | 2 | BTA | PIONSNR5S239BTA0006 | |
| 14060000093008 | L14/dossiers | 14 | 14060000092980 | 14060000093007 | 1 | 2 | BTA | PIONANR5L14BTA0458 | |
| 14060000093018 | L14/dossiers | 14 | 14060000092980 | 14060000093017 | 1 | 2 | BTA | PIONSNR5S239BTA0059 | |
| 14060000093122 | L14/dossiers | 14 | 14060000093104 | 14060000093121 | 1 | 2 | BTA | PRJLANR5L14BTA0638 | |
| 14060000093134 | L14/dossiers | 14 | 14060000093104 | 14060000093133 | 1 | 2 | BTA | PRJLSNR5S259BTA0058 | |
| 14060000093157 | L14/dossiers | 14 | 14060000093137 | 14060000093156 | 1 | 2 | BTA | PRJLANR5L14BTA0609 | |
| 14060000093169 | L14/dossiers | 14 | 14060000093137 | 14060000093168 | 1 | 2 | BTA | PRJLSNR5S259BTA0042 | |
| 14060000093202 | L14/dossiers | 14 | 14060000093193 | 14060000093201 | 1 | 2 | BTA | RIONANR5L14BTA0322 | |
| 14060000093267 | L14/dossiers | 14 | 14060000093260 | 14060000093266 | 1 | 2 | BTA | RIONANR5L14BTA0301 | |
| 14060000093293 | L14/dossiers | 14 | 14060000093279 | 14060000093292 | 1 | 2 | BTA | RIONANR5L14BTA0545 | |
| 14060000093354 | L14/dossiers | 14 | 14060000093340 | 14060000093353 | 1 | 2 | BTA | PRJLSNR5S259BTA0107 | |
| 14060000093368 | L14/dossiers | 14 | 14060000093340 | 14060000093367 | 1 | 2 | BTA | PRJLANR5L14BTA0748 | |
| 14060000093447 | L14/dossiers | 14 | 14060000093434 | 14060000093446 | 1 | 2 | BTA | PIONSNR5S239BTA0101 | |
| 14060000093527 | L14/dossiers | 14 | 14060000093512 | 14060000093526 | 1 | 2 | BTA | PRJLSNR5S239BTA0022 | |
| 14060000093539 | L14/dossiers | 14 | 14060000093512 | 14060000093538 | 1 | 2 | BTA | PRJLANR5L14BTA0421 | |
| 14060000093652 | L14/dossiers | 14 | 14060000093643 | 14060000093651 | 1 | 2 | BTA | RIONANR5L14BTA0727 | |
| 14060000093688 | L14/dossiers | 14 | 14060000093674 | 14060000093687 | 1 | 2 | BTA | PRJLSNR5S279BTA0091 | |
| 14060000093707 | L14/dossiers | 14 | 14060000093674 | 14060000093706 | 1 | 2 | BTA | PRJLANR5L15BTA0012 | |
| 14060000093736 | L14/dossiers | 14 | 14060000093721 | 14060000093735 | 1 | 2 | BTA | PRJLSNR5S239BTA0120 | |
| 14060000093761 | L14/dossiers | 14 | 14060000093721 | 14060000093760 | 1 | 2 | BTA | PRJLANR5L14BTA0571 | |
| 14060000093775 | L14/dossiers | 14 | 14060000093721 | 14060000093774 | 1 | 2 | BTA | PRJLSNR5S259BTA0001 | |
| 14060000093779 | L14/dossiers | 14 | 14060000093721 | 14060000093778 | 1 | 2 | BTA | PRJLANR5L14BTA0589 | |
| 14060000093826 | L14/dossiers | 14 | 14060000093807 | 14060000093825 | 1 | 2 | BTA | PRJLSNR5S279BTA0071 | |
| 14060000093842 | L14/dossiers | 14 | 14060000093807 | 14060000093841 | 1 | 2 | BTA | PRJLANR5L14BTA0910 | |
| 14060000093867 | L14/dossiers | 14 | 14060000093807 | 14060000093866 | 1 | 2 | BTA | PRJLANR5L14BTA0916 | |
| 14060000093877 | L14/dossiers | 14 | 14060000093807 | 14060000093876 | 1 | 2 | BTA | PRJLSNR5S279BTA0096 | |
| 14060000093886 | L14/dossiers | 14 | 14060000093807 | 14060000093885 | 1 | 2 | BTA | PRJLANR5L14BTA0927 | |
| 14060000093941 | L14/dossiers | 14 | 14060000093927 | 14060000093940 | 1 | 2 | BTA | PRJLSNR5S219BTA0165 | |
| 14060000093960 | L14/dossiers | 14 | 14060000093927 | 14060000093959 | 1 | 2 | BTA | PRJLANR5L14BTA0408 |