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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000108901 | L14/dossiers | 14 | 14060000108892 | 14060000108900 | 1 | 2 | BTA | RIONANR5L14BTA0654 | |
| 14060000108956 | L14/dossiers | 14 | 14060000108942 | 14060000108955 | 1 | 2 | BTA | PRJLANR5L14BTA0481 | |
| 14060000108968 | L14/dossiers | 14 | 14060000108942 | 14060000108967 | 1 | 2 | BTA | PRJLSNR5S239BTA0096 | |
| 14060000109006 | L14/dossiers | 14 | 14060000108992 | 14060000109005 | 1 | 2 | BTA | PRJLSNR5S299BTA0045 | |
| 14060000109027 | L14/dossiers | 14 | 14060000109012 | 14060000109026 | 1 | 2 | BTA | PIONANR5L14BTA0658 | |
| 14060000109040 | L14/dossiers | 14 | 14060000109012 | 14060000109039 | 1 | 2 | BTA | PIONSNR5S259BTA0145 | |
| 14060000109110 | L14/dossiers | 14 | 14060000109096 | 14060000109109 | 1 | 2 | BTA | PRJLSNR5S279BTA0018 | |
| 14060000109124 | L14/dossiers | 14 | 14060000109096 | 14060000109123 | 1 | 2 | BTA | PRJLANR5L14BTA0874 | |
| 14060000109159 | L14/dossiers | 14 | 14060000109134 | 14060000109158 | 1 | 2 | BTA | PIONANR5L14BTA0645 | |
| 14060000109175 | L14/dossiers | 14 | 14060000109134 | 14060000109174 | 1 | 2 | BTA | PIONSNR5S259BTA0095 | |
| 14060000109200 | L14/dossiers | 14 | 14060000109134 | 14060000109199 | 1 | 2 | BTA | PIONANR5L14BTA0710 | |
| 14060000109210 | L14/dossiers | 14 | 14060000109134 | 14060000109209 | 1 | 2 | BTA | PIONSNR5S259BTA0116 | |
| 14060000109221 | L14/dossiers | 14 | 14060000109134 | 14060000109220 | 1 | 2 | BTA | PIONANR5L14BTA0713 | |
| 14060000109287 | L14/dossiers | 14 | 14060000109272 | 14060000109286 | 1 | 2 | BTA | PIONANR5L14BTA0219 | |
| 14060000109299 | L14/dossiers | 14 | 14060000109272 | 14060000109298 | 1 | 2 | BTA | PIONSNR5S219BTA0058 | |
| 14060000109310 | L14/dossiers | 14 | 14060000109272 | 14060000109309 | 1 | 2 | BTA | PIONANR5L14BTA0304 | |
| 14060000109320 | L14/dossiers | 14 | 14060000109272 | 14060000109319 | 1 | 2 | BTA | PIONSNR5S219BTA0146 | |
| 14060000109343 | L14/dossiers | 14 | 14060000109330 | 14060000109342 | 1 | 2 | BTA | PIONSNR5S239BTA0073 | |
| 14060000109359 | L14/dossiers | 14 | 14060000109330 | 14060000109358 | 1 | 2 | BTA | PIONANR5L14BTA0530 | |
| 14060000109369 | L14/dossiers | 14 | 14060000109330 | 14060000109368 | 1 | 2 | BTA | PIONSNR5S259BTA0019 | |
| 14060000109391 | L14/dossiers | 14 | 14060000109375 | 14060000109390 | 1 | 2 | BTA | PRJLANR5L14BTA0363 | |
| 14060000109403 | L14/dossiers | 14 | 14060000109375 | 14060000109402 | 1 | 2 | BTA | PRJLSNR5S239BTA0008 | |
| 14060000109473 | L14/dossiers | 14 | 14060000109457 | 14060000109472 | 1 | 2 | BTA | PRJLANR5L14BTA0551 | |
| 14060000109485 | L14/dossiers | 14 | 14060000109457 | 14060000109484 | 1 | 2 | BTA | PRJLSNR5S259BTA0004 | |
| 14060000109535 | L14/dossiers | 14 | 14060000109521 | 14060000109534 | 1 | 2 | BTA | PRJLSNR5S259BTA0062 | |
| 14060000109548 | L14/dossiers | 14 | 14060000109521 | 14060000109547 | 1 | 2 | BTA | PRJLANR5L14BTA0699 | |
| 14060000109603 | L14/dossiers | 14 | 14060000109589 | 14060000109602 | 1 | 2 | BTA | PIONSNR5S219BTA0138 | |
| 14060000109664 | L14/dossiers | 14 | 14060000109649 | 14060000109663 | 1 | 2 | BTA | RIONANR5L14BTA0750 | |
| 14060000109683 | L14/dossiers | 14 | 14060000109665 | 14060000109682 | 1 | 2 | BTA | PRJLANR5L14BTA0891 | |
| 14060000109695 | L14/dossiers | 14 | 14060000109665 | 14060000109694 | 1 | 2 | BTA | PRJLSNR5S279BTA0119 | |
| 14060000109728 | L14/dossiers | 14 | 14060000109712 | 14060000109727 | 1 | 2 | BTA | PRJLSNR5S219BTA0069 | |
| 14060000109744 | L14/dossiers | 14 | 14060000109712 | 14060000109743 | 1 | 2 | BTA | PRJLANR5L14BTA0324 | |
| 14060000109771 | L14/dossiers | 14 | 14060000109712 | 14060000109770 | 1 | 2 | BTA | PRJLANR5L14BTA0416 | |
| 14060000109781 | L14/dossiers | 14 | 14060000109712 | 14060000109780 | 1 | 2 | BTA | PRJLSNR5S239BTA0053 | |
| 14060000109792 | L14/dossiers | 14 | 14060000109712 | 14060000109791 | 1 | 2 | BTA | PRJLANR5L14BTA0467 | |
| 14060000109829 | L14/dossiers | 14 | 14060000109821 | 14060000109828 | 1 | 2 | BTA | RIONANR5L14BTA0439 | |
| 14060000109874 | L14/dossiers | 14 | 14060000109861 | 14060000109873 | 1 | 2 | BTA | PIONSNR5S199BTA0144 | |
| 14060000109937 | L14/dossiers | 14 | 14060000109923 | 14060000109936 | 1 | 2 | BTA | PRJLSNR5S219BTA0141 | |
| 14060000109950 | L14/dossiers | 14 | 14060000109923 | 14060000109949 | 1 | 2 | BTA | PRJLANR5L14BTA0424 | |
| 14060000109969 | L14/dossiers | 14 | 14060000109956 | 14060000109968 | 1 | 2 | BTA | PIONANR5L14BTA0632 | |
| 14060000109982 | L14/dossiers | 14 | 14060000109956 | 14060000109981 | 1 | 2 | BTA | PIONSNR5S259BTA0080 | |
| 14060000109998 | L14/dossiers | 14 | 14060000109985 | 14060000109997 | 1 | 2 | BTA | PIONSNR5S259BTA0064 | |
| 14060000110047 | L14/dossiers | 14 | 14060000110033 | 14060000110046 | 1 | 2 | BTA | PRJLSNR5S219BTA0024 | |
| 14060000110060 | L14/dossiers | 14 | 14060000110033 | 14060000110059 | 1 | 2 | BTA | PRJLANR5L14BTA0257 | |
| 14060000110122 | L14/dossiers | 14 | 14060000110080 | 14060000110121 | 1 | 2 | BTA | PRJLANR5L14BTA0223 | |
| 14060000110149 | L14/dossiers | 14 | 14060000110080 | 14060000110148 | 1 | 2 | BTA | PRJLSNR5S219BTA0028 | |
| 14060000110175 | L14/dossiers | 14 | 14060000110080 | 14060000110174 | 1 | 2 | BTA | PRJLANR5L14BTA0245 | |
| 14060000110185 | L14/dossiers | 14 | 14060000110080 | 14060000110184 | 1 | 2 | BTA | PRJLSNR5S219BTA0050 | |
| 14060000110196 | L14/dossiers | 14 | 14060000110080 | 14060000110195 | 1 | 2 | BTA | PRJLANR5L14BTA0265 | |
| 14060000110223 | L14/dossiers | 14 | 14060000110204 | 14060000110222 | 1 | 2 | BTA | PRJLANR5L14BTA0175 |