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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000122121 | L14/dossiers | 14 | 14060000122106 | 14060000122120 | 1 | 2 | BTA | PRJLANR5L14BTA0552 | |
| 14060000122133 | L14/dossiers | 14 | 14060000122106 | 14060000122132 | 1 | 2 | BTA | PRJLSNR5S259BTA0005 | |
| 14060000122171 | L14/dossiers | 14 | 14060000122154 | 14060000122170 | 1 | 2 | BTA | PRJLANR5L14BTA0492 | |
| 14060000122183 | L14/dossiers | 14 | 14060000122154 | 14060000122182 | 1 | 2 | BTA | PRJLSNR5S239BTA0094 | |
| 14060000122219 | L14/dossiers | 14 | 14060000122210 | 14060000122218 | 1 | 2 | BTA | RIONANR5L14BTA0487 | |
| 14060000122293 | L14/dossiers | 14 | 14060000122279 | 14060000122292 | 1 | 2 | BTA | PRJLSNR5S198BTA0143 | |
| 14060000122305 | L14/dossiers | 14 | 14060000122279 | 14060000122304 | 1 | 2 | BTA | PRJLANR5L14BTA0062 | |
| 14060000122315 | L14/dossiers | 14 | 14060000122279 | 14060000122314 | 1 | 2 | BTA | PRJLSNR5S199BTA0072 | |
| 14060000122360 | L14/dossiers | 14 | 14060000122346 | 14060000122359 | 1 | 2 | BTA | PRJLSNR5S239BTA0012 | |
| 14060000122373 | L14/dossiers | 14 | 14060000122346 | 14060000122372 | 1 | 2 | BTA | PRJLANR5L14BTA0633 | |
| 14060000122428 | L14/dossiers | 14 | 14060000122415 | 14060000122427 | 1 | 2 | BTA | PRJLSNR5S199BTA0116 | |
| 14060000122453 | L14/dossiers | 14 | 14060000122434 | 14060000122452 | 1 | 2 | BTA | PRJLANR5L14BTA0392 | |
| 14060000122465 | L14/dossiers | 14 | 14060000122434 | 14060000122464 | 1 | 2 | BTA | PRJLSNR5S239BTA0010 | |
| 14060000122510 | L14/dossiers | 14 | 14060000122468 | 14060000122509 | 1 | 2 | BTA | PRJLANR5L14BTA0829 | |
| 14060000122535 | L14/dossiers | 14 | 14060000122468 | 14060000122534 | 1 | 2 | BTA | PRJLSNR5S279BTA0025 | |
| 14060000122558 | L14/dossiers | 14 | 14060000122468 | 14060000122557 | 1 | 2 | BTA | PRJLANR5L14BTA0842 | |
| 14060000122568 | L14/dossiers | 14 | 14060000122468 | 14060000122567 | 1 | 2 | BTA | PRJLSNR5S279BTA0029 | |
| 14060000122577 | L14/dossiers | 14 | 14060000122468 | 14060000122576 | 1 | 2 | BTA | PRJLANR5L14BTA0851 | |
| 14060000122641 | L14/dossiers | 14 | 14060000122622 | 14060000122640 | 1 | 2 | BTA | PIONANR5L14BTA0745 | |
| 14060000122653 | L14/dossiers | 14 | 14060000122622 | 14060000122652 | 1 | 2 | BTA | PIONSNR5S259BTA0164 | |
| 14060000122668 | L14/dossiers | 14 | 14060000122622 | 14060000122667 | 1 | 2 | BTA | PIONANR5L14BTA0800 | |
| 14060000122672 | L14/dossiers | 14 | 14060000122622 | 14060000122671 | 1 | 2 | BTA | PIONSNR5S259BTA0182 | |
| 14060000122720 | L14/dossiers | 14 | 14060000122705 | 14060000122719 | 1 | 2 | BTA | PIONANR5L14BTA0620 | |
| 14060000122774 | L14/dossiers | 14 | 14060000122764 | 14060000122773 | 1 | 2 | BTA | RIONANR5L14BTA0853 | |
| 14060000122829 | L14/dossiers | 14 | 14060000122816 | 14060000122828 | 1 | 2 | BTA | PIONSNR5S259BTA0142 | |
| 14060000122843 | L14/dossiers | 14 | 14060000122816 | 14060000122842 | 1 | 2 | BTA | PIONANR5L14BTA0789 | |
| 14060000122881 | L14/dossiers | 14 | 14060000122874 | 14060000122880 | 1 | 2 | BTA | RIONANR5L14BTA0334 | |
| 14060000122994 | L14/dossiers | 14 | 14060000122979 | 14060000122993 | 1 | 2 | BTA | PIONANR5L14BTA0621 | |
| 14060000123068 | L14/dossiers | 14 | 14060000123055 | 14060000123067 | 1 | 2 | BTA | PRJLSNR5S279BTA0120 | |
| 14060000123081 | L14/dossiers | 14 | 14060000123055 | 14060000123080 | 1 | 2 | BTA | PRJLANR5L15BTA0022 | |
| 14060000123108 | L14/dossiers | 14 | 14060000123091 | 14060000123107 | 1 | 2 | BTA | PIONSNR5S259BTA0085 | |
| 14060000123123 | L14/dossiers | 14 | 14060000123091 | 14060000123122 | 1 | 2 | BTA | PIONANR5L14BTA0725 | |
| 14060000123133 | L14/dossiers | 14 | 14060000123091 | 14060000123132 | 1 | 2 | BTA | PIONSNR5S259BTA0151 | |
| 14060000123145 | L14/dossiers | 14 | 14060000123091 | 14060000123144 | 1 | 2 | BTA | PIONANR5L14BTA0856 | |
| 14060000123155 | L14/dossiers | 14 | 14060000123091 | 14060000123154 | 1 | 2 | BTA | PIONSNR5S279BTA0058 | |
| 14060000123206 | L14/dossiers | 14 | 14060000123181 | 14060000123205 | 1 | 2 | BTA | PRJLANR5L14BTA0179 | |
| 14060000123219 | L14/dossiers | 14 | 14060000123181 | 14060000123218 | 1 | 2 | BTA | PRJLSNR5S199BTA0217 | |
| 14060000123242 | L14/dossiers | 14 | 14060000123181 | 14060000123241 | 1 | 2 | BTA | PRJLANR5L14BTA0243 | |
| 14060000123252 | L14/dossiers | 14 | 14060000123181 | 14060000123251 | 1 | 2 | BTA | PRJLSNR5S219BTA0062 | |
| 14060000123263 | L14/dossiers | 14 | 14060000123181 | 14060000123262 | 1 | 2 | BTA | PRJLANR5L14BTA0279 | |
| 14060000123388 | L14/dossiers | 14 | 14060000123368 | 14060000123387 | 1 | 2 | BTA | PRJLSNR5S198BTA0144 | |
| 14060000123411 | L14/dossiers | 14 | 14060000123368 | 14060000123410 | 1 | 2 | BTA | PRJLANR5L14BTA0022 | |
| 14060000123425 | L14/dossiers | 14 | 14060000123368 | 14060000123424 | 1 | 2 | BTA | PRJLSNR5S199BTA0022 | |
| 14060000123429 | L14/dossiers | 14 | 14060000123368 | 14060000123428 | 1 | 2 | BTA | PRJLANR5L14BTA0030 | |
| 14060000123449 | L14/dossiers | 14 | 14060000123436 | 14060000123448 | 1 | 2 | BTA | PRJLSNR5S299BTA0015 | |
| 14060000123463 | L14/dossiers | 14 | 14060000123436 | 14060000123462 | 1 | 2 | BTA | PRJLANR5L15BTA0096 | |
| 14060000123485 | L14/dossiers | 14 | 14060000123467 | 14060000123484 | 1 | 2 | BTA | PIONANR5L14BTA0687 | |
| 14060000123503 | L14/dossiers | 14 | 14060000123467 | 14060000123502 | 1 | 2 | BTA | PIONSNR5S259BTA0148 | |
| 14060000123525 | L14/dossiers | 14 | 14060000123467 | 14060000123524 | 1 | 2 | BTA | PIONANR5L14BTA0795 | |
| 14060000123535 | L14/dossiers | 14 | 14060000123467 | 14060000123534 | 1 | 2 | BTA | PIONSNR5S259BTA0191 |