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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000177205 | L15/dossiers | 15 | 15060000177153 | 15060000177204 | 1 | 2 | BTA | PRJLANR5L15BTA0664 | |
| 15060000177206 | L15/dossiers | 15 | 15060000177153 | 15060000177204 | 2 | 2 | TAP | PRJLANR5L15TAP0664 | |
| 15060000177411 | L15/dossiers | 15 | 15060000177398 | 15060000177410 | 1 | 2 | BTA | PIONSNR5S379BTA0004 | |
| 15060000177457 | L15/dossiers | 15 | 15060000177424 | 15060000177456 | 1 | 2 | BTA | PRJLANR5L15BTA0622 | |
| 15060000177458 | L15/dossiers | 15 | 15060000177424 | 15060000177456 | 2 | 2 | TAP | PRJLANR5L15TAP0622 | |
| 15060000177470 | L15/dossiers | 15 | 15060000177424 | 15060000177469 | 1 | 2 | BTA | PRJLSNR5S359BTA0131 | |
| 15060000177492 | L15/dossiers | 15 | 15060000177424 | 15060000177491 | 1 | 2 | BTA | PRJLANR5L15BTA0646 | |
| 15060000177493 | L15/dossiers | 15 | 15060000177424 | 15060000177491 | 2 | 2 | TAP | PRJLANR5L15TAP0646 | |
| 15060000177503 | L15/dossiers | 15 | 15060000177424 | 15060000177502 | 1 | 2 | BTA | PRJLSNR5S359BTA0146 | |
| 15060000177513 | L15/dossiers | 15 | 15060000177424 | 15060000177512 | 1 | 2 | BTA | PRJLANR5L15BTA0653 | |
| 15060000177514 | L15/dossiers | 15 | 15060000177424 | 15060000177512 | 2 | 2 | TAP | PRJLANR5L15TAP0653 | |
| 15060000177547 | L15/dossiers | 15 | 15060000177521 | 15060000177546 | 1 | 2 | BTA | PRJLANR5L15BTA0609 | |
| 15060000177548 | L15/dossiers | 15 | 15060000177521 | 15060000177546 | 2 | 2 | TAP | PRJLANR5L15TAP0609 | |
| 15060000177559 | L15/dossiers | 15 | 15060000177521 | 15060000177558 | 1 | 2 | BTA | PRJLSNR5S359BTA0107 | |
| 15060000177574 | L15/dossiers | 15 | 15060000177521 | 15060000177573 | 1 | 2 | BTA | PRJLANR5L15BTA0614 | |
| 15060000177575 | L15/dossiers | 15 | 15060000177521 | 15060000177573 | 2 | 2 | TAP | PRJLANR5L15TAP0614 | |
| 15060000177578 | L15/dossiers | 15 | 15060000177521 | 15060000177577 | 1 | 2 | BTA | PRJLSNR5S359BTA0118 | |
| 15060000177655 | L15/dossiers | 15 | 15060000177636 | 15060000177654 | 1 | 2 | BTA | PIONANR5L15BTA0639 | |
| 15060000177656 | L15/dossiers | 15 | 15060000177636 | 15060000177654 | 2 | 2 | TAP | PIONANR5L15TAP0639 | |
| 15060000177667 | L15/dossiers | 15 | 15060000177636 | 15060000177666 | 1 | 2 | BTA | PIONSNR5S359BTA0155 | |
| 15060000177681 | L15/dossiers | 15 | 15060000177636 | 15060000177680 | 1 | 2 | BTA | PIONANR5L15BTA0676 | |
| 15060000177682 | L15/dossiers | 15 | 15060000177636 | 15060000177680 | 2 | 2 | TAP | PIONANR5L15TAP0676 | |
| 15060000177686 | L15/dossiers | 15 | 15060000177636 | 15060000177685 | 1 | 2 | BTA | PIONSNR5S379BTA0008 | |
| 15060000177733 | L15/dossiers | 15 | 15060000177718 | 15060000177732 | 1 | 2 | BTA | PIONANR5L15BTA0630 | |
| 15060000177734 | L15/dossiers | 15 | 15060000177718 | 15060000177732 | 2 | 2 | TAP | PIONANR5L15TAP0630 | |
| 15060000177746 | L15/dossiers | 15 | 15060000177718 | 15060000177745 | 1 | 2 | BTA | PIONSNR5S379BTA0052 | |
| 15060000177787 | L15/dossiers | 15 | 15060000177771 | 15060000177786 | 1 | 2 | BTA | PIONANR5L15BTA0650 | |
| 15060000177788 | L15/dossiers | 15 | 15060000177771 | 15060000177786 | 2 | 2 | TAP | PIONANR5L15TAP0650 | |
| 15060000177800 | L15/dossiers | 15 | 15060000177771 | 15060000177799 | 1 | 2 | BTA | PIONSNR5S359BTA0160 | |
| 15060000177823 | L15/dossiers | 15 | 15060000177771 | 15060000177822 | 1 | 2 | BTA | PIONANR5L15BTA0770 | |
| 15060000177824 | L15/dossiers | 15 | 15060000177771 | 15060000177822 | 2 | 2 | TAP | PIONANR5L15TAP0770 | |
| 15060000177834 | L15/dossiers | 15 | 15060000177771 | 15060000177833 | 1 | 2 | BTA | PIONSNR5S379BTA0093 | |
| 15060000177861 | L15/dossiers | 15 | 15060000177844 | 15060000177860 | 1 | 2 | BTA | PIONANR5L15BTA0647 | |
| 15060000177862 | L15/dossiers | 15 | 15060000177844 | 15060000177860 | 2 | 2 | TAP | PIONANR5L15TAP0647 | |
| 15060000177874 | L15/dossiers | 15 | 15060000177844 | 15060000177873 | 1 | 2 | BTA | PIONSNR5S359BTA0157 | |
| 15060000177888 | L15/dossiers | 15 | 15060000177844 | 15060000177887 | 1 | 2 | BTA | PIONANR5L15BTA0694 | |
| 15060000177889 | L15/dossiers | 15 | 15060000177844 | 15060000177887 | 2 | 2 | TAP | PIONANR5L15TAP0694 | |
| 15060000177893 | L15/dossiers | 15 | 15060000177844 | 15060000177892 | 1 | 2 | BTA | RAPPSNR5S379BTA0042 | |
| 15060000177916 | L15/dossiers | 15 | 15060000177900 | 15060000177915 | 1 | 2 | BTA | PIONANR5L15BTA0649 | |
| 15060000177917 | L15/dossiers | 15 | 15060000177900 | 15060000177915 | 2 | 2 | TAP | PIONANR5L15TAP0649 | |
| 15060000177929 | L15/dossiers | 15 | 15060000177900 | 15060000177928 | 1 | 2 | BTA | PIONSNR5S359BTA0159 | |
| 15060000177953 | L15/dossiers | 15 | 15060000177900 | 15060000177952 | 1 | 2 | BTA | PIONANR5L15BTA0769 | |
| 15060000177954 | L15/dossiers | 15 | 15060000177900 | 15060000177952 | 2 | 2 | TAP | PIONANR5L15TAP0769 | |
| 15060000177965 | L15/dossiers | 15 | 15060000177900 | 15060000177964 | 1 | 2 | BTA | PIONSNR5S379BTA0092 | |
| 15060000178064 | L15/dossiers | 15 | 15060000178051 | 15060000178063 | 1 | 2 | BTA | PRJLSNR5S359BTA0138 | |
| 15060000178191 | L15/dossiers | 15 | 15060000178176 | 15060000178190 | 1 | 2 | BTA | PRJLSNR5S359BTA0144 | |
| 15060000178254 | L15/dossiers | 15 | 15060000178176 | 15060000178253 | 1 | 2 | BTA | PRJLANR5L15BTA0738 | |
| 15060000178255 | L15/dossiers | 15 | 15060000178176 | 15060000178253 | 2 | 2 | TAP | PRJLANR5L15TAP0738 | |
| 15060000178273 | L15/dossiers | 15 | 15060000178176 | 15060000178272 | 1 | 2 | BTA | PRJLANR5L15BTA0790 | |
| 15060000178274 | L15/dossiers | 15 | 15060000178176 | 15060000178272 | 2 | 2 | TAP | PRJLANR5L15TAP0790 |