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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000165793 | L15/dossiers | 15 | 15060000165755 | 15060000165792 | 1 | 2 | BTA | PRJLSNR5S359BTA0002 | |
| 15060000165815 | L15/dossiers | 15 | 15060000165755 | 15060000165814 | 1 | 2 | BTA | PRJLANR5L15BTA0498 | |
| 15060000165816 | L15/dossiers | 15 | 15060000165755 | 15060000165814 | 2 | 2 | TAP | PRJLANR5L15TAP0498 | |
| 15060000165825 | L15/dossiers | 15 | 15060000165755 | 15060000165824 | 1 | 2 | BTA | PRJLSNR5S359BTA0036 | |
| 15060000165834 | L15/dossiers | 15 | 15060000165755 | 15060000165833 | 1 | 2 | BTA | PRJLANR5L15BTA0540 | |
| 15060000165835 | L15/dossiers | 15 | 15060000165755 | 15060000165833 | 2 | 2 | TAP | PRJLANR5L15TAP0540 | |
| 15060000165928 | L15/dossiers | 15 | 15060000165914 | 15060000165927 | 1 | 2 | BTA | RIONANR5L15BTA0560 | |
| 15060000166155 | L15/dossiers | 15 | 15060000166133 | 15060000166154 | 1 | 2 | BTA | PIONANR5L15BTA0525 | |
| 15060000166156 | L15/dossiers | 15 | 15060000166133 | 15060000166154 | 2 | 2 | TAP | PIONANR5L15TAP0525 | |
| 15060000166167 | L15/dossiers | 15 | 15060000166133 | 15060000166166 | 1 | 2 | BTA | PIONSNR5S379BTA0011 | |
| 15060000166191 | L15/dossiers | 15 | 15060000166133 | 15060000166190 | 1 | 2 | BTA | PIONANR5L15BTA0754 | |
| 15060000166192 | L15/dossiers | 15 | 15060000166133 | 15060000166190 | 2 | 2 | TAP | PIONANR5L15TAP0754 | |
| 15060000166201 | L15/dossiers | 15 | 15060000166133 | 15060000166200 | 1 | 2 | BTA | PIONSNR5S379BTA0084 | |
| 15060000166211 | L15/dossiers | 15 | 15060000166133 | 15060000166210 | 1 | 2 | BTA | PIONANR5L15BTA0791 | |
| 15060000166212 | L15/dossiers | 15 | 15060000166133 | 15060000166210 | 2 | 2 | TAP | PIONANR5L15TAP0791 | |
| 15060000166264 | L15/dossiers | 15 | 15060000166243 | 15060000166263 | 1 | 2 | BTA | PIONANR5L15BTA0616 | |
| 15060000166265 | L15/dossiers | 15 | 15060000166243 | 15060000166263 | 2 | 2 | TAP | PIONANR5L15TAP0616 | |
| 15060000166278 | L15/dossiers | 15 | 15060000166243 | 15060000166277 | 1 | 2 | BTA | PIONSNR5S359BTA0156 | |
| 15060000166294 | L15/dossiers | 15 | 15060000166243 | 15060000166293 | 1 | 2 | BTA | PIONSNR5S379BTA0013 | |
| 15060000166299 | L15/dossiers | 15 | 15060000166243 | 15060000166298 | 1 | 2 | BTA | PIONANR5L15BTA0689 | |
| 15060000166300 | L15/dossiers | 15 | 15060000166243 | 15060000166298 | 2 | 2 | TAP | PIONANR5L15TAP0689 | |
| 15060000166405 | L15/dossiers | 15 | 15060000166389 | 15060000166404 | 1 | 2 | BTA | PIONSNR5S359BTA0044 | |
| 15060000166574 | L15/dossiers | 15 | 15060000166549 | 15060000166573 | 1 | 2 | BTA | PRJLANR5L15BTA0477 | |
| 15060000166575 | L15/dossiers | 15 | 15060000166549 | 15060000166573 | 2 | 2 | TAP | PRJLANR5L15TAP0477 | |
| 15060000166586 | L15/dossiers | 15 | 15060000166549 | 15060000166585 | 1 | 2 | BTA | PRJLSNR5S359BTA0003 | |
| 15060000166607 | L15/dossiers | 15 | 15060000166549 | 15060000166606 | 1 | 2 | BTA | PRJLANR5L15BTA0499 | |
| 15060000166608 | L15/dossiers | 15 | 15060000166549 | 15060000166606 | 2 | 2 | TAP | PRJLANR5L15TAP0499 | |
| 15060000166617 | L15/dossiers | 15 | 15060000166549 | 15060000166616 | 1 | 2 | BTA | PRJLSNR5S359BTA0035 | |
| 15060000166626 | L15/dossiers | 15 | 15060000166549 | 15060000166625 | 1 | 2 | BTA | PRJLANR5L15BTA0535 | |
| 15060000166627 | L15/dossiers | 15 | 15060000166549 | 15060000166625 | 2 | 2 | TAP | PRJLANR5L15TAP0535 | |
| 15060000166742 | L15/dossiers | 15 | 15060000166729 | 15060000166741 | 1 | 2 | BTA | PRJLSNR5S339BTA0133 | |
| 15060000166754 | L15/dossiers | 15 | 15060000166729 | 15060000166753 | 1 | 2 | BTA | PRJLANR5L15BTA0473 | |
| 15060000166755 | L15/dossiers | 15 | 15060000166729 | 15060000166753 | 2 | 2 | TAP | PRJLANR5L15TAP0473 | |
| 15060000166870 | L15/dossiers | 15 | 15060000166843 | 15060000166869 | 1 | 2 | BTA | PRJLANR5L15BTA0486 | |
| 15060000166871 | L15/dossiers | 15 | 15060000166843 | 15060000166869 | 2 | 2 | TAP | PRJLANR5L15TAP0486 | |
| 15060000166883 | L15/dossiers | 15 | 15060000166843 | 15060000166882 | 1 | 2 | BTA | PRJLSNR5S359BTA0019 | |
| 15060000166905 | L15/dossiers | 15 | 15060000166843 | 15060000166904 | 1 | 2 | BTA | PRJLANR5L15BTA0526 | |
| 15060000166906 | L15/dossiers | 15 | 15060000166843 | 15060000166904 | 2 | 2 | TAP | PRJLANR5L15TAP0526 | |
| 15060000166916 | L15/dossiers | 15 | 15060000166843 | 15060000166915 | 1 | 2 | BTA | PRJLSNR5S359BTA0038 | |
| 15060000166925 | L15/dossiers | 15 | 15060000166843 | 15060000166924 | 1 | 2 | BTA | PRJLANR5L15BTA0539 | |
| 15060000166926 | L15/dossiers | 15 | 15060000166843 | 15060000166924 | 2 | 2 | TAP | PRJLANR5L15TAP0539 | |
| 15060000166949 | L15/dossiers | 15 | 15060000166936 | 15060000166948 | 1 | 2 | BTA | PIONSNR5S359BTA0008 | |
| 15060000166965 | L15/dossiers | 15 | 15060000166936 | 15060000166964 | 1 | 2 | BTA | PIONANR5L15BTA0710 | |
| 15060000166966 | L15/dossiers | 15 | 15060000166936 | 15060000166964 | 2 | 2 | TAP | PIONANR5L15TAP0710 | |
| 15060000166976 | L15/dossiers | 15 | 15060000166936 | 15060000166975 | 1 | 2 | BTA | PIONSNR5S379BTA0116 | |
| 15060000167090 | L15/dossiers | 15 | 15060000167051 | 15060000167089 | 1 | 2 | BTA | PRJLANR5L15BTA0478 | |
| 15060000167091 | L15/dossiers | 15 | 15060000167051 | 15060000167089 | 2 | 2 | TAP | PRJLANR5L15TAP0478 | |
| 15060000167102 | L15/dossiers | 15 | 15060000167051 | 15060000167101 | 1 | 2 | BTA | PRJLSNR5S359BTA0013 | |
| 15060000167117 | L15/dossiers | 15 | 15060000167051 | 15060000167116 | 1 | 2 | BTA | PRJLANR5L15BTA0501 | |
| 15060000167118 | L15/dossiers | 15 | 15060000167051 | 15060000167116 | 2 | 2 | TAP | PRJLANR5L15TAP0501 |