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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000110235 | L14/dossiers | 14 | 14060000110204 | 14060000110234 | 1 | 2 | BTA | PRJLSNR5S199BTA0188 | |
| 14060000110255 | L14/dossiers | 14 | 14060000110204 | 14060000110254 | 1 | 2 | BTA | PRJLANR5L14BTA0194 | |
| 14060000110265 | L14/dossiers | 14 | 14060000110204 | 14060000110264 | 1 | 2 | BTA | PRJLSNR5S199BTA0205 | |
| 14060000110275 | L14/dossiers | 14 | 14060000110204 | 14060000110274 | 1 | 2 | BTA | PRJLANR5L14BTA0201 | |
| 14060000110298 | L14/dossiers | 14 | 14060000110282 | 14060000110297 | 1 | 2 | BTA | PRJLSNR5S199BTA0120 | |
| 14060000110314 | L14/dossiers | 14 | 14060000110282 | 14060000110313 | 1 | 2 | BTA | PRJLANR5L14BTA0136 | |
| 14060000110341 | L14/dossiers | 14 | 14060000110282 | 14060000110340 | 1 | 2 | BTA | PRJLANR5L14BTA0159 | |
| 14060000110351 | L14/dossiers | 14 | 14060000110282 | 14060000110350 | 1 | 2 | BTA | PRJLSNR5S199BTA0181 | |
| 14060000110403 | L14/dossiers | 14 | 14060000110362 | 14060000110402 | 1 | 2 | BTA | PRJLANR5L14BTA0087 | |
| 14060000110427 | L14/dossiers | 14 | 14060000110362 | 14060000110426 | 1 | 2 | BTA | PRJLSNR5S199BTA0121 | |
| 14060000110440 | L14/dossiers | 14 | 14060000110362 | 14060000110439 | 1 | 2 | BTA | PRJLANR5L14BTA0149 | |
| 14060000110450 | L14/dossiers | 14 | 14060000110362 | 14060000110449 | 1 | 2 | BTA | PRJLSNR5S199BTA0179 | |
| 14060000110465 | L14/dossiers | 14 | 14060000110362 | 14060000110464 | 1 | 2 | BTA | PRJLANR5L14BTA0189 | |
| 14060000110469 | L14/dossiers | 14 | 14060000110362 | 14060000110468 | 1 | 2 | BTA | PRJLSNR5S199BTA0197 | |
| 14060000110499 | L14/dossiers | 14 | 14060000110490 | 14060000110498 | 1 | 2 | BTA | RIONANR5L14BTA0580 | |
| 14060000110523 | L14/dossiers | 14 | 14060000110507 | 14060000110522 | 1 | 2 | BTA | PIONANR5L14BTA0434 | |
| 14060000110545 | L14/dossiers | 14 | 14060000110531 | 14060000110544 | 1 | 2 | BTA | PIONSNR5S219BTA0009 | |
| 14060000110558 | L14/dossiers | 14 | 14060000110531 | 14060000110557 | 1 | 2 | BTA | PIONANR5L14BTA0261 | |
| 14060000110573 | L14/dossiers | 14 | 14060000110561 | 14060000110572 | 1 | 2 | BTA | RIONANR5L14BTA0129 | |
| 14060000110616 | L14/dossiers | 14 | 14060000110605 | 14060000110615 | 1 | 2 | BTA | RIONANR5L14BTA0428 | |
| 14060000110631 | L14/dossiers | 14 | 14060000110617 | 14060000110630 | 1 | 2 | BTA | PRJLSNR5S239BTA0081 | |
| 14060000110644 | L14/dossiers | 14 | 14060000110617 | 14060000110643 | 1 | 2 | BTA | PRJLANR5L14BTA0636 | |
| 14060000110710 | L14/dossiers | 14 | 14060000110693 | 14060000110709 | 1 | 2 | BTA | RIONANR5L14BTA0442 | |
| 14060000110767 | L14/dossiers | 14 | 14060000110757 | 14060000110766 | 1 | 2 | BTA | RIONANR5L14BTA0808 | |
| 14060000110795 | L14/dossiers | 14 | 14060000110768 | 14060000110794 | 1 | 2 | BTA | PIONANR5L14BTA0443 | |
| 14060000110818 | L14/dossiers | 14 | 14060000110803 | 14060000110817 | 1 | 2 | BTA | PRJLSNR5S219BTA0111 | |
| 14060000110832 | L14/dossiers | 14 | 14060000110803 | 14060000110831 | 1 | 2 | BTA | PRJLANR5L14BTA0380 | |
| 14060000110842 | L14/dossiers | 14 | 14060000110803 | 14060000110841 | 1 | 2 | BTA | PRJLSNR5S219BTA0160 | |
| 14060000110894 | L14/dossiers | 14 | 14060000110876 | 14060000110893 | 1 | 2 | BTA | PIONANR5L14BTA0202 | |
| 14060000110906 | L14/dossiers | 14 | 14060000110876 | 14060000110905 | 1 | 2 | BTA | PIONSNR5S199BTA0212 | |
| 14060000110920 | L14/dossiers | 14 | 14060000110876 | 14060000110919 | 1 | 2 | BTA | PIONANR5L14BTA0212 | |
| 14060000110924 | L14/dossiers | 14 | 14060000110876 | 14060000110923 | 1 | 2 | BTA | PIONSNR5S199BTA0215 | |
| 14060000110955 | L14/dossiers | 14 | 14060000110939 | 14060000110954 | 1 | 2 | BTA | PRJLANR5L14BTA0107 | |
| 14060000110967 | L14/dossiers | 14 | 14060000110939 | 14060000110966 | 1 | 2 | BTA | PRJLSNR5S199BTA0174 | |
| 14060000110987 | L14/dossiers | 14 | 14060000110970 | 14060000110986 | 1 | 2 | BTA | PIONANR5L14BTA0597 | |
| 14060000111324 | L14/dossiers | 14 | 14060000110991 | 14060000111323 | 1 | 2 | BTA | PRJLANR5L14BTA0239 | |
| 14060000111341 | L14/dossiers | 14 | 14060000110991 | 14060000111340 | 1 | 2 | BTA | PRJLSNR5S219BTA0040 | |
| 14060000111364 | L14/dossiers | 14 | 14060000110991 | 14060000111363 | 1 | 2 | BTA | PRJLANR5L14BTA0260 | |
| 14060000111374 | L14/dossiers | 14 | 14060000110991 | 14060000111373 | 1 | 2 | BTA | PRJLSNR5S219BTA0051 | |
| 14060000111384 | L14/dossiers | 14 | 14060000110991 | 14060000111383 | 1 | 2 | BTA | PRJLANR5L14BTA0267 | |
| 14060000111770 | L14/dossiers | 14 | 14060000111754 | 14060000111769 | 1 | 2 | BTA | PRJLANR5L14BTA0181 | |
| 14060000111782 | L14/dossiers | 14 | 14060000111754 | 14060000111781 | 1 | 2 | BTA | PRJLSNR5S199BTA0200 | |
| 14060000111839 | L14/dossiers | 14 | 14060000111826 | 14060000111838 | 1 | 2 | BTA | PIONSNR5S259BTA0018 | |
| 14060000111854 | L14/dossiers | 14 | 14060000111826 | 14060000111853 | 1 | 2 | BTA | PIONANR5L14BTA0659 | |
| 14060000111864 | L14/dossiers | 14 | 14060000111826 | 14060000111863 | 1 | 2 | BTA | PIONSNR5S279BTA0034 | |
| 14060000111898 | L14/dossiers | 14 | 14060000111873 | 14060000111897 | 1 | 2 | BTA | PRJLANR5L14BTA0782 | |
| 14060000111910 | L14/dossiers | 14 | 14060000111873 | 14060000111909 | 1 | 2 | BTA | PRJLSNR5S259BTA0188 | |
| 14060000112027 | L14/dossiers | 14 | 14060000112010 | 14060000112026 | 1 | 2 | BTA | PIONANR5L14BTA0457 | |
| 14060000112039 | L14/dossiers | 14 | 14060000112010 | 14060000112038 | 1 | 2 | BTA | PIONSNR5S239BTA0060 | |
| 14060000112053 | L14/dossiers | 14 | 14060000112010 | 14060000112052 | 1 | 2 | BTA | PIONANR5L14BTA0498 |