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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000145408 | L15/dossiers | 15 | 15060000145355 | 15060000145406 | 2 | 2 | TAP | PRJLANR5L15TAP0275 | |
| 15060000145432 | L15/dossiers | 15 | 15060000145415 | 15060000145431 | 1 | 2 | BTA | PRJLSNR5S319BTA0066 | |
| 15060000145450 | L15/dossiers | 15 | 15060000145415 | 15060000145449 | 1 | 2 | BTA | PRJLANR5L15BTA0259 | |
| 15060000145451 | L15/dossiers | 15 | 15060000145415 | 15060000145449 | 2 | 2 | TAP | PRJLANR5L15TAP0259 | |
| 15060000145465 | L15/dossiers | 15 | 15060000145415 | 15060000145464 | 1 | 2 | BTA | PRJLSNR5S319BTA0104 | |
| 15060000145469 | L15/dossiers | 15 | 15060000145415 | 15060000145468 | 1 | 2 | BTA | PRJLANR5L15BTA0274 | |
| 15060000145470 | L15/dossiers | 15 | 15060000145415 | 15060000145468 | 2 | 2 | TAP | PRJLANR5L15TAP0274 | |
| 15060000145588 | L15/dossiers | 15 | 15060000145572 | 15060000145587 | 1 | 2 | BTA | PIONANR5L15BTA0221 | |
| 15060000145589 | L15/dossiers | 15 | 15060000145572 | 15060000145587 | 2 | 2 | TAP | PIONANR5L15TAP0221 | |
| 15060000145601 | L15/dossiers | 15 | 15060000145572 | 15060000145600 | 1 | 2 | BTA | PIONSNR5S319BTA0065 | |
| 15060000145620 | L15/dossiers | 15 | 15060000145604 | 15060000145619 | 1 | 2 | BTA | PIONANR5L15BTA0234 | |
| 15060000145621 | L15/dossiers | 15 | 15060000145604 | 15060000145619 | 2 | 2 | TAP | PIONANR5L15TAP0234 | |
| 15060000145633 | L15/dossiers | 15 | 15060000145604 | 15060000145632 | 1 | 2 | BTA | PIONSNR5S339BTA0018 | |
| 15060000145644 | L15/dossiers | 15 | 15060000145604 | 15060000145643 | 1 | 2 | BTA | PIONANR5L15BTA0402 | |
| 15060000145645 | L15/dossiers | 15 | 15060000145604 | 15060000145643 | 2 | 2 | TAP | PIONANR5L15TAP0402 | |
| 15060000145653 | L15/dossiers | 15 | 15060000145604 | 15060000145652 | 1 | 2 | BTA | PIONSNR5S339BTA0111 | |
| 15060000145673 | L15/dossiers | 15 | 15060000145656 | 15060000145672 | 1 | 2 | BTA | PIONANR5L15BTA0225 | |
| 15060000145674 | L15/dossiers | 15 | 15060000145656 | 15060000145672 | 2 | 2 | TAP | PIONANR5L15TAP0225 | |
| 15060000145698 | L15/dossiers | 15 | 15060000145680 | 15060000145697 | 1 | 2 | BTA | PIONANR5L15BTA0223 | |
| 15060000145717 | L15/dossiers | 15 | 15060000145699 | 15060000145716 | 1 | 2 | BTA | PIONANR5L15BTA0224 | |
| 15060000145718 | L15/dossiers | 15 | 15060000145699 | 15060000145716 | 2 | 2 | TAP | PIONANR5L15TAP0224 | |
| 15060000145809 | L15/dossiers | 15 | 15060000145780 | 15060000145808 | 1 | 2 | BTA | PRJLANR5L15BTA0214 | |
| 15060000145810 | L15/dossiers | 15 | 15060000145780 | 15060000145808 | 2 | 2 | TAP | PRJLANR5L15TAP0214 | |
| 15060000145822 | L15/dossiers | 15 | 15060000145780 | 15060000145821 | 1 | 2 | BTA | PRJLSNR5S319BTA0044 | |
| 15060000145907 | L15/dossiers | 15 | 15060000145890 | 15060000145906 | 1 | 2 | BTA | PIONANR5L15BTA0236 | |
| 15060000145908 | L15/dossiers | 15 | 15060000145890 | 15060000145906 | 2 | 2 | TAP | PIONANR5L15TAP0236 | |
| 15060000145955 | L15/dossiers | 15 | 15060000145943 | 15060000145954 | 1 | 2 | BTA | PIONSNR5S319BTA0051 | |
| 15060000145985 | L15/dossiers | 15 | 15060000145972 | 15060000145984 | 1 | 2 | BTA | PIONSNR5S319BTA0050 | |
| 15060000146004 | L15/dossiers | 15 | 15060000145991 | 15060000146003 | 1 | 2 | BTA | PIONSNR5S319BTA0052 | |
| 15060000146070 | L15/dossiers | 15 | 15060000146057 | 15060000146069 | 1 | 2 | BTA | PIONSNR5S319BTA0054 | |
| 15060000146089 | L15/dossiers | 15 | 15060000146076 | 15060000146088 | 1 | 2 | BTA | PIONSNR5S319BTA0055 | |
| 15060000146105 | L15/dossiers | 15 | 15060000146076 | 15060000146104 | 1 | 2 | BTA | PIONANR5L15BTA0267 | |
| 15060000146106 | L15/dossiers | 15 | 15060000146076 | 15060000146104 | 2 | 2 | TAP | PIONANR5L15TAP0267 | |
| 15060000146116 | L15/dossiers | 15 | 15060000146076 | 15060000146115 | 1 | 2 | BTA | PIONSNR5S319BTA0125 | |
| 15060000146128 | L15/dossiers | 15 | 15060000146076 | 15060000146127 | 1 | 2 | BTA | PIONANR5L15BTA0325 | |
| 15060000146129 | L15/dossiers | 15 | 15060000146076 | 15060000146127 | 2 | 2 | TAP | PIONANR5L15TAP0325 | |
| 15060000146192 | L15/dossiers | 15 | 15060000146175 | 15060000146191 | 1 | 2 | BTA | PRJLANR5L15BTA0336 | |
| 15060000146203 | L15/dossiers | 15 | 15060000146175 | 15060000146202 | 1 | 2 | BTA | PRJLSNR5S339BTA0051 | |
| 15060000146223 | L15/dossiers | 15 | 15060000146206 | 15060000146222 | 1 | 2 | BTA | PRJLANR5L15BTA0308 | |
| 15060000146235 | L15/dossiers | 15 | 15060000146206 | 15060000146234 | 1 | 2 | BTA | PRJLSNR5S339BTA0038 | |
| 15060000146460 | L15/dossiers | 15 | 15060000146442 | 15060000146459 | 1 | 2 | BTA | PIONANR5L15BTA0238 | |
| 15060000146477 | L15/dossiers | 15 | 15060000146461 | 15060000146476 | 1 | 2 | BTA | PIONANR5L15BTA0240 | |
| 15060000146478 | L15/dossiers | 15 | 15060000146461 | 15060000146476 | 2 | 2 | TAP | PIONANR5L15TAP0240 | |
| 15060000146506 | L15/dossiers | 15 | 15060000146491 | 15060000146505 | 1 | 2 | BTA | PIONANR5L15BTA0237 | |
| 15060000146632 | L15/dossiers | 15 | 15060000146625 | 15060000146631 | 1 | 2 | BTA | RIONANR5L15BTA0231 | |
| 15060000146758 | L15/dossiers | 15 | 15060000146740 | 15060000146757 | 1 | 2 | BTA | PIONANR5L15BTA0249 | |
| 15060000146759 | L15/dossiers | 15 | 15060000146740 | 15060000146757 | 2 | 2 | TAP | PIONANR5L15TAP0249 | |
| 15060000146771 | L15/dossiers | 15 | 15060000146740 | 15060000146770 | 1 | 2 | BTA | PIONSNR5S319BTA0093 | |
| 15060000146787 | L15/dossiers | 15 | 15060000146740 | 15060000146786 | 1 | 2 | BTA | PIONANR5L15BTA0300 | |
| 15060000146788 | L15/dossiers | 15 | 15060000146740 | 15060000146786 | 2 | 2 | TAP | PIONANR5L15TAP0300 |