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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000167122 | L15/dossiers | 15 | 15060000167051 | 15060000167121 | 1 | 2 | BTA | PRJLSNR5S359BTA0024 | |
| 15060000167162 | L15/dossiers | 15 | 15060000167145 | 15060000167161 | 1 | 2 | BTA | PRJLANR5L15BTA0552 | |
| 15060000167163 | L15/dossiers | 15 | 15060000167145 | 15060000167161 | 2 | 2 | TAP | PRJLANR5L15TAP0552 | |
| 15060000167175 | L15/dossiers | 15 | 15060000167145 | 15060000167174 | 1 | 2 | BTA | PRJLSNR5S359BTA0059 | |
| 15060000167338 | L15/dossiers | 15 | 15060000167323 | 15060000167337 | 1 | 2 | BTA | PIONANR5L15BTA0631 | |
| 15060000167715 | L15/dossiers | 15 | 15060000167441 | 15060000167714 | 1 | 2 | BTA | PRJLANR5L15BTA0500 | |
| 15060000167716 | L15/dossiers | 15 | 15060000167441 | 15060000167714 | 2 | 2 | TAP | PRJLANR5L15TAP0500 | |
| 15060000167776 | L15/dossiers | 15 | 15060000167441 | 15060000167775 | 1 | 2 | BTA | PRJLSNR5S359BTA0028 | |
| 15060000167801 | L15/dossiers | 15 | 15060000167441 | 15060000167800 | 1 | 2 | BTA | PRJLANR5L15BTA0536 | |
| 15060000167802 | L15/dossiers | 15 | 15060000167441 | 15060000167800 | 2 | 2 | TAP | PRJLANR5L15TAP0536 | |
| 15060000167812 | L15/dossiers | 15 | 15060000167441 | 15060000167811 | 1 | 2 | BTA | PRJLSNR5S359BTA0040 | |
| 15060000167822 | L15/dossiers | 15 | 15060000167441 | 15060000167821 | 1 | 2 | BTA | PRJLANR5L15BTA0538 | |
| 15060000167823 | L15/dossiers | 15 | 15060000167441 | 15060000167821 | 2 | 2 | TAP | PRJLANR5L15TAP0538 | |
| 15060000168171 | L15/dossiers | 15 | 15060000168157 | 15060000168170 | 1 | 2 | BTA | PIONSNR5S359BTA0006 | |
| 15060000168190 | L15/dossiers | 15 | 15060000168177 | 15060000168189 | 1 | 2 | BTA | PIONSNR5S359BTA0005 | |
| 15060000168242 | L15/dossiers | 15 | 15060000168227 | 15060000168241 | 1 | 2 | BTA | PRJLSNR5S359BTA0014 | |
| 15060000168259 | L15/dossiers | 15 | 15060000168227 | 15060000168258 | 1 | 2 | BTA | PRJLANR5L15BTA0578 | |
| 15060000168260 | L15/dossiers | 15 | 15060000168227 | 15060000168258 | 2 | 2 | TAP | PRJLANR5L15TAP0578 | |
| 15060000168414 | L15/dossiers | 15 | 15060000168398 | 15060000168413 | 1 | 2 | BTA | PIONANR5L15BTA0488 | |
| 15060000168415 | L15/dossiers | 15 | 15060000168398 | 15060000168413 | 2 | 2 | TAP | PIONANR5L15TAP0488 | |
| 15060000168426 | L15/dossiers | 15 | 15060000168398 | 15060000168425 | 1 | 2 | BTA | PIONSNR5S359BTA0045 | |
| 15060000168445 | L15/dossiers | 15 | 15060000168398 | 15060000168444 | 1 | 2 | BTA | PIONANR5L15BTA0719 | |
| 15060000168446 | L15/dossiers | 15 | 15060000168398 | 15060000168444 | 2 | 2 | TAP | PIONANR5L15TAP0719 | |
| 15060000168456 | L15/dossiers | 15 | 15060000168398 | 15060000168455 | 1 | 2 | BTA | PIONSNR5S379BTA0074 | |
| 15060000168480 | L15/dossiers | 15 | 15060000168398 | 15060000168479 | 1 | 2 | BTA | PIONANR5L15BTA0799 | |
| 15060000168481 | L15/dossiers | 15 | 15060000168398 | 15060000168479 | 2 | 2 | TAP | PIONANR5L15TAP0799 | |
| 15060000168491 | L15/dossiers | 15 | 15060000168398 | 15060000168490 | 1 | 2 | BTA | PIONSNR5S379BTA0104 | |
| 15060000168500 | L15/dossiers | 15 | 15060000168398 | 15060000168499 | 1 | 2 | BTA | PIONANR5L15BTA0812 | |
| 15060000168501 | L15/dossiers | 15 | 15060000168398 | 15060000168499 | 2 | 2 | TAP | PIONANR5L15TAP0812 | |
| 15060000168572 | L15/dossiers | 15 | 15060000168559 | 15060000168571 | 1 | 2 | BTA | PRJLSNR5S359BTA0055 | |
| 15060000168586 | L15/dossiers | 15 | 15060000168559 | 15060000168585 | 1 | 2 | BTA | PRJLANR5L15BTA0618 | |
| 15060000168606 | L15/dossiers | 15 | 15060000168589 | 15060000168605 | 1 | 2 | BTA | PIONANR5L15BTA0786 | |
| 15060000168633 | L15/dossiers | 15 | 15060000168621 | 15060000168632 | 1 | 2 | BTA | PIONSNR5S359BTA0009 | |
| 15060000168702 | L15/dossiers | 15 | 15060000168673 | 15060000168701 | 1 | 2 | BTA | PRJLANR5L15BTA0483 | |
| 15060000168703 | L15/dossiers | 15 | 15060000168673 | 15060000168701 | 2 | 2 | TAP | PRJLANR5L15TAP0483 | |
| 15060000168714 | L15/dossiers | 15 | 15060000168673 | 15060000168713 | 1 | 2 | BTA | PRJLSNR5S359BTA0011 | |
| 15060000168727 | L15/dossiers | 15 | 15060000168673 | 15060000168726 | 1 | 2 | BTA | PRJLANR5L15BTA0492 | |
| 15060000168728 | L15/dossiers | 15 | 15060000168673 | 15060000168726 | 2 | 2 | TAP | PRJLANR5L15TAP0492 | |
| 15060000168732 | L15/dossiers | 15 | 15060000168673 | 15060000168731 | 1 | 2 | BTA | PRJLSNR5S359BTA0017 | |
| 15060000168762 | L15/dossiers | 15 | 15060000168749 | 15060000168761 | 1 | 2 | BTA | PRJLSNR5S359BTA0041 | |
| 15060000168776 | L15/dossiers | 15 | 15060000168749 | 15060000168775 | 1 | 2 | BTA | PRJLANR5L15BTA0619 | |
| 15060000168917 | L15/dossiers | 15 | 15060000168899 | 15060000168916 | 1 | 2 | BTA | PIONANR5L15BTA0762 | |
| 15060000168951 | L15/dossiers | 15 | 15060000168939 | 15060000168950 | 1 | 2 | BTA | PRJLSNR5S359BTA0087 | |
| 15060000168965 | L15/dossiers | 15 | 15060000168939 | 15060000168964 | 1 | 2 | BTA | PRJLANR5L15BTA0772 | |
| 15060000169062 | L15/dossiers | 15 | 15060000169042 | 15060000169061 | 1 | 2 | BTA | PRJLANR5L15BTA0482 | |
| 15060000169063 | L15/dossiers | 15 | 15060000169042 | 15060000169061 | 2 | 2 | TAP | PRJLANR5L15TAP0482 | |
| 15060000169090 | L15/dossiers | 15 | 15060000169081 | 15060000169089 | 1 | 2 | BTA | RIONANR5L15BTA0493 | |
| 15060000169245 | L15/dossiers | 15 | 15060000169232 | 15060000169244 | 1 | 2 | BTA | PRJLSNR5S359BTA0015 | |
| 15060000169260 | L15/dossiers | 15 | 15060000169232 | 15060000169259 | 1 | 2 | BTA | PRJLANR5L15BTA0593 | |
| 15060000169354 | L15/dossiers | 15 | 15060000169291 | 15060000169353 | 1 | 2 | BTA | PIONSNR5S359BTA0029 |