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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000115134 | L14/dossiers | 14 | 14060000115086 | 14060000115133 | 1 | 2 | BTA | PRJLSNR5S259BTA0102 | |
| 14060000115199 | L14/dossiers | 14 | 14060000115183 | 14060000115198 | 1 | 2 | BTA | RIONANR5L14BTA0085 | |
| 14060000115221 | L14/dossiers | 14 | 14060000115207 | 14060000115220 | 1 | 2 | BTA | PRJLSNR5S199BTA0206 | |
| 14060000115235 | L14/dossiers | 14 | 14060000115207 | 14060000115234 | 1 | 2 | BTA | PRJLANR5L14BTA0229 | |
| 14060000115266 | L14/dossiers | 14 | 14060000115252 | 14060000115265 | 1 | 2 | BTA | PRJLSNR5S259BTA0087 | |
| 14060000115287 | L14/dossiers | 14 | 14060000115252 | 14060000115286 | 1 | 2 | BTA | PRJLANR5L14BTA0769 | |
| 14060000115331 | L14/dossiers | 14 | 14060000115316 | 14060000115330 | 1 | 2 | BTA | PRJLSNR5S199BTA0119 | |
| 14060000115346 | L14/dossiers | 14 | 14060000115316 | 14060000115345 | 1 | 2 | BTA | PRJLANR5L14BTA0135 | |
| 14060000115382 | L14/dossiers | 14 | 14060000115362 | 14060000115381 | 1 | 2 | BTA | PRJLANR5L14BTA0169 | |
| 14060000115394 | L14/dossiers | 14 | 14060000115362 | 14060000115393 | 1 | 2 | BTA | PRJLSNR5S219BTA0054 | |
| 14060000115417 | L14/dossiers | 14 | 14060000115397 | 14060000115416 | 1 | 2 | BTA | PRJLANR5L14BTA0275 | |
| 14060000115429 | L14/dossiers | 14 | 14060000115397 | 14060000115428 | 1 | 2 | BTA | PRJLSNR5S219BTA0078 | |
| 14060000115459 | L14/dossiers | 14 | 14060000115446 | 14060000115458 | 1 | 2 | BTA | PIONSNR5S239BTA0025 | |
| 14060000115483 | L14/dossiers | 14 | 14060000115470 | 14060000115482 | 1 | 2 | BTA | PRJLSNR5S259BTA0158 | |
| 14060000115496 | L14/dossiers | 14 | 14060000115470 | 14060000115495 | 1 | 2 | BTA | PRJLANR5L14BTA0815 | |
| 14060000115618 | L14/dossiers | 14 | 14060000115594 | 14060000115617 | 1 | 2 | BTA | PRJLANR5L14BTA0162 | |
| 14060000115632 | L14/dossiers | 14 | 14060000115594 | 14060000115631 | 1 | 2 | BTA | PRJLSNR5S199BTA0193 | |
| 14060000115656 | L14/dossiers | 14 | 14060000115594 | 14060000115655 | 1 | 2 | BTA | PRJLANR5L14BTA0192 | |
| 14060000115666 | L14/dossiers | 14 | 14060000115594 | 14060000115665 | 1 | 2 | BTA | PRJLSNR5S199BTA0211 | |
| 14060000115677 | L14/dossiers | 14 | 14060000115594 | 14060000115676 | 1 | 2 | BTA | PRJLANR5L14BTA0208 | |
| 14060000115714 | L14/dossiers | 14 | 14060000115699 | 14060000115713 | 1 | 2 | BTA | PRJLSNR5S219BTA0035 | |
| 14060000115728 | L14/dossiers | 14 | 14060000115699 | 14060000115727 | 1 | 2 | BTA | PRJLANR5L14BTA0294 | |
| 14060000115744 | L14/dossiers | 14 | 14060000115731 | 14060000115743 | 1 | 2 | BTA | PRJLSNR5S259BTA0136 | |
| 14060000115757 | L14/dossiers | 14 | 14060000115731 | 14060000115756 | 1 | 2 | BTA | PRJLANR5L14BTA0779 | |
| 14060000115783 | L14/dossiers | 14 | 14060000115767 | 14060000115782 | 1 | 2 | BTA | PIONANR5L14BTA0724 | |
| 14060000115816 | L14/dossiers | 14 | 14060000115797 | 14060000115815 | 1 | 2 | BTA | PRJLANR5L14BTA0821 | |
| 14060000115828 | L14/dossiers | 14 | 14060000115797 | 14060000115827 | 1 | 2 | BTA | PRJLSNR5S279BTA0012 | |
| 14060000115920 | L14/dossiers | 14 | 14060000115887 | 14060000115919 | 1 | 2 | BTA | PRJLANR5L14BTA0289 | |
| 14060000115938 | L14/dossiers | 14 | 14060000115887 | 14060000115937 | 1 | 2 | BTA | PRJLSNR5S219BTA0122 | |
| 14060000115953 | L14/dossiers | 14 | 14060000115887 | 14060000115952 | 1 | 2 | BTA | PRJLANR5L14BTA0356 | |
| 14060000115957 | L14/dossiers | 14 | 14060000115887 | 14060000115956 | 1 | 2 | BTA | PRJLSNR5S219BTA0140 | |
| 14060000116011 | L14/dossiers | 14 | 14060000115997 | 14060000116010 | 1 | 2 | BTA | PRJLSNR5S199BTA0087 | |
| 14060000116026 | L14/dossiers | 14 | 14060000115997 | 14060000116025 | 1 | 2 | BTA | PRJLANR5L14BTA0361 | |
| 14060000116077 | L14/dossiers | 14 | 14060000116060 | 14060000116076 | 1 | 2 | BTA | PIONANR5L14BTA0151 | |
| 14060000116105 | L14/dossiers | 14 | 14060000116085 | 14060000116104 | 1 | 2 | BTA | RIONANR5L14BTA0523 | |
| 14060000116123 | L14/dossiers | 14 | 14060000116106 | 14060000116122 | 1 | 2 | BTA | PIONANR5L14BTA0855 | |
| 14060000116140 | L14/dossiers | 14 | 14060000116106 | 14060000116139 | 1 | 2 | BTA | PIONSNR5S279BTA0079 | |
| 14060000116151 | L14/dossiers | 14 | 14060000116106 | 14060000116150 | 1 | 2 | BTA | PIONANR5L14BTA0928 | |
| 14060000116169 | L14/dossiers | 14 | 14060000116154 | 14060000116168 | 1 | 2 | BTA | PIONANR5L14BTA0088 | |
| 14060000116186 | L14/dossiers | 14 | 14060000116170 | 14060000116185 | 1 | 2 | BTA | PRJLSNR5S239BTA0109 | |
| 14060000116202 | L14/dossiers | 14 | 14060000116170 | 14060000116201 | 1 | 2 | BTA | PRJLANR5L14BTA0562 | |
| 14060000116216 | L14/dossiers | 14 | 14060000116170 | 14060000116215 | 1 | 2 | BTA | PRJLANR5L14BTA0574 | |
| 14060000116220 | L14/dossiers | 14 | 14060000116170 | 14060000116219 | 1 | 2 | BTA | PRJLSNR5S239BTA0138 | |
| 14060000116252 | L14/dossiers | 14 | 14060000116239 | 14060000116251 | 1 | 2 | BTA | PIONSNR5S259BTA0082 | |
| 14060000116297 | L14/dossiers | 14 | 14060000116266 | 14060000116296 | 1 | 2 | BTA | PRJLANR5L14BTA0591 | |
| 14060000116316 | L14/dossiers | 14 | 14060000116266 | 14060000116315 | 1 | 2 | BTA | PRJLSNR5S259BTA0100 | |
| 14060000116333 | L14/dossiers | 14 | 14060000116266 | 14060000116332 | 1 | 2 | BTA | PRJLANR5L14BTA0707 | |
| 14060000116344 | L14/dossiers | 14 | 14060000116266 | 14060000116343 | 1 | 2 | BTA | PRJLSNR5S259BTA0147 | |
| 14060000116360 | L14/dossiers | 14 | 14060000116266 | 14060000116359 | 1 | 2 | BTA | PRJLANR5L14BTA0768 | |
| 14060000116364 | L14/dossiers | 14 | 14060000116266 | 14060000116363 | 1 | 2 | BTA | PRJLSNR5S259BTA0166 |