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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000137648 | L15/dossiers | 15 | 15060000137592 | 15060000137646 | 2 | 2 | TAP | PIONANR5L15TAP0181 | |
| 15060000137658 | L15/dossiers | 15 | 15060000137592 | 15060000137657 | 1 | 2 | BTA | PIONSNR5S319BTA0014 | |
| 15060000137667 | L15/dossiers | 15 | 15060000137592 | 15060000137666 | 1 | 2 | BTA | PIONANR5L15BTA0191 | |
| 15060000137668 | L15/dossiers | 15 | 15060000137592 | 15060000137666 | 2 | 2 | TAP | PIONANR5L15TAP0191 | |
| 15060000137847 | L15/dossiers | 15 | 15060000137820 | 15060000137846 | 1 | 2 | BTA | PIONANR5L15BTA0151 | |
| 15060000137848 | L15/dossiers | 15 | 15060000137820 | 15060000137846 | 2 | 2 | TAP | PIONANR5L15TAP0151 | |
| 15060000137865 | L15/dossiers | 15 | 15060000137820 | 15060000137864 | 1 | 2 | BTA | PIONSNR5S299BTA0152 | |
| 15060000137894 | L15/dossiers | 15 | 15060000137820 | 15060000137893 | 1 | 2 | BTA | PIONANR5L15BTA0180 | |
| 15060000137895 | L15/dossiers | 15 | 15060000137820 | 15060000137893 | 2 | 2 | TAP | PIONANR5L15TAP0180 | |
| 15060000137905 | L15/dossiers | 15 | 15060000137820 | 15060000137904 | 1 | 2 | BTA | PIONSNR5S319BTA0013 | |
| 15060000137914 | L15/dossiers | 15 | 15060000137820 | 15060000137913 | 1 | 2 | BTA | PIONANR5L15BTA0190 | |
| 15060000137915 | L15/dossiers | 15 | 15060000137820 | 15060000137913 | 2 | 2 | TAP | PIONANR5L15TAP0190 | |
| 15060000137988 | L15/dossiers | 15 | 15060000137964 | 15060000137987 | 1 | 2 | BTA | PRJLANR5L15BTA0115 | |
| 15060000137989 | L15/dossiers | 15 | 15060000137964 | 15060000137987 | 2 | 2 | TAP | PRJLANR5L15TAP0115 | |
| 15060000138002 | L15/dossiers | 15 | 15060000137964 | 15060000138001 | 1 | 2 | BTA | PRJLSNR5S299BTA0134 | |
| 15060000138016 | L15/dossiers | 15 | 15060000137964 | 15060000138015 | 1 | 2 | BTA | PRJLSNR5S299BTA0156 | |
| 15060000138020 | L15/dossiers | 15 | 15060000137964 | 15060000138019 | 1 | 2 | BTA | PRJLANR5L15BTA0169 | |
| 15060000138021 | L15/dossiers | 15 | 15060000137964 | 15060000138019 | 2 | 2 | TAP | PRJLANR5L15TAP0169 | |
| 15060000138043 | L15/dossiers | 15 | 15060000138025 | 15060000138042 | 1 | 2 | BTA | PIONANR5L15BTA0239 | |
| 15060000138080 | L15/dossiers | 15 | 15060000138066 | 15060000138079 | 1 | 2 | BTA | PIONSNR5S299BTA0086 | |
| 15060000138099 | L15/dossiers | 15 | 15060000138086 | 15060000138098 | 1 | 2 | BTA | PIONSNR5S299BTA0088 | |
| 15060000138118 | L15/dossiers | 15 | 15060000138105 | 15060000138117 | 1 | 2 | BTA | PIONSNR5S299BTA0090 | |
| 15060000138227 | L15/dossiers | 15 | 15060000138206 | 15060000138226 | 1 | 2 | BTA | PIONANR5L15BTA0254 | |
| 15060000138228 | L15/dossiers | 15 | 15060000138206 | 15060000138226 | 2 | 2 | TAP | PIONANR5L15TAP0254 | |
| 15060000138310 | L15/dossiers | 15 | 15060000138294 | 15060000138309 | 1 | 2 | BTA | PIONANR5L15BTA0120 | |
| 15060000138311 | L15/dossiers | 15 | 15060000138294 | 15060000138309 | 2 | 2 | TAP | PIONANR5L15TAP0120 | |
| 15060000138323 | L15/dossiers | 15 | 15060000138294 | 15060000138322 | 1 | 2 | BTA | PIONSNR5S299BTA0119 | |
| 15060000138337 | L15/dossiers | 15 | 15060000138294 | 15060000138336 | 1 | 2 | BTA | PIONANR5L15BTA0160 | |
| 15060000138338 | L15/dossiers | 15 | 15060000138294 | 15060000138336 | 2 | 2 | TAP | PIONANR5L15TAP0160 | |
| 15060000138342 | L15/dossiers | 15 | 15060000138294 | 15060000138341 | 1 | 2 | BTA | PIONSNR5S299BTA0150 | |
| 15060000138367 | L15/dossiers | 15 | 15060000138346 | 15060000138366 | 1 | 2 | BTA | PRJLSNR5S299BTA0133 | |
| 15060000138395 | L15/dossiers | 15 | 15060000138346 | 15060000138394 | 1 | 2 | BTA | PRJLANR5L15BTA0172 | |
| 15060000138396 | L15/dossiers | 15 | 15060000138346 | 15060000138394 | 2 | 2 | TAP | PRJLANR5L15TAP0172 | |
| 15060000138410 | L15/dossiers | 15 | 15060000138346 | 15060000138409 | 1 | 2 | BTA | PRJLSNR5S319BTA0003 | |
| 15060000138414 | L15/dossiers | 15 | 15060000138346 | 15060000138413 | 1 | 2 | BTA | PRJLANR5L15BTA0182 | |
| 15060000138415 | L15/dossiers | 15 | 15060000138346 | 15060000138413 | 2 | 2 | TAP | PRJLANR5L15TAP0182 | |
| 15060000138436 | L15/dossiers | 15 | 15060000138421 | 15060000138435 | 1 | 2 | BTA | PIONANR5L15BTA0118 | |
| 15060000138437 | L15/dossiers | 15 | 15060000138421 | 15060000138435 | 2 | 2 | TAP | PIONANR5L15TAP0118 | |
| 15060000138449 | L15/dossiers | 15 | 15060000138421 | 15060000138448 | 1 | 2 | BTA | PIONSNR5S319BTA0002 | |
| 15060000138469 | L15/dossiers | 15 | 15060000138452 | 15060000138468 | 1 | 2 | BTA | PIONANR5L15BTA0116 | |
| 15060000138470 | L15/dossiers | 15 | 15060000138452 | 15060000138468 | 2 | 2 | TAP | PIONANR5L15TAP0116 | |
| 15060000138482 | L15/dossiers | 15 | 15060000138452 | 15060000138481 | 1 | 2 | BTA | PIONSNR5S319BTA0072 | |
| 15060000138494 | L15/dossiers | 15 | 15060000138452 | 15060000138493 | 1 | 2 | BTA | PIONANR5L15BTA0263 | |
| 15060000138495 | L15/dossiers | 15 | 15060000138452 | 15060000138493 | 2 | 2 | TAP | PIONANR5L15TAP0263 | |
| 15060000138506 | L15/dossiers | 15 | 15060000138452 | 15060000138505 | 1 | 2 | BTA | PIONSNR5S359BTA0110 | |
| 15060000138517 | L15/dossiers | 15 | 15060000138452 | 15060000138516 | 1 | 2 | BTA | PIONANR5L15BTA0638 | |
| 15060000138518 | L15/dossiers | 15 | 15060000138452 | 15060000138516 | 2 | 2 | TAP | PIONANR5L15TAP0638 | |
| 15060000138619 | L15/dossiers | 15 | 15060000138542 | 15060000138618 | 1 | 2 | BTA | PRJLANR5L15BTA0123 | |
| 15060000138620 | L15/dossiers | 15 | 15060000138542 | 15060000138618 | 2 | 2 | TAP | PRJLANR5L15TAP0123 | |
| 15060000138654 | L15/dossiers | 15 | 15060000138542 | 15060000138653 | 1 | 2 | BTA | PRJLSNR5S299BTA0145 |