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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000116432 | L14/dossiers | 14 | 14060000116424 | 14060000116431 | 1 | 2 | BTA | RIONANR5L14BTA0148 | |
| 14060000116449 | L14/dossiers | 14 | 14060000116433 | 14060000116448 | 1 | 2 | BTA | PIONANR5L14BTA0758 | |
| 14060000116497 | L14/dossiers | 14 | 14060000116482 | 14060000116496 | 1 | 2 | BTA | PRJLSNR5S199BTA0195 | |
| 14060000116512 | L14/dossiers | 14 | 14060000116482 | 14060000116511 | 1 | 2 | BTA | PRJLANR5L14BTA0206 | |
| 14060000116526 | L14/dossiers | 14 | 14060000116482 | 14060000116525 | 1 | 2 | BTA | PRJLSNR5S219BTA0021 | |
| 14060000116530 | L14/dossiers | 14 | 14060000116482 | 14060000116529 | 1 | 2 | BTA | PRJLANR5L14BTA0225 | |
| 14060000116591 | L14/dossiers | 14 | 14060000116559 | 14060000116590 | 1 | 2 | BTA | PRJLANR5L14BTA0215 | |
| 14060000116618 | L14/dossiers | 14 | 14060000116559 | 14060000116617 | 1 | 2 | BTA | PRJLSNR5S219BTA0045 | |
| 14060000116629 | L14/dossiers | 14 | 14060000116559 | 14060000116628 | 1 | 2 | BTA | PRJLANR5L14BTA0269 | |
| 14060000116692 | L14/dossiers | 14 | 14060000116676 | 14060000116691 | 1 | 2 | BTA | PRJLANR5L14BTA0639 | |
| 14060000116704 | L14/dossiers | 14 | 14060000116676 | 14060000116703 | 1 | 2 | BTA | PRJLSNR5S259BTA0094 | |
| 14060000116722 | L14/dossiers | 14 | 14060000116707 | 14060000116721 | 1 | 2 | BTA | PRJLSNR5S239BTA0002 | |
| 14060000116737 | L14/dossiers | 14 | 14060000116707 | 14060000116736 | 1 | 2 | BTA | PRJLANR5L14BTA0456 | |
| 14060000116785 | L14/dossiers | 14 | 14060000116772 | 14060000116784 | 1 | 2 | BTA | PIONSNR5S199BTA0079 | |
| 14060000116828 | L14/dossiers | 14 | 14060000116814 | 14060000116827 | 1 | 2 | BTA | PIONSNR5S199BTA0126 | |
| 14060000116843 | L14/dossiers | 14 | 14060000116814 | 14060000116842 | 1 | 2 | BTA | PIONANR5L14BTA0105 | |
| 14060000116863 | L14/dossiers | 14 | 14060000116849 | 14060000116862 | 1 | 2 | BTA | PIONANR5L14BTA0514 | |
| 14060000116890 | L14/dossiers | 14 | 14060000116876 | 14060000116889 | 1 | 2 | BTA | RIONANR5L14BTA0188 | |
| 14060000117047 | L14/dossiers | 14 | 14060000117033 | 14060000117046 | 1 | 2 | BTA | PRJLSNR5S199BTA0208 | |
| 14060000117061 | L14/dossiers | 14 | 14060000117033 | 14060000117060 | 1 | 2 | BTA | PRJLANR5L14BTA0227 | |
| 14060000117216 | L14/dossiers | 14 | 14060000117203 | 14060000117215 | 1 | 2 | BTA | PIONSNR5S219BTA0068 | |
| 14060000117244 | L14/dossiers | 14 | 14060000117227 | 14060000117243 | 1 | 2 | BTA | PIONANR5L14BTA0410 | |
| 14060000117263 | L14/dossiers | 14 | 14060000117254 | 14060000117262 | 1 | 2 | BTA | PNREANR5L14BTA0297 | |
| 14060000117280 | L14/dossiers | 14 | 14060000117264 | 14060000117279 | 1 | 2 | BTA | PRJLANR5L14BTA0488 | |
| 14060000117292 | L14/dossiers | 14 | 14060000117264 | 14060000117291 | 1 | 2 | BTA | PRJLSNR5S239BTA0092 | |
| 14060000117359 | L14/dossiers | 14 | 14060000117343 | 14060000117358 | 1 | 2 | BTA | PIONANR5L14BTA0041 | |
| 14060000117371 | L14/dossiers | 14 | 14060000117343 | 14060000117370 | 1 | 2 | BTA | PIONSNR5S199BTA0105 | |
| 14060000117383 | L14/dossiers | 14 | 14060000117343 | 14060000117382 | 1 | 2 | BTA | PIONANR5L14BTA0247 | |
| 14060000117393 | L14/dossiers | 14 | 14060000117343 | 14060000117392 | 1 | 2 | BTA | PIONSNR5S219BTA0075 | |
| 14060000117425 | L14/dossiers | 14 | 14060000117411 | 14060000117424 | 1 | 2 | BTA | PIONSNR5S199BTA0078 | |
| 14060000117441 | L14/dossiers | 14 | 14060000117411 | 14060000117440 | 1 | 2 | BTA | PIONANR5L14BTA0266 | |
| 14060000117451 | L14/dossiers | 14 | 14060000117411 | 14060000117450 | 1 | 2 | BTA | PIONSNR5S219BTA0067 | |
| 14060000117463 | L14/dossiers | 14 | 14060000117411 | 14060000117462 | 1 | 2 | BTA | PIONANR5L14BTA0466 | |
| 14060000117477 | L14/dossiers | 14 | 14060000117411 | 14060000117476 | 1 | 2 | BTA | PIONSNR5S239BTA0080 | |
| 14060000117481 | L14/dossiers | 14 | 14060000117411 | 14060000117480 | 1 | 2 | BTA | PIONANR5L14BTA0493 | |
| 14060000117566 | L14/dossiers | 14 | 14060000117551 | 14060000117565 | 1 | 2 | BTA | PRJLANR5L14BTA0226 | |
| 14060000117578 | L14/dossiers | 14 | 14060000117551 | 14060000117577 | 1 | 2 | BTA | PRJLSNR5S219BTA0042 | |
| 14060000117694 | L14/dossiers | 14 | 14060000117669 | 14060000117693 | 1 | 2 | BTA | PRJLANR5L14BTA0164 | |
| 14060000117708 | L14/dossiers | 14 | 14060000117669 | 14060000117707 | 1 | 2 | BTA | PRJLSNR5S199BTA0199 | |
| 14060000117732 | L14/dossiers | 14 | 14060000117669 | 14060000117731 | 1 | 2 | BTA | PRJLANR5L14BTA0211 | |
| 14060000117742 | L14/dossiers | 14 | 14060000117669 | 14060000117741 | 1 | 2 | BTA | PRJLSNR5S219BTA0007 | |
| 14060000117753 | L14/dossiers | 14 | 14060000117669 | 14060000117752 | 1 | 2 | BTA | PRJLANR5L14BTA0238 | |
| 14060000117785 | L14/dossiers | 14 | 14060000117766 | 14060000117784 | 1 | 2 | BTA | PRJLANR5L14BTA0801 | |
| 14060000117797 | L14/dossiers | 14 | 14060000117766 | 14060000117796 | 1 | 2 | BTA | PRJLSNR5S259BTA0183 | |
| 14060000117811 | L14/dossiers | 14 | 14060000117766 | 14060000117810 | 1 | 2 | BTA | PRJLANR5L14BTA0806 | |
| 14060000117815 | L14/dossiers | 14 | 14060000117766 | 14060000117814 | 1 | 2 | BTA | PRJLSNR5S259BTA0184 | |
| 14060000117872 | L14/dossiers | 14 | 14060000117858 | 14060000117871 | 1 | 2 | BTA | PRJLSNR5S199BTA0011 | |
| 14060000117886 | L14/dossiers | 14 | 14060000117858 | 14060000117885 | 1 | 2 | BTA | PRJLANR5L14BTA0036 | |
| 14060000117939 | L14/dossiers | 14 | 14060000117920 | 14060000117938 | 1 | 2 | BTA | PIONANR5L14BTA0845 | |
| 14060000117951 | L14/dossiers | 14 | 14060000117920 | 14060000117950 | 1 | 2 | BTA | PIONSNR5S279BTA0045 |