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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000170477 | L15/dossiers | 15 | 15060000170406 | 15060000170476 | 1 | 2 | BTA | PIONSNR5S359BTA0090 | |
| 15060000170486 | L15/dossiers | 15 | 15060000170406 | 15060000170485 | 1 | 2 | BTA | PIONANR5L15BTA0592 | |
| 15060000170487 | L15/dossiers | 15 | 15060000170406 | 15060000170485 | 2 | 2 | TAP | PIONANR5L15TAP0592 | |
| 15060000170524 | L15/dossiers | 15 | 15060000170511 | 15060000170523 | 1 | 2 | BTA | PIONSNR5S359BTA0120 | |
| 15060000170539 | L15/dossiers | 15 | 15060000170511 | 15060000170538 | 1 | 2 | BTA | PIONANR5L15BTA0777 | |
| 15060000170540 | L15/dossiers | 15 | 15060000170511 | 15060000170538 | 2 | 2 | TAP | PIONANR5L15TAP0777 | |
| 15060000170551 | L15/dossiers | 15 | 15060000170543 | 15060000170550 | 1 | 2 | BTA | RIONANR5L15BTA0513 | |
| 15060000170559 | L15/dossiers | 15 | 15060000170552 | 15060000170558 | 1 | 2 | BTA | RIONANR5L15BTA0508 | |
| 15060000170567 | L15/dossiers | 15 | 15060000170560 | 15060000170566 | 1 | 2 | BTA | RIONANR5L15BTA0512 | |
| 15060000170589 | L15/dossiers | 15 | 15060000170575 | 15060000170588 | 1 | 2 | BTA | PIONANR5L15BTA0603 | |
| 15060000170668 | L15/dossiers | 15 | 15060000170656 | 15060000170667 | 1 | 2 | BTA | PIONSNR5S379BTA0029 | |
| 15060000170728 | L15/dossiers | 15 | 15060000170712 | 15060000170727 | 1 | 2 | BTA | PIONSNR5S359BTA0043 | |
| 15060000170766 | L15/dossiers | 15 | 15060000170749 | 15060000170765 | 1 | 2 | BTA | PRJLANR5L15BTA0621 | |
| 15060000170777 | L15/dossiers | 15 | 15060000170749 | 15060000170776 | 1 | 2 | BTA | PRJLSNR5S379BTA0017 | |
| 15060000170801 | L15/dossiers | 15 | 15060000170786 | 15060000170800 | 1 | 2 | BTA | RIONANR5L15BTA0507 | |
| 15060000170994 | L15/dossiers | 15 | 15060000170976 | 15060000170993 | 1 | 2 | BTA | PRJLANR5L15BTA0497 | |
| 15060000170995 | L15/dossiers | 15 | 15060000170976 | 15060000170993 | 2 | 2 | TAP | PRJLANR5L15TAP0497 | |
| 15060000171006 | L15/dossiers | 15 | 15060000170976 | 15060000171005 | 1 | 2 | BTA | PRJLSNR5S359BTA0021 | |
| 15060000171021 | L15/dossiers | 15 | 15060000170976 | 15060000171020 | 1 | 2 | BTA | PRJLANR5L15BTA0503 | |
| 15060000171022 | L15/dossiers | 15 | 15060000170976 | 15060000171020 | 2 | 2 | TAP | PRJLANR5L15TAP0503 | |
| 15060000171026 | L15/dossiers | 15 | 15060000170976 | 15060000171025 | 1 | 2 | BTA | PRJLSNR5S359BTA0025 | |
| 15060000171119 | L15/dossiers | 15 | 15060000171111 | 15060000171118 | 1 | 2 | BTA | RIONANR5L15BTA0520 | |
| 15060000171127 | L15/dossiers | 15 | 15060000171120 | 15060000171126 | 1 | 2 | BTA | RIONANR5L15BTA0518 | |
| 15060000171446 | L15/dossiers | 15 | 15060000171426 | 15060000171445 | 1 | 2 | BTA | PRJLANR5L15BTA0523 | |
| 15060000171447 | L15/dossiers | 15 | 15060000171426 | 15060000171445 | 2 | 2 | TAP | PRJLANR5L15TAP0523 | |
| 15060000171456 | L15/dossiers | 15 | 15060000171426 | 15060000171455 | 1 | 2 | BTA | PRJLSNR5S359BTA0030 | |
| 15060000171469 | L15/dossiers | 15 | 15060000171426 | 15060000171468 | 1 | 2 | BTA | PRJLSNR5S359BTA0033 | |
| 15060000171472 | L15/dossiers | 15 | 15060000171426 | 15060000171471 | 1 | 2 | BTA | PRJLANR5L15BTA0532 | |
| 15060000171473 | L15/dossiers | 15 | 15060000171426 | 15060000171471 | 2 | 2 | TAP | PRJLANR5L15TAP0532 | |
| 15060000171500 | L15/dossiers | 15 | 15060000171480 | 15060000171499 | 1 | 2 | BTA | PRJLANR5L15BTA0524 | |
| 15060000171501 | L15/dossiers | 15 | 15060000171480 | 15060000171499 | 2 | 2 | TAP | PRJLANR5L15TAP0524 | |
| 15060000171510 | L15/dossiers | 15 | 15060000171480 | 15060000171509 | 1 | 2 | BTA | PRJLSNR5S359BTA0031 | |
| 15060000171524 | L15/dossiers | 15 | 15060000171480 | 15060000171523 | 1 | 2 | BTA | RAPPSNR5S359BTA0034 | |
| 15060000171527 | L15/dossiers | 15 | 15060000171480 | 15060000171526 | 1 | 2 | BTA | PRJLANR5L15BTA0533 | |
| 15060000171528 | L15/dossiers | 15 | 15060000171480 | 15060000171526 | 2 | 2 | TAP | PRJLANR5L15TAP0533 | |
| 15060000171559 | L15/dossiers | 15 | 15060000171542 | 15060000171558 | 1 | 2 | BTA | PRJLANR5L15BTA0670 | |
| 15060000171585 | L15/dossiers | 15 | 15060000171565 | 15060000171584 | 1 | 2 | BTA | PRJLANR5L15BTA0595 | |
| 15060000171596 | L15/dossiers | 15 | 15060000171565 | 15060000171595 | 1 | 2 | BTA | PRJLSNR5S359BTA0126 | |
| 15060000171703 | L15/dossiers | 15 | 15060000171691 | 15060000171702 | 1 | 2 | BTA | PIONSNR5S359BTA0046 | |
| 15060000171717 | L15/dossiers | 15 | 15060000171691 | 15060000171716 | 1 | 2 | BTA | PIONANR5L15BTA0576 | |
| 15060000171718 | L15/dossiers | 15 | 15060000171691 | 15060000171716 | 2 | 2 | TAP | PIONANR5L15TAP0576 | |
| 15060000171727 | L15/dossiers | 15 | 15060000171691 | 15060000171726 | 1 | 2 | BTA | PIONSNR5S359BTA0085 | |
| 15060000171740 | L15/dossiers | 15 | 15060000171691 | 15060000171739 | 1 | 2 | BTA | PIONANR5L15BTA0601 | |
| 15060000171741 | L15/dossiers | 15 | 15060000171691 | 15060000171739 | 2 | 2 | TAP | PIONANR5L15TAP0601 | |
| 15060000171905 | L15/dossiers | 15 | 15060000171893 | 15060000171904 | 1 | 2 | BTA | PIONSNR5S359BTA0077 | |
| 15060000171939 | L15/dossiers | 15 | 15060000171929 | 15060000171938 | 1 | 2 | BTA | RIONANR5L15BTA0561 | |
| 15060000171952 | L15/dossiers | 15 | 15060000171940 | 15060000171951 | 1 | 2 | BTA | PIONSNR5S359BTA0078 | |
| 15060000172021 | L15/dossiers | 15 | 15060000172014 | 15060000172020 | 1 | 2 | BTA | RIONANR5L15BTA0586 | |
| 15060000172045 | L15/dossiers | 15 | 15060000172033 | 15060000172044 | 1 | 2 | BTA | PIONSNR5S359BTA0124 | |
| 15060000172061 | L15/dossiers | 15 | 15060000172033 | 15060000172060 | 1 | 2 | BTA | PIONANR5L15BTA0709 |