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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000136435 | L15/dossiers | 15 | 15060000136388 | 15060000136434 | 1 | 2 | BTA | PRJLANR5L15BTA0104 | |
| 15060000136436 | L15/dossiers | 15 | 15060000136388 | 15060000136434 | 2 | 2 | TAP | PRJLANR5L15TAP0104 | |
| 15060000136460 | L15/dossiers | 15 | 15060000136388 | 15060000136459 | 1 | 2 | BTA | PRJLSNR5S299BTA0110 | |
| 15060000136473 | L15/dossiers | 15 | 15060000136388 | 15060000136472 | 1 | 2 | BTA | PRJLANR5L15BTA0144 | |
| 15060000136474 | L15/dossiers | 15 | 15060000136388 | 15060000136472 | 2 | 2 | TAP | PRJLANR5L15TAP0144 | |
| 15060000136478 | L15/dossiers | 15 | 15060000136388 | 15060000136477 | 1 | 2 | BTA | PRJLSNR5S299BTA0130 | |
| 15060000136502 | L15/dossiers | 15 | 15060000136489 | 15060000136501 | 1 | 2 | BTA | PIONSNR5S299BTA0068 | |
| 15060000136519 | L15/dossiers | 15 | 15060000136489 | 15060000136518 | 1 | 2 | BTA | PIONANR5L15BTA0106 | |
| 15060000136520 | L15/dossiers | 15 | 15060000136489 | 15060000136518 | 2 | 2 | TAP | PIONANR5L15TAP0106 | |
| 15060000136544 | L15/dossiers | 15 | 15060000136531 | 15060000136543 | 1 | 2 | BTA | PIONSNR5S299BTA0071 | |
| 15060000136573 | L15/dossiers | 15 | 15060000136557 | 15060000136572 | 1 | 2 | BTA | PIONANR5L15BTA0141 | |
| 15060000136574 | L15/dossiers | 15 | 15060000136557 | 15060000136572 | 2 | 2 | TAP | PIONANR5L15TAP0141 | |
| 15060000136726 | L15/dossiers | 15 | 15060000136698 | 15060000136725 | 1 | 2 | BTA | PIONANR5L15BTA0105 | |
| 15060000136727 | L15/dossiers | 15 | 15060000136698 | 15060000136725 | 2 | 2 | TAP | PIONANR5L15TAP0105 | |
| 15060000136739 | L15/dossiers | 15 | 15060000136698 | 15060000136738 | 1 | 2 | BTA | PIONSNR5S299BTA0095 | |
| 15060000136753 | L15/dossiers | 15 | 15060000136698 | 15060000136752 | 1 | 2 | BTA | PIONANR5L15BTA0125 | |
| 15060000136754 | L15/dossiers | 15 | 15060000136698 | 15060000136752 | 2 | 2 | TAP | PIONANR5L15TAP0125 | |
| 15060000136758 | L15/dossiers | 15 | 15060000136698 | 15060000136757 | 1 | 2 | BTA | PIONSNR5S299BTA0126 | |
| 15060000136790 | L15/dossiers | 15 | 15060000136777 | 15060000136789 | 1 | 2 | BTA | PIONSNR5S299BTA0072 | |
| 15060000136881 | L15/dossiers | 15 | 15060000136862 | 15060000136880 | 1 | 2 | BTA | PIONANR5L15BTA0107 | |
| 15060000137000 | L15/dossiers | 15 | 15060000136945 | 15060000136999 | 1 | 2 | BTA | PRJLANR5L15BTA0112 | |
| 15060000137001 | L15/dossiers | 15 | 15060000136945 | 15060000136999 | 2 | 2 | TAP | PRJLANR5L15TAP0112 | |
| 15060000137023 | L15/dossiers | 15 | 15060000136945 | 15060000137022 | 1 | 2 | BTA | PRJLSNR5S299BTA0128 | |
| 15060000137048 | L15/dossiers | 15 | 15060000136945 | 15060000137047 | 1 | 2 | BTA | PRJLANR5L15BTA0162 | |
| 15060000137049 | L15/dossiers | 15 | 15060000136945 | 15060000137047 | 2 | 2 | TAP | PRJLANR5L15TAP0162 | |
| 15060000137059 | L15/dossiers | 15 | 15060000136945 | 15060000137058 | 1 | 2 | BTA | PRJLSNR5S299BTA0157 | |
| 15060000137068 | L15/dossiers | 15 | 15060000136945 | 15060000137067 | 1 | 2 | BTA | PRJLANR5L15BTA0168 | |
| 15060000137069 | L15/dossiers | 15 | 15060000136945 | 15060000137067 | 2 | 2 | TAP | PRJLANR5L15TAP0168 | |
| 15060000137104 | L15/dossiers | 15 | 15060000137094 | 15060000137103 | 1 | 2 | BTA | RIONANR5L15BTA0108 | |
| 15060000137202 | L15/dossiers | 15 | 15060000137188 | 15060000137201 | 1 | 2 | BTA | PRJLSNR5S299BTA0091 | |
| 15060000137216 | L15/dossiers | 15 | 15060000137188 | 15060000137215 | 1 | 2 | BTA | PRJLANR5L15BTA0149 | |
| 15060000137217 | L15/dossiers | 15 | 15060000137188 | 15060000137215 | 2 | 2 | TAP | PRJLANR5L15TAP0149 | |
| 15060000137231 | L15/dossiers | 15 | 15060000137188 | 15060000137230 | 1 | 2 | BTA | PRJLSNR5S299BTA0137 | |
| 15060000137234 | L15/dossiers | 15 | 15060000137188 | 15060000137233 | 1 | 2 | BTA | PRJLANR5L15BTA0159 | |
| 15060000137235 | L15/dossiers | 15 | 15060000137188 | 15060000137233 | 2 | 2 | TAP | PRJLANR5L15TAP0159 | |
| 15060000137381 | L15/dossiers | 15 | 15060000137363 | 15060000137380 | 1 | 2 | BTA | PRJLANR5L15BTA0176 | |
| 15060000137393 | L15/dossiers | 15 | 15060000137363 | 15060000137392 | 1 | 2 | BTA | PRJLSNR5S319BTA0059 | |
| 15060000137424 | L15/dossiers | 15 | 15060000137411 | 15060000137423 | 1 | 2 | BTA | PIONSNR5S299BTA0084 | |
| 15060000137500 | L15/dossiers | 15 | 15060000137464 | 15060000137499 | 1 | 2 | BTA | PRJLANR5L15BTA0111 | |
| 15060000137501 | L15/dossiers | 15 | 15060000137464 | 15060000137499 | 2 | 2 | TAP | PRJLANR5L15TAP0111 | |
| 15060000137516 | L15/dossiers | 15 | 15060000137464 | 15060000137515 | 1 | 2 | BTA | PRJLSNR5S299BTA0113 | |
| 15060000137531 | L15/dossiers | 15 | 15060000137464 | 15060000137530 | 1 | 2 | BTA | PRJLANR5L15BTA0124 | |
| 15060000137532 | L15/dossiers | 15 | 15060000137464 | 15060000137530 | 2 | 2 | TAP | PRJLANR5L15TAP0124 | |
| 15060000137536 | L15/dossiers | 15 | 15060000137464 | 15060000137535 | 1 | 2 | BTA | PRJLSNR5S299BTA0123 | |
| 15060000137572 | L15/dossiers | 15 | 15060000137557 | 15060000137571 | 1 | 2 | BTA | PRJLSNR5S299BTA0129 | |
| 15060000137586 | L15/dossiers | 15 | 15060000137557 | 15060000137585 | 1 | 2 | BTA | PRJLANR5L15BTA0229 | |
| 15060000137613 | L15/dossiers | 15 | 15060000137592 | 15060000137612 | 1 | 2 | BTA | PIONANR5L15BTA0152 | |
| 15060000137614 | L15/dossiers | 15 | 15060000137592 | 15060000137612 | 2 | 2 | TAP | PIONANR5L15TAP0152 | |
| 15060000137626 | L15/dossiers | 15 | 15060000137592 | 15060000137625 | 1 | 2 | BTA | PIONSNR5S299BTA0153 | |
| 15060000137647 | L15/dossiers | 15 | 15060000137592 | 15060000137646 | 1 | 2 | BTA | PIONANR5L15BTA0181 |