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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000181867 | L15/dossiers | 15 | 15060000181817 | 15060000181865 | 2 | 2 | TAP | PRJLANR5L15TAP0792 | |
| 15060000182058 | L15/dossiers | 15 | 15060000182041 | 15060000182057 | 1 | 2 | BTA | PIONANR5L15BTA0712 | |
| 15060000182071 | L15/dossiers | 15 | 15060000182062 | 15060000182070 | 1 | 2 | BTA | RIONANR5L15BTA0700 | |
| 15060000182118 | L15/dossiers | 15 | 15060000182080 | 15060000182117 | 1 | 2 | BTA | PRJLANR5L15BTA0683 | |
| 15060000182119 | L15/dossiers | 15 | 15060000182080 | 15060000182117 | 2 | 2 | TAP | PRJLANR5L15TAP0683 | |
| 15060000182136 | L15/dossiers | 15 | 15060000182080 | 15060000182135 | 1 | 2 | BTA | PRJLSNR5S379BTA0034 | |
| 15060000182157 | L15/dossiers | 15 | 15060000182080 | 15060000182156 | 1 | 2 | BTA | PRJLANR5L15BTA0698 | |
| 15060000182158 | L15/dossiers | 15 | 15060000182080 | 15060000182156 | 2 | 2 | TAP | PRJLANR5L15TAP0698 | |
| 15060000182168 | L15/dossiers | 15 | 15060000182080 | 15060000182167 | 1 | 2 | BTA | PRJLSNR5S379BTA0045 | |
| 15060000182178 | L15/dossiers | 15 | 15060000182080 | 15060000182177 | 1 | 2 | BTA | PRJLANR5L15BTA0716 | |
| 15060000182179 | L15/dossiers | 15 | 15060000182080 | 15060000182177 | 2 | 2 | TAP | PRJLANR5L15TAP0716 | |
| 15060000182218 | L15/dossiers | 15 | 15060000182199 | 15060000182217 | 1 | 2 | BTA | PIONANR5L15BTA0704 | |
| 15060000182219 | L15/dossiers | 15 | 15060000182199 | 15060000182217 | 2 | 2 | TAP | PIONANR5L15TAP0704 | |
| 15060000182242 | L15/dossiers | 15 | 15060000182225 | 15060000182241 | 1 | 2 | BTA | PIONANR5L15BTA0705 | |
| 15060000182243 | L15/dossiers | 15 | 15060000182225 | 15060000182241 | 2 | 2 | TAP | PIONANR5L15TAP0705 | |
| 15060000182265 | L15/dossiers | 15 | 15060000182256 | 15060000182264 | 1 | 2 | BTA | RIONANR5L15BTA0702 | |
| 15060000182311 | L15/dossiers | 15 | 15060000182293 | 15060000182310 | 1 | 2 | BTA | PRJLANR5L15BTA0805 | |
| 15060000182325 | L15/dossiers | 15 | 15060000182317 | 15060000182324 | 1 | 2 | BTA | RIONANR5L15BTA0707 | |
| 15060000182347 | L15/dossiers | 15 | 15060000182326 | 15060000182346 | 1 | 2 | BTA | PRJLANR5L15BTA0682 | |
| 15060000182348 | L15/dossiers | 15 | 15060000182326 | 15060000182346 | 2 | 2 | TAP | PRJLANR5L15TAP0682 | |
| 15060000182359 | L15/dossiers | 15 | 15060000182326 | 15060000182358 | 1 | 2 | BTA | PRJLSNR5S379BTA0021 | |
| 15060000182381 | L15/dossiers | 15 | 15060000182326 | 15060000182380 | 1 | 2 | BTA | PRJLANR5L15BTA0684 | |
| 15060000182382 | L15/dossiers | 15 | 15060000182326 | 15060000182380 | 2 | 2 | TAP | PRJLANR5L15TAP0684 | |
| 15060000182391 | L15/dossiers | 15 | 15060000182326 | 15060000182390 | 1 | 2 | BTA | PRJLSNR5S379BTA0030 | |
| 15060000182400 | L15/dossiers | 15 | 15060000182326 | 15060000182399 | 1 | 2 | BTA | PRJLANR5L15BTA0685 | |
| 15060000182401 | L15/dossiers | 15 | 15060000182326 | 15060000182399 | 2 | 2 | TAP | PRJLANR5L15TAP0685 | |
| 15060000182451 | L15/dossiers | 15 | 15060000182416 | 15060000182450 | 1 | 2 | BTA | PIONSNR5S379BTA0066 | |
| 15060000182513 | L15/dossiers | 15 | 15060000182505 | 15060000182512 | 1 | 2 | BTA | RIONANR5L15BTA0708 | |
| 15060000182543 | L15/dossiers | 15 | 15060000182521 | 15060000182542 | 1 | 2 | BTA | PNREANR5L15BTA0726 | |
| 15060000182569 | L15/dossiers | 15 | 15060000182552 | 15060000182568 | 1 | 2 | BTA | PIONANR5L15BTA0723 | |
| 15060000182608 | L15/dossiers | 15 | 15060000182592 | 15060000182607 | 1 | 2 | BTA | PIONANR5L15BTA0721 | |
| 15060000182657 | L15/dossiers | 15 | 15060000182645 | 15060000182656 | 1 | 2 | BTA | PRJLSNR5S379BTA0055 | |
| 15060000182670 | L15/dossiers | 15 | 15060000182645 | 15060000182669 | 1 | 2 | BTA | PRJLANR5L15BTA0807 | |
| 15060000182704 | L15/dossiers | 15 | 15060000182687 | 15060000182703 | 1 | 2 | BTA | PIONANR5L15BTA0782 | |
| 15060000182705 | L15/dossiers | 15 | 15060000182687 | 15060000182703 | 2 | 2 | TAP | PIONANR5L15TAP0782 | |
| 15060000182769 | L15/dossiers | 15 | 15060000182757 | 15060000182768 | 1 | 2 | BTA | PIONSNR5S379BTA0067 | |
| 15060000182788 | L15/dossiers | 15 | 15060000182775 | 15060000182787 | 1 | 2 | BTA | PIONSNR5S379BTA0111 | |
| 15060000182826 | L15/dossiers | 15 | 15060000182818 | 15060000182825 | 1 | 2 | BTA | RIONANR5L15BTA0718 | |
| 15060000182993 | L15/dossiers | 15 | 15060000182979 | 15060000182992 | 1 | 2 | BTA | RIONANR5L15BTA0823 | |
| 15060000183091 | L15/dossiers | 15 | 15060000183074 | 15060000183090 | 1 | 2 | BTA | PIONANR5L15BTA0755 | |
| 15060000183092 | L15/dossiers | 15 | 15060000183074 | 15060000183090 | 2 | 2 | TAP | PIONANR5L15TAP0755 | |
| 15060000183104 | L15/dossiers | 15 | 15060000183074 | 15060000183103 | 1 | 2 | BTA | PIONSNR5S379BTA0094 | |
| 15060000183118 | L15/dossiers | 15 | 15060000183074 | 15060000183117 | 1 | 2 | BTA | PIONANR5L15BTA0811 | |
| 15060000183119 | L15/dossiers | 15 | 15060000183074 | 15060000183117 | 2 | 2 | TAP | PIONANR5L15TAP0811 | |
| 15060000183123 | L15/dossiers | 15 | 15060000183074 | 15060000183122 | 1 | 2 | BTA | PIONSNR5S379BTA0118 | |
| 15060000183158 | L15/dossiers | 15 | 15060000183149 | 15060000183157 | 1 | 2 | BTA | PNREANR5L15BTA0715 | |
| 15060000183180 | L15/dossiers | 15 | 15060000183163 | 15060000183179 | 1 | 2 | BTA | PIONANR5L15BTA0706 | |
| 15060000183181 | L15/dossiers | 15 | 15060000183163 | 15060000183179 | 2 | 2 | TAP | PIONANR5L15TAP0706 | |
| 15060000183192 | L15/dossiers | 15 | 15060000183163 | 15060000183191 | 1 | 2 | BTA | PIONSNR5S379BTA0083 | |
| 15060000183206 | L15/dossiers | 15 | 15060000183163 | 15060000183205 | 1 | 2 | BTA | PIONANR5L15BTA0801 |