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 |
|---|---|---|---|---|---|---|---|---|---|
| 16060000095240 | L16/dossiers | 16 | 16060000095216 | 16060000095238 | 2 | 2 | TAP | PRJLANR5L16TAP0001 | |
| 16060000095252 | L16/dossiers | 16 | 16060000095216 | 16060000095251 | 1 | 2 | BTA | PRJLSNR5S379BTA0136 | |
| 16060000095268 | L16/dossiers | 16 | 16060000095216 | 16060000095267 | 1 | 2 | BTA | PRJLANR5L16BTA0004 | |
| 16060000095269 | L16/dossiers | 16 | 16060000095216 | 16060000095267 | 2 | 2 | TAP | PRJLANR5L16TAP0004 | |
| 16060000095273 | L16/dossiers | 16 | 16060000095216 | 16060000095272 | 1 | 2 | BTA | PRJLSNR5S379BTA0140 | |
| 16060000095297 | L16/dossiers | 16 | 16060000095280 | 16060000095296 | 1 | 2 | BTA | PRJLANR5L16BTA0002 | |
| 16060000095298 | L16/dossiers | 16 | 16060000095280 | 16060000095296 | 2 | 2 | TAP | PRJLANR5L16TAP0002 | |
| 16060000095358 | L16/dossiers | 16 | 16060000095280 | 16060000095357 | 1 | 2 | BTA | PRJLSNR5S379BTA0135 | |
| 16060000095382 | L16/dossiers | 16 | 16060000095280 | 16060000095381 | 1 | 2 | BTA | PRJLANR5L16BTA0006 | |
| 16060000095383 | L16/dossiers | 16 | 16060000095280 | 16060000095381 | 2 | 2 | TAP | PRJLANR5L16TAP0006 | |
| 16060000095393 | L16/dossiers | 16 | 16060000095280 | 16060000095392 | 1 | 2 | BTA | PRJLSNR5S379BTA0144 | |
| 16060000095406 | L16/dossiers | 16 | 16060000095280 | 16060000095405 | 1 | 2 | BTA | PRJLANR5L16BTA0013 | |
| 16060000095435 | L16/dossiers | 16 | 16060000095416 | 16060000095434 | 1 | 2 | BTA | PRJLANR5L16BTA0010 | |
| 16060000095446 | L16/dossiers | 16 | 16060000095416 | 16060000095445 | 1 | 2 | BTA | PRJLSNR5S399BTA0014 | |
| 16060000095539 | L16/dossiers | 16 | 16060000095525 | 16060000095538 | 1 | 2 | BTA | PIONSNR5S399BTA0001 | |
| 16060000095552 | L16/dossiers | 16 | 16060000095525 | 16060000095551 | 1 | 2 | BTA | PIONANR5L16BTA0023 | |
| 16060000095553 | L16/dossiers | 16 | 16060000095525 | 16060000095551 | 2 | 2 | TAP | PIONANR5L16TAP0023 | |
| 16060000095617 | L16/dossiers | 16 | 16060000095570 | 16060000095616 | 1 | 2 | BTA | PRJLANR5L16BTA0003 | |
| 16060000095618 | L16/dossiers | 16 | 16060000095570 | 16060000095616 | 2 | 2 | TAP | PRJLANR5L16TAP0003 | |
| 16060000095630 | L16/dossiers | 16 | 16060000095570 | 16060000095629 | 1 | 2 | BTA | PRJLSNR5S379BTA0142 | |
| 16060000095646 | L16/dossiers | 16 | 16060000095570 | 16060000095645 | 1 | 2 | BTA | PRJLSNR5S379BTA0147 | |
| 16060000095650 | L16/dossiers | 16 | 16060000095570 | 16060000095649 | 1 | 2 | BTA | PRJLANR5L16BTA0012 | |
| 16060000095651 | L16/dossiers | 16 | 16060000095570 | 16060000095649 | 2 | 2 | TAP | PRJLANR5L16TAP0012 | |
| 16060000095695 | L16/dossiers | 16 | 16060000095659 | 16060000095694 | 1 | 2 | BTA | PRJLANR5L16BTA0005 | |
| 16060000095696 | L16/dossiers | 16 | 16060000095659 | 16060000095694 | 2 | 2 | TAP | PRJLANR5L16TAP0005 | |
| 16060000095708 | L16/dossiers | 16 | 16060000095659 | 16060000095707 | 1 | 2 | BTA | PRJLSNR5S379BTA0145 | |
| 16060000095721 | L16/dossiers | 16 | 16060000095659 | 16060000095720 | 1 | 2 | BTA | PRJLSNR5S379BTA0148 | |
| 16060000095725 | L16/dossiers | 16 | 16060000095659 | 16060000095724 | 1 | 2 | BTA | PRJLANR5L16BTA0016 | |
| 16060000095726 | L16/dossiers | 16 | 16060000095659 | 16060000095724 | 2 | 2 | TAP | PRJLANR5L16TAP0016 | |
| 16060000095763 | L16/dossiers | 16 | 16060000095734 | 16060000095762 | 1 | 2 | BTA | PRJLANR5L16BTA0009 | |
| 16060000095774 | L16/dossiers | 16 | 16060000095734 | 16060000095773 | 1 | 2 | BTA | PRJLSNR5S399BTA0012 | |
| 16060000095897 | L16/dossiers | 16 | 16060000095851 | 16060000095896 | 1 | 2 | BTA | PRJLANR5L16BTA0049 | |
| 16060000095908 | L16/dossiers | 16 | 16060000095851 | 16060000095907 | 1 | 2 | BTA | PRJLSNR5S399BTA0059 | |
| 16060000095932 | L16/dossiers | 16 | 16060000095918 | 16060000095931 | 1 | 2 | BTA | PRJLSNR5S379BTA0137 | |
| 16060000095950 | L16/dossiers | 16 | 16060000095918 | 16060000095949 | 1 | 2 | BTA | PRJLANR5L16BTA0011 | |
| 16060000096342 | L16/dossiers | 16 | 16060000096091 | 16060000096341 | 1 | 2 | BTA | PRJLANR5L16BTA0026 | |
| 16060000096343 | L16/dossiers | 16 | 16060000096091 | 16060000096341 | 2 | 2 | TAP | PRJLANR5L16TAP0026 | |
| 16060000096402 | L16/dossiers | 16 | 16060000096091 | 16060000096401 | 1 | 2 | BTA | PRJLSNR5S399BTA0030 | |
| 16060000096432 | L16/dossiers | 16 | 16060000096091 | 16060000096431 | 1 | 2 | BTA | PRJLANR5L16BTA0050 | |
| 16060000096433 | L16/dossiers | 16 | 16060000096091 | 16060000096431 | 2 | 2 | TAP | PRJLANR5L16TAP0050 | |
| 16060000096443 | L16/dossiers | 16 | 16060000096091 | 16060000096442 | 1 | 2 | BTA | PRJLSNR5S399BTA0039 | |
| 16060000096457 | L16/dossiers | 16 | 16060000096091 | 16060000096456 | 1 | 2 | BTA | PRJLANR5L16BTA0051 | |
| 16060000096458 | L16/dossiers | 16 | 16060000096091 | 16060000096456 | 2 | 2 | TAP | PRJLANR5L16TAP0051 | |
| 16060000096644 | L16/dossiers | 16 | 16060000096631 | 16060000096643 | 1 | 2 | BTA | PIONSNR5S399BTA0097 | |
| 16060000096919 | L16/dossiers | 16 | 16060000096906 | 16060000096918 | 1 | 2 | BTA | PIONSNR5S399BTA0085 | |
| 16060000097070 | L16/dossiers | 16 | 16060000097052 | 16060000097069 | 1 | 2 | BTA | PRJLANR5L16BTA0022 | |
| 16060000097081 | L16/dossiers | 16 | 16060000097052 | 16060000097080 | 1 | 2 | BTA | PRJLSNR5S399BTA0023 | |
| 16060000097384 | L16/dossiers | 16 | 16060000097371 | 16060000097383 | 1 | 2 | BTA | PIONSNR5S399BTA0072 | |
| 16060000097399 | L16/dossiers | 16 | 16060000097371 | 16060000097398 | 1 | 2 | BTA | PIONANR5L16BTA0134 | |
| 16060000097400 | L16/dossiers | 16 | 16060000097371 | 16060000097398 | 2 | 2 | TAP | PIONANR5L16TAP0134 |