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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000120626 | L14/dossiers | 14 | 14060000120509 | 14060000120625 | 1 | 2 | BTA | PRJLANR5L14BTA0374 | |
| 14060000120640 | L14/dossiers | 14 | 14060000120509 | 14060000120639 | 1 | 2 | BTA | PRJLSNR5S219BTA0159 | |
| 14060000120644 | L14/dossiers | 14 | 14060000120509 | 14060000120643 | 1 | 2 | BTA | PRJLANR5L14BTA0387 | |
| 14060000120672 | L14/dossiers | 14 | 14060000120657 | 14060000120671 | 1 | 2 | BTA | PRJLANR5L14BTA0506 | |
| 14060000120684 | L14/dossiers | 14 | 14060000120657 | 14060000120683 | 1 | 2 | BTA | PRJLSNR5S239BTA0144 | |
| 14060000120715 | L14/dossiers | 14 | 14060000120701 | 14060000120714 | 1 | 2 | BTA | PRJLSNR5S239BTA0044 | |
| 14060000120728 | L14/dossiers | 14 | 14060000120701 | 14060000120727 | 1 | 2 | BTA | PRJLANR5L14BTA0548 | |
| 14060000120748 | L14/dossiers | 14 | 14060000120731 | 14060000120747 | 1 | 2 | BTA | RIONANR5L14BTA0177 | |
| 14060000120789 | L14/dossiers | 14 | 14060000120773 | 14060000120788 | 1 | 2 | BTA | PIONANR5L14BTA0598 | |
| 14060000120808 | L14/dossiers | 14 | 14060000120795 | 14060000120807 | 1 | 2 | BTA | PIONSNR5S239BTA0114 | |
| 14060000120823 | L14/dossiers | 14 | 14060000120795 | 14060000120822 | 1 | 2 | BTA | PIONANR5L14BTA0757 | |
| 14060000120900 | L14/dossiers | 14 | 14060000120882 | 14060000120899 | 1 | 2 | BTA | PRJLANR5L14BTA0329 | |
| 14060000120912 | L14/dossiers | 14 | 14060000120882 | 14060000120911 | 1 | 2 | BTA | PRJLSNR5S219BTA0115 | |
| 14060000121011 | L14/dossiers | 14 | 14060000120991 | 14060000121010 | 1 | 2 | BTA | RIONANR5L14BTA0339 | |
| 14060000121052 | L14/dossiers | 14 | 14060000121034 | 14060000121051 | 1 | 2 | BTA | PIONSNR5S219BTA0125 | |
| 14060000121157 | L14/dossiers | 14 | 14060000121141 | 14060000121156 | 1 | 2 | BTA | PIONANR5L14BTA0318 | |
| 14060000121169 | L14/dossiers | 14 | 14060000121141 | 14060000121168 | 1 | 2 | BTA | PIONSNR5S219BTA0136 | |
| 14060000121268 | L14/dossiers | 14 | 14060000121252 | 14060000121267 | 1 | 2 | BTA | PIONANR5L14BTA0058 | |
| 14060000121312 | L14/dossiers | 14 | 14060000121277 | 14060000121311 | 1 | 2 | BTA | PRJLANR5L14BTA0246 | |
| 14060000121330 | L14/dossiers | 14 | 14060000121277 | 14060000121329 | 1 | 2 | BTA | PRJLSNR5S219BTA0060 | |
| 14060000121344 | L14/dossiers | 14 | 14060000121277 | 14060000121343 | 1 | 2 | BTA | PRJLSNR5S219BTA0076 | |
| 14060000121348 | L14/dossiers | 14 | 14060000121277 | 14060000121347 | 1 | 2 | BTA | PRJLANR5L14BTA0296 | |
| 14060000121423 | L14/dossiers | 14 | 14060000121405 | 14060000121422 | 1 | 2 | BTA | PIONANR5L14BTA0500 | |
| 14060000121435 | L14/dossiers | 14 | 14060000121405 | 14060000121434 | 1 | 2 | BTA | PIONSNR5S239BTA0103 | |
| 14060000121457 | L14/dossiers | 14 | 14060000121405 | 14060000121456 | 1 | 2 | BTA | PIONANR5L14BTA0558 | |
| 14060000121467 | L14/dossiers | 14 | 14060000121405 | 14060000121466 | 1 | 2 | BTA | PIONSNR5S239BTA0127 | |
| 14060000121477 | L14/dossiers | 14 | 14060000121405 | 14060000121476 | 1 | 2 | BTA | PIONANR5L14BTA0563 | |
| 14060000121551 | L14/dossiers | 14 | 14060000121504 | 14060000121550 | 1 | 2 | BTA | PRJLANR5L14BTA0505 | |
| 14060000121590 | L14/dossiers | 14 | 14060000121504 | 14060000121589 | 1 | 2 | BTA | PRJLSNR5S259BTA0003 | |
| 14060000121622 | L14/dossiers | 14 | 14060000121504 | 14060000121621 | 1 | 2 | BTA | PRJLANR5L14BTA0618 | |
| 14060000121632 | L14/dossiers | 14 | 14060000121504 | 14060000121631 | 1 | 2 | BTA | PRJLSNR5S259BTA0054 | |
| 14060000121641 | L14/dossiers | 14 | 14060000121504 | 14060000121640 | 1 | 2 | BTA | PRJLANR5L14BTA0650 | |
| 14060000121674 | L14/dossiers | 14 | 14060000121660 | 14060000121673 | 1 | 2 | BTA | PRJLSNR5S259BTA0156 | |
| 14060000121687 | L14/dossiers | 14 | 14060000121660 | 14060000121686 | 1 | 2 | BTA | PRJLANR5L14BTA0797 | |
| 14060000121773 | L14/dossiers | 14 | 14060000121732 | 14060000121772 | 1 | 2 | BTA | PRJLANR5L14BTA0578 | |
| 14060000121793 | L14/dossiers | 14 | 14060000121732 | 14060000121792 | 1 | 2 | BTA | PRJLSNR5S259BTA0008 | |
| 14060000121817 | L14/dossiers | 14 | 14060000121732 | 14060000121816 | 1 | 2 | BTA | PRJLANR5L14BTA0664 | |
| 14060000121827 | L14/dossiers | 14 | 14060000121732 | 14060000121826 | 1 | 2 | BTA | PRJLSNR5S259BTA0092 | |
| 14060000121837 | L14/dossiers | 14 | 14060000121732 | 14060000121836 | 1 | 2 | BTA | PRJLANR5L14BTA0683 | |
| 14060000121914 | L14/dossiers | 14 | 14060000121873 | 14060000121913 | 1 | 2 | BTA | PRJLANR5L14BTA0029 | |
| 14060000121938 | L14/dossiers | 14 | 14060000121873 | 14060000121937 | 1 | 2 | BTA | PRJLSNR5S199BTA0029 | |
| 14060000121961 | L14/dossiers | 14 | 14060000121873 | 14060000121960 | 1 | 2 | BTA | PRJLANR5L14BTA0046 | |
| 14060000121971 | L14/dossiers | 14 | 14060000121873 | 14060000121970 | 1 | 2 | BTA | PRJLSNR5S199BTA0041 | |
| 14060000121981 | L14/dossiers | 14 | 14060000121873 | 14060000121980 | 1 | 2 | BTA | PRJLANR5L14BTA0054 | |
| 14060000122008 | L14/dossiers | 14 | 14060000121991 | 14060000122007 | 1 | 2 | BTA | PRJLANR5L14BTA0362 | |
| 14060000122020 | L14/dossiers | 14 | 14060000121991 | 14060000122019 | 1 | 2 | BTA | PRJLSNR5S239BTA0007 | |
| 14060000122037 | L14/dossiers | 14 | 14060000122023 | 14060000122036 | 1 | 2 | BTA | PRJLSNR5S239BTA0018 | |
| 14060000122050 | L14/dossiers | 14 | 14060000122023 | 14060000122049 | 1 | 2 | BTA | PRJLANR5L14BTA0730 | |
| 14060000122084 | L14/dossiers | 14 | 14060000122066 | 14060000122083 | 1 | 2 | BTA | PRJLANR5L14BTA0541 | |
| 14060000122096 | L14/dossiers | 14 | 14060000122066 | 14060000122095 | 1 | 2 | BTA | PRJLSNR5S239BTA0130 |