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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000184417 | L15/dossiers | 15 | 15060000184400 | 15060000184416 | 1 | 2 | BTA | PIONANR5L15BTA0761 | |
| 15060000184418 | L15/dossiers | 15 | 15060000184400 | 15060000184416 | 2 | 2 | TAP | PIONANR5L15TAP0761 | |
| 15060000184461 | L15/dossiers | 15 | 15060000184452 | 15060000184460 | 1 | 2 | BTA | RIONANR5L15BTA0742 | |
| 15060000184515 | L15/dossiers | 15 | 15060000184495 | 15060000184514 | 1 | 2 | BTA | PRJLANR5L15BTA0776 | |
| 15060000184527 | L15/dossiers | 15 | 15060000184495 | 15060000184526 | 1 | 2 | BTA | PRJLSNR5S379BTA0096 | |
| 15060000184638 | L15/dossiers | 15 | 15060000184623 | 15060000184637 | 1 | 2 | BTA | PIONANR5L15BTA0787 | |
| 15060000184661 | L15/dossiers | 15 | 15060000184653 | 15060000184660 | 1 | 2 | BTA | RIONANR5L15BTA0753 | |
| 15060000184677 | L15/dossiers | 15 | 15060000184662 | 15060000184676 | 1 | 2 | BTA | PIONANR5L15BTA0784 | |
| 15060000184678 | L15/dossiers | 15 | 15060000184662 | 15060000184676 | 2 | 2 | TAP | PIONANR5L15TAP0784 | |
| 15060000184820 | L15/dossiers | 15 | 15060000184813 | 15060000184819 | 1 | 2 | BTA | RIONANR5L15BTA0815 | |
| 15060000184887 | L15/dossiers | 15 | 15060000184871 | 15060000184886 | 1 | 2 | BTA | PIONANR5L15BTA0788 | |
| 15060000184904 | L15/dossiers | 15 | 15060000184888 | 15060000184903 | 1 | 2 | BTA | PIONANR5L15BTA0778 | |
| 15060000184905 | L15/dossiers | 15 | 15060000184888 | 15060000184903 | 2 | 2 | TAP | PIONANR5L15TAP0778 | |
| 15060000184932 | L15/dossiers | 15 | 15060000184918 | 15060000184931 | 1 | 2 | BTA | PIONANR5L15BTA0756 | |
| 15060000184933 | L15/dossiers | 15 | 15060000184918 | 15060000184931 | 2 | 2 | TAP | PIONANR5L15TAP0756 | |
| 15060000184945 | L15/dossiers | 15 | 15060000184918 | 15060000184944 | 1 | 2 | BTA | PIONSNR5S379BTA0089 | |
| 15060000184959 | L15/dossiers | 15 | 15060000184918 | 15060000184958 | 1 | 2 | BTA | PIONANR5L15BTA0800 | |
| 15060000184960 | L15/dossiers | 15 | 15060000184918 | 15060000184958 | 2 | 2 | TAP | PIONANR5L15TAP0800 | |
| 15060000184964 | L15/dossiers | 15 | 15060000184918 | 15060000184963 | 1 | 2 | BTA | PIONSNR5S379BTA0107 | |
| 15060000185010 | L15/dossiers | 15 | 15060000184993 | 15060000185009 | 1 | 2 | BTA | PIONANR5L15BTA0768 | |
| 15060000185011 | L15/dossiers | 15 | 15060000184993 | 15060000185009 | 2 | 2 | TAP | PIONANR5L15TAP0768 | |
| 15060000185023 | L15/dossiers | 15 | 15060000184993 | 15060000185022 | 1 | 2 | BTA | PIONSNR5S379BTA0099 | |
| 15060000185045 | L15/dossiers | 15 | 15060000184993 | 15060000185044 | 1 | 2 | BTA | PIONANR5L15BTA0809 | |
| 15060000185046 | L15/dossiers | 15 | 15060000184993 | 15060000185044 | 2 | 2 | TAP | PIONANR5L15TAP0809 | |
| 15060000185056 | L15/dossiers | 15 | 15060000184993 | 15060000185055 | 1 | 2 | BTA | PIONSNR5S379BTA0114 | |
| 15060000185065 | L15/dossiers | 15 | 15060000184993 | 15060000185064 | 1 | 2 | BTA | PIONANR5L15BTA0818 | |
| 15060000185066 | L15/dossiers | 15 | 15060000184993 | 15060000185064 | 2 | 2 | TAP | PIONANR5L15TAP0818 | |
| 15060000185076 | L15/dossiers | 15 | 15060000185069 | 15060000185075 | 1 | 2 | BTA | RIONANR5L15BTA0813 | |
| 15060000185153 | L15/dossiers | 15 | 15060000185127 | 15060000185152 | 1 | 2 | BTA | PRJLANR5L15BTA0739 | |
| 15060000185154 | L15/dossiers | 15 | 15060000185127 | 15060000185152 | 2 | 2 | TAP | PRJLANR5L15TAP0739 | |
| 15060000185166 | L15/dossiers | 15 | 15060000185127 | 15060000185165 | 1 | 2 | BTA | PRJLSNR5S379BTA0068 | |
| 15060000185189 | L15/dossiers | 15 | 15060000185127 | 15060000185188 | 1 | 2 | BTA | PRJLANR5L15BTA0749 | |
| 15060000185190 | L15/dossiers | 15 | 15060000185127 | 15060000185188 | 2 | 2 | TAP | PRJLANR5L15TAP0749 | |
| 15060000185199 | L15/dossiers | 15 | 15060000185127 | 15060000185198 | 1 | 2 | BTA | PRJLSNR5S379BTA0073 | |
| 15060000185208 | L15/dossiers | 15 | 15060000185127 | 15060000185207 | 1 | 2 | BTA | PRJLANR5L15BTA0751 | |
| 15060000185209 | L15/dossiers | 15 | 15060000185127 | 15060000185207 | 2 | 2 | TAP | PRJLANR5L15TAP0751 | |
| 15060000185247 | L15/dossiers | 15 | 15060000185230 | 15060000185246 | 1 | 2 | BTA | PIONANR5L15BTA0802 | |
| 15060000185248 | L15/dossiers | 15 | 15060000185230 | 15060000185246 | 2 | 2 | TAP | PIONANR5L15TAP0802 | |
| 15060000185261 | L15/dossiers | 15 | 15060000185254 | 15060000185260 | 1 | 2 | BTA | PNREANR5L15BTA0789 | |
| 15060000185279 | L15/dossiers | 15 | 15060000185262 | 15060000185278 | 1 | 2 | BTA | PRJLANR5L15BTA0808 | |
| 15060000185309 | L15/dossiers | 15 | 15060000185295 | 15060000185308 | 1 | 2 | BTA | PRJLSNR5S379BTA0097 | |
| 15060000185332 | L15/dossiers | 15 | 15060000185325 | 15060000185331 | 1 | 2 | BTA | RIONANR5L15BTA0780 | |
| 15060000185340 | L15/dossiers | 15 | 15060000185333 | 15060000185339 | 1 | 2 | BTA | RIONANR5L15BTA0779 | |
| 15060000185348 | L15/dossiers | 15 | 15060000185341 | 15060000185347 | 1 | 2 | BTA | RIONANR5L15BTA0781 | |
| 15060000185431 | L15/dossiers | 15 | 15060000185421 | 15060000185430 | 1 | 2 | BTA | RIONANR5L15BTA0820 | |
| 15060000185445 | L15/dossiers | 15 | 15060000185432 | 15060000185444 | 1 | 2 | BTA | PIONSNR5S379BTA0119 | |
| 15060000185472 | L15/dossiers | 15 | 15060000185458 | 15060000185471 | 1 | 2 | BTA | PRJLSNR5S379BTA0110 | |
| 15060000185579 | L15/dossiers | 15 | 15060000185567 | 15060000185578 | 1 | 2 | BTA | PIONSNR5S379BTA0120 | |
| 15060000185647 | L15/dossiers | 15 | 15060000185637 | 15060000185646 | 1 | 2 | BTA | RIONANR5L15BTA0821 | |
| 15060000185664 | L15/dossiers | 15 | 15060000185654 | 15060000185663 | 1 | 2 | BTA | RIONANR5L15BTA0822 |