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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000117974 | L14/dossiers | 14 | 14060000117958 | 14060000117973 | 1 | 2 | BTA | PIONANR5L14BTA0504 | |
| 14060000118006 | L14/dossiers | 14 | 14060000117990 | 14060000118005 | 1 | 2 | BTA | PIONANR5L14BTA0691 | |
| 14060000118040 | L14/dossiers | 14 | 14060000118027 | 14060000118039 | 1 | 2 | BTA | PIONSNR5S219BTA0134 | |
| 14060000118109 | L14/dossiers | 14 | 14060000118090 | 14060000118108 | 1 | 2 | BTA | RIONANR5L14BTA0143 | |
| 14060000118183 | L14/dossiers | 14 | 14060000118166 | 14060000118182 | 1 | 2 | BTA | PRJLSNR5S199BTA0075 | |
| 14060000118207 | L14/dossiers | 14 | 14060000118166 | 14060000118206 | 1 | 2 | BTA | PRJLANR5L14BTA0091 | |
| 14060000118218 | L14/dossiers | 14 | 14060000118166 | 14060000118217 | 1 | 2 | BTA | PRJLSNR5S199BTA0118 | |
| 14060000118234 | L14/dossiers | 14 | 14060000118166 | 14060000118233 | 1 | 2 | BTA | PRJLANR5L14BTA0101 | |
| 14060000118248 | L14/dossiers | 14 | 14060000118166 | 14060000118247 | 1 | 2 | BTA | PRJLSNR5S199BTA0131 | |
| 14060000118253 | L14/dossiers | 14 | 14060000118166 | 14060000118252 | 1 | 2 | BTA | PRJLANR5L14BTA0119 | |
| 14060000118289 | L14/dossiers | 14 | 14060000118269 | 14060000118288 | 1 | 2 | BTA | PRJLANR5L14BTA0426 | |
| 14060000118301 | L14/dossiers | 14 | 14060000118269 | 14060000118300 | 1 | 2 | BTA | PRJLSNR5S239BTA0048 | |
| 14060000118315 | L14/dossiers | 14 | 14060000118269 | 14060000118314 | 1 | 2 | BTA | PRJLANR5L14BTA0462 | |
| 14060000118319 | L14/dossiers | 14 | 14060000118269 | 14060000118318 | 1 | 2 | BTA | PRJLSNR5S239BTA0061 | |
| 14060000118337 | L14/dossiers | 14 | 14060000118323 | 14060000118336 | 1 | 2 | BTA | PRJLSNR5S239BTA0097 | |
| 14060000118349 | L14/dossiers | 14 | 14060000118323 | 14060000118348 | 1 | 2 | BTA | PRJLANR5L14BTA0553 | |
| 14060000118362 | L14/dossiers | 14 | 14060000118352 | 14060000118361 | 1 | 2 | BTA | RIONANR5L14BTA0884 | |
| 14060000118379 | L14/dossiers | 14 | 14060000118363 | 14060000118378 | 1 | 2 | BTA | RIONANR5L14BTA0122 | |
| 14060000118426 | L14/dossiers | 14 | 14060000118408 | 14060000118425 | 1 | 2 | BTA | PRJLSNR5S279BTA0024 | |
| 14060000118450 | L14/dossiers | 14 | 14060000118408 | 14060000118449 | 1 | 2 | BTA | PRJLANR5L14BTA0864 | |
| 14060000118478 | L14/dossiers | 14 | 14060000118408 | 14060000118477 | 1 | 2 | BTA | PRJLANR5L14BTA0885 | |
| 14060000118488 | L14/dossiers | 14 | 14060000118408 | 14060000118487 | 1 | 2 | BTA | PRJLSNR5S279BTA0078 | |
| 14060000118497 | L14/dossiers | 14 | 14060000118408 | 14060000118496 | 1 | 2 | BTA | PRJLANR5L14BTA0920 | |
| 14060000118534 | L14/dossiers | 14 | 14060000118521 | 14060000118533 | 1 | 2 | BTA | PRJLSNR5S219BTA0094 | |
| 14060000118547 | L14/dossiers | 14 | 14060000118521 | 14060000118546 | 1 | 2 | BTA | PRJLANR5L14BTA0477 | |
| 14060000118607 | L14/dossiers | 14 | 14060000118582 | 14060000118606 | 1 | 2 | BTA | PRJLANR5L14BTA0406 | |
| 14060000118621 | L14/dossiers | 14 | 14060000118582 | 14060000118620 | 1 | 2 | BTA | PRJLSNR5S239BTA0003 | |
| 14060000118636 | L14/dossiers | 14 | 14060000118582 | 14060000118635 | 1 | 2 | BTA | PRJLANR5L14BTA0415 | |
| 14060000118640 | L14/dossiers | 14 | 14060000118582 | 14060000118639 | 1 | 2 | BTA | PRJLSNR5S239BTA0014 | |
| 14060000118713 | L14/dossiers | 14 | 14060000118700 | 14060000118712 | 1 | 2 | BTA | PIONSNR5S199BTA0033 | |
| 14060000118728 | L14/dossiers | 14 | 14060000118700 | 14060000118727 | 1 | 2 | BTA | PIONANR5L14BTA0072 | |
| 14060000118738 | L14/dossiers | 14 | 14060000118700 | 14060000118737 | 1 | 2 | BTA | PIONSNR5S199BTA0067 | |
| 14060000118785 | L14/dossiers | 14 | 14060000118762 | 14060000118784 | 1 | 2 | BTA | PRJLSNR5S279BTA0113 | |
| 14060000118817 | L14/dossiers | 14 | 14060000118762 | 14060000118816 | 1 | 2 | BTA | PRJLANR5L15BTA0008 | |
| 14060000118831 | L14/dossiers | 14 | 14060000118762 | 14060000118830 | 1 | 2 | BTA | PRJLSNR5S279BTA0126 | |
| 14060000118835 | L14/dossiers | 14 | 14060000118762 | 14060000118834 | 1 | 2 | BTA | PRJLANR5L15BTA0016 | |
| 14060000118875 | L14/dossiers | 14 | 14060000118852 | 14060000118874 | 1 | 2 | BTA | PRJLANR5L14BTA0171 | |
| 14060000118887 | L14/dossiers | 14 | 14060000118852 | 14060000118886 | 1 | 2 | BTA | PRJLSNR5S219BTA0143 | |
| 14060000118978 | L14/dossiers | 14 | 14060000118954 | 14060000118977 | 1 | 2 | BTA | PRJLSNR5S279BTA0114 | |
| 14060000119004 | L14/dossiers | 14 | 14060000118954 | 14060000119003 | 1 | 2 | BTA | PRJLANR5L15BTA0009 | |
| 14060000119032 | L14/dossiers | 14 | 14060000118954 | 14060000119031 | 1 | 2 | BTA | PRJLANR5L15BTA0017 | |
| 14060000119042 | L14/dossiers | 14 | 14060000118954 | 14060000119041 | 1 | 2 | BTA | PRJLSNR5S279BTA0128 | |
| 14060000119053 | L14/dossiers | 14 | 14060000118954 | 14060000119052 | 1 | 2 | BTA | PRJLANR5L15BTA0018 | |
| 14060000119086 | L14/dossiers | 14 | 14060000119073 | 14060000119085 | 1 | 2 | BTA | PIONSNR5S259BTA0122 | |
| 14060000119105 | L14/dossiers | 14 | 14060000119092 | 14060000119104 | 1 | 2 | BTA | RIONANR5L14BTA0418 | |
| 14060000119122 | L14/dossiers | 14 | 14060000119106 | 14060000119121 | 1 | 2 | BTA | PIONANR5L14BTA0057 | |
| 14060000119166 | L14/dossiers | 14 | 14060000119149 | 14060000119165 | 1 | 2 | BTA | PIONANR5L14BTA0444 | |
| 14060000119214 | L14/dossiers | 14 | 14060000119198 | 14060000119213 | 1 | 2 | BTA | PIONANR5L14BTA0741 | |
| 14060000119247 | L14/dossiers | 14 | 14060000119233 | 14060000119246 | 1 | 2 | BTA | PIONANR5L14BTA0742 | |
| 14060000119276 | L14/dossiers | 14 | 14060000119248 | 14060000119275 | 1 | 2 | BTA | PRJLANR5L14BTA0372 |