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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000161504 | L15/dossiers | 15 | 15060000161484 | 15060000161502 | 2 | 2 | TAP | PRJLANR5L15TAP0527 | |
| 15060000161516 | L15/dossiers | 15 | 15060000161484 | 15060000161515 | 1 | 2 | BTA | PRJLSNR5S359BTA0058 | |
| 15060000161540 | L15/dossiers | 15 | 15060000161527 | 15060000161539 | 1 | 2 | BTA | PRJLSNR5S339BTA0127 | |
| 15060000161561 | L15/dossiers | 15 | 15060000161527 | 15060000161560 | 1 | 2 | BTA | PRJLANR5L15BTA0598 | |
| 15060000161588 | L15/dossiers | 15 | 15060000161571 | 15060000161587 | 1 | 2 | BTA | PIONSNR5S339BTA0090 | |
| 15060000161839 | L15/dossiers | 15 | 15060000161821 | 15060000161838 | 1 | 2 | BTA | PIONANR5L15BTA0451 | |
| 15060000161840 | L15/dossiers | 15 | 15060000161821 | 15060000161838 | 2 | 2 | TAP | PIONANR5L15TAP0451 | |
| 15060000161852 | L15/dossiers | 15 | 15060000161821 | 15060000161851 | 1 | 2 | BTA | PIONSNR5S339BTA0125 | |
| 15060000161865 | L15/dossiers | 15 | 15060000161821 | 15060000161864 | 1 | 2 | BTA | PIONSNR5S339BTA0134 | |
| 15060000161868 | L15/dossiers | 15 | 15060000161821 | 15060000161867 | 1 | 2 | BTA | PIONANR5L15BTA0472 | |
| 15060000161869 | L15/dossiers | 15 | 15060000161821 | 15060000161867 | 2 | 2 | TAP | PIONANR5L15TAP0472 | |
| 15060000161923 | L15/dossiers | 15 | 15060000161916 | 15060000161922 | 1 | 2 | BTA | PNREANR5L15BTA0445 | |
| 15060000161975 | L15/dossiers | 15 | 15060000161948 | 15060000161974 | 1 | 2 | BTA | PIONSNR5S339BTA0094 | |
| 15060000162011 | L15/dossiers | 15 | 15060000161996 | 15060000162010 | 1 | 2 | BTA | PRJLANR5L15BTA0411 | |
| 15060000162012 | L15/dossiers | 15 | 15060000161996 | 15060000162010 | 2 | 2 | TAP | PRJLANR5L15TAP0411 | |
| 15060000162024 | L15/dossiers | 15 | 15060000161996 | 15060000162023 | 1 | 2 | BTA | PRJLSNR5S339BTA0078 | |
| 15060000162035 | L15/dossiers | 15 | 15060000162027 | 15060000162034 | 1 | 2 | BTA | PNREANR5L15BTA0722 | |
| 15060000162061 | L15/dossiers | 15 | 15060000162047 | 15060000162060 | 1 | 2 | BTA | PRJLSNR5S339BTA0076 | |
| 15060000162076 | L15/dossiers | 15 | 15060000162047 | 15060000162075 | 1 | 2 | BTA | PRJLANR5L15BTA0412 | |
| 15060000162077 | L15/dossiers | 15 | 15060000162047 | 15060000162075 | 2 | 2 | TAP | PRJLANR5L15TAP0412 | |
| 15060000162091 | L15/dossiers | 15 | 15060000162047 | 15060000162090 | 1 | 2 | BTA | PRJLSNR5S339BTA0079 | |
| 15060000162097 | L15/dossiers | 15 | 15060000162047 | 15060000162096 | 1 | 2 | BTA | PRJLANR5L15BTA0414 | |
| 15060000162098 | L15/dossiers | 15 | 15060000162047 | 15060000162096 | 2 | 2 | TAP | PRJLANR5L15TAP0414 | |
| 15060000162113 | L15/dossiers | 15 | 15060000162102 | 15060000162112 | 1 | 2 | BTA | PRJLSNR5S339BTA0077 | |
| 15060000162128 | L15/dossiers | 15 | 15060000162102 | 15060000162127 | 1 | 2 | BTA | PRJLANR5L15BTA0413 | |
| 15060000162129 | L15/dossiers | 15 | 15060000162102 | 15060000162127 | 2 | 2 | TAP | PRJLANR5L15TAP0413 | |
| 15060000162202 | L15/dossiers | 15 | 15060000162185 | 15060000162201 | 1 | 2 | BTA | PIONANR5L15BTA0679 | |
| 15060000162217 | L15/dossiers | 15 | 15060000162203 | 15060000162216 | 1 | 2 | BTA | PIONANR5L15BTA0450 | |
| 15060000162218 | L15/dossiers | 15 | 15060000162203 | 15060000162216 | 2 | 2 | TAP | PIONANR5L15TAP0450 | |
| 15060000162230 | L15/dossiers | 15 | 15060000162203 | 15060000162229 | 1 | 2 | BTA | PIONSNR5S359BTA0007 | |
| 15060000162241 | L15/dossiers | 15 | 15060000162203 | 15060000162240 | 1 | 2 | BTA | PIONANR5L15BTA0569 | |
| 15060000162242 | L15/dossiers | 15 | 15060000162203 | 15060000162240 | 2 | 2 | TAP | PIONANR5L15TAP0569 | |
| 15060000162692 | L15/dossiers | 15 | 15060000162672 | 15060000162691 | 1 | 2 | BTA | PRJLANR5L15BTA0415 | |
| 15060000162693 | L15/dossiers | 15 | 15060000162672 | 15060000162691 | 2 | 2 | TAP | PRJLANR5L15TAP0415 | |
| 15060000162704 | L15/dossiers | 15 | 15060000162672 | 15060000162703 | 1 | 2 | BTA | PRJLSNR5S339BTA0083 | |
| 15060000162717 | L15/dossiers | 15 | 15060000162672 | 15060000162716 | 1 | 2 | BTA | PRJLSNR5S339BTA0084 | |
| 15060000162720 | L15/dossiers | 15 | 15060000162672 | 15060000162719 | 1 | 2 | BTA | PRJLANR5L15BTA0416 | |
| 15060000162721 | L15/dossiers | 15 | 15060000162672 | 15060000162719 | 2 | 2 | TAP | PRJLANR5L15TAP0416 | |
| 15060000162789 | L15/dossiers | 15 | 15060000162774 | 15060000162788 | 1 | 2 | BTA | PIONSNR5S339BTA0092 | |
| 15060000163133 | L15/dossiers | 15 | 15060000163117 | 15060000163132 | 1 | 2 | BTA | PIONANR5L15BTA0430 | |
| 15060000163369 | L15/dossiers | 15 | 15060000163302 | 15060000163368 | 1 | 2 | BTA | PRJLANR5L15BTA0432 | |
| 15060000163370 | L15/dossiers | 15 | 15060000163302 | 15060000163368 | 2 | 2 | TAP | PRJLANR5L15TAP0432 | |
| 15060000163382 | L15/dossiers | 15 | 15060000163302 | 15060000163381 | 1 | 2 | BTA | PRJLSNR5S339BTA0119 | |
| 15060000163402 | L15/dossiers | 15 | 15060000163302 | 15060000163401 | 1 | 2 | BTA | PRJLANR5L15BTA0462 | |
| 15060000163403 | L15/dossiers | 15 | 15060000163302 | 15060000163401 | 2 | 2 | TAP | PRJLANR5L15TAP0462 | |
| 15060000163413 | L15/dossiers | 15 | 15060000163302 | 15060000163412 | 1 | 2 | BTA | PRJLSNR5S339BTA0129 | |
| 15060000163424 | L15/dossiers | 15 | 15060000163302 | 15060000163423 | 1 | 2 | BTA | PRJLANR5L15BTA0470 | |
| 15060000163425 | L15/dossiers | 15 | 15060000163302 | 15060000163423 | 2 | 2 | TAP | PRJLANR5L15TAP0470 | |
| 15060000163442 | L15/dossiers | 15 | 15060000163428 | 15060000163441 | 1 | 2 | BTA | PRJLSNR5S339BTA0085 | |
| 15060000163460 | L15/dossiers | 15 | 15060000163428 | 15060000163459 | 1 | 2 | BTA | PRJLANR5L15BTA0417 |