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 |
|---|---|---|---|---|---|---|---|---|---|
| 16060000093413 | L16/dossiers | 16 | 16060000093400 | 16060000093412 | 1 | 2 | BTA | PRJLSNR5S359BTA0108 | |
| 16060000093433 | L16/dossiers | 16 | 16060000093400 | 16060000093432 | 1 | 2 | BTA | PRJLANR5L15BTA0642 | |
| 16060000093434 | L16/dossiers | 16 | 16060000093400 | 16060000093432 | 2 | 2 | TAP | PRJLANR5L15TAP0642 | |
| 16060000093448 | L16/dossiers | 16 | 16060000093400 | 16060000093447 | 1 | 2 | BTA | PRJLSNR5S359BTA0154 | |
| 16060000093452 | L16/dossiers | 16 | 16060000093400 | 16060000093451 | 1 | 2 | BTA | PRJLANR5L15BTA0664 | |
| 16060000093453 | L16/dossiers | 16 | 16060000093400 | 16060000093451 | 2 | 2 | TAP | PRJLANR5L15TAP0664 | |
| 16060000093472 | L16/dossiers | 16 | 16060000093459 | 16060000093471 | 1 | 2 | BTA | PIONSNR5S379BTA0004 | |
| 16060000093502 | L16/dossiers | 16 | 16060000093483 | 16060000093501 | 1 | 2 | BTA | PIONANR5L15BTA0639 | |
| 16060000093503 | L16/dossiers | 16 | 16060000093483 | 16060000093501 | 2 | 2 | TAP | PIONANR5L15TAP0639 | |
| 16060000093514 | L16/dossiers | 16 | 16060000093483 | 16060000093513 | 1 | 2 | BTA | PIONSNR5S359BTA0155 | |
| 16060000093528 | L16/dossiers | 16 | 16060000093483 | 16060000093527 | 1 | 2 | BTA | PIONANR5L15BTA0676 | |
| 16060000093529 | L16/dossiers | 16 | 16060000093483 | 16060000093527 | 2 | 2 | TAP | PIONANR5L15TAP0676 | |
| 16060000093533 | L16/dossiers | 16 | 16060000093483 | 16060000093532 | 1 | 2 | BTA | PIONSNR5S379BTA0008 | |
| 16060000093552 | L16/dossiers | 16 | 16060000093539 | 16060000093551 | 1 | 2 | BTA | PRJLSNR5S359BTA0138 | |
| 16060000093572 | L16/dossiers | 16 | 16060000093539 | 16060000093571 | 1 | 2 | BTA | PRJLANR5L16BTA0031 | |
| 16060000093592 | L16/dossiers | 16 | 16060000093575 | 16060000093591 | 1 | 2 | BTA | PRJLANR5L15BTA0806 | |
| 16060000093603 | L16/dossiers | 16 | 16060000093575 | 16060000093602 | 1 | 2 | BTA | PRJLSNR5S399BTA0043 | |
| 16060000093620 | L16/dossiers | 16 | 16060000093606 | 16060000093619 | 1 | 2 | BTA | PRJLSNR5S359BTA0137 | |
| 16060000093641 | L16/dossiers | 16 | 16060000093606 | 16060000093640 | 1 | 2 | BTA | PRJLANR5L16BTA0069 | |
| 16060000093657 | L16/dossiers | 16 | 16060000093644 | 16060000093656 | 1 | 2 | BTA | PIONSNR5S379BTA0007 | |
| 16060000093691 | L16/dossiers | 16 | 16060000093668 | 16060000093690 | 1 | 2 | BTA | PRJLANR5L15BTA0774 | |
| 16060000093703 | L16/dossiers | 16 | 16060000093668 | 16060000093702 | 1 | 2 | BTA | PRJLSNR5S379BTA0134 | |
| 16060000093725 | L16/dossiers | 16 | 16060000093706 | 16060000093724 | 1 | 2 | BTA | PRJLANR5L15BTA0771 | |
| 16060000093737 | L16/dossiers | 16 | 16060000093706 | 16060000093736 | 1 | 2 | BTA | PRJLSNR5S379BTA0133 | |
| 16060000093795 | L16/dossiers | 16 | 16060000093740 | 16060000093794 | 1 | 2 | BTA | PIONSNR5S379BTA0027 | |
| 16060000093823 | L16/dossiers | 16 | 16060000093806 | 16060000093822 | 1 | 2 | BTA | PRJLANR5L15BTA0804 | |
| 16060000093834 | L16/dossiers | 16 | 16060000093806 | 16060000093833 | 1 | 2 | BTA | PRJLSNR5S399BTA0024 | |
| 16060000093854 | L16/dossiers | 16 | 16060000093837 | 16060000093853 | 1 | 2 | BTA | PIONANR5L15BTA0705 | |
| 16060000093855 | L16/dossiers | 16 | 16060000093837 | 16060000093853 | 2 | 2 | TAP | PIONANR5L15TAP0705 | |
| 16060000093866 | L16/dossiers | 16 | 16060000093837 | 16060000093865 | 1 | 2 | BTA | PIONSNR5S399BTA0005 | |
| 16060000093878 | L16/dossiers | 16 | 16060000093837 | 16060000093877 | 1 | 2 | BTA | PIONANR5L16BTA0060 | |
| 16060000093879 | L16/dossiers | 16 | 16060000093837 | 16060000093877 | 2 | 2 | TAP | PIONANR5L16TAP0060 | |
| 16060000093900 | L16/dossiers | 16 | 16060000093882 | 16060000093899 | 1 | 2 | BTA | PRJLANR5L15BTA0805 | |
| 16060000093911 | L16/dossiers | 16 | 16060000093882 | 16060000093910 | 1 | 2 | BTA | PRJLSNR5S399BTA0013 | |
| 16060000093949 | L16/dossiers | 16 | 16060000093914 | 16060000093948 | 1 | 2 | BTA | PIONSNR5S379BTA0066 | |
| 16060000093972 | L16/dossiers | 16 | 16060000093960 | 16060000093971 | 1 | 2 | BTA | PIONSNR5S379BTA0067 | |
| 16060000093992 | L16/dossiers | 16 | 16060000093960 | 16060000093991 | 1 | 2 | BTA | PIONANR5L16BTA0018 | |
| 16060000093993 | L16/dossiers | 16 | 16060000093960 | 16060000093991 | 2 | 2 | TAP | PIONANR5L16TAP0018 | |
| 16060000094002 | L16/dossiers | 16 | 16060000093960 | 16060000094001 | 1 | 2 | BTA | PIONSNR5S399BTA0031 | |
| 16060000094013 | L16/dossiers | 16 | 16060000093960 | 16060000094012 | 1 | 2 | BTA | PIONANR5L16BTA0071 | |
| 16060000094014 | L16/dossiers | 16 | 16060000093960 | 16060000094012 | 2 | 2 | TAP | PIONANR5L16TAP0071 | |
| 16060000094030 | L16/dossiers | 16 | 16060000094017 | 16060000094029 | 1 | 2 | BTA | PIONSNR5S379BTA0111 | |
| 16060000094058 | L16/dossiers | 16 | 16060000094041 | 16060000094057 | 1 | 2 | BTA | PIONANR5L15BTA0748 | |
| 16060000094069 | L16/dossiers | 16 | 16060000094041 | 16060000094068 | 1 | 2 | BTA | PIONSNR5S399BTA0050 | |
| 16060000094087 | L16/dossiers | 16 | 16060000094075 | 16060000094086 | 1 | 2 | BTA | PRJLSNR5S399BTA0060 | |
| 16060000094101 | L16/dossiers | 16 | 16060000094075 | 16060000094100 | 1 | 2 | BTA | PRJLANR5L16BTA0121 | |
| 16060000094122 | L16/dossiers | 16 | 16060000094104 | 16060000094121 | 1 | 2 | BTA | PRJLANR5L15BTA0775 | |
| 16060000094134 | L16/dossiers | 16 | 16060000094104 | 16060000094133 | 1 | 2 | BTA | PRJLSNR5S379BTA0131 | |
| 16060000094149 | L16/dossiers | 16 | 16060000094137 | 16060000094148 | 1 | 2 | BTA | PIONSNR5S379BTA0087 | |
| 16060000094174 | L16/dossiers | 16 | 16060000094160 | 16060000094173 | 1 | 2 | BTA | PIONSNR5S379BTA0113 |