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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000164762 | L15/dossiers | 15 | 15060000164685 | 15060000164760 | 2 | 2 | TAP | PRJLANR5L15TAP0468 | |
| 15060000164789 | L15/dossiers | 15 | 15060000164768 | 15060000164788 | 1 | 2 | BTA | PRJLANR5L15BTA0440 | |
| 15060000164790 | L15/dossiers | 15 | 15060000164768 | 15060000164788 | 2 | 2 | TAP | PRJLANR5L15TAP0440 | |
| 15060000164802 | L15/dossiers | 15 | 15060000164768 | 15060000164801 | 1 | 2 | BTA | PRJLSNR5S339BTA0116 | |
| 15060000164822 | L15/dossiers | 15 | 15060000164768 | 15060000164821 | 1 | 2 | BTA | PRJLANR5L15BTA0465 | |
| 15060000164823 | L15/dossiers | 15 | 15060000164768 | 15060000164821 | 2 | 2 | TAP | PRJLANR5L15TAP0465 | |
| 15060000164833 | L15/dossiers | 15 | 15060000164768 | 15060000164832 | 1 | 2 | BTA | PRJLSNR5S339BTA0132 | |
| 15060000164842 | L15/dossiers | 15 | 15060000164768 | 15060000164841 | 1 | 2 | BTA | PRJLANR5L15BTA0469 | |
| 15060000164843 | L15/dossiers | 15 | 15060000164768 | 15060000164841 | 2 | 2 | TAP | PRJLANR5L15TAP0469 | |
| 15060000164865 | L15/dossiers | 15 | 15060000164846 | 15060000164864 | 1 | 2 | BTA | PRJLANR5L15BTA0431 | |
| 15060000164866 | L15/dossiers | 15 | 15060000164846 | 15060000164864 | 2 | 2 | TAP | PRJLANR5L15TAP0431 | |
| 15060000164877 | L15/dossiers | 15 | 15060000164846 | 15060000164876 | 1 | 2 | BTA | PRJLSNR5S339BTA0099 | |
| 15060000164891 | L15/dossiers | 15 | 15060000164846 | 15060000164890 | 1 | 2 | BTA | PRJLANR5L15BTA0441 | |
| 15060000164892 | L15/dossiers | 15 | 15060000164846 | 15060000164890 | 2 | 2 | TAP | PRJLANR5L15TAP0441 | |
| 15060000164895 | L15/dossiers | 15 | 15060000164846 | 15060000164894 | 1 | 2 | BTA | PRJLSNR5S339BTA0102 | |
| 15060000164912 | L15/dossiers | 15 | 15060000164899 | 15060000164911 | 1 | 2 | BTA | PRJLSNR5S339BTA0101 | |
| 15060000164926 | L15/dossiers | 15 | 15060000164899 | 15060000164925 | 1 | 2 | BTA | PRJLANR5L15BTA0457 | |
| 15060000164927 | L15/dossiers | 15 | 15060000164899 | 15060000164925 | 2 | 2 | TAP | PRJLANR5L15TAP0457 | |
| 15060000164963 | L15/dossiers | 15 | 15060000164947 | 15060000164962 | 1 | 2 | BTA | PIONANR5L15BTA0456 | |
| 15060000164964 | L15/dossiers | 15 | 15060000164947 | 15060000164962 | 2 | 2 | TAP | PIONANR5L15TAP0456 | |
| 15060000164990 | L15/dossiers | 15 | 15060000164973 | 15060000164989 | 1 | 2 | BTA | PIONANR5L15BTA0783 | |
| 15060000165030 | L15/dossiers | 15 | 15060000165016 | 15060000165029 | 1 | 2 | BTA | PIONANR5L15BTA0454 | |
| 15060000165130 | L15/dossiers | 15 | 15060000165111 | 15060000165129 | 1 | 2 | BTA | PRJLANR5L15BTA0594 | |
| 15060000165141 | L15/dossiers | 15 | 15060000165111 | 15060000165140 | 1 | 2 | BTA | PRJLSNR5S359BTA0128 | |
| 15060000165175 | L15/dossiers | 15 | 15060000165162 | 15060000165174 | 1 | 2 | BTA | PRJLSNR5S339BTA0128 | |
| 15060000165195 | L15/dossiers | 15 | 15060000165162 | 15060000165194 | 1 | 2 | BTA | PRJLANR5L15BTA0548 | |
| 15060000165424 | L15/dossiers | 15 | 15060000165391 | 15060000165423 | 1 | 2 | BTA | PRJLANR5L15BTA0460 | |
| 15060000165425 | L15/dossiers | 15 | 15060000165391 | 15060000165423 | 2 | 2 | TAP | PRJLANR5L15TAP0460 | |
| 15060000165436 | L15/dossiers | 15 | 15060000165391 | 15060000165435 | 1 | 2 | BTA | PRJLSNR5S339BTA0121 | |
| 15060000165449 | L15/dossiers | 15 | 15060000165391 | 15060000165448 | 1 | 2 | BTA | PRJLSNR5S339BTA0135 | |
| 15060000165453 | L15/dossiers | 15 | 15060000165391 | 15060000165452 | 1 | 2 | BTA | PRJLANR5L15BTA0471 | |
| 15060000165454 | L15/dossiers | 15 | 15060000165391 | 15060000165452 | 2 | 2 | TAP | PRJLANR5L15TAP0471 | |
| 15060000165476 | L15/dossiers | 15 | 15060000165458 | 15060000165475 | 1 | 2 | BTA | PRJLANR5L15BTA0442 | |
| 15060000165477 | L15/dossiers | 15 | 15060000165458 | 15060000165475 | 2 | 2 | TAP | PRJLANR5L15TAP0442 | |
| 15060000165488 | L15/dossiers | 15 | 15060000165458 | 15060000165487 | 1 | 2 | BTA | PRJLSNR5S339BTA0106 | |
| 15060000165511 | L15/dossiers | 15 | 15060000165458 | 15060000165510 | 1 | 2 | BTA | PRJLANR5L15BTA0458 | |
| 15060000165512 | L15/dossiers | 15 | 15060000165458 | 15060000165510 | 2 | 2 | TAP | PRJLANR5L15TAP0458 | |
| 15060000165522 | L15/dossiers | 15 | 15060000165458 | 15060000165521 | 1 | 2 | BTA | PRJLSNR5S339BTA0117 | |
| 15060000165531 | L15/dossiers | 15 | 15060000165458 | 15060000165530 | 1 | 2 | BTA | PRJLANR5L15BTA0459 | |
| 15060000165532 | L15/dossiers | 15 | 15060000165458 | 15060000165530 | 2 | 2 | TAP | PRJLANR5L15TAP0459 | |
| 15060000165594 | L15/dossiers | 15 | 15060000165587 | 15060000165593 | 1 | 2 | BTA | PNREANR5L15BTA0453 | |
| 15060000165636 | L15/dossiers | 15 | 15060000165616 | 15060000165635 | 1 | 2 | BTA | PIONANR5L15BTA0476 | |
| 15060000165637 | L15/dossiers | 15 | 15060000165616 | 15060000165635 | 2 | 2 | TAP | PIONANR5L15TAP0476 | |
| 15060000165648 | L15/dossiers | 15 | 15060000165616 | 15060000165647 | 1 | 2 | BTA | PIONSNR5S359BTA0001 | |
| 15060000165662 | L15/dossiers | 15 | 15060000165616 | 15060000165661 | 1 | 2 | BTA | PIONSNR5S359BTA0018 | |
| 15060000165667 | L15/dossiers | 15 | 15060000165616 | 15060000165666 | 1 | 2 | BTA | PIONANR5L15BTA0516 | |
| 15060000165668 | L15/dossiers | 15 | 15060000165616 | 15060000165666 | 2 | 2 | TAP | PIONANR5L15TAP0516 | |
| 15060000165679 | L15/dossiers | 15 | 15060000165672 | 15060000165678 | 1 | 2 | BTA | RIONANR5L15BTA0449 | |
| 15060000165781 | L15/dossiers | 15 | 15060000165755 | 15060000165780 | 1 | 2 | BTA | PRJLANR5L15BTA0467 | |
| 15060000165782 | L15/dossiers | 15 | 15060000165755 | 15060000165780 | 2 | 2 | TAP | PRJLANR5L15TAP0467 |