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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000135525 | L14/dossiers | 14 | 14060000135487 | 14060000135524 | 1 | 2 | BTA | PRJLSNR5S259BTA0129 | |
| 14060000135542 | L14/dossiers | 14 | 14060000135528 | 14060000135541 | 1 | 2 | BTA | PIONSNR5S219BTA0011 | |
| 14060000135585 | L14/dossiers | 14 | 14060000135571 | 14060000135584 | 1 | 2 | BTA | PIONSNR5S259BTA0081 | |
| 14060000135600 | L14/dossiers | 14 | 14060000135571 | 14060000135599 | 1 | 2 | BTA | PIONANR5L14BTA0689 | |
| 14060000135625 | L14/dossiers | 14 | 14060000135616 | 14060000135624 | 1 | 2 | BTA | RIONANR5L14BTA0934 | |
| 14060000135649 | L14/dossiers | 14 | 14060000135634 | 14060000135648 | 1 | 2 | BTA | PIONANR5L14BTA0469 | |
| 14060000135661 | L14/dossiers | 14 | 14060000135634 | 14060000135660 | 1 | 2 | BTA | PIONSNR5S239BTA0089 | |
| 14060000135687 | L14/dossiers | 14 | 14060000135674 | 14060000135686 | 1 | 2 | BTA | PIONSNR5S279BTA0056 | |
| 14060000135771 | L14/dossiers | 14 | 14060000135758 | 14060000135770 | 1 | 2 | BTA | PIONSNR5S279BTA0006 | |
| 14060000135787 | L14/dossiers | 14 | 14060000135758 | 14060000135786 | 1 | 2 | BTA | PIONANR5L14BTA0882 | |
| 14060000135797 | L14/dossiers | 14 | 14060000135758 | 14060000135796 | 1 | 2 | BTA | PIONSNR5S279BTA0089 | |
| 14060000135840 | L14/dossiers | 14 | 14060000135827 | 14060000135839 | 1 | 2 | BTA | PIONSNR5S219BTA0013 | |
| 14060000135866 | L14/dossiers | 14 | 14060000135851 | 14060000135865 | 1 | 2 | BTA | PRJLSNR5S239BTA0021 | |
| 14060000135878 | L14/dossiers | 14 | 14060000135851 | 14060000135877 | 1 | 2 | BTA | PRJLANR5L14BTA0490 | |
| 14060000135919 | L14/dossiers | 14 | 14060000135902 | 14060000135918 | 1 | 2 | BTA | PIONANR5L14BTA0051 | |
| 14060000135931 | L14/dossiers | 14 | 14060000135902 | 14060000135930 | 1 | 2 | BTA | PIONSNR5S199BTA0204 | |
| 14060000135943 | L14/dossiers | 14 | 14060000135902 | 14060000135942 | 1 | 2 | BTA | PIONANR5L14BTA0271 | |
| 14060000136016 | L14/dossiers | 14 | 14060000135993 | 14060000136015 | 1 | 2 | BTA | PRJLANR5L14BTA0081 | |
| 14060000136029 | L14/dossiers | 14 | 14060000135993 | 14060000136028 | 1 | 2 | BTA | PRJLSNR5S199BTA0090 | |
| 14060000136043 | L14/dossiers | 14 | 14060000135993 | 14060000136042 | 1 | 2 | BTA | PRJLSNR5S199BTA0098 | |
| 14060000136046 | L14/dossiers | 14 | 14060000135993 | 14060000136045 | 1 | 2 | BTA | PRJLANR5L14BTA0086 | |
| 14060000136109 | L14/dossiers | 14 | 14060000136094 | 14060000136108 | 1 | 2 | BTA | PIONANR5L14BTA0286 | |
| 14060000136121 | L14/dossiers | 14 | 14060000136094 | 14060000136120 | 1 | 2 | BTA | PIONSNR5S219BTA0081 | |
| 14060000136216 | L14/dossiers | 14 | 14060000136181 | 14060000136215 | 1 | 2 | BTA | PRJLANR5L14BTA0828 | |
| 14060000136245 | L14/dossiers | 14 | 14060000136181 | 14060000136244 | 1 | 2 | BTA | PRJLSNR5S279BTA0036 | |
| 14060000136260 | L14/dossiers | 14 | 14060000136181 | 14060000136259 | 1 | 2 | BTA | PRJLANR5L14BTA0867 | |
| 14060000136264 | L14/dossiers | 14 | 14060000136181 | 14060000136263 | 1 | 2 | BTA | PRJLSNR5S279BTA0054 | |
| 14060000136416 | L14/dossiers | 14 | 14060000136398 | 14060000136415 | 1 | 2 | BTA | PIONANR5L14BTA0759 | |
| 14060000136428 | L14/dossiers | 14 | 14060000136398 | 14060000136427 | 1 | 2 | BTA | PIONSNR5S259BTA0190 | |
| 14060000136439 | L14/dossiers | 14 | 14060000136398 | 14060000136438 | 1 | 2 | BTA | PIONANR5L14BTA0869 | |
| 14060000136456 | L14/dossiers | 14 | 14060000136442 | 14060000136455 | 1 | 2 | BTA | PRJLSNR5S259BTA0061 | |
| 14060000136469 | L14/dossiers | 14 | 14060000136442 | 14060000136468 | 1 | 2 | BTA | PRJLANR5L14BTA0698 | |
| 14060000136512 | L14/dossiers | 14 | 14060000136502 | 14060000136511 | 1 | 2 | BTA | RIONANR5L14BTA0777 | |
| 14060000136533 | L14/dossiers | 14 | 14060000136520 | 14060000136532 | 1 | 2 | BTA | PIONSNR5S219BTA0010 | |
| 14060000136562 | L14/dossiers | 14 | 14060000136544 | 14060000136561 | 1 | 2 | BTA | PRJLANR5L14BTA0166 | |
| 14060000136575 | L14/dossiers | 14 | 14060000136544 | 14060000136574 | 1 | 2 | BTA | PRJLSNR5S219BTA0144 | |
| 14060000136645 | L14/dossiers | 14 | 14060000136623 | 14060000136644 | 1 | 2 | BTA | PIONANR5L14BTA0323 | |
| 14060000136657 | L14/dossiers | 14 | 14060000136623 | 14060000136656 | 1 | 2 | BTA | PIONSNR5S219BTA0107 | |
| 14060000136694 | L14/dossiers | 14 | 14060000136682 | 14060000136693 | 1 | 2 | BTA | RIONANR5L14BTA0932 | |
| 14060000136761 | L14/dossiers | 14 | 14060000136747 | 14060000136760 | 1 | 2 | BTA | PRJLSNR5S259BTA0086 | |
| 14060000136776 | L14/dossiers | 14 | 14060000136747 | 14060000136775 | 1 | 2 | BTA | PRJLANR5L14BTA0681 | |
| 14060000136821 | L14/dossiers | 14 | 14060000136803 | 14060000136820 | 1 | 2 | BTA | PRJLANR5L14BTA0781 | |
| 14060000136833 | L14/dossiers | 14 | 14060000136803 | 14060000136832 | 1 | 2 | BTA | PRJLSNR5S259BTA0187 | |
| 14060000136911 | L14/dossiers | 14 | 14060000136896 | 14060000136910 | 1 | 2 | BTA | PRJLSNR5S198BTA0125 | |
| 14060000136931 | L14/dossiers | 14 | 14060000136896 | 14060000136930 | 1 | 2 | BTA | PRJLANR5L14BTA0009 | |
| 14060000136947 | L14/dossiers | 14 | 14060000136934 | 14060000136946 | 1 | 2 | BTA | PIONSNR5S279BTA0100 | |
| 14060000136991 | L14/dossiers | 14 | 14060000136974 | 14060000136990 | 1 | 2 | BTA | PIONANR5L14BTA0150 | |
| 14060000137009 | L14/dossiers | 14 | 14060000136992 | 14060000137008 | 1 | 2 | BTA | PRJLANR5L14BTA0892 | |
| 14060000137021 | L14/dossiers | 14 | 14060000136992 | 14060000137020 | 1 | 2 | BTA | PRJLSNR5S279BTA0116 | |
| 14060000137038 | L14/dossiers | 14 | 14060000137024 | 14060000137037 | 1 | 2 | BTA | PIONSNR5S259BTA0007 |