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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000133871 | L15/dossiers | 15 | 15060000133789 | 15060000133870 | 1 | 2 | BTA | PRJLSNR5S299BTA0074 | |
| 15060000133902 | L15/dossiers | 15 | 15060000133875 | 15060000133901 | 1 | 2 | BTA | PRJLANR5L15BTA0047 | |
| 15060000133903 | L15/dossiers | 15 | 15060000133875 | 15060000133901 | 2 | 2 | TAP | PRJLANR5L15TAP0047 | |
| 15060000133916 | L15/dossiers | 15 | 15060000133875 | 15060000133915 | 1 | 2 | BTA | PRJLSNR5S299BTA0028 | |
| 15060000133939 | L15/dossiers | 15 | 15060000133875 | 15060000133938 | 1 | 2 | BTA | PRJLANR5L15BTA0063 | |
| 15060000133940 | L15/dossiers | 15 | 15060000133875 | 15060000133938 | 2 | 2 | TAP | PRJLANR5L15TAP0063 | |
| 15060000133950 | L15/dossiers | 15 | 15060000133875 | 15060000133949 | 1 | 2 | BTA | PRJLSNR5S299BTA0039 | |
| 15060000133959 | L15/dossiers | 15 | 15060000133875 | 15060000133958 | 1 | 2 | BTA | PRJLANR5L15BTA0067 | |
| 15060000133960 | L15/dossiers | 15 | 15060000133875 | 15060000133958 | 2 | 2 | TAP | PRJLANR5L15TAP0067 | |
| 15060000134023 | L15/dossiers | 15 | 15060000134003 | 15060000134022 | 1 | 2 | BTA | PRJLANR5L15BTA0278 | |
| 15060000134035 | L15/dossiers | 15 | 15060000134003 | 15060000134034 | 1 | 2 | BTA | PRJLSNR5S319BTA0114 | |
| 15060000134070 | L15/dossiers | 15 | 15060000134038 | 15060000134069 | 1 | 2 | BTA | PRJLANR5L15BTA0061 | |
| 15060000134071 | L15/dossiers | 15 | 15060000134038 | 15060000134069 | 2 | 2 | TAP | PRJLANR5L15TAP0061 | |
| 15060000134089 | L15/dossiers | 15 | 15060000134038 | 15060000134088 | 1 | 2 | BTA | PRJLSNR5S299BTA0058 | |
| 15060000134102 | L15/dossiers | 15 | 15060000134038 | 15060000134101 | 1 | 2 | BTA | PRJLANR5L15BTA0087 | |
| 15060000134103 | L15/dossiers | 15 | 15060000134038 | 15060000134101 | 2 | 2 | TAP | PRJLANR5L15TAP0087 | |
| 15060000134107 | L15/dossiers | 15 | 15060000134038 | 15060000134106 | 1 | 2 | BTA | PRJLSNR5S299BTA0066 | |
| 15060000134200 | L15/dossiers | 15 | 15060000134184 | 15060000134199 | 1 | 2 | BTA | PRJLSNR5S299BTA0034 | |
| 15060000134214 | L15/dossiers | 15 | 15060000134184 | 15060000134213 | 1 | 2 | BTA | PRJLANR5L15BTA0076 | |
| 15060000134215 | L15/dossiers | 15 | 15060000134184 | 15060000134213 | 2 | 2 | TAP | PRJLANR5L15TAP0076 | |
| 15060000134229 | L15/dossiers | 15 | 15060000134184 | 15060000134228 | 1 | 2 | BTA | PRJLSNR5S299BTA0060 | |
| 15060000134233 | L15/dossiers | 15 | 15060000134184 | 15060000134232 | 1 | 2 | BTA | PRJLANR5L15BTA0089 | |
| 15060000134234 | L15/dossiers | 15 | 15060000134184 | 15060000134232 | 2 | 2 | TAP | PRJLANR5L15TAP0089 | |
| 15060000134278 | L15/dossiers | 15 | 15060000134242 | 15060000134277 | 1 | 2 | BTA | PRJLANR5L15BTA0073 | |
| 15060000134279 | L15/dossiers | 15 | 15060000134242 | 15060000134277 | 2 | 2 | TAP | PRJLANR5L15TAP0073 | |
| 15060000134294 | L15/dossiers | 15 | 15060000134242 | 15060000134293 | 1 | 2 | BTA | PRJLSNR5S299BTA0075 | |
| 15060000134319 | L15/dossiers | 15 | 15060000134242 | 15060000134318 | 1 | 2 | BTA | PRJLANR5L15BTA0143 | |
| 15060000134320 | L15/dossiers | 15 | 15060000134242 | 15060000134318 | 2 | 2 | TAP | PRJLANR5L15TAP0143 | |
| 15060000134330 | L15/dossiers | 15 | 15060000134242 | 15060000134329 | 1 | 2 | BTA | PRJLSNR5S299BTA0147 | |
| 15060000134339 | L15/dossiers | 15 | 15060000134242 | 15060000134338 | 1 | 2 | BTA | PRJLANR5L15BTA0165 | |
| 15060000134340 | L15/dossiers | 15 | 15060000134242 | 15060000134338 | 2 | 2 | TAP | PRJLANR5L15TAP0165 | |
| 15060000134644 | L15/dossiers | 15 | 15060000134628 | 15060000134643 | 1 | 2 | BTA | PIONANR5L15BTA0071 | |
| 15060000134645 | L15/dossiers | 15 | 15060000134628 | 15060000134643 | 2 | 2 | TAP | PIONANR5L15TAP0071 | |
| 15060000134657 | L15/dossiers | 15 | 15060000134628 | 15060000134656 | 1 | 2 | BTA | PIONSNR5S299BTA0089 | |
| 15060000134669 | L15/dossiers | 15 | 15060000134628 | 15060000134668 | 1 | 2 | BTA | PIONANR5L15BTA0208 | |
| 15060000134670 | L15/dossiers | 15 | 15060000134628 | 15060000134668 | 2 | 2 | TAP | PIONANR5L15TAP0208 | |
| 15060000134680 | L15/dossiers | 15 | 15060000134628 | 15060000134679 | 1 | 2 | BTA | PIONSNR5S319BTA0042 | |
| 15060000134699 | L15/dossiers | 15 | 15060000134686 | 15060000134698 | 1 | 2 | BTA | RIONANR5L15BTA0069 | |
| 15060000134771 | L15/dossiers | 15 | 15060000134740 | 15060000134770 | 1 | 2 | BTA | PRJLANR5L15BTA0084 | |
| 15060000134772 | L15/dossiers | 15 | 15060000134740 | 15060000134770 | 2 | 2 | TAP | PRJLANR5L15TAP0084 | |
| 15060000134785 | L15/dossiers | 15 | 15060000134740 | 15060000134784 | 1 | 2 | BTA | PRJLSNR5S299BTA0076 | |
| 15060000134807 | L15/dossiers | 15 | 15060000134740 | 15060000134806 | 1 | 2 | BTA | PRJLANR5L15BTA0110 | |
| 15060000134808 | L15/dossiers | 15 | 15060000134740 | 15060000134806 | 2 | 2 | TAP | PRJLANR5L15TAP0110 | |
| 15060000134818 | L15/dossiers | 15 | 15060000134740 | 15060000134817 | 1 | 2 | BTA | PRJLSNR5S299BTA0100 | |
| 15060000134827 | L15/dossiers | 15 | 15060000134740 | 15060000134826 | 1 | 2 | BTA | PRJLANR5L15BTA0113 | |
| 15060000134828 | L15/dossiers | 15 | 15060000134740 | 15060000134826 | 2 | 2 | TAP | PRJLANR5L15TAP0113 | |
| 15060000134873 | L15/dossiers | 15 | 15060000134865 | 15060000134872 | 1 | 2 | BTA | PNREANR5L15BTA0078 | |
| 15060000134892 | L15/dossiers | 15 | 15060000134874 | 15060000134891 | 1 | 2 | BTA | PIONANR5L15BTA0079 | |
| 15060000134910 | L15/dossiers | 15 | 15060000134893 | 15060000134909 | 1 | 2 | BTA | PIONANR5L15BTA0077 | |
| 15060000134959 | L15/dossiers | 15 | 15060000134940 | 15060000134958 | 1 | 2 | BTA | PIONANR5L15BTA0080 |