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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000100068 | L14/dossiers | 14 | 14060000099774 | 14060000100067 | 1 | 2 | BTA | PRJLSNR5S199BTA0040 | |
| 14060000100092 | L14/dossiers | 14 | 14060000099774 | 14060000100091 | 1 | 2 | BTA | PRJLANR5L14BTA0066 | |
| 14060000100102 | L14/dossiers | 14 | 14060000099774 | 14060000100101 | 1 | 2 | BTA | PRJLSNR5S199BTA0061 | |
| 14060000100112 | L14/dossiers | 14 | 14060000099774 | 14060000100111 | 1 | 2 | BTA | PRJLANR5L14BTA0073 | |
| 14060000100510 | L14/dossiers | 14 | 14060000100497 | 14060000100509 | 1 | 2 | BTA | PIONSNR5S219BTA0048 | |
| 14060000100525 | L14/dossiers | 14 | 14060000100497 | 14060000100524 | 1 | 2 | BTA | PIONANR5L14BTA0431 | |
| 14060000100537 | L14/dossiers | 14 | 14060000100497 | 14060000100536 | 1 | 2 | BTA | PIONSNR5S239BTA0074 | |
| 14060000100568 | L14/dossiers | 14 | 14060000100554 | 14060000100567 | 1 | 2 | BTA | RIONANR5L14BTA0320 | |
| 14060000100611 | L14/dossiers | 14 | 14060000100586 | 14060000100610 | 1 | 2 | BTA | PRJLANR5L14BTA0729 | |
| 14060000100628 | L14/dossiers | 14 | 14060000100586 | 14060000100627 | 1 | 2 | BTA | PRJLSNR5S259BTA0153 | |
| 14060000100728 | L14/dossiers | 14 | 14060000100712 | 14060000100727 | 1 | 2 | BTA | PIONANR5L14BTA0503 | |
| 14060000100749 | L14/dossiers | 14 | 14060000100736 | 14060000100748 | 1 | 2 | BTA | PRJLSNR5S259BTA0137 | |
| 14060000100762 | L14/dossiers | 14 | 14060000100736 | 14060000100761 | 1 | 2 | BTA | PRJLANR5L14BTA0784 | |
| 14060000100782 | L14/dossiers | 14 | 14060000100765 | 14060000100781 | 1 | 2 | BTA | PRJLANR5L14BTA0837 | |
| 14060000100794 | L14/dossiers | 14 | 14060000100765 | 14060000100793 | 1 | 2 | BTA | PRJLSNR5S279BTA0067 | |
| 14060000100813 | L14/dossiers | 14 | 14060000100797 | 14060000100812 | 1 | 2 | BTA | PIONANR5L14BTA0411 | |
| 14060000100841 | L14/dossiers | 14 | 14060000100817 | 14060000100840 | 1 | 2 | BTA | PRJLANR5L14BTA0230 | |
| 14060000100858 | L14/dossiers | 14 | 14060000100817 | 14060000100857 | 1 | 2 | BTA | PRJLSNR5S219BTA0031 | |
| 14060000100889 | L14/dossiers | 14 | 14060000100875 | 14060000100888 | 1 | 2 | BTA | RIONANR5L14BTA0185 | |
| 14060000100950 | L14/dossiers | 14 | 14060000100935 | 14060000100949 | 1 | 2 | BTA | RIONANR5L14BTA0093 | |
| 14060000100975 | L14/dossiers | 14 | 14060000100958 | 14060000100974 | 1 | 2 | BTA | PIONANR5L14BTA0378 | |
| 14060000100987 | L14/dossiers | 14 | 14060000100958 | 14060000100986 | 1 | 2 | BTA | PIONSNR5S219BTA0170 | |
| 14060000101002 | L14/dossiers | 14 | 14060000100958 | 14060000101001 | 1 | 2 | BTA | PIONANR5L14BTA0409 | |
| 14060000101033 | L14/dossiers | 14 | 14060000101019 | 14060000101032 | 1 | 2 | BTA | PRJLSNR5S199BTA0133 | |
| 14060000101047 | L14/dossiers | 14 | 14060000101019 | 14060000101046 | 1 | 2 | BTA | PRJLANR5L14BTA0316 | |
| 14060000101081 | L14/dossiers | 14 | 14060000101072 | 14060000101080 | 1 | 2 | BTA | RIONANR5L14BTA0432 | |
| 14060000101115 | L14/dossiers | 14 | 14060000101099 | 14060000101114 | 1 | 2 | BTA | PIONANR5L14BTA0138 | |
| 14060000101154 | L14/dossiers | 14 | 14060000101140 | 14060000101153 | 1 | 2 | BTA | PRJLSNR5S279BTA0023 | |
| 14060000101173 | L14/dossiers | 14 | 14060000101140 | 14060000101172 | 1 | 2 | BTA | PRJLANR5L15BTA0098 | |
| 14060000101225 | L14/dossiers | 14 | 14060000101207 | 14060000101224 | 1 | 2 | BTA | RIONANR5L14BTA0923 | |
| 14060000101266 | L14/dossiers | 14 | 14060000101257 | 14060000101265 | 1 | 2 | BTA | RIONANR5L14BTA0694 | |
| 14060000101285 | L14/dossiers | 14 | 14060000101267 | 14060000101284 | 1 | 2 | BTA | PIONANR5L14BTA0848 | |
| 14060000101307 | L14/dossiers | 14 | 14060000101267 | 14060000101306 | 1 | 2 | BTA | PIONSNR5S279BTA0033 | |
| 14060000101329 | L14/dossiers | 14 | 14060000101267 | 14060000101328 | 1 | 2 | BTA | PIONANR5L14BTA0896 | |
| 14060000101339 | L14/dossiers | 14 | 14060000101267 | 14060000101338 | 1 | 2 | BTA | PIONSNR5S279BTA0083 | |
| 14060000101349 | L14/dossiers | 14 | 14060000101267 | 14060000101348 | 1 | 2 | BTA | PIONANR5L14BTA0919 | |
| 14060000101377 | L14/dossiers | 14 | 14060000101359 | 14060000101376 | 1 | 2 | BTA | PRJLANR5L14BTA0780 | |
| 14060000101389 | L14/dossiers | 14 | 14060000101359 | 14060000101388 | 1 | 2 | BTA | PRJLSNR5S259BTA0189 | |
| 14060000101419 | L14/dossiers | 14 | 14060000101402 | 14060000101418 | 1 | 2 | BTA | PRJLANR5L14BTA0425 | |
| 14060000101432 | L14/dossiers | 14 | 14060000101402 | 14060000101431 | 1 | 2 | BTA | PRJLSNR5S239BTA0042 | |
| 14060000101458 | L14/dossiers | 14 | 14060000101442 | 14060000101457 | 1 | 2 | BTA | PIONANR5L14BTA0887 | |
| 14060000101470 | L14/dossiers | 14 | 14060000101442 | 14060000101469 | 1 | 2 | BTA | PIONSNR5S279BTA0076 | |
| 14060000101484 | L14/dossiers | 14 | 14060000101442 | 14060000101483 | 1 | 2 | BTA | PIONANR5L14BTA0913 | |
| 14060000101488 | L14/dossiers | 14 | 14060000101442 | 14060000101487 | 1 | 2 | BTA | PIONSNR5S279BTA0087 | |
| 14060000101529 | L14/dossiers | 14 | 14060000101495 | 14060000101528 | 1 | 2 | BTA | PRJLANR5L14BTA0288 | |
| 14060000101548 | L14/dossiers | 14 | 14060000101495 | 14060000101547 | 1 | 2 | BTA | PRJLSNR5S219BTA0085 | |
| 14060000101562 | L14/dossiers | 14 | 14060000101495 | 14060000101561 | 1 | 2 | BTA | PRJLANR5L14BTA0317 | |
| 14060000101566 | L14/dossiers | 14 | 14060000101495 | 14060000101565 | 1 | 2 | BTA | PRJLSNR5S219BTA0091 | |
| 14060000101640 | L14/dossiers | 14 | 14060000101624 | 14060000101639 | 1 | 2 | BTA | PIONANR5L14BTA0417 | |
| 14060000101652 | L14/dossiers | 14 | 14060000101624 | 14060000101651 | 1 | 2 | BTA | PIONSNR5S239BTA0034 |