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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000174532 | L15/dossiers | 15 | 15060000174515 | 15060000174531 | 1 | 2 | BTA | PIONANR5L15BTA0589 | |
| 15060000174613 | L15/dossiers | 15 | 15060000174597 | 15060000174612 | 1 | 2 | BTA | PIONANR5L15BTA0587 | |
| 15060000174614 | L15/dossiers | 15 | 15060000174597 | 15060000174612 | 2 | 2 | TAP | PIONANR5L15TAP0587 | |
| 15060000174626 | L15/dossiers | 15 | 15060000174597 | 15060000174625 | 1 | 2 | BTA | PIONSNR5S379BTA0050 | |
| 15060000174669 | L15/dossiers | 15 | 15060000174643 | 15060000174668 | 1 | 2 | BTA | PIONANR5L15BTA0615 | |
| 15060000174670 | L15/dossiers | 15 | 15060000174643 | 15060000174668 | 2 | 2 | TAP | PIONANR5L15TAP0615 | |
| 15060000174681 | L15/dossiers | 15 | 15060000174643 | 15060000174680 | 1 | 2 | BTA | PIONSNR5S379BTA0025 | |
| 15060000174695 | L15/dossiers | 15 | 15060000174643 | 15060000174694 | 1 | 2 | BTA | PIONSNR5S379BTA0048 | |
| 15060000174700 | L15/dossiers | 15 | 15060000174643 | 15060000174699 | 1 | 2 | BTA | PIONANR5L15BTA0736 | |
| 15060000174701 | L15/dossiers | 15 | 15060000174643 | 15060000174699 | 2 | 2 | TAP | PIONANR5L15TAP0736 | |
| 15060000174828 | L15/dossiers | 15 | 15060000174736 | 15060000174827 | 1 | 2 | BTA | PRJLANR5L15BTA0602 | |
| 15060000174829 | L15/dossiers | 15 | 15060000174736 | 15060000174827 | 2 | 2 | TAP | PRJLANR5L15TAP0602 | |
| 15060000174843 | L15/dossiers | 15 | 15060000174736 | 15060000174842 | 1 | 2 | BTA | PRJLSNR5S359BTA0130 | |
| 15060000174860 | L15/dossiers | 15 | 15060000174736 | 15060000174859 | 1 | 2 | BTA | PRJLSNR5S359BTA0140 | |
| 15060000174864 | L15/dossiers | 15 | 15060000174736 | 15060000174863 | 1 | 2 | BTA | PRJLANR5L15BTA0651 | |
| 15060000174865 | L15/dossiers | 15 | 15060000174736 | 15060000174863 | 2 | 2 | TAP | PRJLANR5L15TAP0651 | |
| 15060000174939 | L15/dossiers | 15 | 15060000174926 | 15060000174938 | 1 | 2 | BTA | PIONSNR5S359BTA0072 | |
| 15060000174953 | L15/dossiers | 15 | 15060000174926 | 15060000174952 | 1 | 2 | BTA | PIONANR5L15BTA0583 | |
| 15060000174954 | L15/dossiers | 15 | 15060000174926 | 15060000174952 | 2 | 2 | TAP | PIONANR5L15TAP0583 | |
| 15060000174967 | L15/dossiers | 15 | 15060000174926 | 15060000174966 | 1 | 2 | BTA | PIONSNR5S359BTA0086 | |
| 15060000174970 | L15/dossiers | 15 | 15060000174926 | 15060000174969 | 1 | 2 | BTA | PIONANR5L15BTA0590 | |
| 15060000174971 | L15/dossiers | 15 | 15060000174926 | 15060000174969 | 2 | 2 | TAP | PIONANR5L15TAP0590 | |
| 15060000175029 | L15/dossiers | 15 | 15060000175017 | 15060000175028 | 1 | 2 | BTA | PIONSNR5S359BTA0096 | |
| 15060000175082 | L15/dossiers | 15 | 15060000175069 | 15060000175081 | 1 | 2 | BTA | PRJLSNR5S359BTA0093 | |
| 15060000175099 | L15/dossiers | 15 | 15060000175069 | 15060000175098 | 1 | 2 | BTA | PRJLANR5L15BTA0624 | |
| 15060000175100 | L15/dossiers | 15 | 15060000175069 | 15060000175098 | 2 | 2 | TAP | PRJLANR5L15TAP0624 | |
| 15060000175308 | L15/dossiers | 15 | 15060000175292 | 15060000175307 | 1 | 2 | BTA | PIONANR5L15BTA0785 | |
| 15060000175309 | L15/dossiers | 15 | 15060000175292 | 15060000175307 | 2 | 2 | TAP | PIONANR5L15TAP0785 | |
| 15060000175362 | L15/dossiers | 15 | 15060000175343 | 15060000175361 | 1 | 2 | BTA | PRJLANR5L15BTA0620 | |
| 15060000175373 | L15/dossiers | 15 | 15060000175343 | 15060000175372 | 1 | 2 | BTA | PRJLSNR5S379BTA0016 | |
| 15060000175460 | L15/dossiers | 15 | 15060000175447 | 15060000175459 | 1 | 2 | BTA | PIONSNR5S359BTA0095 | |
| 15060000175542 | L15/dossiers | 15 | 15060000175530 | 15060000175541 | 1 | 2 | BTA | PIONSNR5S359BTA0123 | |
| 15060000175557 | L15/dossiers | 15 | 15060000175530 | 15060000175556 | 1 | 2 | BTA | PIONANR5L15BTA0680 | |
| 15060000175558 | L15/dossiers | 15 | 15060000175530 | 15060000175556 | 2 | 2 | TAP | PIONANR5L15TAP0680 | |
| 15060000175648 | L15/dossiers | 15 | 15060000175632 | 15060000175647 | 1 | 2 | BTA | PIONANR5L15BTA0632 | |
| 15060000175833 | L15/dossiers | 15 | 15060000175814 | 15060000175832 | 1 | 2 | BTA | PIONANR5L15BTA0610 | |
| 15060000175834 | L15/dossiers | 15 | 15060000175814 | 15060000175832 | 2 | 2 | TAP | PIONANR5L15TAP0610 | |
| 15060000175845 | L15/dossiers | 15 | 15060000175814 | 15060000175844 | 1 | 2 | BTA | PIONSNR5S379BTA0015 | |
| 15060000175860 | L15/dossiers | 15 | 15060000175814 | 15060000175859 | 1 | 2 | BTA | PIONANR5L15BTA0733 | |
| 15060000175861 | L15/dossiers | 15 | 15060000175814 | 15060000175859 | 2 | 2 | TAP | PIONANR5L15TAP0733 | |
| 15060000175864 | L15/dossiers | 15 | 15060000175814 | 15060000175863 | 1 | 2 | BTA | PIONSNR5S379BTA0059 | |
| 15060000175893 | L15/dossiers | 15 | 15060000175879 | 15060000175892 | 1 | 2 | BTA | PIONANR5L15BTA0608 | |
| 15060000175909 | L15/dossiers | 15 | 15060000175894 | 15060000175908 | 1 | 2 | BTA | PIONANR5L15BTA0604 | |
| 15060000175978 | L15/dossiers | 15 | 15060000175964 | 15060000175977 | 1 | 2 | BTA | PIONANR5L15BTA0606 | |
| 15060000176002 | L15/dossiers | 15 | 15060000175986 | 15060000176001 | 1 | 2 | BTA | PIONANR5L15BTA0605 | |
| 15060000176054 | L15/dossiers | 15 | 15060000176036 | 15060000176053 | 1 | 2 | BTA | PIONANR5L15BTA0648 | |
| 15060000176055 | L15/dossiers | 15 | 15060000176036 | 15060000176053 | 2 | 2 | TAP | PIONANR5L15TAP0648 | |
| 15060000176067 | L15/dossiers | 15 | 15060000176036 | 15060000176066 | 1 | 2 | BTA | PIONSNR5S359BTA0158 | |
| 15060000176081 | L15/dossiers | 15 | 15060000176036 | 15060000176080 | 1 | 2 | BTA | PIONANR5L15BTA0695 | |
| 15060000176082 | L15/dossiers | 15 | 15060000176036 | 15060000176080 | 2 | 2 | TAP | PIONANR5L15TAP0695 |