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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000172062 | L15/dossiers | 15 | 15060000172033 | 15060000172060 | 2 | 2 | TAP | PIONANR5L15TAP0709 | |
| 15060000172099 | L15/dossiers | 15 | 15060000172089 | 15060000172098 | 1 | 2 | BTA | RIONANR5L15BTA0562 | |
| 15060000172178 | L15/dossiers | 15 | 15060000172103 | 15060000172177 | 1 | 2 | BTA | PRJLANR5L15BTA0565 | |
| 15060000172179 | L15/dossiers | 15 | 15060000172103 | 15060000172177 | 2 | 2 | TAP | PRJLANR5L15TAP0565 | |
| 15060000172191 | L15/dossiers | 15 | 15060000172103 | 15060000172190 | 1 | 2 | BTA | PRJLSNR5S359BTA0094 | |
| 15060000172225 | L15/dossiers | 15 | 15060000172103 | 15060000172224 | 1 | 2 | BTA | PRJLANR5L15BTA0641 | |
| 15060000172226 | L15/dossiers | 15 | 15060000172103 | 15060000172224 | 2 | 2 | TAP | PRJLANR5L15TAP0641 | |
| 15060000172236 | L15/dossiers | 15 | 15060000172103 | 15060000172235 | 1 | 2 | BTA | PRJLSNR5S359BTA0143 | |
| 15060000172245 | L15/dossiers | 15 | 15060000172103 | 15060000172244 | 1 | 2 | BTA | PRJLANR5L15BTA0656 | |
| 15060000172246 | L15/dossiers | 15 | 15060000172103 | 15060000172244 | 2 | 2 | TAP | PRJLANR5L15TAP0656 | |
| 15060000172409 | L15/dossiers | 15 | 15060000172391 | 15060000172408 | 1 | 2 | BTA | PIONANR5L15BTA0556 | |
| 15060000172410 | L15/dossiers | 15 | 15060000172391 | 15060000172408 | 2 | 2 | TAP | PIONANR5L15TAP0556 | |
| 15060000172421 | L15/dossiers | 15 | 15060000172391 | 15060000172420 | 1 | 2 | BTA | PIONSNR5S359BTA0075 | |
| 15060000172434 | L15/dossiers | 15 | 15060000172391 | 15060000172433 | 1 | 2 | BTA | PIONSNR5S359BTA0092 | |
| 15060000172440 | L15/dossiers | 15 | 15060000172391 | 15060000172439 | 1 | 2 | BTA | PIONANR5L15BTA0600 | |
| 15060000172441 | L15/dossiers | 15 | 15060000172391 | 15060000172439 | 2 | 2 | TAP | PIONANR5L15TAP0600 | |
| 15060000172555 | L15/dossiers | 15 | 15060000172541 | 15060000172554 | 1 | 2 | BTA | PIONANR5L15BTA0553 | |
| 15060000172556 | L15/dossiers | 15 | 15060000172541 | 15060000172554 | 2 | 2 | TAP | PIONANR5L15TAP0553 | |
| 15060000172611 | L15/dossiers | 15 | 15060000172597 | 15060000172610 | 1 | 2 | BTA | PIONANR5L15BTA0554 | |
| 15060000172612 | L15/dossiers | 15 | 15060000172597 | 15060000172610 | 2 | 2 | TAP | PIONANR5L15TAP0554 | |
| 15060000172624 | L15/dossiers | 15 | 15060000172597 | 15060000172623 | 1 | 2 | BTA | PIONSNR5S379BTA0109 | |
| 15060000172657 | L15/dossiers | 15 | 15060000172640 | 15060000172656 | 1 | 2 | BTA | PIONANR5L15BTA0557 | |
| 15060000172658 | L15/dossiers | 15 | 15060000172640 | 15060000172656 | 2 | 2 | TAP | PIONANR5L15TAP0557 | |
| 15060000172669 | L15/dossiers | 15 | 15060000172640 | 15060000172668 | 1 | 2 | BTA | PIONSNR5S379BTA0012 | |
| 15060000172684 | L15/dossiers | 15 | 15060000172640 | 15060000172683 | 1 | 2 | BTA | PIONANR5L15BTA0734 | |
| 15060000172685 | L15/dossiers | 15 | 15060000172640 | 15060000172683 | 2 | 2 | TAP | PIONANR5L15TAP0734 | |
| 15060000172688 | L15/dossiers | 15 | 15060000172640 | 15060000172687 | 1 | 2 | BTA | PIONSNR5S379BTA0060 | |
| 15060000172723 | L15/dossiers | 15 | 15060000172699 | 15060000172722 | 1 | 2 | BTA | PIONANR5L15BTA0558 | |
| 15060000172724 | L15/dossiers | 15 | 15060000172699 | 15060000172722 | 2 | 2 | TAP | PIONANR5L15TAP0558 | |
| 15060000172735 | L15/dossiers | 15 | 15060000172699 | 15060000172734 | 1 | 2 | BTA | PIONSNR5S359BTA0163 | |
| 15060000172752 | L15/dossiers | 15 | 15060000172699 | 15060000172751 | 1 | 2 | BTA | PIONANR5L15BTA0688 | |
| 15060000172753 | L15/dossiers | 15 | 15060000172699 | 15060000172751 | 2 | 2 | TAP | PIONANR5L15TAP0688 | |
| 15060000172757 | L15/dossiers | 15 | 15060000172699 | 15060000172756 | 1 | 2 | BTA | PIONSNR5S379BTA0037 | |
| 15060000172848 | L15/dossiers | 15 | 15060000172817 | 15060000172847 | 1 | 2 | BTA | PRJLANR5L15BTA0574 | |
| 15060000172849 | L15/dossiers | 15 | 15060000172817 | 15060000172847 | 2 | 2 | TAP | PRJLANR5L15TAP0574 | |
| 15060000172861 | L15/dossiers | 15 | 15060000172817 | 15060000172860 | 1 | 2 | BTA | PRJLSNR5S359BTA0106 | |
| 15060000172876 | L15/dossiers | 15 | 15060000172817 | 15060000172875 | 1 | 2 | BTA | PRJLANR5L15BTA0645 | |
| 15060000172877 | L15/dossiers | 15 | 15060000172817 | 15060000172875 | 2 | 2 | TAP | PRJLANR5L15TAP0645 | |
| 15060000172881 | L15/dossiers | 15 | 15060000172817 | 15060000172880 | 1 | 2 | BTA | PRJLSNR5S359BTA0141 | |
| 15060000172914 | L15/dossiers | 15 | 15060000172902 | 15060000172913 | 1 | 2 | BTA | PIONSNR5S359BTA0079 | |
| 15060000172928 | L15/dossiers | 15 | 15060000172920 | 15060000172927 | 1 | 2 | BTA | RIONANR5L15BTA0550 | |
| 15060000172989 | L15/dossiers | 15 | 15060000172971 | 15060000172988 | 1 | 2 | BTA | PIONANR5L15BTA0571 | |
| 15060000172990 | L15/dossiers | 15 | 15060000172971 | 15060000172988 | 2 | 2 | TAP | PIONANR5L15TAP0571 | |
| 15060000173057 | L15/dossiers | 15 | 15060000173040 | 15060000173056 | 1 | 2 | BTA | PRJLANR5L15BTA0541 | |
| 15060000173058 | L15/dossiers | 15 | 15060000173040 | 15060000173056 | 2 | 2 | TAP | PRJLANR5L15TAP0541 | |
| 15060000173069 | L15/dossiers | 15 | 15060000173040 | 15060000173068 | 1 | 2 | BTA | PRJLSNR5S359BTA0066 | |
| 15060000173084 | L15/dossiers | 15 | 15060000173040 | 15060000173083 | 1 | 2 | BTA | PRJLANR5L15BTA0575 | |
| 15060000173085 | L15/dossiers | 15 | 15060000173040 | 15060000173083 | 2 | 2 | TAP | PRJLANR5L15TAP0575 | |
| 15060000173088 | L15/dossiers | 15 | 15060000173040 | 15060000173087 | 1 | 2 | BTA | PRJLSNR5S359BTA0080 | |
| 15060000173121 | L15/dossiers | 15 | 15060000173107 | 15060000173120 | 1 | 2 | BTA | PIONSNR5S359BTA0121 |