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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000148118 | L15/dossiers | 15 | 15060000148086 | 15060000148116 | 2 | 2 | TAP | PIONANR5L15TAP0310 | |
| 15060000148130 | L15/dossiers | 15 | 15060000148086 | 15060000148129 | 1 | 2 | BTA | PIONSNR5S339BTA0036 | |
| 15060000148154 | L15/dossiers | 15 | 15060000148086 | 15060000148153 | 1 | 2 | BTA | PIONANR5L15BTA0388 | |
| 15060000148155 | L15/dossiers | 15 | 15060000148086 | 15060000148153 | 2 | 2 | TAP | PIONANR5L15TAP0388 | |
| 15060000148167 | L15/dossiers | 15 | 15060000148086 | 15060000148166 | 1 | 2 | BTA | PIONSNR5S339BTA0064 | |
| 15060000148176 | L15/dossiers | 15 | 15060000148086 | 15060000148175 | 1 | 2 | BTA | PIONANR5L15BTA0419 | |
| 15060000148177 | L15/dossiers | 15 | 15060000148086 | 15060000148175 | 2 | 2 | TAP | PIONANR5L15TAP0419 | |
| 15060000148200 | L15/dossiers | 15 | 15060000148183 | 15060000148199 | 1 | 2 | BTA | PIONANR5L15BTA0362 | |
| 15060000148201 | L15/dossiers | 15 | 15060000148183 | 15060000148199 | 2 | 2 | TAP | PIONANR5L15TAP0362 | |
| 15060000148213 | L15/dossiers | 15 | 15060000148183 | 15060000148212 | 1 | 2 | BTA | PIONSNR5S339BTA0073 | |
| 15060000148224 | L15/dossiers | 15 | 15060000148183 | 15060000148223 | 1 | 2 | BTA | PIONANR5L15BTA0423 | |
| 15060000148225 | L15/dossiers | 15 | 15060000148183 | 15060000148223 | 2 | 2 | TAP | PIONANR5L15TAP0423 | |
| 15060000148251 | L15/dossiers | 15 | 15060000148235 | 15060000148250 | 1 | 2 | BTA | PIONANR5L15BTA0396 | |
| 15060000148269 | L15/dossiers | 15 | 15060000148259 | 15060000148268 | 1 | 2 | BTA | RIONANR5L15BTA0272 | |
| 15060000148305 | L15/dossiers | 15 | 15060000148292 | 15060000148304 | 1 | 2 | BTA | PRJLSNR5S339BTA0053 | |
| 15060000148319 | L15/dossiers | 15 | 15060000148292 | 15060000148318 | 1 | 2 | BTA | PRJLANR5L15BTA0479 | |
| 15060000148352 | L15/dossiers | 15 | 15060000148336 | 15060000148351 | 1 | 2 | BTA | PIONANR5L15BTA0269 | |
| 15060000148353 | L15/dossiers | 15 | 15060000148336 | 15060000148351 | 2 | 2 | TAP | PIONANR5L15TAP0269 | |
| 15060000148427 | L15/dossiers | 15 | 15060000148409 | 15060000148426 | 1 | 2 | BTA | PIONANR5L15BTA0261 | |
| 15060000148428 | L15/dossiers | 15 | 15060000148409 | 15060000148426 | 2 | 2 | TAP | PIONANR5L15TAP0261 | |
| 15060000148440 | L15/dossiers | 15 | 15060000148409 | 15060000148439 | 1 | 2 | BTA | PIONSNR5S319BTA0129 | |
| 15060000148453 | L15/dossiers | 15 | 15060000148409 | 15060000148452 | 1 | 2 | BTA | PIONANR5L15BTA0332 | |
| 15060000148454 | L15/dossiers | 15 | 15060000148409 | 15060000148452 | 2 | 2 | TAP | PIONANR5L15TAP0332 | |
| 15060000148458 | L15/dossiers | 15 | 15060000148409 | 15060000148457 | 1 | 2 | BTA | PIONSNR5S339BTA0004 | |
| 15060000148520 | L15/dossiers | 15 | 15060000148481 | 15060000148519 | 1 | 2 | BTA | PRJLANR5L15BTA0279 | |
| 15060000148521 | L15/dossiers | 15 | 15060000148481 | 15060000148519 | 2 | 2 | TAP | PRJLANR5L15TAP0279 | |
| 15060000148539 | L15/dossiers | 15 | 15060000148481 | 15060000148538 | 1 | 2 | BTA | PRJLSNR5S319BTA0121 | |
| 15060000148553 | L15/dossiers | 15 | 15060000148481 | 15060000148552 | 1 | 2 | BTA | PRJLANR5L15BTA0321 | |
| 15060000148554 | L15/dossiers | 15 | 15060000148481 | 15060000148552 | 2 | 2 | TAP | PRJLANR5L15TAP0321 | |
| 15060000148558 | L15/dossiers | 15 | 15060000148481 | 15060000148557 | 1 | 2 | BTA | PRJLSNR5S319BTA0140 | |
| 15060000148660 | L15/dossiers | 15 | 15060000148646 | 15060000148659 | 1 | 2 | BTA | PRJLSNR5S319BTA0103 | |
| 15060000148674 | L15/dossiers | 15 | 15060000148646 | 15060000148673 | 1 | 2 | BTA | PRJLANR5L15BTA0381 | |
| 15060000148765 | L15/dossiers | 15 | 15060000148751 | 15060000148764 | 1 | 2 | BTA | PIONSNR5S319BTA0118 | |
| 15060000148781 | L15/dossiers | 15 | 15060000148751 | 15060000148780 | 1 | 2 | BTA | PIONANR5L15BTA0338 | |
| 15060000148782 | L15/dossiers | 15 | 15060000148751 | 15060000148780 | 2 | 2 | TAP | PIONANR5L15TAP0338 | |
| 15060000148792 | L15/dossiers | 15 | 15060000148751 | 15060000148791 | 1 | 2 | BTA | PIONSNR5S339BTA0016 | |
| 15060000148839 | L15/dossiers | 15 | 15060000148826 | 15060000148838 | 1 | 2 | BTA | PIONSNR5S319BTA0119 | |
| 15060000148855 | L15/dossiers | 15 | 15060000148826 | 15060000148854 | 1 | 2 | BTA | PIONANR5L15BTA0339 | |
| 15060000148856 | L15/dossiers | 15 | 15060000148826 | 15060000148854 | 2 | 2 | TAP | PIONANR5L15TAP0339 | |
| 15060000148866 | L15/dossiers | 15 | 15060000148826 | 15060000148865 | 1 | 2 | BTA | PIONSNR5S339BTA0017 | |
| 15060000148891 | L15/dossiers | 15 | 15060000148872 | 15060000148890 | 1 | 2 | BTA | RIONANR5L15BTA0280 | |
| 15060000149100 | L15/dossiers | 15 | 15060000149084 | 15060000149099 | 1 | 2 | BTA | PRJLSNR5S319BTA0106 | |
| 15060000149116 | L15/dossiers | 15 | 15060000149084 | 15060000149115 | 1 | 2 | BTA | PRJLANR5L15BTA0326 | |
| 15060000149117 | L15/dossiers | 15 | 15060000149084 | 15060000149115 | 2 | 2 | TAP | PRJLANR5L15TAP0326 | |
| 15060000149131 | L15/dossiers | 15 | 15060000149084 | 15060000149130 | 1 | 2 | BTA | PRJLSNR5S319BTA0147 | |
| 15060000149135 | L15/dossiers | 15 | 15060000149084 | 15060000149134 | 1 | 2 | BTA | PRJLANR5L15BTA0342 | |
| 15060000149136 | L15/dossiers | 15 | 15060000149084 | 15060000149134 | 2 | 2 | TAP | PRJLANR5L15TAP0342 | |
| 15060000149238 | L15/dossiers | 15 | 15060000149226 | 15060000149237 | 1 | 2 | BTA | PIONSNR5S319BTA0095 | |
| 15060000149257 | L15/dossiers | 15 | 15060000149244 | 15060000149256 | 1 | 2 | BTA | PIONSNR5S319BTA0098 | |
| 15060000149351 | L15/dossiers | 15 | 15060000149333 | 15060000149350 | 1 | 2 | BTA | PRJLANR5L15BTA0271 |