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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000180433 | L15/dossiers | 15 | 15060000180402 | 15060000180432 | 1 | 2 | BTA | PRJLSNR5S379BTA0033 | |
| 15060000180446 | L15/dossiers | 15 | 15060000180402 | 15060000180445 | 1 | 2 | BTA | PRJLSNR5S379BTA0082 | |
| 15060000180450 | L15/dossiers | 15 | 15060000180402 | 15060000180449 | 1 | 2 | BTA | PRJLANR5L15BTA0766 | |
| 15060000180451 | L15/dossiers | 15 | 15060000180402 | 15060000180449 | 2 | 2 | TAP | PRJLANR5L15TAP0766 | |
| 15060000180518 | L15/dossiers | 15 | 15060000180501 | 15060000180517 | 1 | 2 | BTA | PIONANR5L15BTA0693 | |
| 15060000180519 | L15/dossiers | 15 | 15060000180501 | 15060000180517 | 2 | 2 | TAP | PIONANR5L15TAP0693 | |
| 15060000180530 | L15/dossiers | 15 | 15060000180501 | 15060000180529 | 1 | 2 | BTA | PIONSNR5S379BTA0079 | |
| 15060000180546 | L15/dossiers | 15 | 15060000180501 | 15060000180545 | 1 | 2 | BTA | PIONANR5L15BTA0794 | |
| 15060000180547 | L15/dossiers | 15 | 15060000180501 | 15060000180545 | 2 | 2 | TAP | PIONANR5L15TAP0794 | |
| 15060000180551 | L15/dossiers | 15 | 15060000180501 | 15060000180550 | 1 | 2 | BTA | RAPPSNR5S379BTA0102 | |
| 15060000180590 | L15/dossiers | 15 | 15060000180573 | 15060000180589 | 1 | 2 | BTA | PIONANR5L15BTA0692 | |
| 15060000180591 | L15/dossiers | 15 | 15060000180573 | 15060000180589 | 2 | 2 | TAP | PIONANR5L15TAP0692 | |
| 15060000180602 | L15/dossiers | 15 | 15060000180573 | 15060000180601 | 1 | 2 | BTA | PIONSNR5S379BTA0078 | |
| 15060000180617 | L15/dossiers | 15 | 15060000180573 | 15060000180616 | 1 | 2 | BTA | PIONANR5L15BTA0793 | |
| 15060000180618 | L15/dossiers | 15 | 15060000180573 | 15060000180616 | 2 | 2 | TAP | PIONANR5L15TAP0793 | |
| 15060000180622 | L15/dossiers | 15 | 15060000180573 | 15060000180621 | 1 | 2 | BTA | PIONSNR5S379BTA0101 | |
| 15060000180666 | L15/dossiers | 15 | 15060000180641 | 15060000180665 | 1 | 2 | BTA | PRJLANR5L15BTA0654 | |
| 15060000180667 | L15/dossiers | 15 | 15060000180641 | 15060000180665 | 2 | 2 | TAP | PRJLANR5L15TAP0654 | |
| 15060000180678 | L15/dossiers | 15 | 15060000180641 | 15060000180677 | 1 | 2 | BTA | PRJLSNR5S359BTA0148 | |
| 15060000180691 | L15/dossiers | 15 | 15060000180641 | 15060000180690 | 1 | 2 | BTA | PRJLSNR5S359BTA0149 | |
| 15060000180694 | L15/dossiers | 15 | 15060000180641 | 15060000180693 | 1 | 2 | BTA | PRJLANR5L15BTA0660 | |
| 15060000180695 | L15/dossiers | 15 | 15060000180641 | 15060000180693 | 2 | 2 | TAP | PRJLANR5L15TAP0660 | |
| 15060000180735 | L15/dossiers | 15 | 15060000180705 | 15060000180734 | 1 | 2 | BTA | PRJLANR5L15BTA0663 | |
| 15060000180736 | L15/dossiers | 15 | 15060000180705 | 15060000180734 | 2 | 2 | TAP | PRJLANR5L15TAP0663 | |
| 15060000180748 | L15/dossiers | 15 | 15060000180705 | 15060000180747 | 1 | 2 | BTA | PRJLSNR5S379BTA0009 | |
| 15060000180764 | L15/dossiers | 15 | 15060000180705 | 15060000180763 | 1 | 2 | BTA | PRJLANR5L15BTA0731 | |
| 15060000180765 | L15/dossiers | 15 | 15060000180705 | 15060000180763 | 2 | 2 | TAP | PRJLANR5L15TAP0731 | |
| 15060000180768 | L15/dossiers | 15 | 15060000180705 | 15060000180767 | 1 | 2 | BTA | PRJLSNR5S379BTA0061 | |
| 15060000180947 | L15/dossiers | 15 | 15060000180892 | 15060000180946 | 1 | 2 | BTA | PIONSNR5S379BTA0027 | |
| 15060000181031 | L15/dossiers | 15 | 15060000181018 | 15060000181030 | 1 | 2 | BTA | PIONSNR5S379BTA0005 | |
| 15060000181047 | L15/dossiers | 15 | 15060000181018 | 15060000181046 | 1 | 2 | BTA | PIONANR5L15BTA0711 | |
| 15060000181088 | L15/dossiers | 15 | 15060000181076 | 15060000181087 | 1 | 2 | BTA | PRJLSNR5S379BTA0020 | |
| 15060000181103 | L15/dossiers | 15 | 15060000181076 | 15060000181102 | 1 | 2 | BTA | PRJLANR5L15BTA0727 | |
| 15060000181260 | L15/dossiers | 15 | 15060000181244 | 15060000181259 | 1 | 2 | BTA | PIONANR5L15BTA0677 | |
| 15060000181285 | L15/dossiers | 15 | 15060000181268 | 15060000181284 | 1 | 2 | BTA | PRJLANR5L15BTA0804 | |
| 15060000181327 | L15/dossiers | 15 | 15060000181310 | 15060000181326 | 1 | 2 | BTA | PRJLANR5L15BTA0662 | |
| 15060000181328 | L15/dossiers | 15 | 15060000181310 | 15060000181326 | 2 | 2 | TAP | PRJLANR5L15TAP0662 | |
| 15060000181340 | L15/dossiers | 15 | 15060000181310 | 15060000181339 | 1 | 2 | BTA | PRJLSNR5S359BTA0150 | |
| 15060000181561 | L15/dossiers | 15 | 15060000181554 | 15060000181560 | 1 | 2 | BTA | RIONANR5L15BTA0681 | |
| 15060000181618 | L15/dossiers | 15 | 15060000181611 | 15060000181617 | 1 | 2 | BTA | RIONANR5L15BTA0678 | |
| 15060000181632 | L15/dossiers | 15 | 15060000181619 | 15060000181631 | 1 | 2 | BTA | PIONSNR5S379BTA0024 | |
| 15060000181648 | L15/dossiers | 15 | 15060000181619 | 15060000181647 | 1 | 2 | BTA | PIONANR5L15BTA0735 | |
| 15060000181649 | L15/dossiers | 15 | 15060000181619 | 15060000181647 | 2 | 2 | TAP | PIONANR5L15TAP0735 | |
| 15060000181756 | L15/dossiers | 15 | 15060000181739 | 15060000181755 | 1 | 2 | BTA | PIONANR5L15BTA0714 | |
| 15060000181757 | L15/dossiers | 15 | 15060000181739 | 15060000181755 | 2 | 2 | TAP | PIONANR5L15TAP0714 | |
| 15060000181830 | L15/dossiers | 15 | 15060000181817 | 15060000181829 | 1 | 2 | BTA | PRJLSNR5S379BTA0014 | |
| 15060000181846 | L15/dossiers | 15 | 15060000181817 | 15060000181845 | 1 | 2 | BTA | PRJLANR5L15BTA0740 | |
| 15060000181847 | L15/dossiers | 15 | 15060000181817 | 15060000181845 | 2 | 2 | TAP | PRJLANR5L15TAP0740 | |
| 15060000181861 | L15/dossiers | 15 | 15060000181817 | 15060000181860 | 1 | 2 | BTA | PRJLSNR5S379BTA0088 | |
| 15060000181866 | L15/dossiers | 15 | 15060000181817 | 15060000181865 | 1 | 2 | BTA | PRJLANR5L15BTA0792 |