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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000123545 | L14/dossiers | 14 | 14060000123467 | 14060000123544 | 1 | 2 | BTA | PIONANR5L14BTA0820 | |
| 14060000123579 | L14/dossiers | 14 | 14060000123566 | 14060000123578 | 1 | 2 | BTA | RIONANR5L14BTA0684 | |
| 14060000123651 | L14/dossiers | 14 | 14060000123636 | 14060000123650 | 1 | 2 | BTA | PRJLSNR5S239BTA0079 | |
| 14060000123664 | L14/dossiers | 14 | 14060000123636 | 14060000123663 | 1 | 2 | BTA | PRJLANR5L14BTA0510 | |
| 14060000123705 | L14/dossiers | 14 | 14060000123681 | 14060000123704 | 1 | 2 | BTA | PRJLANR5L14BTA0299 | |
| 14060000123728 | L14/dossiers | 14 | 14060000123681 | 14060000123727 | 1 | 2 | BTA | PRJLSNR5S219BTA0100 | |
| 14060000123741 | L14/dossiers | 14 | 14060000123681 | 14060000123740 | 1 | 2 | BTA | PRJLANR5L14BTA0342 | |
| 14060000123745 | L14/dossiers | 14 | 14060000123681 | 14060000123744 | 1 | 2 | BTA | PRJLSNR5S219BTA0131 | |
| 14060000123791 | L14/dossiers | 14 | 14060000123775 | 14060000123790 | 1 | 2 | BTA | PIONANR5L14BTA0739 | |
| 14060000123862 | L14/dossiers | 14 | 14060000123844 | 14060000123861 | 1 | 2 | BTA | PRJLANR5L14BTA0888 | |
| 14060000123874 | L14/dossiers | 14 | 14060000123844 | 14060000123873 | 1 | 2 | BTA | PRJLSNR5S279BTA0081 | |
| 14060000123920 | L14/dossiers | 14 | 14060000123904 | 14060000123919 | 1 | 2 | BTA | PIONANR5L14BTA0042 | |
| 14060000123979 | L14/dossiers | 14 | 14060000123945 | 14060000123978 | 1 | 2 | BTA | PRJLANR5L14BTA0447 | |
| 14060000123992 | L14/dossiers | 14 | 14060000123945 | 14060000123991 | 1 | 2 | BTA | PRJLSNR5S239BTA0033 | |
| 14060000124014 | L14/dossiers | 14 | 14060000123945 | 14060000124013 | 1 | 2 | BTA | PRJLANR5L14BTA0452 | |
| 14060000124024 | L14/dossiers | 14 | 14060000123945 | 14060000124023 | 1 | 2 | BTA | PRJLSNR5S239BTA0036 | |
| 14060000124035 | L14/dossiers | 14 | 14060000123945 | 14060000124034 | 1 | 2 | BTA | PRJLANR5L14BTA0460 | |
| 14060000124070 | L14/dossiers | 14 | 14060000124057 | 14060000124069 | 1 | 2 | BTA | PIONSNR5S299BTA0053 | |
| 14060000124114 | L14/dossiers | 14 | 14060000124097 | 14060000124113 | 1 | 2 | BTA | PRJLANR5L14BTA0313 | |
| 14060000124126 | L14/dossiers | 14 | 14060000124097 | 14060000124125 | 1 | 2 | BTA | PRJLSNR5S219BTA0096 | |
| 14060000124167 | L14/dossiers | 14 | 14060000124153 | 14060000124166 | 1 | 2 | BTA | PRJLSNR5S199BTA0207 | |
| 14060000124181 | L14/dossiers | 14 | 14060000124153 | 14060000124180 | 1 | 2 | BTA | PRJLANR5L14BTA0228 | |
| 14060000124207 | L14/dossiers | 14 | 14060000124184 | 14060000124206 | 1 | 2 | BTA | PRJLANR5L14BTA0852 | |
| 14060000124221 | L14/dossiers | 14 | 14060000124184 | 14060000124220 | 1 | 2 | BTA | PRJLSNR5S279BTA0039 | |
| 14060000124243 | L14/dossiers | 14 | 14060000124184 | 14060000124242 | 1 | 2 | BTA | PRJLANR5L14BTA0866 | |
| 14060000124253 | L14/dossiers | 14 | 14060000124184 | 14060000124252 | 1 | 2 | BTA | PRJLSNR5S279BTA0051 | |
| 14060000124264 | L14/dossiers | 14 | 14060000124184 | 14060000124263 | 1 | 2 | BTA | PRJLANR5L14BTA0877 | |
| 14060000124338 | L14/dossiers | 14 | 14060000124320 | 14060000124337 | 1 | 2 | BTA | PRJLANR5L14BTA0907 | |
| 14060000124350 | L14/dossiers | 14 | 14060000124320 | 14060000124349 | 1 | 2 | BTA | PRJLSNR5S279BTA0093 | |
| 14060000124428 | L14/dossiers | 14 | 14060000124375 | 14060000124427 | 1 | 2 | BTA | PRJLANR5L14BTA0176 | |
| 14060000124459 | L14/dossiers | 14 | 14060000124375 | 14060000124458 | 1 | 2 | BTA | PRJLSNR5S199BTA0213 | |
| 14060000124479 | L14/dossiers | 14 | 14060000124375 | 14060000124478 | 1 | 2 | BTA | PRJLANR5L14BTA0262 | |
| 14060000124491 | L14/dossiers | 14 | 14060000124375 | 14060000124490 | 1 | 2 | BTA | PRJLSNR5S219BTA0071 | |
| 14060000124507 | L14/dossiers | 14 | 14060000124375 | 14060000124506 | 1 | 2 | BTA | PRJLSNR5S219BTA0077 | |
| 14060000124511 | L14/dossiers | 14 | 14060000124375 | 14060000124510 | 1 | 2 | BTA | PRJLANR5L14BTA0295 | |
| 14060000124547 | L14/dossiers | 14 | 14060000124528 | 14060000124546 | 1 | 2 | BTA | PRJLANR5L14BTA0626 | |
| 14060000124559 | L14/dossiers | 14 | 14060000124528 | 14060000124558 | 1 | 2 | BTA | PRJLSNR5S259BTA0071 | |
| 14060000124573 | L14/dossiers | 14 | 14060000124528 | 14060000124572 | 1 | 2 | BTA | PRJLANR5L14BTA0712 | |
| 14060000124577 | L14/dossiers | 14 | 14060000124528 | 14060000124576 | 1 | 2 | BTA | PRJLSNR5S259BTA0121 | |
| 14060000124627 | L14/dossiers | 14 | 14060000124612 | 14060000124626 | 1 | 2 | BTA | PRJLSNR5S239BTA0126 | |
| 14060000124639 | L14/dossiers | 14 | 14060000124612 | 14060000124638 | 1 | 2 | BTA | PRJLANR5L14BTA0586 | |
| 14060000124712 | L14/dossiers | 14 | 14060000124698 | 14060000124711 | 1 | 2 | BTA | PRJLSNR5S239BTA0065 | |
| 14060000124726 | L14/dossiers | 14 | 14060000124698 | 14060000124725 | 1 | 2 | BTA | PRJLANR5L14BTA0697 | |
| 14060000124753 | L14/dossiers | 14 | 14060000124736 | 14060000124752 | 1 | 2 | BTA | PRJLANR5L14BTA0012 | |
| 14060000124763 | L14/dossiers | 14 | 14060000124736 | 14060000124762 | 1 | 2 | BTA | PRJLSNR5S199BTA0056 | |
| 14060000124805 | L14/dossiers | 14 | 14060000124780 | 14060000124804 | 1 | 2 | BTA | PIONANR5L14BTA0651 | |
| 14060000124823 | L14/dossiers | 14 | 14060000124780 | 14060000124822 | 1 | 2 | BTA | PIONSNR5S259BTA0075 | |
| 14060000124837 | L14/dossiers | 14 | 14060000124780 | 14060000124836 | 1 | 2 | BTA | PIONSNR5S259BTA0101 | |
| 14060000124841 | L14/dossiers | 14 | 14060000124780 | 14060000124840 | 1 | 2 | BTA | PIONANR5L14BTA0688 | |
| 14060000124868 | L14/dossiers | 14 | 14060000124854 | 14060000124867 | 1 | 2 | BTA | PRJLSNR5S259BTA0132 |