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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000130313 | L14/dossiers | 14 | 14060000130264 | 14060000130312 | 1 | 2 | BTA | PRJLANR5L14BTA0383 | |
| 14060000130323 | L14/dossiers | 14 | 14060000130264 | 14060000130322 | 1 | 2 | BTA | PRJLSNR5S219BTA0164 | |
| 14060000130333 | L14/dossiers | 14 | 14060000130264 | 14060000130332 | 1 | 2 | BTA | PRJLANR5L14BTA0396 | |
| 14060000130406 | L14/dossiers | 14 | 14060000130390 | 14060000130405 | 1 | 2 | BTA | PIONSNR5S259BTA0084 | |
| 14060000130421 | L14/dossiers | 14 | 14060000130390 | 14060000130420 | 1 | 2 | BTA | PIONANR5L14BTA0726 | |
| 14060000130431 | L14/dossiers | 14 | 14060000130390 | 14060000130430 | 1 | 2 | BTA | PIONSNR5S259BTA0150 | |
| 14060000130443 | L14/dossiers | 14 | 14060000130390 | 14060000130442 | 1 | 2 | BTA | PIONANR5L14BTA0857 | |
| 14060000130453 | L14/dossiers | 14 | 14060000130390 | 14060000130452 | 1 | 2 | BTA | PIONSNR5S279BTA0057 | |
| 14060000130472 | L14/dossiers | 14 | 14060000130456 | 14060000130471 | 1 | 2 | BTA | PIONANR5L14BTA0615 | |
| 14060000130493 | L14/dossiers | 14 | 14060000130480 | 14060000130492 | 1 | 2 | BTA | PIONSNR5S259BTA0168 | |
| 14060000130542 | L14/dossiers | 14 | 14060000130527 | 14060000130541 | 1 | 2 | BTA | PRJLSNR5S199BTA0202 | |
| 14060000130559 | L14/dossiers | 14 | 14060000130527 | 14060000130558 | 1 | 2 | BTA | PRJLANR5L14BTA0217 | |
| 14060000130573 | L14/dossiers | 14 | 14060000130527 | 14060000130572 | 1 | 2 | BTA | PRJLSNR5S219BTA0020 | |
| 14060000130577 | L14/dossiers | 14 | 14060000130527 | 14060000130576 | 1 | 2 | BTA | PRJLANR5L14BTA0234 | |
| 14060000130601 | L14/dossiers | 14 | 14060000130588 | 14060000130600 | 1 | 2 | BTA | PIONSNR5S239BTA0086 | |
| 14060000130662 | L14/dossiers | 14 | 14060000130648 | 14060000130661 | 1 | 2 | BTA | PRJLSNR5S239BTA0045 | |
| 14060000130674 | L14/dossiers | 14 | 14060000130648 | 14060000130673 | 1 | 2 | BTA | PRJLANR5L14BTA0549 | |
| 14060000130714 | L14/dossiers | 14 | 14060000130701 | 14060000130713 | 1 | 2 | BTA | PNREANR5L14BTA0347 | |
| 14060000130765 | L14/dossiers | 14 | 14060000130746 | 14060000130764 | 1 | 2 | BTA | PIONANR5L14BTA0379 | |
| 14060000130777 | L14/dossiers | 14 | 14060000130746 | 14060000130776 | 1 | 2 | BTA | PIONSNR5S219BTA0169 | |
| 14060000130863 | L14/dossiers | 14 | 14060000130845 | 14060000130862 | 1 | 2 | BTA | PIONANR5L14BTA0026 | |
| 14060000130890 | L14/dossiers | 14 | 14060000130876 | 14060000130889 | 1 | 2 | BTA | RIONANR5L14BTA0662 | |
| 14060000130907 | L14/dossiers | 14 | 14060000130891 | 14060000130906 | 1 | 2 | BTA | PIONANR5L14BTA0839 | |
| 14060000131047 | L14/dossiers | 14 | 14060000131029 | 14060000131046 | 1 | 2 | BTA | PRJLANR5L14BTA0583 | |
| 14060000131059 | L14/dossiers | 14 | 14060000131029 | 14060000131058 | 1 | 2 | BTA | PRJLSNR5S259BTA0059 | |
| 14060000131097 | L14/dossiers | 14 | 14060000131083 | 14060000131096 | 1 | 2 | BTA | PRJLSNR5S239BTA0063 | |
| 14060000131110 | L14/dossiers | 14 | 14060000131083 | 14060000131109 | 1 | 2 | BTA | PRJLANR5L14BTA0497 | |
| 14060000131139 | L14/dossiers | 14 | 14060000131120 | 14060000131138 | 1 | 2 | BTA | PIONSNR5S199BTA0034 | |
| 14060000131160 | L14/dossiers | 14 | 14060000131120 | 14060000131159 | 1 | 2 | BTA | PIONANR5L14BTA0083 | |
| 14060000131170 | L14/dossiers | 14 | 14060000131120 | 14060000131169 | 1 | 2 | BTA | PIONSNR5S199BTA0127 | |
| 14060000131230 | L14/dossiers | 14 | 14060000131212 | 14060000131229 | 1 | 2 | BTA | PRJLANR5L14BTA0599 | |
| 14060000131242 | L14/dossiers | 14 | 14060000131212 | 14060000131241 | 1 | 2 | BTA | PRJLSNR5S259BTA0032 | |
| 14060000131296 | L14/dossiers | 14 | 14060000131282 | 14060000131295 | 1 | 2 | BTA | PIONANR5L14BTA0340 | |
| 14060000131334 | L14/dossiers | 14 | 14060000131311 | 14060000131333 | 1 | 2 | BTA | PRJLSNR5S219BTA0023 | |
| 14060000131373 | L14/dossiers | 14 | 14060000131311 | 14060000131372 | 1 | 2 | BTA | PRJLANR5L14BTA0251 | |
| 14060000131383 | L14/dossiers | 14 | 14060000131311 | 14060000131382 | 1 | 2 | BTA | PRJLSNR5S219BTA0046 | |
| 14060000131403 | L14/dossiers | 14 | 14060000131389 | 14060000131402 | 1 | 2 | BTA | RIONANR5L14BTA0082 | |
| 14060000131459 | L14/dossiers | 14 | 14060000131446 | 14060000131458 | 1 | 2 | BTA | PIONSNR5S259BTA0006 | |
| 14060000131473 | L14/dossiers | 14 | 14060000131446 | 14060000131472 | 1 | 2 | BTA | PIONANR5L14BTA0603 | |
| 14060000131487 | L14/dossiers | 14 | 14060000131446 | 14060000131486 | 1 | 2 | BTA | PIONSNR5S259BTA0048 | |
| 14060000131491 | L14/dossiers | 14 | 14060000131446 | 14060000131490 | 1 | 2 | BTA | PIONANR5L14BTA0629 | |
| 14060000131542 | L14/dossiers | 14 | 14060000131528 | 14060000131541 | 1 | 2 | BTA | PRJLSNR5S279BTA0047 | |
| 14060000131555 | L14/dossiers | 14 | 14060000131528 | 14060000131554 | 1 | 2 | BTA | PRJLANR5L14BTA0917 | |
| 14060000131580 | L14/dossiers | 14 | 14060000131567 | 14060000131579 | 1 | 2 | BTA | PRJLSNR5S299BTA0037 | |
| 14060000131594 | L14/dossiers | 14 | 14060000131586 | 14060000131593 | 1 | 2 | BTA | RIONANR5L14BTA0146 | |
| 14060000131648 | L14/dossiers | 14 | 14060000131617 | 14060000131647 | 1 | 2 | BTA | PRJLANR5L14BTA0015 | |
| 14060000131666 | L14/dossiers | 14 | 14060000131617 | 14060000131665 | 1 | 2 | BTA | PRJLSNR5S198BTA0142 | |
| 14060000131681 | L14/dossiers | 14 | 14060000131617 | 14060000131680 | 1 | 2 | BTA | PRJLANR5L14BTA0019 | |
| 14060000131685 | L14/dossiers | 14 | 14060000131617 | 14060000131684 | 1 | 2 | BTA | PRJLSNR5S199BTA0008 | |
| 14060000131720 | L14/dossiers | 14 | 14060000131710 | 14060000131719 | 1 | 2 | BTA | RIONANR5L14BTA0499 |