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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000152486 | L15/dossiers | 15 | 15060000152330 | 15060000152485 | 1 | 2 | BTA | PRJLSNR5S359BTA0053 | |
| 15060000152521 | L15/dossiers | 15 | 15060000152330 | 15060000152520 | 1 | 2 | BTA | PRJLANR5L15BTA0623 | |
| 15060000152522 | L15/dossiers | 15 | 15060000152330 | 15060000152520 | 2 | 2 | TAP | PRJLANR5L15TAP0623 | |
| 15060000152531 | L15/dossiers | 15 | 15060000152330 | 15060000152530 | 1 | 2 | BTA | PRJLSNR5S359BTA0129 | |
| 15060000152540 | L15/dossiers | 15 | 15060000152330 | 15060000152539 | 1 | 2 | BTA | PRJLANR5L15BTA0640 | |
| 15060000152541 | L15/dossiers | 15 | 15060000152330 | 15060000152539 | 2 | 2 | TAP | PRJLANR5L15TAP0640 | |
| 15060000152713 | L15/dossiers | 15 | 15060000152697 | 15060000152712 | 1 | 2 | BTA | PIONANR5L15BTA0358 | |
| 15060000152714 | L15/dossiers | 15 | 15060000152697 | 15060000152712 | 2 | 2 | TAP | PIONANR5L15TAP0358 | |
| 15060000152725 | L15/dossiers | 15 | 15060000152697 | 15060000152724 | 1 | 2 | BTA | PIONSNR5S339BTA0095 | |
| 15060000152736 | L15/dossiers | 15 | 15060000152697 | 15060000152735 | 1 | 2 | BTA | PIONANR5L15BTA0555 | |
| 15060000152737 | L15/dossiers | 15 | 15060000152697 | 15060000152735 | 2 | 2 | TAP | PIONANR5L15TAP0555 | |
| 15060000152784 | L15/dossiers | 15 | 15060000152764 | 15060000152783 | 1 | 2 | BTA | PIONANR5L15BTA0344 | |
| 15060000152785 | L15/dossiers | 15 | 15060000152764 | 15060000152783 | 2 | 2 | TAP | PIONANR5L15TAP0344 | |
| 15060000152798 | L15/dossiers | 15 | 15060000152764 | 15060000152797 | 1 | 2 | BTA | PIONSNR5S339BTA0024 | |
| 15060000152812 | L15/dossiers | 15 | 15060000152764 | 15060000152811 | 1 | 2 | BTA | PIONANR5L15BTA0363 | |
| 15060000152813 | L15/dossiers | 15 | 15060000152764 | 15060000152811 | 2 | 2 | TAP | PIONANR5L15TAP0363 | |
| 15060000152817 | L15/dossiers | 15 | 15060000152764 | 15060000152816 | 1 | 2 | BTA | PIONSNR5S339BTA0040 | |
| 15060000152910 | L15/dossiers | 15 | 15060000152897 | 15060000152909 | 1 | 2 | BTA | PRJLSNR5S339BTA0052 | |
| 15060000152923 | L15/dossiers | 15 | 15060000152897 | 15060000152922 | 1 | 2 | BTA | PRJLANR5L15BTA0545 | |
| 15060000152995 | L15/dossiers | 15 | 15060000152982 | 15060000152994 | 1 | 2 | BTA | PRJLSNR5S339BTA0037 | |
| 15060000153008 | L15/dossiers | 15 | 15060000152982 | 15060000153007 | 1 | 2 | BTA | PRJLANR5L15BTA0544 | |
| 15060000153237 | L15/dossiers | 15 | 15060000153221 | 15060000153236 | 1 | 2 | BTA | RIONANR5L15BTA0372 | |
| 15060000153238 | L15/dossiers | 15 | 15060000153221 | 15060000153236 | 2 | 2 | TAP | RIONANR5L15TAP0372 | |
| 15060000153247 | L15/dossiers | 15 | 15060000153239 | 15060000153246 | 1 | 2 | BTA | RIONANR5L15BTA0341 | |
| 15060000153335 | L15/dossiers | 15 | 15060000153319 | 15060000153334 | 1 | 2 | BTA | PIONSNR5S339BTA0001 | |
| 15060000153523 | L15/dossiers | 15 | 15060000153508 | 15060000153522 | 1 | 2 | BTA | PIONSNR5S339BTA0023 | |
| 15060000153538 | L15/dossiers | 15 | 15060000153508 | 15060000153537 | 1 | 2 | BTA | PIONANR5L15BTA0379 | |
| 15060000153539 | L15/dossiers | 15 | 15060000153508 | 15060000153537 | 2 | 2 | TAP | PIONANR5L15TAP0379 | |
| 15060000153549 | L15/dossiers | 15 | 15060000153508 | 15060000153548 | 1 | 2 | BTA | PIONSNR5S339BTA0063 | |
| 15060000153776 | L15/dossiers | 15 | 15060000153738 | 15060000153775 | 1 | 2 | BTA | PRJLANR5L15BTA0345 | |
| 15060000153777 | L15/dossiers | 15 | 15060000153738 | 15060000153775 | 2 | 2 | TAP | PRJLANR5L15TAP0345 | |
| 15060000153802 | L15/dossiers | 15 | 15060000153738 | 15060000153801 | 1 | 2 | BTA | PRJLSNR5S339BTA0026 | |
| 15060000153827 | L15/dossiers | 15 | 15060000153738 | 15060000153826 | 1 | 2 | BTA | PRJLANR5L15BTA0353 | |
| 15060000153828 | L15/dossiers | 15 | 15060000153738 | 15060000153826 | 2 | 2 | TAP | PRJLANR5L15TAP0353 | |
| 15060000153837 | L15/dossiers | 15 | 15060000153738 | 15060000153836 | 1 | 2 | BTA | PRJLSNR5S339BTA0031 | |
| 15060000153847 | L15/dossiers | 15 | 15060000153738 | 15060000153846 | 1 | 2 | BTA | PRJLANR5L15BTA0360 | |
| 15060000153848 | L15/dossiers | 15 | 15060000153738 | 15060000153846 | 2 | 2 | TAP | PRJLANR5L15TAP0360 | |
| 15060000153895 | L15/dossiers | 15 | 15060000153882 | 15060000153894 | 1 | 2 | BTA | PIONSNR5S339BTA0010 | |
| 15060000153957 | L15/dossiers | 15 | 15060000153943 | 15060000153956 | 1 | 2 | BTA | PIONSNR5S339BTA0062 | |
| 15060000153989 | L15/dossiers | 15 | 15060000153963 | 15060000153988 | 1 | 2 | BTA | PIONSNR5S339BTA0011 | |
| 15060000154008 | L15/dossiers | 15 | 15060000153995 | 15060000154007 | 1 | 2 | BTA | PIONSNR5S339BTA0012 | |
| 15060000154029 | L15/dossiers | 15 | 15060000154014 | 15060000154028 | 1 | 2 | BTA | PIONSNR5S339BTA0013 | |
| 15060000154044 | L15/dossiers | 15 | 15060000154014 | 15060000154043 | 1 | 2 | BTA | PIONANR5L15BTA0391 | |
| 15060000154045 | L15/dossiers | 15 | 15060000154014 | 15060000154043 | 2 | 2 | TAP | PIONANR5L15TAP0391 | |
| 15060000154057 | L15/dossiers | 15 | 15060000154014 | 15060000154056 | 1 | 2 | BTA | PIONSNR5S359BTA0070 | |
| 15060000154068 | L15/dossiers | 15 | 15060000154014 | 15060000154067 | 1 | 2 | BTA | PIONANR5L15BTA0611 | |
| 15060000154069 | L15/dossiers | 15 | 15060000154014 | 15060000154067 | 2 | 2 | TAP | PIONANR5L15TAP0611 | |
| 15060000154085 | L15/dossiers | 15 | 15060000154072 | 15060000154084 | 1 | 2 | BTA | PIONSNR5S339BTA0014 | |
| 15060000154102 | L15/dossiers | 15 | 15060000154072 | 15060000154101 | 1 | 2 | BTA | PIONANR5L15BTA0795 | |
| 15060000154103 | L15/dossiers | 15 | 15060000154072 | 15060000154101 | 2 | 2 | TAP | PIONANR5L15TAP0795 |