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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000090594 | L14/dossiers | 14 | 14060000090542 | 14060000090593 | 1 | 2 | BTA | PRJLANR5L14BTA0628 | |
| 14060000090598 | L14/dossiers | 14 | 14060000090542 | 14060000090597 | 1 | 2 | BTA | PRJLSNR5S259BTA0063 | |
| 14060000090629 | L14/dossiers | 14 | 14060000090613 | 14060000090628 | 1 | 2 | BTA | PIONANR5L14BTA0900 | |
| 14060000090641 | L14/dossiers | 14 | 14060000090613 | 14060000090640 | 1 | 2 | BTA | PIONSNR5S299BTA0021 | |
| 14060000090655 | L14/dossiers | 14 | 14060000090613 | 14060000090654 | 1 | 2 | BTA | PIONANR5L15BTA0070 | |
| 14060000090656 | L14/dossiers | 14 | 14060000090613 | 14060000090654 | 2 | 2 | TAP | PIONANR5L15TAP0070 | |
| 14060000090701 | L14/dossiers | 14 | 14060000090685 | 14060000090700 | 1 | 2 | BTA | PIONANR5L14BTA0513 | |
| 14060000091066 | L14/dossiers | 14 | 14060000090723 | 14060000091065 | 1 | 2 | BTA | PRJLANR5L14BTA0420 | |
| 14060000091093 | L14/dossiers | 14 | 14060000090723 | 14060000091092 | 1 | 2 | BTA | PRJLSNR5S239BTA0030 | |
| 14060000091117 | L14/dossiers | 14 | 14060000090723 | 14060000091116 | 1 | 2 | BTA | PRJLANR5L14BTA0451 | |
| 14060000091127 | L14/dossiers | 14 | 14060000090723 | 14060000091126 | 1 | 2 | BTA | PRJLSNR5S239BTA0037 | |
| 14060000091138 | L14/dossiers | 14 | 14060000090723 | 14060000091137 | 1 | 2 | BTA | PRJLANR5L14BTA0459 | |
| 14060000091510 | L14/dossiers | 14 | 14060000091497 | 14060000091509 | 1 | 2 | BTA | PRJLSNR5S199BTA0157 | |
| 14060000091522 | L14/dossiers | 14 | 14060000091497 | 14060000091521 | 1 | 2 | BTA | PRJLANR5L14BTA0200 | |
| 14060000091553 | L14/dossiers | 14 | 14060000091539 | 14060000091552 | 1 | 2 | BTA | PRJLSNR5S239BTA0064 | |
| 14060000091565 | L14/dossiers | 14 | 14060000091539 | 14060000091564 | 1 | 2 | BTA | PRJLANR5L14BTA0634 | |
| 14060000091599 | L14/dossiers | 14 | 14060000091582 | 14060000091598 | 1 | 2 | BTA | PIONANR5L14BTA0740 | |
| 14060000091657 | L14/dossiers | 14 | 14060000091615 | 14060000091656 | 1 | 2 | BTA | PRJLANR5L14BTA0224 | |
| 14060000091680 | L14/dossiers | 14 | 14060000091615 | 14060000091679 | 1 | 2 | BTA | PRJLSNR5S219BTA0030 | |
| 14060000091704 | L14/dossiers | 14 | 14060000091615 | 14060000091703 | 1 | 2 | BTA | PRJLANR5L14BTA0244 | |
| 14060000091714 | L14/dossiers | 14 | 14060000091615 | 14060000091713 | 1 | 2 | BTA | PRJLSNR5S219BTA0041 | |
| 14060000091726 | L14/dossiers | 14 | 14060000091615 | 14060000091725 | 1 | 2 | BTA | PRJLANR5L14BTA0250 | |
| 14060000091773 | L14/dossiers | 14 | 14060000091735 | 14060000091772 | 1 | 2 | BTA | PRJLANR5L14BTA0686 | |
| 14060000091798 | L14/dossiers | 14 | 14060000091735 | 14060000091797 | 1 | 2 | BTA | PRJLSNR5S259BTA0118 | |
| 14060000091813 | L14/dossiers | 14 | 14060000091735 | 14060000091812 | 1 | 2 | BTA | PRJLANR5L14BTA0735 | |
| 14060000091817 | L14/dossiers | 14 | 14060000091735 | 14060000091816 | 1 | 2 | BTA | PRJLSNR5S259BTA0146 | |
| 14060000091834 | L14/dossiers | 14 | 14060000091824 | 14060000091833 | 1 | 2 | BTA | RIONANR5L14BTA0764 | |
| 14060000091869 | L14/dossiers | 14 | 14060000091852 | 14060000091868 | 1 | 2 | BTA | PRJLANR5L14BTA0011 | |
| 14060000091881 | L14/dossiers | 14 | 14060000091852 | 14060000091880 | 1 | 2 | BTA | PRJLSNR5S199BTA0028 | |
| 14060000091899 | L14/dossiers | 14 | 14060000091884 | 14060000091898 | 1 | 2 | BTA | PIONANR5L14BTA0529 | |
| 14060000091991 | L14/dossiers | 14 | 14060000091977 | 14060000091990 | 1 | 2 | BTA | PRJLSNR5S259BTA0011 | |
| 14060000092005 | L14/dossiers | 14 | 14060000091977 | 14060000092004 | 1 | 2 | BTA | PRJLANR5L14BTA0704 | |
| 14060000092060 | L14/dossiers | 14 | 14060000092053 | 14060000092059 | 1 | 2 | BTA | PNREANR5L14BTA0528 | |
| 14060000092082 | L14/dossiers | 14 | 14060000092068 | 14060000092081 | 1 | 2 | BTA | PRJLSNR5S199BTA0020 | |
| 14060000092097 | L14/dossiers | 14 | 14060000092068 | 14060000092096 | 1 | 2 | BTA | PRJLANR5L14BTA0040 | |
| 14060000092111 | L14/dossiers | 14 | 14060000092068 | 14060000092110 | 1 | 2 | BTA | PRJLSNR5S199BTA0043 | |
| 14060000092115 | L14/dossiers | 14 | 14060000092068 | 14060000092114 | 1 | 2 | BTA | PRJLANR5L14BTA0065 | |
| 14060000092133 | L14/dossiers | 14 | 14060000092119 | 14060000092132 | 1 | 2 | BTA | RIONANR5L14BTA0346 | |
| 14060000092147 | L14/dossiers | 14 | 14060000092134 | 14060000092146 | 1 | 2 | BTA | RIONANR5L14BTA0572 | |
| 14060000092226 | L14/dossiers | 14 | 14060000092160 | 14060000092225 | 1 | 2 | BTA | PRJLANR5L14BTA0412 | |
| 14060000092267 | L14/dossiers | 14 | 14060000092160 | 14060000092266 | 1 | 2 | BTA | PRJLSNR5S239BTA0067 | |
| 14060000092307 | L14/dossiers | 14 | 14060000092160 | 14060000092306 | 1 | 2 | BTA | PRJLANR5L14BTA0519 | |
| 14060000092319 | L14/dossiers | 14 | 14060000092160 | 14060000092318 | 1 | 2 | BTA | PRJLSNR5S239BTA0134 | |
| 14060000092330 | L14/dossiers | 14 | 14060000092160 | 14060000092329 | 1 | 2 | BTA | PRJLANR5L14BTA0575 | |
| 14060000092354 | L14/dossiers | 14 | 14060000092347 | 14060000092353 | 1 | 2 | BTA | PNREANR5L14BTA0502 | |
| 14060000092396 | L14/dossiers | 14 | 14060000092362 | 14060000092395 | 1 | 2 | BTA | PRJLSNR5S199BTA0163 | |
| 14060000092451 | L14/dossiers | 14 | 14060000092362 | 14060000092450 | 1 | 2 | BTA | PRJLANR5L14BTA0190 | |
| 14060000092464 | L14/dossiers | 14 | 14060000092362 | 14060000092463 | 1 | 2 | BTA | PRJLSNR5S219BTA0005 | |
| 14060000092481 | L14/dossiers | 14 | 14060000092362 | 14060000092480 | 1 | 2 | BTA | PRJLANR5L14BTA0259 | |
| 14060000092495 | L14/dossiers | 14 | 14060000092362 | 14060000092494 | 1 | 2 | BTA | PRJLSNR5S219BTA0056 |