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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000176086 | L15/dossiers | 15 | 15060000176036 | 15060000176085 | 1 | 2 | BTA | PIONSNR5S379BTA0043 | |
| 15060000176108 | L15/dossiers | 15 | 15060000176090 | 15060000176107 | 1 | 2 | BTA | PIONANR5L15BTA0673 | |
| 15060000176109 | L15/dossiers | 15 | 15060000176090 | 15060000176107 | 2 | 2 | TAP | PIONANR5L15TAP0673 | |
| 15060000176121 | L15/dossiers | 15 | 15060000176090 | 15060000176120 | 1 | 2 | BTA | PIONSNR5S379BTA0049 | |
| 15060000176135 | L15/dossiers | 15 | 15060000176090 | 15060000176134 | 1 | 2 | BTA | PIONSNR5S379BTA0077 | |
| 15060000176139 | L15/dossiers | 15 | 15060000176090 | 15060000176138 | 1 | 2 | BTA | PIONANR5L15BTA0763 | |
| 15060000176140 | L15/dossiers | 15 | 15060000176090 | 15060000176138 | 2 | 2 | TAP | PIONANR5L15TAP0763 | |
| 15060000176160 | L15/dossiers | 15 | 15060000176144 | 15060000176159 | 1 | 2 | BTA | PIONANR5L15BTA0607 | |
| 15060000176220 | L15/dossiers | 15 | 15060000176207 | 15060000176219 | 1 | 2 | BTA | PIONSNR5S359BTA0114 | |
| 15060000176303 | L15/dossiers | 15 | 15060000176291 | 15060000176302 | 1 | 2 | BTA | PRJLSNR5S359BTA0125 | |
| 15060000176317 | L15/dossiers | 15 | 15060000176291 | 15060000176316 | 1 | 2 | BTA | PRJLANR5L15BTA0728 | |
| 15060000176369 | L15/dossiers | 15 | 15060000176350 | 15060000176368 | 1 | 2 | BTA | PIONSNR5S359BTA0115 | |
| 15060000176601 | L15/dossiers | 15 | 15060000176588 | 15060000176600 | 1 | 2 | BTA | PRJLSNR5S359BTA0111 | |
| 15060000176620 | L15/dossiers | 15 | 15060000176588 | 15060000176619 | 1 | 2 | BTA | PRJLANR5L15BTA0635 | |
| 15060000176621 | L15/dossiers | 15 | 15060000176588 | 15060000176619 | 2 | 2 | TAP | PRJLANR5L15TAP0635 | |
| 15060000176634 | L15/dossiers | 15 | 15060000176588 | 15060000176633 | 1 | 2 | BTA | PRJLSNR5S359BTA0152 | |
| 15060000176638 | L15/dossiers | 15 | 15060000176588 | 15060000176637 | 1 | 2 | BTA | PRJLANR5L15BTA0666 | |
| 15060000176639 | L15/dossiers | 15 | 15060000176588 | 15060000176637 | 2 | 2 | TAP | PRJLANR5L15TAP0666 | |
| 15060000176659 | L15/dossiers | 15 | 15060000176646 | 15060000176658 | 1 | 2 | BTA | PRJLSNR5S359BTA0112 | |
| 15060000176683 | L15/dossiers | 15 | 15060000176646 | 15060000176682 | 1 | 2 | BTA | PRJLANR5L15BTA0636 | |
| 15060000176684 | L15/dossiers | 15 | 15060000176646 | 15060000176682 | 2 | 2 | TAP | PRJLANR5L15TAP0636 | |
| 15060000176697 | L15/dossiers | 15 | 15060000176646 | 15060000176696 | 1 | 2 | BTA | PRJLSNR5S359BTA0153 | |
| 15060000176701 | L15/dossiers | 15 | 15060000176646 | 15060000176700 | 1 | 2 | BTA | PRJLANR5L15BTA0667 | |
| 15060000176702 | L15/dossiers | 15 | 15060000176646 | 15060000176700 | 2 | 2 | TAP | PRJLANR5L15TAP0667 | |
| 15060000176753 | L15/dossiers | 15 | 15060000176734 | 15060000176752 | 1 | 2 | BTA | RIONANR5L15BTA0697 | |
| 15060000176795 | L15/dossiers | 15 | 15060000176782 | 15060000176794 | 1 | 2 | BTA | PIONSNR5S379BTA0051 | |
| 15060000176900 | L15/dossiers | 15 | 15060000176832 | 15060000176899 | 1 | 2 | BTA | PRJLANR5L15BTA0628 | |
| 15060000176901 | L15/dossiers | 15 | 15060000176832 | 15060000176899 | 2 | 2 | TAP | PRJLANR5L15TAP0628 | |
| 15060000176960 | L15/dossiers | 15 | 15060000176832 | 15060000176959 | 1 | 2 | BTA | PRJLSNR5S359BTA0139 | |
| 15060000176980 | L15/dossiers | 15 | 15060000176832 | 15060000176979 | 1 | 2 | BTA | PRJLANR5L15BTA0652 | |
| 15060000176981 | L15/dossiers | 15 | 15060000176832 | 15060000176979 | 2 | 2 | TAP | PRJLANR5L15TAP0652 | |
| 15060000176991 | L15/dossiers | 15 | 15060000176832 | 15060000176990 | 1 | 2 | BTA | PRJLSNR5S359BTA0145 | |
| 15060000177001 | L15/dossiers | 15 | 15060000176832 | 15060000177000 | 1 | 2 | BTA | PRJLANR5L15BTA0655 | |
| 15060000177002 | L15/dossiers | 15 | 15060000176832 | 15060000177000 | 2 | 2 | TAP | PRJLANR5L15TAP0655 | |
| 15060000177038 | L15/dossiers | 15 | 15060000177005 | 15060000177037 | 1 | 2 | BTA | PRJLANR5L15BTA0612 | |
| 15060000177039 | L15/dossiers | 15 | 15060000177005 | 15060000177037 | 2 | 2 | TAP | PRJLANR5L15TAP0612 | |
| 15060000177051 | L15/dossiers | 15 | 15060000177005 | 15060000177050 | 1 | 2 | BTA | PRJLSNR5S359BTA0161 | |
| 15060000177067 | L15/dossiers | 15 | 15060000177005 | 15060000177066 | 1 | 2 | BTA | PRJLANR5L15BTA0690 | |
| 15060000177068 | L15/dossiers | 15 | 15060000177005 | 15060000177066 | 2 | 2 | TAP | PRJLANR5L15TAP0690 | |
| 15060000177072 | L15/dossiers | 15 | 15060000177005 | 15060000177071 | 1 | 2 | BTA | PRJLSNR5S379BTA0038 | |
| 15060000177112 | L15/dossiers | 15 | 15060000177079 | 15060000177111 | 1 | 2 | BTA | PRJLANR5L15BTA0613 | |
| 15060000177113 | L15/dossiers | 15 | 15060000177079 | 15060000177111 | 2 | 2 | TAP | PRJLANR5L15TAP0613 | |
| 15060000177125 | L15/dossiers | 15 | 15060000177079 | 15060000177124 | 1 | 2 | BTA | PRJLSNR5S359BTA0162 | |
| 15060000177141 | L15/dossiers | 15 | 15060000177079 | 15060000177140 | 1 | 2 | BTA | PRJLANR5L15BTA0691 | |
| 15060000177142 | L15/dossiers | 15 | 15060000177079 | 15060000177140 | 2 | 2 | TAP | PRJLANR5L15TAP0691 | |
| 15060000177146 | L15/dossiers | 15 | 15060000177079 | 15060000177145 | 1 | 2 | BTA | RAPPSNR5S379BTA0039 | |
| 15060000177166 | L15/dossiers | 15 | 15060000177153 | 15060000177165 | 1 | 2 | BTA | PRJLSNR5S359BTA0108 | |
| 15060000177186 | L15/dossiers | 15 | 15060000177153 | 15060000177185 | 1 | 2 | BTA | PRJLANR5L15BTA0642 | |
| 15060000177187 | L15/dossiers | 15 | 15060000177153 | 15060000177185 | 2 | 2 | TAP | PRJLANR5L15TAP0642 | |
| 15060000177201 | L15/dossiers | 15 | 15060000177153 | 15060000177200 | 1 | 2 | BTA | PRJLSNR5S359BTA0154 |