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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000183207 | L15/dossiers | 15 | 15060000183163 | 15060000183205 | 2 | 2 | TAP | PIONANR5L15TAP0801 | |
| 15060000183211 | L15/dossiers | 15 | 15060000183163 | 15060000183210 | 1 | 2 | BTA | PIONSNR5S379BTA0108 | |
| 15060000183246 | L15/dossiers | 15 | 15060000183229 | 15060000183245 | 1 | 2 | BTA | PIONANR5L15BTA0748 | |
| 15060000183272 | L15/dossiers | 15 | 15060000183252 | 15060000183271 | 1 | 2 | BTA | PRJLANR5L15BTA0696 | |
| 15060000183273 | L15/dossiers | 15 | 15060000183252 | 15060000183271 | 2 | 2 | TAP | PRJLANR5L15TAP0696 | |
| 15060000183284 | L15/dossiers | 15 | 15060000183252 | 15060000183283 | 1 | 2 | BTA | PRJLSNR5S379BTA0080 | |
| 15060000183299 | L15/dossiers | 15 | 15060000183252 | 15060000183298 | 1 | 2 | BTA | PRJLANR5L15BTA0796 | |
| 15060000183300 | L15/dossiers | 15 | 15060000183252 | 15060000183298 | 2 | 2 | TAP | PRJLANR5L15TAP0796 | |
| 15060000183304 | L15/dossiers | 15 | 15060000183252 | 15060000183303 | 1 | 2 | BTA | PRJLSNR5S379BTA0098 | |
| 15060000183327 | L15/dossiers | 15 | 15060000183308 | 15060000183326 | 1 | 2 | BTA | PRJLANR5L15BTA0765 | |
| 15060000183328 | L15/dossiers | 15 | 15060000183308 | 15060000183326 | 2 | 2 | TAP | PRJLANR5L15TAP0765 | |
| 15060000183340 | L15/dossiers | 15 | 15060000183308 | 15060000183339 | 1 | 2 | BTA | PRJLSNR5S379BTA0100 | |
| 15060000183367 | L15/dossiers | 15 | 15060000183348 | 15060000183366 | 1 | 2 | BTA | PRJLANR5L15BTA0686 | |
| 15060000183368 | L15/dossiers | 15 | 15060000183348 | 15060000183366 | 2 | 2 | TAP | PRJLANR5L15TAP0686 | |
| 15060000183380 | L15/dossiers | 15 | 15060000183348 | 15060000183379 | 1 | 2 | BTA | PRJLSNR5S379BTA0036 | |
| 15060000183400 | L15/dossiers | 15 | 15060000183348 | 15060000183399 | 1 | 2 | BTA | PRJLANR5L15BTA0699 | |
| 15060000183401 | L15/dossiers | 15 | 15060000183348 | 15060000183399 | 2 | 2 | TAP | PRJLANR5L15TAP0699 | |
| 15060000183411 | L15/dossiers | 15 | 15060000183348 | 15060000183410 | 1 | 2 | BTA | PRJLSNR5S379BTA0041 | |
| 15060000183421 | L15/dossiers | 15 | 15060000183348 | 15060000183420 | 1 | 2 | BTA | PRJLANR5L15BTA0701 | |
| 15060000183422 | L15/dossiers | 15 | 15060000183348 | 15060000183420 | 2 | 2 | TAP | PRJLANR5L15TAP0701 | |
| 15060000183463 | L15/dossiers | 15 | 15060000183446 | 15060000183462 | 1 | 2 | BTA | PIONANR5L15BTA0720 | |
| 15060000183464 | L15/dossiers | 15 | 15060000183446 | 15060000183462 | 2 | 2 | TAP | PIONANR5L15TAP0720 | |
| 15060000183475 | L15/dossiers | 15 | 15060000183446 | 15060000183474 | 1 | 2 | BTA | PIONSNR5S379BTA0086 | |
| 15060000183497 | L15/dossiers | 15 | 15060000183446 | 15060000183496 | 1 | 2 | BTA | PIONANR5L15BTA0798 | |
| 15060000183498 | L15/dossiers | 15 | 15060000183446 | 15060000183496 | 2 | 2 | TAP | PIONANR5L15TAP0798 | |
| 15060000183508 | L15/dossiers | 15 | 15060000183446 | 15060000183507 | 1 | 2 | BTA | PIONSNR5S379BTA0106 | |
| 15060000183517 | L15/dossiers | 15 | 15060000183446 | 15060000183516 | 1 | 2 | BTA | PIONANR5L15BTA0817 | |
| 15060000183518 | L15/dossiers | 15 | 15060000183446 | 15060000183516 | 2 | 2 | TAP | PIONANR5L15TAP0817 | |
| 15060000183529 | L15/dossiers | 15 | 15060000183521 | 15060000183528 | 1 | 2 | BTA | PNREANR5L15BTA0724 | |
| 15060000183734 | L15/dossiers | 15 | 15060000183716 | 15060000183733 | 1 | 2 | BTA | PRJLANR5L15BTA0775 | |
| 15060000183844 | L15/dossiers | 15 | 15060000183832 | 15060000183843 | 1 | 2 | BTA | PIONSNR5S379BTA0087 | |
| 15060000183909 | L15/dossiers | 15 | 15060000183892 | 15060000183908 | 1 | 2 | BTA | PIONANR5L15BTA0746 | |
| 15060000183946 | L15/dossiers | 15 | 15060000183929 | 15060000183945 | 1 | 2 | BTA | PIONANR5L15BTA0743 | |
| 15060000183966 | L15/dossiers | 15 | 15060000183947 | 15060000183965 | 1 | 2 | BTA | PIONANR5L15BTA0747 | |
| 15060000183984 | L15/dossiers | 15 | 15060000183970 | 15060000183983 | 1 | 2 | BTA | PIONSNR5S379BTA0113 | |
| 15060000184028 | L15/dossiers | 15 | 15060000184012 | 15060000184027 | 1 | 2 | BTA | PIONANR5L15BTA0745 | |
| 15060000184052 | L15/dossiers | 15 | 15060000184033 | 15060000184051 | 1 | 2 | BTA | RIONANR5L15BTA0750 | |
| 15060000184080 | L15/dossiers | 15 | 15060000184067 | 15060000184079 | 1 | 2 | BTA | PIONSNR5S379BTA0085 | |
| 15060000184092 | L15/dossiers | 15 | 15060000184067 | 15060000184091 | 1 | 2 | BTA | PIONANR5L15BTA0803 | |
| 15060000184093 | L15/dossiers | 15 | 15060000184067 | 15060000184091 | 2 | 2 | TAP | PIONANR5L15TAP0803 | |
| 15060000184122 | L15/dossiers | 15 | 15060000184106 | 15060000184121 | 1 | 2 | BTA | PIONANR5L15BTA0744 | |
| 15060000184245 | L15/dossiers | 15 | 15060000184225 | 15060000184244 | 1 | 2 | BTA | PRJLANR5L15BTA0741 | |
| 15060000184246 | L15/dossiers | 15 | 15060000184225 | 15060000184244 | 2 | 2 | TAP | PRJLANR5L15TAP0741 | |
| 15060000184258 | L15/dossiers | 15 | 15060000184225 | 15060000184257 | 1 | 2 | BTA | PRJLSNR5S379BTA0090 | |
| 15060000184272 | L15/dossiers | 15 | 15060000184225 | 15060000184271 | 1 | 2 | BTA | PRJLANR5L15BTA0810 | |
| 15060000184273 | L15/dossiers | 15 | 15060000184225 | 15060000184271 | 2 | 2 | TAP | PRJLANR5L15TAP0810 | |
| 15060000184277 | L15/dossiers | 15 | 15060000184225 | 15060000184276 | 1 | 2 | BTA | PRJLSNR5S379BTA0117 | |
| 15060000184330 | L15/dossiers | 15 | 15060000184323 | 15060000184329 | 1 | 2 | BTA | RIONANR5L15BTA0758 | |
| 15060000184363 | L15/dossiers | 15 | 15060000184347 | 15060000184362 | 1 | 2 | BTA | PIONANR5L15BTA0759 | |
| 15060000184394 | L15/dossiers | 15 | 15060000184378 | 15060000184393 | 1 | 2 | BTA | PIONANR5L15BTA0760 |