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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000107350 | L14/dossiers | 14 | 14060000107321 | 14060000107349 | 1 | 2 | BTA | PRJLSNR5S199BTA0026 | |
| 14060000107401 | L14/dossiers | 14 | 14060000107385 | 14060000107400 | 1 | 2 | BTA | PIONANR5L14BTA0305 | |
| 14060000107423 | L14/dossiers | 14 | 14060000107409 | 14060000107422 | 1 | 2 | BTA | PRJLSNR5S259BTA0029 | |
| 14060000107437 | L14/dossiers | 14 | 14060000107409 | 14060000107436 | 1 | 2 | BTA | PRJLANR5L14BTA0647 | |
| 14060000107455 | L14/dossiers | 14 | 14060000107440 | 14060000107454 | 1 | 2 | BTA | PRJLANR5L14BTA0480 | |
| 14060000107467 | L14/dossiers | 14 | 14060000107440 | 14060000107466 | 1 | 2 | BTA | PRJLSNR5S239BTA0095 | |
| 14060000107500 | L14/dossiers | 14 | 14060000107485 | 14060000107499 | 1 | 2 | BTA | PRJLSNR5S219BTA0087 | |
| 14060000107516 | L14/dossiers | 14 | 14060000107485 | 14060000107515 | 1 | 2 | BTA | PRJLANR5L14BTA0333 | |
| 14060000107530 | L14/dossiers | 14 | 14060000107485 | 14060000107529 | 1 | 2 | BTA | PRJLSNR5S219BTA0120 | |
| 14060000107534 | L14/dossiers | 14 | 14060000107485 | 14060000107533 | 1 | 2 | BTA | PRJLANR5L14BTA0337 | |
| 14060000107566 | L14/dossiers | 14 | 14060000107550 | 14060000107565 | 1 | 2 | BTA | PIONANR5L14BTA0483 | |
| 14060000107579 | L14/dossiers | 14 | 14060000107550 | 14060000107578 | 1 | 2 | BTA | PIONSNR5S259BTA0050 | |
| 14060000107636 | L14/dossiers | 14 | 14060000107614 | 14060000107635 | 1 | 2 | BTA | PIONANR5L14BTA0540 | |
| 14060000107658 | L14/dossiers | 14 | 14060000107614 | 14060000107657 | 1 | 2 | BTA | PIONSNR5S239BTA0140 | |
| 14060000107672 | L14/dossiers | 14 | 14060000107614 | 14060000107671 | 1 | 2 | BTA | PIONANR5L14BTA0588 | |
| 14060000107676 | L14/dossiers | 14 | 14060000107614 | 14060000107675 | 1 | 2 | BTA | PIONSNR5S259BTA0002 | |
| 14060000107709 | L14/dossiers | 14 | 14060000107694 | 14060000107708 | 1 | 2 | BTA | PRJLANR5L14BTA0422 | |
| 14060000107721 | L14/dossiers | 14 | 14060000107694 | 14060000107720 | 1 | 2 | BTA | PRJLSNR5S239BTA0051 | |
| 14060000107830 | L14/dossiers | 14 | 14060000107748 | 14060000107829 | 1 | 2 | BTA | PRJLANR5L14BTA0473 | |
| 14060000107859 | L14/dossiers | 14 | 14060000107748 | 14060000107858 | 1 | 2 | BTA | PRJLSNR5S239BTA0099 | |
| 14060000107892 | L14/dossiers | 14 | 14060000107748 | 14060000107891 | 1 | 2 | BTA | PRJLANR5L14BTA0538 | |
| 14060000107903 | L14/dossiers | 14 | 14060000107748 | 14060000107902 | 1 | 2 | BTA | PRJLSNR5S239BTA0124 | |
| 14060000107915 | L14/dossiers | 14 | 14060000107748 | 14060000107914 | 1 | 2 | BTA | PRJLANR5L14BTA0565 | |
| 14060000107989 | L14/dossiers | 14 | 14060000107972 | 14060000107988 | 1 | 2 | BTA | PIONANR5L14BTA0677 | |
| 14060000108036 | L14/dossiers | 14 | 14060000108021 | 14060000108035 | 1 | 2 | BTA | PRJLSNR5S239BTA0068 | |
| 14060000108048 | L14/dossiers | 14 | 14060000108021 | 14060000108047 | 1 | 2 | BTA | PRJLANR5L14BTA0508 | |
| 14060000108077 | L14/dossiers | 14 | 14060000108051 | 14060000108076 | 1 | 2 | BTA | PIONANR5L14BTA0890 | |
| 14060000108171 | L14/dossiers | 14 | 14060000108158 | 14060000108170 | 1 | 2 | BTA | PIONSNR5S299BTA0056 | |
| 14060000108214 | L14/dossiers | 14 | 14060000108201 | 14060000108213 | 1 | 2 | BTA | PIONSNR5S279BTA0031 | |
| 14060000108271 | L14/dossiers | 14 | 14060000108253 | 14060000108270 | 1 | 2 | BTA | PRJLANR5L14BTA0637 | |
| 14060000108283 | L14/dossiers | 14 | 14060000108253 | 14060000108282 | 1 | 2 | BTA | PRJLSNR5S259BTA0093 | |
| 14060000108334 | L14/dossiers | 14 | 14060000108327 | 14060000108333 | 1 | 2 | BTA | RIONANR5L14BTA0263 | |
| 14060000108391 | L14/dossiers | 14 | 14060000108384 | 14060000108390 | 1 | 2 | BTA | RIONANR5L14BTA0721 | |
| 14060000108410 | L14/dossiers | 14 | 14060000108392 | 14060000108409 | 1 | 2 | BTA | PRJLANR5L14BTA0332 | |
| 14060000108422 | L14/dossiers | 14 | 14060000108392 | 14060000108421 | 1 | 2 | BTA | PRJLSNR5S219BTA0116 | |
| 14060000108442 | L14/dossiers | 14 | 14060000108425 | 14060000108441 | 1 | 2 | BTA | PIONANR5L14BTA0127 | |
| 14060000108458 | L14/dossiers | 14 | 14060000108443 | 14060000108457 | 1 | 2 | BTA | PIONANR5L14BTA0660 | |
| 14060000108477 | L14/dossiers | 14 | 14060000108459 | 14060000108476 | 1 | 2 | BTA | PIONANR5L14BTA0184 | |
| 14060000108532 | L14/dossiers | 14 | 14060000108518 | 14060000108531 | 1 | 2 | BTA | RIONANR5L14BTA0441 | |
| 14060000108547 | L14/dossiers | 14 | 14060000108533 | 14060000108546 | 1 | 2 | BTA | PRJLSNR5S199BTA0086 | |
| 14060000108561 | L14/dossiers | 14 | 14060000108533 | 14060000108560 | 1 | 2 | BTA | PRJLANR5L14BTA0199 | |
| 14060000108589 | L14/dossiers | 14 | 14060000108575 | 14060000108588 | 1 | 2 | BTA | PRJLSNR5S219BTA0083 | |
| 14060000108602 | L14/dossiers | 14 | 14060000108575 | 14060000108601 | 1 | 2 | BTA | PRJLANR5L14BTA0695 | |
| 14060000108621 | L14/dossiers | 14 | 14060000108605 | 14060000108620 | 1 | 2 | BTA | PRJLANR5L14BTA0702 | |
| 14060000108633 | L14/dossiers | 14 | 14060000108605 | 14060000108632 | 1 | 2 | BTA | PRJLSNR5S259BTA0135 | |
| 14060000108662 | L14/dossiers | 14 | 14060000108653 | 14060000108661 | 1 | 2 | BTA | RIONANR5L14BTA0935 | |
| 14060000108855 | L14/dossiers | 14 | 14060000108835 | 14060000108854 | 1 | 2 | BTA | PRJLANR5L14BTA0197 | |
| 14060000108867 | L14/dossiers | 14 | 14060000108835 | 14060000108866 | 1 | 2 | BTA | PRJLSNR5S219BTA0002 | |
| 14060000108881 | L14/dossiers | 14 | 14060000108835 | 14060000108880 | 1 | 2 | BTA | PRJLSNR5S219BTA0018 | |
| 14060000108885 | L14/dossiers | 14 | 14060000108835 | 14060000108884 | 1 | 2 | BTA | PRJLANR5L14BTA0232 |