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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000169478 | L15/dossiers | 15 | 15060000169461 | 15060000169477 | 1 | 2 | BTA | PIONANR5L15BTA0713 | |
| 15060000169479 | L15/dossiers | 15 | 15060000169461 | 15060000169477 | 2 | 2 | TAP | PIONANR5L15TAP0713 | |
| 15060000169491 | L15/dossiers | 15 | 15060000169461 | 15060000169490 | 1 | 2 | BTA | PIONSNR5S379BTA0069 | |
| 15060000169573 | L15/dossiers | 15 | 15060000169557 | 15060000169572 | 1 | 2 | BTA | PIONANR5L15BTA0509 | |
| 15060000169574 | L15/dossiers | 15 | 15060000169557 | 15060000169572 | 2 | 2 | TAP | PIONANR5L15TAP0509 | |
| 15060000169585 | L15/dossiers | 15 | 15060000169557 | 15060000169584 | 1 | 2 | BTA | PIONSNR5S379BTA0028 | |
| 15060000169613 | L15/dossiers | 15 | 15060000169598 | 15060000169612 | 1 | 2 | BTA | RIONANR5L15BTA0506 | |
| 15060000169658 | L15/dossiers | 15 | 15060000169614 | 15060000169657 | 1 | 2 | BTA | PRJLANR5L15BTA0490 | |
| 15060000169659 | L15/dossiers | 15 | 15060000169614 | 15060000169657 | 2 | 2 | TAP | PRJLANR5L15TAP0490 | |
| 15060000169676 | L15/dossiers | 15 | 15060000169614 | 15060000169675 | 1 | 2 | BTA | PRJLSNR5S359BTA0022 | |
| 15060000169701 | L15/dossiers | 15 | 15060000169614 | 15060000169700 | 1 | 2 | BTA | PRJLANR5L15BTA0505 | |
| 15060000169702 | L15/dossiers | 15 | 15060000169614 | 15060000169700 | 2 | 2 | TAP | PRJLANR5L15TAP0505 | |
| 15060000169712 | L15/dossiers | 15 | 15060000169614 | 15060000169711 | 1 | 2 | BTA | PRJLSNR5S359BTA0027 | |
| 15060000169722 | L15/dossiers | 15 | 15060000169614 | 15060000169721 | 1 | 2 | BTA | PRJLANR5L15BTA0515 | |
| 15060000169723 | L15/dossiers | 15 | 15060000169614 | 15060000169721 | 2 | 2 | TAP | PRJLANR5L15TAP0515 | |
| 15060000169781 | L15/dossiers | 15 | 15060000169762 | 15060000169780 | 1 | 2 | BTA | PIONANR5L15BTA0511 | |
| 15060000169782 | L15/dossiers | 15 | 15060000169762 | 15060000169780 | 2 | 2 | TAP | PIONANR5L15TAP0511 | |
| 15060000169793 | L15/dossiers | 15 | 15060000169762 | 15060000169792 | 1 | 2 | BTA | PIONSNR5S359BTA0065 | |
| 15060000169808 | L15/dossiers | 15 | 15060000169762 | 15060000169807 | 1 | 2 | BTA | PIONANR5L15BTA0580 | |
| 15060000169809 | L15/dossiers | 15 | 15060000169762 | 15060000169807 | 2 | 2 | TAP | PIONANR5L15TAP0580 | |
| 15060000169812 | L15/dossiers | 15 | 15060000169762 | 15060000169811 | 1 | 2 | BTA | PIONSNR5S359BTA0089 | |
| 15060000169858 | L15/dossiers | 15 | 15060000169841 | 15060000169857 | 1 | 2 | BTA | PIONANR5L15BTA0517 | |
| 15060000169859 | L15/dossiers | 15 | 15060000169841 | 15060000169857 | 2 | 2 | TAP | PIONANR5L15TAP0517 | |
| 15060000169870 | L15/dossiers | 15 | 15060000169841 | 15060000169869 | 1 | 2 | BTA | PIONSNR5S359BTA0037 | |
| 15060000169920 | L15/dossiers | 15 | 15060000169908 | 15060000169919 | 1 | 2 | BTA | PIONSNR5S359BTA0098 | |
| 15060000170027 | L15/dossiers | 15 | 15060000170010 | 15060000170026 | 1 | 2 | BTA | PIONSNR5S359BTA0042 | |
| 15060000170052 | L15/dossiers | 15 | 15060000170010 | 15060000170051 | 1 | 2 | BTA | PIONANR5L15BTA0625 | |
| 15060000170053 | L15/dossiers | 15 | 15060000170010 | 15060000170051 | 2 | 2 | TAP | PIONANR5L15TAP0625 | |
| 15060000170062 | L15/dossiers | 15 | 15060000170010 | 15060000170061 | 1 | 2 | BTA | PIONSNR5S379BTA0023 | |
| 15060000170120 | L15/dossiers | 15 | 15060000170104 | 15060000170119 | 1 | 2 | BTA | PIONANR5L15BTA0588 | |
| 15060000170214 | L15/dossiers | 15 | 15060000170177 | 15060000170213 | 1 | 2 | BTA | PIONANR5L15BTA0504 | |
| 15060000170215 | L15/dossiers | 15 | 15060000170177 | 15060000170213 | 2 | 2 | TAP | PIONANR5L15TAP0504 | |
| 15060000170227 | L15/dossiers | 15 | 15060000170177 | 15060000170226 | 1 | 2 | BTA | PIONSNR5S359BTA0083 | |
| 15060000170242 | L15/dossiers | 15 | 15060000170177 | 15060000170241 | 1 | 2 | BTA | PIONSNR5S359BTA0091 | |
| 15060000170248 | L15/dossiers | 15 | 15060000170177 | 15060000170247 | 1 | 2 | BTA | PIONANR5L15BTA0599 | |
| 15060000170249 | L15/dossiers | 15 | 15060000170177 | 15060000170247 | 2 | 2 | TAP | PIONANR5L15TAP0599 | |
| 15060000170314 | L15/dossiers | 15 | 15060000170307 | 15060000170313 | 1 | 2 | BTA | RIONANR5L15BTA0514 | |
| 15060000170343 | L15/dossiers | 15 | 15060000170325 | 15060000170342 | 1 | 2 | BTA | PRJLANR5L15BTA0489 | |
| 15060000170344 | L15/dossiers | 15 | 15060000170325 | 15060000170342 | 2 | 2 | TAP | PRJLANR5L15TAP0489 | |
| 15060000170355 | L15/dossiers | 15 | 15060000170325 | 15060000170354 | 1 | 2 | BTA | PRJLSNR5S359BTA0012 | |
| 15060000170378 | L15/dossiers | 15 | 15060000170325 | 15060000170377 | 1 | 2 | BTA | PRJLANR5L15BTA0494 | |
| 15060000170379 | L15/dossiers | 15 | 15060000170325 | 15060000170377 | 2 | 2 | TAP | PRJLANR5L15TAP0494 | |
| 15060000170389 | L15/dossiers | 15 | 15060000170325 | 15060000170388 | 1 | 2 | BTA | PRJLSNR5S359BTA0020 | |
| 15060000170398 | L15/dossiers | 15 | 15060000170325 | 15060000170397 | 1 | 2 | BTA | PRJLANR5L15BTA0496 | |
| 15060000170399 | L15/dossiers | 15 | 15060000170325 | 15060000170397 | 2 | 2 | TAP | PRJLANR5L15TAP0496 | |
| 15060000170429 | L15/dossiers | 15 | 15060000170406 | 15060000170428 | 1 | 2 | BTA | PIONANR5L15BTA0528 | |
| 15060000170430 | L15/dossiers | 15 | 15060000170406 | 15060000170428 | 2 | 2 | TAP | PIONANR5L15TAP0528 | |
| 15060000170441 | L15/dossiers | 15 | 15060000170406 | 15060000170440 | 1 | 2 | BTA | PIONSNR5S359BTA0064 | |
| 15060000170467 | L15/dossiers | 15 | 15060000170406 | 15060000170466 | 1 | 2 | BTA | PIONANR5L15BTA0582 | |
| 15060000170468 | L15/dossiers | 15 | 15060000170406 | 15060000170466 | 2 | 2 | TAP | PIONANR5L15TAP0582 |