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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000127891 | L14/dossiers | 14 | 14060000127867 | 14060000127890 | 1 | 2 | BTA | PRJLANR5L14BTA0172 | |
| 14060000127903 | L14/dossiers | 14 | 14060000127867 | 14060000127902 | 1 | 2 | BTA | PRJLSNR5S219BTA0097 | |
| 14060000127953 | L14/dossiers | 14 | 14060000127934 | 14060000127952 | 1 | 2 | BTA | PRJLANR5L14BTA0847 | |
| 14060000127965 | L14/dossiers | 14 | 14060000127934 | 14060000127964 | 1 | 2 | BTA | PRJLSNR5S279BTA0069 | |
| 14060000127990 | L14/dossiers | 14 | 14060000127968 | 14060000127989 | 1 | 2 | BTA | PIONANR5L14BTA0017 | |
| 14060000128007 | L14/dossiers | 14 | 14060000127968 | 14060000128006 | 1 | 2 | BTA | PIONSNR5S199BTA0019 | |
| 14060000128031 | L14/dossiers | 14 | 14060000127968 | 14060000128030 | 1 | 2 | BTA | PIONANR5L14BTA0080 | |
| 14060000128044 | L14/dossiers | 14 | 14060000127968 | 14060000128043 | 1 | 2 | BTA | PIONSNR5S199BTA0099 | |
| 14060000128055 | L14/dossiers | 14 | 14060000127968 | 14060000128054 | 1 | 2 | BTA | PIONANR5L14BTA0094 | |
| 14060000128095 | L14/dossiers | 14 | 14060000128088 | 14060000128094 | 1 | 2 | BTA | RIONANR5L14BTA0926 | |
| 14060000128114 | L14/dossiers | 14 | 14060000128096 | 14060000128113 | 1 | 2 | BTA | PRJLANR5L14BTA0703 | |
| 14060000128126 | L14/dossiers | 14 | 14060000128096 | 14060000128125 | 1 | 2 | BTA | PRJLSNR5S259BTA0139 | |
| 14060000128175 | L14/dossiers | 14 | 14060000128160 | 14060000128174 | 1 | 2 | BTA | PRJLANR5L14BTA0037 | |
| 14060000128187 | L14/dossiers | 14 | 14060000128160 | 14060000128186 | 1 | 2 | BTA | PRJLSNR5S199BTA0094 | |
| 14060000128242 | L14/dossiers | 14 | 14060000128225 | 14060000128241 | 1 | 2 | BTA | PIONANR5L14BTA0827 | |
| 14060000128324 | L14/dossiers | 14 | 14060000128311 | 14060000128323 | 1 | 2 | BTA | PIONSNR5S299BTA0073 | |
| 14060000128373 | L14/dossiers | 14 | 14060000128354 | 14060000128372 | 1 | 2 | BTA | PNREANR5L14BTA0622 | |
| 14060000128400 | L14/dossiers | 14 | 14060000128384 | 14060000128399 | 1 | 2 | BTA | PIONANR5L14BTA0527 | |
| 14060000128438 | L14/dossiers | 14 | 14060000128406 | 14060000128437 | 1 | 2 | BTA | PRJLANR5L14BTA0494 | |
| 14060000128463 | L14/dossiers | 14 | 14060000128406 | 14060000128462 | 1 | 2 | BTA | PRJLSNR5S259BTA0069 | |
| 14060000128490 | L14/dossiers | 14 | 14060000128406 | 14060000128489 | 1 | 2 | BTA | PRJLANR5L14BTA0706 | |
| 14060000128507 | L14/dossiers | 14 | 14060000128406 | 14060000128506 | 1 | 2 | BTA | PRJLSNR5S259BTA0140 | |
| 14060000128535 | L14/dossiers | 14 | 14060000128406 | 14060000128534 | 1 | 2 | BTA | PRJLANR5L14BTA0775 | |
| 14060000128545 | L14/dossiers | 14 | 14060000128406 | 14060000128544 | 1 | 2 | BTA | PRJLSNR5S259BTA0176 | |
| 14060000128556 | L14/dossiers | 14 | 14060000128406 | 14060000128555 | 1 | 2 | BTA | PRJLANR5L14BTA0803 | |
| 14060000128611 | L14/dossiers | 14 | 14060000128587 | 14060000128610 | 1 | 2 | BTA | PIONANR5L14BTA0486 | |
| 14060000128631 | L14/dossiers | 14 | 14060000128587 | 14060000128630 | 1 | 2 | BTA | PIONSNR5S239BTA0116 | |
| 14060000128645 | L14/dossiers | 14 | 14060000128587 | 14060000128644 | 1 | 2 | BTA | PIONANR5L14BTA0592 | |
| 14060000128655 | L14/dossiers | 14 | 14060000128587 | 14060000128654 | 1 | 2 | BTA | PIONSNR5S259BTA0030 | |
| 14060000128669 | L14/dossiers | 14 | 14060000128587 | 14060000128668 | 1 | 2 | BTA | PIONANR5L14BTA0665 | |
| 14060000128673 | L14/dossiers | 14 | 14060000128587 | 14060000128672 | 1 | 2 | BTA | PIONSNR5S259BTA0072 | |
| 14060000128721 | L14/dossiers | 14 | 14060000128700 | 14060000128720 | 1 | 2 | BTA | PRJLANR5L14BTA0028 | |
| 14060000128738 | L14/dossiers | 14 | 14060000128700 | 14060000128737 | 1 | 2 | BTA | PRJLSNR5S199BTA0021 | |
| 14060000128759 | L14/dossiers | 14 | 14060000128700 | 14060000128758 | 1 | 2 | BTA | PRJLANR5L14BTA0068 | |
| 14060000128769 | L14/dossiers | 14 | 14060000128700 | 14060000128768 | 1 | 2 | BTA | PRJLSNR5S199BTA0063 | |
| 14060000128779 | L14/dossiers | 14 | 14060000128700 | 14060000128778 | 1 | 2 | BTA | PRJLANR5L14BTA0074 | |
| 14060000128800 | L14/dossiers | 14 | 14060000128783 | 14060000128799 | 1 | 2 | BTA | PIONANR5L14BTA0325 | |
| 14060000128830 | L14/dossiers | 14 | 14060000128815 | 14060000128829 | 1 | 2 | BTA | PRJLSNR5S199BTA0201 | |
| 14060000128846 | L14/dossiers | 14 | 14060000128815 | 14060000128845 | 1 | 2 | BTA | PRJLANR5L14BTA0216 | |
| 14060000128860 | L14/dossiers | 14 | 14060000128815 | 14060000128859 | 1 | 2 | BTA | PRJLSNR5S219BTA0019 | |
| 14060000128864 | L14/dossiers | 14 | 14060000128815 | 14060000128863 | 1 | 2 | BTA | PRJLANR5L14BTA0233 | |
| 14060000128909 | L14/dossiers | 14 | 14060000128892 | 14060000128908 | 1 | 2 | BTA | PIONANR5L14BTA0709 | |
| 14060000128921 | L14/dossiers | 14 | 14060000128892 | 14060000128920 | 1 | 2 | BTA | PIONSNR5S279BTA0027 | |
| 14060000128965 | L14/dossiers | 14 | 14060000128941 | 14060000128964 | 1 | 2 | BTA | PIONANR5L14BTA0672 | |
| 14060000128984 | L14/dossiers | 14 | 14060000128941 | 14060000128983 | 1 | 2 | BTA | PIONSNR5S259BTA0115 | |
| 14060000128998 | L14/dossiers | 14 | 14060000128941 | 14060000128997 | 1 | 2 | BTA | PIONANR5L14BTA0747 | |
| 14060000129002 | L14/dossiers | 14 | 14060000128941 | 14060000129001 | 1 | 2 | BTA | PIONSNR5S259BTA0152 | |
| 14060000129042 | L14/dossiers | 14 | 14060000129006 | 14060000129041 | 1 | 2 | BTA | PRJLANR5L14BTA0358 | |
| 14060000129060 | L14/dossiers | 14 | 14060000129006 | 14060000129059 | 1 | 2 | BTA | PRJLSNR5S219BTA0152 | |
| 14060000129075 | L14/dossiers | 14 | 14060000129006 | 14060000129074 | 1 | 2 | BTA | PRJLANR5L14BTA0385 |