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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000124883 | L14/dossiers | 14 | 14060000124854 | 14060000124882 | 1 | 2 | BTA | PRJLANR5L14BTA0734 | |
| 14060000124963 | L14/dossiers | 14 | 14060000124950 | 14060000124962 | 1 | 2 | BTA | PIONSNR5S199BTA0124 | |
| 14060000125034 | L14/dossiers | 14 | 14060000125021 | 14060000125033 | 1 | 2 | BTA | PRJLSNR5S259BTA0109 | |
| 14060000125048 | L14/dossiers | 14 | 14060000125021 | 14060000125047 | 1 | 2 | BTA | PRJLANR5L14BTA0733 | |
| 14060000125086 | L14/dossiers | 14 | 14060000125065 | 14060000125085 | 1 | 2 | BTA | PRJLSNR5S199BTA0096 | |
| 14060000125110 | L14/dossiers | 14 | 14060000125065 | 14060000125109 | 1 | 2 | BTA | PRJLANR5L14BTA0117 | |
| 14060000125124 | L14/dossiers | 14 | 14060000125065 | 14060000125123 | 1 | 2 | BTA | PRJLSNR5S199BTA0137 | |
| 14060000125128 | L14/dossiers | 14 | 14060000125065 | 14060000125127 | 1 | 2 | BTA | PRJLANR5L14BTA0124 | |
| 14060000125160 | L14/dossiers | 14 | 14060000125142 | 14060000125159 | 1 | 2 | BTA | PRJLANR5L14BTA0875 | |
| 14060000125172 | L14/dossiers | 14 | 14060000125142 | 14060000125171 | 1 | 2 | BTA | PRJLSNR5S279BTA0070 | |
| 14060000125191 | L14/dossiers | 14 | 14060000125175 | 14060000125190 | 1 | 2 | BTA | PIONANR5L14BTA0760 | |
| 14060000125212 | L14/dossiers | 14 | 14060000125197 | 14060000125211 | 1 | 2 | BTA | PIONANR5L14BTA0656 | |
| 14060000125252 | L14/dossiers | 14 | 14060000125235 | 14060000125251 | 1 | 2 | BTA | PIONANR5L14BTA0221 | |
| 14060000125318 | L14/dossiers | 14 | 14060000125303 | 14060000125317 | 1 | 2 | BTA | PRJLSNR5S279BTA0021 | |
| 14060000125337 | L14/dossiers | 14 | 14060000125303 | 14060000125336 | 1 | 2 | BTA | PRJLANR5L15BTA0051 | |
| 14060000125376 | L14/dossiers | 14 | 14060000125357 | 14060000125375 | 1 | 2 | BTA | RIONANR5L14BTA0156 | |
| 14060000125407 | L14/dossiers | 14 | 14060000125384 | 14060000125406 | 1 | 2 | BTA | PRJLANR5L14BTA0020 | |
| 14060000125425 | L14/dossiers | 14 | 14060000125384 | 14060000125424 | 1 | 2 | BTA | PRJLSNR5S199BTA0018 | |
| 14060000125439 | L14/dossiers | 14 | 14060000125384 | 14060000125438 | 1 | 2 | BTA | PRJLANR5L14BTA0031 | |
| 14060000125443 | L14/dossiers | 14 | 14060000125384 | 14060000125442 | 1 | 2 | BTA | PRJLSNR5S199BTA0035 | |
| 14060000125475 | L14/dossiers | 14 | 14060000125457 | 14060000125474 | 1 | 2 | BTA | PIONANR5L14BTA0252 | |
| 14060000125492 | L14/dossiers | 14 | 14060000125457 | 14060000125491 | 1 | 2 | BTA | PIONSNR5S239BTA0085 | |
| 14060000125504 | L14/dossiers | 14 | 14060000125457 | 14060000125503 | 1 | 2 | BTA | PIONANR5L14BTA0533 | |
| 14060000125514 | L14/dossiers | 14 | 14060000125457 | 14060000125513 | 1 | 2 | BTA | PIONSNR5S259BTA0014 | |
| 14060000125536 | L14/dossiers | 14 | 14060000125457 | 14060000125535 | 1 | 2 | BTA | PIONANR5L14BTA0673 | |
| 14060000125546 | L14/dossiers | 14 | 14060000125457 | 14060000125545 | 1 | 2 | BTA | PIONSNR5S259BTA0106 | |
| 14060000125557 | L14/dossiers | 14 | 14060000125457 | 14060000125556 | 1 | 2 | BTA | PIONANR5L14BTA0716 | |
| 14060000125580 | L14/dossiers | 14 | 14060000125567 | 14060000125579 | 1 | 2 | BTA | PIONSNR5S259BTA0105 | |
| 14060000125680 | L14/dossiers | 14 | 14060000125626 | 14060000125679 | 1 | 2 | BTA | PRJLANR5L14BTA0663 | |
| 14060000125717 | L14/dossiers | 14 | 14060000125626 | 14060000125716 | 1 | 2 | BTA | PRJLSNR5S259BTA0131 | |
| 14060000125731 | L14/dossiers | 14 | 14060000125626 | 14060000125730 | 1 | 2 | BTA | PRJLANR5L14BTA0802 | |
| 14060000125735 | L14/dossiers | 14 | 14060000125626 | 14060000125734 | 1 | 2 | BTA | PRJLSNR5S259BTA0185 | |
| 14060000125783 | L14/dossiers | 14 | 14060000125749 | 14060000125782 | 1 | 2 | BTA | PRJLANR5L14BTA0403 | |
| 14060000125808 | L14/dossiers | 14 | 14060000125749 | 14060000125807 | 1 | 2 | BTA | PRJLSNR5S239BTA0083 | |
| 14060000125828 | L14/dossiers | 14 | 14060000125749 | 14060000125827 | 1 | 2 | BTA | PRJLANR5L14BTA0581 | |
| 14060000125838 | L14/dossiers | 14 | 14060000125749 | 14060000125837 | 1 | 2 | BTA | PRJLSNR5S259BTA0027 | |
| 14060000125853 | L14/dossiers | 14 | 14060000125749 | 14060000125852 | 1 | 2 | BTA | PRJLANR5L14BTA0642 | |
| 14060000125857 | L14/dossiers | 14 | 14060000125749 | 14060000125856 | 1 | 2 | BTA | PRJLSNR5S259BTA0053 | |
| 14060000125884 | L14/dossiers | 14 | 14060000125871 | 14060000125883 | 1 | 2 | BTA | PIONSNR5S239BTA0026 | |
| 14060000125899 | L14/dossiers | 14 | 14060000125890 | 14060000125898 | 1 | 2 | BTA | RIONANR5L14BTA0344 | |
| 14060000126001 | L14/dossiers | 14 | 14060000125986 | 14060000126000 | 1 | 2 | BTA | PRJLSNR5S259BTA0111 | |
| 14060000126021 | L14/dossiers | 14 | 14060000125986 | 14060000126020 | 1 | 2 | BTA | PRJLANR5L14BTA0717 | |
| 14060000126073 | L14/dossiers | 14 | 14060000126052 | 14060000126072 | 1 | 2 | BTA | PRJLANR5L14BTA0413 | |
| 14060000126090 | L14/dossiers | 14 | 14060000126052 | 14060000126089 | 1 | 2 | BTA | PRJLSNR5S239BTA0023 | |
| 14060000126113 | L14/dossiers | 14 | 14060000126052 | 14060000126112 | 1 | 2 | BTA | PRJLANR5L14BTA0453 | |
| 14060000126123 | L14/dossiers | 14 | 14060000126052 | 14060000126122 | 1 | 2 | BTA | PRJLSNR5S239BTA0038 | |
| 14060000126134 | L14/dossiers | 14 | 14060000126052 | 14060000126133 | 1 | 2 | BTA | PRJLANR5L14BTA0461 | |
| 14060000126150 | L14/dossiers | 14 | 14060000126137 | 14060000126149 | 1 | 2 | BTA | PIONSNR5S259BTA0022 | |
| 14060000126188 | L14/dossiers | 14 | 14060000126171 | 14060000126187 | 1 | 2 | BTA | PIONANR5L14BTA0761 | |
| 14060000126277 | L14/dossiers | 14 | 14060000126250 | 14060000126276 | 1 | 2 | BTA | PRJLANR5L14BTA0161 |