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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000105954 | L14/dossiers | 14 | 14060000105924 | 14060000105953 | 1 | 2 | BTA | PRJLSNR5S199BTA0175 | |
| 14060000105974 | L14/dossiers | 14 | 14060000105957 | 14060000105973 | 1 | 2 | BTA | PRJLANR5L14BTA0539 | |
| 14060000105986 | L14/dossiers | 14 | 14060000105957 | 14060000105985 | 1 | 2 | BTA | PRJLSNR5S239BTA0133 | |
| 14060000106010 | L14/dossiers | 14 | 14060000105996 | 14060000106009 | 1 | 2 | BTA | PRJLSNR5S199BTA0088 | |
| 14060000106023 | L14/dossiers | 14 | 14060000105996 | 14060000106022 | 1 | 2 | BTA | PRJLANR5L14BTA0360 | |
| 14060000106042 | L14/dossiers | 14 | 14060000106029 | 14060000106041 | 1 | 2 | BTA | PIONSNR5S239BTA0055 | |
| 14060000106057 | L14/dossiers | 14 | 14060000106029 | 14060000106056 | 1 | 2 | BTA | PIONANR5L14BTA0532 | |
| 14060000106067 | L14/dossiers | 14 | 14060000106029 | 14060000106066 | 1 | 2 | BTA | PIONSNR5S259BTA0020 | |
| 14060000106134 | L14/dossiers | 14 | 14060000106119 | 14060000106133 | 1 | 2 | BTA | PRJLSNR5S239BTA0015 | |
| 14060000106149 | L14/dossiers | 14 | 14060000106119 | 14060000106148 | 1 | 2 | BTA | PRJLANR5L14BTA0544 | |
| 14060000106176 | L14/dossiers | 14 | 14060000106119 | 14060000106175 | 1 | 2 | BTA | PRJLANR5L14BTA0573 | |
| 14060000106186 | L14/dossiers | 14 | 14060000106119 | 14060000106185 | 1 | 2 | BTA | PRJLSNR5S239BTA0141 | |
| 14060000106196 | L14/dossiers | 14 | 14060000106119 | 14060000106195 | 1 | 2 | BTA | PRJLANR5L14BTA0579 | |
| 14060000106254 | L14/dossiers | 14 | 14060000106240 | 14060000106253 | 1 | 2 | BTA | RIONANR5L14BTA0810 | |
| 14060000106268 | L14/dossiers | 14 | 14060000106255 | 14060000106267 | 1 | 2 | BTA | PIONSNR5S259BTA0039 | |
| 14060000106282 | L14/dossiers | 14 | 14060000106255 | 14060000106281 | 1 | 2 | BTA | PIONANR5L14BTA0718 | |
| 14060000106366 | L14/dossiers | 14 | 14060000106348 | 14060000106365 | 1 | 2 | BTA | PIONANR5L14BTA0024 | |
| 14060000106381 | L14/dossiers | 14 | 14060000106367 | 14060000106380 | 1 | 2 | BTA | PRJLSNR5S239BTA0020 | |
| 14060000106394 | L14/dossiers | 14 | 14060000106367 | 14060000106393 | 1 | 2 | BTA | PRJLANR5L14BTA0535 | |
| 14060000106425 | L14/dossiers | 14 | 14060000106411 | 14060000106424 | 1 | 2 | BTA | PRJLSNR5S259BTA0010 | |
| 14060000106439 | L14/dossiers | 14 | 14060000106411 | 14060000106438 | 1 | 2 | BTA | PRJLANR5L14BTA0700 | |
| 14060000106613 | L14/dossiers | 14 | 14060000106598 | 14060000106612 | 1 | 2 | BTA | PRJLANR5L14BTA0423 | |
| 14060000106625 | L14/dossiers | 14 | 14060000106598 | 14060000106624 | 1 | 2 | BTA | PRJLSNR5S239BTA0052 | |
| 14060000106676 | L14/dossiers | 14 | 14060000106662 | 14060000106675 | 1 | 2 | BTA | PRJLSNR5S279BTA0022 | |
| 14060000106695 | L14/dossiers | 14 | 14060000106662 | 14060000106694 | 1 | 2 | BTA | PRJLANR5L15BTA0052 | |
| 14060000106711 | L14/dossiers | 14 | 14060000106698 | 14060000106710 | 1 | 2 | BTA | PRJLSNR5S279BTA0124 | |
| 14060000106725 | L14/dossiers | 14 | 14060000106698 | 14060000106724 | 1 | 2 | BTA | PRJLANR5L15BTA0020 | |
| 14060000106750 | L14/dossiers | 14 | 14060000106735 | 14060000106749 | 1 | 2 | BTA | RIONANR5L14BTA0404 | |
| 14060000106783 | L14/dossiers | 14 | 14060000106764 | 14060000106782 | 1 | 2 | BTA | PRJLANR5L14BTA0407 | |
| 14060000106795 | L14/dossiers | 14 | 14060000106764 | 14060000106794 | 1 | 2 | BTA | PRJLSNR5S239BTA0004 | |
| 14060000106809 | L14/dossiers | 14 | 14060000106764 | 14060000106808 | 1 | 2 | BTA | PRJLANR5L14BTA0454 | |
| 14060000106813 | L14/dossiers | 14 | 14060000106764 | 14060000106812 | 1 | 2 | BTA | PRJLSNR5S239BTA0039 | |
| 14060000106830 | L14/dossiers | 14 | 14060000106817 | 14060000106829 | 1 | 2 | BTA | PIONSNR5S199BTA0149 | |
| 14060000106843 | L14/dossiers | 14 | 14060000106817 | 14060000106842 | 1 | 2 | BTA | PIONANR5L14BTA0218 | |
| 14060000106889 | L14/dossiers | 14 | 14060000106874 | 14060000106888 | 1 | 2 | BTA | PIONSNR5S239BTA0077 | |
| 14060000106923 | L14/dossiers | 14 | 14060000106910 | 14060000106922 | 1 | 2 | BTA | PRJLSNR5S299BTA0038 | |
| 14060000106965 | L14/dossiers | 14 | 14060000106949 | 14060000106964 | 1 | 2 | BTA | PIONANR5L14BTA0335 | |
| 14060000106977 | L14/dossiers | 14 | 14060000106949 | 14060000106976 | 1 | 2 | BTA | PIONSNR5S219BTA0127 | |
| 14060000106989 | L14/dossiers | 14 | 14060000106949 | 14060000106988 | 1 | 2 | BTA | PIONANR5L14BTA0389 | |
| 14060000107037 | L14/dossiers | 14 | 14060000106995 | 14060000107036 | 1 | 2 | BTA | PRJLANR5L14BTA0142 | |
| 14060000107061 | L14/dossiers | 14 | 14060000106995 | 14060000107060 | 1 | 2 | BTA | PRJLSNR5S199BTA0170 | |
| 14060000107075 | L14/dossiers | 14 | 14060000106995 | 14060000107074 | 1 | 2 | BTA | PRJLSNR5S199BTA0185 | |
| 14060000107079 | L14/dossiers | 14 | 14060000106995 | 14060000107078 | 1 | 2 | BTA | PRJLANR5L14BTA0180 | |
| 14060000107205 | L14/dossiers | 14 | 14060000107177 | 14060000107204 | 1 | 2 | BTA | PIONANR5L14BTA0359 | |
| 14060000107218 | L14/dossiers | 14 | 14060000107177 | 14060000107217 | 1 | 2 | BTA | PIONSNR5S219BTA0153 | |
| 14060000107233 | L14/dossiers | 14 | 14060000107177 | 14060000107232 | 1 | 2 | BTA | PIONANR5L14BTA0386 | |
| 14060000107237 | L14/dossiers | 14 | 14060000107177 | 14060000107236 | 1 | 2 | BTA | PIONSNR5S219BTA0167 | |
| 14060000107299 | L14/dossiers | 14 | 14060000107285 | 14060000107298 | 1 | 2 | BTA | PIONSNR5S199BTA0097 | |
| 14060000107311 | L14/dossiers | 14 | 14060000107285 | 14060000107310 | 1 | 2 | BTA | PIONANR5L14BTA0116 | |
| 14060000107338 | L14/dossiers | 14 | 14060000107321 | 14060000107337 | 1 | 2 | BTA | PRJLANR5L14BTA0005 |