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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000103024 | L14/dossiers | 14 | 14060000103009 | 14060000103023 | 1 | 2 | BTA | PRJLANR5L14BTA0167 | |
| 14060000103037 | L14/dossiers | 14 | 14060000103009 | 14060000103036 | 1 | 2 | BTA | PRJLSNR5S219BTA0142 | |
| 14060000103068 | L14/dossiers | 14 | 14060000103040 | 14060000103067 | 1 | 2 | BTA | PRJLANR5L14BTA0348 | |
| 14060000103081 | L14/dossiers | 14 | 14060000103040 | 14060000103080 | 1 | 2 | BTA | PRJLSNR5S219BTA0148 | |
| 14060000103095 | L14/dossiers | 14 | 14060000103040 | 14060000103094 | 1 | 2 | BTA | PRJLANR5L14BTA0382 | |
| 14060000103099 | L14/dossiers | 14 | 14060000103040 | 14060000103098 | 1 | 2 | BTA | PRJLSNR5S219BTA0158 | |
| 14060000103132 | L14/dossiers | 14 | 14060000103118 | 14060000103131 | 1 | 2 | BTA | RIONANR5L14BTA0661 | |
| 14060000103206 | L14/dossiers | 14 | 14060000103192 | 14060000103205 | 1 | 2 | BTA | RIONANR5L14BTA0370 | |
| 14060000103224 | L14/dossiers | 14 | 14060000103207 | 14060000103223 | 1 | 2 | BTA | PRJLANR5L14BTA0816 | |
| 14060000103236 | L14/dossiers | 14 | 14060000103207 | 14060000103235 | 1 | 2 | BTA | PRJLSNR5S279BTA0017 | |
| 14060000103257 | L14/dossiers | 14 | 14060000103242 | 14060000103256 | 1 | 2 | BTA | PRJLANR5L14BTA0035 | |
| 14060000103269 | L14/dossiers | 14 | 14060000103242 | 14060000103268 | 1 | 2 | BTA | PRJLSNR5S199BTA0095 | |
| 14060000103319 | L14/dossiers | 14 | 14060000103301 | 14060000103318 | 1 | 2 | BTA | PRJLANR5L14BTA0113 | |
| 14060000103331 | L14/dossiers | 14 | 14060000103301 | 14060000103330 | 1 | 2 | BTA | PRJLSNR5S199BTA0177 | |
| 14060000103395 | L14/dossiers | 14 | 14060000103358 | 14060000103394 | 1 | 2 | BTA | PRJLANR5L14BTA0511 | |
| 14060000103415 | L14/dossiers | 14 | 14060000103358 | 14060000103414 | 1 | 2 | BTA | PRJLSNR5S239BTA0111 | |
| 14060000103429 | L14/dossiers | 14 | 14060000103358 | 14060000103428 | 1 | 2 | BTA | PRJLSNR5S239BTA0117 | |
| 14060000103433 | L14/dossiers | 14 | 14060000103358 | 14060000103432 | 1 | 2 | BTA | PRJLANR5L14BTA0542 | |
| 14060000103514 | L14/dossiers | 14 | 14060000103463 | 14060000103513 | 1 | 2 | BTA | PRJLSNR5S239BTA0054 | |
| 14060000103587 | L14/dossiers | 14 | 14060000103463 | 14060000103586 | 1 | 2 | BTA | PRJLANR5L14BTA0482 | |
| 14060000103602 | L14/dossiers | 14 | 14060000103463 | 14060000103601 | 1 | 2 | BTA | PRJLSNR5S239BTA0108 | |
| 14060000103623 | L14/dossiers | 14 | 14060000103463 | 14060000103622 | 1 | 2 | BTA | PRJLANR5L14BTA0559 | |
| 14060000103638 | L14/dossiers | 14 | 14060000103463 | 14060000103637 | 1 | 2 | BTA | PRJLANR5L14BTA0568 | |
| 14060000103642 | L14/dossiers | 14 | 14060000103463 | 14060000103641 | 1 | 2 | BTA | PRJLSNR5S239BTA0135 | |
| 14060000103699 | L14/dossiers | 14 | 14060000103684 | 14060000103698 | 1 | 2 | BTA | RIONANR5L14BTA0055 | |
| 14060000103716 | L14/dossiers | 14 | 14060000103700 | 14060000103715 | 1 | 2 | BTA | PIONANR5L14BTA0754 | |
| 14060000103736 | L14/dossiers | 14 | 14060000103722 | 14060000103735 | 1 | 2 | BTA | PRJLSNR5S219BTA0095 | |
| 14060000103749 | L14/dossiers | 14 | 14060000103722 | 14060000103748 | 1 | 2 | BTA | PRJLANR5L14BTA0778 | |
| 14060000103787 | L14/dossiers | 14 | 14060000103773 | 14060000103786 | 1 | 2 | BTA | PRJLSNR5S239BTA0106 | |
| 14060000103802 | L14/dossiers | 14 | 14060000103773 | 14060000103801 | 1 | 2 | BTA | PRJLANR5L14BTA0555 | |
| 14060000103849 | L14/dossiers | 14 | 14060000103837 | 14060000103848 | 1 | 2 | BTA | RIONANR5L14BTA0933 | |
| 14060000103870 | L14/dossiers | 14 | 14060000103850 | 14060000103869 | 1 | 2 | BTA | PIONSNR5S239BTA0076 | |
| 14060000103894 | L14/dossiers | 14 | 14060000103850 | 14060000103893 | 1 | 2 | BTA | PIONANR5L14BTA0515 | |
| 14060000103905 | L14/dossiers | 14 | 14060000103850 | 14060000103904 | 1 | 2 | BTA | PIONSNR5S259BTA0009 | |
| 14060000103918 | L14/dossiers | 14 | 14060000103850 | 14060000103917 | 1 | 2 | BTA | PIONANR5L14BTA0608 | |
| 14060000103945 | L14/dossiers | 14 | 14060000103850 | 14060000103944 | 1 | 2 | BTA | PIONANR5L14BTA0666 | |
| 14060000103955 | L14/dossiers | 14 | 14060000103850 | 14060000103954 | 1 | 2 | BTA | PIONSNR5S259BTA0097 | |
| 14060000103964 | L14/dossiers | 14 | 14060000103850 | 14060000103963 | 1 | 2 | BTA | PIONANR5L14BTA0685 | |
| 14060000104011 | L14/dossiers | 14 | 14060000103998 | 14060000104010 | 1 | 2 | BTA | RIONANR5L14BTA0832 | |
| 14060000104053 | L14/dossiers | 14 | 14060000104039 | 14060000104052 | 1 | 2 | BTA | PRJLSNR5S259BTA0089 | |
| 14060000104074 | L14/dossiers | 14 | 14060000104039 | 14060000104073 | 1 | 2 | BTA | PRJLANR5L14BTA0770 | |
| 14060000104178 | L14/dossiers | 14 | 14060000104131 | 14060000104177 | 1 | 2 | BTA | PRJLANR5L14BTA0103 | |
| 14060000104203 | L14/dossiers | 14 | 14060000104131 | 14060000104202 | 1 | 2 | BTA | PRJLSNR5S199BTA0139 | |
| 14060000104217 | L14/dossiers | 14 | 14060000104131 | 14060000104216 | 1 | 2 | BTA | PRJLANR5L14BTA0123 | |
| 14060000104221 | L14/dossiers | 14 | 14060000104131 | 14060000104220 | 1 | 2 | BTA | PRJLSNR5S199BTA0142 | |
| 14060000104325 | L14/dossiers | 14 | 14060000104274 | 14060000104324 | 1 | 2 | BTA | PRJLANR5L14BTA0084 | |
| 14060000104349 | L14/dossiers | 14 | 14060000104274 | 14060000104348 | 1 | 2 | BTA | PRJLSNR5S199BTA0129 | |
| 14060000104367 | L14/dossiers | 14 | 14060000104274 | 14060000104366 | 1 | 2 | BTA | PRJLANR5L14BTA0120 | |
| 14060000104401 | L14/dossiers | 14 | 14060000104392 | 14060000104400 | 1 | 2 | BTA | RIONANR5L14BTA0204 | |
| 14060000104429 | L14/dossiers | 14 | 14060000104412 | 14060000104428 | 1 | 2 | BTA | PIONANR5L14BTA0526 |