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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000130511 | L15/dossiers | 15 | 15060000130146 | 15060000130510 | 1 | 2 | BTA | PRJLSNR5S299BTA0026 | |
| 15060000130534 | L15/dossiers | 15 | 15060000130146 | 15060000130533 | 1 | 2 | BTA | PRJLANR5L15BTA0049 | |
| 15060000130535 | L15/dossiers | 15 | 15060000130146 | 15060000130533 | 2 | 2 | TAP | PRJLANR5L15TAP0049 | |
| 15060000130545 | L15/dossiers | 15 | 15060000130146 | 15060000130544 | 1 | 2 | BTA | PRJLSNR5S299BTA0032 | |
| 15060000130555 | L15/dossiers | 15 | 15060000130146 | 15060000130554 | 1 | 2 | BTA | PRJLANR5L15BTA0065 | |
| 15060000130556 | L15/dossiers | 15 | 15060000130146 | 15060000130554 | 2 | 2 | TAP | PRJLANR5L15TAP0065 | |
| 15060000130896 | L15/dossiers | 15 | 15060000130879 | 15060000130895 | 1 | 2 | BTA | PIONANR5L15BTA0255 | |
| 15060000130918 | L15/dossiers | 15 | 15060000130897 | 15060000130917 | 1 | 2 | BTA | PRJLSNR5S279BTA0115 | |
| 15060000130949 | L15/dossiers | 15 | 15060000130897 | 15060000130948 | 1 | 2 | BTA | PRJLANR5L15BTA0019 | |
| 15060000130963 | L15/dossiers | 15 | 15060000130897 | 15060000130962 | 1 | 2 | BTA | PRJLANR5L15BTA0025 | |
| 15060000130967 | L15/dossiers | 15 | 15060000130897 | 15060000130966 | 1 | 2 | BTA | PRJLSNR5S299BTA0006 | |
| 15060000131204 | L15/dossiers | 15 | 15060000131186 | 15060000131203 | 1 | 2 | BTA | PRJLANR5L15BTA0023 | |
| 15060000131216 | L15/dossiers | 15 | 15060000131186 | 15060000131215 | 1 | 2 | BTA | PRJLSNR5S299BTA0035 | |
| 15060000131242 | L15/dossiers | 15 | 15060000131226 | 15060000131241 | 1 | 2 | BTA | PIONANR5L15BTA0027 | |
| 15060000131262 | L15/dossiers | 15 | 15060000131243 | 15060000131261 | 1 | 2 | BTA | PRJLANR5L15BTA0057 | |
| 15060000131274 | L15/dossiers | 15 | 15060000131243 | 15060000131273 | 1 | 2 | BTA | PRJLSNR5S299BTA0063 | |
| 15060000131533 | L15/dossiers | 15 | 15060000131501 | 15060000131532 | 1 | 2 | BTA | PRJLANR5L15BTA0024 | |
| 15060000131551 | L15/dossiers | 15 | 15060000131501 | 15060000131550 | 1 | 2 | BTA | PRJLSNR5S299BTA0011 | |
| 15060000131580 | L15/dossiers | 15 | 15060000131501 | 15060000131579 | 1 | 2 | BTA | PRJLANR5L15BTA0040 | |
| 15060000131581 | L15/dossiers | 15 | 15060000131501 | 15060000131579 | 2 | 2 | TAP | PRJLANR5L15TAP0040 | |
| 15060000131591 | L15/dossiers | 15 | 15060000131501 | 15060000131590 | 1 | 2 | BTA | PRJLSNR5S299BTA0030 | |
| 15060000131601 | L15/dossiers | 15 | 15060000131501 | 15060000131600 | 1 | 2 | BTA | PRJLANR5L15BTA0062 | |
| 15060000131602 | L15/dossiers | 15 | 15060000131501 | 15060000131600 | 2 | 2 | TAP | PRJLANR5L15TAP0062 | |
| 15060000131743 | L15/dossiers | 15 | 15060000131725 | 15060000131742 | 1 | 2 | BTA | PRJLANR5L15BTA0054 | |
| 15060000131755 | L15/dossiers | 15 | 15060000131725 | 15060000131754 | 1 | 2 | BTA | PRJLSNR5S299BTA0048 | |
| 15060000131776 | L15/dossiers | 15 | 15060000131758 | 15060000131775 | 1 | 2 | BTA | PRJLANR5L15BTA0053 | |
| 15060000131788 | L15/dossiers | 15 | 15060000131758 | 15060000131787 | 1 | 2 | BTA | PRJLSNR5S299BTA0047 | |
| 15060000131878 | L15/dossiers | 15 | 15060000131862 | 15060000131877 | 1 | 2 | BTA | RIONANR5L15BTA0026 | |
| 15060000131926 | L15/dossiers | 15 | 15060000131910 | 15060000131925 | 1 | 2 | BTA | PIONANR5L15BTA0043 | |
| 15060000131927 | L15/dossiers | 15 | 15060000131910 | 15060000131925 | 2 | 2 | TAP | PIONANR5L15TAP0043 | |
| 15060000131939 | L15/dossiers | 15 | 15060000131910 | 15060000131938 | 1 | 2 | BTA | PIONSNR5S299BTA0052 | |
| 15060000132074 | L15/dossiers | 15 | 15060000132048 | 15060000132073 | 1 | 2 | BTA | PRJLANR5L15BTA0028 | |
| 15060000132091 | L15/dossiers | 15 | 15060000132048 | 15060000132090 | 1 | 2 | BTA | PRJLSNR5S299BTA0017 | |
| 15060000132114 | L15/dossiers | 15 | 15060000132048 | 15060000132113 | 1 | 2 | BTA | PRJLANR5L15BTA0050 | |
| 15060000132115 | L15/dossiers | 15 | 15060000132048 | 15060000132113 | 2 | 2 | TAP | PRJLANR5L15TAP0050 | |
| 15060000132125 | L15/dossiers | 15 | 15060000132048 | 15060000132124 | 1 | 2 | BTA | PRJLSNR5S299BTA0033 | |
| 15060000132135 | L15/dossiers | 15 | 15060000132048 | 15060000132134 | 1 | 2 | BTA | PRJLANR5L15BTA0066 | |
| 15060000132136 | L15/dossiers | 15 | 15060000132048 | 15060000132134 | 2 | 2 | TAP | PRJLANR5L15TAP0066 | |
| 15060000132180 | L15/dossiers | 15 | 15060000132150 | 15060000132179 | 1 | 2 | BTA | PRJLANR5L15BTA0036 | |
| 15060000132181 | L15/dossiers | 15 | 15060000132150 | 15060000132179 | 2 | 2 | TAP | PRJLANR5L15TAP0036 | |
| 15060000132195 | L15/dossiers | 15 | 15060000132150 | 15060000132194 | 1 | 2 | BTA | PRJLSNR5S299BTA0044 | |
| 15060000132209 | L15/dossiers | 15 | 15060000132150 | 15060000132208 | 1 | 2 | BTA | PRJLANR5L15BTA0081 | |
| 15060000132210 | L15/dossiers | 15 | 15060000132150 | 15060000132208 | 2 | 2 | TAP | PRJLANR5L15TAP0081 | |
| 15060000132214 | L15/dossiers | 15 | 15060000132150 | 15060000132213 | 1 | 2 | BTA | PRJLSNR5S299BTA0059 | |
| 15060000132238 | L15/dossiers | 15 | 15060000132221 | 15060000132237 | 1 | 2 | BTA | PIONANR5L15BTA0044 | |
| 15060000132239 | L15/dossiers | 15 | 15060000132221 | 15060000132237 | 2 | 2 | TAP | PIONANR5L15TAP0044 | |
| 15060000132436 | L15/dossiers | 15 | 15060000132422 | 15060000132435 | 1 | 2 | BTA | PIONSNR5S299BTA0008 | |
| 15060000132455 | L15/dossiers | 15 | 15060000132442 | 15060000132454 | 1 | 2 | BTA | PIONSNR5S299BTA0007 | |
| 15060000132513 | L15/dossiers | 15 | 15060000132500 | 15060000132512 | 1 | 2 | BTA | PIONSNR5S299BTA0009 | |
| 15060000132572 | L15/dossiers | 15 | 15060000132533 | 15060000132571 | 1 | 2 | BTA | PRJLANR5L15BTA0029 |