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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000126292 | L14/dossiers | 14 | 14060000126250 | 14060000126291 | 1 | 2 | BTA | PRJLSNR5S199BTA0192 | |
| 14060000126316 | L14/dossiers | 14 | 14060000126250 | 14060000126315 | 1 | 2 | BTA | PRJLANR5L14BTA0191 | |
| 14060000126326 | L14/dossiers | 14 | 14060000126250 | 14060000126325 | 1 | 2 | BTA | PRJLSNR5S199BTA0210 | |
| 14060000126338 | L14/dossiers | 14 | 14060000126250 | 14060000126337 | 1 | 2 | BTA | PRJLANR5L14BTA0209 | |
| 14060000126374 | L14/dossiers | 14 | 14060000126344 | 14060000126373 | 1 | 2 | BTA | PRJLSNR5S199BTA0214 | |
| 14060000126410 | L14/dossiers | 14 | 14060000126344 | 14060000126409 | 1 | 2 | BTA | PRJLANR5L14BTA0282 | |
| 14060000126420 | L14/dossiers | 14 | 14060000126344 | 14060000126419 | 1 | 2 | BTA | PRJLSNR5S219BTA0101 | |
| 14060000126433 | L14/dossiers | 14 | 14060000126344 | 14060000126432 | 1 | 2 | BTA | PRJLANR5L14BTA0369 | |
| 14060000126447 | L14/dossiers | 14 | 14060000126344 | 14060000126446 | 1 | 2 | BTA | PRJLSNR5S219BTA0168 | |
| 14060000126451 | L14/dossiers | 14 | 14060000126344 | 14060000126450 | 1 | 2 | BTA | PRJLANR5L14BTA0398 | |
| 14060000126554 | L14/dossiers | 14 | 14060000126541 | 14060000126553 | 1 | 2 | BTA | PIONSNR5S219BTA0104 | |
| 14060000126622 | L14/dossiers | 14 | 14060000126581 | 14060000126621 | 1 | 2 | BTA | PRJLANR5L14BTA0525 | |
| 14060000126640 | L14/dossiers | 14 | 14060000126581 | 14060000126639 | 1 | 2 | BTA | PRJLSNR5S239BTA0131 | |
| 14060000126654 | L14/dossiers | 14 | 14060000126581 | 14060000126653 | 1 | 2 | BTA | PRJLANR5L14BTA0570 | |
| 14060000126658 | L14/dossiers | 14 | 14060000126581 | 14060000126657 | 1 | 2 | BTA | PRJLSNR5S239BTA0136 | |
| 14060000126752 | L14/dossiers | 14 | 14060000126738 | 14060000126751 | 1 | 2 | BTA | PRJLSNR5S239BTA0011 | |
| 14060000126766 | L14/dossiers | 14 | 14060000126738 | 14060000126765 | 1 | 2 | BTA | PRJLANR5L14BTA0696 | |
| 14060000126817 | L14/dossiers | 14 | 14060000126803 | 14060000126816 | 1 | 2 | BTA | PIONSNR5S279BTA0011 | |
| 14060000126889 | L14/dossiers | 14 | 14060000126873 | 14060000126888 | 1 | 2 | BTA | PIONANR5L14BTA0139 | |
| 14060000126954 | L14/dossiers | 14 | 14060000126940 | 14060000126953 | 1 | 2 | BTA | PRJLSNR5S199BTA0114 | |
| 14060000126968 | L14/dossiers | 14 | 14060000126940 | 14060000126967 | 1 | 2 | BTA | PRJLANR5L14BTA0465 | |
| 14060000126987 | L14/dossiers | 14 | 14060000126971 | 14060000126986 | 1 | 2 | BTA | PIONANR5L14BTA0524 | |
| 14060000126999 | L14/dossiers | 14 | 14060000126971 | 14060000126998 | 1 | 2 | BTA | PIONSNR5S259BTA0016 | |
| 14060000127010 | L14/dossiers | 14 | 14060000126971 | 14060000127009 | 1 | 2 | BTA | PIONANR5L14BTA0607 | |
| 14060000127065 | L14/dossiers | 14 | 14060000127041 | 14060000127064 | 1 | 2 | BTA | PRJLANR5L14BTA0436 | |
| 14060000127082 | L14/dossiers | 14 | 14060000127041 | 14060000127081 | 1 | 2 | BTA | PRJLSNR5S239BTA0041 | |
| 14060000127108 | L14/dossiers | 14 | 14060000127099 | 14060000127107 | 1 | 2 | BTA | RIONANR5L14BTA0205 | |
| 14060000127239 | L14/dossiers | 14 | 14060000127226 | 14060000127238 | 1 | 2 | BTA | RIONANR5L14BTA0132 | |
| 14060000127255 | L14/dossiers | 14 | 14060000127246 | 14060000127254 | 1 | 2 | BTA | RIONANR5L14BTA0811 | |
| 14060000127322 | L14/dossiers | 14 | 14060000127309 | 14060000127321 | 1 | 2 | BTA | PRJLSNR5S199BTA0159 | |
| 14060000127336 | L14/dossiers | 14 | 14060000127309 | 14060000127335 | 1 | 2 | BTA | PRJLANR5L14BTA0293 | |
| 14060000127367 | L14/dossiers | 14 | 14060000127354 | 14060000127366 | 1 | 2 | BTA | RIONANR5L14BTA0931 | |
| 14060000127382 | L14/dossiers | 14 | 14060000127374 | 14060000127381 | 1 | 2 | BTA | RIONANR5L14BTA0753 | |
| 14060000127390 | L14/dossiers | 14 | 14060000127383 | 14060000127389 | 1 | 2 | BTA | RIONANR5L14BTA0925 | |
| 14060000127413 | L14/dossiers | 14 | 14060000127400 | 14060000127412 | 1 | 2 | BTA | PIONSNR5S279BTA0008 | |
| 14060000127428 | L14/dossiers | 14 | 14060000127400 | 14060000127427 | 1 | 2 | BTA | PIONANR5L14BTA0863 | |
| 14060000127449 | L14/dossiers | 14 | 14060000127431 | 14060000127448 | 1 | 2 | BTA | PIONANR5L14BTA0766 | |
| 14060000127473 | L14/dossiers | 14 | 14060000127460 | 14060000127472 | 1 | 2 | BTA | PIONSNR5S239BTA0075 | |
| 14060000127507 | L14/dossiers | 14 | 14060000127491 | 14060000127506 | 1 | 2 | BTA | PRJLANR5L14BTA0489 | |
| 14060000127519 | L14/dossiers | 14 | 14060000127491 | 14060000127518 | 1 | 2 | BTA | PRJLSNR5S239BTA0119 | |
| 14060000127583 | L14/dossiers | 14 | 14060000127543 | 14060000127582 | 1 | 2 | BTA | PRJLANR5L14BTA0823 | |
| 14060000127622 | L14/dossiers | 14 | 14060000127543 | 14060000127621 | 1 | 2 | BTA | PRJLSNR5S279BTA0060 | |
| 14060000127636 | L14/dossiers | 14 | 14060000127543 | 14060000127635 | 1 | 2 | BTA | PRJLANR5L14BTA0909 | |
| 14060000127640 | L14/dossiers | 14 | 14060000127543 | 14060000127639 | 1 | 2 | BTA | PRJLSNR5S279BTA0086 | |
| 14060000127714 | L14/dossiers | 14 | 14060000127688 | 14060000127713 | 1 | 2 | BTA | PIONANR5L14BTA0371 | |
| 14060000127752 | L14/dossiers | 14 | 14060000127727 | 14060000127751 | 1 | 2 | BTA | PIONANR5L14BTA0646 | |
| 14060000127768 | L14/dossiers | 14 | 14060000127727 | 14060000127767 | 1 | 2 | BTA | PIONSNR5S259BTA0096 | |
| 14060000127793 | L14/dossiers | 14 | 14060000127727 | 14060000127792 | 1 | 2 | BTA | PIONANR5L14BTA0711 | |
| 14060000127803 | L14/dossiers | 14 | 14060000127727 | 14060000127802 | 1 | 2 | BTA | PIONSNR5S259BTA0117 | |
| 14060000127814 | L14/dossiers | 14 | 14060000127727 | 14060000127813 | 1 | 2 | BTA | PIONANR5L14BTA0714 |