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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000173137 | L15/dossiers | 15 | 15060000173107 | 15060000173136 | 1 | 2 | BTA | PIONANR5L15BTA0675 | |
| 15060000173138 | L15/dossiers | 15 | 15060000173107 | 15060000173136 | 2 | 2 | TAP | PIONANR5L15TAP0675 | |
| 15060000173147 | L15/dossiers | 15 | 15060000173107 | 15060000173146 | 1 | 2 | BTA | PIONSNR5S379BTA0057 | |
| 15060000173164 | L15/dossiers | 15 | 15060000173150 | 15060000173163 | 1 | 2 | BTA | PRJLSNR5S359BTA0048 | |
| 15060000173177 | L15/dossiers | 15 | 15060000173150 | 15060000173176 | 1 | 2 | BTA | PRJLANR5L15BTA0564 | |
| 15060000173178 | L15/dossiers | 15 | 15060000173150 | 15060000173176 | 2 | 2 | TAP | PRJLANR5L15TAP0564 | |
| 15060000173192 | L15/dossiers | 15 | 15060000173150 | 15060000173191 | 1 | 2 | BTA | PRJLSNR5S359BTA0061 | |
| 15060000173197 | L15/dossiers | 15 | 15060000173150 | 15060000173196 | 1 | 2 | BTA | PRJLANR5L15BTA0567 | |
| 15060000173198 | L15/dossiers | 15 | 15060000173150 | 15060000173196 | 2 | 2 | TAP | PRJLANR5L15TAP0567 | |
| 15060000173245 | L15/dossiers | 15 | 15060000173221 | 15060000173244 | 1 | 2 | BTA | PIONANR5L15BTA0570 | |
| 15060000173246 | L15/dossiers | 15 | 15060000173221 | 15060000173244 | 2 | 2 | TAP | PIONANR5L15TAP0570 | |
| 15060000173259 | L15/dossiers | 15 | 15060000173221 | 15060000173258 | 1 | 2 | BTA | PIONSNR5S359BTA0134 | |
| 15060000173275 | L15/dossiers | 15 | 15060000173221 | 15060000173274 | 1 | 2 | BTA | PIONSNR5S359BTA0142 | |
| 15060000173279 | L15/dossiers | 15 | 15060000173221 | 15060000173278 | 1 | 2 | BTA | PIONANR5L15BTA0657 | |
| 15060000173280 | L15/dossiers | 15 | 15060000173221 | 15060000173278 | 2 | 2 | TAP | PIONANR5L15TAP0657 | |
| 15060000173318 | L15/dossiers | 15 | 15060000173302 | 15060000173317 | 1 | 2 | BTA | PIONANR5L15BTA0572 | |
| 15060000173533 | L15/dossiers | 15 | 15060000173513 | 15060000173532 | 1 | 2 | BTA | PRJLANR5L15BTA0542 | |
| 15060000173534 | L15/dossiers | 15 | 15060000173513 | 15060000173532 | 2 | 2 | TAP | PRJLANR5L15TAP0542 | |
| 15060000173546 | L15/dossiers | 15 | 15060000173513 | 15060000173545 | 1 | 2 | BTA | PRJLSNR5S359BTA0049 | |
| 15060000173568 | L15/dossiers | 15 | 15060000173513 | 15060000173567 | 1 | 2 | BTA | PRJLANR5L15BTA0559 | |
| 15060000173569 | L15/dossiers | 15 | 15060000173513 | 15060000173567 | 2 | 2 | TAP | PRJLANR5L15TAP0559 | |
| 15060000173579 | L15/dossiers | 15 | 15060000173513 | 15060000173578 | 1 | 2 | BTA | PRJLSNR5S359BTA0056 | |
| 15060000173589 | L15/dossiers | 15 | 15060000173513 | 15060000173588 | 1 | 2 | BTA | PRJLANR5L15BTA0563 | |
| 15060000173590 | L15/dossiers | 15 | 15060000173513 | 15060000173588 | 2 | 2 | TAP | PRJLANR5L15TAP0563 | |
| 15060000173625 | L15/dossiers | 15 | 15060000173600 | 15060000173624 | 1 | 2 | BTA | PRJLANR5L15BTA0549 | |
| 15060000173637 | L15/dossiers | 15 | 15060000173600 | 15060000173636 | 1 | 2 | BTA | PRJLSNR5S359BTA0054 | |
| 15060000173754 | L15/dossiers | 15 | 15060000173741 | 15060000173753 | 1 | 2 | BTA | PRJLSNR5S359BTA0063 | |
| 15060000173768 | L15/dossiers | 15 | 15060000173741 | 15060000173767 | 1 | 2 | BTA | PRJLANR5L15BTA0617 | |
| 15060000173921 | L15/dossiers | 15 | 15060000173890 | 15060000173920 | 1 | 2 | BTA | PRJLANR5L15BTA0577 | |
| 15060000173932 | L15/dossiers | 15 | 15060000173890 | 15060000173931 | 1 | 2 | BTA | PRJLSNR5S359BTA0105 | |
| 15060000173945 | L15/dossiers | 15 | 15060000173890 | 15060000173944 | 1 | 2 | BTA | PRJLANR5L15BTA0634 | |
| 15060000173946 | L15/dossiers | 15 | 15060000173890 | 15060000173944 | 2 | 2 | TAP | PRJLANR5L15TAP0634 | |
| 15060000173955 | L15/dossiers | 15 | 15060000173890 | 15060000173954 | 1 | 2 | BTA | PRJLSNR5S359BTA0133 | |
| 15060000173998 | L15/dossiers | 15 | 15060000173991 | 15060000173997 | 1 | 2 | BTA | RIONANR5L15BTA0568 | |
| 15060000174031 | L15/dossiers | 15 | 15060000174013 | 15060000174030 | 1 | 2 | BTA | PIONANR5L15BTA0581 | |
| 15060000174042 | L15/dossiers | 15 | 15060000174013 | 15060000174041 | 1 | 2 | BTA | PIONSNR5S359BTA0116 | |
| 15060000174075 | L15/dossiers | 15 | 15060000174048 | 15060000174074 | 1 | 2 | BTA | PIONANR5L15BTA0584 | |
| 15060000174076 | L15/dossiers | 15 | 15060000174048 | 15060000174074 | 2 | 2 | TAP | PIONANR5L15TAP0584 | |
| 15060000174088 | L15/dossiers | 15 | 15060000174048 | 15060000174087 | 1 | 2 | BTA | PIONSNR5S379BTA0075 | |
| 15060000174111 | L15/dossiers | 15 | 15060000174048 | 15060000174110 | 1 | 2 | BTA | PIONANR5L15BTA0797 | |
| 15060000174112 | L15/dossiers | 15 | 15060000174048 | 15060000174110 | 2 | 2 | TAP | PIONANR5L15TAP0797 | |
| 15060000174122 | L15/dossiers | 15 | 15060000174048 | 15060000174121 | 1 | 2 | BTA | PIONSNR5S379BTA0103 | |
| 15060000174131 | L15/dossiers | 15 | 15060000174048 | 15060000174130 | 1 | 2 | BTA | PIONANR5L15BTA0816 | |
| 15060000174132 | L15/dossiers | 15 | 15060000174048 | 15060000174130 | 2 | 2 | TAP | PIONANR5L15TAP0816 | |
| 15060000174168 | L15/dossiers | 15 | 15060000174153 | 15060000174167 | 1 | 2 | BTA | RIONANR5L15BTA0573 | |
| 15060000174169 | L15/dossiers | 15 | 15060000174153 | 15060000174167 | 2 | 2 | TAP | RIONANR5L15TAP0573 | |
| 15060000174411 | L15/dossiers | 15 | 15060000174397 | 15060000174410 | 1 | 2 | BTA | PIONSNR5S359BTA0122 | |
| 15060000174427 | L15/dossiers | 15 | 15060000174397 | 15060000174426 | 1 | 2 | BTA | PIONANR5L15BTA0674 | |
| 15060000174428 | L15/dossiers | 15 | 15060000174397 | 15060000174426 | 2 | 2 | TAP | PIONANR5L15TAP0674 | |
| 15060000174437 | L15/dossiers | 15 | 15060000174397 | 15060000174436 | 1 | 2 | BTA | PIONSNR5S379BTA0058 |