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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000178278 | L15/dossiers | 15 | 15060000178176 | 15060000178277 | 1 | 2 | BTA | PRJLSNR5S379BTA0091 | |
| 15060000178394 | L15/dossiers | 15 | 15060000178387 | 15060000178393 | 1 | 2 | BTA | PNREANR5L15BTA0633 | |
| 15060000178402 | L15/dossiers | 15 | 15060000178395 | 15060000178401 | 1 | 2 | BTA | PNREANR5L15BTA0627 | |
| 15060000178436 | L15/dossiers | 15 | 15060000178411 | 15060000178435 | 1 | 2 | BTA | PRJLANR5L15BTA0773 | |
| 15060000178449 | L15/dossiers | 15 | 15060000178411 | 15060000178448 | 1 | 2 | BTA | PRJLSNR5S379BTA0095 | |
| 15060000178590 | L15/dossiers | 15 | 15060000178573 | 15060000178589 | 1 | 2 | BTA | PRJLANR5L15BTA0626 | |
| 15060000178591 | L15/dossiers | 15 | 15060000178573 | 15060000178589 | 2 | 2 | TAP | PRJLANR5L15TAP0626 | |
| 15060000178602 | L15/dossiers | 15 | 15060000178573 | 15060000178601 | 1 | 2 | BTA | PRJLSNR5S359BTA0132 | |
| 15060000178617 | L15/dossiers | 15 | 15060000178573 | 15060000178616 | 1 | 2 | BTA | PRJLANR5L15BTA0643 | |
| 15060000178618 | L15/dossiers | 15 | 15060000178573 | 15060000178616 | 2 | 2 | TAP | PRJLANR5L15TAP0643 | |
| 15060000178621 | L15/dossiers | 15 | 15060000178573 | 15060000178620 | 1 | 2 | BTA | PRJLSNR5S359BTA0136 | |
| 15060000178644 | L15/dossiers | 15 | 15060000178625 | 15060000178643 | 1 | 2 | BTA | PRJLANR5L15BTA0658 | |
| 15060000178655 | L15/dossiers | 15 | 15060000178625 | 15060000178654 | 1 | 2 | BTA | PRJLSNR5S379BTA0019 | |
| 15060000178684 | L15/dossiers | 15 | 15060000178675 | 15060000178683 | 1 | 2 | BTA | RIONANR5L15BTA0671 | |
| 15060000178741 | L15/dossiers | 15 | 15060000178728 | 15060000178740 | 1 | 2 | BTA | PIONSNR5S359BTA0151 | |
| 15060000178755 | L15/dossiers | 15 | 15060000178728 | 15060000178754 | 1 | 2 | BTA | PIONANR5L15BTA0672 | |
| 15060000178756 | L15/dossiers | 15 | 15060000178728 | 15060000178754 | 2 | 2 | TAP | PIONANR5L15TAP0672 | |
| 15060000178787 | L15/dossiers | 15 | 15060000178770 | 15060000178786 | 1 | 2 | BTA | PRJLANR5L15BTA0806 | |
| 15060000178814 | L15/dossiers | 15 | 15060000178800 | 15060000178813 | 1 | 2 | BTA | PRJLSNR5S359BTA0137 | |
| 15060000178947 | L15/dossiers | 15 | 15060000178921 | 15060000178946 | 1 | 2 | BTA | PRJLANR5L15BTA0644 | |
| 15060000178948 | L15/dossiers | 15 | 15060000178921 | 15060000178946 | 2 | 2 | TAP | PRJLANR5L15TAP0644 | |
| 15060000178959 | L15/dossiers | 15 | 15060000178921 | 15060000178958 | 1 | 2 | BTA | PRJLSNR5S379BTA0054 | |
| 15060000178974 | L15/dossiers | 15 | 15060000178921 | 15060000178973 | 1 | 2 | BTA | PRJLSNR5S379BTA0076 | |
| 15060000178978 | L15/dossiers | 15 | 15060000178921 | 15060000178977 | 1 | 2 | BTA | PRJLANR5L15BTA0764 | |
| 15060000178979 | L15/dossiers | 15 | 15060000178921 | 15060000178977 | 2 | 2 | TAP | PRJLANR5L15TAP0764 | |
| 15060000179001 | L15/dossiers | 15 | 15060000178983 | 15060000179000 | 1 | 2 | BTA | PRJLANR5L15BTA0659 | |
| 15060000179012 | L15/dossiers | 15 | 15060000178983 | 15060000179011 | 1 | 2 | BTA | PRJLSNR5S379BTA0018 | |
| 15060000179042 | L15/dossiers | 15 | 15060000179029 | 15060000179041 | 1 | 2 | BTA | PIONSNR5S379BTA0007 | |
| 15060000179074 | L15/dossiers | 15 | 15060000179066 | 15060000179073 | 1 | 2 | BTA | RIONANR5L15BTA0717 | |
| 15060000179124 | L15/dossiers | 15 | 15060000179109 | 15060000179123 | 1 | 2 | BTA | RIONANR5L15BTA0819 | |
| 15060000179610 | L15/dossiers | 15 | 15060000179340 | 15060000179609 | 1 | 2 | BTA | PRJLANR5L15BTA0687 | |
| 15060000179611 | L15/dossiers | 15 | 15060000179340 | 15060000179609 | 2 | 2 | TAP | PRJLANR5L15TAP0687 | |
| 15060000179671 | L15/dossiers | 15 | 15060000179340 | 15060000179670 | 1 | 2 | BTA | PRJLSNR5S379BTA0040 | |
| 15060000179692 | L15/dossiers | 15 | 15060000179340 | 15060000179691 | 1 | 2 | BTA | PRJLANR5L15BTA0730 | |
| 15060000179693 | L15/dossiers | 15 | 15060000179340 | 15060000179691 | 2 | 2 | TAP | PRJLANR5L15TAP0730 | |
| 15060000179703 | L15/dossiers | 15 | 15060000179340 | 15060000179702 | 1 | 2 | BTA | PRJLSNR5S379BTA0053 | |
| 15060000179714 | L15/dossiers | 15 | 15060000179340 | 15060000179713 | 1 | 2 | BTA | PRJLANR5L15BTA0737 | |
| 15060000179715 | L15/dossiers | 15 | 15060000179340 | 15060000179713 | 2 | 2 | TAP | PRJLANR5L15TAP0737 | |
| 15060000180145 | L15/dossiers | 15 | 15060000180127 | 15060000180144 | 1 | 2 | BTA | PRJLANR5L15BTA0729 | |
| 15060000180156 | L15/dossiers | 15 | 15060000180127 | 15060000180155 | 1 | 2 | BTA | PRJLSNR5S379BTA0081 | |
| 15060000180182 | L15/dossiers | 15 | 15060000180159 | 15060000180181 | 1 | 2 | BTA | PRJLANR5L15BTA0774 | |
| 15060000180224 | L15/dossiers | 15 | 15060000180211 | 15060000180223 | 1 | 2 | BTA | PRJLSNR5S379BTA0035 | |
| 15060000180239 | L15/dossiers | 15 | 15060000180211 | 15060000180238 | 1 | 2 | BTA | PRJLANR5L15BTA0767 | |
| 15060000180240 | L15/dossiers | 15 | 15060000180211 | 15060000180238 | 2 | 2 | TAP | PRJLANR5L15TAP0767 | |
| 15060000180250 | L15/dossiers | 15 | 15060000180211 | 15060000180249 | 1 | 2 | BTA | PRJLSNR5S379BTA0105 | |
| 15060000180276 | L15/dossiers | 15 | 15060000180253 | 15060000180275 | 1 | 2 | BTA | RIONANR5L15BTA0757 | |
| 15060000180287 | L15/dossiers | 15 | 15060000180277 | 15060000180286 | 1 | 2 | BTA | RIONANR5L15BTA0661 | |
| 15060000180373 | L15/dossiers | 15 | 15060000180354 | 15060000180372 | 1 | 2 | BTA | PRJLANR5L15BTA0771 | |
| 15060000180421 | L15/dossiers | 15 | 15060000180402 | 15060000180420 | 1 | 2 | BTA | PRJLANR5L15BTA0665 | |
| 15060000180422 | L15/dossiers | 15 | 15060000180402 | 15060000180420 | 2 | 2 | TAP | PRJLANR5L15TAP0665 |