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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000133093 | L14/dossiers | 14 | 14060000133061 | 14060000133092 | 1 | 2 | BTA | PRJLSNR5S279BTA0052 | |
| 14060000133107 | L14/dossiers | 14 | 14060000133061 | 14060000133106 | 1 | 2 | BTA | PRJLANR5L14BTA0893 | |
| 14060000133111 | L14/dossiers | 14 | 14060000133061 | 14060000133110 | 1 | 2 | BTA | PRJLSNR5S279BTA0080 | |
| 14060000133145 | L14/dossiers | 14 | 14060000133128 | 14060000133144 | 1 | 2 | BTA | PIONANR5L14BTA0485 | |
| 14060000133167 | L14/dossiers | 14 | 14060000133154 | 14060000133166 | 1 | 2 | BTA | PIONSNR5S199BTA0101 | |
| 14060000133262 | L14/dossiers | 14 | 14060000133248 | 14060000133261 | 1 | 2 | BTA | RIONANR5L14BTA0048 | |
| 14060000133303 | L14/dossiers | 14 | 14060000133288 | 14060000133302 | 1 | 2 | BTA | PIONANR5L14BTA0306 | |
| 14060000133340 | L14/dossiers | 14 | 14060000133323 | 14060000133339 | 1 | 2 | BTA | RIONANR5L14BTA0653 | |
| 14060000133356 | L14/dossiers | 14 | 14060000133341 | 14060000133355 | 1 | 2 | BTA | RIONANR5L14BTA0560 | |
| 14060000133407 | L14/dossiers | 14 | 14060000133381 | 14060000133406 | 1 | 2 | BTA | PRJLANR5L14BTA0678 | |
| 14060000133421 | L14/dossiers | 14 | 14060000133381 | 14060000133420 | 1 | 2 | BTA | PRJLSNR5S259BTA0113 | |
| 14060000133442 | L14/dossiers | 14 | 14060000133429 | 14060000133441 | 1 | 2 | BTA | PRJLSNR5S279BTA0046 | |
| 14060000133456 | L14/dossiers | 14 | 14060000133429 | 14060000133455 | 1 | 2 | BTA | PRJLANR5L14BTA0918 | |
| 14060000133520 | L14/dossiers | 14 | 14060000133504 | 14060000133519 | 1 | 2 | BTA | PRJLSNR5S239BTA0001 | |
| 14060000133535 | L14/dossiers | 14 | 14060000133504 | 14060000133534 | 1 | 2 | BTA | PRJLANR5L14BTA0427 | |
| 14060000133569 | L14/dossiers | 14 | 14060000133553 | 14060000133568 | 1 | 2 | BTA | PIONANR5L14BTA0692 | |
| 14060000133614 | L14/dossiers | 14 | 14060000133582 | 14060000133613 | 1 | 2 | BTA | PRJLANR5L14BTA0375 | |
| 14060000133632 | L14/dossiers | 14 | 14060000133582 | 14060000133631 | 1 | 2 | BTA | PRJLSNR5S219BTA0157 | |
| 14060000133653 | L14/dossiers | 14 | 14060000133582 | 14060000133652 | 1 | 2 | BTA | PRJLANR5L14BTA0384 | |
| 14060000133663 | L14/dossiers | 14 | 14060000133582 | 14060000133662 | 1 | 2 | BTA | PRJLSNR5S219BTA0163 | |
| 14060000133673 | L14/dossiers | 14 | 14060000133582 | 14060000133672 | 1 | 2 | BTA | PRJLANR5L14BTA0397 | |
| 14060000133709 | L14/dossiers | 14 | 14060000133690 | 14060000133708 | 1 | 2 | BTA | PRJLANR5L14BTA0868 | |
| 14060000133721 | L14/dossiers | 14 | 14060000133690 | 14060000133720 | 1 | 2 | BTA | PRJLSNR5S279BTA0064 | |
| 14060000133735 | L14/dossiers | 14 | 14060000133690 | 14060000133734 | 1 | 2 | BTA | PRJLANR5L14BTA0911 | |
| 14060000133739 | L14/dossiers | 14 | 14060000133690 | 14060000133738 | 1 | 2 | BTA | PRJLSNR5S279BTA0088 | |
| 14060000133800 | L14/dossiers | 14 | 14060000133784 | 14060000133799 | 1 | 2 | BTA | PRJLSNR5S259BTA0031 | |
| 14060000133821 | L14/dossiers | 14 | 14060000133784 | 14060000133820 | 1 | 2 | BTA | PRJLANR5L14BTA0737 | |
| 14060000133835 | L14/dossiers | 14 | 14060000133784 | 14060000133834 | 1 | 2 | BTA | PRJLSNR5S259BTA0170 | |
| 14060000133839 | L14/dossiers | 14 | 14060000133784 | 14060000133838 | 1 | 2 | BTA | PRJLANR5L14BTA0790 | |
| 14060000133884 | L14/dossiers | 14 | 14060000133865 | 14060000133883 | 1 | 2 | BTA | PRJLANR5L14BTA0582 | |
| 14060000133896 | L14/dossiers | 14 | 14060000133865 | 14060000133895 | 1 | 2 | BTA | PRJLSNR5S259BTA0024 | |
| 14060000133910 | L14/dossiers | 14 | 14060000133865 | 14060000133909 | 1 | 2 | BTA | PRJLANR5L14BTA0605 | |
| 14060000133914 | L14/dossiers | 14 | 14060000133865 | 14060000133913 | 1 | 2 | BTA | PRJLSNR5S259BTA0044 | |
| 14060000133934 | L14/dossiers | 14 | 14060000133918 | 14060000133933 | 1 | 2 | BTA | PIONANR5L14BTA0901 | |
| 14060000133982 | L14/dossiers | 14 | 14060000133967 | 14060000133981 | 1 | 2 | BTA | PIONANR5L14BTA0089 | |
| 14060000134038 | L14/dossiers | 14 | 14060000134024 | 14060000134037 | 1 | 2 | BTA | PRJLSNR5S239BTA0098 | |
| 14060000134053 | L14/dossiers | 14 | 14060000134024 | 14060000134052 | 1 | 2 | BTA | PRJLANR5L14BTA0520 | |
| 14060000134067 | L14/dossiers | 14 | 14060000134024 | 14060000134066 | 1 | 2 | BTA | PRJLANR5L14BTA0537 | |
| 14060000134071 | L14/dossiers | 14 | 14060000134024 | 14060000134070 | 1 | 2 | BTA | PRJLSNR5S239BTA0115 | |
| 14060000134092 | L14/dossiers | 14 | 14060000134075 | 14060000134091 | 1 | 2 | BTA | PIONANR5L14BTA0277 | |
| 14060000134104 | L14/dossiers | 14 | 14060000134075 | 14060000134103 | 1 | 2 | BTA | PIONSNR5S219BTA0112 | |
| 14060000134142 | L14/dossiers | 14 | 14060000134128 | 14060000134141 | 1 | 2 | BTA | PIONSNR5S279BTA0073 | |
| 14060000134157 | L14/dossiers | 14 | 14060000134128 | 14060000134156 | 1 | 2 | BTA | PIONANR5L14BTA0929 | |
| 14060000134282 | L14/dossiers | 14 | 14060000134239 | 14060000134281 | 1 | 2 | BTA | PRJLANR5L14BTA0450 | |
| 14060000134302 | L14/dossiers | 14 | 14060000134239 | 14060000134301 | 1 | 2 | BTA | PRJLSNR5S239BTA0107 | |
| 14060000134324 | L14/dossiers | 14 | 14060000134239 | 14060000134323 | 1 | 2 | BTA | PRJLANR5L14BTA0556 | |
| 14060000134334 | L14/dossiers | 14 | 14060000134239 | 14060000134333 | 1 | 2 | BTA | PRJLSNR5S239BTA0128 | |
| 14060000134344 | L14/dossiers | 14 | 14060000134239 | 14060000134343 | 1 | 2 | BTA | PRJLANR5L14BTA0566 | |
| 14060000134434 | L14/dossiers | 14 | 14060000134426 | 14060000134433 | 1 | 2 | BTA | PNREANR5L14BTA0355 | |
| 14060000134466 | L14/dossiers | 14 | 14060000134449 | 14060000134465 | 1 | 2 | BTA | PIONANR5L14BTA0805 |