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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000097652 | L14/dossiers | 14 | 14060000097638 | 14060000097651 | 1 | 2 | BTA | PIONANR5L14BTA0248 | |
| 14060000097743 | L14/dossiers | 14 | 14060000097719 | 14060000097742 | 1 | 2 | BTA | PRJLANR5L14BTA0255 | |
| 14060000097756 | L14/dossiers | 14 | 14060000097719 | 14060000097755 | 1 | 2 | BTA | PRJLSNR5S219BTA0049 | |
| 14060000097777 | L14/dossiers | 14 | 14060000097719 | 14060000097776 | 1 | 2 | BTA | PRJLANR5L14BTA0264 | |
| 14060000097787 | L14/dossiers | 14 | 14060000097719 | 14060000097786 | 1 | 2 | BTA | PRJLSNR5S219BTA0055 | |
| 14060000097797 | L14/dossiers | 14 | 14060000097719 | 14060000097796 | 1 | 2 | BTA | PRJLANR5L14BTA0268 | |
| 14060000097837 | L14/dossiers | 14 | 14060000097829 | 14060000097836 | 1 | 2 | BTA | RIONANR5L14BTA0614 | |
| 14060000097875 | L14/dossiers | 14 | 14060000097862 | 14060000097874 | 1 | 2 | BTA | PIONSNR5S239BTA0104 | |
| 14060000097936 | L14/dossiers | 14 | 14060000097920 | 14060000097935 | 1 | 2 | BTA | PRJLANR5L14BTA0001 | |
| 14060000097948 | L14/dossiers | 14 | 14060000097920 | 14060000097947 | 1 | 2 | BTA | PRJLSNR5S198BTA0124 | |
| 14060000097993 | L14/dossiers | 14 | 14060000097969 | 14060000097992 | 1 | 2 | BTA | PIONANR5L14BTA0214 | |
| 14060000098020 | L14/dossiers | 14 | 14060000097969 | 14060000098019 | 1 | 2 | BTA | PIONSNR5S219BTA0074 | |
| 14060000098041 | L14/dossiers | 14 | 14060000097969 | 14060000098040 | 1 | 2 | BTA | PIONANR5L14BTA0298 | |
| 14060000098051 | L14/dossiers | 14 | 14060000097969 | 14060000098050 | 1 | 2 | BTA | PIONSNR5S219BTA0086 | |
| 14060000098060 | L14/dossiers | 14 | 14060000097969 | 14060000098059 | 1 | 2 | BTA | PIONANR5L14BTA0309 | |
| 14060000098094 | L14/dossiers | 14 | 14060000098078 | 14060000098093 | 1 | 2 | BTA | PIONANR5L14BTA0352 | |
| 14060000098145 | L14/dossiers | 14 | 14060000098102 | 14060000098144 | 1 | 2 | BTA | PRJLANR5L14BTA0521 | |
| 14060000098172 | L14/dossiers | 14 | 14060000098102 | 14060000098171 | 1 | 2 | BTA | PRJLSNR5S239BTA0123 | |
| 14060000098196 | L14/dossiers | 14 | 14060000098102 | 14060000098195 | 1 | 2 | BTA | PRJLANR5L14BTA0564 | |
| 14060000098206 | L14/dossiers | 14 | 14060000098102 | 14060000098205 | 1 | 2 | BTA | PRJLSNR5S239BTA0137 | |
| 14060000098216 | L14/dossiers | 14 | 14060000098102 | 14060000098215 | 1 | 2 | BTA | PRJLANR5L14BTA0577 | |
| 14060000098241 | L14/dossiers | 14 | 14060000098228 | 14060000098240 | 1 | 2 | BTA | PIONSNR5S199BTA0015 | |
| 14060000098258 | L14/dossiers | 14 | 14060000098228 | 14060000098257 | 1 | 2 | BTA | PIONANR5L14BTA0079 | |
| 14060000098344 | L14/dossiers | 14 | 14060000098326 | 14060000098343 | 1 | 2 | BTA | PRJLANR5L14BTA0870 | |
| 14060000098356 | L14/dossiers | 14 | 14060000098326 | 14060000098355 | 1 | 2 | BTA | PRJLSNR5S279BTA0117 | |
| 14060000098447 | L14/dossiers | 14 | 14060000098431 | 14060000098446 | 1 | 2 | BTA | PIONANR5L14BTA0849 | |
| 14060000098464 | L14/dossiers | 14 | 14060000098431 | 14060000098463 | 1 | 2 | BTA | PIONSNR5S279BTA0059 | |
| 14060000098476 | L14/dossiers | 14 | 14060000098431 | 14060000098475 | 1 | 2 | BTA | PIONANR5L14BTA0898 | |
| 14060000098521 | L14/dossiers | 14 | 14060000098506 | 14060000098520 | 1 | 2 | BTA | PRJLSNR5S219BTA0008 | |
| 14060000098541 | L14/dossiers | 14 | 14060000098506 | 14060000098540 | 1 | 2 | BTA | PRJLANR5L14BTA0258 | |
| 14060000098571 | L14/dossiers | 14 | 14060000098551 | 14060000098570 | 1 | 2 | BTA | RIONANR5L14BTA0437 | |
| 14060000098600 | L14/dossiers | 14 | 14060000098586 | 14060000098599 | 1 | 2 | BTA | RIONANR5L14BTA0419 | |
| 14060000098639 | L14/dossiers | 14 | 14060000098618 | 14060000098638 | 1 | 2 | BTA | PNREANR5L14BTA0512 | |
| 14060000099027 | L14/dossiers | 14 | 14060000098680 | 14060000099026 | 1 | 2 | BTA | PRJLANR5L14BTA0602 | |
| 14060000099053 | L14/dossiers | 14 | 14060000098680 | 14060000099052 | 1 | 2 | BTA | PRJLSNR5S259BTA0047 | |
| 14060000099074 | L14/dossiers | 14 | 14060000098680 | 14060000099073 | 1 | 2 | BTA | PRJLANR5L14BTA0643 | |
| 14060000099084 | L14/dossiers | 14 | 14060000098680 | 14060000099083 | 1 | 2 | BTA | PRJLSNR5S259BTA0055 | |
| 14060000099096 | L14/dossiers | 14 | 14060000098680 | 14060000099095 | 1 | 2 | BTA | PRJLANR5L14BTA0648 | |
| 14060000099491 | L14/dossiers | 14 | 14060000099472 | 14060000099490 | 1 | 2 | BTA | PRJLANR5L14BTA0141 | |
| 14060000099508 | L14/dossiers | 14 | 14060000099472 | 14060000099507 | 1 | 2 | BTA | PRJLSNR5S199BTA0162 | |
| 14060000099520 | L14/dossiers | 14 | 14060000099472 | 14060000099519 | 1 | 2 | BTA | PRJLANR5L14BTA0157 | |
| 14060000099545 | L14/dossiers | 14 | 14060000099530 | 14060000099544 | 1 | 2 | BTA | RIONANR5L14BTA0930 | |
| 14060000099553 | L14/dossiers | 14 | 14060000099546 | 14060000099552 | 1 | 2 | BTA | PNREANR5L14BTA0763 | |
| 14060000099626 | L14/dossiers | 14 | 14060000099613 | 14060000099625 | 1 | 2 | BTA | PIONSNR5S219BTA0079 | |
| 14060000099689 | L14/dossiers | 14 | 14060000099671 | 14060000099688 | 1 | 2 | BTA | PIONANR5L14BTA0319 | |
| 14060000099701 | L14/dossiers | 14 | 14060000099671 | 14060000099700 | 1 | 2 | BTA | PIONSNR5S219BTA0103 | |
| 14060000099712 | L14/dossiers | 14 | 14060000099671 | 14060000099711 | 1 | 2 | BTA | PIONANR5L14BTA0351 | |
| 14060000099730 | L14/dossiers | 14 | 14060000099717 | 14060000099729 | 1 | 2 | BTA | PRJLSNR5S259BTA0025 | |
| 14060000099752 | L14/dossiers | 14 | 14060000099739 | 14060000099751 | 1 | 2 | BTA | PIONSNR5S279BTA0075 | |
| 14060000100051 | L14/dossiers | 14 | 14060000099774 | 14060000100050 | 1 | 2 | BTA | PRJLANR5L14BTA0038 |