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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000155396 | L15/dossiers | 15 | 15060000155361 | 15060000155394 | 2 | 2 | TAP | PIONANR5L15TAP0585 | |
| 15060000155406 | L15/dossiers | 15 | 15060000155361 | 15060000155405 | 1 | 2 | BTA | PIONSNR5S359BTA0113 | |
| 15060000156872 | L15/dossiers | 15 | 15060000156859 | 15060000156871 | 1 | 2 | BTA | PIONSNR5S339BTA0047 | |
| 15060000157660 | L15/dossiers | 15 | 15060000157649 | 15060000157659 | 1 | 2 | BTA | PIONSNR5S359BTA0097 | |
| 15060000158331 | L15/dossiers | 15 | 15060000158319 | 15060000158330 | 1 | 2 | BTA | PIONSNR5S339BTA0059 | |
| 15060000158450 | L15/dossiers | 15 | 15060000158435 | 15060000158449 | 1 | 2 | BTA | PIONSNR5S339BTA0045 | |
| 15060000158599 | L15/dossiers | 15 | 15060000158578 | 15060000158598 | 1 | 2 | BTA | PRJLANR5L15BTA0596 | |
| 15060000158610 | L15/dossiers | 15 | 15060000158578 | 15060000158609 | 1 | 2 | BTA | PRJLSNR5S359BTA0127 | |
| 15060000158640 | L15/dossiers | 15 | 15060000158623 | 15060000158639 | 1 | 2 | BTA | PIONANR5L15BTA0510 | |
| 15060000158641 | L15/dossiers | 15 | 15060000158623 | 15060000158639 | 2 | 2 | TAP | PIONANR5L15TAP0510 | |
| 15060000158666 | L15/dossiers | 15 | 15060000158654 | 15060000158665 | 1 | 2 | BTA | PIONSNR5S339BTA0048 | |
| 15060000158728 | L15/dossiers | 15 | 15060000158707 | 15060000158727 | 1 | 2 | BTA | PIONANR5L15BTA0390 | |
| 15060000158729 | L15/dossiers | 15 | 15060000158707 | 15060000158727 | 2 | 2 | TAP | PIONANR5L15TAP0390 | |
| 15060000158740 | L15/dossiers | 15 | 15060000158707 | 15060000158739 | 1 | 2 | BTA | PIONSNR5S339BTA0097 | |
| 15060000158753 | L15/dossiers | 15 | 15060000158707 | 15060000158752 | 1 | 2 | BTA | PIONANR5L15BTA0466 | |
| 15060000158754 | L15/dossiers | 15 | 15060000158707 | 15060000158752 | 2 | 2 | TAP | PIONANR5L15TAP0466 | |
| 15060000158758 | L15/dossiers | 15 | 15060000158707 | 15060000158757 | 1 | 2 | BTA | PIONSNR5S339BTA0124 | |
| 15060000158833 | L15/dossiers | 15 | 15060000158820 | 15060000158832 | 1 | 2 | BTA | PIONSNR5S339BTA0056 | |
| 15060000158891 | L15/dossiers | 15 | 15060000158872 | 15060000158890 | 1 | 2 | BTA | PRJLANR5L15BTA0546 | |
| 15060000158902 | L15/dossiers | 15 | 15060000158872 | 15060000158901 | 1 | 2 | BTA | PRJLSNR5S359BTA0081 | |
| 15060000159014 | L15/dossiers | 15 | 15060000158971 | 15060000159013 | 1 | 2 | BTA | PIONSNR5S339BTA0087 | |
| 15060000159045 | L15/dossiers | 15 | 15060000159020 | 15060000159044 | 1 | 2 | BTA | PIONSNR5S339BTA0046 | |
| 15060000159114 | L15/dossiers | 15 | 15060000159101 | 15060000159113 | 1 | 2 | BTA | PIONSNR5S339BTA0058 | |
| 15060000159152 | L15/dossiers | 15 | 15060000159134 | 15060000159151 | 1 | 2 | BTA | PRJLANR5L15BTA0531 | |
| 15060000159164 | L15/dossiers | 15 | 15060000159134 | 15060000159163 | 1 | 2 | BTA | PRJLSNR5S359BTA0051 | |
| 15060000159186 | L15/dossiers | 15 | 15060000159170 | 15060000159185 | 1 | 2 | BTA | PIONANR5L15BTA0395 | |
| 15060000159232 | L15/dossiers | 15 | 15060000159219 | 15060000159231 | 1 | 2 | BTA | PRJLSNR5S339BTA0070 | |
| 15060000159247 | L15/dossiers | 15 | 15060000159219 | 15060000159246 | 1 | 2 | BTA | PRJLANR5L15BTA0597 | |
| 15060000159287 | L15/dossiers | 15 | 15060000159271 | 15060000159286 | 1 | 2 | BTA | PIONANR5L15BTA0398 | |
| 15060000159332 | L15/dossiers | 15 | 15060000159316 | 15060000159331 | 1 | 2 | BTA | PIONANR5L15BTA0403 | |
| 15060000159333 | L15/dossiers | 15 | 15060000159316 | 15060000159331 | 2 | 2 | TAP | PIONANR5L15TAP0403 | |
| 15060000159341 | L15/dossiers | 15 | 15060000159316 | 15060000159340 | 1 | 2 | BTA | PIONSNR5S339BTA0110 | |
| 15060000159354 | L15/dossiers | 15 | 15060000159316 | 15060000159353 | 1 | 2 | BTA | PIONANR5L15BTA0485 | |
| 15060000159355 | L15/dossiers | 15 | 15060000159316 | 15060000159353 | 2 | 2 | TAP | PIONANR5L15TAP0485 | |
| 15060000159515 | L15/dossiers | 15 | 15060000159502 | 15060000159514 | 1 | 2 | BTA | PIONSNR5S359BTA0057 | |
| 15060000159536 | L15/dossiers | 15 | 15060000159521 | 15060000159535 | 1 | 2 | BTA | PIONANR5L15BTA0404 | |
| 15060000159537 | L15/dossiers | 15 | 15060000159521 | 15060000159535 | 2 | 2 | TAP | PIONANR5L15TAP0404 | |
| 15060000159549 | L15/dossiers | 15 | 15060000159521 | 15060000159548 | 1 | 2 | BTA | PIONSNR5S379BTA0006 | |
| 15060000159569 | L15/dossiers | 15 | 15060000159552 | 15060000159568 | 1 | 2 | BTA | PIONANR5L15BTA0408 | |
| 15060000159570 | L15/dossiers | 15 | 15060000159552 | 15060000159568 | 2 | 2 | TAP | PIONANR5L15TAP0408 | |
| 15060000159581 | L15/dossiers | 15 | 15060000159552 | 15060000159580 | 1 | 2 | BTA | PIONSNR5S359BTA0032 | |
| 15060000159594 | L15/dossiers | 15 | 15060000159552 | 15060000159593 | 1 | 2 | BTA | PIONANR5L15BTA0591 | |
| 15060000159595 | L15/dossiers | 15 | 15060000159552 | 15060000159593 | 2 | 2 | TAP | PIONANR5L15TAP0591 | |
| 15060000159617 | L15/dossiers | 15 | 15060000159601 | 15060000159616 | 1 | 2 | BTA | PIONANR5L15BTA0405 | |
| 15060000159634 | L15/dossiers | 15 | 15060000159618 | 15060000159633 | 1 | 2 | BTA | PIONANR5L15BTA0406 | |
| 15060000159635 | L15/dossiers | 15 | 15060000159618 | 15060000159633 | 2 | 2 | TAP | PIONANR5L15TAP0406 | |
| 15060000159646 | L15/dossiers | 15 | 15060000159618 | 15060000159645 | 1 | 2 | BTA | PIONSNR5S359BTA0074 | |
| 15060000159661 | L15/dossiers | 15 | 15060000159618 | 15060000159660 | 1 | 2 | BTA | PIONANR5L15BTA0629 | |
| 15060000159662 | L15/dossiers | 15 | 15060000159618 | 15060000159660 | 2 | 2 | TAP | PIONANR5L15TAP0629 | |
| 15060000159672 | L15/dossiers | 15 | 15060000159618 | 15060000159671 | 1 | 2 | BTA | PIONSNR5S379BTA0003 |